PO_FLEX_RNK_TMP

#	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
9	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
10	ITM_VNDR_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Item Vendor Priority
11	ITM_VNDR_PR_TOT	Number(8,4)	DECIMAL(7,4) NOT NULL	Item Supplier Priority
12	LEAD_TIME	Number(3,0)	SMALLINT NOT NULL	Lead Time Days
13	LEAD_TIME_RANK	Number(8,4)	DECIMAL(7,4) NOT NULL	Lead Time Rank
14	LEAD_TIME_TOT	Number(5,0)	INTEGER NOT NULL	Lead Time Days
15	PRICE_PO_BSE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Price Base
16	PRICE_PO_BSE_STD	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Base Price in Std UOM
17	PRICE_PO_BSE_TOT	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Price Base
18	PRICE_RANK	Number(8,4)	DECIMAL(7,4) NOT NULL	Price Rank
19	SHIPTO_PR_RANK	Number(8,4)	DECIMAL(7,4) NOT NULL	Shipto Priority Rank
20	SHIPTO_VNDR_PR	Number(3,0)	SMALLINT NOT NULL	Shipto Supplier Priority
21	SHIPTO_VNDR_PR_TOT	Number(3,0)	SMALLINT NOT NULL	Shipto Supplier Priority
22	VNDR_PR_RANK	Number(8,4)	DECIMAL(7,4) NOT NULL	Supplier Priority Rank