PV_TEMPL_ITEMS

(SQL Table)
Index Back

Template Items

Template Items Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
2 PV_TEMPLATE Character(30) VARCHAR2(30) NOT NULL Templates
3 FAVORITES_TYPE Character(5) VARCHAR2(5) NOT NULL Favorite Type
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID
6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_POVW1

10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
12 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
13 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
14 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
15 SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL Sevice type
1=Service Request
2=Service Reply
16 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
17 PROJECT_ROLE Character(30) VARCHAR2(30) NOT NULL Project Role
18 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
19 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
20 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
23 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
24 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
25 PV_SR_TYPE Character(1) VARCHAR2(1) NOT NULL Request type
B=Blanket Order
F=Fixed Cost
G=Good
L=Variable Cost
M=Time & Materials 2
N=Rentals
R=Recurring Agreement
T=Time and Materials
26 USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
27 LAST_ORDER_DATE Date(10) DATE Last Order Date
28 PREFERRED_FAV_FLG Number(1,0) SMALLINT NOT NULL Preferred Favorite Flag

Default Value: 0

29 LN_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type
CAT=Catalog Item
CUST=Custom Item
DC=Direct Connect Item
DCEX=Exchange Item
DCPO=Punchout Item
DCRT=Round Trip
DCTP=Transparent Punchout Item
DESR=Ad-hoc Item
EF=Express Form Item
OS=Order Sheet
SDF=Supplemental Data Form
SPRO=Service
SR=ePro Special Request Item
SRFC=Fixed Cost Service Item
SRTM=Time and Material Service Item
SRVC=Variable Cost Service Item
30 KEY1 Character(65) VARCHAR2(65) NOT NULL First Key
31 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
32 KEY2 Character(65) VARCHAR2(65) NOT NULL Second Key
33 KEY2_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 2 Field Value
34 KEY3 Character(65) VARCHAR2(65) NOT NULL Third Key
35 KEY3_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 3 Field Value
36 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
37 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number