 |
Lawson Insight Technical Documentation |
|
ARADJUST FILE
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.
REFERENCED BY
AR132 AR137 AR161 AR190 AR194 AR196
AR230 AR232 AR233 AR235 AR250 AR251
AR252 AR253 AR255 AR256 AR282 AR286
AR287 AR42.2 AR42.7 AR53.1 AR560 AR80.1
AR80.2 AR82.1 BR11.1 PHI3.1 WH20.7
UPDATED BY
AR129 AR130 AR131 AR135 AR150 AR180
AR191 AR20.1 AR21.1 AR21.2 AR21.3 AR30.1
AR30.2 AR30.3 AR30.4 AR30.8 AR300 AR31.5
AR31.6 AR35.1 AR35.2 AR36.1 AR36.2 AR37.1
AR37.2 AR37.3 AR37.4 AR37.5 AR37.6 AR37.7
AR44.3 AR48.3 AR504 AR700 CB06.2 DT45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADJ-COMPANY Numeric 4 AR129 AR130
Company The company number represents an AR131 AR135
established company and is entered on AR180 AR30.1
all function codes. AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-TRANS-TYPE Alpha 1 AR129 AR130
Transaction Type This field will contain the type of AR131 AR135
transaction being adjusted. Valid AR180 AR30.1
values are: AR30.2 AR30.3
AR30.4 AR30.8
C = Credit memo AR31.5 AR31.6
D = Debit memo AR35.1 AR35.2
I = Invoice AR44.3 AR48.3
P = Payment AR504 DT45.1
ADJ-INVOICE Alpha 22 AR129 AR130
Invoice Number Used to identify the invoice. AR131 AR135
AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-PAYMENT-SEQ Numeric 6 AR129 AR130
Payment Sequence Payment Sequence. This is the generated AR131 AR135
sequence number to separate individual AR180 AR30.1
invoice payment requirements. AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-BATCH-NBR Numeric 6 AR129 AR130
Batch Number The batch that the entered invoices, AR131 AR135
debit memos, credit memos, or payments AR180 AR30.1
are a part of. AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504
ADJ-APP-SEQ Numeric 5 AR129 AR130
Application Sequence This is the application sequence that AR131 AR135
the adjustment is being made against. AR180 AR30.1
Transaction Type, Number, and AR30.2 AR30.3
Application Sequence will point back to AR30.4 AR30.8
the application record that is being AR31.5 AR31.6
adjusted. AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-ADJ-SEQ Numeric 3 AR129 AR130
Adjustment Sequence This is the sequence number of AR131 AR135
adjustment for a given application. AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-ADJ-AMT Signed 15.2 AR129 AR130
Adjustment Amount This is the amount of the adjustment. AR131 AR135
AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-REASON-CODE Alpha 4 AR129 AR130
Adjustment Reason The reason code assigned to the AR131 AR135
Code adjustment. AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-REASON-TYPE Alpha 2 AR129 AR130
Adjustment Reason Indicates the type of adjustment reason AR131 AR135
Type code assigned to the adjustment. Valid AR180 AR30.1
values are: AR30.2 AR30.3
AR30.4 AR30.8
CB = Chargeback AR31.5 AR31.6
DS = Discount AR35.1 AR35.2
OS = Over/short AR44.3 AR48.3
GP = Grouping AR504 DT45.1
ADJ-DESC Alpha 30 (Lower Case) AR129 AR130
Description The description of the adjustment as AR131 AR135
defined for the adjustment reason code AR180 AR30.1
in AR15.1 (Adjustment Reasons), or keyed AR30.2 AR30.3
during cash application. AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-ACCT-UNIT Alpha 15 AR129 AR130
Accounting Unit The general ledger accounting unit of AR131 AR135
this transaction. This will default from AR180 AR30.1
the open item's process level's AR30.2 AR30.3
accounting unit or the accounting unit AR30.4 AR30.8
of the reason code item that this AR31.5 AR31.6
adjustment references. AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-ACCOUNT Numeric 6 AR129 AR130
Account The general ledger account of this AR131 AR135
transaction. Defaults from the reason AR180 AR30.1
code file. AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-SUB-ACCT Numeric 4 AR129 AR130
Subaccount The general ledger subaccount for this AR131 AR135
transaction. This subaccount will AR180 AR30.1
default from the reason code file. AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-REVIEW-STATUS Numeric 1 AR129 AR130
Review Status This status code will indicate any AR131 AR135
processing or review cycles to an AR180 AR191
application adjustment. If the AR30.1 AR30.2
adjustment needs a review, the AR30.3 AR30.4
application will not be set for posting AR30.8 AR31.5
until approval is made. Valid values AR31.6 AR35.1
are: AR35.2 AR36.1
AR36.2 AR44.3
0 = Unreleased adjustment AR48.3 DT45.1
2 = Review - needs approval
4 = Approval complete/approval na
5 = Posted
ADJ-CREATE-DATE Numeric 8 (yyyymmdd) AR129 AR130
Creation Date System date when this adjustment was AR131 AR135
created. AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-CREATE-TIME Numeric 6 (hhmmss) AR129 AR130
Creation Time System time when this adjustment was AR131 AR135
created. AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-ORIG-ADJ-AMT Signed 15.2 AR129 AR130
Transaction The amount of the adjustment in the AR131 AR135
Adjustment Amount currency of the adjustment. AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR48.3
AR504 DT45.1
ADJ-CR-ORIG-AJ-AMT Signed 15.2 AR129 AR130
Cr Orig Aj Amt The amount of the credit adjustment in AR131 AR135
the payment currency. AR180 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR48.3 AR700
DT45.1
ADJ-ADJUST-SOURCE Alpha 1 AR129 AR130
Adjustment Type Indicates the type of the adjustment. AR131 AR135
Valid values are AR150 AR180
AR30.1 AR30.2
C = Credit adjustment AR30.3 AR30.4
D = Debit adjustment AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR48.3
ADJ-ADJUST-TYPE Alpha 1 AR129 AR130
Credit Adjustment Indicates if the adjustment is the AR131 AR135
Type result of a payment being turned into a AR180 AR30.1
credit memo. Valid values are: AR30.2 AR30.3
AR30.4 AR30.8
C = Credit memo origin AR31.5 AR31.6
N = Non credit memo origin AR35.1 AR35.2
AR44.3 AR48.3
ADJ-UNITS Signed 15.2 AR35.1 AR35.2
Units The element that explains the activity.
For example, a unit would be the number
of computers purchased.
ADJ-ACTIVITY Alpha 15 AR129 AR130
Activity Activities are the processes or AR131 AR135
procedures that produce work. Cost AR30.1 AR30.2
objects (products, services, customers, AR30.3 AR30.4
and so on) are the reasons for AR30.8 AR31.5
performing the activity. AR31.6 AR35.1
AR35.2 AR48.3
ADJ-ACCT-CATEGORY Alpha 5 AR129 AR130
Account Category Account categories are groupings of AR131 AR135
costs, revenues, or a combination of AR30.1 AR30.2
both used for reporting and inquiries AR30.3 AR30.4
for activities in the Activity AR30.8 AR31.5
Management system. All transactions are AR31.6 AR35.1
posted to an account category within an AR35.2 AR48.3
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.
ARADJUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADJSET1 COMPANY This is the primary path for accessing AR129 AR130
TRANS-TYPE adjustment records by transaction AR131 AR132
INVOICE number. AR135 AR137
PAYMENT-SEQ AR150 AR161
BATCH-NBR AR180 AR190
APP-SEQ AR191 AR194
ADJ-SEQ AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR230
AR232 AR233
AR235 AR250
AR251 AR252
AR253 AR255
AR256 AR282
AR286 AR287
...
ADJSET2 COMPANY This path is used to access any AR36.1 AR36.2
TRANS-TYPE adjustment which requires review.
INVOICE Subset
PAYMENT-SEQ Where REVIEW-STATUS = 2
BATCH-NBR
APP-SEQ
ADJ-SEQ
ARADJUST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED Required
ADJ-COMPANY -> ARA-COMPANY
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
Arreason ARREASON Required
ADJ-COMPANY -> ARR-COMPANY
"AD" -> ARR-TYPE
ADJ-REASON-CODE -> ARR-REASON-CODE
Aruadjust ARUADJUST Not Required
ADJ-COMPANY -> AGM-COMPANY
ADJ-TRANS-TYPE -> AGM-TRANS-TYPE
ADJ-INVOICE -> AGM-INVOICE
ADJ-PAYMENT-SEQ -> AGM-PAYMENT-SEQ
ADJ-BATCH-NBR -> AGM-BATCH-NBR
ADJ-APP-SEQ -> AGM-APP-SEQ
ADJ-ADJ-SEQ -> AGM-ADJ-SEQ
|