PO_ITM_STG_VNV8

(SQL View)
 Index Back

Sourcing Analysis Supplier Vie


select PROCESS_INSTANCE, BUSINESS_UNIT, PO_STG_TYPE, PO_STG_ID, LINE_NBR, SCHED_NBR, VENDOR_SETID, VENDOR_ID, VNDR_LOC, CURRENCY_CD_BASE, INV_ITEM_ID, ITM_SETID, ITM_VNDR_PRIORITY, LEAD_TIME, LEAD_TIME_IMP, LEAD_TIME_RANK, LEAD_TIME_RATING, LEAD_TM_RT_SET, PCT_ALLOC, PO_ID, PRICE_IMP, PRICE_PO_BSE, PRICE_PO_BSE_STD, PRICE_RANK, PRICE_RATING, PRICE_RT_SET, QTY_REQ, QTY_REQ_STD, RECOM_VNDR, SHIPTO_ID, SHIPTO_PR_IMP, SHIPTO_PR_RANK, SHIPTO_PR_RATING, SHIPTO_PR_RT_SET, SHIPTO_SETID, SHIPTO_VNDR_PR, SRC_METHOD, UNIT_OF_MEASURE, UNIT_MEASURE_STD, USE_THIS_VNDR, VNDR_COUNT, VNDR_PR_IMP, VNDR_PR_RANK, VNDR_PR_RATING, VNDR_PR_RT_SET, VNDR_SCORE, VNDR_SOURCE from PS_PO_ITM_STG_VND

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition
4 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

9 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VENDOR_LOC_VW

10 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
13 ITM_VNDR_PRIORITY Number(3,0) SMALLINT NOT NULL Item Vendor Priority
14 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
15 LEAD_TIME_IMP Number(6,2) DECIMAL(5,2) NOT NULL Lead Time Factor %
16 LEAD_TIME_RANK Number(8,4) DECIMAL(7,4) NOT NULL Lead Time Rank
17 LEAD_TIME_RATING Number(9,5) DECIMAL(8,5) NOT NULL Lead Time Rating
18 LEAD_TM_RT_SET Character(1) VARCHAR2(1) NOT NULL Lead Time Rating Set
19 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
20 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
21 PRICE_IMP Number(6,2) DECIMAL(5,2) NOT NULL Price Factor %
22 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base
23 PRICE_PO_BSE_STD Signed Number(17,5) DECIMAL(15,5) NOT NULL Base Price in Std UOM
24 PRICE_RANK Number(8,4) DECIMAL(7,4) NOT NULL Price Rank
25 PRICE_RATING Number(9,5) DECIMAL(8,5) NOT NULL Price Rating
26 PRICE_RT_SET Character(1) VARCHAR2(1) NOT NULL Price Rating Set
27 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
28 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
29 RECOM_VNDR Character(1) VARCHAR2(1) NOT NULL Recommended Supplier
30 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
31 SHIPTO_PR_IMP Number(6,2) DECIMAL(5,2) NOT NULL Ship to Priority Factor %
32 SHIPTO_PR_RANK Number(8,4) DECIMAL(7,4) NOT NULL Shipto Priority Rank
33 SHIPTO_PR_RATING Number(9,5) DECIMAL(8,5) NOT NULL Shipto Priority Rating
34 SHIPTO_PR_RT_SET Character(1) VARCHAR2(1) NOT NULL Shipro Priority Rating Set
35 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
36 SHIPTO_VNDR_PR Number(3,0) SMALLINT NOT NULL Shipto Supplier Priority
37 SRC_METHOD Character(1) VARCHAR2(1) NOT NULL Sourcing Method
B=Basic
F=Flexible
H=Cumulative Split
S=Sched Split
38 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
39 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
40 USE_THIS_VNDR Character(1) VARCHAR2(1) NOT NULL Supplier to Use for PO
41 VNDR_COUNT Number(3,0) SMALLINT NOT NULL Supplier Count
42 VNDR_PR_IMP Number(6,2) DECIMAL(5,2) NOT NULL Vendor Priority Factor %
43 VNDR_PR_RANK Number(8,4) DECIMAL(7,4) NOT NULL Supplier Priority Rank
44 VNDR_PR_RATING Number(9,5) DECIMAL(8,5) NOT NULL Supplier Priority Rating
45 VNDR_PR_RT_SET Character(1) VARCHAR2(1) NOT NULL Supplier Priority Rating Set
46 VNDR_SCORE Number(6,2) DECIMAL(5,2) NOT NULL Supplier Selection Score
47 VNDR_SOURCE Character(1) VARCHAR2(1) NOT NULL Where Supplier was Found
1=Basic, Category Supplier
2=Basic, Item Shipto Supplier
3=Basic, Item Supplier
4=Flex, Item Supplier
5=Split, Item Supplier
6=Split, Category Supplier
7=Cumulative, Category Supp, Nxt
8=Cumulative, Category Supp, Min
9=Basic, Regional Supplier