AROITEMS

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
AC56.1 AC560 AR01.1 AR10.1 AR12.1 AR12.2
AR301 ARLL.1 BR11.1 BR48.1 CB06.2 WH20.2
WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARO-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ARLL.1
ARO-TRANS-TYPE
Element: Transaction Type
Alpha 1
Indicates the type of transaction. Valid values are: C = Credit Memo D = Debit Memo I = Invoice
ARLL.1
ARO-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
ARLL.1
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.
ARLL.1
ARO-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
The customer number representing a unique customer number.
ARLL.1
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
ARLL.1 CB06.2
ARO-LAST-STA-DATE
Element: Last Statement Date
Numeric 8 (yyyymmdd)
The date of the last statement that listed this transaction.
ARLL.1
ARO-TRANS-DATE
Element: Transaction Date
Numeric 8 (yyyymmdd)
The date assigned to the transaction.
ARLL.1
ARO-TRAN-AMT
Element: Transaction Amount
Signed 18.2
The transaction amount in the company base currency.
ARLL.1
ARO-APPLD-AMT
Element: Applied Amount
Signed 18.2
The total amount applied to the transaction in the company base currency.
ARLL.1 CB06.2
ARO-APPLIED-SEQ
Element: Application Sequence
Numeric 7
Number of applications made for this open item.
ARLL.1
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.
ARLL.1
ARO-LAST-FC-DATE
Last Finance Charge
Date
Numeric 8 (yyyymmdd)
The date of the last finance charge calculation for this open item.
ARLL.1
ARO-DISC-DATE
Element: Discount Date
Numeric 8 (yyyymmdd) Occurs 3 Times
The discount date of the open item.
ARLL.1
ARO-DISC-PCT
Element: Discount Percent
Percent 7.5 (Percent) Occurs 3 Times
Discount percent.
ARLL.1
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.
ARLL.1
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.
ARLL.1 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.
ARLL.1
ARO-ITEM-USER1
Element: Line Item User 1
Alpha 20
The User 1 value associated with the line item.
ARLL.1
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.
ARLL.1
ARO-ACCT-CATEGORY
Element: Account Category
Alpha 5
The account category assigned to the activity.
ARLL.1
ARO-LINE-NBR
Element: Line Item Number
Numeric 6
This field contains the line number.
ARLL.1
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
ARLL.1
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.
ARLL.1
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
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARO-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
ARLL.1
ARO-SORT-AMOUNT
Element: Sort Amount
Numeric 17
ARLL.1 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.
ARLL.1
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
ARLL.1
ARO-SORT-1
Element: Sort 1
Alpha 32 (Lower Case)
User sort 1 field used in cash application and credit manangement inquiry.
ARLL.1
ARO-SORT-2
Element: Sort 2
Alpha 32 (Lower Case)
User sort 2 field used in cash application and credit manangement inquiry.
ARLL.1
ARO-SORT-3
Element: Sort 3
Alpha 32 (Lower Case)
User sort 2 field used in cash application and credit manangement inquiry.
ARLL.1
ARO-SORT-4
Element: Sort 4
Alpha 32 (Lower Case)
User sort 2 field used in cash application and credit manangement inquiry.
ARLL.1
ARO-ORIG-CURRENCY
Element: Orig Currency
Alpha 5
Transaction currency. The currency in which the transaction was added to the system.
ARLL.1
ARO-ORIG-ND
Element: Acct Nd
Numeric 1
The number of decimals defined for the transaction currency in the Lawson Currency system.
ARLL.1
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.
ARLL.1
ARO-BATCH-NBR
Element: Batch Nbr
Numeric 6
The batch number associated with the invoice or debit memo.
ARLL.1
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.
ARLL.1
ARO-SUM-LINE
Element: Sum Line
Alpha 1

