AR Application Adjustment
The AR Application Adjustment file contains adjustment records created from
the cash application process. Adjustment records are "application records"
that do not represent payment or credit applications. Examples of this include
discounts, shorts/overages, write-offs, etc. Every adjustment has a
corresponding application record in the application file. There can be many
adjustments to one application or the relationship can be one-to-one.
UPDATED BY
AC56.1 | AC560 | AR01.1 | ARLL.1 | BR11.1 | BR48.1 |
CB06.2 | WH20.2 | WH20.7 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
ADJ-COMPANY Element: Company | Numeric 4 The number representing an AR company. |
|
|
ADJ-TRANS-TYPE Element: Transaction Type | Alpha 1 This field will contain the type of transaction being adjusted. Valid values are: C = Credit memo D = Debit memo I = Invoice P = Payment |
|
|
ADJ-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
|
ADJ-PAYMENT-SEQ Element: Payment Sequence | Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system. |
|
|
ADJ-BATCH-NBR Element: Batch Nbr | Numeric 6 The batch that the entered invoices, debit memos, credit memos, or payments are a part of. |
|
|
ADJ-APP-SEQ Element: Application Sequence | Numeric 7 This is the application sequence that the adjustment is being made against. Transaction Type, Number, and Application Sequence will point back to the application record that is being adjusted. |
|
|
ADJ-ADJ-SEQ Element: Adjustment Sequence | Numeric 3 This is the sequence number of adjustment for a given application. |
|
|
ADJ-ADJ-AMT Element: Adjustment Amount | Signed 18.2 This is the amount of the adjustment. |
|
|
ADJ-REASON-CODE Adjustment Reason Code | Alpha 4 The reason code assigned to the adjustment. |
|
|
ADJ-REASON-TYPE Adjustment Reason Type | Alpha 2 Indicates the type of adjustment reason code assigned to the adjustment. Valid values are: CB = Chargeback DS = Discount OS = Over/short GP = Grouping TR = Payment Transfer |
|
|
ADJ-DESC Element: Description | Alpha 30 (Lower Case) The description of the adjustment as defined for the adjustment reason code in AR15.1 (Adjustment Reasons), or keyed during cash application. |
|
|
ADJ-ACCT-UNIT Element: Accounting Unit | Alpha 15 The general ledger accounting unit of this transaction. This will default from the open item's process level's accounting unit or the accounting unit of the reason code item that this adjustment references. |
|
|
ADJ-ACCOUNT Element: Account | Numeric 6 The general ledger account of this transaction. Defaults from the reason code file. |
|
|
ADJ-SUB-ACCT Element: Subaccount | Numeric 4 The general ledger subaccount for this transaction. This subaccount will default from the reason code file. |
|
|
ADJ-REVIEW-STATUS Element: Review Status | Numeric 1 This status code will indicate any processing or review cycles to an application adjustment. If the adjustment needs a review, the application will not be set for posting until approval is made. Valid values are: 0 = Unreleased adjustment 2 = Review - needs approval 4 = Approval complete/approval na 5 = Posted |
|
|
ADJ-CREATE-DATE Element: Creation Date | Numeric 8 (yyyymmdd) System date when this adjustment was created. |
|
|
ADJ-CREATE-TIME Element: Creation Time | Numeric 6 (hhmmss) System time when this adjustment was created. |
|
|
ADJ-ORIG-ADJ-AMT Transaction Adjustment Amount | Signed 18.2 The amount of the adjustment in the currency of the adjustment. |
|
|
ADJ-CR-ORIG-AJ-AMT Element: Intl Amt | Signed 18.2 The amount of the credit adjustment in the payment currency. |
|
|
ADJ-ADJUST-SOURCE Element: Adjustment Type | Alpha 1 Indicates the type of the adjustment. Valid values are B = Balance Forward auto discount C = Credit adjustment D = Debit adjustment |
|
|
ADJ-ADJUST-TYPE Credit Adjustment Type | Alpha 1 Indicates if the adjustment is the result of a payment being turned into a credit memo. Valid values are: C = Credit memo origin N = Non credit memo origin P = Transfer origin |
|
|
ADJ-UNITS Element: Unit | Signed 15.2 |
|
|
ADJ-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
|
ADJ-ACCT-CATEGORY Element: Acct Category | Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru |
|
|
ADJ-EA-DISC-AMT Element: Intl Amt | Signed 18.2 |
|
|
ADJ-UE-DISC-AMT Element: Intl Amt | Signed 18.2 |
|
|
ADJ-ADJUST-FLAG Element: Adjust Flag | Numeric 1 0 = No adjust maintenance 1 = Accrued 2 = Expensed |
|
|
ADJ-DISPUTE-CD Element: Dispute Cd | Alpha 2 |
|
|
ADJ-CB-DISPUTE-CD Element: Dispute Cd | Alpha 2 |
|
|
ADJ-ADJUSTED Element: Adjusted | Alpha 1 " " = Space Y = Adjusted in AR38 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ADJSET1 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ ADJ-SEQ |
|
| ||||||||||||||||
ADJSET2 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ ADJ-SEQ |
|
|||||||||||||||||
ADJSET3 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ ADJ-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arapplied | ARAPPLIED |
Required
| ||||||||||||||||||
Arcode | ARCODE |
Required
| ||||||||||||||||||
Arcomp | ARCOMP |
Required
| ||||||||||||||||||
Aroihdr | AROIHDR |
Required
| ||||||||||||||||||
Aroitems | AROITEMS |
Required
| ||||||||||||||||||
Arpymnthdr | ARPYMNTHDR |
Not Required
| ||||||||||||||||||
Arreason | ARREASON |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.