ARXIND – No description in the Lawson data dictionary

System
Accounts Receivable (AR)
Prefix
ARX
Primary key
COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBR
Fields
10
Updated by
4 programs
Referenced by
0 programs

ARXIND is a Lawson Accounts Receivable table (prefix ARX); no description in the lawson data dictionary. It is indexed by COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBR (ARXSET1); alternate indexes: ARXSET10, ARXSET11, ARXSET12, ARXSET13, ARXSET2, ARXSET3, ARXSET4, ARXSET5 and 4 more. It is updated by AR12.1, AR12.2, ARLL.1 and CB06.2. The table has 10 fields, 13 indexes and 0 documented relations.

About ARXIND

No description in the Lawson data dictionary.

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
ARX-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR12.1, AR12.2, ARLL.1, CB06.2
ARX-CUSTOMER
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.AR12.1, AR12.2, ARLL.1, CB06.2
ARX-NAT-COMPANY
NAT_COMPANY		Numeric 4The national account company.AR12.1, AR12.2, ARLL.1, CB06.2
ARX-NAT-CUSTOMER
NAT_CUSTOMER		Alpha 9 (Right Justified)The national account customer.AR12.1, AR12.2, ARLL.1, CB06.2
ARX-TRANS-TYPE PK
TRANS_TYPE		Alpha 1The related transaction type. Valid values are:
  • C Credit Mem
  • D Debit Memo
  • I Invoice
AR12.1, AR12.2, ARLL.1, CB06.2
ARX-INVOICE PK
INVOICE		Alpha 22Used to identify the related invoice, debit memo, or credit memo.AR12.1, AR12.2, ARLL.1, CB06.2
ARX-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6The payment sequence number of the related transaciont. This is the generated sequence number to separate individual invoic, credit memo, or debit memo payment requirements.AR12.1, AR12.2, ARLL.1, CB06.2
ARX-INDEX-NBR PK
INDEX_NBR		Numeric 1This number represents the indexed access method to the related transaction.AR12.1, AR12.2, ARLL.1, CB06.2
ARX-NAT-FLAG
NAT_FLAG		Alpha 1This field incdicates the national account affiliation.AR12.1, AR12.2, ARLL.1, CB06.2
ARX-SORT-FIELD
SORT_FIELD		Alpha 32 (Lower Case)The user sort data value.AR12.1, AR12.2, ARLL.1, CB06.2

Indexes (13)

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

IndexKeysFlagsConditionUsed in
ARXSET1COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRPrimaryAR12.1, AR12.2, ARLL.1, CB06.2
ARXSET10NAT-COMPANY, NAT-CUSTOMER, SORT-FIELD, COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 1 And NAT-FLAG = "I"—
ARXSET11NAT-COMPANY, NAT-CUSTOMER, SORT-FIELD, COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 2 And NAT-FLAG = "I"—
ARXSET12NAT-COMPANY, NAT-CUSTOMER, SORT-FIELD, COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 3 And NAT-FLAG = "I"—
ARXSET13NAT-COMPANY, NAT-CUSTOMER, SORT-FIELD, COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 4 And NAT-FLAG = "I"—
ARXSET2COMPANY, CUSTOMER, SORT-FIELD, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 1—
ARXSET3COMPANY, CUSTOMER, SORT-FIELD, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 2—
ARXSET4COMPANY, CUSTOMER, SORT-FIELD, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 3—
ARXSET5COMPANY, CUSTOMER, SORT-FIELD, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 4—
ARXSET6NAT-COMPANY, NAT-CUSTOMER, SORT-FIELD, COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 1 And NAT-FLAG != Spaces—
ARXSET7NAT-COMPANY, NAT-CUSTOMER, SORT-FIELD, COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 2 And NAT-FLAG != Spaces—
ARXSET8NAT-COMPANY, NAT-CUSTOMER, SORT-FIELD, COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 3 And NAT-FLAG != Spaces—
ARXSET9NAT-COMPANY, NAT-CUSTOMER, SORT-FIELD, COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, INDEX-NBRSubsetWhere INDEX-NBR = 4 And NAT-FLAG != Spaces—

Programs

Updated by (4)