CNTRCT_RFQ_XREF

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 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
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 DOC_ID Character(50) VARCHAR2(50) NOT NULL ID
8 DOC_LINE Number(5,0) INTEGER NOT NULL Document Line Number
9 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
10 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
11 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
12 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
13 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
14 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
15 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
16 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
17 LIQUIDATE_METHOD Character(1) VARCHAR2(1) NOT NULL Liquidate by
A=Amount
Q=Quantity

Default Value: A

18 DISTRIB_PCT Number(8,4) DECIMAL(7,4) NOT NULL Distribution Percentage
19 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
20 QTY_OPEN_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM
21 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 0