|
|
ARITRANS FILE
AR Interface Transaction
The AR Interface Transaction file contains transaction records for
interfacing and conversion purposes.
Conversion - These records will be loaded into the Accounts Receivable system
via AR502 (Transaction Conversion). Records in this file can be maintained by
AR99 (Conversion Maintenance) to comply with the edit requirements of AR502.
Interfacing - These records will be loaded into the Accounts Receivable
system via AR560 (Transaction Interface). Records in this file can be
maintained by AR97 (Interface Maintenance) to comply with the edit
requirements of AR560.
REFERENCED BY
AR42.2 AR42.7 BL00.1 BL01.1 BL120 BL121
BL122 BL123 BL130 BL20.1 BL20.3 BL200
BL201 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 BR11.1 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE810 OE830 WH20.7
UPDATED BY
AR502 AR560 AR97.1 AR99.1 ARLL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIT-COMPANY Numeric 4 AR97.1 AR99.1
Element: Company Required. Transaction company number. ARLL.1
AIT-TRANS-TYPE Alpha 1 AR97.1 AR99.1
Element: Transaction TyRequired. Transaction type of open item ARLL.1
record. Valid values are:
C = Credit Memo
D = Debit Memo
I = Invoice
M = Mixed
AIT-INVOICE Alpha 22 AR97.1 AR99.1
Element: Invoice NumberUsed to identify the invoice. ARLL.1
AIT-PAYMENT-SEQ Numeric 6 AR99.1
Payment Sequence Payment Sequence. This is the generated
Number sequence number to separate individual
payment requirements.
AIT-CUSTOMER Alpha 9 (Right Justified) AR97.1 AR99.1
Element: Customer Required. Customer number. ARLL.1
AIT-STATUS Numeric 1 AR97.1 AR99.1
Element: Status Required. Status indicating where this ARLL.1
record is in the processing flow. Valid
values are:
1 = Open
7 = Fully applied
8 = Closed
9 = Historical
AIT-GL-STATUS Numeric 1 AR97.1 AR99.1
General Ledger Required. Specifies if distribution ARLL.1
Status records are to be posted to general
ledger. Valid values are:
2 = Distributions records to be posted
9 = Historical or nonexistent
AIT-LAST-STA-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: Last StatementDate of last statement that this record ARLL.1
was selected for. YYYYMMDD format.
AIT-BATCH-NBR Numeric 6 AR97.1 AR99.1
Element: Batch Number Required. Identifies the batch the ARLL.1
entered transaction belongs to.
AIT-PROCESS-LEVEL Alpha 5 AR97.1 AR99.1
Element: Process Level Required. The process level of this ARLL.1
invoice, debit memo or credit memo. Must
be an active process level and not
restricted for this customer's
invoice.
AIT-TRANS-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: Transaction DaRequired. Date of the transaction. ARLL.1
YYYYMMDD format.
AIT-GL-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: General LedgerRequired. General Ledger posting date. ARLL.1
AIT-APPLIED-SEQ Numeric 7 AR99.1
Element: Application SeApplication sequence for interfaced
invoice, debit memo or credit memo.
AIT-LAST-FC-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Last Finance Charge Last finance charge date for this ARLL.1
Date invoice or debit memo. YYYYMMDD format.
AIT-CUST-PO-NBR Alpha 22 AR97.1 AR99.1
Element: Customer PO NuCustomer purchase order number that ARLL.1
relates to this credit memo, debit memo,
or invoice.
AIT-XREF-COMPANY Numeric 4 AR502 AR560
Cross Reference Cross reference company number. AR97.1 AR99.1
Company ARLL.1
AIT-XREF-TYPE Alpha 1 AR97.1 AR99.1
Element: Cross ReferencCross reference type indicator. This ARLL.1
field is used with the cross reference
number field. Valid values are:
D = Debit memo
I = Invoice
O = Other - Order processing
AIT-XREF-NBR Alpha 22 AR97.1 AR99.1
Cross Reference Cross reference number that this ARLL.1
Number invoice, debit memo or credit memo
relates to. This field is used with the
cross reference type field.
AIT-XREF-PYMT-SEQ Numeric 6 AR502 AR97.1
Element: Xref Pymt Seq ARLL.1
AIT-DESC Alpha 30 (Lower Case) AR97.1 AR99.1
Element: Description Description of invoice or reason for ARLL.1
credit or debit memo.
AIT-AR-CODE Alpha 4 AR97.1 AR99.1
Accounts Receivable Accounts Receivable general ledger ARLL.1
Code account code. The account specified by
this code will be credited during cash
application.
AIT-SALESMAN Numeric 4 AR97.1 AR99.1
Element: SalesRep The sales representative for this ARLL.1
invoice, debit memo or credit memo.
AIT-TRANS-USER1 Alpha 10 AR97.1 AR99.1
Element: Transaction UsFirst user field. This field is used in ARLL.1
record selection and record sorting.
AIT-TRANS-USER2 Alpha 15 AR97.1 AR99.1
Element: Transaction UsSecond user field. ARLL.1
AIT-TRANS-USER3 Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: Transaction UsThird user field. ARLL.1
AIT-TRANS-USER4 Numeric 9 AR97.1 AR99.1
Element: Transaction UsFourth user field. ARLL.1
AIT-TRANS-USER5 Signed 18.2 AR97.1 AR99.1
Element: Transaction UsFifth user field. ARLL.1
AIT-ORIG-CURRENCY Alpha 5 AR560 AR97.1
Element: Transaction CuCurrency in which the credit memo, AR99.1 ARLL.1
debit memo, or invoice was entered.
AIT-ORIG-RATE Signed 14.7 AR560 AR97.1
Element: Exchange Rate The rate used to convert a transaction AR99.1 ARLL.1
amount from a non-base currency to the
company base currency.
AIT-CURR-MUDV Alpha 1 AR560 AR97.1
Currency Currency Multiplier or Divider. This is AR99.1 ARLL.1
Multiply/Divide used along with the currency rate to
compute the company base transaction
amount. Valid values are:
D = Divide
M = Multiply
AIT-ORIG-AMT Signed 18.2 AR97.1 AR99.1
Element: Transaction AmRequired. Transaction amount in ARLL.1
transaction currency of invoice, debit
memo or credit memo.
AIT-GROUP-RATE Signed 14.7 AR560 AR97.1
Element: Group Rate The group rate used to calculate AR99.1 ARLL.1
customer group balance updates.
AIT-GROUP-MUDV Alpha 1 AR560 AR97.1
Group The group currency multiplier or AR99.1 ARLL.1
Multiply/Divide divider. Valid values are:
D = Divide
M = Multiply
AIT-ORIG-APP-AMT Signed 18.2 AR97.1 AR99.1
Transaction Applied Amount, if any, of all applications for ARLL.1
Amount this credit memo, debit memo, or invoice
in transaction currency.
AIT-ORIG-ADJ-AMT Signed 18.2 AR97.1 AR99.1
Transaction Amount, if any, of all adjustments for ARLL.1
Adjustment Amount this credit memo, debit memo, or invoice
in transaction currency.
AIT-REVALUE-FL Alpha 1 AR560 AR97.1
Element: Revalue This flag indicates whether this credit AR99.1 ARLL.1
memo, debit memo, or invoice is subject
to revaluation if its currency differs
from the company base currency. Valid
values are:
N = No; do not revalue
Y = Yes; revalue
AIT-ORIG-ND Numeric 1 AR97.1 AR99.1
Element: Number of DeciCurrency decimal indicator. ARLL.1
AIT-TERMS-CD Alpha 5 AR97.1 AR99.1
Element: Terms Code Terms code for the credit memo, debit ARLL.1
memo, or invoice.
AIT-BANK-INST-CODE Alpha 3 AR97.1 AR99.1
Element: Payment Code This is a user-defined value ARLL.1
representing a specific banking
transaction. There are three categories
of bank transactions: cash payments,
bill of exchange payments, and
miscellaneous non-payment bank
transactions. Specify the cash payment
value.
AIT-OPEN-ORDS Signed 18.2 AR97.1 AR99.1
Element: Open Order AmoOrder amount of an invoice, credit or ARLL.1
debit memo. This amount will be
subtracted from the customer's open
order amount.
AIT-DISC-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: Discount Date Discount date of invoice. If entered it ARLL.1
will override the calculated discount
date of terms code.
AIT-DISC-PCT Percent 7.5 (Percent) AR97.1 AR99.1
Element: Discount PerceDiscount percent. If entered it will ARLL.1
override the discount percent of terms
code.
AIT-DUE-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: Due Date The due date of the credit memo, debit ARLL.1
memo, or invoice. If entered it will
override the calculated due date of
terms code.
AIT-DISC-AMT Signed 18.2 AR560 AR97.1
Element: Discount AmounDiscount amount. If entered will AR99.1 ARLL.1
override the calculated discount amount
of terms code.
AIT-BILL-TO Numeric 4 AR97.1 AR99.1
Element: Bill To The bill to location for the open item. ARLL.1
AIT-JRNL-BOOK-NBR Alpha 12 AR97.1 AR99.1
Element: Journal Book NThe journal book assigned to the ARLL.1
transaction.
AIT-AUTO-APP-FL Alpha 1 AR97.1 AR99.1
Automatic Indicates if the credit memo is ARLL.1
Application Flag eligible for automatic memo application.
Valid values are:
N = No
Y = Yes
AIT-ACTIVITY Alpha 15 AR560 AR97.1
Element: Activity The activity assigned to the AR99.1 ARLL.1
transaction.
AIT-ACCT-CATEGORY Alpha 5 AR502 AR560
Element: Account CategoThe account category assigned to the AR97.1 AR99.1
activity. ARLL.1
AIT-ALT-TYPE Alpha 1 AR560 AR97.1
Element: Alt Type The transaction type of the associated ARLL.1
transaction header record.
C = Credit Memo
D = Debit Memo
I = Invoice
AIT-SUM-LINE Alpha 1 AR97.1 ARLL.1
Element: Sum Line The field will determine if line items
are displayed in detail or summary.
N = No
Y = Yes
AIT-SYSTEM Alpha 2 AR97.1 AR99.1
Element: System Code A two-character code representing an ARLL.1
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
AIT-INV-OBJ-ID Numeric 12
Element: Inv Obj Id
AIT-USR-FLD-01 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 01 ARLL.1
AIT-USR-FLD-02 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 02 ARLL.1
AIT-USR-FLD-03 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 03 ARLL.1
AIT-USR-FLD-04 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 04 ARLL.1
AIT-USR-FLD-05 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 05 ARLL.1
AIT-AC-CUSTOMER-ID Alpha 5 AR97.1 ARLL.1
Element: Ac Customer IdUsed for Drill access from the ARsystem
to the ABR system.
AIT-SORT-1 Alpha 32 (Lower Case) AR97.1 AR99.1
Element: Sort 1 ARLL.1
AIT-SORT-2 Alpha 32 (Lower Case) AR97.1 AR99.1
Element: Sort 2 ARLL.1
AIT-SORT-3 Alpha 32 (Lower Case) AR97.1 AR99.1
Element: Sort 3 ARLL.1
AIT-SORT-4 Alpha 32 (Lower Case) AR97.1 AR99.1
Element: Sort 4 ARLL.1
AIT-FOB-CODE Alpha 3
Element: Shipping Term The user defined Free On Board Code.
AIT-PORT-CD Alpha 5
Element: Port Cd The Intrastat port code. Must be
define
in IN04.1 (Port Maintenance)
AIT-NOTC Alpha 2
Element: Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
AIT-STAT-PROC Alpha 6
Element: Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
AIT-ORIGIN-COUNTRY Alpha 2
Element: Origin CountryThe country from which the goods were
shipped. Must be a valid country in
IN01.1 (Country Maintenance)
AIT-DEST-COUNTRY Alpha 2
Element: Dest Country The country to which the goods were
shipped. Must be a valid country in
IN01.1 (Country Maintenance).
AIT-ORIGIN-REGION Alpha 2
Element: Origin Region The region of the country from which the
goods were shipped, if required. Must be
a valid region in IN02.1 (Region
Maintenance)
AIT-DEST-REGION Alpha 2
Element: Dest Region The region of the country to which the
goods were shipped, if required. Must
be a valid region in IN02.1 (Region
Maintenance)
AIT-DROP-SHIP-IND Alpha 1
Element: Drop Ship Ind Specifies whether the shipment is a
drop (triangulated) shipment, that is a
shipment where goods are shipped from
one EC country to another, but a
principal in the transaction is based
elsewhere.
AIT-TRANSPORT-MODE Alpha 1
Element: Transport ModeThe mode of transportation at the
border crossing. Code 7 is used for the
Channel Tunnel.
1 = Sea
2 = Rail
3 = Road
4 = Air
5 = Post
7 = Fixed Installation
8 = Inland Waterway
9 = Own Propulsion
ARITRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AITSET1 COMPANY This path is used for record uniqueness AR502 AR560
CUSTOMER with customer being an access method for
TRANS-TYPE processing.
INVOICE
PAYMENT-SEQ
AITSET2 COMPANY This path is used for record AR42.2 AR42.7
TRANS-TYPE uniqueness. AR560 AR97.1
INVOICE AR97.2 AR99.1
PAYMENT-SEQ AR99.2 ARLL.1
BL00.1 BL01.1
BL120 BL121
BL122 BL123
BL130 BL20.1
BL20.3 BL200
BL201 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BR11.1 OE10.1
OE10.2 OE10.3
...
|
