AROITEMS FILE
AR Transaction
AR Transaction
REFERENCED BY
AC115 AR01.1 AR124 AR132 AR191 AR229
AR230 AR232 AR233 AR235 AR24.1 AR250
AR251 AR253 AR255 AR274 AR282 AR36.1
AR36.2 AR53.1 AR570 AR575 AR58.1 AR580
AR73.1 AR80.1 AR80.2 BL123 CB191 PBIP.1
AR234 AR271 AR72.1 AR90.1 AR140 AR194
AR227 AR161 AR252 AR256 AR258 AR275
AR505 AR10.1 AR245 AR294 AR301 AR74.1
AR50.1 AR286 AR287
UPDATED BY
AR100 AR105 AR110 AR115 AR130 AR131
AR135 AR136 AR137 AR150 AR180 AR190
AR196 AR199 AR20.1 AR21.1 AR21.2 AR21.3
AR25.1 AR29.3 AR30.1 AR30.2 AR30.3 AR30.4
AR30.8 AR300 AR31.5 AR31.6 AR35.1 AR35.2
AR37.1 AR37.2 AR37.3 AR37.4 AR37.5 AR37.6
AR37.7 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.3 AR45.1 AR502 AR504 AR506 AR560
AR82.1 AR953 AR954 AR976 CB06.2 DT150
DT170 DT180 DT181 DT40.1 DT45.1 DT520
DT92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARO-COMPANY Numeric 4 AR115 AR130
Company Company number. AR137 AR190
AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
AR953 AR954
AR976 DT92.1
ARO-TRANS-TYPE Alpha 1 AR115 AR130
Transaction Type Indicates the type of transaction. AR137 AR190
Valid values are: AR30.1 AR30.2
AR30.4 AR30.8
C = Credit Memo AR31.5 AR42.1
D = Debit Memo AR42.2 AR42.6
I = Invoice AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
AR953 AR954
AR976 DT92.1
ARO-TRANS-NBR Alpha 10 (Right Justified) AR115 AR130
Transaction Number The transaction number of the invoice, AR137 AR190
credit memo or debit memo. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
AR953 AR954
AR976 DT92.1
ARO-PAYMENT-SEQ Numeric 6 AR115 AR130
Payment Sequence This is a counter used to keep multiple AR137 AR190
invoice payment records unique. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
AR953 AR954
AR976 DT92.1
ARO-CUSTOMER Alpha 9 (Right Justified) AR115 AR130
Customer The customer number representing a AR137 AR190
unique customer number. AR29.3 AR30.1
AR30.2 AR30.4
AR30.8 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 AR953
AR954 AR976
DT92.1
ARO-STATUS Numeric 1 AR115 AR130
Status The status indicating where this record AR131 AR135
is in the processing flow. Valid values AR137 AR180
are: AR190 AR199
AR20.1 AR21.1
0 = Unreleased transaction (Batch AR21.2 AR21.3
entry) 1 = Open transaction AR30.1 AR30.2
2 = Select for BOE Application AR30.3 AR30.4
5 = Application by BOE AcAct = N AR30.8 AR31.5
6 = Application by BOE AcAct = Y AR31.6 AR35.1
7 = Fully applied transaction AR35.2 AR37.1
8 = Closed transaction AR37.2 AR37.3
9 = Historical transaction AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR504
AR560 AR82.1
AR953 AR954
AR976 CB06.2
DT150 DT170
DT180 DT181
DT40.1 DT45.1
DT520 DT92.1
ARO-LAST-STA-DATE Numeric 8 (yyyymmdd) AR150 AR502
Last Statement Date The date of the last statement that AR560 AR953
listed this transaction. AR954 AR976
ARO-TRANS-DATE Numeric 8 (yyyymmdd) AR115 AR130
Transaction Date The date assigned to the transaction. AR137 AR190
AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR58.1
AR82.1 AR953
AR954 AR976
DT92.1
ARO-TRAN-AMT Signed 15.2 AR115 AR130
Transaction Amount The transaction amount in the company AR137 AR190
base currency. AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR50.1
AR502 AR560
AR72.1 AR73.1
AR82.1 AR90.1
AR953 AR954
AR976 DT45.1
DT92.1
ARO-APPLD-AMT Signed 15.2 AR130 AR131
Applied Amount The total amount applied to the AR135 AR180
transaction in the company base AR20.1 AR21.1
currency. AR21.2 AR21.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR504 AR560
AR72.1 AR73.1
AR953 AR954
AR976 CB06.2
DT150 DT40.1
DT45.1 DT520
DT92.1
ARO-APPLIED-SEQ Numeric 5 AR130 AR131
Application Sequence Number of applications made for this AR135 AR180
open item. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR504 AR560
AR953 AR954
AR976 DT150
DT40.1 DT45.1
DT520 DT92.1
ARO-ADJ-AMT Signed 15.2 AR130 AR131
Adjustment Amount The total amount of adjustments that AR135 AR180
have been made against the transaction. AR20.1 AR21.1
AR21.2 AR21.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR35.2
AR44.3 AR502
AR504 AR72.1
AR73.1 AR953
AR954 AR976
CB06.2
ARO-DISPUTE-SEQ Numeric 3 AR190 AR45.1
Dispute Sequence The number of dispute records for this AR506 AR953
open item. AR954 AR976
ARO-DUE-DATE Numeric 8 (yyyymmdd) AR115 AR130
Due Date The due date of the open item. AR137 AR190
AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR58.1
AR82.1 AR953
AR954 AR976
DT92.1
ARO-LAST-FC-DATE Numeric 8 (yyyymmdd) AR136 AR137
Last Finance Charge The date of the last finance charge AR502 AR560
Date calculation for this open item. AR953 AR954
AR976
ARO-DISC-DATE Numeric 8 (yyyymmdd) Occurs 3 Times AR115 AR31.5
Discount Date The discount date of the open item. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR58.1 AR953
AR976 DT92.1
ARO-DISC-PCT Percent 5.3 (Percent) Occurs 3 Times AR115 AR31.5
Discount Percent Discount percent. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR953 DT92.1
ARO-DISC-PCT1 Derived
Discount Percent 1 Redefinition of discount percent occurs
value one; for use in the discount one
compute amount field.
ARO-DISC-PCT2 Derived
Discount Percent 2 Redefinition of discount percent occurs
two field; for use in the discount two
compute amount field.
ARO-DISC-PCT3 Derived
Discount Percent 3 Redefinition of discount percent occurs
value three; for use in the discount
three compute amount field.
ARO-ORIG-AMT Signed 15.2 AR115 AR130
Transaction Amount The original transaction amount for the AR137 AR190
records. This amount will converted to AR30.1 AR30.2
the company base currency for a non-base AR30.4 AR30.8
currency transaction. AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR50.1
AR502 AR560
AR72.1 AR73.1
AR82.1 AR953
AR954 AR976
DT92.1
ARO-ORIG-APP-AMT Signed 15.2 AR130 AR131
Transaction Applied Payment amount. The amount applied to AR135 AR180
Amount the open item in the currency of the AR20.1 AR21.1
transaction. AR21.2 AR21.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR504
AR560 AR72.1
AR73.1 AR953
AR954 AR976
CB06.2 DT150
DT40.1 DT45.1
DT520 DT92.1
ARO-ORIG-ADJ-AMT Signed 15.2 AR130 AR131
Transaction Adjust Transaction adjustment amount. The AR135 AR180
Amount amount of the open item that has been AR20.1 AR21.1
adjusted in the transaction currency of AR21.2 AR21.3
the open item. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR44.3
AR502 AR504
AR72.1 AR73.1
AR953 AR954
AR976 CB06.2
ARO-OPEN-AMOUNT Derived
Open Amount 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 Derived
Application Amount Derived indicator for application
amount existing.
ARO-DISC-AMT1 Derived
Discount Amount 1 Derived value for discount amount one.
ARO-DISC-AMT2 Derived
Discount Amount 2 Derived value for discount amount two.
ARO-DISC-AMT3 Derived
Discount Amount 3 Derived value for discount amount
three.
ARO-DESCRIPTION Alpha 30 (Lower Case) AR42.1 AR42.2
Description The description of the transaction. AR42.7 AR43.1
AR560 AR976
ARO-ITEM-USER1 Alpha 20 AR42.1 AR42.2
Line Item User 1 The User 1 value associated with the AR42.7 AR43.1
line item. AR560 AR976
ARO-ACTIVITY Alpha 15 AR190 AR42.1
Activity Activities are the processes or AR42.2 AR42.7
procedures that produce work. Cost AR43.1 AR44.3
objects (products, services, customers, AR502 AR560
and so on) are the reasons for AR976
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
ARO-ACCT-CATEGORY Alpha 5 AR190 AR42.1
Account Category Account categories are groupings of AR42.2 AR42.7
costs, revenues, or a combination of AR43.1 AR44.3
both used for reporting and inquiries AR502 AR560
for activities in the Activity AR976
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
ARO-LINE-NBR Numeric 6 AR42.1 AR42.2
Line Item Number This field contains the line number. AR42.7 AR43.1
AR560 AR976
ARO-LINE-TYPE Alpha 1 AR560 AR976
Inventory Type Indicates the inventory 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 Numeric 3
Line Item Sequence The sequence number of the line item.
Number
ARO-ITEM Alpha 32 AR42.1 AR42.2
Item Number This field contains the item AR42.7 AR43.1
identifier. AR560 AR976
ARO-EFT-NOTE Numeric 1 AR100 AR105
Status of EFT Notice Indicates the status of the EFT note. AR976
Valid values are:
0 = Prenote not sent
1 = Prenote sent
2 = Final note sent
9 = Note printed
ARO-EFT-EXTRACT Numeric 1 AR110 AR115
Status of EFT Indicates the status of an EFT AR25.1 AR976
Extract adjustment. Valid values are:
0 = Not extracted
8 = Adjustment made
9 = Extracted
ARO-EFT-ACTION Alpha 1 AR110 AR25.1
EFT Action Indicates the action taken on an EFT AR976
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 Signed 15.2 AR196
Gain/Loss Amount The amount of gain or loss from the
last run of the Unrealized Gain Loss
Report.
ARO-AR-CUST-PO-NBR Derived
Customer PO Number Used by Lawson SEA programs.
ARO-AR-TERM Derived
Terms Used by Lawson SEA programs.
ARO-HIST-PER Numeric 2 AR180 AR199
History Periods Determines the number of times the
Period Closing Report runs before the
status of the transaction is changed.
AROITEMS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AROSET1 COMPANY This path is used for record AC115 AR01.1
TRANS-TYPE uniqueness. AR105 AR115
TRANS-NBR AR124 AR130
PAYMENT-SEQ AR131 AR132
AR135 AR137
AR150 AR180
AR190 AR191
AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR229
AR230 AR232
AR233 AR235
AR24.1 AR25.1
AR250 AR251
AR253 AR255
...
AROSET2 COMPANY This path is used to select a AR130 AR234
CUSTOMER customer's open records in due date AR271 AR30.1
DUE-DATE order. AR30.2 AR30.3
TRANS-TYPE Subset AR30.8 AR72.1
TRANS-NBR Where STATUS = 1 AR73.1 AR90.1
PAYMENT-SEQ Or STATUS = 2 DT520
AROSET3 COMPANY This path is used to select a AR100 AR110
CUSTOMER customer's open records in purchase AR130 AR131
TRANS-TYPE order number order. AR135 AR140
TRANS-NBR Subset AR194 AR227
PAYMENT-SEQ Where STATUS = 1 AR25.1 AR30.1
AR30.2 AR30.3
AR30.6 AR30.8
AR30.9 AR31.6
AR44.1 AR90.1
DT150
AROSET4 COMPANY This path is used to select a AR130 AR136
CUSTOMER customer's open records in transaction AR161 AR196
TRANS-DATE user1 order. AR199 AR252
TRANS-TYPE Subset AR256 AR258
TRANS-NBR Where STATUS > Zeroes AR275 AR505
PAYMENT-SEQ And STATUS < 9 AR90.1
AROSET5 COMPANY This path is used to select a AR10.1 AR150
CUSTOMER customer's open records in transaction AR191 AR230
TRANS-TYPE type and transaction number order. AR232 AR245
TRANS-NBR AR251 AR252
PAYMENT-SEQ AR253 AR255
AR256 AR294
AR300 AR301
AR35.1 AR35.2
AR37.4 AR37.5
AR37.6 AR37.7
AR504 AR53.1
AR72.1 AR73.1
AR74.1 AR80.2
AR90.1
AROSET6 COMPANY This path is used to select a AR137 AR150
CUSTOMER customer's non-historical transactions. AR194 AR250
TRANS-TYPE Subset AR251 AR253
TRANS-NBR Where STATUS > Zeroes AR255 AR294
PAYMENT-SEQ And STATUS < 9 AR50.1
AROSET7 COMPANY This path is used to access a AR30.1 AR30.2
CUSTOMER customer's non-historical records. AR30.3
ACTIVITY Subset
TRANS-TYPE Where STATUS = 1
TRANS-NBR
PAYMENT-SEQ
AROSET9 COMPANY This path is used to access a AR131 AR286
TRANS-TYPE customer's records. AR287 AR30.1
TRANS-DATE Subset AR30.2 AR30.3
TRANS-NBR Where STATUS = 1
PAYMENT-SEQ
AROITEMS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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-TRANS-NBR -> ARZ-TRANS-NBR
ARO-PAYMENT-SEQ -> ARZ-PAYMENT-SEQ
Aroihdr AROIHDR Required
ARO-COMPANY -> ARH-COMPANY
ARO-TRANS-TYPE -> ARH-TRANS-TYPE
ARO-TRANS-NBR -> ARH-TRANS-NBR
Arsapplied ARSAPPLIED Not Required
ARO-COMPANY -> ASG-COMPANY
ARO-TRANS-TYPE -> ASG-TRANS-TYPE
ARO-TRANS-NBR -> ASG-TRANS-NBR
ARO-PAYMENT-SEQ -> ASG-PAYMENT-SEQ
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
ARO-CUSTOMER -> CUD-CUSTOMER
AROITEMS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aradjust ARADJUST Delete Restricted
ARO-COMPANY -> ADJ-COMPANY
ARO-TRANS-TYPE -> ADJ-TRANS-TYPE
ARO-TRANS-NBR -> ADJ-TRANS-NBR
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-TRANS-NBR -> ARA-TRANS-NBR
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-TRANS-NBR -> ADP-TRANS-NBR
ARO-PAYMENT-SEQ -> ADP-PAYMENT-SEQ
ADP-SEQ
Ardunhist ARDUNHIST
ARO-COMPANY -> DUH-COMPANY
ARO-CUSTOMER -> DUH-CUSTOMER
ARO-TRANS-TYPE -> DUH-TRANS-TYPE
ARO-TRANS-NBR -> DUH-TRANS-NBR
DUH-DUN-PROCESS-CD
DUH-DUN-LEVEL
DUH-DUN-CYCLE-ID
Arsadjust ARSADJUST
ARO-COMPANY -> ASJ-COMPANY
ARO-TRANS-TYPE -> ASJ-TRANS-TYPE
ARO-TRANS-NBR -> ASJ-TRANS-NBR
ARO-PAYMENT-SEQ -> ASJ-PAYMENT-SEQ
ASJ-ADJ-SEQ
Crapplied ARAPPLIED
ARO-COMPANY -> ARA-CR-COMPANY
ARO-CUSTOMER -> ARA-CR-CUSTOMER
ARO-TRANS-TYPE -> ARA-CR-TYPE
ARO-TRANS-NBR -> 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
Dtcredit DTCREDIT
ARO-COMPANY -> DTX-CR-COMPANY
ARO-TRANS-TYPE -> DTX-CR-TYPE
ARO-TRANS-NBR -> DTX-CR-NBR
ARH-BATCH-NBR -> DTX-CR-BATCH
ARO-PAYMENT-SEQ -> DTX-CR-PYMNT-SEQ
DTX-CR-APP-SEQ
Pbclient PBCLIENT
ARO-COMPANY -> PCC-POST-COMPANY
ARO-CUSTOMER -> PCC-CUSTOMER
PCC-COMPANY
PCC-PROCESS-LEVEL
Reversedtl REVERSEDTL Delete Cascades
ARO-COMPANY -> RVD-COMPANY
ARO-TRANS-TYPE -> RVD-TRANS-TYPE
ARO-TRANS-NBR -> RVD-TRANS-NBR
ARO-PAYMENT-SEQ -> RVD-PAYMENT-SEQ
ARH-BATCH-NBR -> RVD-BATCH-NBR
RVD-APP-SEQ
|