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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
NACSET1
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. COMPANY
  4. CUSTOMER
PrimaryAR09.1, AR10.1, AR12.1, AR12.2, AR212, AR301, AR501, AR550 +2 more
NACSET2
  1. COMPANY
  2. CUSTOMER
  3. NAT-COMPANY
  4. NAT-CUSTOMER
AC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
NACSET3
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. COMPANY
  4. CUSTOMER
SubsetWhere NAT-COMPANY != COMPANY—
NACSET4
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. COMPANY
  4. CUSTOMER
SubsetWhere NA-TRAN-STATUS != ZeroesAR01.1, AR12.1, AR12.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPCUSTDESCARCUSTOMERNATBALANCEAROITEMSNATACCT

One to one (6) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
NAC-NAT-COMPANY→ACO-COMPANY
ArinvcompARCOMPRequired
NAC-COMPANY→ACO-COMPANY
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
NAC-NAT-CUSTOMER→CUD-CUSTOMER
IncustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
NAC-CUSTOMER→CUD-CUSTOMER
InvcustomerARCUSTOMERRequired
NAC-COMPANY→ACM-COMPANY
NAC-CUSTOMER→ACM-CUSTOMER
NatbalanceNATBALANCERequired
NAC-NAT-COMPANY→NAB-NAT-COMPANY
NAC-NAT-CUSTOMER→NAB-NAT-CUSTOMER

One to many (2) — child tables

RelationTableRulesConditionField map
InvoitemsAROITEMS
NAC-COMPANY→ARO-COMPANY
NAC-CUSTOMER→ARO-CUSTOMER
—→ARO-TRANS-DATE
—→ARO-TRANS-TYPE
—→ARO-INVOICE
—→ARO-PAYMENT-SEQ
NatoitemsAROITEMS
NAC-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)