N = No
Y = Yes
ARLL.1
ARO-GL-DATE
Element: Gl Date
Numeric 8 (yyyymmdd)
The general ledger posting date assigned to the invoice or debit memo.
ARLL.1
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.
ARLL.1
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
ARLL.1
ARO-CANCEL-FLAG
Element: Cancel Flag
Alpha 1
ARLL.1
ARO-DESC
Element: Description
Alpha 30 (Lower Case)
Free text description or reason for invoice, debit memo, or credit memo.
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARO-SALESMAN
Element: Salesman
Numeric 4
Sales representative for this invoice or debit memo.
ARLL.1
ARO-XREF-COMPANY
Element: Company
Numeric 4
The cross reference company of the cross referenced transaction.
ARLL.1
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
ARLL.1
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.
ARLL.1
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)
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARO-ADJ-FL
Element: Flag1
Alpha 1
If the field = Y, activity and acct category cannot be entered on the aradjust record.
ARLL.1
ARO-LATE-CH-FL
Element: Late Ch Fl
Alpha 1
Late Charge Flag. Indicate if late charge is to be applied to the invoice.
ARLL.1
ARO-LST-DUNLTR-STM
Element: Lst Dunltr Stm
Numeric 2
Level of the last dunning letter sent.
ARLL.1
ARO-LAST-LTR-DATE
Element: Last Ltr Date
Numeric 8 (yyyymmdd)
Date last dunning letter was sent for the invoice.
ARLL.1
ARO-LST-LTRTEXT-CD
Element: Lst Ltrtext Cd
Alpha 6
Text Code for last Dunning Letter sent on this invoice.
ARLL.1
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).
ARLL.1
ARO-ASSESS-DUN-FEE
Element: Assess Dun Fee
Alpha 1
Specifies whether to assess a dunning letter fee.
ARLL.1
ARO-DUN-LTR-IND
Element: Dun Ltr Ind
Alpha 1
Specifies whether the advanced dunning letter process is to be used.
ARLL.1
ARO-ORIG-DISC-AMT
Element: Intl Amt
Signed 18.2 Occurs 3 Times
ARLL.1
ARO-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
ARLL.1
ARO-ACTIVITY-GRP
Element: Activity Grp
Alpha 15
The activity group is the overall project.
ARLL.1
ARO-NA-LST-ST-DATE
Element: Na Lst St Date
Numeric 8 (yyyymmdd)
ARO-REASON-CODE
Element: Reason Code
Alpha 4
ARLL.1
ARO-GRANT
Element: Grant
Alpha 30
ARLL.1


AROITEMS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AROSET1 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange
AC56.1 AC560
AR01.1 ARLL.1
BR11.1 BR48.1
CB06.2 CB191
WH20.2 WH20.7
AROSET10 COMPANY
CUSTOMER
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS =1
AROSET11 COMPANY
CUSTOMER
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS =1
AROSET12 COMPANY
CUSTOMER
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS =1
AROSET13 COMPANY
CUSTOMER
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS =1
ARLL.1
AROSET14 ACTIVITY
STATUS
TRANS-DATE
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange
AROSET2 COMPANY
CUSTOMER
DUE-DATE
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS =1
OrSTATUS =2
AROSET3 COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS =1
AR12.1 AR12.2
ARLL.1
AROSET4 COMPANY
CUSTOMER
TRANS-DATE
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS >Zeroes
AndSTATUS <9
AROSET5 COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange
AR10.1 AR301
ARLL.1
AROSET6 COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS >Zeroes
AndSTATUS <9
AROSET7 COMPANY
CUSTOMER
ACTIVITY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS =1
AROSET8 COMPANY
ALT-TYPE
INVOICE
PAYMENT-SEQ
KeyChange
ARLL.1
AROSET9 COMPANY
TRANS-TYPE
DUE-DATE
INVOICE
PAYMENT-SEQ
KeyChange, Subset
WhereSTATUS =1


