ARIDISTRIB – Distribution Convert/Interface

System
Accounts Receivable (AR)
Prefix
AID
Primary key
COMPANY, TRANS-TYPE, INVOICE, PROG-SEQ-NBR
Fields
22
Updated by
1 program
Referenced by
0 programs

ARIDISTRIB is the Distribution Convert/Interface table in Lawson Accounts Receivable (prefix AID). It is indexed by COMPANY, TRANS-TYPE, INVOICE, PROG-SEQ-NBR (AIDSET1); alternate indexes: AIDSET2. It is updated by ARLL.1. The table has 22 fields, 2 indexes and 0 documented relations.

About ARIDISTRIB

No description in the Lawson data dictionary.

Fields (22)

Column = COBOL field name without the AID- 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
#AID-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.ARLL.1
#AID-CUSTOMER
CUSTOMER		Alpha 9 (Right Justified)Required. Customer number to which this distribution belongs to.ARLL.1
#AID-TRANS-TYPE PK
TRANS_TYPE		Alpha 1Required. Transaction type from which this distribution originated. Valid values are:
  • C Credit Memo
  • D Debit Memo
  • I Invoice
ARLL.1
#AID-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.ARLL.1
#AID-PROG-SEQ-NBR PK
PROG_SEQ_NBR		Numeric 7Required. Sequence number used for uniqueness.ARLL.1
#AID-GL-COMPANY
GL_COMPANY		Numeric 4General ledger company to which this distribution record belongs. Required field.ARLL.1
#AID-ACCT-UNIT
ACCT_UNIT		Alpha 15The general ledger accounting unit for this distribution. Required field.ARLL.1
#AID-ACCOUNT
ACCOUNT		Numeric 6The general ledger account for this distribution record. Required field.ARLL.1
#AID-SUB-ACCT
SUB_ACCT		Numeric 4The general ledger subaccount for this distribution record.ARLL.1
#AID-ORIG-AMT
ORIG_AMT		Signed 18.2The amount of the distribution in transaction currency. Required field.ARLL.1
#AID-UNITS
UNITS		Signed 15.2Quantity of units represented by the amount of this distribution record.—
#AID-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of this distribution.—
#AID-ACTIVITY
ACTIVITY		Alpha 15The activity associated with the distribution.—
#AID-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The account category for the activity.—
#AID-TAX-CODE
TAX_CODE		Alpha 10A user-defined code representing a taxing authority and tax rate. Must be a valid tax code record.ARLL.1
#AID-ORIG-TAXABLE
ORIG_TAXABLE		Signed 18.2The taxable amount of the original distribution transaction.ARLL.1
#AID-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).—
#AID-TAX-POINT
TAX_POINT		Alpha 1The tax point value for a taxable interface ditsribution record.ARLL.1
#AID-LINE-TYPE
LINE_TYPE		Alpha 1This field contains the line type used for intrastat purpose. Valid values are: Blank
  • G Goods
  • S Services
—
#AID-WEIGHT
WEIGHT		Signed 9.3This field contains a weight measurement used in the intrastat process.—
#AID-ICN-CODE
ICN_CODE		Alpha 8The ICN code used in the intrastat process.—
#AID-SUPLMNTARY-QTY
SUPLMNTARY_QTY		Signed 13.4The supplementary quantity used in the intrastat process.—

Indexes (2)

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
AIDSET1
  1. COMPANY
  2. TRANS-TYPE
  3. INVOICE
  4. PROG-SEQ-NBR
PrimaryARLL.1
AIDSET2
  1. COMPANY
  2. INVOICE
  3. TRANS-TYPE
  4. PROG-SEQ-NBR
KeyChange—

Programs

Updated by (1)