Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POPSPHIST


                             POPSPHIST FILE

UPDATED BY

AP115     AP180     AP181     AP190     AP198     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP220     AP23.1    AP25.2    AP26.1    AP27.1    AP28.1
AP28.2    AP30.4    AP300     AP305     AP45.1    API1.1
API2.1    MA41.1    MA41.2    MA41.4    MA41.7    MA43.2


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PH1-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.

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

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

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

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

PH1-INVOICE            Alpha 22                                  AP115   AP198
Element: Invoice       Used to identify the invoice.             AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

PH1-AOC-RATE           Percent 7.3  (Percent)                    AP198
Element: Aoc Rate      Add On Cost Percentage Rate. If add on
                       cost is spread by rate, this value times
                       the line unit cost is the unit add on
                       cost for the PO line.

PH1-ENT-AOC-AMOUNT     Signed 18.2                               AP198
Element: Intl Amt

PH1-CALC-SPRD-AMT      Signed 18.2                               AP198
Element: Intl Amt

PH1-SPREAD-DIFF        Signed 18.2                               AP198
Element: Intl Amt

PH1-SPREAD-METHOD      Alpha 1                                   AP198
Element: Spread Method A method of spreading Add On Cost
                       amounts across the Purchase Order
                       line level.

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


PH1-DST-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.


PH1-DST-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.

PH1-DST-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.

PH1-TAXABLE-FLAG       Alpha 1                                   AP198
Element: Taxable Flag  Defines if Taxable.

PH1-ACCRUAL-FL         Alpha 1                                   AP198
Element: Accrual Fl

PH1-TAX-AMOUNT         Signed 18.5                               AP198
Element: Intl Cost

PH1-AOC-ON-PO          Alpha 1                                   AP198
Element: Aoc On Po     Indicates if the add-on cost is to
                       appear on the Purchase Order document
                       that is issued to the vendor.

PH1-SUMMARY-FLAG       Alpha 1                                   AP198
Element: Summary Flag  Defines if add on cost is printed in
                       summary or at a detail level on the
                       Lawson Purchase Order document.

PH1-VENDOR             Alpha 9  (Right Justified)                AP115   AP198
Element: Vendor        The vendor's identification code.         AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

PH1-PURCH-FR-LOC       Alpha 4                                   AP198
Element: Purch Fr Loc  The vendor's purchase from location.

PH1-SEGMENT-BLOCK      Alpha 103                                 AP198
Element: Segment Block This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

PH1-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.


PH1-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

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

                         POPSPHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PH1SET1   COMPANY
          PO-NUMBER
          PO-RELEASE
          PO-CODE
          AOC-CODE
          INVOICE

PH1SET4   COMPANY       Subset                                   AP115   AP180
          VENDOR        Where INVOICE != Spaces                  AP181   AP190
          INVOICE                                                AP20.1  AP20.2
          AOC-CODE                                               AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP300
                                                                 AP305   AP45.1
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

                         POPSPHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Poaudit        POAUDIT

                            PH1-COMPANY       -> PAU-COMPANY
                            PH1-PO-NUMBER     -> PAU-PO-NUMBER
                            PH1-PO-RELEASE    -> PAU-PO-RELEASE
                            PH1-PO-CODE       -> PAU-PO-CODE
                            Zeroes            -> PAU-PO-LINE-NBR
                            PH1-AOC-CODE      -> PAU-AOC-CODE
                                                 PAU-PO-REVISION
                                                 PAU-UPDATE-DATE
                                                 PAU-UPDATE-TIME
                                                 PAU-FLD-NBR
                                                 PAU-AUDIT-TYPE
                                                 PAU-AUDIT-ACTION