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.

Field / column	Type	Description & values	Updated by
`AMD-GL-COMPANY` PK GL_COMPANY	Numeric 4	The general ledger company associated with this distribution.	ARLL.1, CB191
`AMD-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	The general ledger accounting unit to which this distribution will be posted.	ARLL.1, CB191
`AMD-ACCOUNT` PK ACCOUNT	Numeric 6	The general ledger account number to which this distribution will be posted.	ARLL.1, CB191
`AMD-SUB-ACCT` PK SUB_ACCT	Numeric 4	The 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 7	Program sequence number. If multiple records with the same keys exist, this sequence number is incremented to make records unique.	ARLL.1, CB191
`AMD-COMPANY` COMPANY	Numeric 4	The 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` BATCH_NBR	Numeric 6	The batch number associated with the transaction distribution.	ARLL.1, CB191
`AMD-CUSTOMER` 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 5	The process level associated with the transaction distribution.	ARLL.1, CB191
`AMD-TRANS-TYPE` TRANS_TYPE	Alpha 1	The 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` INVOICE	Alpha 22	Used 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` DIST_SEQ	Numeric 4	Distribution 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` DST_TYPE	Alpha 2	Identifies 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` PAYMENT_SEQ	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	—
`AMD-ACCUM-TYPE` ACCUM_TYPE	Alpha 1	Indicates 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.2	The amount of the distribution in the company base currency.	ARLL.1, CB191
`AMD-TO-COMP-AMT` TO_COMP_AMT	Signed 18.2	The amount of the distribution that will be posted to another company in a intercompany transaction.	ARLL.1, CB191
`AMD-UNITS` UNITS	Signed 15.2	The 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 15	Activities 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 5	Account 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 1	Status of the distribution record. Valid values are: `0` Unreleased `2` Released `9` Posted	ARLL.1, CB191
`AMD-ORIG-CURRENCY` ORIG_CURRENCY	Alpha 5	The currency in which the transaction was entered.	ARLL.1, CB191
`AMD-ORIG-RATE` ORIG_RATE	Signed 14.7	The 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.2	The amount of the distribution in transaction currency.	ARLL.1, CB191
`AMD-CAT-TYPE` CAT_TYPE	Alpha 1	Indicates the type of distribution category. Valid values are: `C` Category `T` Tax	—
`AMD-AR-CATEGORY` AR_CATEGORY	Alpha 5	The category code assigned to the distribution. Used to default distribution information.	—
`AMD-TAX-CODE` TAX_CODE	Alpha 10	The 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.2	The taxable amount of the distribution.	ARLL.1
`AMD-UPDATE-SUM` UPDATE_SUM	Alpha 2	Indicates 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 1	Indicates the number of decimals defined for the transaction currency.	ARLL.1, CB191
`AMD-AUTO-REV` AUTO_REV	Alpha 1	When 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 4	This is the company the distribution record originated from.	ARLL.1
`AMD-ORIG-TAXABLE` ORIG_TAXABLE	Signed 18.2	The taxable amount of the original distribution transaction.	ARLL.1
`AMD-DOCUMENT-NBR` DOCUMENT_NBR	Alpha 27	This 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 1	The source of the distribution. Valid values are: `A` Accounts Receivable `B` Bill of Exchange	ARLL.1, CB191
`AMD-BASE-ACCTUNIT` BASE_ACCTUNIT	Alpha 15	Used for inter-zone balancing in the Lawson General Ledger system.	ARLL.1, CB191
`AMD-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	This field will contain the journal book number for the distribution record.	ARLL.1, CB191
`AMD-MX-VALUE` MX_VALUE	Alpha 32 Occurs 3 Times ×3	An optional transaction attribute value as defined in the Lawson General Ledger system's Source Code program.	ARLL.1, CB191
`AMD-GLT-OBJ-ID` GLT_OBJ_ID	Numeric 12	A subsystem interface identification number. Used for Drill Around purposes.	ARLL.1, CB191
`AMD-DRAFT-SOURCE` DRAFT_SOURCE	Alpha 1	This defines origination of the bill of exchange.	—
`AMD-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	A subsystem interface identification number. Used for Drill Around purposes.	ARLL.1, CB191
`AMD-TAX-POINT` TAX_POINT	Alpha 1	Indicates 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 10	The 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 1	This field contains the line type used for intrastat purpose. Valid values are: Blank `G` Goods `S` Services	—
`AMD-WEIGHT` WEIGHT	Signed 9.3	This field contains a weight measurement used in the intrastat process.	—
`AMD-ICN-CODE` ICN_CODE	Alpha 8	The ICN code used in the intrastat process.	—
`AMD-SUPLMNTARY-QTY` SUPLMNTARY_QTY	Signed 13.4	The 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` ARA_OBJ_ID	Numeric 12	—	—

Indexes (10)

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

Index	Keys	Flags	Condition	Used in
`AMDSET1`	`GL-COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCT`, `GL-DATE`, `CREATE-DATE`, `CREATE-TIME`, `PROG-SEQ-NBR`	Primary		ARLL.1, CB191
`AMDSET10`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `CUSTOMER`, `DIST-SEQ`, `PROG-SEQ-NBR`, `DST-TYPE`, `BATCH-NBR`	Subset	Where DST-TYPE = "RM" Or DST-TYPE = "RI" Or DST-TYPE = "RP" Or DST-TYPE = "RN"	—
`AMDSET2`	`COMPANY`, `BATCH-NBR`, `TRANS-TYPE`, `INVOICE`, `CUSTOMER`, `DIST-SEQ`	Subset	Where DST-TYPE = "RI" Or DST-TYPE = "RP" Or DST-TYPE = "RM"	ARLL.1, CB06.2, CB191, TX101
`AMDSET3`	`COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCT`, `GL-COMPANY`, `GL-DATE`, `CREATE-DATE`, `CREATE-TIME`, `PROG-SEQ-NBR`	Subset	Where STATUS = 2	—
`AMDSET4`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `DIST-SEQ`	Subset	Where DST-TYPE = "RU"	—
`AMDSET5`	`GL-COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCT`, `GL-DATE`, `GLT-OBJ-ID`, `CREATE-DATE`, `CREATE-TIME`, `PROG-SEQ-NBR`	KeyChange		GL235
`AMDSET6`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`, `DIST-SEQ`	Subset	Where TAX-POINT = "P"	—
`AMDSET7`	`ATN-OBJ-ID`, `GL-COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCT`, `GL-DATE`, `CREATE-DATE`, `CREATE-TIME`, `PROG-SEQ-NBR`	Subset	Where ATN-OBJ-ID != Zeroes	—
`AMDSET8`	`GL-COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCT`, `DST-TYPE`, `GL-DATE`, `CREATE-DATE`, `CREATE-TIME`, `PROG-SEQ-NBR`	Subset	Where BAL-DATE = Zeroes And STATUS = 9	—
`AMDSET9`	`ARA-OBJ-ID`	Subset	Where ARA-OBJ-ID != Zeroes	—

