RTV_CNTRCT_WRK3

(SQL Table)
Index Back

RTV Contract Work

Used by PO_RTVRECON for updating contract released amounts and quantities

# 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 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
4 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
5 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
7 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
8 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
9 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
10 QTY_LN_RETRN_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Std Returned Qty
11 CURRENCY_RTV Character(3) VARCHAR2(3) NOT NULL Used by PO_RTVRECON process for updating contract released amounts.
12 CURRENCY_CD_CNTR Character(3) VARCHAR2(3) NOT NULL Contract Base Currency
13 UNIT_MEASURE_CNTR Character(3) VARCHAR2(3) NOT NULL Contract Unit of Measure
14 AMT_LINE_RELEASED Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Amt Released
15 QTY_LINE_RELEASED Number(15,2) DECIMAL(14,2) NOT NULL Total Line Qty Released
16 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
17 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
18 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

Default Value: 1

19 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
20 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
21 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
22 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
23 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
24 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
25 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
26 DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Done Flag

Default Value: N

27 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
28 CNTRCT_ID_DST Character(25) VARCHAR2(25) NOT NULL Contract ID To