|
|
ARIDISTRIB FILE
Distribution Convert/Interface
The AR Distribution Convert/Interface file contains interface and conversion
distribution records for credit memos, debit memos and invoice transactions.
These 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
AR507 AR97.2 AR99.2 ARLL.1 AR560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AID-COMPANY Numeric 4 AR97.2 AR99.2
Element: Company Required. Transaction company number. ARLL.1
AID-CUSTOMER Alpha 9 (Right Justified) ARLL.1
Element: Customer Required. Customer number to which this
distribution belongs to.
AID-TRANS-TYPE Alpha 1 AR97.2 AR99.2
Element: Transaction TyRequired. Transaction type from which ARLL.1
this distribution originated. Valid
values are:
C = Credit Memo
D = Debit Memo
I = Invoice
AID-INVOICE Alpha 22 AR97.2 AR99.2
Element: Invoice NumberUsed to identify the invoice. ARLL.1
AID-PROG-SEQ-NBR Numeric 7 AR97.2 AR99.2
Element: Sequence NumbeRequired. Sequence number used for ARLL.1
uniqueness.
AID-GL-COMPANY Numeric 4 AR560 AR97.2
General Ledger General ledger company to which this AR99.2 ARLL.1
Company distribution record belongs. Required
field.
AID-ACCT-UNIT Alpha 15 AR97.2 AR99.2
Element: Accounting UniThe general ledger accounting unit for ARLL.1
this distribution. Required field.
AID-ACCOUNT Numeric 6 AR97.2 AR99.2
Element: Account The general ledger account for this ARLL.1
distribution record. Required field.
AID-SUB-ACCT Numeric 4 AR97.2 AR99.2
Element: Subaccount The general ledger subaccount for this ARLL.1
distribution record.
AID-ORIG-AMT Signed 18.2 AR97.2 AR99.2
Element: Transaction AmThe amount of the distribution in ARLL.1
transaction currency. Required field.
AID-UNITS Signed 15.2 AR97.2 AR99.2
Element: Units Quantity of units represented by the
amount of this distribution record.
AID-DESCRIPTION Alpha 30 (Lower Case) AR97.2 AR99.2
Element: Description The description of this distribution.
AID-ACTIVITY Alpha 15 AR97.2 AR99.2
Element: Activity The activity associated with the
distribution.
AID-ACCT-CATEGORY Alpha 5 AR97.2 AR99.2
Element: Category The account category for the activity.
AID-TAX-CODE Alpha 10 AR97.2 AR99.2
Element: Tax Code A user-defined code representing a ARLL.1
taxing authority and tax rate. Must be a
valid tax code record.
AID-ORIG-TAXABLE Signed 18.2 AR97.2 AR99.2
Original Taxable The taxable amount of the original ARLL.1
Amount distribution transaction.
AID-JBK-SEQ-NBR Numeric 10 AR99.2
Journal Book The journal book sequence number
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 Alpha 1 ARLL.1
Element: Tax Point
AID-LINE-TYPE Alpha 1
Element: Line Type This field contains the type of
inventory on this line.
AID-WEIGHT Signed 9.3
Element: Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
AID-ICN-CODE Alpha 8
Element: Icn Code
AID-SUPLMNTARY-QTY Signed 13.4
Element: Quantity
ARIDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIDSET1 COMPANY The path is used to keep records unique AR507 AR560
TRANS-TYPE and for the primary processing. AR97.1 AR97.2
INVOICE AR99.1 AR99.2
PROG-SEQ-NBR ARLL.1
|
