Lawson Insight Technical Documentation |
|
ARSAPPLIED
ARSAPPLIED FILE
Cash Application Select
The Cash Application Select file contains the cash application select records
that have been selected but not yet processed, thereby creating application
records.
REFERENCED BY
AR124 AR129 AR135 AR199 AR24.1 AR29.1
AR29.2 AR29.3 AR48.1 AR570 AR575 AR580
AR82.1 CB191 AR131 AR251 AR38.1 AR38.2
AR38.3 AR39.1 AR42.6 AR91.1 AR230
UPDATED BY
AR115 AR130 AR20.1 AR21.1 AR21.2 AR21.3
AR30.1 AR30.2 AR30.6 AR30.8 AR32.1 AR32.3
AR33.1 AR33.3 AR34.1 AR34.2 CB06.2 DT520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASG-CR-COMPANY Numeric 4 AR115 AR30.1
Element: Payment CompanThe number representing an AR company. AR30.2 AR30.6
AR32.1 AR33.1
AR34.1 DT520
ASG-CR-BATCH Numeric 6 AR115 AR30.1
Element: Payment Batch The batch of the payment. AR30.2 AR30.6
AR32.1 AR33.1
AR34.1 DT520
ASG-CR-PYMNT-SEQ Numeric 6 AR115 AR30.1
Payment Sequence The sequence number of the payment. AR30.2 AR30.6
Number AR32.1 AR33.1
AR34.1 DT520
ASG-COMPANY Numeric 4 AR115 AR30.1
Element: Company The company number of the transaction. AR30.2 AR30.6
AR32.1 AR33.1
AR34.1 DT520
ASG-TRANS-TYPE Alpha 1 AR115 AR30.1
Element: Trans Type The transaction type associated with AR30.2 AR30.6
the selected application. Valid values AR32.1 AR33.1
are: AR34.1 DT520
C = Credit Memo
D = Debit Memo
I = Invoice
P = Payment
ASG-INVOICE Alpha 22 AR115 AR30.1
Element: Invoice Used to identify the invoice. AR30.2 AR30.6
AR32.1 AR33.1
AR34.1 DT520
ASG-PAYMENT-SEQ Numeric 6 AR115 AR30.1
Element: Payment SequenA unique number assigned to each AR30.2 AR30.6
transaction to be interfaced into the AR32.1 AR33.1
Lawson system. AR34.1 DT520
ASG-OPEN-AMT Signed 18.2 AR115 AR30.1
Element: Open Amount The open amount of the transaction. AR30.2 AR30.6
AR30.8 AR32.1
AR32.3 AR33.1
AR33.3 AR34.1
AR34.2
ASG-ORIG-OPEN-AMT Signed 18.2 AR30.1 AR30.2
Element: Original Open The open amount in transaction AR30.6 AR32.1
currency. AR32.3 AR33.1
AR34.1 AR34.2
ASG-CR-ORIG-AP-AMT Signed 18.2 AR115 AR30.1
Element: Intl Amt The amount of the application in the AR30.2 AR30.3
payment currency. AR30.6 AR32.1
AR32.3 AR33.1
AR34.1 AR34.2
AR34.4 DT520
ASG-ADJ-SEQ Numeric 3 AR115 AR30.1
Element: Adjustment SeqThe sequence number of the adjustment. AR30.2 AR30.6
AR32.1 AR32.3
AR33.1 AR34.1
AR34.2 DT520
ASG-GL-DATE Numeric 8 (yyyymmdd) AR115 AR30.1
Element: Posting Date This field contains the date the AR30.2 AR30.6
applications will be posted to the AR32.1 AR33.1
general ledger. AR34.1 DT520
ASG-OPR-CODE Alpha 10 (Lower Case) AR115 AR30.1
Element: Opr Code This field contains the operator code. AR30.2 AR30.6
This is the user ID of the person who AR32.1 AR33.1
last maintained this record. AR34.1 DT520
ASG-EFT-FL Alpha 1 AR115 AR30.1
Element: EFT ApplicatioIndicates if the open amount was AR30.2 AR32.1
selected for application during EFT AR34.1 DT520
processing. Valid values are:
Y = Record was written from EFT
processing
N = Record was written from online
processing
ASG-SELECT-SEQ Numeric 6 AR115 AR30.1
Element: Select Seq The payment application order. AR30.2 AR30.6
AR32.1 AR33.1
AR34.1
ARSAPPLIED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASGSET1 CR-COMPANY 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.6
AR30.7 AR30.8
AR32.1 AR33.1
AR33.3 AR33.6
AR34.1 AR34.3
AR34.4 AR48.1
AR570 AR575
AR580 AR82.1
...
ASGSET2 COMPANY AR115 AR130
TRANS-TYPE AR131 AR135
INVOICE AR251 AR29.3
PAYMENT-SEQ AR30.1 AR30.2
AR30.6 AR30.8
AR32.1 AR32.3
AR33.1 AR33.3
AR34.1 AR34.2
AR38.1 AR38.2
AR38.3 AR39.1
AR42.6 AR48.1
AR91.1
ASGSET3 CR-COMPANY AR230 AR251
CR-BATCH AR91.1
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
|