 |
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 AP125 AP126
AP131 AP25.1 AP25.2 AP26.1 AP27.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 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 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
IC28.1 IC531 MX223 MA180 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 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 TX140
TX40.1 WH110 WH120 WH130 WH132 WH190
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
UPDATED BY
AR10.1 AR12.1 AR12.2 AR301 AR501 AR550
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
NAC-NAT-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR12.1
National Account National account customer number. AR12.2 AR501
Customer AR550
NAC-COMPANY Numeric 4 AR10.1 AR12.1
Company Invoiced customer's company number. AR12.2 AR501
AR550
NAC-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR12.1
Customer Number Invoiced customer's customer number. AR12.2 AR501
AR550
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.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
...
NACSET2 COMPANY This path is used to validate customer AC551 AP125
CUSTOMER national account relationship. AP126 AP131
NAT-COMPANY AP25.1 AP25.2
NAT-CUSTOMER AP26.1 AP27.1
AR10.1 AR115
AR12.1 AR124
AR129 AR13.1
AR13.2 AR130
AR131 AR135
AR137 AR150
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR21.4 AR21.5
AR212 AR219
...
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
|