CNTRCT_RFQ_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
4	CNTRCT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Buying Agreement Line Nbr
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
6	PRCR_DOC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Document Type CNT=Contract IUR=Inter Unit Receipt MSR=MSR PMT=Payment PO=Purchase Order RCV=Receipt REQ=Requisition RFQ=Request For Quote RTV=Return To Vendor (Supplier) SSE=Strategic Sourcing Event VOU=Voucher WO=Work Order
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	DOC_ID	Character(50)	VARCHAR2(50) NOT NULL	ID
9	DOC_LINE	Number(5,0)	INTEGER NOT NULL	Document Line Number
10	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
11	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
12	BUSINESS_UNIT_REQ	Character(5)	VARCHAR2(5) NOT NULL	Requesting Business Unit
13	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
14	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
15	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
16	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
17	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity
18	LIQUIDATE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Liquidate by A=Amount Q=Quantity
19	DISTRIB_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Distribution Percentage
20	QTY_REQ_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Requested Stand. UOM
21	QTY_OPEN_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Open Standard UOM
22	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 0
23	DONE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Done Flag Default Value: N