Acct Receivables 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
AC56.1 | AC560 | AR01.1 | AR09.1 | AR09.4 | AR10.1 |
AR11.1 | AR13.1 | AR13.2 | AR17.1 | AR210 | AR301 |
AR501 | AR550 | BR11.1 | BR48.1 | CB191 | TX140 |
WH20.2 | WH20.7 |
ARLL.1 | CB06.2 | AR12.1 | AR12.2 |
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 |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
ARO-DEST-COUNTRY Element: Dest Country | Alpha 2 |
|
||
ARO-ORIGIN-COUNTRY Element: Origin Country | Alpha 2 |
|
||
ARO-BILL-TO Element: Bill To | Numeric 4 |
|
||
ARO-FOR-ECON-CODE Element: Code | Alpha 10 |
|
||
ARO-TEMP-HOLD Element: Temp Hold | Alpha 1 A = Approved by Engine S = Sent for Approval |
|
||
ARO-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AROSET1 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ |
|
| ||||||||||||||||||||||||||||||
AROSET10 |
COMPANY CUSTOMER SORT-AMOUNT* TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||
AROSET11 |
COMPANY CUSTOMER CUST-PO-NBR TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||
AROSET12 |
COMPANY CUSTOMER TRANS-USER1 TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||
AROSET13 |
COMPANY CUSTOMER PROCESS-LEVEL TRANS-TYPE INVOICE PAYMENT-SEQ |
|
| ||||||||||||||||||||||||||||||
AROSET14 |
ACTIVITY STATUS TRANS-DATE COMPANY CUSTOMER TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||
AROSET2 |
COMPANY CUSTOMER DUE-DATE TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||
AROSET3 |
COMPANY CUSTOMER TRANS-TYPE INVOICE PAYMENT-SEQ |
|
| ||||||||||||||||||||||||||||||
AROSET4 |
COMPANY CUSTOMER TRANS-DATE TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||
AROSET5 |
COMPANY CUSTOMER TRANS-TYPE INVOICE PAYMENT-SEQ |
|
| ||||||||||||||||||||||||||||||
AROSET6 |
COMPANY CUSTOMER TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||
AROSET7 |
COMPANY CUSTOMER ACTIVITY TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||||||
AROSET8 |
COMPANY ALT-TYPE INVOICE PAYMENT-SEQ |
|
| ||||||||||||||||||||||||||||||
AROSET9 |
COMPANY TRANS-TYPE DUE-DATE INVOICE PAYMENT-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arapselect | ARAPSELECT |
Not Required
| ||||||||||||
Ararhuf | ARARHUF |
Not Required
| ||||||||||||
Arcomp | ARCOMP |
Required
| ||||||||||||
Arcustomer | ARCUSTOMER |
Required
| ||||||||||||
Aritemaud | ARITEMAUD |
Not Required
| ||||||||||||
Aroihdr | AROIHDR |
Required
| ||||||||||||
Arprlev | ARPROCLEVL |
Required
| ||||||||||||
Arsapplied | ARSAPPLIED |
Not Required
| ||||||||||||
Arusersort | ARUSERSORT |
Not Required
| ||||||||||||
Cbbankinst | CBBANKINST |
Required
| ||||||||||||
Custdesc | CUSTDESC |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Achisthdr | ACHISTHDR |
| |||||||||||||||||||||||||||
Acpmhsthdr | ACPMHSTHDR |
| |||||||||||||||||||||||||||
Aradjust | ARADJUST |
Delete Restricted
| |||||||||||||||||||||||||||
Arapplied | ARAPPLIED |
Delete Restricted
| |||||||||||||||||||||||||||
Ardispute | ARDISPUTE |
Delete Cascades
| |||||||||||||||||||||||||||
Arsadjust | ARSADJUST |
| |||||||||||||||||||||||||||
Crapplied | ARAPPLIED |
|
All trademarks and registered trademarks are the property of their
respective owners.