|
|
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.
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
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 The number representing an AR company. 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 Used 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
Element: Jbk Seq Nbr 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 Alpha 1 ARLL.1
Element: Tax Point The tax point value for a taxable
interface ditsribution record.
AID-LINE-TYPE Alpha 1 AR97.2
Element: Line Type This field contains the line type used
for intrastat purpose. Valid values are:
Blank
G = Goods
S = Services
AID-WEIGHT Signed 9.3 AR97.2
Element: Weight This field contains a weight
measurement used in the intrastat
process.
AID-ICN-CODE Alpha 8 AR97.2
Element: Icn Code The ICN code used in the intrastat
process.
AID-SUPLMNTARY-QTY Signed 13.4 AR97.2
Element: Quantity The supplementary quantity used in the
intrastat process.
ARIDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIDSET1 COMPANY AR507 AR560
TRANS-TYPE AR97.1 AR97.2
INVOICE AR99.1 AR99.2
PROG-SEQ-NBR ARLL.1
AIDSET2 COMPANY KeyChange AR560
INVOICE
TRANS-TYPE
PROG-SEQ-NBR
|
