Lawson Insight Technical Documentation |
|
AROITEMS
AROITEMS FILE
AR Transaction
The AR 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 will
also stored in this file.
REFERENCED BY
AR01.1 AR124 AR132 AR141 AR191 AR229
AR230 AR232 AR233 AR235 AR24.1 AR245
AR250 AR251 AR253 AR255 AR274 AR282
AR36.1 AR36.2 AR46.1 AR510 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 BR11.1
CB191 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE810 OE830
WH20.7 AR72.1 AR234 AR271 DT520 AR112
AR12.1 AR12.2 AR140 AR194 AR227 AR252
AR256 AR50.1 AR505 AR161 AR258 AR275
AR520 AR10.1 AR286 AR293 AR294 AR301
AR74.1 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 AR31.5
AR31.6 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 AR42.1 AR42.2 AR42.6
AR42.7 AR43.1 AR44.3 AR45.1 AR48.3 AR502
AR504 AR506 AR560 AR80.1 AR80.2 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 Company number. AR137 AR190
AR30.1 AR30.8
AR31.5 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
AR31.5 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 NumberUsed to identify the invoice. AR137 AR190
AR30.1 AR30.8
AR31.5 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 SequenBased on the terms of sale, this field AR137 AR190
is used as a counter to keep track of AR30.1 AR30.8
multiple payment obligations. AR31.5 AR33.3
Example - a sale of a $50,000 item: AR33.5 AR34.1
Customer to pay 10,000 at the end of AR42.1 AR42.2
the first month, 30,000 the second AR42.6 AR42.7
month, and 10,000 the third month. Thus, AR43.1 AR44.3
three AROITEMS records would be created. AR502 AR560
This field would be used to keep the AR82.1 ARLL.1
three obligations unique. DT92.1
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 AR31.5
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 entry) AR21.1 AR21.2
1 = Open transaction AR21.3 AR30.1
2 = Select for BOE Application AR30.8 AR31.5
5 = Application by BOE AcAct = N AR31.6 AR33.1
6 = Application by BOE AcAct = Y AR33.3 AR33.5
7 = Fully applied transaction AR33.6 AR34.1
8 = Closed transaction AR35.1 AR35.2
9 = Historical transaction 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 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
AR31.5 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
AR31.5 AR33.3
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR50.1 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 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 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 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
AR35.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 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR502 AR504
AR72.1 AR80.1
AR80.2 CB06.2
ARO-DISPUTE-SEQ Numeric 3 AR190 AR45.1
Element: Dispute SequenThe number of dispute records for this AR506
open item.
ARO-DUE-DATE Numeric 8 (yyyymmdd) AR115 AR130
Element: Due Date The due date of the open item. AR137 AR190
AR30.1 AR30.8
AR31.5 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 AR31.5
Element: Discount Date The discount date of the open item. AR33.5 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 AR31.5
Element: Discount PerceDiscount percent. AR33.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 ARLL.1
DT92.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 AR31.5 AR33.3
currency transaction. AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR50.1 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 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
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
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 AR31.6
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 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
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 AR42.1
Element: 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 ARLL.1
performing the activity.
ARO-ACCT-CATEGORY Alpha 5 AR190 AR42.1
Element: Account CategoAccount 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 ARLL.1
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.
Valid account category types are:
cost
revenue
accrual
pass thru
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 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
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: AR80.1 AR80.2
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 AR180 AR25.1
Extract adjustment. Valid values are: AR80.1 AR80.2
0 = Not extracted
8 = Adjustment made
9 = Extracted
ARO-EFT-ACTION Alpha 1 AR110 AR180
Element: EFT Action Indicates the action taken on an EFT AR25.1 AR80.1
transaction. Valid values are: AR80.2
Blank = Not within due date range
0 = Eligible
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 AR31.5 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 Nbr
ARO-AR-TERM Derived
Element: Ar Term
ARO-HIST-PER Numeric 2 AR180 AR198
Element: Hist Per AR80.1 AR80.2
ARO-INVL-OBJ-ID Numeric 12
Element: Invl Obj Id
ARO-CUST-PO-NBR Alpha 22 AR115 AR130
Element: Customer P.O. The customer purchase order number. AR190 AR30.1
AR30.8 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
AR560 ARLL.1
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. AR31.5 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 AR31.5
AR31.6 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 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: Transaction CoA transaction code represents a type of AR137 AR190
cash payment, bill of exchange payment, AR30.1 AR30.8
or bank service transaction. AR31.5 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-BANK-INST-TYPE Alpha 1 AR115 AR130
Transaction Code Payment code. Indicates the payment AR137 AR190
Type type. Valid values are: AR30.1 AR30.8
AR31.5 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 AR42.2 AR42.7
AR43.1 AR502
AR560 ARLL.1
ARO-SORT-2 Alpha 32 (Lower Case) AR190 AR42.1
Element: Sort 2 AR42.2 AR42.7
AR43.1 AR502
AR560 ARLL.1
ARO-SORT-3 Alpha 32 (Lower Case) AR190 AR42.1
Element: Sort 3 AR42.2 AR42.7
AR43.1 AR502
AR560 ARLL.1
ARO-SORT-4 Alpha 32 (Lower Case) AR190 AR42.1
Element: Sort 4 AR42.2 AR42.7
AR43.1 AR502
AR560 ARLL.1
ARO-ORIG-CURRENCY Alpha 5 AR115 AR130
Element: Original CurreTransaction currency. The currency in AR137 AR190
which the transaction was added to the AR30.1 AR30.8
system. AR31.5 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
Account Currency The number of decimals defined for the AR137 AR190
Code transaction currency in the Lawson AR30.1 AR30.8
Currency system. AR31.5 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 AR31.5 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 Number The batch number associated with the AR137 AR190
invoice or debit memo. AR30.1 AR30.8
AR31.5 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
Currency The currency multiplier or divider. AR137 AR190
Multiply/Divide Mathematical technique used in AR30.1 AR30.8
conjunction with the currency exchange AR31.5 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
AR31.5 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: General LedgerThe general ledger posting date AR137 AR190
assigned to the invoice or debit memo. AR30.1 AR30.8
AR31.5 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
Accounts Receivable The accounts receivable code that AR137 AR190
Code identifies the accounts receivable AR30.1 AR30.8
general ledger account for this AR31.5 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 Indicates whether this invoice or debit AR137 AR190
memo is subject to revaluation if its AR30.1 AR30.8
currency differs from the company AR31.5 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
AR30.1 AR30.8
AR31.5 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
debit memo or invoice. AR30.1 AR30.8
AR31.5 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 AR31.5 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
Group The currency multiplier or divider. AR137 AR190
Multiply/Divide Mathematical technique used in AR30.1 AR30.8
conjunction with the currency exchange AR31.5 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 NumbeSales representative for this invoice AR137 AR190
or debit memo. AR30.1 AR30.8
AR31.5 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 AR137 AR190
AR30.1 AR30.8
AR31.5 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. AR31.5 AR33.3
Valid values are: AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
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 AR31.5 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
AR31.5 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: Terms Code Terms code for this invoice or debit AR137 AR190
memo. Must be a valid terms code. AR30.1 AR30.8
AR33.3 AR33.5
AR34.1 AR42.6
AR44.3 AR502
AR82.1 ARLL.1
ARO-AC-CUSTOMER-ID Alpha 5 AR115 AR130
Element: Ac Customer Id AR137 AR190
AR30.1 AR30.8
AR33.3 AR33.5
AR34.1 AR42.6
AR44.3 AR502
AR82.1 ARLL.1
ARO-ADJ-FL Alpha 1 AR560 ARLL.1
Tax Distrib. Flag -
Tax Code 1
AROITEMS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AROSET1 COMPANY This path is used for record AR01.1 AR105
TRANS-TYPE uniqueness. AR115 AR124
INVOICE KeyChange AR129 AR130
PAYMENT-SEQ AR131 AR132
AR135 AR137
AR141 AR150
AR180 AR190
AR191 AR196
AR20.1 AR21.1
AR21.2 AR21.3
AR21.6 AR229
AR230 AR232
AR233 AR235
AR24.1 AR245
AR25.1 AR250
...
AROSET10 COMPANY KeyChange, Subset AR30.1 AR33.1
CUSTOMER Where STATUS = 1 AR72.1 AR90.1
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET11 COMPANY KeyChange, Subset AR129 AR30.1
CUSTOMER Where STATUS = 1 AR33.1 AR72.1
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET12 COMPANY KeyChange, Subset AR30.1 AR33.1
CUSTOMER Where STATUS = 1 AR72.1
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET13 COMPANY KeyChange, Subset AR30.1 AR33.1
CUSTOMER Where STATUS = 1 AR72.1
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET14 ACTIVITY KeyChange
STATUS
TRANS-DATE
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET2 COMPANY This path is used to select a AR130 AR131
CUSTOMER customer's open records in due date AR135 AR234
DUE-DATE order. AR271 AR30.1
TRANS-TYPE KeyChange, Subset AR30.8 AR33.1
INVOICE Where STATUS = 1 AR33.3 AR44.1
PAYMENT-SEQ Or STATUS = 2 AR72.1 AR90.1
DT520
AROSET3 COMPANY This path is used to select a AR100 AR110
CUSTOMER customer's open records in trans type AR112 AR12.1
TRANS-TYPE and invoice number order. AR12.2 AR129
INVOICE KeyChange, Subset AR130 AR131
PAYMENT-SEQ Where STATUS = 1 AR135 AR137
AR140 AR150
AR194 AR196
AR227 AR25.1
AR250 AR251
AR252 AR253
AR255 AR256
AR30.1 AR30.2
AR30.6 AR30.8
AR31.6 AR33.1
AR33.3 AR33.6
...
AROSET4 COMPANY This path is used to select a AR136 AR161
CUSTOMER customer's open records in transaction AR196 AR198
TRANS-DATE date order. AR256 AR258
TRANS-TYPE KeyChange, Subset AR275 AR44.1
INVOICE Where STATUS > Zeroes AR520 AR90.1
PAYMENT-SEQ And STATUS < 9
AROSET5 COMPANY This path is used to select a AR10.1 AR129
CUSTOMER customer's records in transaction type AR131 AR191
TRANS-TYPE and transaction number order. AR230 AR245
INVOICE KeyChange AR251 AR252
PAYMENT-SEQ AR253 AR255
AR256 AR286
AR293 AR294
AR300 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
AR504 AR506
...
AROSET6 COMPANY This path is used to select a AR137 AR150
CUSTOMER customer's non-historical transactions. AR194 AR250
TRANS-TYPE KeyChange, Subset AR251 AR252
INVOICE Where STATUS > Zeroes AR253 AR255
PAYMENT-SEQ And STATUS < 9 AR294 AR50.1
AROSET7 COMPANY This path is used to access a AR30.1 AR33.1
CUSTOMER customer's open records in Activity AR72.1
ACTIVITY order.
TRANS-TYPE KeyChange, Subset
INVOICE Where STATUS = 1
PAYMENT-SEQ
AROSET8 COMPANY This path is used to access a AR129 AR131
ALT-TYPE transaction's header record. AR150 AR191
INVOICE KeyChange AR21.6 AR29.3
PAYMENT-SEQ AR30.1 AR30.6
AR33.1 AR34.1
AR34.2 AR42.1
AR42.2 AR42.6
AR42.7 AR42.8
AR43.1 AR560
AR58.1 AR90.1
ARLL.1
AROSET9 COMPANY This path is used to access a company's AR131 AR227
TRANS-TYPE open records in transaction type and AR250 AR287
TRANS-DATE number order. AR33.1 AR58.2
INVOICE KeyChange, Subset
PAYMENT-SEQ Where STATUS = 1
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
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
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
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
Pbclient PBCLIENT
ARO-COMPANY -> PCC-POST-COMPANY
ARO-CUSTOMER -> PCC-CUSTOMER
PCC-COMPANY
PCC-PROCESS-LEVEL
|