POPSPHIST FILE
UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP220
AP28.1 AP28.2 AP30.4 AP300 AP305 AP45.1
API1.1 API2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PH1-COMPANY Numeric 4 AP198
Company The company number represents an
established company and is entered on
all function codes.
PH1-PO-NUMBER Alpha 14 (Right Justified) AP198
PO Number This field contains the number
representing the purchase order.
PH1-PO-RELEASE Numeric 4 AP198
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
PH1-PO-CODE Alpha 4 AP198
Po Code This is the purchase order code.
PH1-AOC-CODE Alpha 2 AP198
Add On Cost Code This field contains the identifier for
the add on cost associated with this
line item.
PH1-INVOICE Alpha 22 AP115 AP198
Invoice Number Used to identify the invoice. AP220 AP30.4
AP305 API1.1
API2.1
PH1-AOC-RATE Percent 7.3 (Percent) AP198
Add On Cost 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 15.2 AP198
Ent Aoc Amount
PH1-CALC-SPRD-AMT Signed 15.2 AP198
Calculated Spread This calculated amount is the
Amount accumulation of all Add On Cost
unit costs extended for the Purchase
Order after using the spread feature.
PH1-SPREAD-DIFF Signed 15.2 AP198
Spread Difference The difference between the entered
spread amount and the accumulated
spread amount for the Purchase Order.
PH1-SPREAD-METHOD Alpha 1 AP198
Spread Method A method of spreading Add On Cost
amounts across the Purchase Order
line level.
PH1-TAX-CODE Alpha 10 AP198
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PH1-DST-ACCT-UNIT Alpha 15 AP198
Distribution Contains the General Ledger accounting
Accounting Unit unit to which the amount is posted.
PH1-DST-ACCOUNT Numeric 6 AP198
Distribution Contains the General Ledger account to
Account Number which the amount is posted.
PH1-DST-SUB-ACCT Numeric 4 AP198
Distribution Contains the General Ledger subaccount
Subaccount Number to which the amount is posted.
PH1-TAXABLE-FLAG Alpha 1 AP198
Taxable or Defines if Taxable.
Non-Taxable Flag
PH1-ACCRUAL-FL Alpha 1 AP198
Accrual Flag
PH1-TAX-AMOUNT Signed 13.5 AP198
Tax Amount
PH1-AOC-ON-PO Alpha 1 AP198
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
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
Vendor ID The vendor's identification code. AP220 AP30.4
AP305 API1.1
API2.1
PH1-PURCH-FR-LOC Alpha 4 AP198
Purchase From The vendor's purchase from location.
Location Code
PH1-SEGMENT-BLOCK Alpha 103 AP198
User Analysis 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
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
Account 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.
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 AP220 AP28.1
AOC-CODE AP28.2 AP30.4
AP300 AP305
AP45.1 API1.1
API2.1
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
|
