|
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 main 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 AR232
AR235 AR239 AR250 AR251 AR252 AR253
AR255 AR256 AR257 AR265 AR274 AR275
AR286 AR287 AR296 AR36.1 AR36.2 AR53.1
AR800 AR82.1 DT170 DT180 DT181 GL235
AR29.1 AR29.2 AR50.1 AR223 AR230 DT155
AR199 AR233 AR237
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
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
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 The number representing an AR company. AR131 AR135
AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 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
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 AR32.1
C = Credit memo AR33.1 AR33.3
D = Debit memo AR33.5 AR33.6
I = Invoice AR34.1 AR35.1
P = Payment AR35.2 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
ARA-INVOICE Alpha 22 AR129 AR130
Element: Invoice Used to identify the invoice. AR131 AR135
AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 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
ARA-PAYMENT-SEQ Numeric 6 AR129 AR130
Element: Payment SequenA unique number assigned to each AR131 AR135
transaction to be interfaced into the AR180 AR30.1
Lawson system. AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 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
ARA-BATCH-NBR Numeric 6 AR129 AR130
Element: Batch Nbr This identifies the batch the entered AR131 AR135
invoices, debit memos, credit memos, or AR180 AR30.1
payments are a part of. AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.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
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: AR32.1 AR33.1
AR33.3 AR33.5
If an application is made by other than AR33.6 AR34.1
the entry and apply method, or when the AR35.2 AR38.1
cash batch is released, the status will AR38.2 AR38.3
be set to 2 if the debit company AR39.1 AR39.2
requires an audit of applications (Yes AR42.1 AR42.2
selected in the Review Applications AR42.6 AR42.7
field in AR01.2). The status will be set AR43.1 AR44.3
to a 4 if the debit company does not AR48.3 AR502
require an audit of applications (No AR504 AR560
selected in the Review Applications AR570 AR575
field in AR01.2). Valid values are: AR580 AR80.1
AR80.2 ARLL.1
0 = Unreleased CB191 DT150
2 = Requires audit listing DT45.1 DT92.1
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 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
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
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 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 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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
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
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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
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
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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
AR39.1 AR39.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 AR32.1
credit memo or an adjustment. AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
AR39.1 AR39.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-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 AR32.1
C = Credit Memo AR33.1 AR33.3
D = Debit Memo AR33.5 AR33.6
P = Payment AR34.1 AR35.2
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
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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
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
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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
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
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 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
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
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 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
AR38.1 AR38.2
AR38.3 AR39.1
AR39.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-CR-ADJ-SEQ Numeric 3 AR129 AR130
Credit Adjustment The sequence number of the credit AR131 AR135
Sequence adjustment. AR180 AR30.1
AR33.1 AR33.6
AR39.1 AR39.2
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
AR33.1 AR33.6
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
as IPA, DBT, and so on. AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 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
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 AR32.1
operator code defined in AR15.6 AR33.1 AR33.3
(Operator). If the operator is not AR33.5 AR33.6
required, this is the operator's system AR34.1 AR35.2
logon ID. 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
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 AR32.1
memo or the system date of the AR33.1 AR33.3
application defaults depending on the AR33.5 AR33.6
options defined for the company. For AR34.1 AR35.1
partial and full write-offs, the AR35.2 AR38.1
application general ledger date defined AR38.2 AR38.3
by the operator will be used. All AR39.1 AR39.2
application general ledger dates are AR42.1 AR42.2
maintainable by the operator. 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-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 AR32.1
accounts receivable code assigned to the AR33.1 AR33.3
invoice or debit memo being paid. AR33.5 AR33.6
AR34.1 AR35.2
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
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 AR32.1
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 AR39.1 AR39.2
assigned to the credit memo. AR42.1 AR42.2
AR42.6 AR42.7
If grouping by a bill of exchange, this AR43.1 AR44.3
is the AR code assigned to the bill of AR48.3 AR502
exchange process level. AR504 AR560
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 AR32.1
A = Automatic cash application AR33.1 AR33.3
C = Converted application record AR33.5 AR33.6
M = Manual cash application AR34.1 AR35.2
R = Payment reversal application AR39.1 AR39.2
X = Automatic memo application AR42.1 AR42.2
B = Bill of Exchange AR42.6 AR42.7
E = Electronic Funds Transfer AR43.1 AR44.3
W = Automatic Write Off AR48.3 AR502
T = Transfer to AP AR504 AR560
S = Mixed Signed Application AR80.1 AR80.2
G = Grouped Memo ARLL.1 DT150
J = Adjustment Maintenance 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 AR32.1
values are: AR33.1 AR33.3
AR33.5 AR33.6
C = Credit application AR34.1 AR35.2
D = Partially applied (late) AR39.1 AR39.2
F = Fully applied (on time) AR42.1 AR42.2
L = Fully applied (late) AR42.6 AR42.7
P = Partially applied (on time) AR43.1 AR44.3
W = Finance charge assessed AR48.3 AR502
B = Bill of Exchange AR504 AR560
X = Partially applied (late) with AR80.1 AR80.2
charges assessed ARLL.1 DT150
Y = Fully applied (late) with charges DT45.1 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 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
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
ARA-APP-CURR-CD Alpha 5 AR129 AR130
Application The currency of the application. AR131 AR135
Currency Code AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.2
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
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 AR32.1
AR33.1 AR33.3
B = Base AR33.5 AR33.6
N = Non-base AR34.1 AR35.2
M = Mixed 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
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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR39.1
AR39.2 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 KeyChange AR130 AR135
TRANS-TYPE AR137 AR150
INVOICE AR161 AR180
PAYMENT-SEQ AR190 AR191
BATCH-NBR AR194 AR196
APP-SEQ AR232 AR235
AR239 AR250
AR251 AR252
AR253 AR255
AR256 AR257
AR265 AR274
AR275 AR286
AR287 AR296
AR30.1 AR30.6
AR30.8 AR300
...
ARASET2 CR-COMPANY KeyChange, Subset AR115 AR124
CR-BATCH Where CR-TYPE = "P" AR137 AR150
CR-PYMNT-SEQ AR191 AR194
COMPANY 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 AR257
AR275 AR286
AR287 AR29.1
AR29.2 AR30.1
AR300 AR32.1
AR34.1 AR37.1
AR37.2 AR50.1
...
ARASET3 CR-COMPANY KeyChange, Subset AR130 AR135
CR-CUSTOMER Where CR-COMPANY != Zeroes AR137 AR150
CR-TYPE AR161 AR190
CR-NBR AR194 AR196
CR-PYMNT-SEQ AR223 AR230
CR-BATCH AR232 AR235
CR-SUFFIX AR239 AR250
CR-CANCEL-SEQ AR251 AR252
CR-APP-SEQ AR253 AR255
AR256 AR257
AR275 AR286
AR30.1 AR30.6
AR30.8 AR32.1
AR33.1 AR33.3
AR34.1 AR35.2
...
ARASET4 COMPANY KeyChange, Subset AR132 AR135
TRANS-TYPE Where STATUS = Zeroes AR190 AR199
INVOICE Or STATUS = 2 AR233 AR48.1
PAYMENT-SEQ Or STATUS = 4
BATCH-NBR
APP-SEQ
ARASET5 COMPANY KeyChange AR180 AR232
GL-DATE AR237
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
CR-COMPANY
CR-BATCH
CR-PYMNT-SEQ
ARASET6 CR-COMPANY KeyChange, Subset AR230
GL-DATE Where CR-COMPANY != Zeroes
CR-CUSTOMER
CR-TYPE
CR-NBR
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
ARO-ALT-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
|