ARDISTRIB – AR Distributions

System
Accounts Receivable (AR)
Prefix
AMD
Primary key
GL-COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCT, GL-DATE, CREATE-DATE, CREATE-TIME, PROG-SEQ-NBR
Fields
54
Updated by
3 programs
Referenced by
2 programs

ARDISTRIB is the AR Distributions table in Lawson Accounts Receivable (prefix AMD). It is indexed by GL-COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCT, GL-DATE, CREATE-DATE, CREATE-TIME, PROG-SEQ-NBR (AMDSET1); alternate indexes: AMDSET10, AMDSET2, AMDSET3, AMDSET4, AMDSET5, AMDSET6, AMDSET7, AMDSET8 and 1 more. It is related 1:1 to ARCATEGORY, AROIHDR, ARPAYMENT, ARUDISTRIB, ARCOMP, CUSTDESC, ARCUSTOMER, GLNAMES and 2 more and 1:M to ARAPPLIED and SLTRANS. It is updated by ARLL.1, CB06.2 and CB191 and referenced by GL235 and TX101. The table has 54 fields, 10 indexes and 14 documented relations.

About ARDISTRIB

The AR Distributions file contains distribution records for every transaction that will be posted to the General Ledger system through the Lawson Accounts Receivable system.

Fields (54)

Column = COBOL field name without the AMD- 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
#AMD-GL-COMPANY PK
GL_COMPANY		Numeric 4The general ledger company associated with this distribution.ARLL.1, CB191
#AMD-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The general ledger accounting unit to which this distribution will be posted.ARLL.1, CB191
#AMD-ACCOUNT PK
ACCOUNT		Numeric 6The general ledger account number to which this distribution will be posted.ARLL.1, CB191
#AMD-SUB-ACCT PK
SUB_ACCT		Numeric 4The general ledger subaccount number used for posting the distribution.ARLL.1, CB191
#AMD-GL-DATE PK
GL_DATE		Numeric 8 (yyyymmdd)The date this distribution will be posted to the general ledger.ARLL.1, CB191
#AMD-CREATE-DATE PK
CREATE_DATE		Numeric 8 (yyyymmdd)The system date indicating when this distribution was created.ARLL.1, CB191
#AMD-CREATE-TIME PK
CREATE_TIME		Numeric 6 (hhmmss)The system time indicating when this distribution was created.ARLL.1, CB191
#AMD-PROG-SEQ-NBR PK
PROG_SEQ_NBR		Numeric 7Program sequence number. If multiple records with the same keys exist, this sequence number is incremented to make records unique.ARLL.1, CB191
#AMD-COMPANY SET10 SET2 SET3 SET4 SET6
COMPANY		Numeric 4The company assigned to the distribution. This may be different from the company assigned to the transaction if an intercompany relationship is defined in the Lawson General Ledger system.ARLL.1, CB191
#AMD-BATCH-NBR SET10 SET2
BATCH_NBR		Numeric 6The batch number associated with the transaction distribution.ARLL.1, CB191
#AMD-CUSTOMER SET10 SET2 SET4 SET6
CUSTOMER		Alpha 9 (Right Justified)The customer number associated with this distribution. This field will have a value depending on whether the distributions are detail or summary and the originating process.ARLL.1, CB191
#AMD-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5The process level associated with the transaction distribution.ARLL.1, CB191
#AMD-TRANS-TYPE SET10 SET2 SET4 SET6
TRANS_TYPE		Alpha 1The type of transaction associated with the distribution. Valid values are:
  • C Credit Memo
  • D Debit Memo
  • I Invoice
  • N Non-Accounts Receivable Payment
  • B Bills of Exchange
  • P Payment (AR)
  • R Remittance
  • M Mixed
ARLL.1, CB191
#AMD-INVOICE SET10 SET2 SET4 SET6
INVOICE		Alpha 22Used to identify the invoice.ARLL.1, CB191
#AMD-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction associated with the distribution.ARLL.1, CB191
#AMD-DIST-SEQ SET10 SET2 SET4 SET6
DIST_SEQ		Numeric 4Distribution sequence number. If multiple distributions are posted for a transaction, this sequence number helps identify and keep distributions unique.ARLL.1, CB191
#AMD-DST-TYPE SET10 SET8
DST_TYPE		Alpha 2Identifies where the transaction originated in the Lawson Accounts Receivable system. Valid values are:
  • RI Receivable Invoicing
  • RL Receivable Application
  • RM Receivable Memo
  • RN Receivable Notice
  • RP Receivable Payment
  • RV Receivable Reversal
  • RU Unrealized Gain Loss
  • BE BOE Cashing Expense
  • BG BOE Bank Presentation Cashing
  • DA BOE Accepted
  • DB BOE Cancellation
  • DC BOE Cashing
  • DH BOE Dishonored
  • DK BOE Discounted Remittance
  • DR BOE Cashing with Remittance
  • EC BOE Gain Loss
  • RY Application Reversal
  • RQ Application Adjustment
  • RX Adjustment Reversal
