|
NATACCT FILE
AR National Account
The AR National Account file contains national account records that identify
payment relationships between customers. Invoiced customers must be in the
same customer group as the national account customer. National account
relationships are alo used in Aging reports and customer Statements.
REFERENCED BY
AR130 AR131 AR150 AR160 AR161 AR170
AR21.5 AR21.1 AR21.2 AR21.3 AR21.4 AR212
AR251 AR255 AR275 AR30.2 AR30.7 AR30.1
AR30.8 AR33.1 AR33.3 AR33.5 AR33.6 AR34.1
AR34.3 AR42.2 AR42.6 AR42.1 AR42.7 AR44.1
AR44.3 AR50.1 AR504 AR560 AR70.2 AR72.1
AR75.1 AR90.1 ARLL.1 DT150 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 API1.1 AR115
AR124 AR129 AR13.1 AR13.2 AR135 AR137
AR180 AR190 AR20.1 AR219 AR24.1 AR28.1
AR29.1 AR29.2 AR29.3 AR32.1 AR35.1 AR35.2
AR37.1 AR37.2 AR37.3 AR37.4 AR37.5 AR37.6
AR37.7 AR38.1 AR38.2 AR38.3 AR39.1 AR39.2
AR43.1 AR48.1 AR48.3 AR502 AR505 AR510
AR570 AR575 AR580 AR80.1 AR80.2 AR800
AR82.1 BL04.1 BL10.1 BL120 BL121 BL122
BL123 BL125 BL130 BL20.1 BL20.3 BL20.6
BL202 BL204 BL21.2 BL21.5 BL217 BL220
BL231 BL246 BL29.1 BL29.2 BL290 BL291
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.3
BL32.4 BL33.1 BL331 BL34.1 BL46.1 BL46.2
BL520 BL530 BL546 BL80.1 BL80.3 BL81.1
BL82.1 BL820 BL85.1 BL85.2 BL90.1 BL92.1
BR00.1 BR00.2 BR02.3 BR10.1 BR10.9 BR11.1
BR120 BR121 BR122 BR123 BR140 BR151
BR152 BR155 BR156 BR16.1 BR16.2 BR17.1
BR180 BR19.1 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.7 BR21.2 BR210 BR211 BR216
BR217 BR220 BR251 BR252 BR253 BR400
BR420 BR45.1 BR450 BR46.1 BR46.2 BR46.4
BR51.1 BR51.2 BR52.1 BR52.2 BR521 BR53.1
BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1 CB06.2
CB191 DT155 DT160 DT165 DT166 DT170
DT180 DT181 DT30.1 DT30.2 DT40.1 DT45.1
DT520 DT60.1 DT60.2 DT70.1 DT70.3 DT80.1
DT85.1 DT85.2 DT90.1 DT92.1 IC02.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 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 PO100 PO101 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 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 POI3.1
POID.1 POII.1 POIJ.1 PW110 RQ10.1 RQ10.2
TX40.1 WH110 WH120 WH130 WH132 WH190
WH20.1 WH20.2 WH20.7 WH21.2 WH224 WH226
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830
UPDATED BY
AR09.1 AR10.1 AR112 AR12.1 AR12.2 AR301
AR501 AR550 BL02.1 BL802 PW550 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
NAC-NAT-COMPANY Numeric 4 AR09.1 AR10.1
National Account National account customer's company AR12.1 AR12.2
Company number. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
NAC-NAT-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
National Account National account customer number. AR12.1 AR12.2
Customer AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
NAC-COMPANY Numeric 4 AR09.1 AR10.1
Element: Company Invoiced customer's company number. AR12.1 AR12.2
AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
NAC-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
Element: Customer Invoiced customer's customer number. AR12.1 AR12.2
AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
NAC-NA-TRAN-STATUS Numeric 1 AR112 AR12.1
Element: Status Determines whether to add and delete
national account transaction records in
AR12 National Account or in AR112
National Account Transaction Update,
based on a company processing option.
Valid values are:
1 = AR112 will add transactions
2 = AR112 will delete transactions
0 = Initialized value
3 = Establish relationship
NATACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
NACSET1 NAT-COMPANY AR09.1 AR10.1
NAT-CUSTOMER AR112 AR12.1
COMPANY AR12.2 AR130
CUSTOMER AR131 AR150
AR160 AR161
AR170 AR21.5
AR212 AR251
AR255 AR275
AR30.2 AR30.7
AR301 AR33.1
AR33.3 AR34.1
AR34.3 AR42.2
AR42.6 AR44.1
AR44.3 AR50.1
AR501 AR504
...
NACSET2 COMPANY AC56.1 AC560
CUSTOMER AP125 AP126
NAT-COMPANY AP131 AP20.1
NAT-CUSTOMER AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR09.1
AR10.1 AR112
AR115 AR12.1
AR12.2 AR124
AR129 AR13.1
AR13.2 AR130
...
NACSET3 NAT-COMPANY Subset AR251 AR70.2
NAT-CUSTOMER Where NAT-COMPANY != COMPANY
COMPANY
CUSTOMER
NACSET4 NAT-COMPANY Subset AR112
NAT-CUSTOMER Where NA-TRAN-STATUS != Zeroes
COMPANY
CUSTOMER
NATACCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
NAC-NAT-COMPANY -> ACO-COMPANY
Arinvcomp ARCOMP Required
NAC-COMPANY -> ACO-COMPANY
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
NAC-NAT-CUSTOMER -> CUD-CUSTOMER
Incustdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
NAC-CUSTOMER -> CUD-CUSTOMER
Invcustomer ARCUSTOMER Required
NAC-COMPANY -> ACM-COMPANY
NAC-CUSTOMER -> ACM-CUSTOMER
Natbalance NATBALANCE Required
NAC-NAT-COMPANY -> NAB-NAT-COMPANY
NAC-NAT-CUSTOMER -> NAB-NAT-CUSTOMER
NATACCT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Invoitems AROITEMS
NAC-COMPANY -> ARO-COMPANY
NAC-CUSTOMER -> ARO-CUSTOMER
ARO-TRANS-DATE
ARO-TRANS-TYPE
ARO-INVOICE
ARO-PAYMENT-SEQ
Natoitems AROITEMS
NAC-NAT-COMPANY -> ARO-COMPANY
NAC-NAT-CUSTOMER -> ARO-CUSTOMER
ARO-TRANS-DATE
ARO-TRANS-TYPE
ARO-INVOICE
ARO-PAYMENT-SEQ
|