Lawson Insight Technical Documentation |
|
NATACCT
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 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.4 API1.1 AR112 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 BR122 BR123
BR15.1 BR151 BR152 BR155 BR156 BR16.1
BR16.2 BR210 BR211 BR215 BR220 BR251
BR252 BR253 BR420 BR450 BR51.1 BR51.2
BR52.1 BR52.2 BR521 BR53.1 BR55.2 BR91.1
BRIP.1 BRPI.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 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 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 PBIP.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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 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 POII.1
POIJ.1 PR197 RQ10.1 RQ10.2 RQ10.3 RQIE.1
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
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
Element: Company Invoiced customer's company number. AR12.2 AR501
AR550
NAC-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR12.1
Element: Customer NumbeInvoiced 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 AP20.1 AP20.2
NAT-CUSTOMER AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR10.1
AR112 AR115
AR12.1 AR12.2
AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR135 AR137
...
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
|