BILLTO

Bill To

The Bill To file contains alternate billing address information for a customer.

REFERENCED BY
AC56.1 AC560 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
AP510 API1.1 API2.1 AR10.1 AR11.1 AR12.1
AR12.2 AR13.1 AR13.2 AR210 AR550 ARLL.1
BR00.1 BR00.2 BR02.3 BR11.1 BR120 BR121
BR122 BR123 BR140 BR151 BR152 BR156
BR17.1 BR19.1 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.7 BR21.1 BR211 BR217 BR420
BR46.1 BR46.2 BR46.4 BR521 BR55.1 BRIP.1
CB06.2 CB191 CX05.1 CX05.2 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CX805 CXCP.1 DR100 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.1
TX140 WH110 WH120 WH130 WH132 WH190
WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6
WH20.7 WH21.1 WH21.2 WH21.3 WH21.4 WH210
WH22.1 WH222 WH25.1 WH25.2 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830


UPDATED BY
AR09.4 AR09.1 AR301 AR501

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABS-CUST-GROUP
Element: Cust Group
Alpha 5
Customer group. Used to identify a group of customer associated with one or more companies.
AR09.4 AR301
AR501
ABS-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Customer number.
AR09.4 AR301
AR501
ABS-BILL-TO
Element: Bill To
Numeric 4
Bill to number.
AR09.4 AR301
AR501
ABS-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
AR09.4 AR301
AR501
ABS-CONTACT
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
ABS-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.4 AR301
AR501
ABS-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.4 AR301
AR501
ABS-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.4 AR301
AR501
ABS-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.4 AR301
AR501
ABS-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
AR09.4 AR301
AR501
ABS-STATE
Element: State
Alpha 2
This field contains the two-character state code of the address.
AR09.4 AR301
AR501
ABS-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the address.
AR09.4 AR301
AR501
ABS-COUNTRY
Element: Country
Alpha 30 (Lower Case)
This field contains the country of the address, or it can be used for additional information such as an attention name.
AR09.4 AR301
AR501
ABS-COUNTY
Element: County
Alpha 25 (Lower Case)
This field contains the county of the address, or it can be used for additional information such as an attention name.
AR09.4 AR301
AR501
ABS-DEFAULT-BILL
Element: Default Bill To
Alpha 1
Indicates if the address is the default billing address for the customer. Valid values are:
Y = Yes
N = No
AR09.4 AR301
AR501
ABS-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AR09.4 AR301
AR501
ABS-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
AR09.4 AR301
AR501
ABS-E-MAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
Email address of related Bill To.
AR09.4 AR301
AR501


BILLTO FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABSSET1 CUST-GROUP
CUSTOMER
BILL-TO
...
AC56.1 AC560
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 AR09.1
AR09.4 AR10.1
AR11.1 AR12.1
AR12.2 AR13.1
AR13.2 AR210
ABSSET2 CUST-GROUP
CUSTOMER
BILL-TO
Subset
WhereDEFAULT-BILL ="Y"
AR09.1 WH20.2
WH20.7


BILLTO FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Billtobod BILLTOBOD Not Required, Delete Cascades
ABS-CUST-GROUP->YCK-CUST-GROUP
ABS-CUSTOMER->YCK-CUSTOMER
ABS-BILL-TO->YCK-BILL-TO


File created: Thu Jun 09 02:09:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.