Lawson Insight Technical Documentation |
|
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
|