|
|
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.1 (Conversion Obligation) 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.1 (Interface Transaction) to comply with the edit requirements of AR560.
REFERENCED BY
AC56.1 AC560 AR01.1 AR33.5 AR42.2 AR42.7
AR44.3 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 BL98.1 BR11.1 BR48.1 WH20.7
UPDATED BY
AR502 AR97.1 AR99.1 ARLL.1 AR560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIT-COMPANY Numeric 4 AR97.1 AR99.1
Element: Company The number representing an AR company. 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 Used 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 or 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 A transaction code representing a type ARLL.1
of cash payment (with atributes for
either receiving AP payments, or
creating EFT payments), bill of
exchange payment, or bank service
transaction.
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 AR97.1 AR99.1
Element: Discount AmounDiscount amount. If entered will 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: Acct Category The 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 A two-character code representing the ARLL.1
system of origin within the Lawson
system. (i.e. BR = Billing & Revenue).
AIT-INV-OBJ-ID Numeric 12
Element: Inv Obj Id
AIT-USR-FLD-01 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 01 First additional user field. ARLL.1
AIT-USR-FLD-02 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 02 Second additional user field. ARLL.1
AIT-USR-FLD-03 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 03 Third additional user field. ARLL.1
AIT-USR-FLD-04 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 04 Fourth additional user field. ARLL.1
AIT-USR-FLD-05 Alpha 20 AR97.1 AR99.1
Element: Usr Fld 05 Fifth additional user field. ARLL.1
AIT-AC-CUSTOMER-ID Alpha 5 AR97.1 ARLL.1
Element: Ac Customer IdUsed for Drill access from the AR system
to the BR system.
AIT-SORT-1 Alpha 32 (Lower Case) AR502 AR560
Element: Sort 1 The transaction User Sort 1 value, used AR97.1 AR99.1
for sorting purposes in cash application ARLL.1
and credit management inquiry.
AIT-SORT-2 Alpha 32 (Lower Case) AR502 AR560
Element: Sort 2 The transaction User Sort 2 value, used AR97.1 AR99.1
for sorting purposes in cash ARLL.1
application and credit management
inquiry.
AIT-SORT-3 Alpha 32 (Lower Case) AR502 AR560
Element: Sort 3 The transaction User Sort 3 value, used AR97.1 AR99.1
for sorting purposes in cash application ARLL.1
and credit management inquiry.
AIT-SORT-4 Alpha 32 (Lower Case) AR502 AR560
Element: Sort 4 The transaction User Sort 4 value, used AR97.1 AR99.1
for sorting purposes in cash ARLL.1
application and credit management
inquiry.
AIT-FOB-CODE Alpha 3 AR97.1
Element: Fob Code The user defined Free On Board Code.
AIT-PORT-CD Alpha 5 AR97.1
Element: Port Cd The Intrastat port code. Must be
defined in IN04.1 (Port Maintenance)
AIT-NOTC Alpha 2 AR560 AR97.1
Element: Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
AIT-STAT-PROC Alpha 6 AR97.1
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 AR560 AR97.1
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 AR560 AR97.1
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 AR560 AR97.1
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 AR560 AR97.1
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 AR97.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 AR97.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
AIT-CONTRACT Alpha 15
Element: Contract Activity Management contract.
AIT-ACTIVITY-GRP Alpha 15
Element: Activity Grp The activity group is the overall
project.
ARITRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AITSET1 COMPANY AR502 AR560
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AITSET2 COMPANY AC56.1 AC560
TRANS-TYPE AR01.1 AR33.5
INVOICE AR42.2 AR42.7
PAYMENT-SEQ AR44.3 AR502
AR560 AR97.1
AR97.2 AR99.1
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
...
|
