ACBILLTOX

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).
UPDATED BY
BR00.1 BR00.2 BR02.3 BR120 BR121 BR122
BR123 BR140 BR151 BR152 BR156 BR17.1
BR19.1 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR21.1 BR217 BR420 BR46.1 BR46.2 BR46.4
BR521 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABO-COMPANY
Element: Company
Numeric 4
The company number represents an established AR company. The company for the bill to group is maintained on the Bill to Group (BR17.1).
BR17.1
ABO-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer. The customer for the bill To group is maintained on Bill To Group (BR17.1).
BR17.1
ABO-BILL-TO-GRP
Element: Bill To Grp
Numeric 4
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)
BR17.1
ABO-BILL-TO
Element: Bill To
Numeric 4
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).
BR17.1
ABO-PRIMARY-FLAG
Element: Primary Flag
Alpha 1
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)
BR17.1


ACBILLTOX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABOSET1 COMPANY
CUSTOMER
BILL-TO-GRP
BILL-TO
BR17.1 BR217
BRIP.1
ABOSET2 COMPANY
CUSTOMER
BILL-TO-GRP
BILL-TO
Subset
WherePRIMARY-FLAG ="Y"
BR00.1 BR00.2
BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 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
NAME
RELATED 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


File created: Thu Jun 09 11:10:47 2016

Home
Contact Us



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