ARIDISTRIB

Distribution Convert/Interface

The AR Distribution Convert/Interface file contains interface and conversion distribution records for credit memos, debit memos and invoice transactions. Interface type distribution records may be specified to be posted to the general ledger, or to serve as a historical reference only. Conversion - These records are loaded by AR507 (Distribution Conversion) and can be maintained in AR99.2 (Conversion Distribution). Interfacing - These records are loaded by AR560 (Transaction Interface) and can be maintained in AR97.2 (Interfaced Distribution).
UPDATED BY
ARLL.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AID-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ARLL.1
AID-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Required. Customer number to which this distribution belongs to.
ARLL.1
AID-TRANS-TYPE
Element: Transaction Type
Alpha 1
Required. Transaction type from which this distribution originated. Valid values are: C = Credit Memo D = Debit Memo I = Invoice
ARLL.1
AID-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
ARLL.1
AID-PROG-SEQ-NBR
Element: Sequence Number
Numeric 7
Required. Sequence number used for uniqueness.
ARLL.1
AID-GL-COMPANY
General Ledger
Company
Numeric 4
General ledger company to which this distribution record belongs. Required field.
ARLL.1
AID-ACCT-UNIT
Element: Accounting Unit
Alpha 15
The general ledger accounting unit for this distribution. Required field.
ARLL.1
AID-ACCOUNT
Element: Account
Numeric 6
The general ledger account for this distribution record. Required field.
ARLL.1
AID-SUB-ACCT
Element: Subaccount
Numeric 4
The general ledger subaccount for this distribution record.
ARLL.1
AID-ORIG-AMT
Element: Transaction Amount
Signed 18.2
The amount of the distribution in transaction currency. Required field.
ARLL.1
AID-UNITS
Element: Units
Signed 15.2
Quantity of units represented by the amount of this distribution record.
AID-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of this distribution.
AID-ACTIVITY
Element: Activity
Alpha 15
The activity associated with the distribution.
AID-ACCT-CATEGORY
Element: Category
Alpha 5
The account category for the activity.
AID-TAX-CODE
Element: Tax Code
Alpha 10
A user-defined code representing a taxing authority and tax rate. Must be a valid tax code record.
ARLL.1
AID-ORIG-TAXABLE
Original Taxable
Amount
Signed 18.2
The taxable amount of the original distribution transaction.
ARLL.1
AID-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).
AID-TAX-POINT
Element: Tax Point
Alpha 1
The tax point value for a taxable interface ditsribution record.
ARLL.1
AID-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
AID-WEIGHT
Element: Weight
Signed 9.3
This field contains a weight measurement used in the intrastat process.
AID-ICN-CODE
Element: Icn Code
Alpha 8
The ICN code used in the intrastat process.
AID-SUPLMNTARY-QTY
Element: Quantity
Signed 13.4
The supplementary quantity used in the intrastat process.


ARIDISTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIDSET1 COMPANY
TRANS-TYPE
INVOICE
PROG-SEQ-NBR
ARLL.1
AIDSET2 COMPANY
INVOICE
TRANS-TYPE
PROG-SEQ-NBR
KeyChange


File created: Thu Jun 09 11:09:02 2016

Home
Contact Us



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