|
|
PROCTEMPLN FILE
REFERENCED BY
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO215 RQ10.1 RQ10.3 RQ10.2 RQIC.1 RQIG.1
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 CXCP.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO190 PO22.1 PO23.1 PO24.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 PO32.4
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 POID.1 POII.1 POIJ.1 RQ11.1
RQ35.1 RQ500 RQID.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 IC11.1 PO45.1
UPDATED BY
PO115 PO15.1 PO15.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POE-PROCURE-GROUP Alpha 4 PO115 PO15.1
Element: Procure Group This field contains the identifier for PO15.2 PO21.1
a group of companies that share a common RQ10.3
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
POE-LINE-NBR Numeric 6 PO115 PO15.1
Element: Line Nbr This field contains the line number. PO15.2 PO21.1
RQ10.3
POE-ITEM Alpha 32 PO115 PO15.1
Element: Item This field contains the item PO15.2 PO21.1
identifier. RQ10.3
POE-SERVICE-DESC Alpha 30 (Lower Case) PO115 PO15.1
Element: Service Desc PO15.2 PO21.1
RQ10.3
POE-SERVICE-CODE Alpha 1 PO115 PO15.1
Element: Service Code Q = Quantity PO15.2 PO21.1
A = Amount RQ10.3
" " = Not Service Item
POE-UOM Alpha 4 PO115 PO15.1
Element: Uom This field contains the valid stock PO15.2 PO21.1
unit of measure for this item. RQ10.3
POE-QUANTITY Signed 13.4 PO115 PO15.1
Element: Quantity This field contains the desired PO15.2 PO21.1
quantity. RQ10.3
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 Identifies the AP company if the PO15.2 PO21.1
resource type = V. Identifies the HR RQ10.3
company if the resource type = E. It is
blank for type A, P or Q resources.
POE-ACCT-UNIT Alpha 15 PO115 PO15.1
Element: Acct Unit The accounting unit is a shorthand PO15.2 PO21.1
notation representing the variable level RQ10.3
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
(account) where amounts and other
account information is stored.
POE-SUB-ACCT Numeric 4 PO115 PO15.1
Element: Sub Acct This field contains the subaccount from PO15.2 PO21.1
your general ledger chart of accounts RQ10.3
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
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
POE-ACCT-CATEGORY Alpha 5 PO115 PO15.1
Element: Acct Category Account categories are groupings of PO15.2 PO21.1
costs, revenues, or a combination of RQ10.3
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
POE-BILL-CATEGORY Alpha 32 PO115 PO15.1
Element: Bill Category PO15.2 PO21.1
RQ10.3
POE-FROM-COMPANY Numeric 4 PO115 PO15.1
Element: Company Identifies the AP company if the PO15.2 PO21.1
resource type = V. Identifies the HR RQ10.3
company if the resource type = E. It is
blank for type A, P or Q resources.
POE-FROM-LOCATION Alpha 5 PO115 PO15.1
Element: Location This field contains a valid stocking PO15.2 PO21.1
location within the company inventory. RQ10.3
POE-COMMODITY-CODE Alpha 35 PO115 PO15.1
Element: Commodity Code PO15.2 PO21.1
RQ10.3
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
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
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
|
