AR Transaction

The open items transaction file contains open item records consisting of one of three types of transactions; credits (Transaction Type "C"), debits (Transaction Type "D") or invoices (Transaction Type "I"). Records in this file may be unapplied, partially applied or fully applied. Historical transactions remain in this file.

REFERENCED BY

CB191

UPDATED BY

CB06.2

AR01.1

AR12.1

AR12.2

AR10.1

AR301

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ARO-COMPANY Element: Company	Numeric 4 The number representing an AR company.
ARO-TRANS-TYPE Element: Transaction Type	Alpha 1 Indicates the type of transaction. Valid values are: C = Credit Memo D = Debit Memo I = Invoice
ARO-INVOICE Element: Invoice	Alpha 22 Used to identify the invoice.
ARO-PAYMENT-SEQ Element: Payment Sequence	Numeric 6 Sequence number used for record uniqueness. This number may relate to an invoice line number, payment schedule, line sub grouping, or many other examples. Based on the terms of sale, this field is used as a counter to keep track of multiple payment obligations. Example - a sale of a $50,000 item: Customer to pay 10,000 at the end of the first month, 30,000 the second month, and 10,000 the third month. Thus, three open item records would be created. This field would be used to keep the three obligations unique.
ARO-CUSTOMER Element: Customer	Alpha 9 (Right Justified) The customer number representing a unique customer number.
ARO-STATUS Element: Status	Numeric 1 The status indicating where this record is in the processing flow. Valid values are: 0 = Unreleased transaction (Batch entry) 1 = Open transaction 2 = Select for BOE Application 5 = Application by BOE AcAct = N 6 = Application by BOE AcAct = Y 7 = Fully applied transaction 8 = Closed transaction 9 = Historical transaction	CB06.2
ARO-LAST-STA-DATE Element: Last Statement Date	Numeric 8 (yyyymmdd) The date of the last statement that listed this transaction.
ARO-TRANS-DATE Element: Transaction Date	Numeric 8 (yyyymmdd) The date assigned to the transaction.
ARO-TRAN-AMT Element: Transaction Amount	Signed 18.2 The transaction amount in the company base currency.
ARO-APPLD-AMT Element: Applied Amount	Signed 18.2 The total amount applied to the transaction in the company base currency.	CB06.2
ARO-APPLIED-SEQ Element: Application Sequence	Numeric 7 Number of applications made for this open item.
ARO-ADJ-AMT Element: Adjustment Amount	Signed 18.2 The total amount of adjustments that have been made against the transaction.	CB06.2
ARO-DISPUTE-SEQ Element: Dispute Sequence	Numeric 3 The number of dispute records for this open item.
ARO-DUE-DATE Element: Due Date	Numeric 8 (yyyymmdd) The due date of the open item.
ARO-LAST-FC-DATE Last Finance Charge Date	Numeric 8 (yyyymmdd) The date of the last finance charge calculation for this open item.
ARO-DISC-DATE Element: Discount Date	Numeric 8 (yyyymmdd) Occurs 3 Times The discount date of the open item.
ARO-DISC-PCT Element: Discount Percent	Percent 7.5 (Percent) Occurs 3 Times Discount percent.
ARO-DISC-PCT1 Element: Disc Pct1	Derived Redefinition of discount percent occurs value one; for use in the discount one compute amount field.
ARO-DISC-PCT2 Element: Disc Pct2	Derived Redefinition of discount percent occurs two field; for use in the discount two compute amount field.
ARO-DISC-PCT3 Element: Disc Pct3	Derived Redefinition of discount percent occurs value three; for use in the discount three compute amount field.
ARO-ORIG-AMT Element: Transaction Amount	Signed 18.2 The original transaction amount for the records. This amount will converted to the company base currency for a non-base currency transaction.
ARO-ORIG-APP-AMT Transaction Applied Amount	Signed 18.2 Payment amount. The amount applied to the open item in the currency of the transaction.	CB06.2
ARO-ORIG-ADJ-AMT Transaction Adjust Amount	Signed 18.2 Transaction adjustment amount. The amount of the open item that has been adjusted in the transaction currency of the open item.	CB06.2
ARO-OPEN-AMOUNT Element: Open Amount	Derived This field is used as a compute field to calculate open amount. No data is stored in this field. Please refer to the Universe documentation for more information on compute fields.
ARO-APPL-DISP Element: Application Amount	Derived Derived indicator for application amount existing.
ARO-DISC-AMT1 Element: Disc Amt1	Derived Derived value for discount amount one.
ARO-DISC-AMT2 Element: Disc Amt2	Derived Derived value for discount amount two.
ARO-DISC-AMT3 Element: Disc Amt3	Derived Derived value for discount amount three.
ARO-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description of the transaction.
ARO-ITEM-USER1 Element: Line Item User 1	Alpha 20 The User 1 value associated with the line item.
ARO-ACTIVITY Element: Activity	Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
ARO-ACCT-CATEGORY Element: Account Category	Alpha 5 The account category assigned to the activity.
ARO-LINE-NBR Element: Line Item Number	Numeric 6 This field contains the line number.
ARO-LINE-TYPE Element: Inventory Type	Alpha 1 Indicates the Billing system line type of the line item. Valid values are Blank = Non-Lawson BL generated A = Add on charges item I = Inventoried item N = Non stock item X = Special order item
ARO-LINE-SEQ Line Item Sequence Number	Numeric 3 The sequence number of the Billing system transaction's line item.
ARO-ITEM Element: Item Number	Alpha 32 This field contains the item identifier.
ARO-EFT-NOTE Element: Status of EFT Notice	Numeric 1 Indicates the status of the EFT note. Valid values are: 0 = Prenote not sent 1 = Prenote sent 2 = Final note sent 9 = Note printed
ARO-EFT-EXTRACT Status of EFT Extract	Numeric 1 Indicates the status of an EFT adjustment. Valid values are: 0 = Not extracted 8 = Adjustment made 9 = Extracted
ARO-EFT-ACTION Element: EFT Action	Alpha 1 Indicates the action taken on an EFT transaction. Valid values are: Blank = Not within due date range 0 = Eligible 1 = Added 2 = Postponed 3 = Deleted 5 = Added postponed 6 = Hold
ARO-GAINLOS-AMT Element: Intl Amt	Signed 18.2 The amount of gain or loss from the last run of the Unrealized Gain Loss Report.
ARO-ALT-TYPE Element: Alt Type	Alpha 1 The transaction type of the associated transaction header record. C = Credit Memo D = Debit Memo I = Invoice M = Mixed
ARO-AR-CUST-PO-NBR Element: Ar Cust Po Nbr	Derived String field to derive purchase order number.
ARO-AR-TERM Element: Ar Term	Derived String field to derive terms code value.
ARO-HIST-PER Element: Hist Per	Numeric 2 The number of updates from being processed by AR198 Transaction Status Update.	CB06.2
ARO-INVL-OBJ-ID Element: Invl Obj Id	Numeric 12
ARO-CUST-PO-NBR Element: Cust Po Nbr	Alpha 22 The customer purchase order number.
ARO-TRANS-USER1 Element: Trans User1	Alpha 10 User-defined field 1. Can be used as a selection criteria or for sorting in the Lawson Accounts Receivable system. Primarily used as an open item sort within cash aplication.
ARO-PROCESS-LEVEL Element: Process Level	Alpha 5 This field contains the process level, which is the reporting hierarchy below company.
ARO-SORT-AMOUNT Element: Sort Amount	Numeric 17	CB06.2
ARO-BANK-INST-CODE Element: 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.
ARO-BANK-INST-TYPE Element: Bank Inst Type	Alpha 1 Payment code. Indicates the payment type. Valid values are: C = Cash D = Bill of Exchange
ARO-SORT-1 Element: Sort 1	Alpha 32 (Lower Case) User sort 1 field used in cash application and credit manangement inquiry.
ARO-SORT-2 Element: Sort 2	Alpha 32 (Lower Case) User sort 2 field used in cash application and credit manangement inquiry.
ARO-SORT-3 Element: Sort 3	Alpha 32 (Lower Case) User sort 2 field used in cash application and credit manangement inquiry.
ARO-SORT-4 Element: Sort 4	Alpha 32 (Lower Case) User sort 2 field used in cash application and credit manangement inquiry.
ARO-ORIG-CURRENCY Element: Orig Currency	Alpha 5 Transaction currency. The currency in which the transaction was added to the system.
ARO-ORIG-ND Element: Acct Nd	Numeric 1 The number of decimals defined for the transaction currency in the Lawson Currency system.
ARO-ORIG-RATE Element: Orig Rate	Signed 14.7 The currency exchange rate used to convert a non-base currency transaction amount to the company base currency. The rate is maintained in the Lawson Currency system, and an option exists at the company level to override the rate at entry time.
ARO-BATCH-NBR Element: Batch Nbr	Numeric 6 The batch number associated with the invoice or debit memo.
ARO-CURR-MUDV Element: Curr Mudv	Alpha 1 The currency multiplier or divider. Mathematical technique used in conjunction with the currency exchange rate to convert a non-base currency transaction amount to the company base currency.
ARO-SUM-LINE Element: Sum Line	Alpha 1 N = No Y = Yes
ARO-GL-DATE Element: Gl Date	Numeric 8 (yyyymmdd) The general ledger posting date assigned to the invoice or debit memo.
ARO-AR-CODE Element: Ar Code	Alpha 4 The accounts receivable code that identifies the accounts receivable general ledger account for this transaction. The general ledger account that this code represents will be credited during cash application.
ARO-REVALUE-FL Element: Revalue Fl	Alpha 1 Indicates whether this invoice or debit memo is subject to revaluation if its currency differs from the company currency. Valid values are: N = No - Do not revalue Y = Yes - Revalue
ARO-CANCEL-FLAG Element: Cancel Flag	Alpha 1
ARO-DESC Element: Description	Alpha 30 (Lower Case) Free text description or reason for invoice, debit memo, or credit memo.
ARO-GROUP-RATE Element: Group Rate	Signed 14.7 The currency exchange rate used to convert a transaction amount from a currency that differs from the customer group currency to the customer group currency.
ARO-GROUP-MUDV Element: Group Mudv	Alpha 1 The currency multiplier or divider. Mathematical technique used in conjunction with the currency exchange rate to convert a non-base currency transaction amount to the customer group currency.
ARO-SALESMAN Element: Salesman	Numeric 4 Sales representative for this invoice or debit memo.
ARO-XREF-COMPANY Element: Company	Numeric 4 The cross reference company of the cross referenced transaction.
ARO-XREF-TYPE Element: Xref Type	Alpha 1 This will identify what type of item is being cross referenced. This will work with the cross reference number field. Valid values are: C = Credit Memo D = Debit Mmeo I = Invoice O = Other
ARO-XREF-NBR Element: Xref Nbr	Alpha 22 The Cross Reference Number field is an informational field that can be used when entering an invoice or debit memo to cross reference a particular record. It could also be used for example, as the order entry order number for this invoice or debit memo.
ARO-ORIG-CODE Element: Orig Code	Alpha 1 Identifies where the transaction originated. Valid values are: B = AR generated invoice (AR42) C = Chargeback (Memo) F = Finance charges L = Converted records (Lawson) M = Memo (AR40) O = External Order Entry R = Returned Payment G = Grouping E = Chargebacks (Summary/Detail)
ARO-TERMS-CD Element: Term Code	Alpha 5 Terms code for this invoice, or debit memo, or credit memo. Must be a valid terms code.
ARO-AC-CUSTOMER-ID Element: Ac Customer Id	Alpha 5 This field enables a link to BR-created transactions and is used in Drill views.
ARO-ADJ-FL Element: Flag1	Alpha 1 If the field = Y, activity and acct category cannot be entered on the aradjust record.
ARO-LATE-CH-FL Element: Late Ch Fl	Alpha 1 Late Charge Flag. Indicate if late charge is to be applied to the invoice.
ARO-LST-DUNLTR-STM Element: Lst Dunltr Stm	Numeric 2 Level of the last dunning letter sent.
ARO-LAST-LTR-DATE Element: Last Ltr Date	Numeric 8 (yyyymmdd) Date last dunning letter was sent for the invoice.
ARO-LST-LTRTEXT-CD Element: Lst Ltrtext Cd	Alpha 6 Text Code for last Dunning Letter sent on this invoice.
ARO-SENT-FOR-COLL Element: Sent For Coll	Alpha 1 Sent for collection. This indicates whether the invoice has been sent for collection (Yes or No).
ARO-ASSESS-DUN-FEE Element: Assess Dun Fee	Alpha 1 Specifies whether to assess a dunning letter fee.
ARO-DUN-LTR-IND Element: Dun Ltr Ind	Alpha 1 Specifies whether the advanced dunning letter process is to be used.
ARO-ORIG-DISC-AMT Element: Intl Amt	Signed 18.2 Occurs 3 Times
ARO-CONTRACT Element: Contract	Alpha 15 Activity Management contract.
ARO-ACTIVITY-GRP Element: Activity Grp	Alpha 15 The activity group is the overall project.
ARO-NA-LST-ST-DATE Element: Na Lst St Date	Numeric 8 (yyyymmdd)
ARO-REASON-CODE Element: Reason Code	Alpha 4
ARO-GRANT Element: Grant	Alpha 30

AROITEMS FILE INDEX

AROITEMS FILE RELATIONS

ONE TO ONE RELATIONS

AROITEMS FILE RELATIONS

ONE TO MANY RELATIONS

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