NATACCT FILE
AR National Account
AR National Account
REFERENCED BY
AR130 AR131 AR150 AR160 AR161 AR170
AR21.4 AR21.5 AR21.1 AR21.2 AR21.3 AR212
AR251 AR255 AR275 AR30.1 AR30.2 AR30.3
AR30.4 AR30.7 AR30.8 AR30.9 AR42.2 AR42.6
AR42.1 AR42.7 AR44.1 AR44.3 AR50.1 AR504
AR560 AR570 AR575 AR580 AR70.2 AR73.1
AR75.1 DT150 SAA2.1 AC115 AC15.2 AC450
AR115 AR124 AR13.1 AR13.2 AR135 AR137
AR180 AR190 AR20.1 AR24.1 AR28.1 AR29.1
AR29.3 AR31.5 AR31.6 AR35.1 AR35.2 AR37.1
AR37.2 AR37.3 AR37.4 AR37.5 AR37.6 AR37.7
AR43.1 AR502 AR505 AR82.1 BL04.1 BL120
BL121 BL122 BL123 BL130 BL20.1 BL20.3
BL202 BL204 BL21.2 BL21.5 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
BL80.1 BL80.3 BL802 BL81.1 BL820 BL85.1
BL85.2 BL90.1 BL902 BL92.1 BL940 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 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 OE112
OE113 OE114 OE129 OE130 OE14.3 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE230 OE254 OE260 OE270 OE271 OE272
OE284 OE285 OE286 OE290 OE291 OE292
OE293 OE294 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE330 OE510
OE53.1 OE54.1 OE60.1 OE80.1 OE80.2 OE81.1
OE81.2 OE810 OE830 OE85.1 OE90.1 OE90.2
OE920 OE950 PBIP.1 SA03.1 SA100 SA252
SA254 SA256 SA261 SA271 SA281 SA291
SA300 SA80.2 SA90.2 TX140 TX40.1 WH110
WH120 WH130 WH132 WH190 WH20.2 WH20.7
WH21.2 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 WH33.5 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830
UPDATED BY
AR10.1 AR12.1 AR12.2 AR301 AR501 AR550
BL02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
NAC-NAT-COMPANY Numeric 4 AR10.1 AR12.1
National Account National account customer's company AR12.2 AR501
Company identifier. AR550 BL02.1
NAC-NAT-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR12.1
National Account National account customer number. AR12.2 AR501
Customer AR550 BL02.1
NAC-COMPANY Numeric 4 AR10.1 AR12.1
Company Invoiced customer's company number. AR12.2 AR501
AR550 BL02.1
NAC-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR12.1
Customer Number Invoiced customer's customer number. AR12.2 AR501
AR550 BL02.1
NATACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
NACSET1 NAT-COMPANY This is the primary path used to access AR12.1 AR12.2
NAT-CUSTOMER records. AR130 AR131
COMPANY AR150 AR160
CUSTOMER AR161 AR170
AR21.4 AR21.5
AR212 AR251
AR255 AR275
AR30.1 AR30.2
AR30.3 AR30.4
AR30.7 AR30.8
AR30.9 AR301
AR42.2 AR42.6
AR44.1 AR44.3
AR50.1 AR501
AR504 AR550
...
NACSET2 COMPANY This path is used to validate customer AC115 AC15.2
CUSTOMER national account relationship. AC450 AR10.1
NAT-COMPANY AR115 AR124
NAT-CUSTOMER AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR150 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR21.4
AR21.5 AR212
AR24.1 AR28.1
AR29.1 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
...
NACSET3 NAT-COMPANY This path is used to validate AR251 AR70.2
NAT-CUSTOMER intercompany national account
COMPANY relationship.
CUSTOMER Subset
Where NAT-COMPANY != COMPANY
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-TRANS-NBR
ARO-PAYMENT-SEQ
Natoitems AROITEMS
NAC-NAT-COMPANY -> ARO-COMPANY
NAC-NAT-CUSTOMER -> ARO-CUSTOMER
ARO-TRANS-DATE
ARO-TRANS-TYPE
ARO-TRANS-NBR
ARO-PAYMENT-SEQ
|