AR Distributions

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.

REFERENCED BY

TX101

GL235

UPDATED BY

ARLL.1

CB191

CB06.2

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
AMD-GL-COMPANY General Ledger Company	Numeric 4 The general ledger company associated with this distribution.	ARLL.1 CB191
AMD-ACCT-UNIT Element: Accounting Unit	Alpha 15 The general ledger accounting unit to which this distribution will be posted.	ARLL.1 CB191
AMD-ACCOUNT Element: Account	Numeric 6 The general ledger account number to which this distribution will be posted.	ARLL.1 CB191
AMD-SUB-ACCT Element: Subaccount	Numeric 4 The general ledger subaccount number used for posting the distribution.	ARLL.1 CB191
AMD-GL-DATE Element: Posting Date	Numeric 8 (yyyymmdd) The date this distribution will be posted to the general ledger.	ARLL.1 CB191
AMD-CREATE-DATE Element: Creation Date	Numeric 8 (yyyymmdd) The system date indicating when this distribution was created.	ARLL.1 CB191
AMD-CREATE-TIME Element: Creation Time	Numeric 6 (hhmmss) The system time indicating when this distribution was created.	ARLL.1 CB191
AMD-PROG-SEQ-NBR Program Sequence Number	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 Element: Distribution 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 Element: Batch Number	Numeric 6 The batch number associated with the transaction distribution.	ARLL.1 CB191
AMD-CUSTOMER Element: 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 Element: Process Level	Alpha 5 The process level associated with the transaction distribution.	ARLL.1 CB191
AMD-TRANS-TYPE Element: Transaction 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 Element: Invoice	Alpha 22 Used to identify the invoice.	ARLL.1 CB191
AMD-TRANS-DATE Element: Transaction Date	Numeric 8 (yyyymmdd) The date of the transaction associated with the distribution.	ARLL.1 CB191
AMD-DIST-SEQ Distribution Sequence Number	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 Element: Distribution 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 Sequence Number	Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system.
AMD-ACCUM-TYPE Distribution Summary/Detail	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 Element: Base Amount	Signed 18.2 The amount of the distribution in the company base currency.	ARLL.1 CB191
AMD-TO-COMP-AMT Element: To Company Amount	Signed 18.2 The amount of the distribution that will be posted to another company in a intercompany transaction.	ARLL.1 CB191
AMD-UNITS Element: Units	Signed 15.2 The quantity of units for the distribution if units are being used for a transaction.
AMD-DESC Element: Description	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 Element: 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 Element: 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 Element: Status	Numeric 1 Status of the distribution record. Valid values are: 0 = Unreleased 2 = Released 9 = Posted	ARLL.1 CB191
AMD-ORIG-CURRENCY Element: Transaction Currency	Alpha 5 The currency in which the transaction was entered.	ARLL.1 CB191
AMD-ORIG-RATE Element: Exchange 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 Element: Transaction Amount	Signed 18.2 The amount of the distribution in transaction currency.	ARLL.1 CB191
AMD-CAT-TYPE Element: Cat Type	Alpha 1 Indicates the type of distribution category. Valid values are: C = Category T = Tax
AMD-AR-CATEGORY Element: AR Category	Alpha 5 The category code assigned to the distribution. Used to default distribution information.
AMD-TAX-CODE Element: 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 Element: Base Taxable Amount	Signed 18.2 The taxable amount of the distribution.	ARLL.1
AMD-UPDATE-SUM Element: Update Summary	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 Element: Number of Decimals	Numeric 1 Indicates the number of decimals defined for the transaction currency.	ARLL.1 CB191
AMD-AUTO-REV Element: Auto Reversal	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 Element: Originating Company	Numeric 4 This is the company the distribution record originated from.	ARLL.1
AMD-ORIG-TAXABLE Element: Intl Amt	Signed 18.2 The taxable amount of the original distribution transaction.	ARLL.1
AMD-DOCUMENT-NBR Element: Document Number	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 Element: Distribution Source	Alpha 1 The source of the distribution. Valid values are: A = Accounts Receivable B = Bill of Exchange	ARLL.1 CB191
AMD-BASE-ACCTUNIT Element: Base Account Unit	Alpha 15 Used for inter-zone balancing in the Lawson General Ledger system.	ARLL.1 CB191
AMD-JRNL-BOOK-NBR Element: Journal Book Number	Alpha 12 This field will contain the journal book number for the distribution record.	ARLL.1 CB191
AMD-MX-VALUE Element: Matrix Value	Alpha 32 Occurs 3 Times An optional transaction attribute value as defined in the Lawson General Ledger system's Source Code program.	ARLL.1 CB191
AMD-GLT-OBJ-ID General Ledger Object ID	Numeric 12 A subsystem interface identification number. Used for Drill Around purposes.	ARLL.1 CB191
AMD-DRAFT-SOURCE Bill of Exchange Source	Alpha 1 This defines origination of the bill of exchange.
AMD-ATN-OBJ-ID Element: Activity Object ID	Numeric 12 A subsystem interface identification number. Used for Drill Around purposes.	ARLL.1 CB191
AMD-TAX-POINT Element: 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 Element: 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 Element: Line Type	Alpha 1 This field contains the line type used for intrastat purpose. Valid values are: Blank G = Goods S = Services
AMD-WEIGHT Element: Weight	Signed 9.3 This field contains a weight measurement used in the intrastat process.
AMD-ICN-CODE Element: Icn Code	Alpha 8 The ICN code used in the intrastat process.
AMD-SUPLMNTARY-QTY Element: Quantity	Signed 13.4 The supplementary quantity used in the intrastat process.
AMD-BAL-DATE Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.
AMD-ARA-OBJ-ID Element: Obj Id	Numeric 12

ARDISTRIB FILE INDEX

ARDISTRIB FILE RELATIONS

ONE TO ONE RELATIONS

ARDISTRIB FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.