ARLL.1, CB191
#AMD-PAYMENT-SEQ SET4
PAYMENT_SEQ		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.—
#AMD-ACCUM-TYPE
ACCUM_TYPE		Alpha 1Indicates whether the type of the distribution is detail or summary. Valid values are:
  • D Detail
  • S Summary
ARLL.1, CB191
#AMD-TRAN-AMT
TRAN_AMT		Signed 18.2The amount of the distribution in the company base currency.ARLL.1, CB191
#AMD-TO-COMP-AMT
TO_COMP_AMT		Signed 18.2The amount of the distribution that will be posted to another company in a intercompany transaction.ARLL.1, CB191
#AMD-UNITS
UNITS		Signed 15.2The quantity of units for the distribution if units are being used for a transaction.—
#AMD-DESC
DESC		Alpha 30 (Lower Case)The description of the distribution. The value in this field varies depending on the type of transaction and the program the distribution was created in.ARLL.1, CB191
#AMD-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.—
#AMD-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru—
#AMD-STATUS
STATUS		Numeric 1Status of the distribution record. Valid values are:
  • 0 Unreleased
  • 2 Released
  • 9 Posted
ARLL.1, CB191
#AMD-ORIG-CURRENCY
ORIG_CURRENCY		Alpha 5The currency in which the transaction was entered.ARLL.1, CB191
#AMD-ORIG-RATE
ORIG_RATE		Signed 14.7The currency exchange rate used to convert a non-base currency transaction amount to the company base currency. The rate is maintained in the Currency Relationship file and there is an option at the company level to override the rate at entry time.ARLL.1, CB191
#AMD-ORIG-AMT
ORIG_AMT		Signed 18.2The amount of the distribution in transaction currency.ARLL.1, CB191
#AMD-CAT-TYPE
CAT_TYPE		Alpha 1Indicates the type of distribution category. Valid values are:
  • C Category
  • T Tax
—
#AMD-AR-CATEGORY
AR_CATEGORY		Alpha 5The category code assigned to the distribution. Used to default distribution information.—
#AMD-TAX-CODE
TAX_CODE		Alpha 10The tax code assigned to the distribution. Identifies a tax percentage to be assessed to the taxable amount of a transaction. Must be defined in the Lawson Tax system.ARLL.1
#AMD-TRAN-TAXABLE
TRAN_TAXABLE		Signed 18.2The taxable amount of the distribution.ARLL.1
#AMD-UPDATE-SUM
UPDATE_SUM		Alpha 2Indicates what summary amount should be updated when AR194 (Audit Summary) is run. Valid values are:
  • 01 Invoice
  • 02 Memos
  • 03 Cash
  • 04 Credits Applied
  • 06 Chargebacks
  • 07 Discounts
  • 08 Write-Offs
  • 09 Gain/Loss on currency exchange
  • 10 Cashed Bill of Exchange
ARLL.1
#AMD-ORIG-ND
ORIG_ND		Numeric 1Indicates the number of decimals defined for the transaction currency.ARLL.1, CB191
#AMD-AUTO-REV
AUTO_REV		Alpha 1When the Auto Reversal field is set to "Y", program AR196 (Unrealized Gain Loss Report) creates an opposite entry for this transaction. Valid values are:
  • N No reversing records needed
  • Y Reversing records needed
—
#AMD-ORIG-COMPANY
ORIG_COMPANY		Numeric 4This is the company the distribution record originated from.ARLL.1
#AMD-ORIG-TAXABLE
ORIG_TAXABLE		Signed 18.2The taxable amount of the original distribution transaction.ARLL.1
#AMD-DOCUMENT-NBR
DOCUMENT_NBR		Alpha 27This field is used for document journalizing in the Lawson General Ledger system. Document numbers are assessed during record creation and represent a source document or a summary value for many documents with an identifying source prefix. Valid values are:
  • 1 Invoicing detail
  • 2 Debit Memo detail
  • 3 Credit Memo detail
  • 5 Payment Batch summary
  • 6 Payment detail
  • 7 Application detail/summary
  • 8 RTM detail
  • 9 Finance Charge summary
  • 10 Finance Charge detail
  • 11 Invoice Unreal Gain Loss detail
  • 12 Db Memo Unreal Gain Loss detail
  • 13 Cr Memo Unreal Gain Loss detail
  • 14 Transfer to Non-AR detail
  • 15 Debit Memo Grouping
