|
|
ACBILLTOX FILE
Activity Bill To Detail
This file maintains the bill-to group detail for customer invoicing. A bill
to group can be assigned to each customer invoice option. A bill to group is
maintained via BR17 (Bill-to Group). The ACBILLTO file maintains the AR
company, customer, group name and description. The ACBILLTOX file maintains
the bill to's associated with the group. A bill-to group is made up of
multiple bill-to addresses, which are defined in the AR Bill-To from
(AR09.4). A bill-to group listing can be printed by running BR217 (Bill-To
Group Listing).
REFERENCED BY
BR217 BRIP.1 BR00.1 BR00.2 BR02.3 BR120
BR121 BR122 BR140 BR19.1 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR21.1 BR420 BR46.1
BR46.2 BR46.4 BR521
UPDATED BY
BR17.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABO-COMPANY Numeric 4 BR17.1
Element: Company The company number represents an
established AR company. The company for
the bill to group is maintained on the
Bill to Group (BR17.1).
ABO-CUSTOMER Alpha 9 (Right Justified) BR17.1
Element: Customer NumbeThis field contains the number that
represents a customer. The customer for
the bill To group is maintained on Bill
To Group (BR17.1).
ABO-BILL-TO-GRP Numeric 4 BR17.1
Element: Bill To Grp Used to identify a group of AR bill-to
addresses used for customer invoicing in
the BR system. The bill to group is
maintained on Bill To Group (BR17.1)
ABO-BILL-TO Numeric 4 BR17.1
Element: Bill To This field contains the mailing address
for the invoice. Bill to addresses are
maintained in the Accounts Receviable
Bill To (AR09.4) and added in Bill To
Group (BR17.1).
ABO-PRIMARY-FLAG Alpha 1 BR17.1
Element: Primary Flag This flag identifies which bill-to
address within a bill-to group should be
used for invoicing and to send to the
subsystems. This flag is maintained in
Bill To Group (BR17.1)
ACBILLTOX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABOSET1 COMPANY BR17.1 BR217
CUSTOMER BRIP.1
BILL-TO-GRP
BILL-TO
ABOSET2 COMPANY Subset BR00.1 BR00.2
CUSTOMER Where PRIMARY-FLAG = "Y" BR02.3 BR120
BILL-TO-GRP BR121 BR122
BILL-TO BR140 BR17.1
BR19.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR21.1 BR420
BR46.1 BR46.2
BR46.4 BR521
ACBILLTOX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbillto ACBILLTO Required
ABO-COMPANY -> ABL-COMPANY
ABO-CUSTOMER -> ABL-CUSTOMER
ABO-BILL-TO-GRP -> ABL-BILL-TO-GRP
Arcomp ARCOMP Required
ABO-COMPANY -> ACO-COMPANY
Billto BILLTO Required
ACO-CUST-GROUP -> ABS-CUST-GROUP
ABO-CUSTOMER -> ABS-CUSTOMER
ABO-BILL-TO -> ABS-BILL-TO
|
