Lawson Insight Technical Documentation |
|
ARADJUST
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 AR150 AR161 AR190 AR194
AR196 AR230 AR232 AR233 AR235 AR250
AR251 AR252 AR253 AR255 AR256 AR275
AR282 AR286 AR287 AR42.2 AR42.7 AR53.1
AR560 AR82.1 ARLL.1 BL00.1 BL01.1 BL120
BL121 BL122 BL123 BL130 BL20.1 BL20.3
BL200 BL201 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 BR11.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE111
OE113 OE114 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE810 OE830 WH20.7
UPDATED BY
AR129 AR130 AR131 AR135 AR180 AR191
AR20.1 AR21.1 AR21.2 AR21.3 AR30.1 AR30.8
AR300 AR31.5 AR31.6 AR33.1 AR33.3 AR33.5
AR33.6 AR34.1 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 AR80.1 AR80.2
CB06.2 DT45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADJ-COMPANY Numeric 4 AR129 AR130
Element: Company Identifies the AP company if the AR131 AR135
resource type = V. Identifies the HR AR180 AR30.1
company if the resource type = E. It is AR30.8 AR31.5
blank for type A, P or Q resources. AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-TRANS-TYPE Alpha 1 AR129 AR130
Element: Transaction TyThis field will contain the type of AR131 AR135
transaction being adjusted. Valid AR180 AR30.1
values are: AR30.8 AR31.5
AR31.6 AR33.1
C = Credit memo AR33.3 AR33.5
D = Debit memo AR33.6 AR34.1
I = Invoice AR35.1 AR35.2
P = Payment AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-INVOICE Alpha 22 AR129 AR130
Element: Invoice NumberUsed to identify the invoice. AR131 AR135
AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-PAYMENT-SEQ Numeric 6 AR129 AR130
Element: Payment SequenPayment Sequence. This is the generated AR131 AR135
sequence number to separate individual AR180 AR30.1
invoice payment requirements. AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-BATCH-NBR Numeric 6 AR129 AR130
Element: Batch Number The batch that the entered invoices, AR131 AR135
debit memos, credit memos, or payments AR180 AR30.1
are a part of. AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2
ADJ-APP-SEQ Numeric 7 AR129 AR130
Element: Application SeThis is the application sequence that AR131 AR135
the adjustment is being made against. AR180 AR30.1
Transaction Type, Number, and AR30.8 AR31.5
Application Sequence will point back to AR31.6 AR33.1
the application record that is being AR33.3 AR33.5
adjusted. AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-ADJ-SEQ Numeric 3 AR129 AR130
Element: Adjustment SeqThis is the sequence number of AR131 AR135
adjustment for a given application. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-ADJ-AMT Signed 18.2 AR129 AR130
Element: Adjustment AmoThis is the amount of the adjustment. AR131 AR135
AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 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.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 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.8 AR31.5
AR31.6 AR33.1
CB = Chargeback AR33.3 AR33.5
DS = Discount AR33.6 AR34.1
OS = Over/short AR35.1 AR35.2
GP = Grouping AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-DESC Alpha 30 (Lower Case) AR129 AR130
Element: 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.8 AR31.5
during cash application. AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-ACCT-UNIT Alpha 15 AR129 AR130
Element: Accounting UniThe general ledger accounting unit of AR131 AR135
this transaction. This will default from AR180 AR30.1
the open item's process level's AR30.8 AR31.5
accounting unit or the accounting unit AR31.6 AR33.1
of the reason code item that this AR33.3 AR33.5
adjustment references. AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-ACCOUNT Numeric 6 AR129 AR130
Element: Account The general ledger account of this AR131 AR135
transaction. Defaults from the reason AR180 AR30.1
code file. AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-SUB-ACCT Numeric 4 AR129 AR130
Element: Subaccount The general ledger subaccount for this AR131 AR135
transaction. This subaccount will AR180 AR30.1
default from the reason code file. AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-REVIEW-STATUS Numeric 1 AR129 AR130
Element: 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.8
adjustment needs a review, the AR31.5 AR31.6
application will not be set for posting AR33.1 AR33.3
until approval is made. Valid values AR33.5 AR33.6
are: AR34.1 AR35.1
AR35.2 AR36.1
0 = Unreleased adjustment AR36.2 AR44.3
2 = Review - needs approval AR48.3 AR80.1
4 = Approval complete/approval na AR80.2 DT45.1
5 = Posted
ADJ-CREATE-DATE Numeric 8 (yyyymmdd) AR129 AR130
Element: Creation Date System date when this adjustment was AR131 AR135
created. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-CREATE-TIME Numeric 6 (hhmmss) AR129 AR130
Element: Creation Time System time when this adjustment was AR131 AR135
created. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-ORIG-ADJ-AMT Signed 18.2 AR129 AR130
Transaction The amount of the adjustment in the AR131 AR135
Adjustment Amount currency of the adjustment. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR504 AR80.1
AR80.2 DT45.1
ADJ-CR-ORIG-AJ-AMT Signed 18.2 AR129 AR130
Element: Intl Amt The amount of the credit adjustment in AR131 AR135
the payment currency. AR180 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3 AR80.1
AR80.2 DT45.1
ADJ-ADJUST-SOURCE Alpha 1 AR129 AR130
Element: Adjustment TypIndicates the type of the adjustment. AR131 AR135
Valid values are AR180 AR30.1
AR30.8 AR31.5
C = Credit adjustment AR31.6 AR33.1
D = Debit adjustment AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR80.1 AR80.2
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.8 AR31.5
AR31.6 AR33.1
C = Credit memo origin AR33.3 AR33.5
N = Non credit memo origin AR33.6 AR34.1
AR35.1 AR35.2
AR44.3 AR48.3
AR80.1 AR80.2
ADJ-UNITS Signed 15.2 AR35.1 AR35.2
Element: Unit The element that explains the activity.
For example, a unit would be the number
of computers purchased.
ADJ-ACTIVITY Alpha 15 AR129 AR130
Element: Activity Activities are the processes or AR131 AR135
procedures that produce work. Cost AR30.1 AR30.8
objects (products, services, customers, AR31.5 AR31.6
and so on) are the reasons for AR33.1 AR33.3
performing the activity. AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR48.3
ADJ-ACCT-CATEGORY Alpha 5 AR129 AR130
Element: Account CategoAccount categories are groupings of AR131 AR135
costs, revenues, or a combination of AR30.1 AR30.8
both used for reporting and inquiries AR31.5 AR31.6
for activities in the Activity AR33.1 AR33.3
Management system. All transactions are AR33.5 AR33.6
posted to an account category within an AR34.1 AR35.1
activity. You can assign a specific AR35.2 AR48.3
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
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 KeyChange 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 AR275
AR282 AR286
...
ADJSET2 COMPANY This path is used to access any AR36.1 AR36.2
TRANS-TYPE adjustment which requires review.
INVOICE KeyChange, 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
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
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
|