 |
Lawson Insight Technical Documentation |
|
ARSAPPLIED FILE
Cash Application Select
The Cash Application Select file contains the cash application select records
that have been selected but not yet processed into application records.
REFERENCED BY
AR124 AR129 AR135 AR199 AR24.1 AR29.1
AR29.2 AR29.3 AR31.1 AR48.1 AR570 AR575
AR580 AR82.1 CB191 AR131 AR42.6 AR230
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-INVOICE Alpha 22 AR115 AR30.1
Invoice Number Used to identify the invoice. AR30.2 AR30.3
AR30.4 AR30.6
AR30.9 DT520
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
Cr Orig Ap Amt The amount of the application in the AR30.2 AR30.3
payment currency. 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
ASG-SELECT-SEQ Numeric 6 AR115 AR30.1
Select Seq AR30.2 AR30.3
AR30.4 AR30.6
AR30.9
ARSAPPLIED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASGSET1 CR-COMPANY This path is used for record uniqueness. AR124 AR129
CR-BATCH AR130 AR135
CR-PYMNT-SEQ AR199 AR20.1
COMPANY AR21.1 AR21.2
TRANS-TYPE AR21.3 AR24.1
INVOICE AR29.1 AR29.2
PAYMENT-SEQ AR30.1 AR30.2
AR30.3 AR30.4
AR30.6 AR30.7
AR30.9 AR31.1
AR48.1 AR570
AR575 AR580
AR82.1 CB06.2
CB191
ASGSET2 COMPANY This path is used to select a AR115 AR130
TRANS-TYPE transaction's application select AR131 AR135
INVOICE records. AR29.3 AR30.1
PAYMENT-SEQ AR30.2 AR30.3
AR30.4 AR30.6
AR30.8 AR30.9
AR42.6 AR48.1
ASGSET3 CR-COMPANY AR230
CR-BATCH
CR-PYMNT-SEQ
SELECT-SEQ
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-INVOICE -> ARO-INVOICE
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-PAYMENT-SEQ
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-INVOICE -> ASJ-INVOICE
ASG-PAYMENT-SEQ -> ASJ-PAYMENT-SEQ
ASJ-ADJ-SEQ
|