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 BR11.1 PHI3.1 WH20.7
UPDATED BY
AR502 AR560 AR97.1 AR99.1 BRIP.1 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIT-COMPANY Numeric 4 AR97.1 AR99.1
Company Required. Transaction company number. BRIP.1 PBIP.1
AIT-TRANS-TYPE Alpha 1 AR97.1 AR99.1
Transaction Type Required. Transaction type of open item BRIP.1 PBIP.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. BRIP.1 PBIP.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. BRIP.1 PBIP.1
AIT-STATUS Numeric 1 AR97.1 AR99.1
Status Required. Status indicating where this BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1 PBIP.1
was selected for. YYYYMMDD format.
AIT-BATCH-NBR Numeric 6 AR97.1 AR99.1
Batch Number Required. Identifies the batch the BRIP.1 PBIP.1
entered transaction belongs to.
AIT-PROCESS-LEVEL Alpha 5 AR97.1 AR99.1
Process Level Required. The process level of this BRIP.1 PBIP.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. BRIP.1 PBIP.1
YYYYMMDD format.
AIT-GL-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
General Ledger Date Required. General Ledger posting date. BRIP.1 PBIP.1
AIT-APPLIED-SEQ Numeric 5 AR99.1 BRIP.1
Application Sequence Application sequence for interfaced PBIP.1
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 BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1 PBIP.1
AIT-XREF-TYPE Alpha 1 AR97.1 AR99.1
Cross Reference Type Cross reference type indicator. This BRIP.1 PBIP.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 BRIP.1 PBIP.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 AR97.1
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 BRIP.1 PBIP.1
credit or debit memo.
AIT-AR-CODE Alpha 4 AR97.1 AR99.1
Accounts Receivable Accounts Receivable general ledger BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1 PBIP.1
record selection and record sorting.
AIT-TRANS-USER2 Alpha 15 AR97.1 AR99.1
Transaction User 2 Second user field. BRIP.1 PBIP.1
AIT-TRANS-USER3 Numeric 8 (yyyymmdd) AR97.1 AR99.1
Transaction User 3 Third user field. BRIP.1 PBIP.1
AIT-TRANS-USER4 Numeric 9 AR97.1 AR99.1
Transaction User 4 Fourth user field. BRIP.1 PBIP.1
AIT-TRANS-USER5 Signed 13.2 AR97.1 AR99.1
Transaction User 5 Fifth user field. BRIP.1 PBIP.1
AIT-ORIG-CURRENCY Alpha 5 AR560 AR97.1
Transaction Currency Currency in which the credit memo, AR99.1 BRIP.1
debit memo, or invoice was entered. PBIP.1
AIT-ORIG-RATE Signed 12.6 AR560 AR97.1
Exchange Rate The rate used to convert a transaction AR99.1 BRIP.1
amount from a non-base currency to the PBIP.1
company base currency.
AIT-CURR-MUDV Alpha 1 AR560 AR97.1
Currency Currency Multiplier or Divider. This is AR99.1 BRIP.1
Multiply/Divide used along with the currency rate to PBIP.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 BRIP.1 PBIP.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 BRIP.1
customer group balance updates. PBIP.1
AIT-GROUP-MUDV Alpha 1 AR560 AR97.1
Group The group currency multiplier or AR99.1 BRIP.1
Multiply/Divide divider. Valid values are: PBIP.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 BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1
memo, debit memo, or invoice is subject PBIP.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. BRIP.1 PBIP.1
AIT-TERMS-CD Alpha 5 AR97.1 AR99.1
Terms Code Terms code for the credit memo, debit BRIP.1 PBIP.1
memo, or invoice.
AIT-BANK-INST-CODE Alpha 3 AR97.1 AR99.1
Payment Code This is a user-defined value BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1 PBIP.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. BRIP.1 PBIP.1
AIT-JRNL-BOOK-NBR Alpha 12 AR97.1 AR99.1
Journal Book Number The journal book assigned to the BRIP.1 PBIP.1
transaction.
AIT-AUTO-APP-FL Alpha 1 AR97.1 AR99.1
Automatic Indicates if the credit memo is BRIP.1 PBIP.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 BRIP.1
transaction. PBIP.1
AIT-ACCT-CATEGORY Alpha 5 AR560 AR97.1
Account Category The account category assigned to the AR99.1 BRIP.1
activity. PBIP.1
AIT-ALT-TYPE Alpha 1 AR560 AR97.1
Alt Type C = Credit Memo BRIP.1 PBIP.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 BRIP.1 PBIP.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 BRIP.1
Ac Customer Id PBIP.1
AIT-SORT-1 Alpha 32 (Lower Case) AR97.1 AR99.1
Sort 1 BRIP.1 PBIP.1
AIT-SORT-2 Alpha 32 (Lower Case) AR97.1 AR99.1
Sort 2 BRIP.1 PBIP.1
AIT-SORT-3 Alpha 32 (Lower Case) AR97.1 AR99.1
Sort 3 BRIP.1 PBIP.1
AIT-SORT-4 Alpha 32 (Lower Case) AR97.1 AR99.1
Sort 4 BRIP.1 PBIP.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 BR11.1
BRIP.1 PBIP.1
PHI3.1 WH20.7
AITSET3 COMPANY
SYSTEM
TRANS-TYPE
INVOICE
PAYMENT-SEQ
|
