 |
Lawson Insight Technical Documentation |
|
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 AR229 AR230
AR232 AR233 AR235 AR24.1 AR245 AR250
AR251 AR253 AR255 AR274 AR282 AR36.1
AR36.2 AR46.1 AR53.1 AR570 AR575 AR58.1
AR580 AR72.1 AR80.1 AR80.2 AR90.1 DA90.1
DA91.1 BR11.1 BRIP.1 CB191 PBIP.1 PHI3.1
WH20.7 AR234 AR271 DT520 AR12.1 AR140
AR194 AR227 AR252 AR256 AR161 AR258
AR275 AR505 AR10.1 AR286 AR293 AR294
AR301 AR74.1 AR50.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 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 AR48.3 AR502 AR504
AR506 AR560 AR82.1 CB06.2 DT150 DT170
DT180 DT181 DT45.1 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 AR72.1
AR82.1 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
DT92.1
ARO-INVOICE Alpha 22 AR115 AR130
Invoice Number Used 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
Payment Sequence Based 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
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
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.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
Last Statement Date The date of the last statement that AR560
listed this transaction.
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 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 AR82.1
AR90.1 DA90.1
DA91.1 DT45.1
DT92.1
ARO-APPLD-AMT Signed 15.2 AR129 AR130
Applied Amount The 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
Application Sequence Number 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
Adjustment Amount The 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
Dispute Sequence The number of dispute records for this AR506
open item.
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 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
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
Discount Percent Discount percent. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
DT92.1
ARO-DISC-PCT1 Derived
Disc Pct1 Redefinition of discount percent occurs
value one; for use in the discount one
compute amount field.
ARO-DISC-PCT2 Derived
Disc Pct2 Redefinition of discount percent occurs
two field; for use in the discount two
compute amount field.
ARO-DISC-PCT3 Derived
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
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 AR82.1
AR90.1 DA90.1
DA91.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
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
Disc Amt1 Derived value for discount amount one.
ARO-DISC-AMT2 Derived
Disc Amt2 Derived value for discount amount two.
ARO-DISC-AMT3 Derived
Disc Amt3 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
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
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
performing the activity.
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 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
Line Item Number This field contains the line number. AR42.7 AR43.1
AR560
ARO-LINE-TYPE Alpha 1 AR560
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
ARO-EFT-NOTE Numeric 1 AR100 AR105
Status of EFT Notice Indicates the status of the EFT note. AR180 AR25.1
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 AR180 AR25.1
Extract adjustment. Valid values are:
0 = Not extracted
8 = Adjustment made
9 = Extracted
ARO-EFT-ACTION Alpha 1 AR110 AR180
EFT Action Indicates the action taken on an EFT AR25.1
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-ALT-TYPE Alpha 1 AR115 AR130
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
Ar Cust Po Nbr
ARO-AR-TERM Derived
Ar Term
ARO-HIST-PER Numeric 2 AR180 AR198
Hist Per
ARO-INVL-OBJ-ID Numeric 12
Invl Obj Id
ARO-CUST-PO-NBR Alpha 22 AR130 AR190
Customer P.O. Number 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
Trans 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
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 AR130
Sort Amount AR137 AR190
AR30.1 AR30.2
AR30.4 AR30.8
AR31.5 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
AR502 AR560
AR82.1 DT150
DT170 DT180
DT181 DT45.1
DT92.1
ARO-BANK-INST-CODE Alpha 3 AR115 AR130
Transaction Code A 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.6
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.6
D = Bill of Exchange AR44.3 AR502
AR560 AR82.1
ARO-SORT-1 Alpha 32 (Lower Case) AR190 AR502
Sort 1 AR560
ARO-SORT-2 Alpha 32 (Lower Case) AR190 AR502
Sort 2 AR560
ARO-SORT-3 Alpha 32 (Lower Case) AR190 AR502
Sort 3 AR560
ARO-SORT-4 Alpha 32 (Lower Case) AR190 AR502
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. AR115 AR124
INVOICE AR129 AR130
PAYMENT-SEQ AR131 AR132
AR135 AR137
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 AR251
...
AROSET10 COMPANY KeyChange, Subset AR30.1 AR30.2
CUSTOMER Where STATUS = 1 AR30.3 AR72.1
SORT-AMOUNT*
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 AR234
CUSTOMER customer's open records in due date AR271 AR30.1
DUE-DATE order. AR30.2 AR30.3
TRANS-TYPE Subset AR30.8 AR44.1
INVOICE Where STATUS = 1 AR72.1 AR90.1
PAYMENT-SEQ Or STATUS = 2 DA90.1 DA91.1
DT520
AROSET3 COMPANY This path is used to select a AR100 AR110
CUSTOMER customer's open records in trans type AR12.1 AR129
TRANS-TYPE and invoice number order. AR130 AR131
INVOICE Subset AR135 AR137
PAYMENT-SEQ Where STATUS = 1 AR140 AR150
AR194 AR196
AR227 AR25.1
AR250 AR251
AR252 AR253
AR255 AR256
AR30.1 AR30.2
AR30.3 AR30.6
AR30.8 AR30.9
AR31.6 AR45.1
AR72.1 AR90.1
...
AROSET4 COMPANY This path is used to select a AR130 AR136
CUSTOMER customer's open records in transaction AR161 AR196
TRANS-DATE date order. AR198 AR256
TRANS-TYPE Subset AR258 AR275
INVOICE Where STATUS > Zeroes AR44.1 AR505
PAYMENT-SEQ And STATUS < 9 AR90.1 DA90.1
DA91.1
AROSET5 COMPANY This path is used to select a AR10.1 AR191
CUSTOMER customer's records in transaction type AR230 AR232
TRANS-TYPE and transaction number order. AR245 AR251
INVOICE AR252 AR253
PAYMENT-SEQ 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
AR90.1 DA90.1
...
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 AR150
ALT-TYPE transaction's header record. AR191 AR21.6
INVOICE AR29.3 AR30.1
PAYMENT-SEQ AR30.2 AR30.3
AR30.4 AR30.6
AR42.6 AR560
AR90.1
AROSET9 COMPANY This path is used to access a company's AR131 AR227
TRANS-TYPE open records in transaction type and AR287 AR30.3
TRANS-DATE number order.
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
|