Lawson Insight Technical Documentation |
|
AROITEMS
AROITEMS FILE
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
AC56.1 AC560 AR01.1 AR124 AR132 AR140
AR191 AR229 AR230 AR232 AR233 AR235
AR237 AR238 AR239 AR24.1 AR245 AR250
AR251 AR252 AR253 AR255 AR257 AR274
AR282 AR36.1 AR36.2 AR46.1 AR525 AR53.1
AR570 AR575 AR58.1 AR58.2 AR580 AR90.1
BL00.1 BL01.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL200 BL201 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
BL98.1 BR11.1 BR48.1 CB191 WH20.7 AR72.1
AR234 AR271 DT520 AR112 AR12.1 AR12.2
AR194 AR227 AR256 AR50.1 AR505 AR510
AR161 AR258 AR275 AR520 AR10.1 AR286
AR293 AR294 AR301 AR74.1 AR265 AR287
UPDATED BY
AR100 AR105 AR110 AR115 AR129 AR130
AR131 AR135 AR136 AR137 AR150 AR180
AR190 AR196 AR198 AR20.1 AR21.1 AR21.2
AR21.3 AR25.1 AR29.3 AR30.1 AR30.8 AR32.1
AR33.1 AR33.3 AR33.5 AR33.6 AR34.1 AR35.1
AR35.2 AR37.1 AR37.2 AR37.3 AR37.4 AR37.5
AR37.6 AR37.7 AR38.1 AR38.2 AR38.3 AR39.1
AR39.2 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.3 AR45.1 AR48.3 AR502 AR504 AR506
AR560 AR80.1 AR80.2 AR800 AR82.1 ARLL.1
CB06.2 DT150 DT170 DT180 DT181 DT45.1
DT92.1 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARO-COMPANY Numeric 4 AR115 AR130
Element: Company The number representing an AR company. AR137 AR190
AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-TRANS-TYPE Alpha 1 AR115 AR130
Element: Transaction TyIndicates the type of transaction. AR137 AR190
Valid values are: AR30.1 AR30.8
AR32.1 AR33.3
C = Credit Memo AR33.5 AR34.1
D = Debit Memo AR42.1 AR42.2
I = Invoice AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-INVOICE Alpha 22 AR115 AR130
Element: Invoice Used to identify the invoice. AR137 AR190
AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-PAYMENT-SEQ Numeric 6 AR115 AR130
Element: Payment SequenSequence number used for record AR137 AR190
uniqueness. This number may relate to AR30.1 AR30.8
an invoice line number, payment AR32.1 AR33.3
schedule, line sub grouping, or many AR33.5 AR34.1
other examples. AR42.1 AR42.2
AR42.6 AR42.7
Based on the terms of sale, this field AR43.1 AR44.3
is used as a counter to keep track of AR502 AR560
multiple payment obligations. AR82.1 ARLL.1
Example - a sale of a $50,000 item: DT92.1
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 Alpha 9 (Right Justified) AR115 AR130
Element: Customer The customer number representing a AR137 AR190
unique customer number. AR29.3 AR30.1
AR30.8 AR32.1
AR33.3 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
ARLL.1 DT92.1
ARO-STATUS Numeric 1 AR115 AR129
Element: Status The status indicating where this record AR130 AR131
is in the processing flow. Valid values AR135 AR137
are: AR180 AR190
AR198 AR20.1
0 = Unreleased transaction (Batch AR21.1 AR21.2
entry) 1 = Open transaction AR21.3 AR30.1
2 = Select for BOE Application AR30.8 AR32.1
5 = Application by BOE AcAct = N AR33.1 AR33.3
6 = Application by BOE AcAct = Y AR33.5 AR33.6
7 = Fully applied transaction AR34.1 AR35.1
8 = Closed transaction AR35.2 AR37.1
9 = Historical transaction AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR504
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARO-LAST-STA-DATE Numeric 8 (yyyymmdd) AR150 AR502
Element: Last StatementThe date of the last statement that AR560 ARLL.1
listed this transaction.
ARO-TRANS-DATE Numeric 8 (yyyymmdd) AR115 AR130
Element: Transaction DaThe date assigned to the transaction. AR137 AR190
AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR58.1 AR82.1
ARLL.1 DT92.1
ARO-TRAN-AMT Signed 18.2 AR115 AR130
Element: Transaction AmThe transaction amount in the company AR137 AR190
base currency. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR72.1 AR82.1
AR90.1 ARLL.1
DT45.1 DT92.1
ARO-APPLD-AMT Signed 18.2 AR129 AR130
Element: Applied AmountThe total amount applied to the AR131 AR135
transaction in the company base AR180 AR20.1
currency. AR21.1 AR21.2
AR21.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR504
AR560 AR72.1
AR80.1 AR80.2
ARLL.1 CB06.2
DT150 DT45.1
DT92.1
ARO-APPLIED-SEQ Numeric 7 AR129 AR130
Element: Application SeNumber of applications made for this AR131 AR135
open item. AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR80.1 AR80.2
ARLL.1 DT150
DT45.1 DT92.1
ARO-ADJ-AMT Signed 18.2 AR129 AR130
Element: Adjustment AmoThe total amount of adjustments that AR131 AR135
have been made against the transaction. AR180 AR20.1
AR21.1 AR21.2
AR21.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR39.1 AR39.2
AR44.3 AR48.3
AR502 AR504
AR72.1 AR80.1
AR80.2 CB06.2
ARO-DISPUTE-SEQ Numeric 3 AR190 AR38.1
Element: Dispute SequenThe number of dispute records for this AR38.2 AR38.3
open item. AR45.1 AR506
ARO-DUE-DATE Numeric 8 (yyyymmdd) AR115 AR130
Element: Due Date The due date of the open item. AR137 AR190
AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR58.1 AR82.1
ARLL.1 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. ARLL.1
ARO-DISC-DATE Numeric 8 (yyyymmdd) Occurs 3 Times AR115 AR33.5
Element: 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 ARLL.1
DT92.1
ARO-DISC-PCT Percent 7.5 (Percent) Occurs 3 Times AR115 AR33.5
Element: Discount PerceDiscount percent. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
ARLL.1
ARO-DISC-PCT1 Derived
Element: Disc Pct1 Redefinition of discount percent occurs
value one; for use in the discount one
compute amount field.
ARO-DISC-PCT2 Derived
Element: Disc Pct2 Redefinition of discount percent occurs
two field; for use in the discount two
compute amount field.
ARO-DISC-PCT3 Derived
Element: Disc Pct3 Redefinition of discount percent occurs
value three; for use in the discount
three compute amount field.
ARO-ORIG-AMT Signed 18.2 AR115 AR130
Element: Transaction AmThe original transaction amount for the AR137 AR190
records. This amount will converted to AR30.1 AR30.8
the company base currency for a non-base AR32.1 AR33.3
currency transaction. AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR72.1 AR82.1
AR90.1 ARLL.1
DT92.1
ARO-ORIG-APP-AMT Signed 18.2 AR129 AR130
Transaction Applied Payment amount. The amount applied to AR131 AR135
Amount the open item in the currency of the AR180 AR20.1
transaction. AR21.1 AR21.2
AR21.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR72.1 AR80.1
AR80.2 ARLL.1
CB06.2 DT150
DT45.1 DT92.1
ARO-ORIG-ADJ-AMT Signed 18.2 AR129 AR130
Transaction Adjust Transaction adjustment amount. The AR131 AR135
Amount amount of the open item that has been AR180 AR20.1
adjusted in the transaction currency of AR21.1 AR21.2
the open item. AR21.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR39.1
AR39.2 AR44.3
AR48.3 AR502
AR504 AR72.1
AR80.1 AR80.2
CB06.2
ARO-OPEN-AMOUNT Derived
Element: 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
Element: Application AmDerived indicator for application
amount existing.
ARO-DISC-AMT1 Derived
Element: Disc Amt1 Derived value for discount amount one.
ARO-DISC-AMT2 Derived
Element: Disc Amt2 Derived value for discount amount two.
ARO-DISC-AMT3 Derived
Element: Disc Amt3 Derived value for discount amount
three.
ARO-DESCRIPTION Alpha 30 (Lower Case) AR42.1 AR42.2
Element: Description The description of the transaction. AR42.7 AR43.1
AR502 AR560
ARLL.1
ARO-ITEM-USER1 Alpha 20 AR42.1 AR42.2
Element: Line Item UserThe User 1 value associated with the AR42.7 AR43.1
line item. AR560 ARLL.1
ARO-ACTIVITY Alpha 15 AR190 AR33.5
Element: Activity Activities are the processes or AR42.1 AR42.2
procedures that produce work. Cost AR42.7 AR43.1
objects (products, services, customers, AR44.3 AR502
and so on) are the reasons for AR560 ARLL.1
performing the activity.
ARO-ACCT-CATEGORY Alpha 5 AR190 AR42.1
Element: Account CategoThe account category assigned to the AR42.2 AR42.7
activity. AR43.1 AR44.3
AR502 AR560
ARLL.1
ARO-LINE-NBR Numeric 6 AR42.1 AR42.2
Element: Line Item NumbThis field contains the line number. AR42.7 AR43.1
AR560 ARLL.1
ARO-LINE-TYPE Alpha 1 AR560 ARLL.1
Element: Inventory TypeIndicates 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 Numeric 3 AR560
Line Item Sequence The sequence number of the Billing
Number system transaction's line item.
ARO-ITEM Alpha 32 AR42.1 AR42.2
Element: Item Number This field contains the item AR42.7 AR43.1
identifier. AR560 ARLL.1
ARO-EFT-NOTE Numeric 1 AR100 AR105
Element: Status of EFT Indicates the status of the EFT note. AR180 AR25.1
Valid values are: AR37.1 AR37.2
AR37.3 AR37.4
0 = Prenote not sent AR37.5 AR37.6
1 = Prenote sent AR37.7 AR80.1
2 = Final note sent AR80.2
9 = Note printed
ARO-EFT-EXTRACT Numeric 1 AR110 AR115
Status of EFT Indicates the status of an EFT AR180 AR25.1
Extract adjustment. Valid values are: AR37.1 AR37.2
AR37.3 AR37.4
0 = Not extracted AR37.5 AR37.6
8 = Adjustment made AR37.7 AR80.1
9 = Extracted AR80.2
ARO-EFT-ACTION Alpha 1 AR110 AR180
Element: EFT Action Indicates the action taken on an EFT AR25.1 AR37.1
transaction. Valid values are: AR37.2 AR37.3
AR37.4 AR37.5
Blank = Not within due date range AR37.6 AR37.7
0 = Eligible AR80.1 AR80.2
1 = Added
2 = Postponed
3 = Deleted
5 = Added postponed
6 = Hold
ARO-GAINLOS-AMT Signed 18.2 AR196
Element: Intl Amt The amount of gain or loss from the last
run of the Unrealized Gain Loss Report.
ARO-ALT-TYPE Alpha 1 AR115 AR130
Element: Alt Type The transaction type of the associated AR137 AR190
transaction header record. AR30.1 AR30.8
C = Credit Memo AR32.1 AR33.3
D = Debit Memo AR33.5 AR34.1
I = Invoice AR42.1 AR42.2
M = Mixed AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-AR-CUST-PO-NBR Derived
Element: Ar Cust Po NbrString field to derive purchase order
number.
ARO-AR-TERM Derived
Element: Ar Term String field to derive terms code value.
ARO-HIST-PER Numeric 2 AR180 AR198
Element: Hist Per The number of updates from being AR80.1 AR80.2
processed by AR198 Transaction Status
Update.
ARO-INVL-OBJ-ID Numeric 12
Element: Invl Obj Id
ARO-CUST-PO-NBR Alpha 22 AR115 AR130
Element: Cust Po Nbr The customer purchase order number. AR190 AR30.1
AR30.8 AR32.1
AR33.3 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR502
AR560 ARLL.1
ARO-TRANS-USER1 Alpha 10 AR115 AR190
Element: Trans User1 User-defined field 1. Can be used as a AR42.1 AR42.2
selection criteria or for sorting in the AR42.6 AR42.7
Lawson Accounts Receivable system. AR43.1 AR502
Primarily used as an open item sort AR560 ARLL.1
within cash aplication.
ARO-PROCESS-LEVEL Alpha 5 AR115 AR130
Element: Process Level This field contains the process level, AR137 AR190
which is the reporting hierarchy below AR30.1 AR30.8
company. AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-SORT-AMOUNT Numeric 17 AR115 AR129
Element: Sort Amount AR130 AR131
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR504
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARO-BANK-INST-CODE Alpha 3 AR115 AR130
Element: Bank Inst CodeA transaction code representing a type AR137 AR190
of cash payment (with atributes for AR30.1 AR30.8
either receiving AP payments, or AR32.1 AR33.3
creating EFT payments), bill of exchange AR33.5 AR34.1
payment, or bank service transaction. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-BANK-INST-TYPE Alpha 1 AR115 AR130
Element: Bank Inst TypePayment code. Indicates the payment AR137 AR190
type. Valid values are: AR30.1 AR30.8
AR32.1 AR33.3
C = Cash AR33.5 AR34.1
D = Bill of Exchange AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-SORT-1 Alpha 32 (Lower Case) AR190 AR42.1
Element: Sort 1 User sort 1 field used in cash AR42.2 AR42.7
application and credit manangement AR43.1 AR502
inquiry. AR560 ARLL.1
ARO-SORT-2 Alpha 32 (Lower Case) AR190 AR42.1
Element: Sort 2 User sort 2 field used in cash AR42.2 AR42.7
application and credit manangement AR43.1 AR502
inquiry. AR560 ARLL.1
ARO-SORT-3 Alpha 32 (Lower Case) AR190 AR42.1
Element: Sort 3 User sort 2 field used in cash AR42.2 AR42.7
application and credit manangement AR43.1 AR502
inquiry. AR560 ARLL.1
ARO-SORT-4 Alpha 32 (Lower Case) AR190 AR42.1
Element: Sort 4 User sort 2 field used in cash AR42.2 AR42.7
application and credit manangement AR43.1 AR502
inquiry. AR560 ARLL.1
ARO-ORIG-CURRENCY Alpha 5 AR115 AR130
Element: Orig Currency Transaction currency. The currency in AR137 AR190
which the transaction was added to the AR30.1 AR30.8
system. AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-ORIG-ND Numeric 1 AR115 AR130
Element: Acct Nd The number of decimals defined for the AR137 AR190
transaction currency in the Lawson AR30.1 AR30.8
Currency system. AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-ORIG-RATE Signed 14.7 AR115 AR130
Element: Orig Rate The currency exchange rate used to AR137 AR190
convert a non-base currency transaction AR30.1 AR30.8
amount to the company base currency. The AR32.1 AR33.3
rate is maintained in the Lawson AR33.5 AR34.1
Currency system, and an option exists at AR42.1 AR42.2
the company level to override the rate AR42.6 AR42.7
at entry time. AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-BATCH-NBR Numeric 6 AR115 AR130
Element: Batch Nbr The batch number associated with the AR137 AR190
invoice or debit memo. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-CURR-MUDV Alpha 1 AR115 AR130
Element: Curr Mudv The currency multiplier or divider. AR137 AR190
Mathematical technique used in AR30.1 AR30.8
conjunction with the currency exchange AR32.1 AR33.3
rate to convert a non-base currency AR33.5 AR34.1
transaction amount to the company base AR42.1 AR42.2
currency. AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
DT92.1
ARO-SUM-LINE Alpha 1 AR115 AR130
Element: Sum Line N = No AR137 AR190
Y = Yes AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-GL-DATE Numeric 8 (yyyymmdd) AR115 AR130
Element: Gl Date The general ledger posting date AR137 AR190
assigned to the invoice or debit memo. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-AR-CODE Alpha 4 AR115 AR130
Element: Ar Code The accounts receivable code that AR137 AR190
identifies the accounts receivable AR30.1 AR30.8
general ledger account for this AR32.1 AR33.3
transaction. The general ledger account AR33.5 AR34.1
that this code represents will be AR42.1 AR42.2
credited during cash application. AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-REVALUE-FL Alpha 1 AR115 AR130
Element: Revalue Fl Indicates whether this invoice or debit AR137 AR190
memo is subject to revaluation if its AR30.1 AR30.8
currency differs from the company AR32.1 AR33.3
currency. AR33.5 AR34.1
AR42.1 AR42.2
Valid values are: AR42.6 AR42.7
AR43.1 AR44.3
N = No - Do not revalue AR502 AR560
Y = Yes - Revalue AR82.1 ARLL.1
ARO-CANCEL-FLAG Alpha 1 AR115 AR130
Element: Cancel Flag AR137 AR190
AR29.3 AR30.1
AR30.8 AR32.1
AR33.3 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
ARLL.1
ARO-DESC Alpha 30 (Lower Case) AR115 AR130
Element: Description Free text description or reason for AR137 AR190
invoice, debit memo, or credit memo. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-GROUP-RATE Signed 14.7 AR115 AR130
Element: Group Rate The currency exchange rate used to AR137 AR190
convert a transaction amount from a AR30.1 AR30.8
currency that differs from the customer AR32.1 AR33.3
group currency to the customer group AR33.5 AR34.1
currency. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-GROUP-MUDV Alpha 1 AR115 AR130
Element: Group Mudv The currency multiplier or divider. AR137 AR190
Mathematical technique used in AR30.1 AR30.8
conjunction with the currency exchange AR32.1 AR33.3
rate to convert a non-base currency AR33.5 AR34.1
transaction amount to the customer group AR42.1 AR42.2
currency. AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-SALESMAN Numeric 4 AR115 AR130
Element: Salesman Sales representative for this invoice AR137 AR190
or debit memo. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-XREF-COMPANY Numeric 4 AR115 AR130
Element: Company The cross reference company of the cross AR137 AR190
referenced transaction. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-XREF-TYPE Alpha 1 AR115 AR130
Element: Xref Type This will identify what type of item is AR137 AR190
being cross referenced. This will work AR30.1 AR30.8
with the cross reference number field. AR32.1 AR33.3
Valid values are: AR33.5 AR34.1
AR42.1 AR42.2
C = Credit Memo AR42.6 AR42.7
D = Debit Mmeo AR43.1 AR44.3
I = Invoice AR502 AR560
O = Other AR82.1 ARLL.1
ARO-XREF-NBR Alpha 22 AR115 AR130
Element: Xref Nbr The Cross Reference Number field is an AR137 AR190
informational field that can be used AR30.1 AR30.8
when entering an invoice or debit memo AR32.1 AR33.3
to cross reference a particular record. AR33.5 AR34.1
It could also be used for example, as AR42.1 AR42.2
the order entry order number for this AR42.6 AR42.7
invoice or debit memo. AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-ORIG-CODE Alpha 1 AR115 AR130
Element: Orig Code Identifies where the transaction AR137 AR190
originated. Valid values are: AR30.1 AR30.8
AR32.1 AR33.3
B = AR generated invoice (AR42) AR33.5 AR34.1
C = Chargeback (Memo) AR42.1 AR42.2
F = Finance charges AR42.6 AR42.7
L = Converted records (Lawson) AR43.1 AR44.3
M = Memo (AR40) AR502 AR560
O = External Order Entry AR82.1 ARLL.1
R = Returned Payment
G = Grouping
E = Chargebacks (Summary/Detail)
ARO-TERMS-CD Alpha 5 AR115 AR130
Element: Term Code Terms code for this invoice, or debit AR137 AR190
memo, or credit memo. Must be a valid AR30.1 AR30.8
terms code. AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-AC-CUSTOMER-ID Alpha 5 AR115 AR130
Element: Ac Customer IdThis field enables a link to BR-created AR137 AR190
transactions and is used in Drill AR30.1 AR30.8
views. AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-ADJ-FL Alpha 1 AR560 ARLL.1
Element: Flag1 If the field = Y, activity and acct
category cannot be entered on the
aradjust record.
ARO-LATE-CH-FL Alpha 1 AR115 AR130
Element: Late Ch Fl Late Charge Flag. Indicate if late AR137 AR190
charge is to be applied to the invoice. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-LST-DUNLTR-STM Numeric 2 AR115 AR130
Element: Lst Dunltr StmLevel of the last dunning letter sent. AR137 AR190
AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-LAST-LTR-DATE Numeric 8 (yyyymmdd) AR115 AR130
Element: Last Ltr Date Date last dunning letter was sent for AR137 AR190
the invoice. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-LST-LTRTEXT-CD Alpha 6 AR115 AR130
Element: Lst Ltrtext CdText Code for last Dunning Letter sent AR137 AR190
on this invoice. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-SENT-FOR-COLL Alpha 1 AR115 AR130
Element: Sent For Coll Sent for collection. This indicates AR137 AR190
whether the invoice has been sent for AR30.1 AR30.8
collection (Yes or No). AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-ASSESS-DUN-FEE Alpha 1 AR115 AR130
Element: Assess Dun FeeSpecifies whether to assess a dunning AR137 AR190
letter fee. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-DUN-LTR-IND Alpha 1 AR115 AR130
Element: Dun Ltr Ind Specifies whether the advanced dunning AR137 AR190
letter process is to be used. AR30.1 AR30.8
AR32.1 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.1 ARLL.1
ARO-ORIG-DISC-AMT Signed 18.2 Occurs 3 Times AR25.1 AR30.1
Element: Intl Amt AR30.8 AR32.1
AR33.3 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 ARLL.1
DT92.1
ARO-CONTRACT Alpha 15 AR190 AR33.5
Element: Contract Activity Management contract. AR42.1 AR42.2
AR42.7 AR43.1
AR44.3 AR502
AR560 AR800
ARLL.1
ARO-ACTIVITY-GRP Alpha 15 AR190 AR33.5
Element: Activity Grp The activity group is the overall AR42.1 AR42.2
project. AR42.7 AR43.1
AR44.3 AR502
AR560 AR800
ARLL.1
AROITEMS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AROSET1 COMPANY KeyChange AC56.1 AC560
TRANS-TYPE AR01.1 AR105
INVOICE AR115 AR124
PAYMENT-SEQ AR129 AR130
AR131 AR132
AR135 AR137
AR140 AR150
AR180 AR190
AR191 AR196
AR20.1 AR21.1
AR21.2 AR21.3
AR21.6 AR229
AR230 AR232
AR233 AR235
AR237 AR238
...
AROSET10 COMPANY KeyChange, Subset AR30.1 AR33.1
CUSTOMER Where STATUS = 1 AR39.1 AR72.1
SORT-AMOUNT* AR90.1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET11 COMPANY KeyChange, Subset AR129 AR30.1
CUSTOMER Where STATUS = 1 AR33.1 AR39.1
CUST-PO-NBR AR72.1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET12 COMPANY KeyChange, Subset AR30.1 AR33.1
CUSTOMER Where STATUS = 1 AR39.1 AR72.1
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET13 COMPANY KeyChange, Subset AR129 AR130
CUSTOMER Where STATUS = 1 AR131 AR30.1
PROCESS-LEVEL AR33.1 AR39.1
TRANS-TYPE AR42.1 AR42.2
INVOICE AR42.7 AR43.1
PAYMENT-SEQ AR560 AR72.1
ARLL.1
AROSET14 ACTIVITY KeyChange
STATUS
TRANS-DATE
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET2 COMPANY KeyChange, Subset AR130 AR131
CUSTOMER Where STATUS = 1 AR135 AR234
DUE-DATE Or STATUS = 2 AR271 AR30.1
TRANS-TYPE AR30.8 AR33.1
INVOICE AR33.3 AR39.1
PAYMENT-SEQ AR44.1 AR72.1
AR90.1 DT520
AROSET3 COMPANY KeyChange, Subset AR100 AR110
CUSTOMER Where STATUS = 1 AR112 AR12.1
TRANS-TYPE AR12.2 AR129
INVOICE AR130 AR131
PAYMENT-SEQ AR135 AR137
AR150 AR194
AR196 AR227
AR25.1 AR250
AR251 AR253
AR255 AR256
AR30.1 AR30.2
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR39.1 AR39.2
...
AROSET4 COMPANY KeyChange, Subset AR130 AR136
CUSTOMER Where STATUS > Zeroes AR161 AR196
TRANS-DATE And STATUS < 9 AR198 AR256
TRANS-TYPE AR258 AR275
INVOICE AR44.1 AR520
PAYMENT-SEQ AR90.1
AROSET5 COMPANY KeyChange AR10.1 AR129
CUSTOMER AR130 AR131
TRANS-TYPE AR140 AR191
INVOICE AR230 AR245
PAYMENT-SEQ AR251 AR253
AR255 AR256
AR286 AR293
AR294 AR301
AR33.1 AR35.1
AR35.2 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.7
AR43.1 AR48.1
AR48.3 AR504
...
AROSET6 COMPANY KeyChange, Subset AR137 AR150
CUSTOMER Where STATUS > Zeroes AR194 AR250
TRANS-TYPE And STATUS < 9 AR251 AR252
INVOICE AR253 AR255
PAYMENT-SEQ AR265 AR38.1
AR38.2 AR38.3
AR50.1
AROSET7 COMPANY KeyChange, Subset AR30.1 AR33.1
CUSTOMER Where STATUS = 1 AR39.1 AR72.1
ACTIVITY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET8 COMPANY KeyChange AR129 AR150
ALT-TYPE AR191 AR21.6
INVOICE AR29.3 AR30.1
PAYMENT-SEQ AR30.6 AR300
AR32.1 AR33.1
AR34.1 AR42.2
AR42.6 AR42.8
AR560 AR58.1
AR90.1 ARLL.1
AROSET9 COMPANY KeyChange, Subset AR131 AR227
TRANS-TYPE Where STATUS = 1 AR250 AR251
DUE-DATE AR252 AR287
INVOICE AR39.2
PAYMENT-SEQ
AROITEMS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arapselect ARAPSELECT Not Required
ARO-COMPANY -> AAI-COMPANY
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
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 RELATED
NAME 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
Ardunhist ARDUNHIST
ARO-COMPANY -> DUH-COMPANY
ARO-CUSTOMER -> DUH-CUSTOMER
ARO-TRANS-TYPE -> DUH-TRANS-TYPE
ARO-INVOICE -> DUH-INVOICE
DUH-DUN-PROCESS-CD
DUH-DUN-LEVEL
DUH-DUN-CYCLE-ID
Arpendadj ARPENDADJ Delete Cascades
ARO-COMPANY -> PND-COMPANY
ARO-TRANS-TYPE -> PND-TRANS-TYPE
ARO-INVOICE -> PND-INVOICE
ARO-PAYMENT-SEQ -> PND-PAYMENT-SEQ
ARO-BATCH-NBR -> PND-BATCH-NBR
PND-APP-SEQ
PND-ADJ-SEQ
Arsadjust ARSADJUST
ARO-COMPANY -> ASJ-COMPANY
ARO-TRANS-TYPE -> ASJ-TRANS-TYPE
ARO-INVOICE -> ASJ-INVOICE
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-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
Dtcredit DTCREDIT
ARO-COMPANY -> DTX-CR-COMPANY
ARO-TRANS-TYPE -> DTX-CR-TYPE
ARO-INVOICE -> DTX-CR-NBR
ARH-BATCH-NBR -> DTX-CR-BATCH
ARO-PAYMENT-SEQ -> DTX-CR-PYMNT-SEQ
DTX-CR-APP-SEQ
|