PROCTEMPLN

Procurement Template Line

REFERENCED BY
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO215 RQ10.1 RQ10.3 RQ10.2
RQ10.4 RQ10.5 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIJ.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 AP510
API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC21.1 IC21.2 IC243 IC330 IC500 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 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 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO120 PO122 PO131
PO132 PO136 PO150 PO17.1 PO190 PO204
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO275 PO276 PO277 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
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
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ01.1 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQII.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 WH32.5
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 PO15.4 PO27.4 PO00.1
IC216

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POE-PROCURE-GROUP
Element: Procure Group
Alpha 4
Type or select a procurement group. A procurement group is a group of companies that share a common procurement effort. They buy items and services together.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-TEMPLATE-REF
Element: Template Ref
Alpha 30
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-SERVICE-DESC
Element: Service Desc
Alpha 30 (Lower Case)
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-SERVICE-CODE
Element: Service Code
Alpha 1

Q = Quantity
A = Amount
" " = Not Service Item
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-QUANTITY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-ACCT-UNIT-FL
Element: Acct Unit Fl
Numeric 1
This flag will be used allow the requesting location accounting unit to override the IC02 flag to use the GL category accounting unit.
0 = No
1 = Yes
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-DIST-COMPANY
Element: Company
Numeric 4
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.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level 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.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-ACCT-CATEGORY
Element: Acct Category
Alpha 5
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. Valid account category types are: cost revenue accrual pass thru
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-BILL-CATEGORY
Element: Bill Category
Alpha 32
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-FROM-COMPANY
Element: Company
Numeric 4
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.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-FROM-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-COMMODITY-CODE
Element: Commodity Code
Alpha 35
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-SPECIAL-DESC
Element: Description
Alpha 30 (Lower Case)
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-VEN-AGRMT-REF
Element: Agreement Ref
Alpha 30
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-TEMPLT-DOC-NBR
Element: Source Doc N
Numeric 8
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3
POE-PVN-OBJ-ID
Element: Obj Id
Numeric 12
PO115 PO15.1
PO15.2 PO15.4
PO21.1 PO27.4
RQ10.3


PROCTEMPLN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POESET1 PROCURE-GROUP
TEMPLATE-REF
LINE-NBR
PO00.1 PO115
PO15.1 PO15.2
PO15.4 PO20.1
PO21.1 PO215
PO27.4 RQ10.1
RQ10.3 RQIC.1
RQID.1 RQIF.1
RQIG.1 RQIJ.1
POESET2 PROCURE-GROUP
TEMPLATE-REF
ITEM
LINE-NBR
KeyChange
...
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
POESET3 PROCURE-GROUP
ITEM
TEMPLATE-REF
LINE-NBR
KeyChange
IC11.1 IC216
PO115 PO45.1
RQID.1 RQIF.1
RQIJ.1
POESET4 PROCURE-GROUP
TEMPLT-DOC-NBR
LINE-NBR
KeyChange, Subset
WhereTEMPLT-DOC-NBR !=Zeroes
PO100


PROCTEMPLN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Agrmtlinecost POVAGRMTLN Not Required
Valid When POE-PVN-OBJ-ID !=Zeroes
POE-PVN-OBJ-ID->PVN-PVN-OBJ-ID
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


PROCTEMPLN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Agreementitems POVAGRMTLN
Valid When POE-VEN-AGRMT-REF !=Spaces
POE-PROCURE-GROUP->PVN-PROCURE-GROUP
POE-ITEM->PVN-ITEM
POE-VEN-AGRMT-REF->PVN-VEN-AGRMT-REF
  PVN-LINE-NBR
Poitemven POITEMVEN
POE-PROCURE-GROUP->PIV-PROCURE-GROUP
POE-ITEM->PIV-ITEM
  PIV-VENDOR
  PIV-VEN-ITEM


File created: Thu Jun 09 02:28:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.