 |
Lawson Insight Technical Documentation |
|
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.3 AR30.4 AR30.7
AR30.8 AR30.9 AR30.1 AR30.2 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 DT150 AC551 AR115 AR124
AR129 AR13.1 AR13.2 AR135 AR137 AR180
AR190 AR20.1 AR219 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 AR48.1 AR48.3 AR502 AR505 AR82.1
BL04.1 BL121 BL123 BL125 BL202 BL204
BL217 BL220 BL231 BL246 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
BL80.1 BL80.3 BL802 BL81.1 BL82.1 BL85.1
BL85.2 BL90.1 BR10.1 BR11.1 BR120 BR121
BR210 BR211 BR220 BR420 BR450 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
PR197 TX140 TX40.1 WH110 WH120 WH130
WH21.2 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4
UPDATED BY
AR301 AR501 AR550 BL02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
NAC-NAT-COMPANY Numeric 4 AR501 AR550
National Account National account customer's company BL02.1
Company identifier.
NAC-NAT-CUSTOMER Alpha 9 (Right Justified) AR501 AR550
National Account National account customer number. BL02.1
Customer
NAC-COMPANY Numeric 4 AR501 AR550
Company Invoiced customer's company number. BL02.1
NAC-CUSTOMER Alpha 9 (Right Justified) AR501 AR550
Customer Number Invoiced customer's customer number. BL02.1
NATACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
NACSET1 NAT-COMPANY This is the primary path used to access AR130 AR131
NAT-CUSTOMER records. AR150 AR160
COMPANY AR161 AR170
CUSTOMER AR21.4 AR21.5
AR212 AR251
AR255 AR275
AR30.3 AR30.4
AR30.7 AR30.8
AR30.9 AR301
AR42.2 AR42.6
AR44.1 AR44.3
AR50.1 AR501
AR504 AR550
AR560 AR570
AR575 AR580
...
NACSET2 COMPANY This path is used to validate customer AC551 AR115
CUSTOMER national account relationship. AR124 AR129
NAT-COMPANY AR13.1 AR13.2
NAT-CUSTOMER AR130 AR131
AR135 AR137
AR150 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR21.4
AR21.5 AR212
AR219 AR24.1
AR28.1 AR29.1
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
...
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-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
|