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 | BR11.1 | BR48.1 | WH20.2 |
WH20.7 |
ARLL.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 |
|
||
AIT-FOR-ECON-CODE Element: Code | Alpha 10 |
|
||
AIT-GLBL-DOC-TYPE Element: Glbl Doc Type | Alpha 10 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AITSET1 |
COMPANY CUSTOMER TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||
AITSET2 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|
All trademarks and registered trademarks are the property of their
respective owners.