Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APAPDHIST


                             APAPDHIST FILE

REFERENCED BY

AP136     AP275

UPDATED BY

AP115     AP180     AP181     AP190     AP198     AP28.1
AP28.2    AP300     AP305     AP45.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AH2-COMPANY            Numeric 4                                 AP198
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AH2-API-OBJ-ID         Numeric 12                                AP198
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

AH2-VENDOR             Alpha 9  (Right Justified)                AP115   AP198
Element: Vendor        The vendor's identification code.



AH2-INVOICE            Alpha 22                                  AP115   AP198
Element: Invoice       Used to identify the invoice.

AH2-SUFFIX             Numeric 3                                 AP198
Element: Suffix        This is the suffix for the invoice.

AH2-CANCEL-SEQ         Numeric 4                                 AP198
Element: Seq Nbr       An automatically assigned sequence
                       number.

AH2-DIST-SEQ-NBR       Numeric 6                                 AP198
Element: Dist Seq Nbr  A unique sequence number.

AH2-ORIG-DIST-SEQ      Numeric 6                                 AP198
Element: Dist Seq Nbr  A unique sequence number.

AH2-DIST-TYPE          Alpha 1                                   AP198
Element: Dist Type     The distribution type.
                           "D" = Distribution
                           "I" = Inter-company
                           "G" = Gain/Loss

AH2-PROC-LEVEL         Alpha 5                                   AP198
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

AH2-POST-OPTION        Alpha 1                                   AP198
Element: Post Option   General Ledger posting option.

AH2-INVOICE-TYPE       Alpha 1                                   AP198
Element: Invoice Type  THis field will be filled in from the
                       Invoice based on PO number.  This is a
                       carrier for the field.  The PORECEIVE
                       file will have to be updated with this
                       field.

AH2-REC-STATUS         Numeric 1                                 AP198
Element: Rec Status    The record status.

AH2-INV-CURRENCY       Alpha 5                                   AP198
Element: To Base Curr

AH2-TAX-RATE           Percent 7.5  (Percent)                    AP198
Element: Chrg Rate     Charge rate by month.

AH2-CURR-RATE          Signed 14.7                               AP198
Element: Curr Rate     The currency rate.

AH2-ORIG-BASE-AMT      Signed 18.2                               AP198
Element: Intl Amt

AH2-BASE-ND            Numeric 1                                 AP198
Element: Base Nd       The number of decimal positions defined
                       for the company base currency.

AH2-ORIG-TRAN-AMT      Signed 18.2                               AP198
Element: Intl Amt

AH2-TRAN-ND            Numeric 1                                 AP198
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


AH2-TO-BASE-AMT        Signed 18.2                               AP198
Element: Intl Amt

AH2-TO-BASE-ND         Numeric 1                                 AP198
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


AH2-TAXABLE-AMT        Signed 18.2                               AP198
Element: Intl Amt

AH2-UNT-AMOUNT         Signed 18.2                               AP198
Element: Intl Amt

AH2-DIST-COMPANY       Numeric 4                                 AP198
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AH2-DIS-ACCT-UNIT      Alpha 15                                  AP198
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


AH2-DIS-ACCOUNT        Numeric 6                                 AP198
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

AH2-DIS-SUB-ACCT       Numeric 4                                 AP198
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

AH2-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP198
Element: Date          This field displays the system date
                       when this was created.

AH2-TAX-SEQ-NBR        Numeric 4                                 AP198
Element: Tax Seq Nbr

AH2-TAX-INDICATOR      Numeric 1                                 AP198
Element: Tax Indicator 1 = Exempt
                       2 = Taxable

AH2-TAX-CODE           Alpha 10                                  AP198
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


AH2-TAX-TYPE           Alpha 1                                   AP198
Element: Tax Type      The type of tax.

AH2-DESCRIPTION        Alpha 30  (Lower Case)                    AP198
Element: Description   This field displays the description.

AH2-DST-REFERENCE      Alpha 10                                  AP198
Element: Cross Ref     A user-defined field that can be used
                       to cross reference expenses to advances
                       or cash payments.

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


AH2-ACCT-CATEGORY      Alpha 5                                   AP198
Element: Acct Category Account categories are groupings of
                       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

AH2-BILL-CATEGORY      Alpha 32                                  AP198
Element: Bill Category

AH2-ACCR-CODE          Alpha 4                                   AP198
Element: Accr Code     A user-defined code representing a
                       general ledger accrual account.

AH2-PO-NUMBER          Alpha 14  (Right Justified)               AP198
Element: Po Number     This field contains the number
                       representing the purchase order.

AH2-PO-RELEASE         Numeric 4                                 AP198
Element: Po Release    Used to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

AH2-PO-CODE            Alpha 4                                   AP198
Element: Po Code       This is the purchase order code.

AH2-PO-LINE-NBR        Numeric 6                                 AP198
Element: Line Nbr      This field contains the line number.

AH2-PO-AOC-CODE        Alpha 2                                   AP198
Element: Aoc Code      This field contains the identifier for
                       the add on cost associated with this
                       line item.

AH2-GLT-OBJ-ID         Numeric 12                                AP198
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

AH2-ATN-OBJ-ID         Numeric 12                                AP198
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

AH2-ASSET-FLAG         Alpha 1                                   AP198
Element: Asset Flag

