ARADJUST – Acct Receivables App Adjsmnt

System: Accounts Receivable (AR)
Prefix: ADJ
Primary key: COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ, ADJ-SEQ
Fields: 30
Updated by: 1 program
Referenced by: 8 programs

ARADJUST is the Acct Receivables App Adjsmnt table in Lawson Accounts Receivable (prefix ADJ). It is indexed by COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ, ADJ-SEQ (ADJSET1); alternate indexes: ADJSET2 and ADJSET3. It is related 1:1 to ARAPPLIED, ARCODE, ARCOMP, AROIHDR, AROITEMS, ARPYMNTHDR and ARREASON. It is updated by CB06.2 and referenced by AC56.1, AC560, AR01.1, ARLL.1, BR11.1, BR48.1, WH20.2 and WH20.7. The table has 30 fields, 3 indexes and 7 documented relations.

About ARADJUST

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.

Fields (30)

Column = COBOL field name without the ADJ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ADJ-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	—
`ADJ-TRANS-TYPE` PK TRANS_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` PK INVOICE	Alpha 22	Used to identify the invoice.	—
`ADJ-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	—
`ADJ-BATCH-NBR` PK BATCH_NBR	Numeric 6	The batch that the entered invoices, debit memos, credit memos, or payments are a part of.	—
`ADJ-APP-SEQ` PK APP_SEQ	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` PK ADJ_SEQ	Numeric 3	This is the sequence number of adjustment for a given application.	—
`ADJ-ADJ-AMT` ADJ_AMT	Signed 18.2	This is the amount of the adjustment.	—
`ADJ-REASON-CODE` REASON_CODE	Alpha 4	The reason code assigned to the adjustment.	—
`ADJ-REASON-TYPE` 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` DESC	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` ACCT_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` ACCOUNT	Numeric 6	The general ledger account of this transaction. Defaults from the reason code file.	—
`ADJ-SUB-ACCT` SUB_ACCT	Numeric 4	The general ledger subaccount for this transaction. This subaccount will default from the reason code file.	—
`ADJ-REVIEW-STATUS` 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` CREATE_DATE	Numeric 8 (yyyymmdd)	System date when this adjustment was created.	—
`ADJ-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	System time when this adjustment was created.	—
`ADJ-ORIG-ADJ-AMT` ORIG_ADJ_AMT	Signed 18.2	The amount of the adjustment in the currency of the adjustment.	—
`ADJ-CR-ORIG-AJ-AMT` CR_ORIG_AJ_AMT	Signed 18.2	The amount of the credit adjustment in the payment currency.	—
`ADJ-ADJUST-SOURCE` ADJUST_SOURCE	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` ADJUST_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` UNITS	Signed 15.2	—	—
`ADJ-ACTIVITY` 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` 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` EA_DISC_AMT	Signed 18.2	—	—
`ADJ-UE-DISC-AMT` UE_DISC_AMT	Signed 18.2	—	—
`ADJ-ADJUST-FLAG` ADJUST_FLAG	Numeric 1	— `0` No adjust maintenance `1` Accrued `2` Expensed	—
`ADJ-DISPUTE-CD` DISPUTE_CD	Alpha 2	—	—
`ADJ-CB-DISPUTE-CD` CB_DISPUTE_CD	Alpha 2	—	—
`ADJ-ADJUSTED` ADJUSTED	Alpha 1	" " = Space `Y` Adjusted in AR38	—

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ADJSET1`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `BATCH-NBR`, `APP-SEQ`, `ADJ-SEQ`	Primary, KeyChange		AC56.1, AC560, AR01.1, ARLL.1, BR11.1, BR48.1, CB06.2, WH20.2 +1 more
`ADJSET2`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `BATCH-NBR`, `APP-SEQ`, `ADJ-SEQ`	KeyChange, Subset	Where REVIEW-STATUS = 2	—
`ADJSET3`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `BATCH-NBR`, `APP-SEQ`, `ADJ-SEQ`	Subset	Where REASON-TYPE = "DS"	—

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Field map
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`

Programs

Updated by (1)

CB06.2 Bank Statement Detail Entry

Referenced by (8)

AC56.1 Setup Interface Adjustment
AC560 Setup Interface
AR01.1 Company
ARLL.1 AR Transaction Interface
BR11.1 Customer
BR48.1 Customer Template
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location