|
|
ARIDISTRIB FILE
Distribution Convert/Interface
Distribution Convert/Interface
UPDATED BY
AR507 AR560 AR97.2 AR99.2 BL123 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AID-COMPANY Numeric 4 AR97.2 AR99.2
Company Required. Transaction company number. BL123 PBIP.1
AID-CUSTOMER Alpha 9 (Right Justified) BL123 PBIP.1
Customer Required. Customer number to which this
distribution belongs to.
AID-TRANS-TYPE Alpha 1 AR97.2 AR99.2
Transaction Type Required. Transaction type from which BL123 PBIP.1
this distribution originated. Valid
values are:
C = Credit Memo
D = Debit Memo
I = Invoice
AID-TRANS-NBR Alpha 10 (Right Justified) AR97.2 AR99.2
Transaction Number Required. Transaction number from which BL123 PBIP.1
this distribution originated from.
AID-PROG-SEQ-NBR Numeric 5 AR97.2 AR99.2
Sequence Number Required. Sequence number used for BL123 PBIP.1
uniqueness.
AID-GL-COMPANY Numeric 4 AR560 AR97.2
General Ledger General ledger company to which this AR99.2 BL123
Company distribution record belongs. Required PBIP.1
field.
AID-ACCT-UNIT Alpha 15 AR97.2 AR99.2
Accounting Unit The general ledger accounting unit for BL123 PBIP.1
this distribution. Required field.
AID-ACCOUNT Numeric 6 AR97.2 AR99.2
Account The general ledger account for this BL123 PBIP.1
distribution record. Required field.
AID-SUB-ACCT Numeric 4 AR97.2 AR99.2
Subaccount The general ledger subaccount for this BL123 PBIP.1
distribution record.
AID-ORIG-AMT Signed 15.2 AR97.2 AR99.2
Transaction Amount The amount of the distribution in BL123 PBIP.1
transaction currency. Required field.
AID-UNITS Signed 15.2 AR97.2 AR99.2
Units Quantity of units represented by the BL123 PBIP.1
amount of this distribution record.
AID-DESCRIPTION Alpha 30 (Lower Case) AR97.2 AR99.2
Description The description of this distribution. BL123 PBIP.1
AID-ACTIVITY Alpha 15 AR97.2 AR99.2
Activity The activity associated with the BL123 PBIP.1
distribution.
AID-ACCT-CATEGORY Alpha 5 AR97.2 AR99.2
Category The account category for the activity. BL123 PBIP.1
AID-TAX-CODE Alpha 10 AR97.2 AR99.2
Tax Code A user-defined code representing a BL123 PBIP.1
taxing authority and tax rate. Must be a
valid tax code record.
AID-ORIG-TAXABLE Signed 15.2 AR97.2 AR99.2
Original Taxable The taxable amount of the original BL123 PBIP.1
Amount distribution transaction.
AID-JRNL-BOOK-NBR Alpha 12
Journal Book Number The journal book number for the
distribution.
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-LINE-TYPE Alpha 1 AR97.2 BL123
Line Type This field contains the type of PBIP.1
inventory on this line.
G - Goods
S - Services
G = Goods
S = Services
AID-COMMODITY Alpha 8 AR97.2 BL123
Commodity The Intrastat commodity code. PBIP.1
Represents a category of goods. Must be
defined in IN03.1 (Commodity
Maintenance).
AID-WEIGHT Signed 9.3 AR97.2 BL123
Weight This field contains the unit weight of PBIP.1
the item based on the stocking UOM
(kilogram for the European Community).
AID-SECONDARY-QTY Signed 13.4 AR97.2 BL123
Secondary Quantity This field contains the secondary PBIP.1
quantity, which is tracked if the
Intrastat Classification Nomenclature
requires a second quantity for the
commodity code. This quantity is a memo
quantity only. It is not used for
valuation.
AID-SEC-UOM Alpha 4 AR97.2 BL123
Secondary Unit of This field contains the unit of measure PBIP.1
Measure for the secondary quantity.
AID-TAX-POINT Alpha 1 BL123 PBIP.1
Tax Point Indicates when the tax amount is
calculated for the distribution, if
applicable. Valid values are:
I = Invoice
P = Payment
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
TRANS-NBR AR99.2
PROG-SEQ-NBR
|