AH2-DIST-CODE          Alpha 9                                   AP198
Element: Dist Code     A user-defined code used to
                       automatically create expense
                       distributions or expense distribution
                       "shells" for invoices or to split an
                       invoice distribution into multiple
                       distributions.

AH2-TAX-POINT          Alpha 1                                   AP198
Element: Tax Point

AH2-VAT-REVERSE-FL     Alpha 1                                   AP198
Element: All Flag

AH2-DST-OBJ-ID         Numeric 12                                AP198
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

AH2-MA-CREATE-FL       Alpha 1                                   AP198
Element: Account Flag

AH2-TAX-USAGE-CD       Alpha 10                                  AP198
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

AH2-TRAN-DIST-FLAG     Alpha 1                                   AP198
Element: Final Dst Flag

AH2-AC-UPD-STATUS      Numeric 1                                 AP198
Element: Ac Upd Status AC provides status that the activity
                       reflects "cash basis" billing. Status
                       change will reflect AP invoice for
                       distibution has been paid and message of
                       payment has been sent to AC.
                       0 = No payment information impact
                       1 = Requires payment information
                       2 = AP invoice paid. AC updated.

AH2-AC-UPD-DATE        Numeric 8  (yyyymmdd)                     AP198
Element: Ac Upd Date   Last Ac distribtion record status change
                       date.

AH2-AC-UPD-TIME        Numeric 6  (hhmmss)                       AP198
Element: Ac Upd Time   Last AC distribution record change time.

AH2-DIST-STATUS        Derived
Element: Dist Status

AH2-DIVERSE-CODE       Alpha 5                                   AP198
Element: Diverse Code  Diversity Code for Account Payable
                       Vendors

AH2-DISTRIB-ADJ        Numeric 1                                 AP198
Element: Distrib Adj   Identifies distribution as one that was
                       created from AP30.2 Distribution
                       Adjustments.  If created in AP30.2 form
                       value equal to '1'.  Used to determine
                       source code to send to GLTRANS and
                       ACTRANS.

AH2-PULL-FOR-FR-FL     Alpha 1
Element: Pull For Fr Fl

AH2-STATEMENT          Alpha 22
Element: Invoice       Used to identify the invoice.

AH2-TXN-NBR            Alpha 22
Element: Transaction

                         APAPDHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AH2SET1   API-OBJ-ID                                             AP115   AP136
          DIST-SEQ-NBR                                           AP180   AP181
                                                                 AP190   AP28.1
                                                                 AP28.2  AP300
                                                                 AP305   AP45.1

AH2SET2   COMPANY       Subset
          STATEMENT     Where (PO-NUMBER = Spaces )
          TXN-NBR
          API-OBJ-ID
          DIST-SEQ-NBR

AH2SET4   DIST-COMPANY  KeyChange                                AP275
          DIS-ACCT-UNIT
          DIS-ACCOUNT
          DIS-SUB-ACCT
          DISTRIB-DATE
          API-OBJ-ID
          DIST-SEQ-NBR

AH2SET5   GLT-OBJ-ID    KeyChange, Subset
          API-OBJ-ID    Where GLT-OBJ-ID != Zeroes
          DIST-SEQ-NBR

AH2SET6   DST-OBJ-ID    KeyChange, Subset
                        Where DST-OBJ-ID != Zeroes

AH2SET9   ATN-OBJ-ID    KeyChange, Subset
          COMPANY       Where ATN-OBJ-ID != Zeroes
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          DIST-SEQ-NBR

                         APAPDHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Actrans        ACTRANS      Not Required

                            AH2-ATN-OBJ-ID       -> ATN-OBJ-ID  (ATNSET12)

Apapihist      APAPIHIST    Required

                            AH2-COMPANY          -> AH1-COMPANY
                            AH2-VENDOR           -> AH1-VENDOR
                            AH2-INVOICE          -> AH1-INVOICE
                            AH2-SUFFIX           -> AH1-SUFFIX
                            AH2-CANCEL-SEQ       -> AH1-CANCEL-SEQ

Apcompany      APCOMPANY    Required

                            AH2-COMPANY          -> CPY-COMPANY

Apuavhist      APUAVHIST    Not Required

                            "D"                  -> AH5-SEG-TYPE
                            AH2-API-OBJ-ID       -> AH5-API-OBJ-ID
                            AH2-DIST-SEQ-NBR     -> AH5-DIST-SEQ-NBR

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            AH2-VENDOR           -> VEN-VENDOR

Asset          APAPSHIST    Not Required

                            AH2-API-OBJ-ID       -> AH4-API-OBJ-ID
                            AH2-DIST-SEQ-NBR     -> AH4-DIST-SEQ-NBR

Dstusrfld      APDFLHIST    Not Required

                            AH2-API-OBJ-ID       -> AH7-API-OBJ-ID
                            AH2-DIST-SEQ-NBR     -> AH7-DIST-SEQ-NBR

Glmaster       GLMASTER     Required

                            AH2-DIST-COMPANY     -> GLM-COMPANY
                            AH2-DIS-ACCT-UNIT    -> GLM-ACCT-UNIT
                            AH2-DIS-ACCOUNT      -> GLM-ACCOUNT
                            AH2-DIS-SUB-ACCT     -> GLM-SUB-ACCOUNT

Glsystem Orig  GLSYSTEM     Required

                            AH2-COMPANY          -> GLS-COMPANY

Glsystem To    GLSYSTEM     Required

                            AH2-DIST-COMPANY     -> GLS-COMPANY