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.
UPDATED BY
CB06.2 | CB191 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
ASG-CR-COMPANY Element: Payment Company | Numeric 4 The number representing an AR company. |
|
|
ASG-CR-BATCH Element: Payment Batch | Numeric 6 The batch of the payment. |
|
|
ASG-CR-PYMNT-SEQ Payment Sequence Number | Numeric 6 The sequence number of the payment. |
|
|
ASG-COMPANY Element: Company | Numeric 4 The company number of the transaction. |
|
|
ASG-TRANS-TYPE Element: Trans Type | Alpha 1 The transaction type associated with the selected application. Valid values are: C = Credit Memo D = Debit Memo I = Invoice P = Payment |
|
|
ASG-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
|
ASG-PAYMENT-SEQ Element: Payment Sequence | Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system. |
|
|
ASG-OPEN-AMT Element: Open Amount | Signed 18.2 The open amount of the transaction. |
|
|
ASG-ORIG-OPEN-AMT Element: Original Open Amount | Signed 18.2 The open amount in transaction currency. |
|
|
ASG-CR-ORIG-AP-AMT Element: Intl Amt | Signed 18.2 The amount of the application in the payment currency. |
|
|
ASG-ADJ-SEQ Element: Adjustment Sequence | Numeric 3 The sequence number of the adjustment. |
|
|
ASG-GL-DATE Element: Posting Date | Numeric 8 (yyyymmdd) This field contains the date the applications will be posted to the general ledger. |
|
|
ASG-OPR-CODE Element: Opr Code | Alpha 10 (Lower Case) This field contains the operator code. This is the user ID of the person who last maintained this record. |
|
|
ASG-EFT-FL Element: EFT Application | Alpha 1 Indicates if the open amount was selected for application during EFT processing. Valid values are: Y = Record was written from EFT processing N = Record was written from online processing |
|
|
ASG-SELECT-SEQ Element: Select Seq | Numeric 6 The payment application order. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
ASGSET1 |
CR-COMPANY CR-BATCH CR-PYMNT-SEQ COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ |
|
| ||||||||
ASGSET2 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||
ASGSET3 |
CR-COMPANY CR-BATCH CR-PYMNT-SEQ SELECT-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Aroitems | AROITEMS |
Required
| ||||||||||||
Arpayment | ARPAYMENT |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arsadjust | ARSADJUST |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.