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 AP220
AP23.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2
AP30.4 AP300 AP305 AP45.1 API1.1 API2.1
MA41.2 MA41.7 MA43.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PH1-COMPANY Numeric 4 AP198
Element: Company The company number represents an
established company and is entered on
all function codes.
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 NumUsed 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: Add On Cost CoThis field contains the identifier for
the add on cost associated with this
line item.
PH1-INVOICE Alpha 22 AP115 AP198
Element: Invoice NumberUsed to identify the invoice. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP30.4
AP305 API1.1
API2.1 MA41.2
MA41.7 MA43.2
PH1-AOC-RATE Percent 7.3 (Percent) AP198
Element: Add On Cost RaAdd 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
Element: Adj Amt
PH1-CALC-SPRD-AMT Signed 15.2 AP198
Element: Adj Amt
PH1-SPREAD-DIFF Signed 15.2 AP198
Element: Spread DiffereThe difference between the entered
spread amount and the accumulated
spread amount for the Purchase Order.
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: Accounting Unit
PH1-DST-ACCOUNT Numeric 6 AP198
Element: Account
PH1-DST-SUB-ACCT Numeric 4 AP198
Element: Subaccount
PH1-TAXABLE-FLAG Alpha 1 AP198
Taxable or Defines if Taxable.
Non-Taxable Flag
PH1-ACCRUAL-FL Alpha 1 AP198
Element: Accrual Flag
PH1-TAX-AMOUNT Signed 13.5 AP198
Element: Base Cost
PH1-AOC-ON-PO Alpha 1 AP198
Element: All Flag
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 ID The vendor's identification code. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP30.4
AP305 API1.1
API2.1 MA41.2
MA41.7 MA43.2
PH1-PURCH-FR-LOC Alpha 4 AP198
Purchase From The vendor's purchase from location.
Location Code
PH1-SEGMENT-BLOCK Alpha 103 AP198
Element: 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
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: 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.
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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP300 AP305
AP45.1 API1.1
API2.1 MA41.2
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
|