Lawson Insight Technical Documentation |
|
ARAPPLIED
ARAPPLIED FILE
AR Application
The AR Application file contains cash application records which serve as
linking or audit records for each application made. Applications originate
from one of four sources. The four sources are; applications made with
payments, applications made with credit memos, "adjustments" (partial or full
write-offs and full chargebacks), or applications that have transferred
liability from an open item to a bill of exchange.
REFERENCED BY
AR150 AR161 AR191 AR194 AR196 AR230
AR232 AR235 AR250 AR251 AR252 AR253
AR255 AR256 AR274 AR275 AR286 AR287
AR36.1 AR36.2 AR53.1 AR82.1 DT170 DT180
DT181 GL235 AR29.1 AR29.2 AR223 DT155
AR199 AR233 AR50.1
UPDATED BY
AR115 AR124 AR129 AR130 AR131 AR132
AR135 AR137 AR180 AR190 AR20.1 AR21.1
AR21.2 AR21.3 AR24.1 AR30.1 AR30.8 AR300
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 AR570 AR575 AR580 AR80.1
AR80.2 ARLL.1 CB06.2 CB191 DT150 DT45.1
DT92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARA-COMPANY Numeric 4 AR129 AR130
Element: Company Identifies the AP company if the AR131 AR135
resource type = V. Identifies the HR AR180 AR30.1
company if the resource type = E. It is AR30.8 AR31.5
blank for type A, P or Q resources. AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.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
ARA-TRANS-TYPE Alpha 1 AR129 AR130
Element: Transaction TyThe type of transaction referenced by AR131 AR135
this application. Valid values are: AR180 AR30.1
AR30.8 AR31.5
C = Credit memo AR31.6 AR33.1
D = Debit memo AR33.3 AR33.5
I = Invoice AR33.6 AR34.1
P = Payment AR35.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
ARA-INVOICE Alpha 22 AR129 AR130
Element: Invoice NumberUsed to identify the invoice. AR131 AR135
AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.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
ARA-PAYMENT-SEQ Numeric 6 AR129 AR130
Element: Payment SequenPayment Sequence. This is the generated AR131 AR135
sequence number to separate individual AR180 AR30.1
invoice payment requirements. AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.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
ARA-BATCH-NBR Numeric 6 AR129 AR130
Element: Batch Number This identifies the batch the entered AR131 AR135
invoices, debit memos, credit memos, or AR180 AR30.1
payments are a part of. AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR504
AR560 AR80.1
AR80.2 ARLL.1
DT150 DT45.1
ARA-APP-SEQ Numeric 7 AR129 AR130
Element: Application SeThe number of applications made to a AR131 AR135
specific transaction. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.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
ARA-STATUS Numeric 1 AR115 AR124
Element: Status Represents the processing position AR129 AR130
within the posting cycle. For example, AR131 AR132
if the application was made during the AR135 AR180
entry and application of cash in AR30 AR190 AR20.1
(Cash Entry and Application), the status AR21.1 AR21.2
will be 0. When that batch of cash is AR21.3 AR24.1
released, the status will be changed AR30.1 AR30.8
depending on the following set of rules: AR31.5 AR31.6
AR33.1 AR33.3
If an application is made by other than AR33.5 AR33.6
the entry and apply method, or when the AR34.1 AR35.2
cash batch is released, the status will AR42.1 AR42.2
be set to 2 if the debit company AR42.6 AR42.7
requires an audit of applications (Yes AR43.1 AR44.3
selected in the Review Applications AR48.3 AR502
field in AR01.2). The status will be set AR504 AR560
to a 4 if the debit company does not AR570 AR575
require an audit of applications (No AR580 AR80.1
selected in the Review Applications AR80.2 ARLL.1
field in AR01.2). Valid values are: CB191 DT150
DT45.1 DT92.1
0 = Unreleased
2 = Requires audit listing
4 = Available for posting
5 = Posted
ARA-APPLD-AMT Signed 18.2 AR129 AR130
Element: Applied AmountThe amount applied to the transaction AR131 AR135
by this payment or credit memo. 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 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
ARLL.1 DT150
DT45.1 DT92.1
ARA-ADJ-AMT Signed 18.2 AR129 AR130
Element: Adjustment AmoThe total amount of adjustments made AR131 AR135
with this application. AR180 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 AR44.3
AR48.3 AR504
AR80.1 AR80.2
DT45.1
ARA-ADJ-SEQ Numeric 3 AR129 AR130
Element: Adjustment SeqThe last adjustment sequence number for AR131 AR135
this application record. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ARA-CR-COMPANY Numeric 4 AR129 AR130
Payment Transaction The company number associated with the AR131 AR135
Company applied payment or credit memo. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
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
ARA-CR-CUSTOMER Alpha 9 (Right Justified) AR129 AR130
Payment Transaction The customer number associated with the AR131 AR135
Customer applied payment or credit memo. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
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
ARA-CR-BATCH Numeric 6 AR129 AR130
Element: Cash Batch NumThe cash batch number associated with AR131 AR135
the applied payment or credit memo. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.2 AR42.1
AR42.2 AR42.7
AR43.1 AR44.3
AR48.3 AR504
AR560 AR80.1
AR80.2 ARLL.1
DT150 DT45.1
ARA-CR-PYMNT-SEQ Numeric 6 AR129 AR130
Element: Payment SequenThe sequence number of the payment AR131 AR135
within the cash batch. This field will AR180 AR30.1
be 0 if the application was from a AR30.8 AR31.5
credit memo or an adjustment. AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.2 AR42.1
AR42.2 AR42.7
AR43.1 AR44.3
AR48.3 AR504
AR80.1 AR80.2
DT150 DT45.1
ARA-CR-TYPE Alpha 1 AR129 AR130
Element: Payment Type The transaction type of the payment. AR131 AR135
Valid values are: AR180 AR30.1
B = Bill of Exchange AR30.8 AR31.5
C = Credit Memo AR31.6 AR33.1
D = Debit Memo AR33.3 AR33.5
P = Payment 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
ARA-CR-NBR Alpha 22 AR129 AR130
Payment Transaction The transaction number of the applied AR131 AR135
Number payment or credit memo. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
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
ARA-CR-SUFFIX Numeric 3 AR180 AR42.1
Credit Memo Suffix Suffix number needed for file AR42.2 AR42.6
Number relationships. AR42.7 AR43.1
AR44.3 AR502
AR560 AR80.1
AR80.2 ARLL.1
DT150 DT45.1
DT92.1
ARA-CR-CANCEL-SEQ Numeric 4 AR180 AR80.1
Element: BOE Cancel SeqThe bill of exchange cancel sequence AR80.2 DT45.1
number.
ARA-CR-APP-SEQ Numeric 7 AR129 AR130
Application Sequence number of the application made AR131 AR135
Sequence Number with this payment or credit memo. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
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
ARA-CR-APP-AMT Signed 18.2 AR129 AR130
Payment Applied The amount in payment in the currency AR131 AR135
Amount of the payment or credit memo that was AR180 AR20.1
applied against the 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
AR80.1 AR80.2
ARLL.1 DT150
DT45.1 DT92.1
ARA-CR-ORIG-AP-AMT Signed 18.2 AR129 AR130
Element: Intl Amt The amount of the application in the AR131 AR135
currency of the payment. AR180 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 AR504
AR560 AR80.1
AR80.2 ARLL.1
DT150 DT45.1
ARA-CR-ADJ-SEQ Numeric 3 AR129 AR130
Credit Adjustment The sequence number of the credit AR131 AR135
Sequence adjustment. AR180 AR31.6
AR33.1 AR33.6
AR48.3 AR504
AR80.1 AR80.2
ARA-CR-ADJ-AMT Signed 18.2 AR129 AR130
Credit Adjustment The amount of the credit adjustment. AR131 AR135
Amount AR180 AR30.1
AR30.8 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3 AR504
AR80.1 AR80.2
ARA-DEPOSIT-DATE Numeric 8 (yyyymmdd) AR129 AR130
Element: Deposit Date The deposit date of the payment, or the AR131 AR135
general ledger date of the credit memo. AR180 AR30.1
This date is used in calculations such AR30.8 AR31.5
as IPA, DBT, and so on. AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.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
ARA-OPR-CODE Alpha 10 (Lower Case) AR129 AR130
Element: Operator Code The operator code used to create the AR131 AR135
application. If the operator is required AR180 AR30.1
at the company level, must be a valid AR30.8 AR31.5
operator code defined in AR15.6 AR31.6 AR33.1
(Operator). If the operator is not AR33.3 AR33.5
required, this is the operator's system AR33.6 AR34.1
logon ID. 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
ARA-GL-DATE Numeric 8 (yyyymmdd) AR129 AR130
Element: General LedgerThe general ledger posting date of the AR131 AR135
application. Either the general ledger AR180 AR30.1
date of the applied payment or credit AR30.8 AR31.5
memo or the system date of the AR31.6 AR33.1
application defaults depending on the AR33.3 AR33.5
options defined for the company. For AR33.6 AR34.1
partial and full write-offs, the AR35.1 AR35.2
application general ledger date defined AR42.1 AR42.2
by the operator will be used. All AR42.6 AR42.7
application general ledger dates are AR43.1 AR44.3
maintainable by the operator. AR48.3 AR502
AR504 AR560
AR80.1 AR80.2
ARLL.1 DT150
DT45.1 DT92.1
ARA-AR-CODE Alpha 4 AR129 AR130
Accounts Receivable The accounts receivable code used to AR131 AR135
Code identify the general ledger account that AR180 AR30.1
is to be credited. This is normally the AR30.8 AR31.5
accounts receivable code assigned to the AR31.6 AR33.1
invoice or debit memo being paid. AR33.3 AR33.5
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
ARA-OFFSET-CODE Alpha 4 AR129 AR130
Element: Offset Code The accounts receivable code that AR131 AR135
identifies the offset general ledger AR180 AR30.1
account that is debited when application AR30.8 AR31.6
occurs. For payment applications, this AR33.1 AR33.3
is the RNA code or Prepay code. For AR33.6 AR34.1
credit applications, this is the AR code AR42.1 AR42.2
assigned to the credit memo. AR42.6 AR42.7
AR43.1 AR44.3
If grouping by a bill of exchange, this AR48.3 AR502
is the AR code assigned to the bill of AR504 AR560
exchange process level. AR80.1 AR80.2
ARLL.1 DT150
DT45.1 DT92.1
ARA-APP-SOURCE Alpha 1 AR129 AR130
Element: Application SoIndicates how the application was made. AR131 AR135
Valid values are: AR180 AR30.1
AR30.8 AR31.5
A = Automatic cash application AR31.6 AR33.1
C = Converted application record AR33.3 AR33.5
M = Manual cash application AR33.6 AR34.1
R = Payment reversal application AR35.2 AR42.1
X = Automatic memo application AR42.2 AR42.6
B = Bill of Exchange AR42.7 AR43.1
E = Electronic Funds Transfer AR44.3 AR48.3
W = Automatic Write Off AR502 AR504
T = Transfer to AP AR560 AR80.1
S = Mixed Signed Application AR80.2 ARLL.1
G = Grouped Memo DT150 DT45.1
DT92.1
ARA-RESULT-FL Alpha 1 AR129 AR130
Element: Application ReIndicates the result of the application AR131 AR135
as it relates to the invoice or debit AR137 AR180
memo. It tracks fully applied status and AR190 AR30.1
timeliness of the application. Valid AR30.8 AR31.5
values are: AR31.6 AR33.1
AR33.3 AR33.5
C = Credit application AR33.6 AR34.1
D = Partially applied (late) AR35.2 AR42.1
F = Fully applied (on time) AR42.2 AR42.6
L = Fully applied (late) AR42.7 AR43.1
P = Partially applied (on time) AR44.3 AR48.3
W = Finance charge assessed AR502 AR504
B = Bill of Exchange AR560 AR80.1
X = Partially applied (late) with AR80.2 ARLL.1
charges assessed DT150 DT45.1
Y = Fully applied (late) with charges DT92.1
assessed
ARA-ORIG-APP-AMT Signed 18.2 AR129 AR130
Transaction The application amount in transaction AR131 AR135
Application Amount currency. AR180 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
AR80.1 AR80.2
ARLL.1 DT150
DT45.1 DT92.1
ARA-APP-CURR-CD Alpha 5 AR129 AR130
Application The currency of the application. AR131 AR135
Currency Code AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR560
AR80.1 AR80.2
ARLL.1 DT150
DT45.1 DT92.1
ARA-APP-CURR Alpha 1 AR129 AR130
Application This field indicates what type of AR131 AR135
Currency Type application occurred in terms of AR180 AR30.1
currency. Valid values are: AR30.8 AR31.5
AR31.6 AR33.1
B = Base AR33.3 AR33.5
N = Non-base AR33.6 AR34.1
M = Mixed 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
ARA-REVERSE-FL Alpha 1 AR180 AR42.1
Element: Reversal Indicates whether an application was AR42.2 AR42.6
reversed after posting to the general AR42.7 AR43.1
ledger. If a reversal is created in AR80 AR502 AR560
(Payment Application Reversal) or AR180 AR80.1 AR80.2
(Payment Application Reversal Creation), ARLL.1 DT45.1
the system creates the appropriate DT92.1
reversing journal entries. Valid values
are:
N = No reversal
Y = Reversal application record
ARA-PREPAY-FLAG Numeric 1 AR129 AR130
Element: Prepayment FlaIndicates if payment is a prepayment. AR131 AR135
AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR48.3 AR80.1
AR80.2
ARA-DELETE-FL Alpha 1 AR300
Element: Delete Fl C = Credit Memo Deleted
D = Debit Memo Deleted
I = Invoice Deleted
P = Payment Deleted
ARA-AR-CUST-PO-NBR Derived
Element: Ar Cust Po Nbr
ARA-AR-DUE-DATE Derived
Element: Ar Due Date
ARAPPLIED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARASET1 COMPANY This is the primary path used to access AR135 AR137
TRANS-TYPE applied records by transaction number. AR150 AR161
INVOICE KeyChange AR180 AR190
PAYMENT-SEQ AR191 AR194
BATCH-NBR AR196 AR230
APP-SEQ AR232 AR235
AR250 AR251
AR252 AR253
AR255 AR256
AR274 AR275
AR286 AR287
AR300 AR35.1
AR35.2 AR36.1
AR36.2 AR37.6
AR37.7 AR37.8
...
ARASET2 CR-COMPANY This path is used to access AR115 AR124
CR-BATCH applications made by payments. AR137 AR150
CR-PYMNT-SEQ KeyChange, Subset AR191 AR194
COMPANY Where CR-TYPE = "P" AR20.1 AR21.1
TRANS-TYPE AR21.2 AR21.3
INVOICE AR24.1 AR250
PAYMENT-SEQ AR251 AR252
BATCH-NBR AR253 AR255
APP-SEQ AR256 AR275
AR286 AR287
AR29.1 AR29.2
AR30.1 AR300
AR34.1 AR37.1
AR37.2 AR570
AR575 AR580
...
ARASET3 CR-COMPANY This path is used to select non AR135 AR137
CR-CUSTOMER write-off applications. AR150 AR161
CR-TYPE KeyChange, Subset AR190 AR194
CR-NBR Where CR-COMPANY != Zeroes AR196 AR223
CR-PYMNT-SEQ AR230 AR232
CR-BATCH AR235 AR250
CR-SUFFIX AR251 AR252
CR-CANCEL-SEQ AR253 AR255
CR-APP-SEQ AR256 AR275
AR286 AR30.1
AR34.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR37.8
...
ARASET4 COMPANY This path will be used to select AR132 AR135
TRANS-TYPE applications that need audits (status 2) AR190 AR199
INVOICE and those records that are not yet AR233 AR48.1
PAYMENT-SEQ updated in the GL (status 2 & 4). When AR50.1
BATCH-NBR the selections are made for audits, the
APP-SEQ selection of status 2 only will need to
be handled programatically.
KeyChange, Subset
Where STATUS = Zeroes
Or STATUS = 2
Or STATUS = 4
ARASET5 COMPANY This path is used to access AR180 AR232
GL-DATE applications by general ledger date for AR300
TRANS-TYPE reporting purposes.
INVOICE KeyChange
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
CR-COMPANY
CR-BATCH
CR-PYMNT-SEQ
ARASET6 CR-COMPANY This path is used to access the credit AR230
GL-DATE side of applications by general ledger
CR-CUSTOMER date.
CR-TYPE KeyChange, Subset
CR-NBR Where CR-COMPANY != Zeroes
CR-PYMNT-SEQ
CR-SUFFIX
CR-CANCEL-SEQ
CR-BATCH
CR-APP-SEQ
ARAPPLIED FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ARA-COMPANY -> ACO-COMPANY
Arcrcomp ARCOMP Required
When ARA-CR-COMPANY != Zeroes
ARA-CR-COMPANY -> ACO-COMPANY
Arcrcustomer ARCUSTOMER Required
When ARA-CR-CUSTOMER != Spaces
And ARA-CR-CUSTOMER != "000000000"
ARA-CR-COMPANY -> ACM-COMPANY
ARA-CR-CUSTOMER -> ACM-CUSTOMER
Aroihdr AROIHDR Required
ARA-COMPANY -> ARH-COMPANY
ARA-TRANS-TYPE -> ARH-TRANS-TYPE
ARA-INVOICE -> ARH-INVOICE
Aroitems AROITEMS Required
ARA-COMPANY -> ARO-COMPANY
ARA-TRANS-TYPE -> ARO-TRANS-TYPE
ARA-INVOICE -> ARO-INVOICE
ARA-PAYMENT-SEQ -> ARO-PAYMENT-SEQ
Arpayment ARPAYMENT Required
ARA-CR-COMPANY -> APM-COMPANY
ARA-CR-BATCH -> APM-BATCH-NBR
ARA-CR-TYPE -> APM-TRANS-TYPE
ARA-CR-NBR -> APM-TRANS-NBR
ARA-CR-CUSTOMER -> APM-CUSTOMER
Custdescpay CUSTDESC Required
When ARA-CR-CUSTOMER != Spaces
And ARA-CR-CUSTOMER != "000000000"
ACO-CUST-GROUP -> CUD-CUST-GROUP
ARA-CR-CUSTOMER -> CUD-CUSTOMER
ARAPPLIED FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aradjust ARADJUST Delete Cascades
ARA-COMPANY -> ADJ-COMPANY
ARA-TRANS-TYPE -> ADJ-TRANS-TYPE
ARA-INVOICE -> ADJ-INVOICE
ARA-PAYMENT-SEQ -> ADJ-PAYMENT-SEQ
ARA-BATCH-NBR -> ADJ-BATCH-NBR
ARA-APP-SEQ -> ADJ-APP-SEQ
ADJ-ADJ-SEQ
Ardrafts ARDRAFTS Required
ARA-CR-COMPANY -> ARD-COMPANY
ARA-CR-NBR -> ARD-AR-DRAFT-NBR
ARA-CR-SUFFIX -> ARD-SUFFIX
ARA-CR-CUSTOMER -> ARD-CUSTOMER
Zeroes -> ARD-CANCEL-SEQ
ARD-DRAFT-SOURCE
|