Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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