BILLTO FILE Bill To Bill To REFERENCED BY AC15.2 AR155 AR42.2 AR42.6 AR502 AR560 BL120 BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL80.1 BL820 BL92.1 BL940 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810 OE830 OE85.1 OE920 OE950 PBIP.1 WH20.2 WH20.7 UPDATED BY AR09.4 AR09.1 AR301 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ABS-CUST-GROUP Alpha 5 AR09.4 Customer Group Customer group. Used to identify a group of customer associated with one or more companies. ABS-CUSTOMER Alpha 9 (Right Justified) AR09.4 Customer Number Customer number. ABS-BILL-TO Numeric 4 AR09.4 Bill To Bill to number. ABS-NAME Alpha 30 (Lower Case) AR09.4 Name Contains the company description. ABS-ADDR1 Alpha 30 (Lower Case) AR09.4 Address 1 This field contains the first line of address information. ABS-ADDR2 Alpha 30 (Lower Case) AR09.4 Address 2 This field contains the second line of address information. ABS-ADDR3 Alpha 30 (Lower Case) AR09.4 Address 3 This field contains the third line of address information. ABS-ADDR4 Alpha 30 (Lower Case) AR09.4 Address 4 This field contains the fourth line of address information. ABS-CITY Alpha 18 (Lower Case) AR09.4 City This field contains the city of the address. ABS-STATE Alpha 2 AR09.4 State or Province This field contains the two-character state code of the address. ABS-ZIP Alpha 10 AR09.4 Postal Code This field contains the postal code of the address. ABS-COUNTRY Alpha 30 (Lower Case) AR09.4 Country or Other This field contains the country of the address, or it can be used for additional information such as an attention name. ABS-COUNTY Alpha 25 AR09.4 County For use in a future release. ABS-DEFAULT-BILL Alpha 1 AR09.4 Default Bill To Indicates if the address is the default billing address for the customer. Valid values are: Y = Default bill to Blank = Not default bill to ABS-COUNTRY-CODE Alpha 2 AR09.4 Country Code The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). ABS-REGION Alpha 2 AR09.4 Region Code The region code, if applicable for the country. Used only by Intrastat. Must be defined in IN02.1 (Region Maintenance). BILLTO FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ABSSET1 CUST-GROUP This path is used for record uniqueness. AC15.2 AR09.1 CUSTOMER AR09.4 AR155 BILL-TO AR301 AR42.2 AR42.6 AR502 AR560 BL120 BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL80.1 BL820 BL92.1 BL940 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ABSSET2 CUST-GROUP This path is used to select the default OE10.1 OE10.2 CUSTOMER bill to record. OE10.3 OE10.4 BILL-TO Subset OE10.5 OE10.6 Where DEFAULT-BILL = "Y" OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.2 WH20.7 |