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 BL121 BL200
BL201 BR11.1 PHI3.1
UPDATED BY
AR502 AR560 AR97.1 AR99.1 BL123 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIT-COMPANY Numeric 4 AR97.1 AR99.1
Company Required. Transaction company number. BL123 BRIP.1
AIT-TRANS-TYPE Alpha 1 AR97.1 AR99.1
Transaction Type Required. Transaction type of open item BL123 BRIP.1
record. Valid values are:
C = Credit Memo
D = Debit Memo
I = Invoice
M = Mixed
AIT-INVOICE Alpha 22 AR97.1 AR99.1
Invoice Number Used to identify the invoice. BL123 BRIP.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
Customer Required. Customer number. BL123 BRIP.1
AIT-STATUS Numeric 1 AR97.1 AR99.1
Status Required. Status indicating where this BL123 BRIP.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 BL123 BRIP.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
Last Statement Date Date of last statement that this record BL123 BRIP.1
was selected for. YYYYMMDD format.
AIT-BATCH-NBR Numeric 6 AR97.1 AR99.1
Batch Number Required. Identifies the batch the BL123 BRIP.1
entered transaction belongs to.
AIT-PROCESS-LEVEL Alpha 5 AR97.1 AR99.1
Process Level Required. The process level of this BL123 BRIP.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
Transaction Date Required. Date of the transaction. BL123 BRIP.1
YYYYMMDD format.
AIT-GL-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
General Ledger Date Required. General Ledger posting date. BL123 BRIP.1
AIT-APPLIED-SEQ Numeric 5 AR99.1 BL123
Application Sequence Application sequence for interfaced BRIP.1
invoice, debit memo or credit memo.
AIT-LAST-FC-DATE Numeric 8 (yyyymmdd) AR99.1 BL123
Last Finance Charge Last finance charge date for this BRIP.1
Date invoice or debit memo. YYYYMMDD format.
AIT-CUST-PO-NBR Alpha 22 AR97.1 AR99.1
Customer PO Number Customer purchase order number that BL123 BRIP.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 BL123 BRIP.1
AIT-XREF-TYPE Alpha 1 AR97.1 AR99.1
Cross Reference Type Cross reference type indicator. This BL123 BRIP.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 BL123 BRIP.1
Number invoice, debit memo or credit memo
relates to. This field is used with the
cross reference type field.
AIT-XREF-SEQ Numeric 3 AR502
Cross Reference Sequence number representing cross
Sequence referenced open item payment obligation
occurrence.
AIT-DESC Alpha 30 (Lower Case) AR97.1 AR99.1
Description Description of invoice or reason for BL123 BRIP.1
credit or debit memo.
AIT-AR-CODE Alpha 4 AR97.1 AR99.1
Accounts Receivable Accounts Receivable general ledger BL123 BRIP.1
Code account code. The account specified by
this code will be credited during cash
application.
AIT-SALESMAN Numeric 4 AR97.1 AR99.1
SalesRep The sales representative for this BL123 BRIP.1
invoice, debit memo or credit memo.
AIT-TRANS-USER1 Alpha 10 AR97.1 AR99.1
Transaction User 1 First user field. This field is used in BL123 BRIP.1
record selection and record sorting.
AIT-TRANS-USER2 Alpha 15 AR97.1 AR99.1
Transaction User 2 Second user field. BL123 BRIP.1
AIT-TRANS-USER3 Numeric 8 (yyyymmdd) AR97.1 AR99.1
Transaction User 3 Third user field. BL123 BRIP.1
AIT-TRANS-USER4 Numeric 9 AR97.1 AR99.1
Transaction User 4 Fourth user field. BL123 BRIP.1
AIT-TRANS-USER5 Signed 13.2 AR97.1 AR99.1
Transaction User 5 Fifth user field. BL123 BRIP.1
AIT-ORIG-CURRENCY Alpha 5 AR560 AR97.1
Transaction Currency Currency in which the credit memo, AR99.1 BL123
debit memo, or invoice was entered. BRIP.1
AIT-ORIG-RATE Signed 12.6 AR560 AR97.1
Exchange Rate The rate used to convert a transaction AR99.1 BL123
amount from a non-base currency to the BRIP.1
company base currency.
AIT-CURR-MUDV Alpha 1 AR560 AR97.1
Currency Currency Multiplier or Divider. This is AR99.1 BL123
Multiply/Divide used along with the currency rate to BRIP.1
compute the company base transaction
amount. Valid values are:
D = Divide
M = Multiply
AIT-ORIG-AMT Signed 15.2 AR97.1 AR99.1
Transaction Amount Required. Transaction amount in BL123 BRIP.1
transaction currency of invoice, debit
memo or credit memo.
AIT-GROUP-RATE Signed 12.6 AR560 AR97.1
Group Rate The group rate used to calculate AR99.1 BL123
customer group balance updates. BRIP.1
AIT-GROUP-MUDV Alpha 1 AR560 AR97.1
Group The group currency multiplier or AR99.1 BL123
Multiply/Divide divider. Valid values are: BRIP.1
D = Divide
M = Multiply
AIT-ORIG-APP-AMT Signed 15.2 AR97.1 AR99.1
Transaction Applied Amount, if any, of all applications for BL123 BRIP.1
Amount this credit memo, debit memo, or invoice
in transaction currency.
AIT-ORIG-ADJ-AMT Signed 15.2 AR97.1 AR99.1
Transaction Amount, if any, of all adjustments for BL123 BRIP.1
Adjustment Amount this credit memo, debit memo, or invoice
in transaction currency.
AIT-REVALUE-FL Alpha 1 AR560 AR97.1
Revalue This flag indicates whether this credit AR99.1 BL123
memo, debit memo, or invoice is subject BRIP.1
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
Number of Decimals Currency decimal indicator. BL123 BRIP.1
AIT-TERMS-CD Alpha 5 AR97.1 AR99.1
Terms Code Terms code for the credit memo, debit BL123 BRIP.1
memo, or invoice.
AIT-BANK-INST-CODE Alpha 3 AR97.1 AR99.1
Payment Code This is a user-defined value BL123 BRIP.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 15.2 AR97.1 AR99.1
Open Order Amount Order amount of an invoice, credit or BL123 BRIP.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
Discount Date Discount date of invoice. If entered it BL123 BRIP.1
will override the calculated discount
date of terms code.
AIT-DISC-PCT Percent 7.5 (Percent) AR97.1 AR99.1
Discount Percent Discount percent. If entered it will BL123 BRIP.1
override the discount percent of terms
code.
AIT-DUE-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Due Date The due date of the credit memo, debit BL123 BRIP.1
memo, or invoice. If entered it will
override the calculated due date of
terms code.
AIT-DISC-AMT Signed 15.2 AR97.1 AR99.1
Discount Amount Discount amount. If entered will BL123 BRIP.1
override the calculated discount amount
of terms code.
AIT-BILL-TO Numeric 4 AR97.1 AR99.1
Bill To The bill to location for the open item. BL123 BRIP.1
AIT-JRNL-BOOK-NBR Alpha 12 AR97.1 AR99.1
Journal Book Number The journal book assigned to the BL123 BRIP.1
transaction.
AIT-AUTO-APP-FL Alpha 1 AR97.1 AR99.1
Automatic Indicates if the credit memo is BL123 BRIP.1
Application Flag eligible for automatic memo application.
Valid values are:
N = No
Y = Yes
AIT-ACTIVITY Alpha 15 AR560 AR97.1
Activity The activity assigned to the AR99.1 BL123
transaction. BRIP.1
AIT-ACCT-CATEGORY Alpha 5 AR560 AR97.1
Account Category The account category assigned to the AR99.1 BL123
activity. BRIP.1
AIT-ALT-TYPE Alpha 1 AR560 AR97.1
Alt Type C = Credit Memo BL123 BRIP.1
D = Debit Memo
I = Invoice
AIT-SUM-LINE Alpha 1 AR97.1
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
System Code A two-character code representing an BL123 BRIP.1
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
AIT-INV-OBJ-ID Numeric 12
Inv Obj Id
AIT-USR-FLD-01 Alpha 20 AR97.1 AR99.1
Usr Fld 01
AIT-USR-FLD-02 Alpha 20 AR97.1 AR99.1
Usr Fld 02
AIT-USR-FLD-03 Alpha 20 AR97.1 AR99.1
Usr Fld 03
AIT-USR-FLD-04 Alpha 20 AR97.1 AR99.1
Usr Fld 04
AIT-USR-FLD-05 Alpha 20 AR97.1 AR99.1
Usr Fld 05
AIT-AC-CUSTOMER-ID Alpha 5 AR97.1 BL123
Ac Customer Id BRIP.1
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 BL00.1
BL01.1 BL121
BL123 BL200
BL201 BR11.1
BRIP.1 PHI3.1
AITSET3 COMPANY
SYSTEM
TRANS-TYPE
INVOICE
PAYMENT-SEQ
|