AROITEMS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arapselect ARAPSELECT Not Required
ARO-COMPANY->AAI-COMPANY (AAISET2)
ARO-TRANS-TYPE->AAI-TRANS-TYPE
ARO-INVOICE->AAI-INVOICE
ARO-PAYMENT-SEQ->AAI-PAYMENT-SEQ
Ararhuf ARARHUF Not Required
ARO-COMPANY->TUF-COMPANY
ARO-ALT-TYPE->TUF-TRANS-TYPE
ARO-INVOICE->TUF-INVOICE
Arcomp ARCOMP Required
ARO-COMPANY->ACO-COMPANY
Arcustomer ARCUSTOMER Required
ARO-COMPANY->ACM-COMPANY
ARO-CUSTOMER->ACM-CUSTOMER
Aritemaud ARITEMAUD Not Required
ARO-COMPANY->ARZ-COMPANY
ARO-TRANS-TYPE->ARZ-TRANS-TYPE
ARO-INVOICE->ARZ-INVOICE
ARO-PAYMENT-SEQ->ARZ-PAYMENT-SEQ
Aroihdr AROIHDR Required
ARO-COMPANY->ARH-COMPANY
ARO-ALT-TYPE->ARH-TRANS-TYPE
ARO-INVOICE->ARH-INVOICE
Arprlev ARPROCLEVL Required
ARO-COMPANY->APV-COMPANY
ARO-PROCESS-LEVEL->APV-PROCESS-LEVEL
Arsapplied ARSAPPLIED Not Required
ARO-COMPANY->ASG-COMPANY
ARO-TRANS-TYPE->ASG-TRANS-TYPE
ARO-INVOICE->ASG-INVOICE
ARO-PAYMENT-SEQ->ASG-PAYMENT-SEQ
Arusersort ARUSERSORT Not Required
ARO-COMPANY->USS-COMPANY
ARO-TRANS-TYPE->USS-TRANS-TYPE
ARO-INVOICE->USS-INVOICE
ARO-PAYMENT-SEQ->USS-PAYMENT-SEQ
Cbbankinst CBBANKINST Required
ARO-BANK-INST-CODE->CBI-BANK-INST-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
ARO-CUSTOMER->CUD-CUSTOMER


AROITEMS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR
Valid When ARO-CONTRACT !="SPACES"
ARO-CONTRACT->HIH-CONTRACT
ARO-COMPANY->HIH-COMPANY
ARO-CUSTOMER->HIH-CUSTOMER
ARO-AC-CUSTOMER-ID->HIH-AC-CUSTOMER-ID
ARO-INVOICE->HIH-INVOICE
  HIH-OBJ-ID
Acpmhsthdr ACPMHSTHDR
Valid When ARO-CONTRACT !="SPACES"
ARO-CONTRACT->PMH-CONTRACT
ARO-COMPANY->PMH-COMPANY
ARO-CUSTOMER->PMH-CUSTOMER
ARO-AC-CUSTOMER-ID->PMH-AC-CUSTOMER-ID
ARO-INVOICE->PMH-INVOICE
  PMH-OBJ-ID
Aradjust ARADJUST Delete Restricted
ARO-COMPANY->ADJ-COMPANY
ARO-TRANS-TYPE->ADJ-TRANS-TYPE
ARO-INVOICE->ADJ-INVOICE
ARO-PAYMENT-SEQ->ADJ-PAYMENT-SEQ
ARH-BATCH-NBR->ADJ-BATCH-NBR
  ADJ-APP-SEQ
  ADJ-ADJ-SEQ
Arapplied ARAPPLIED Delete Restricted
ARO-COMPANY->ARA-COMPANY
ARO-TRANS-TYPE->ARA-TRANS-TYPE
ARO-INVOICE->ARA-INVOICE
ARO-PAYMENT-SEQ->ARA-PAYMENT-SEQ
ARH-BATCH-NBR->ARA-BATCH-NBR
  ARA-APP-SEQ
Ardispute ARDISPUTE Delete Cascades
ARO-COMPANY->ADP-COMPANY
ARO-CUSTOMER->ADP-CUSTOMER
ARO-TRANS-TYPE->ADP-TRANS-TYPE
ARO-INVOICE->ADP-INVOICE
ARO-PAYMENT-SEQ->ADP-PAYMENT-SEQ
  ADP-SEQ
Arsadjust ARSADJUST
ARO-COMPANY->ASJ-COMPANY
ARO-TRANS-TYPE->ASJ-TRANS-TYPE
ARO-INVOICE->ASJ-INVOICE
ARO-PAYMENT-SEQ->ASJ-PAYMENT-SEQ
ARO-BATCH-NBR->ASJ-BATCH-NBR
  ASJ-ADJ-SEQ
Crapplied ARAPPLIED
ARO-COMPANY->ARA-CR-COMPANY
ARO-CUSTOMER->ARA-CR-CUSTOMER
ARO-TRANS-TYPE->ARA-CR-TYPE
ARO-INVOICE->ARA-CR-NBR
ARO-PAYMENT-SEQ->ARA-CR-PYMNT-SEQ
ARH-BATCH-NBR->ARA-CR-BATCH
  ARA-CR-SUFFIX
  ARA-CR-CANCEL-SEQ
  ARA-CR-APP-SEQ


File created: Thu Jun 09 11:09:05 2016

Home
Contact Us



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