ARITRANS – AR Interface Transaction

System: Accounts Receivable (AR)
Prefix: AIT
Primary key: COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ
Fields: 78
Updated by: 1 program
Referenced by: 7 programs

ARITRANS is the AR Interface Transaction table in Lawson Accounts Receivable (prefix AIT). It is indexed by COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ (AITSET1); alternate indexes: AITSET2. It is updated by ARLL.1 and referenced by AC56.1, AC560, AR01.1, BR11.1, BR48.1, WH20.2 and WH20.7. The table has 78 fields, 2 indexes and 0 documented relations.

About ARITRANS

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.

Fields (78)

Column = COBOL field name without the AIT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`AIT-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	ARLL.1
`AIT-TRANS-TYPE` PK TRANS_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` PK INVOICE	Alpha 22	Used to identify the invoice.	ARLL.1
`AIT-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	Payment Sequence. This is the generated sequence number to separate individual payment requirements.	—
`AIT-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	Required. Customer number.	ARLL.1
`AIT-STATUS` 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` GL_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` LAST_STA_DATE	Numeric 8 (yyyymmdd)	Date of last statement that this record was selected for. YYYYMMDD format.	ARLL.1
`AIT-BATCH-NBR` BATCH_NBR	Numeric 6	Required. Identifies the batch the entered transaction belongs to.	ARLL.1
`AIT-PROCESS-LEVEL` 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` TRANS_DATE	Numeric 8 (yyyymmdd)	Required. Date of the transaction. YYYYMMDD format.	ARLL.1
`AIT-GL-DATE` GL_DATE	Numeric 8 (yyyymmdd)	Required. General Ledger posting date.	ARLL.1
`AIT-APPLIED-SEQ` APPLIED_SEQ	Numeric 7	Application sequence for interfaced invoice, debit memo or credit memo.	—
`AIT-LAST-FC-DATE` LAST_FC_DATE	Numeric 8 (yyyymmdd)	Last finance charge date for this invoice or debit memo. YYYYMMDD format.	ARLL.1
`AIT-CUST-PO-NBR` CUST_PO_NBR	Alpha 22	Customer purchase order number that relates to this credit memo, debit memo, or invoice.	ARLL.1
`AIT-XREF-COMPANY` XREF_COMPANY	Numeric 4	Cross reference company number.	ARLL.1
`AIT-XREF-TYPE` XREF_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` XREF_NBR	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` XREF_PYMT_SEQ	Numeric 6	—	ARLL.1
`AIT-DESC` DESC	Alpha 30 (Lower Case)	Description of invoice or reason for credit or debit memo.	ARLL.1
`AIT-AR-CODE` AR_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` SALESMAN	Numeric 4	The sales representative for this invoice, debit memo or credit memo.	ARLL.1
`AIT-TRANS-USER1` TRANS_USER1	Alpha 10	First user field. This field is used in record selection and record sorting.	ARLL.1
`AIT-TRANS-USER2` TRANS_USER2	Alpha 15	Second user field.	ARLL.1
`AIT-TRANS-USER3` TRANS_USER3	Numeric 8 (yyyymmdd)	Third user field.	ARLL.1
`AIT-TRANS-USER4` TRANS_USER4	Numeric 9	Fourth user field.	ARLL.1
`AIT-TRANS-USER5` TRANS_USER5	Signed 18.2	Fifth user field.	ARLL.1
`AIT-ORIG-CURRENCY` ORIG_CURRENCY	Alpha 5	Currency in which the credit memo, debit memo, or invoice was entered.	ARLL.1
`AIT-ORIG-RATE` ORIG_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` CURR_MUDV	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` ORIG_AMT	Signed 18.2	Required. Transaction amount in transaction currency of invoice, debit memo or credit memo.	ARLL.1
`AIT-GROUP-RATE` GROUP_RATE	Signed 14.7	The group rate used to calculate customer group balance updates.	ARLL.1
`AIT-GROUP-MUDV` GROUP_MUDV	Alpha 1	The group currency multiplier or divider. Valid values are: `D` Divide `M` Multiply	ARLL.1
`AIT-ORIG-APP-AMT` ORIG_APP_AMT	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` ORIG_ADJ_AMT	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` REVALUE_FL	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` ORIG_ND	Numeric 1	Currency decimal indicator.	ARLL.1
`AIT-TERMS-CD` TERMS_CD	Alpha 5	Terms code for the credit memo, debit memo, or invoice.	ARLL.1
`AIT-BANK-INST-CODE` BANK_INST_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` OPEN_ORDS	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` DISC_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` DISC_PCT	Percent 7.5 (Percent)	Discount percent. If entered it will override the discount percent of terms code.	ARLL.1
`AIT-DUE-DATE` 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` DISC_AMT	Signed 18.2	Discount amount. If entered will override the calculated discount amount of terms code.	ARLL.1
`AIT-BILL-TO` BILL_TO	Numeric 4	The bill to location for the open item.	ARLL.1
`AIT-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the transaction.	ARLL.1
`AIT-AUTO-APP-FL` AUTO_APP_FL	Alpha 1	Indicates if the credit memo is eligible for automatic memo application. Valid values are: `N` No `Y` Yes	ARLL.1
`AIT-ACTIVITY` ACTIVITY	Alpha 15	The activity assigned to the transaction.	ARLL.1
`AIT-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category assigned to the activity.	ARLL.1
`AIT-ALT-TYPE` 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` 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` 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` INV_OBJ_ID	Numeric 12	—	—
`AIT-USR-FLD-01` USR_FLD_01	Alpha 20	First additional user field.	ARLL.1
`AIT-USR-FLD-02` USR_FLD_02	Alpha 20	Second additional user field.	ARLL.1
`AIT-USR-FLD-03` USR_FLD_03	Alpha 20	Third additional user field.	ARLL.1
`AIT-USR-FLD-04` USR_FLD_04	Alpha 20	Fourth additional user field.	ARLL.1
`AIT-USR-FLD-05` USR_FLD_05	Alpha 20	Fifth additional user field.	ARLL.1
`AIT-AC-CUSTOMER-ID` AC_CUSTOMER_ID	Alpha 5	Used for Drill access from the AR system to the BR system.	ARLL.1
`AIT-SORT-1` 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` 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` 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` 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` FOB_CODE	Alpha 3	The user defined Free On Board Code.	—
`AIT-PORT-CD` PORT_CD	Alpha 5	The Intrastat port code. Must be defined in IN04.1 (Port Maintenance)	—
`AIT-NOTC` NOTC	Alpha 2	The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).	—
`AIT-STAT-PROC` 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` 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` DEST_COUNTRY	Alpha 2	The country to which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance).	ARLL.1
`AIT-ORIGIN-REGION` 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` 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` 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` 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` CONTRACT	Alpha 15	Activity Management contract.	—
`AIT-ACTIVITY-GRP` ACTIVITY_GRP	Alpha 15	The activity group is the overall project.	—
`AIT-REASON-CODE` REASON_CODE	Alpha 4	—	ARLL.1
`AIT-FOR-ECON-CODE` FOR_ECON_CODE	Alpha 10	—	—
`AIT-GLBL-DOC-TYPE` GLBL_DOC_TYPE	Alpha 10	—	—

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`AITSET1`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	Primary		—
`AITSET2`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`			AC56.1, AC560, AR01.1, ARLL.1, BR11.1, BR48.1, WH20.2, WH20.7

Programs

Updated by (1)

ARLL.1 AR Transaction Interface

Referenced by (7)

AC56.1 Setup Interface Adjustment
AC560 Setup Interface
AR01.1 Company
BR11.1 Customer
BR48.1 Customer Template
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location