Cash Application Adjust Select
The Cash Application Adjustment Select file contains adjustment information
for open items that have been selected for cash application, but not yet
processed, thereby creating application adjustment records.
UPDATED BY
CB06.2 | CB191 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
ASJ-COMPANY Element: Company | Numeric 4 The number representing an AR company. |
|
|
ASJ-TRANS-TYPE Element: Trans Type | Alpha 1 The transaction type the adjustment is associated with. Valid values are: C = Credit memo D = Debit Memo I = Invoice |
|
|
ASJ-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice, debit memo, or credit memo. |
|
|
ASJ-PAYMENT-SEQ Element: Payment Sequence | Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system. |
|
|
ASJ-ADJ-SEQ Element: Adjustment Sequence | Numeric 3 The sequence number of the adjustment. |
|
|
ASJ-ADJ-AMT Element: Adjustment Amount | Signed 18.2 The amount of the adjustment in company base currency. |
|
|
ASJ-ORIG-ADJ-AMT Original Adjustment Amount | Signed 18.2 The amount of the adjustment in transaction currency. |
|
|
ASJ-CR-ORIG-AJ-AMT Element: Intl Amt | Signed 18.2 The amount of the credit adjustment in the payment currency. |
|
|
ASJ-REASON-CODE Element: Reason Code | Alpha 4 The reason code for the adjustment. |
|
|
ASJ-ACCT-UNIT Element: Acct Unit | Alpha 15 The General Ldger accounting unit. |
|
|
ASJ-ACCOUNT Element: Account | Numeric 6 The General Ledger account. |
|
|
ASJ-SUB-ACCT Element: Sub Acct | Numeric 4 The General Ledger subaccount |
|
|
ASJ-DESC Element: Description | Alpha 30 (Lower Case) The description of the adjustment. |
|
|
ASJ-MEMO-COMPANY Element: Memo Company | Numeric 4 This is the company which will own the memo chargeback once it is generated. |
|
|
ASJ-MEMO-CUSTOMER Element: Memo Customer | Alpha 9 (Right Justified) This is the customer which will own the memo chargeback once it is generated. |
|
|
ASJ-MEMO-PROC-LEV Element: Memo Process Level | Alpha 5 This is the process level which will own the chargeback once it is generated. |
|
|
ASJ-MEMO-INDIC Element: Memo Indicator | Alpha 1 Indicates if the adjustment select record for a payment is for a chargeback memo. Valid values are: Blank = Not a memo chargeback memo M = Chargeback memo |
|
|
ASJ-MEMO-XREF-NBR Memo Cross Reference Number | Alpha 22 (Right Justified) This will contain the cross reference number entered to memo chargeback creation. |
|
|
ASJ-GL-DATE Element: Posting Date | Numeric 8 (yyyymmdd) This field contains the general ledger posting date. |
|
|
ASJ-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. |
|
|
ASJ-JRNL-BOOK-NBR Element: Journal Book Number | Alpha 12 This is the journal book number for the adjustment record. |
|
|
ASJ-ACTIVITY Element: Activity | Alpha 15 The Activity associated with the adjustment. |
|
|
ASJ-ACCT-CATEGORY Element: Acct Category | Alpha 5 The Account Category associated with the Activity of the adjustment. |
|
|
ASJ-BATCH-NBR Element: Batch Nbr | Numeric 6 This identifies the batch the entered invoices, debit memos, and credit memos are a part of. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ASJSET1 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR ADJ-SEQ |
|
| |||||||||||||
ASJSET2 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ MEMO-INDIC BATCH-NBR ADJ-SEQ |
|
| |||||||||||||
ASJSET3 |
COMPANY BATCH-NBR PAYMENT-SEQ ADJ-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arsapplied | ARSAPPLIED |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.