ARLL.1, CB191
#AMD-DST-SOURCE
DST_SOURCE		Alpha 1The source of the distribution. Valid values are:
  • A Accounts Receivable
  • B Bill of Exchange
ARLL.1, CB191
#AMD-BASE-ACCTUNIT
BASE_ACCTUNIT		Alpha 15Used for inter-zone balancing in the Lawson General Ledger system.ARLL.1, CB191
#AMD-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12This field will contain the journal book number for the distribution record.ARLL.1, CB191
#AMD-MX-VALUE
MX_VALUE		Alpha 32 Occurs 3 Times ×3An optional transaction attribute value as defined in the Lawson General Ledger system's Source Code program.ARLL.1, CB191
#AMD-GLT-OBJ-ID SET5
GLT_OBJ_ID		Numeric 12A subsystem interface identification number. Used for Drill Around purposes.ARLL.1, CB191
#AMD-DRAFT-SOURCE
DRAFT_SOURCE		Alpha 1This defines origination of the bill of exchange.—
#AMD-ATN-OBJ-ID SET7
ATN_OBJ_ID		Numeric 12A subsystem interface identification number. Used for Drill Around purposes.ARLL.1, CB191
#AMD-TAX-POINT
TAX_POINT		Alpha 1Indicates the tax point origin, used for tax calculation. Valid values are:
  • I Invoice origin
  • P Payment origin
  • Blank No tax point origin
  • S Shipping Date
  • G GL Date
ARLL.1
#AMD-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).CB191
#AMD-LINE-TYPE
LINE_TYPE		Alpha 1This field contains the line type used for intrastat purpose. Valid values are: Blank
  • G Goods
  • S Services
—
#AMD-WEIGHT
WEIGHT		Signed 9.3This field contains a weight measurement used in the intrastat process.—
#AMD-ICN-CODE
ICN_CODE		Alpha 8The ICN code used in the intrastat process.—
#AMD-SUPLMNTARY-QTY
SUPLMNTARY_QTY		Signed 13.4The supplementary quantity used in the intrastat process.—
#AMD-BAL-DATE
BAL_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.—
#AMD-ARA-OBJ-ID SET9
ARA_OBJ_ID		Numeric 12——

Indexes (10)

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
AMDSET1
  1. GL-COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCT
  5. GL-DATE
  6. CREATE-DATE
  7. CREATE-TIME
  8. PROG-SEQ-NBR
PrimaryARLL.1, CB191
AMDSET10
  1. COMPANY
  2. TRANS-TYPE
  3. INVOICE
  4. CUSTOMER
  5. DIST-SEQ
  6. PROG-SEQ-NBR
  7. DST-TYPE
  8. BATCH-NBR
SubsetWhere DST-TYPE = "RM" Or DST-TYPE = "RI" Or DST-TYPE = "RP" Or DST-TYPE = "RN"—
AMDSET2
  1. COMPANY
  2. BATCH-NBR
  3. TRANS-TYPE
  4. INVOICE
  5. CUSTOMER
  6. DIST-SEQ
SubsetWhere DST-TYPE = "RI" Or DST-TYPE = "RP" Or DST-TYPE = "RM"ARLL.1, CB06.2, CB191, TX101
AMDSET3
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCT
  5. GL-COMPANY
  6. GL-DATE
  7. CREATE-DATE
  8. CREATE-TIME
  9. PROG-SEQ-NBR
SubsetWhere STATUS = 2—
AMDSET4
  1. COMPANY
  2. CUSTOMER
  3. TRANS-TYPE
  4. INVOICE
  5. PAYMENT-SEQ
  6. DIST-SEQ
SubsetWhere DST-TYPE = "RU"—
AMDSET5
  1. GL-COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCT
  5. GL-DATE
  6. GLT-OBJ-ID
  7. CREATE-DATE
  8. CREATE-TIME
  9. PROG-SEQ-NBR
KeyChangeGL235
AMDSET6
  1. COMPANY
  2. CUSTOMER
  3. TRANS-TYPE
  4. INVOICE
  5. DIST-SEQ
