|
|
POPSPHIST FILE
UPDATED BY
AP115 AP125 AP126 AP180 AP181 AP190
AP198 AP220 AP25.1 AP25.2 AP26.1 AP27.1
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
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 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 AP125
Element: Invoice NumberUsed to identify the invoice. AP126 AP198
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP305 API1.1
API2.1
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 18.2 AP198
Element: Intl Amt
PH1-CALC-SPRD-AMT Signed 18.2 AP198
Element: Intl Amt This calculated amount is the
accumulation of all Add On Cost
unit costs extended for the Purchase
Order after using the spread feature.
PH1-SPREAD-DIFF Signed 18.2 AP198
Element: Intl Amt The 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 UniContains the General Ledger accounting
unit to which the amount is posted.
PH1-DST-ACCOUNT Numeric 6 AP198
Element: Account Contains the General Ledger account to
which the amount is posted.
PH1-DST-SUB-ACCT Numeric 4 AP198
Element: Subaccount Contains the General Ledger subaccount
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
Element: Accrual Flag
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 AP125
Element: Vendor ID The vendor's identification code. AP126 AP198
AP220 AP25.1
AP25.2 AP26.1
AP27.1 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
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.
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 AP125
VENDOR Where INVOICE != Spaces AP126 AP180
INVOICE AP181 AP190
AOC-CODE AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
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
|
