ARSAPPLIED

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.


ARSAPPLIED FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASGSET1 CR-COMPANY
CR-BATCH
CR-PYMNT-SEQ
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
CB06.2 CB191
ASGSET2 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
ASGSET3 CR-COMPANY
CR-BATCH
CR-PYMNT-SEQ
SELECT-SEQ


ARSAPPLIED FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Aroitems AROITEMS Required
ASG-COMPANY->ARO-COMPANY (AROSET1)
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
NAME
RELATED 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
Zeroes->ASJ-BATCH-NBR
  ASJ-ADJ-SEQ


File created: Wed Jun 08 20:47:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.