SubsetWhere TAX-POINT = "P"—
AMDSET7
  1. ATN-OBJ-ID
  2. GL-COMPANY
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCT
  6. GL-DATE
  7. CREATE-DATE
  8. CREATE-TIME
  9. PROG-SEQ-NBR
SubsetWhere ATN-OBJ-ID != Zeroes—
AMDSET8
  1. GL-COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCT
  5. DST-TYPE
  6. GL-DATE
  7. CREATE-DATE
  8. CREATE-TIME
  9. PROG-SEQ-NBR
SubsetWhere BAL-DATE = Zeroes And STATUS = 9—
AMDSET9
  1. ARA-OBJ-ID
SubsetWhere ARA-OBJ-ID != Zeroes—

Relations

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

One to one (11) — lookups and parents

RelationTableRulesConditionField map
ArcategoryARCATEGORYRequired
AMD-COMPANY→ACA-COMPANY (ACASET1)
AMD-AR-CATEGORY→ACA-AR-CATEGORY
AroihdrAROIHDRRequired
AMD-COMPANY→ARH-COMPANY
AMD-BATCH-NBR→ARH-BATCH-NBR
AMD-CUSTOMER→ARH-CUSTOMER
AMD-TRANS-TYPE→ARH-TRANS-TYPE
AMD-INVOICE→ARH-INVOICE
ArpaymentARPAYMENTRequiredWhen AMD-TRANS-TYPE = "N"
AMD-COMPANY→APM-COMPANY
AMD-BATCH-NBR→APM-BATCH-NBR
AMD-TRANS-TYPE→APM-TRANS-TYPE
AMD-INVOICE→APM-TRANS-NBR
AMD-CUSTOMER→APM-CUSTOMER
ArudistribARUDISTRIBNot Required
AMD-COMPANY→DGM-COMPANY
AMD-BATCH-NBR→DGM-BATCH-NBR
AMD-TRANS-TYPE→DGM-TRANS-TYPE
AMD-INVOICE→DGM-INVOICE
AMD-CUSTOMER→DGM-CUSTOMER
AMD-DIST-SEQ→DGM-DIST-SEQ
CompanyARCOMPRequired
AMD-COMPANY→ACO-COMPANY
CustdescCUSTDESCRequiredWhen AMD-CUSTOMER != Spaces Or AMD-CUSTOMER != "000000000"
ACO-CUST-GROUP→CUD-CUST-GROUP
AMD-CUSTOMER→CUD-CUSTOMER
CustomerARCUSTOMERRequired
AMD-COMPANY→ACM-COMPANY
AMD-CUSTOMER→ACM-CUSTOMER
Gl CompARCOMPRequired
AMD-GL-COMPANY→ACO-COMPANY
GlnamesGLNAMESRequired
AMD-GL-COMPANY→GLN-COMPANY
AMD-ACCT-UNIT→GLN-ACCT-UNIT
PorebdistPOREBDISTNot Required
AMD-GL-COMPANY→RDS-COMPANY
AMD-BATCH-NBR→RDS-AR-BATCH-NBR
AMD-INVOICE→RDS-AR-INVOICE
AMD-DIST-SEQ→RDS-DIST-SEQ-NBR
TxtaxcodeTXTAXCODERequired
AMD-COMPANY→TAC-COMPANY
AMD-TAX-CODE→TAC-TAX-CODE

One to many (3) — child tables

RelationTableRulesConditionField map
Arapplied ArARAPPLIEDValid When AMD-ARA-OBJ-ID != Zeroes
AMD-ARA-OBJ-ID→ARA-AMD-AR-OBJ-ID
—→ARA-COMPANY
—→ARA-TRANS-TYPE
—→ARA-INVOICE
—→ARA-PAYMENT-SEQ
—→ARA-BATCH-NBR
—→ARA-APP-SEQ
Arapplied OffARAPPLIEDValid When AMD-ARA-OBJ-ID != Zeroes
AMD-ARA-OBJ-ID→ARA-AMD-OFF-OBJ-ID
—→ARA-COMPANY
—→ARA-TRANS-TYPE
—→ARA-INVOICE
—→ARA-PAYMENT-SEQ
—→ARA-BATCH-NBR
—→ARA-APP-SEQ
SltransSLTRANS
AMD-GLT-OBJ-ID→SLT-GLT-OBJ-ID
—→SLT-OBJ-ID

Programs

Updated by (3)

Referenced by (2)