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 AR191 AR194 AR229
AR230 AR232 AR233 AR235 AR24.1 AR245
AR250 AR251 AR252 AR253 AR255 AR256
AR274 AR282 AR36.1 AR36.2 AR46.1 AR53.1
AR570 AR575 AR58.1 AR58.2 AR580 AR72.1
AR80.1 AR80.2 AR90.1 BR11.1 BRIP.1 BRPI.1
CB191 PBIP.1 PHI3.1 WH20.7 AR140 AR234
AR271 DT520 AR112 AR12.1 AR12.2 AR227
AR50.1 AR505 AR161 AR258 AR275 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.2 AR30.3
AR30.4 AR30.8 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 AR48.3 AR502 AR504 AR506
AR560 AR82.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.2
AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR72.1
AR82.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.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
DT92.1
ARO-INVOICE Alpha 22 AR115 AR130
Element: Invoice NumberUsed to identify the invoice. 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 AR72.1
AR82.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.2
multiple payment obligations. AR30.4 AR30.8
Example - a sale of a $50,000 item: AR31.5 AR42.1
Customer to pay 10,000 at the end of AR42.2 AR42.6
the first month, 30,000 the second AR42.7 AR43.1
month, and 10,000 the third month. Thus, AR44.3 AR502
three AROITEMS records would be created. AR560 AR82.1
This field would be used to keep the DT92.1
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.2 AR30.4
AR30.8 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.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.2 AR30.3
5 = Application by BOE AcAct = N AR30.4 AR30.8
6 = Application by BOE AcAct = Y AR31.5 AR31.6
7 = Fully applied transaction AR35.1 AR35.2
8 = Closed transaction AR37.1 AR37.2
9 = Historical transaction 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 AR82.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
listed this transaction.
ARO-TRANS-DATE Numeric 8 (yyyymmdd) AR115 AR130
Element: Transaction DaThe 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 DT92.1
ARO-TRAN-AMT Signed 15.2 AR115 AR130
Element: Transaction AmThe 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 AR82.1
AR90.1 DT45.1
DT92.1
ARO-APPLD-AMT Signed 15.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.2 AR30.3
AR30.4 AR30.8
AR31.6 AR35.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR72.1 CB06.2
DT150 DT45.1
DT92.1
ARO-APPLIED-SEQ Numeric 5 AR129 AR130
Element: Application SeNumber of applications made for this AR131 AR135
open item. AR180 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
AR48.3 AR502
AR504 AR560
DT150 DT45.1
DT92.1
ARO-ADJ-AMT Signed 15.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.2 AR30.3
AR30.4 AR30.8
AR31.6 AR35.1
AR35.2 AR44.3
AR48.3 AR502
AR504 AR72.1
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.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 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.
ARO-DISC-DATE Numeric 8 (yyyymmdd) Occurs 3 Times AR115 AR31.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 DT92.1
ARO-DISC-PCT Percent 7.5 (Percent) Occurs 3 Times AR115 AR31.5
Element: Discount PerceDiscount percent. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
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 15.2 AR115 AR130
Element: Transaction AmThe 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 AR82.1
AR90.1 DT92.1
ARO-ORIG-APP-AMT Signed 15.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.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 AR48.3
AR502 AR504
AR560 AR72.1
CB06.2 DT150
DT45.1 DT92.1
ARO-ORIG-ADJ-AMT Signed 15.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.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 AR48.3
AR502 AR504
AR72.1 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
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
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
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 AR72.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.
ARO-LINE-NBR Numeric 6 AR42.1 AR42.2
Element: Line Item NumbThis field contains the line number. AR42.7 AR43.1
AR560
ARO-LINE-TYPE Alpha 1 AR560
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 AR560
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
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
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: AR37.1 AR37.2
AR37.3 AR37.4
0 = Not extracted AR37.5 AR37.6
8 = Adjustment made AR37.7
9 = Extracted
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
1 = Added
2 = Postponed
3 = Deleted
5 = Added postponed
6 = Hold
ARO-GAINLOS-AMT Signed 15.2 AR196
Element: Adj 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 C = Credit Memo AR137 AR190
D = Debit Memo AR30.1 AR30.2
I = Invoice AR30.4 AR30.8
M = Mixed AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR72.1
AR82.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: Current Period
ARO-INVL-OBJ-ID Numeric 12
Element: Invl Obj Id
ARO-CUST-PO-NBR Alpha 22 AR130 AR190
Element: Customer P.O. The customer purchase order number. AR30.1 AR30.2
AR30.4 AR30.8
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR502
AR560
ARO-TRANS-USER1 Alpha 10 AR190 AR42.1
Element: Cust User1 User-defined field 1. Can be used as a AR42.2 AR42.6
selection criteria or for sorting in the AR42.7 AR43.1
Lawson Accounts Receivable system. AR502 AR560
ARO-PROCESS-LEVEL Alpha 5 AR130 AR137
Element: Process Level This field contains the process level, AR190 AR30.1
which is the reporting hierarchy below AR30.2 AR30.4
company. AR30.8 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR82.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.2 AR30.3
AR30.4 AR30.8
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 AR48.3
AR502 AR504
AR560 AR82.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.2
or bank service transaction. AR30.4 AR30.8
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.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.2
AR30.4 AR30.8
C = Cash AR31.5 AR42.1
D = Bill of Exchange AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR82.1
ARO-SORT-1 Alpha 32 (Lower Case) AR190 AR502
Element: Sort 1 AR560
ARO-SORT-2 Alpha 32 (Lower Case) AR190 AR502
Element: Sort 2 AR560
ARO-SORT-3 Alpha 32 (Lower Case) AR190 AR502
Element: Sort 3 AR560
ARO-SORT-4 Alpha 32 (Lower Case) AR190 AR502
Element: Sort 4 AR560
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. AR110 AR115
INVOICE AR124 AR129
PAYMENT-SEQ AR130 AR131
AR132 AR135
AR137 AR150
AR180 AR190
AR191 AR194
AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR21.6
AR229 AR230
AR232 AR233
AR235 AR24.1
AR245 AR25.1
...
AROSET10 COMPANY KeyChange, Subset AR30.1 AR30.2
CUSTOMER Where STATUS = 1 AR30.3 AR72.1
SORT-AMOUNT* AR90.1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET11 COMPANY Subset AR30.1 AR30.2
CUSTOMER Where STATUS = 1 AR30.3 AR72.1
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET12 COMPANY Subset AR30.1 AR30.2
CUSTOMER Where STATUS = 1 AR30.3 AR72.1
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AROSET13 COMPANY Subset AR30.1 AR30.2
CUSTOMER Where STATUS = 1 AR30.3 AR72.1
PROCESS-LEVEL
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 AR140
DUE-DATE order. AR234 AR271
TRANS-TYPE Subset AR30.1 AR30.2
INVOICE Where STATUS = 1 AR30.3 AR30.8
PAYMENT-SEQ Or STATUS = 2 AR44.1 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 Subset AR130 AR131
PAYMENT-SEQ Where STATUS = 1 AR135 AR137
AR150 AR194
AR196 AR227
AR25.1 AR250
AR251 AR252
AR253 AR255
AR256 AR30.1
AR30.2 AR30.3
AR30.8 AR30.9
AR31.6 AR45.1
AR48.1 AR50.1
...
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 Subset AR275 AR44.1
INVOICE Where STATUS > Zeroes 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 AR130 AR131
TRANS-TYPE and transaction number order. AR191 AR230
INVOICE AR245 AR251
PAYMENT-SEQ AR252 AR253
AR255 AR256
AR286 AR293
AR294 AR30.3
AR300 AR301
AR35.1 AR35.2
AR37.4 AR37.5
AR37.6 AR37.7
AR48.1 AR504
AR506 AR53.1
AR74.1 AR80.2
...
AROSET6 COMPANY This path is used to select a AR137 AR150
CUSTOMER customer's non-historical transactions. AR194 AR250
TRANS-TYPE 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 AR30.2
CUSTOMER customer's open records in Activity AR30.3 AR72.1
ACTIVITY order.
TRANS-TYPE Subset
INVOICE Where STATUS = 1
PAYMENT-SEQ
AROSET8 COMPANY This path is used to access a AR129 AR130
ALT-TYPE transaction's header record. AR131 AR150
INVOICE AR191 AR21.6
PAYMENT-SEQ AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.6
AR42.2 AR42.6
AR42.8 AR560
AR58.1 AR90.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. AR30.3 AR58.2
INVOICE 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
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
Reversedtl REVERSEDTL Delete Cascades
ARO-COMPANY -> RVD-COMPANY
ARO-TRANS-TYPE -> RVD-TRANS-TYPE
ARO-INVOICE -> RVD-INVOICE
ARO-PAYMENT-SEQ -> RVD-PAYMENT-SEQ
ARH-BATCH-NBR -> RVD-BATCH-NBR
RVD-APP-SEQ
|