NATACCT – Accounts Receivable Natl Acct

System
Accounts Receivable (AR)
Prefix
NAC
Primary key
NAT-COMPANY, NAT-CUSTOMER, COMPANY, CUSTOMER
Fields
5
Updated by
8 programs
Referenced by
293 programs

NATACCT is the Accounts Receivable Natl Acct table in Lawson Accounts Receivable (prefix NAC). It is indexed by NAT-COMPANY, NAT-CUSTOMER, COMPANY, CUSTOMER (NACSET1); alternate indexes: NACSET2, NACSET3 and NACSET4. It is related 1:1 to ARCOMP, CUSTDESC, ARCUSTOMER and NATBALANCE and 1:M to AROITEMS. It is updated by AR09.1, AR10.1, AR12.1, AR12.2, AR301, AR501, AR550 and TX140 and referenced by AC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 and 285 more. The table has 5 fields, 4 indexes and 8 documented relations.

About NATACCT

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.

Fields (5)

Column = COBOL field name without the NAC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
NAC-NAT-COMPANY PK
NAT_COMPANY		Numeric 4National account customer's company number.AR09.1, AR10.1, AR12.1, AR12.2, AR301, AR501, AR550, TX140
NAC-NAT-CUSTOMER PK
NAT_CUSTOMER		Alpha 9 (Right Justified)National account customer number.AR09.1, AR10.1, AR12.1, AR12.2, AR301, AR501, AR550, TX140
NAC-COMPANY PK
COMPANY		Numeric 4Invoiced customer's company number.AR09.1, AR10.1, AR12.1, AR12.2, AR301, AR501, AR550, TX140
NAC-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Invoiced customer's customer number.AR09.1, AR10.1, AR12.1, AR12.2, AR301, AR501, AR550, TX140
NAC-NA-TRAN-STATUS
NA_TRAN_STATUS		Numeric 1Determines 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
AR12.1, AR12.2

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
NACSET1NAT-COMPANY, NAT-CUSTOMER, COMPANY, CUSTOMERPrimaryAR09.1, AR10.1, AR12.1, AR12.2, AR212, AR301, AR501, AR550 +2 more
NACSET2COMPANY, CUSTOMER, NAT-COMPANY, NAT-CUSTOMERAC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
NACSET3NAT-COMPANY, NAT-CUSTOMER, COMPANY, CUSTOMERSubsetWhere NAT-COMPANY != COMPANY—
NACSET4NAT-COMPANY, NAT-CUSTOMER, COMPANY, CUSTOMERSubsetWhere NA-TRAN-STATUS != ZeroesAR01.1, AR12.1, AR12.2

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredNAC-NAT-COMPANY → ACO-COMPANY
ArinvcompARCOMPRequiredNAC-COMPANY → ACO-COMPANY
CustdescCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, NAC-NAT-CUSTOMER → CUD-CUSTOMER
IncustdescCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, NAC-CUSTOMER → CUD-CUSTOMER
InvcustomerARCUSTOMERRequiredNAC-COMPANY → ACM-COMPANY, NAC-CUSTOMER → ACM-CUSTOMER
NatbalanceNATBALANCERequiredNAC-NAT-COMPANY → NAB-NAT-COMPANY, NAC-NAT-CUSTOMER → NAB-NAT-CUSTOMER

One to many (2) — child tables

RelationTableRulesConditionField map
InvoitemsAROITEMSNAC-COMPANY → ARO-COMPANY, NAC-CUSTOMER → ARO-CUSTOMER, → ARO-TRANS-DATE, → ARO-TRANS-TYPE, → ARO-INVOICE, → ARO-PAYMENT-SEQ
NatoitemsAROITEMSNAC-NAT-COMPANY → ARO-COMPANY, NAC-NAT-CUSTOMER → ARO-CUSTOMER, → ARO-TRANS-DATE, → ARO-TRANS-TYPE, → ARO-INVOICE, → ARO-PAYMENT-SEQ

Programs

Updated by (8)

Referenced by (293)