Relations

One to one (11) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcategory	ARCATEGORY	Required		`AMD-COMPANY` → `ACA-COMPANY (ACASET1)`, `AMD-AR-CATEGORY` → `ACA-AR-CATEGORY`
Aroihdr	AROIHDR	Required		`AMD-COMPANY` → `ARH-COMPANY`, `AMD-BATCH-NBR` → `ARH-BATCH-NBR`, `AMD-CUSTOMER` → `ARH-CUSTOMER`, `AMD-TRANS-TYPE` → `ARH-TRANS-TYPE`, `AMD-INVOICE` → `ARH-INVOICE`
Arpayment	ARPAYMENT	Required	When 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`
Arudistrib	ARUDISTRIB	Not 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`
Company	ARCOMP	Required		`AMD-COMPANY` → `ACO-COMPANY`
Custdesc	CUSTDESC	Required	When AMD-CUSTOMER != Spaces Or AMD-CUSTOMER != "000000000"	`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `AMD-CUSTOMER` → `CUD-CUSTOMER`
Customer	ARCUSTOMER	Required		`AMD-COMPANY` → `ACM-COMPANY`, `AMD-CUSTOMER` → `ACM-CUSTOMER`
Gl Comp	ARCOMP	Required		`AMD-GL-COMPANY` → `ACO-COMPANY`
Glnames	GLNAMES	Required		`AMD-GL-COMPANY` → `GLN-COMPANY`, `AMD-ACCT-UNIT` → `GLN-ACCT-UNIT`
Porebdist	POREBDIST	Not 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`
Txtaxcode	TXTAXCODE	Required		`AMD-COMPANY` → `TAC-COMPANY`, `AMD-TAX-CODE` → `TAC-TAX-CODE`

One to many (3) — child tables

Relation	Table	Condition	Field map
Arapplied Ar	ARAPPLIED	Valid 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 Off	ARAPPLIED	Valid 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`
Sltrans	SLTRANS		`AMD-GLT-OBJ-ID` → `SLT-GLT-OBJ-ID`, → `SLT-OBJ-ID`

ARDISTRIB – AR Distributions

About ARDISTRIB

Fields (54)

Indexes (10)

Relations

One to one (11) — lookups and parents

One to many (3) — child tables

Programs

Updated by (3)

Referenced by (2)