|
|
PROCTEMPLN FILE
REFERENCED BY
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO215 RQ10.1 RQ10.3 RQ10.2 RQ11.1 RQ35.1
RQIC.1 RQIG.1 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.4 API1.1
CXCP.1 DR100 IC141 IC142 IC21.1 IC21.2
IC28.1 IC500 IC83.1 MA180 MA41.2 MA41.7
MA43.1 MA43.2 MA43.3 MA43.9 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
PO100 PO101 PO122 PO131 PO22.1 PO23.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POI3.1 POII.1 POIJ.1 RQ500
RQID.1 RQIE.1 RQIF.1 RQIJ.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 WO132 WO140 IC11.1 PO45.1
UPDATED BY
PO115 PO15.1 PO15.2 RQ780
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POE-PROCURE-GROUP Alpha 4 PO115 PO15.1
Element: Procure Group This field contains the identifier for a PO15.2 PO21.1
group of companies that share a common RQ10.3 RQ780
procurement effort. They buy items and
services together.
POE-TEMPLATE-REF Alpha 30 PO115 PO15.1
Element: Template Ref PO15.2 PO21.1
RQ10.3 RQ780
POE-LINE-NBR Numeric 6 PO115 PO15.1
Element: Line Number This field contains the line number. PO15.2 PO21.1
RQ10.3 RQ780
POE-ITEM Alpha 32 PO115 PO15.1
Element: Item Number This field contains the item PO15.2 PO21.1
identifier. RQ10.3 RQ780
POE-SERVICE-DESC Alpha 30 (Lower Case) PO115 PO15.1
Element: Service Desc PO15.2 PO21.1
RQ10.3 RQ780
POE-SERVICE-CODE Alpha 1 PO115 PO15.1
Element: Service Code Q = Quantity PO15.2 PO21.1
A = Amount RQ10.3 RQ780
" " = Not Service Item
POE-UOM Alpha 4 PO115 PO15.1
Element: Unit of MeasurThis field contains the valid stock PO15.2 PO21.1
unit of measure for this item. RQ10.3 RQ780
POE-QUANTITY Signed 13.4 PO115 PO15.1
Element: Quantity This field contains the desired PO15.2 PO21.1
quantity. RQ10.3 RQ780
POE-ACCT-UNIT-FL Numeric 1 PO115 PO15.1
Element: Acct Unit Fl This flag will be used allow the PO15.2 PO21.1
requesting location accounting unit to RQ10.3
override the IC02 flag to use the GL
category accounting unit.
0 = No
1 = Yes
POE-DIST-COMPANY Numeric 4 PO115 PO15.1
Element: Company PO15.2 PO21.1
RQ10.3 RQ780
POE-ACCT-UNIT Alpha 15 PO115 PO15.1
Element: Accounting UniThe accounting unit is a shorthand PO15.2 PO21.1
notation representing the variable level RQ10.3 RQ780
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.
POE-ACCOUNT Numeric 6 PO115 PO15.1
Element: Account This field along with the accounting PO15.2 PO21.1
unit and subaccount make up the location RQ10.3 RQ780
(account) where amounts and other
account information is stored.
POE-SUB-ACCT Numeric 4 PO115 PO15.1
Element: Subaccount This field contains the subaccount from PO15.2 PO21.1
your general ledger chart of accounts RQ10.3 RQ780
that was charged with the amount carried
on this record.
POE-ACTIVITY Alpha 15 PO115 PO15.1
Element: Activity Activities are the processes or PO15.2 PO21.1
procedures that produce work. Cost RQ10.3 RQ780
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
POE-ACCT-CATEGORY Alpha 5 PO115 PO15.1
Element: Account CategoAccount categories are groupings of PO15.2 PO21.1
costs, revenues, or a combination of RQ10.3 RQ780
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.
POE-FROM-COMPANY Numeric 4 PO115 PO15.1
Element: Company PO15.2 PO21.1
RQ10.3 RQ780
POE-FROM-LOCATION Alpha 5 PO115 PO15.1
Element: Location Code PO15.2 PO21.1
RQ10.3 RQ780
PROCTEMPLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POESET1 PROCURE-GROUP PO115 PO15.1
TEMPLATE-REF PO15.2 PO20.1
LINE-NBR PO21.1 PO215
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ780 RQIC.1
RQIG.1
POESET2 PROCURE-GROUP KeyChange AP125 AP126
TEMPLATE-REF AP131 AP20.1
ITEM AP20.2 AP20.3
LINE-NBR AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC141 IC142
IC21.1 IC21.2
IC28.1 IC500
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
...
POESET3 PROCURE-GROUP KeyChange IC11.1 PO115
ITEM PO45.1 RQID.1
TEMPLATE-REF RQIF.1 RQIJ.1
LINE-NBR
PROCTEMPLN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemmast ITEMMAST Not Required
Valid When (POE-SERVICE-CODE = Spaces )
PCG-ITEM-GROUP -> ITE-ITEM-GROUP
POE-ITEM -> ITE-ITEM
Procuregroup PROCUREGRP Not Required
POE-PROCURE-GROUP -> PCG-PROCURE-GROUP
|
