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.
REFERENCED BY
AR130 AR131 AR150 AR160 AR161 AR170
AR21.4 AR21.5 AR21.1 AR21.2 AR21.3 AR212
AR251 AR255 AR275 AR30.2 AR30.7 AR30.8
AR30.1 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 AR570 AR575
AR580 AR70.2 AR72.1 AR75.1 AR90.1 ARLL.1
DT150 AP125 AP126 AP131 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 AR115 AR124 AR129
AR13.1 AR13.2 AR135 AR137 AR180 AR190
AR20.1 AR219 AR24.1 AR28.1 AR29.1 AR29.2
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 AR48.1 AR48.3 AR502 AR505 AR80.1
AR80.2 AR82.1 BL04.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 BL802
BL81.1 BL82.1 BL820 BL85.1 BL85.2 BL90.1
BL92.1 BR00.1 BR00.2 BR02.3 BR10.1 BR11.1
BR120 BR121 BR122 BR140 BR16.1 BR17.1
BR19.1 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR20.7 BR21.2 BR210 BR211 BR216 BR217
BR220 BR400 BR420 BR45.1 BR450 BR46.1
BR46.2 BR46.4 BR521 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 IC28.1 IC531
MA180 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAI1.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 OE111 OE112
OE113 OE114 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE130 OE14.3 OE14.4 OE16.1
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 OE530 OE54.1 OE60.1 OE80.1 OE80.2
OE81.1 OE81.2 OE810 OE830 OE85.1 OE85.3
OE86.1 OE90.1 OE90.2 PBIP.1 PO100 PO101
PO122 PO131 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 POI3.1 POIE.1 POII.1
POIJ.1 PR197 RQ10.1 RQ10.2 SA03.1 SA100
SA252 SA254 SA256 SA261 SA271 SA281
SA291 SA300 SA80.2 SA90.2 TX140 TX40.1
WH110 WH120 WH130 WH132 WH190 WH20.1
WH20.2 WH20.7 WH21.2 WH224 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 WO30.1
UPDATED BY
AR09.1 AR10.1 AR112 AR12.1 AR12.2 AR301
AR501 AR550 BL02.1
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 identifier. AR301 AR501
AR550 BL02.1
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
NAC-COMPANY Numeric 4 AR09.1 AR10.1
Element: Company Invoiced customer's company number. AR12.1 AR12.2
AR301 AR501
AR550 BL02.1
NAC-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
Element: Customer NumbeInvoiced customer's customer number. AR12.1 AR12.2
AR301 AR501
AR550 BL02.1
NAC-NA-TRAN-STATUS Numeric 1 AR112 AR12.1
Element: Status
NATACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
NACSET1 NAT-COMPANY This is the primary path used to access AR09.1 AR10.1
NAT-CUSTOMER records. AR112 AR12.1
COMPANY AR12.2 AR130
CUSTOMER AR131 AR150
AR160 AR161
AR170 AR21.4
AR21.5 AR212
AR251 AR255
AR275 AR30.2
AR30.7 AR30.8
AR301 AR33.1
AR33.3 AR34.1
AR34.3 AR42.2
AR42.6 AR44.1
AR44.3 AR50.1
...
NACSET2 COMPANY This path is used to validate customer AP125 AP126
CUSTOMER national account relationship. AP131 AP25.1
NAT-COMPANY AP25.2 AP26.1
NAT-CUSTOMER AP27.1 AP30.4
AR09.1 AR10.1
AR112 AR115
AR12.1 AR12.2
AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR150 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR21.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
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
|
