ARADJUST

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


ARADJUST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADJSET1 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
ADJ-SEQ
KeyChange
AC56.1 AC560
AR01.1 ARLL.1
BR11.1 BR48.1
CB06.2 WH20.2
WH20.7
ADJSET2 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
ADJ-SEQ
KeyChange, Subset
WhereREVIEW-STATUS =2
ADJSET3 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
ADJ-SEQ
Subset
WhereREASON-TYPE ="DS"


ARADJUST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED Required
ADJ-COMPANY->ARA-COMPANY (ARASET1)
ADJ-TRANS-TYPE->ARA-TRANS-TYPE
ADJ-INVOICE->ARA-INVOICE
ADJ-PAYMENT-SEQ->ARA-PAYMENT-SEQ
ADJ-BATCH-NBR->ARA-BATCH-NBR
ADJ-APP-SEQ->ARA-APP-SEQ
Arcode ARCODE Required
ADJ-COMPANY->RCD-COMPANY
ARA-AR-CODE->RCD-AR-CODE
Arcomp ARCOMP Required
ADJ-COMPANY->ACO-COMPANY
Aroihdr AROIHDR Required
ADJ-COMPANY->ARH-COMPANY
ADJ-TRANS-TYPE->ARH-TRANS-TYPE
ADJ-INVOICE->ARH-INVOICE
Aroitems AROITEMS Required
ADJ-COMPANY->ARO-COMPANY
ADJ-TRANS-TYPE->ARO-TRANS-TYPE
ADJ-INVOICE->ARO-INVOICE
ADJ-PAYMENT-SEQ->ARO-PAYMENT-SEQ
Arpymnthdr ARPYMNTHDR Not Required
ADJ-COMPANY->APH-COMPANY
ADJ-BATCH-NBR->APH-BATCH-NBR
Arreason ARREASON Required
ADJ-COMPANY->ARR-COMPANY
"AD"->ARR-TYPE
ADJ-REASON-CODE->ARR-REASON-CODE


File created: Thu Jun 09 11:08:53 2016

Home
Contact Us



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