PV_ITMCAT_WS

(SQL Table)
Index Back

Item Catalog Vndr Manufac Srch

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: INV_ITEMS

3 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: ITM_CAT_TBL

4 CATEGORY_TYPE Character(3) VARCHAR2(3) NOT NULL Category Type
PSF=User Def
UNS=UN/SPSC
5 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
6 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
9 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
10 PRICE_LIST Number(16,5) DECIMAL(15,5) NOT NULL Standard Price
11 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
12 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
13 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