ITM_VND_EVW

(SQL View)
Index Back

Supplier Item Table

Supplier Item Table

SELECT A.SETID , A.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , %subrec(ITM_VND_ESR, A) FROM PS_ITM_VENDOR A

# 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: ITM_PURCH_VW

3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

5 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
6 PV_CP_PART_EXT Character(50) VARCHAR2(50) NOT NULL CUP Part Extension
7 ITM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
A=Active
D=Discntued
H=Hold
I=Inactive
X=To be Del

Default Value: A

8 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
9 ITM_VNDR_PRIORITY Number(3,0) SMALLINT NOT NULL Item Vendor Priority
10 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
11 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
12 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
13 FILEPATH Character(30) VARCHAR2(30) NOT NULL File Information
14 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
15 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
16 INCL_IN_PLAN Character(1) VARCHAR2(1) NOT NULL Include in Planning

Y/N Table Edit

Default Value: Y