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
AC56.1 AC560 AR01.1 AR132 AR137 AR150
AR161 AR190 AR194 AR196 AR230 AR232
AR233 AR235 AR237 AR238 AR239 AR250
AR251 AR252 AR253 AR255 AR256 AR257
AR265 AR275 AR282 AR286 AR287 AR296
AR42.2 AR42.7 AR502 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 BL98.1 BR11.1 BR48.1 WH20.7
UPDATED BY
AR129 AR130 AR131 AR135 AR180 AR191
AR20.1 AR21.1 AR21.2 AR21.3 AR30.1 AR30.8
AR300 AR32.1 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
AR38.1 AR38.2 AR38.3 AR39.1 AR39.2 AR44.3
AR48.3 AR504 AR80.1 AR80.2 AR800 CB06.2
DT45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADJ-COMPANY Numeric 4 AR129 AR130
Element: Company The number representing an AR company. AR131 AR135
AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.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 AR32.1
AR33.1 AR33.3
C = Credit memo AR33.5 AR33.6
D = Debit memo AR34.1 AR35.1
I = Invoice AR35.2 AR39.1
P = Payment AR39.2 AR44.3
AR48.3 AR504
AR80.1 AR80.2
DT45.1
ADJ-INVOICE Alpha 22 AR129 AR130
Element: Invoice Used to identify the invoice. AR131 AR135
AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR44.3
AR48.3 AR504
AR80.1 AR80.2
DT45.1
ADJ-PAYMENT-SEQ Numeric 6 AR129 AR130
Element: Payment SequenA unique number assigned to each AR131 AR135
transaction to be interfaced into the AR180 AR30.1
Lawson system. AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR44.3
AR48.3 AR504
AR80.1 AR80.2
DT45.1
ADJ-BATCH-NBR Numeric 6 AR129 AR130
Element: Batch Nbr The batch that the entered invoices, AR131 AR135
debit memos, credit memos, or payments AR180 AR30.1
are a part of. AR30.8 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.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 AR32.1
Application Sequence will point back to AR33.1 AR33.3
the application record that is being AR33.5 AR33.6
adjusted. AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
CB = Chargeback AR33.5 AR33.6
DS = Discount AR34.1 AR35.1
OS = Over/short AR35.2 AR39.1
GP = Grouping AR39.2 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 AR32.1
during cash application. AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
accounting unit or the accounting unit AR33.1 AR33.3
of the reason code item that this AR33.5 AR33.6
adjustment references. AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1 AR33.1
application will not be set for posting AR33.3 AR33.5
until approval is made. Valid values AR33.6 AR34.1
are: AR35.1 AR35.2
AR36.1 AR36.2
0 = Unreleased adjustment AR38.1 AR38.2
2 = Review - needs approval AR38.3 AR39.1
4 = Approval complete/approval na AR39.2 AR44.3
5 = Posted AR48.3 AR80.1
AR80.2 DT45.1
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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.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 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR48.3 AR504
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 AR32.1
B = Balance Forward auto discount AR33.1 AR33.3
C = Credit adjustment AR33.5 AR33.6
D = Debit adjustment AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR44.3
AR48.3 AR504
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 AR32.1
AR33.1 AR33.3
C = Credit memo origin AR33.5 AR33.6
N = Non credit memo origin AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR44.3
AR48.3 AR504
AR80.1 AR80.2
ADJ-UNITS Signed 15.2 AR35.1 AR35.2
Element: Unit
ADJ-ACTIVITY Alpha 15 AR129 AR130
Element: Activity Activities are the processes or AR131 AR135
procedures that produce work. Cost AR180 AR30.1
objects (products, services, customers, AR30.8 AR32.1
and so on) are the reasons for AR33.1 AR33.3
performing the activity. AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR48.3 AR80.1
AR80.2
ADJ-ACCT-CATEGORY Alpha 5 AR129 AR130
Element: Acct Category Account categories are groupings of AR131 AR135
costs, revenues, or a combination of AR180 AR30.1
both used for reporting and inquiries AR30.8 AR32.1
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 AR38.1
General Ledger account or range of AR38.2 AR38.3
accounts (company, accounting unit, AR39.1 AR39.2
account, and subaccount) that make up AR48.3 AR80.1
the transactions posted to an account AR80.2
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 Signed 18.2 AR129 AR130
Element: Intl Amt AR131 AR135
AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR48.3
AR80.1 AR80.2
AR800
ADJ-UE-DISC-AMT Signed 18.2 AR129 AR130
Element: Intl Amt AR131 AR135
AR180 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR48.3
AR80.1 AR80.2
AR800
ADJ-ADJUST-FLAG Numeric 1 AR129 AR130
Element: Adjust Flag 0 = No adjust maintenance AR131 AR135
1 = Accrued AR30.1 AR30.8
2 = Expensed AR32.1 AR33.1
AR33.3 AR33.6
AR34.1 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR48.3
ADJ-DISPUTE-CD Alpha 2
Element: Dispute Cd
ADJ-CB-DISPUTE-CD Alpha 2
Element: Dispute Cd
ADJ-ADJUSTED Alpha 1 AR38.1 AR38.2
Element: Adjusted " " = Space AR38.3
Y = Adjusted in AR38
ARADJUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADJSET1 COMPANY KeyChange AC56.1 AC560
TRANS-TYPE AR01.1 AR129
INVOICE AR130 AR131
PAYMENT-SEQ AR132 AR135
BATCH-NBR AR137 AR150
APP-SEQ AR161 AR180
ADJ-SEQ AR190 AR191
AR194 AR196
AR20.1 AR21.1
AR21.2 AR21.3
AR230 AR232
AR233 AR235
AR237 AR238
AR239 AR250
AR251 AR252
...
ADJSET2 COMPANY KeyChange, Subset AR36.1 AR36.2
TRANS-TYPE Where REVIEW-STATUS = 2 AR38.1 AR38.2
INVOICE AR38.3
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
ADJ-SEQ
ADJSET3 COMPANY Subset AR129 AR130
TRANS-TYPE Where REASON-TYPE = "DS" AR131 AR135
INVOICE AR30.1 AR30.8
PAYMENT-SEQ AR32.1 AR33.1
BATCH-NBR AR33.3 AR33.6
APP-SEQ AR34.1 AR39.1
ADJ-SEQ AR39.2 AR48.3
AR800
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
Arpendadj ARPENDADJ Not Required, Delete Cascades
ADJ-COMPANY -> PND-COMPANY
ADJ-TRANS-TYPE -> PND-TRANS-TYPE
ADJ-INVOICE -> PND-INVOICE
ADJ-PAYMENT-SEQ -> PND-PAYMENT-SEQ
ADJ-BATCH-NBR -> PND-BATCH-NBR
ADJ-APP-SEQ -> PND-APP-SEQ
ADJ-ADJ-SEQ -> PND-ADJ-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
|