Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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.  National account
relationships are alo used in Aging reports and customer Statements.

REFERENCED BY

AR130     AR131     AR150     AR160     AR161     AR170
AR21.5    AR21.1    AR21.2    AR21.3    AR21.4    AR212
AR251     AR255     AR275     AR30.2    AR30.7    AR30.1
AR30.8    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     AR70.2    AR72.1
AR75.1    AR90.1    ARLL.1    DT150     AC56.1    AC560
AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.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    AR32.1    AR35.1    AR35.2
AR37.1    AR37.2    AR37.3    AR37.4    AR37.5    AR37.6
AR37.7    AR38.1    AR38.2    AR38.3    AR39.1    AR39.2
AR43.1    AR48.1    AR48.3    AR502     AR505     AR510
AR570     AR575     AR580     AR80.1    AR80.2    AR800
AR82.1    BL04.1    BL10.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    BL81.1
BL82.1    BL820     BL85.1    BL85.2    BL90.1    BL92.1
BR00.1    BR00.2    BR02.3    BR10.1    BR10.9    BR11.1
BR120     BR121     BR122     BR123     BR140     BR151
BR152     BR155     BR156     BR16.1    BR16.2    BR17.1
BR180     BR19.1    BR20.1    BR20.2    BR20.3    BR20.4
BR20.5    BR20.7    BR21.2    BR210     BR211     BR216
BR217     BR220     BR251     BR252     BR253     BR400
BR420     BR45.1    BR450     BR46.1    BR46.2    BR46.4
BR51.1    BR51.2    BR52.1    BR52.2    BR521     BR53.1
BR55.2    BR70.1    BR70.2    BR91.1    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    MA180
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PO100     PO101     PO122     PO131     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO23.1    PO24.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    PO32.4    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
POID.1    POII.1    POIJ.1    PW110     RQ10.1    RQ10.2
TX40.1    WH110     WH120     WH130     WH132     WH190
WH20.1    WH20.2    WH20.7    WH21.2    WH224     WH226
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

AR09.1    AR10.1    AR112     AR12.1    AR12.2    AR301
AR501     AR550     BL02.1    BL802     PW550     TX140


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                number.                                   AR301   AR501
                                                                 AR550   BL02.1
                                                                 BL802   PW550
                                                                 TX140

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
                                                                 BL802   PW550
                                                                 TX140

NAC-COMPANY            Numeric 4                                 AR09.1  AR10.1
Element: Company       Invoiced customer's company number.       AR12.1  AR12.2
                                                                 AR301   AR501
                                                                 AR550   BL02.1
                                                                 BL802   PW550
                                                                 TX140

NAC-CUSTOMER           Alpha 9  (Right Justified)                AR09.1  AR10.1
Element: Customer      Invoiced customer's customer number.      AR12.1  AR12.2
                                                                 AR301   AR501
                                                                 AR550   BL02.1
                                                                 BL802   PW550
                                                                 TX140

NAC-NA-TRAN-STATUS     Numeric 1                                 AR112   AR12.1
Element: Status        Determines whether to add and delete
                       national account transaction records in
                       AR12 National Account or in AR112
                       National Account Transaction Update,
                       based on a company processing option.
                       Valid values are:

                       1 = AR112 will add transactions
                       2 = AR112 will delete transactions
                       0 = Initialized value
                       3 = Establish relationship

                         NATACCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

NACSET1   NAT-COMPANY                                            AR09.1  AR10.1
          NAT-CUSTOMER                                           AR112   AR12.1
          COMPANY                                                AR12.2  AR130
          CUSTOMER                                               AR131   AR150
                                                                 AR160   AR161
                                                                 AR170   AR21.5
                                                                 AR212   AR251
                                                                 AR255   AR275
                                                                 AR30.2  AR30.7
                                                                 AR301   AR33.1
                                                                 AR33.3  AR34.1
                                                                 AR34.3  AR42.2
                                                                 AR42.6  AR44.1
                                                                 AR44.3  AR50.1
                                                                 AR501   AR504
                                                                 ...

NACSET2   COMPANY                                                AC56.1  AC560
          CUSTOMER                                               AP125   AP126
          NAT-COMPANY                                            AP131   AP20.1
          NAT-CUSTOMER                                           AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  AR09.1
                                                                 AR10.1  AR112
                                                                 AR115   AR12.1
                                                                 AR12.2  AR124
                                                                 AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 ...

NACSET3   NAT-COMPANY   Subset                                   AR251   AR70.2
          NAT-CUSTOMER  Where NAT-COMPANY != COMPANY
          COMPANY
          CUSTOMER

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