ARSAPPLIED FILE
Cash Application Select
Cash Application Select
REFERENCED BY
AR124 AR135 AR199 AR230 AR24.1 AR29.1
AR29.2 AR29.3 AR31.1 AR570 AR575 AR580
CB191 AR42.6
UPDATED BY
AR115 AR130 AR20.1 AR21.1 AR21.2 AR21.3
AR30.1 AR30.2 AR30.3 AR30.4 AR30.6 AR30.9
CB06.2 DT520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASG-CR-COMPANY Numeric 4 AR115 AR30.1
Payment Company The payment company number. AR30.2 AR30.3
AR30.4 AR30.6
AR30.9 DT520
ASG-CR-BATCH Numeric 6 AR115 AR30.1
Payment Batch The batch of the payment. AR30.2 AR30.3
AR30.4 AR30.6
AR30.9 DT520
ASG-CR-PYMNT-SEQ Numeric 6 AR115 AR30.1
Payment Sequence The sequence number of the payment. AR30.2 AR30.3
Number AR30.4 AR30.6
AR30.9 DT520
ASG-COMPANY Numeric 4 AR115 AR30.1
Company The company number of the transaction. AR30.2 AR30.3
AR30.4 AR30.6
AR30.9 DT520
ASG-TRANS-TYPE Alpha 1 AR115 AR30.1
Transaction Type The transaction type associated with AR30.2 AR30.3
the selected application. Valid values AR30.4 AR30.6
are: AR30.9 DT520
C = Credit Memo
D = Debit Memo
I = Invoice
P = Payment
ASG-TRANS-NBR Alpha 10 (Right Justified) AR115 AR30.1
Transaction Number The transaction associated with the AR30.2 AR30.3
selected application. Valid values are: AR30.4 AR30.6
AR30.9 DT520
C = Credit Memo
D = Debit Memo
I = Invoice
P = Payment
ASG-PAYMENT-SEQ Numeric 6 AR115 AR30.1
Payment Sequence Payment Sequence. This is the generated AR30.2 AR30.3
sequence number to separate individual AR30.4 AR30.6
invoice payment requirements. AR30.9 DT520
ASG-OPEN-AMT Signed 15.2 AR115 AR30.1
Open Amount The open amount of the transaction. AR30.2 AR30.3
AR30.4 AR30.6
AR30.9
ASG-ORIG-OPEN-AMT Signed 15.2 AR30.1 AR30.2
Original Open Amount The open amount in transaction AR30.3 AR30.4
currency. AR30.6 AR30.9
ASG-CR-ORIG-AP-AMT Signed 15.2 AR115 AR30.1
Credit Application The amount of the application in the AR30.2 AR30.3
Orig Amt currency of the payment. AR30.4 AR30.6
AR30.9 AR31.1
DT520
ASG-ADJ-SEQ Numeric 3 AR115 AR30.1
Adjustment Sequence The sequence number of the adjustment. AR30.2 AR30.3
AR30.4 AR30.6
AR30.9 DT520
ASG-GL-DATE Numeric 8 (yyyymmdd) AR115 AR30.1
Posting Date This field contains the date the AR30.2 AR30.3
applications will be posted to the AR30.4 AR30.6
general ledger. AR30.9 DT520
ASG-OPR-CODE Alpha 10 (Lower Case) AR115 AR30.1
Operator Code This field contains the operator code. AR30.2 AR30.3
This is the user ID of the person who AR30.4 AR30.6
last maintained this record. AR30.9 DT520
ASG-EFT-FL Alpha 1 AR115 AR30.1
EFT Application Indicates if the open amount was AR30.2 AR30.4
selected for application during EFT AR30.6 AR30.9
processing. Valid values are: DT520
Y = Record was written from EFT
processing
N = Record was written from online
processing
ARSAPPLIED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASGSET1 CR-COMPANY This path is used for record uniqueness. AR124 AR130
CR-BATCH AR135 AR199
CR-PYMNT-SEQ AR20.1 AR21.1
COMPANY AR21.2 AR21.3
TRANS-TYPE AR230 AR24.1
TRANS-NBR AR29.1 AR29.2
PAYMENT-SEQ AR30.1 AR30.2
AR30.3 AR30.4
AR30.6 AR30.7
AR30.9 AR31.1
AR570 AR575
AR580 CB06.2
CB191
ASGSET2 COMPANY This path is used to select a AR115 AR130
TRANS-TYPE transaction's application select AR135 AR29.3
TRANS-NBR records. AR30.1 AR30.2
PAYMENT-SEQ AR30.3 AR30.4
AR30.6 AR30.8
AR30.9 AR42.6
ARSAPPLIED FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aroitems AROITEMS Required
ASG-COMPANY -> ARO-COMPANY
ASG-TRANS-TYPE -> ARO-TRANS-TYPE
ASG-TRANS-NBR -> ARO-TRANS-NBR
ASG-PAYMENT-SEQ -> ARO-PAYMENT-SEQ
Arpayment ARPAYMENT Required
ASG-CR-COMPANY -> APM-COMPANY
ASG-CR-BATCH -> APM-BATCH-NBR
ASG-CR-PYMNT-SEQ -> APM-SEQ-NBR
ARSAPPLIED FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arsadjust ARSADJUST Delete Cascades
ASG-COMPANY -> ASJ-COMPANY
ASG-TRANS-TYPE -> ASJ-TRANS-TYPE
ASG-TRANS-NBR -> ASJ-TRANS-NBR
ASG-PAYMENT-SEQ -> ASJ-PAYMENT-SEQ
ASJ-ADJ-SEQ
|