Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APAPDHIST


                             APAPDHIST FILE

REFERENCED BY

AP260     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
Object
Identification

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



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

AH2-SUFFIX             Numeric 3                                 AP198
Element: Invoice SuffixThis is the suffix for the invoice.

AH2-CANCEL-SEQ         Numeric 4                                 AP198
Element: Sequence NumbeThe sequence number assigned upon a
                       cancellation of a distributed invoice.
                       The first sequence assigned is 9999.

AH2-DIST-SEQ-NBR       Numeric 4                                 AP198
Distribution           A unique sequence number.
Sequence Number

AH2-ORIG-DIST-SEQ      Numeric 4                                 AP198
Element: Orig Dist Seq

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

AH2-PROC-LEVEL         Alpha 5                                   AP198
Element: Process Level The process level represents a
                       reporting level below company.

AH2-POST-OPTION        Alpha 1                                   AP198
Element: Posting OptionGeneral 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: Record Status The record status.

AH2-INV-CURRENCY       Alpha 5                                   AP198
To Company Base
Currency

AH2-TAX-RATE           Percent 7.5  (Percent)                    AP198
Element: Chrg Rate     The tax rate defined for the tax code.

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

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

AH2-BASE-ND            Numeric 1                                 AP198
Base Number Of         The number of decimal positions defined
Decimals               for the company base currency.

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

AH2-TRAN-ND            Numeric 1                                 AP198
Account Currency       The number of decimal positions defined
Code                   for the transaction currency.

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

AH2-TO-BASE-ND         Numeric 1                                 AP198
Account Currency
Code

AH2-TAXABLE-AMT        Signed 18.2                               AP198
Element: Intl Amt      This is the taxable amount.

AH2-UNT-AMOUNT         Signed 18.2                               AP198
Element: Intl Amt      The total units.

AH2-DIST-COMPANY       Numeric 4                                 AP198
Element: Company       The company number used for posting the
                       transaction. A valid intercompany
                       relationship must be defined in the
                       Lawson General Ledger system.

AH2-DIS-ACCT-UNIT      Alpha 15                                  AP198
Element: Accounting UniThe general ledger distribution
                       accounting unit. Select a valid
                       accounting unit if you want the
                       interface program to create general
                       ledger transactions for transaction with
                       a record status of  '1' and '2' only. A
                       transaction will be created to this
                       account and an offset transaction to the
                       cash account will occur.

AH2-DIS-ACCOUNT        Numeric 6                                 AP198
Element: Account       Required if the distribution accounting
                       unit field is not blank. The general
                       ledger distribution account.

AH2-DIS-SUB-ACCT       Numeric 4                                 AP198
Element: Subaccount    The general ledger distribution
                       subaccount.

AH2-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP198
Element: Date          The date used for posting the
                       transactions to the general ledger.

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     The distribution reference.

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: Account CategoAccount 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: Accrual 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 NumUsed 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 Number   The PO line number this record is
                       associated with.

AH2-PO-AOC-CODE        Alpha 2                                   AP198
Element: Add On Cost Code

AH2-GLT-OBJ-ID         Numeric 12                                AP198
Object                 This is a subsystem GL interface
Identification         identification number. It is used for
                       Drill Around purposes.

AH2-ATN-OBJ-ID         Numeric 12                                AP198
Object                 The system-defined object id
Identification         representing the Activity Management
                       commitment.

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

AH2-DIST-CODE          Alpha 9                                   AP198
Element: Distribution CA 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
Object
Identification

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
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: Distribution Status

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

AH2-DISTRIB-ADJ        Numeric 1
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.

                         APAPDHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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