Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARPENDADJ


                             ARPENDADJ FILE

This table contains pending ajustment records created from AR38 Adjustment
Maintenance.  These records record the desired adjustment maintenance action
of the user, and are deleted by the Release function with AR38 Adjustment
Maintenance.

REFERENCED BY

AR129     AR130     AR131     AR135     AR199     AR238
AR251     AR265     AR30.1    AR30.2    AR32.1    AR35.1
AR37.2    AR37.4    AR37.6    AR39.1    AR39.2    AR44.1
AR48.1    AR80.1    AR80.2

UPDATED BY

AR38.1    AR38.2    AR38.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PND-USER               Alpha 10  (Lower Case)                    AR38.1  AR38.2
Element: User          The signon user ID.                       AR38.3

PND-COMPANY            Numeric 4                                 AR38.1  AR38.2
Element: Company       The number representing an AR company.    AR38.3

PND-TRANS-TYPE         Alpha 1                                   AR38.1  AR38.2
Element: Trans Type    This field will contain the type of       AR38.3
                       transaction being adjusted.  Valid
                       values are:

                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice

PND-INVOICE            Alpha 22                                  AR38.1  AR38.2
Element: Invoice       Used to identify the invoice.             AR38.3

PND-PAYMENT-SEQ        Numeric 6                                 AR38.1  AR38.2
Element: Seq Number    A unique number assigned to each          AR38.3
                       transaction to be interfaced into the
                       Lawson system.

PND-BATCH-NBR          Numeric 6                                 AR38.1  AR38.2
Element: Batch Nbr     This identifies the batch the entered     AR38.3
                       invoices, debit memos, and credit memos
                       are a part of.

PND-APP-SEQ            Numeric 7                                 AR38.1  AR38.2
Element: App Seq       This is the application sequence that     AR38.3
                       the adjustment is being made against.

PND-ADJ-SEQ            Numeric 3                                 AR38.1  AR38.2
Element: Adj Seq       This is the sequence number of the        AR38.3
                       adjustment for a given application.

PND-CUSTOMER           Alpha 9  (Right Justified)                AR38.1  AR38.2
Element: Customer      This field contains the number that       AR38.3
                       represents a customer.

PND-SOURCE             Alpha 1                                   AR38.1  AR38.2
Element: Source        The source intent of the transaction.     AR38.3
                       Valid values are:

                       A = Accrual
                       R = Reason Code

PND-ACTION             Alpha 1                                   AR38.1  AR38.2
Element: Action        The action that will be performed upon    AR38.3
                       release.
                       B = Both delete and dispute
                       C = Change
                       D = Delete
                       E = Expense
                       R = Reviewed

PND-REASON-CODE        Alpha 4                                   AR38.1  AR38.2
Element: Reason Code   This field contains the reason code,      AR38.3
                       which indicates the adjustment reason.

PND-DISPUTE-CD         Alpha 2                                   AR38.1  AR38.2
Element: Dispute Cd    The dispute code to be assessed to the
                       remaining open amount of the transaction
                       upon release.

PND-GL-DATE            Numeric 8  (yyyymmdd)
Element: Gl Date       This field contains the general ledger
                       posting date.

PND-ACCT-UNIT          Alpha 15                                  AR38.1  AR38.2
Element: Acct Unit     The accounting unit of the adjustment     AR38.3
                       record that is created upon release.

PND-ACCOUNT            Numeric 6                                 AR38.1  AR38.2
Element: Account       This field along with the accounting      AR38.3
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

PND-SUB-ACCT           Numeric 4                                 AR38.1  AR38.2
Element: Sub Acct      The sub account of the adjustment         AR38.3
                       record that is created upon release.

PND-ACTIVITY           Alpha 15                                  AR38.1  AR38.2
Element: Activity      Activities are the processes or           AR38.3
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


PND-ACCT-CATEGORY      Alpha 5                                   AR38.1  AR38.2
Element: Acct Category Account categories are groupings of       AR38.3
                       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

PND-DESC               Alpha 30  (Lower Case)                    AR38.1  AR38.2
Element: Description   The description of the adjustment.        AR38.3

PND-SEGMENT-BLOCK      Alpha 103                                 AR38.1  AR38.2
Element: Segment Block This field identifies the user analysis   AR38.3
                       values included in the transaction.


                         ARPENDADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PNDSET1   COMPANY                                                AR129   AR130
          TRANS-TYPE                                             AR131   AR135
          INVOICE                                                AR199   AR238
          PAYMENT-SEQ                                            AR251   AR265
          BATCH-NBR                                              AR30.1  AR30.2
          APP-SEQ                                                AR32.1  AR35.1
          ADJ-SEQ                                                AR37.2  AR37.4
                                                                 AR37.6  AR38.1
                                                                 AR38.2  AR38.3
                                                                 AR39.1  AR39.2
                                                                 AR44.1  AR48.1
                                                                 AR80.1  AR80.2

PNDSET2   USER                                                   AR38.1  AR38.2
          SOURCE                                                 AR38.3
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          BATCH-NBR
          APP-SEQ
          ADJ-SEQ