|
|
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 AR97.1 AR99.1 BRIP.1 BRPI.1 PBIP.1
AR560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIT-COMPANY Numeric 4 AR97.1 AR99.1
Element: Company Required. Transaction company number. BRIP.1 BRPI.1
PBIP.1
AIT-TRANS-TYPE Alpha 1 AR97.1 AR99.1
Element: Transaction TyRequired. Transaction type of open item BRIP.1 BRPI.1
record. Valid values are: PBIP.1
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. BRIP.1 BRPI.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
Element: Customer Required. Customer number. BRIP.1 BRPI.1
PBIP.1
AIT-STATUS Numeric 1 AR97.1 AR99.1
Element: Status Required. Status indicating where this BRIP.1 BRPI.1
record is in the processing flow. Valid PBIP.1
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 BRPI.1
Status records are to be posted to general PBIP.1
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 BRIP.1 BRPI.1
was selected for. YYYYMMDD format. PBIP.1
AIT-BATCH-NBR Numeric 6 AR97.1 AR99.1
Element: Batch Number Required. Identifies the batch the BRIP.1 BRPI.1
entered transaction belongs to. PBIP.1
AIT-PROCESS-LEVEL Alpha 5 AR97.1 AR99.1
Element: Process Level Required. The process level of this BRIP.1 BRPI.1
invoice, debit memo or credit memo. Must PBIP.1
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. BRIP.1 BRPI.1
YYYYMMDD format. PBIP.1
AIT-GL-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: General LedgerRequired. General Ledger posting date. BRIP.1 BRPI.1
PBIP.1
AIT-APPLIED-SEQ Numeric 5 AR99.1 BRIP.1
Element: Application SeApplication sequence for interfaced BRPI.1 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 BRPI.1
Date invoice or debit memo. YYYYMMDD format. PBIP.1
AIT-CUST-PO-NBR Alpha 22 AR97.1 AR99.1
Element: Customer PO NuCustomer purchase order number that BRIP.1 BRPI.1
relates to this credit memo, debit memo, PBIP.1
or invoice.
AIT-XREF-COMPANY Numeric 4 AR502 AR560
Cross Reference Cross reference company number. AR97.1 AR99.1
Company BRIP.1 BRPI.1
PBIP.1
AIT-XREF-TYPE Alpha 1 AR97.1 AR99.1
Element: Cross ReferencCross reference type indicator. This BRIP.1 BRPI.1
field is used with the cross reference PBIP.1
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 BRPI.1
Number invoice, debit memo or credit memo PBIP.1
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
Element: Description Description of invoice or reason for BRIP.1 BRPI.1
credit or debit memo. PBIP.1
AIT-AR-CODE Alpha 4 AR97.1 AR99.1
Accounts Receivable Accounts Receivable general ledger BRIP.1 BRPI.1
Code account code. The account specified by PBIP.1
this code will be credited during cash
application.
AIT-SALESMAN Numeric 4 AR97.1 AR99.1
Element: SalesRep The sales representative for this BRIP.1 BRPI.1
invoice, debit memo or credit memo. PBIP.1
AIT-TRANS-USER1 Alpha 10 AR97.1 AR99.1
Element: Transaction UsFirst user field. This field is used in BRIP.1 BRPI.1
record selection and record sorting. PBIP.1
AIT-TRANS-USER2 Alpha 15 AR97.1 AR99.1
Element: Transaction UsSecond user field. BRIP.1 BRPI.1
PBIP.1
AIT-TRANS-USER3 Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: Transaction UsThird user field. BRIP.1 BRPI.1
PBIP.1
AIT-TRANS-USER4 Numeric 9 AR97.1 AR99.1
Element: Transaction UsFourth user field. BRIP.1 BRPI.1
PBIP.1
AIT-TRANS-USER5 Signed 13.2 AR97.1 AR99.1
Element: Transaction UsFifth user field. BRIP.1 BRPI.1
PBIP.1
AIT-ORIG-CURRENCY Alpha 5 AR560 AR97.1
Element: Transaction CuCurrency in which the credit memo, AR99.1 BRIP.1
debit memo, or invoice was entered. BRPI.1 PBIP.1
AIT-ORIG-RATE Signed 12.6 AR560 AR97.1
Element: Exchange Rate The rate used to convert a transaction AR99.1 BRIP.1
amount from a non-base currency to the BRPI.1 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 BRPI.1 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
Element: Transaction AmRequired. Transaction amount in BRIP.1 BRPI.1
transaction currency of invoice, debit PBIP.1
memo or credit memo.
AIT-GROUP-RATE Signed 12.6 AR560 AR97.1
Element: Group Rate The group rate used to calculate AR99.1 BRIP.1
customer group balance updates. BRPI.1 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: BRPI.1 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 BRPI.1
Amount this credit memo, debit memo, or invoice PBIP.1
in transaction currency.
AIT-ORIG-ADJ-AMT Signed 15.2 AR97.1 AR99.1
Transaction Amount, if any, of all adjustments for BRIP.1 BRPI.1
Adjustment Amount this credit memo, debit memo, or invoice PBIP.1
in transaction currency.
AIT-REVALUE-FL Alpha 1 AR560 AR97.1
Element: Revalue This flag indicates whether this credit AR99.1 BRIP.1
memo, debit memo, or invoice is subject BRPI.1 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
Element: Number of DeciCurrency decimal indicator. BRIP.1 BRPI.1
PBIP.1
AIT-TERMS-CD Alpha 5 AR97.1 AR99.1
Element: Terms Code Terms code for the credit memo, debit BRIP.1 BRPI.1
memo, or invoice. PBIP.1
AIT-BANK-INST-CODE Alpha 3 AR97.1 AR99.1
Element: Payment Code This is a user-defined value BRIP.1 BRPI.1
representing a specific banking PBIP.1
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
Element: Open Order AmoOrder amount of an invoice, credit or BRIP.1 BRPI.1
debit memo. This amount will be PBIP.1
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 BRIP.1 BRPI.1
will override the calculated discount PBIP.1
date of terms code.
AIT-DISC-PCT Percent 7.5 (Percent) AR97.1 AR99.1
Element: Discount PerceDiscount percent. If entered it will BRIP.1 BRPI.1
override the discount percent of terms PBIP.1
code.
AIT-DUE-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Element: Due Date The due date of the credit memo, debit BRIP.1 BRPI.1
memo, or invoice. If entered it will PBIP.1
override the calculated due date of
terms code.
AIT-DISC-AMT Signed 15.2 AR560 AR97.1
Element: Discount AmounDiscount amount. If entered will AR99.1 BRIP.1
override the calculated discount amount BRPI.1 PBIP.1
of terms code.
AIT-BILL-TO Numeric 4 AR97.1 AR99.1
Element: Bill To The bill to location for the open item. BRIP.1 BRPI.1
PBIP.1
AIT-JRNL-BOOK-NBR Alpha 12 AR97.1 AR99.1
Element: Journal Book NThe journal book assigned to the BRIP.1 BRPI.1
transaction. PBIP.1
AIT-AUTO-APP-FL Alpha 1 AR97.1 AR99.1
Automatic Indicates if the credit memo is BRIP.1 BRPI.1
Application Flag eligible for automatic memo application. PBIP.1
Valid values are:
N = No
Y = Yes
AIT-ACTIVITY Alpha 15 AR560 AR97.1
Element: Activity The activity assigned to the AR99.1 BRIP.1
transaction. BRPI.1 PBIP.1
AIT-ACCT-CATEGORY Alpha 5 AR502 AR560
Element: Account CategoThe account category assigned to the AR97.1 AR99.1
activity. BRIP.1 BRPI.1
PBIP.1
AIT-ALT-TYPE Alpha 1 AR560 AR97.1
Element: Alt Type C = Credit Memo BRIP.1 BRPI.1
D = Debit Memo PBIP.1
I = Invoice
AIT-SUM-LINE Alpha 1 AR97.1
Element: All Flag 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 BRIP.1 BRPI.1
application used within the Lawson PBIP.1
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
AIT-USR-FLD-02 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 02
AIT-USR-FLD-03 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 03
AIT-USR-FLD-04 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 04
AIT-USR-FLD-05 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 05
AIT-AC-CUSTOMER-ID Alpha 5 AR97.1 BRIP.1
Element: Ac Customer Id BRPI.1 PBIP.1
AIT-SORT-1 Alpha 32 (Lower Case) AR97.1 AR99.1
Element: Sort 1 BRIP.1 BRPI.1
PBIP.1
AIT-SORT-2 Alpha 32 (Lower Case) AR97.1 AR99.1
Element: Sort 2 BRIP.1 BRPI.1
PBIP.1
AIT-SORT-3 Alpha 32 (Lower Case) AR97.1 AR99.1
Element: Sort 3 BRIP.1 BRPI.1
PBIP.1
AIT-SORT-4 Alpha 32 (Lower Case) AR97.1 AR99.1
Element: Sort 4 BRIP.1 BRPI.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 BRPI.1
PBIP.1 PHI3.1
WH20.7
AITSET3 COMPANY
SYSTEM
TRANS-TYPE
INVOICE
PAYMENT-SEQ
|
