ARITRANS

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.
UPDATED BY
AC56.1 AC560 AR01.1 ARLL.1 BR11.1 BR48.1
WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIT-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ARLL.1
AIT-TRANS-TYPE
Element: Transaction Type
Alpha 1
Required. Transaction type of open item record. Valid values are: C = Credit Memo D = Debit Memo I = Invoice M = Mixed
ARLL.1
AIT-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
ARLL.1
AIT-PAYMENT-SEQ
Payment Sequence
Number
Numeric 6
Payment Sequence. This is the generated sequence number to separate individual payment requirements.
AIT-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Required. Customer number.
ARLL.1
AIT-STATUS
Element: Status
Numeric 1
Required. Status indicating where this record is in the processing flow. Valid values are: 1 = Open 7 = Fully applied 8 = Closed 9 = Historical
ARLL.1
AIT-GL-STATUS
General Ledger
Status
Numeric 1
Required. Specifies if distribution records are to be posted to general ledger. Valid values are: 2 = Distributions records to be posted 9 = Historical or nonexistent
ARLL.1
AIT-LAST-STA-DATE
Element: Last Statement Date
Numeric 8 (yyyymmdd)
Date of last statement that this record was selected for. YYYYMMDD format.
ARLL.1
AIT-BATCH-NBR
Element: Batch Number
Numeric 6
Required. Identifies the batch the entered transaction belongs to.
ARLL.1
AIT-PROCESS-LEVEL
Element: Process Level
Alpha 5
Required. The process level of this invoice, debit memo or credit memo. Must be an active process level and not restricted for this customer's invoice.
ARLL.1
AIT-TRANS-DATE
Element: Transaction Date
Numeric 8 (yyyymmdd)
Required. Date of the transaction. YYYYMMDD format.
ARLL.1
AIT-GL-DATE
Element: General Ledger Date
Numeric 8 (yyyymmdd)
Required. General Ledger posting date.
ARLL.1
AIT-APPLIED-SEQ
Element: Application Sequence
Numeric 7
Application sequence for interfaced invoice, debit memo or credit memo.
AIT-LAST-FC-DATE
Last Finance Charge
Date
Numeric 8 (yyyymmdd)
Last finance charge date for this invoice or debit memo. YYYYMMDD format.
ARLL.1
AIT-CUST-PO-NBR
Element: Customer PO Number
Alpha 22
Customer purchase order number that relates to this credit memo, debit memo, or invoice.
ARLL.1
AIT-XREF-COMPANY
Cross Reference
Company
Numeric 4
Cross reference company number.
ARLL.1
AIT-XREF-TYPE
Element: Cross Reference Type
Alpha 1
Cross reference type indicator. This field is used with the cross reference number field. Valid values are: D = Debit memo I = Invoice O = Other or Order Processing
ARLL.1
AIT-XREF-NBR
Cross Reference
Number
Alpha 22
Cross reference number that this invoice, debit memo or credit memo relates to. This field is used with the cross reference type field.
ARLL.1
AIT-XREF-PYMT-SEQ
Element: Xref Pymt Seq
Numeric 6
ARLL.1
AIT-DESC
Element: Description
Alpha 30 (Lower Case)
Description of invoice or reason for credit or debit memo.
ARLL.1
AIT-AR-CODE
Accounts Receivable
Code
Alpha 4
Accounts Receivable general ledger account code. The account specified by this code will be credited during cash application.
ARLL.1
AIT-SALESMAN
Element: SalesRep
Numeric 4
The sales representative for this invoice, debit memo or credit memo.
ARLL.1
AIT-TRANS-USER1
Element: Transaction User 1
Alpha 10
First user field. This field is used in record selection and record sorting.
ARLL.1
AIT-TRANS-USER2
Element: Transaction User 2
Alpha 15
Second user field.
ARLL.1
AIT-TRANS-USER3
Element: Transaction User 3
Numeric 8 (yyyymmdd)
Third user field.
ARLL.1
AIT-TRANS-USER4
Element: Transaction User 4
Numeric 9
Fourth user field.
ARLL.1
AIT-TRANS-USER5
Element: Transaction User 5
Signed 18.2
Fifth user field.
ARLL.1
AIT-ORIG-CURRENCY
Element: Transaction Currency
Alpha 5
Currency in which the credit memo, debit memo, or invoice was entered.
ARLL.1
AIT-ORIG-RATE
Element: Exchange Rate
Signed 14.7
The rate used to convert a transaction amount from a non-base currency to the company base currency.
ARLL.1
AIT-CURR-MUDV
Currency
Multiply/Divide
Alpha 1
Currency Multiplier or Divider. This is used along with the currency rate to compute the company base transaction amount. Valid values are: D = Divide M = Multiply
ARLL.1
AIT-ORIG-AMT
Element: Transaction Amount
Signed 18.2
Required. Transaction amount in transaction currency of invoice, debit memo or credit memo.
ARLL.1
AIT-GROUP-RATE
Element: Group Rate
Signed 14.7
The group rate used to calculate customer group balance updates.
ARLL.1
AIT-GROUP-MUDV
Group
Multiply/Divide
Alpha 1
The group currency multiplier or divider. Valid values are: D = Divide M = Multiply
ARLL.1
AIT-ORIG-APP-AMT
Transaction Applied
Amount
Signed 18.2
Amount, if any, of all applications for this credit memo, debit memo, or invoice in transaction currency.
ARLL.1
AIT-ORIG-ADJ-AMT
Transaction
Adjustment Amount
Signed 18.2
Amount, if any, of all adjustments for this credit memo, debit memo, or invoice in transaction currency.
ARLL.1
AIT-REVALUE-FL
Element: Revalue
Alpha 1
This flag indicates whether this credit 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
ARLL.1
AIT-ORIG-ND
Element: Number of Decimals
Numeric 1
Currency decimal indicator.
ARLL.1
AIT-TERMS-CD
Element: Terms Code
Alpha 5
Terms code for the credit memo, debit memo, or invoice.
ARLL.1
AIT-BANK-INST-CODE
Element: Payment Code
Alpha 3
A transaction code representing a type of cash payment (with atributes for either receiving AP payments, or creating EFT payments), bill of exchange payment, or bank service transaction.
ARLL.1
AIT-OPEN-ORDS
Element: Open Order Amount
Signed 18.2
Order amount of an invoice, credit or debit memo. This amount will be subtracted from the customer's open order amount.
ARLL.1
AIT-DISC-DATE
Element: Discount Date
Numeric 8 (yyyymmdd)
Discount date of invoice. If entered it will override the calculated discount date of terms code.
ARLL.1
AIT-DISC-PCT
Element: Discount Percent
Percent 7.5 (Percent)
Discount percent. If entered it will override the discount percent of terms code.
ARLL.1
AIT-DUE-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
The due date of the credit memo, debit memo, or invoice. If entered it will override the calculated due date of terms code.
ARLL.1
AIT-DISC-AMT
Element: Discount Amount
Signed 18.2
Discount amount. If entered will override the calculated discount amount of terms code.
ARLL.1
AIT-BILL-TO
Element: Bill To
Numeric 4
The bill to location for the open item.
ARLL.1
AIT-JRNL-BOOK-NBR
Element: Journal Book Number
Alpha 12
The journal book assigned to the transaction.
ARLL.1
AIT-AUTO-APP-FL
Automatic
Application Flag
Alpha 1
Indicates if the credit memo is eligible for automatic memo application. Valid values are: N = No Y = Yes
ARLL.1
AIT-ACTIVITY
Element: Activity
Alpha 15
The activity assigned to the transaction.
ARLL.1
AIT-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The account category assigned to the activity.
ARLL.1
AIT-ALT-TYPE
Element: Alt Type
Alpha 1
The transaction type of the associated transaction header record.
C = Credit Memo
D = Debit Memo
I = Invoice
ARLL.1
AIT-SUM-LINE
Element: Sum Line
Alpha 1
The field will determine if line items are displayed in detail or summary.
N = No
Y = Yes
ARLL.1
AIT-SYSTEM
Element: System
Alpha 2
A two-character code representing the system of origin within the Lawson system. (i.e. BR = Billing & Revenue).
ARLL.1
AIT-INV-OBJ-ID
Element: Inv Obj Id
Numeric 12
AIT-USR-FLD-01
Element: Usr Fld 01
Alpha 20
First additional user field.
ARLL.1
AIT-USR-FLD-02
Element: Usr Fld 02
Alpha 20
Second additional user field.
ARLL.1
AIT-USR-FLD-03
Element: Usr Fld 03
Alpha 20
Third additional user field.
ARLL.1
AIT-USR-FLD-04
Element: Usr Fld 04
Alpha 20
Fourth additional user field.
ARLL.1
AIT-USR-FLD-05
Element: Usr Fld 05
Alpha 20
Fifth additional user field.
ARLL.1
AIT-AC-CUSTOMER-ID
Element: Ac Customer Id
Alpha 5
Used for Drill access from the AR system to the BR system.
ARLL.1
AIT-SORT-1
Element: Sort 1
Alpha 32 (Lower Case)
The transaction User Sort 1 value, used for sorting purposes in cash application and credit management inquiry.
ARLL.1
AIT-SORT-2
Element: Sort 2
Alpha 32 (Lower Case)
The transaction User Sort 2 value, used for sorting purposes in cash application and credit management inquiry.
ARLL.1
AIT-SORT-3
Element: Sort 3
Alpha 32 (Lower Case)
The transaction User Sort 3 value, used for sorting purposes in cash application and credit management inquiry.
ARLL.1
AIT-SORT-4
Element: Sort 4
Alpha 32 (Lower Case)
The transaction User Sort 4 value, used for sorting purposes in cash application and credit management inquiry.
ARLL.1
AIT-FOB-CODE
Element: Fob Code
Alpha 3
The user defined Free On Board Code.
AIT-PORT-CD
Element: Port Cd
Alpha 5
The Intrastat port code. Must be defined in IN04.1 (Port Maintenance)
AIT-NOTC
Element: Notc
Alpha 2
The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
AIT-STAT-PROC
Element: Stat Proc
Alpha 6
The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).
AIT-ORIGIN-COUNTRY
Element: Origin Country
Alpha 2
The country from which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance)
AIT-DEST-COUNTRY
Element: Dest Country
Alpha 2
The country to which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance).
AIT-ORIGIN-REGION
Element: Origin Region
Alpha 2
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
Element: Dest Region
Alpha 2
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
Element: Drop Ship Ind
Alpha 1
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
Element: Transport Mode
Alpha 1
The 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
Element: Contract
Alpha 15
Activity Management contract.
AIT-ACTIVITY-GRP
Element: Activity Grp
Alpha 15
The activity group is the overall project.
AIT-REASON-CODE
Element: Reason Code
Alpha 4
ARLL.1


ARITRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AITSET1 COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AITSET2 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AC56.1 AC560
AR01.1 ARLL.1
BR11.1 BR48.1
WH20.2 WH20.7


File created: Thu Jun 09 11:09:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.