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

AR01.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
AIT-COMPANY Element: Company	Numeric 4 The number representing an AR company.
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
AIT-INVOICE Element: Invoice	Alpha 22 Used to identify the invoice.
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.
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
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
AIT-LAST-STA-DATE Element: Last Statement Date	Numeric 8 (yyyymmdd) Date of last statement that this record was selected for. YYYYMMDD format.
AIT-BATCH-NBR Element: Batch Number	Numeric 6 Required. Identifies the batch the entered transaction belongs to.
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.
AIT-TRANS-DATE Element: Transaction Date	Numeric 8 (yyyymmdd) Required. Date of the transaction. YYYYMMDD format.
AIT-GL-DATE Element: General Ledger Date	Numeric 8 (yyyymmdd) Required. General Ledger posting date.
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.
AIT-CUST-PO-NBR Element: Customer PO Number	Alpha 22 Customer purchase order number that relates to this credit memo, debit memo, or invoice.
AIT-XREF-COMPANY Cross Reference Company	Numeric 4 Cross reference company number.
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
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.
AIT-XREF-PYMT-SEQ Element: Xref Pymt Seq	Numeric 6
AIT-DESC Element: Description	Alpha 30 (Lower Case) Description of invoice or reason for credit or debit memo.
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.
AIT-SALESMAN Element: SalesRep	Numeric 4 The sales representative for this invoice, debit memo or credit memo.
AIT-TRANS-USER1 Element: Transaction User 1	Alpha 10 First user field. This field is used in record selection and record sorting.
AIT-TRANS-USER2 Element: Transaction User 2	Alpha 15 Second user field.
AIT-TRANS-USER3 Element: Transaction User 3	Numeric 8 (yyyymmdd) Third user field.
AIT-TRANS-USER4 Element: Transaction User 4	Numeric 9 Fourth user field.
AIT-TRANS-USER5 Element: Transaction User 5	Signed 18.2 Fifth user field.
AIT-ORIG-CURRENCY Element: Transaction Currency	Alpha 5 Currency in which the credit memo, debit memo, or invoice was entered.
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.
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
AIT-ORIG-AMT Element: Transaction Amount	Signed 18.2 Required. Transaction amount in transaction currency of invoice, debit memo or credit memo.
AIT-GROUP-RATE Element: Group Rate	Signed 14.7 The group rate used to calculate customer group balance updates.
AIT-GROUP-MUDV Group Multiply/Divide	Alpha 1 The group currency multiplier or divider. Valid values are: D = Divide M = Multiply
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.
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.
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
AIT-ORIG-ND Element: Number of Decimals	Numeric 1 Currency decimal indicator.
AIT-TERMS-CD Element: Terms Code	Alpha 5 Terms code for the credit memo, debit memo, or invoice.
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.
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.
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.
AIT-DISC-PCT Element: Discount Percent	Percent 7.5 (Percent) Discount percent. If entered it will override the discount percent of terms code.
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.
AIT-DISC-AMT Element: Discount Amount	Signed 18.2 Discount amount. If entered will override the calculated discount amount of terms code.
AIT-BILL-TO Element: Bill To	Numeric 4 The bill to location for the open item.
AIT-JRNL-BOOK-NBR Element: Journal Book Number	Alpha 12 The journal book assigned to the transaction.
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
AIT-ACTIVITY Element: Activity	Alpha 15 The activity assigned to the transaction.
AIT-ACCT-CATEGORY Element: Acct Category	Alpha 5 The account category assigned to the activity.
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
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
AIT-SYSTEM Element: System	Alpha 2 A two-character code representing the system of origin within the Lawson system. (i.e. BR = Billing & Revenue).
AIT-INV-OBJ-ID Element: Inv Obj Id	Numeric 12
AIT-USR-FLD-01 Element: Usr Fld 01	Alpha 20 First additional user field.
AIT-USR-FLD-02 Element: Usr Fld 02	Alpha 20 Second additional user field.
AIT-USR-FLD-03 Element: Usr Fld 03	Alpha 20 Third additional user field.
AIT-USR-FLD-04 Element: Usr Fld 04	Alpha 20 Fourth additional user field.
AIT-USR-FLD-05 Element: Usr Fld 05	Alpha 20 Fifth additional user field.
AIT-AC-CUSTOMER-ID Element: Ac Customer Id	Alpha 5 Used for Drill access from the AR system to the BR system.
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.
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.
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.
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.
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

ARITRANS FILE INDEX

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