CNTRCT_PRICE_VW

(SQL View)
 Index Back

Contract Search temp 1

Temp table for contract search.

SELECT SETID , CNTRCT_ID , VENDOR_SETID , VENDOR_ID , VERSION_NBR , CNTRCT_TYPE , CNTRCT_PROC_OPT , CNTRCT_STYLE , DESCR , CNTRCT_BEGIN_DT , CNTRCT_EXPIRE_DT , PCHOUTPRICE_OPTION , CNTRCT_LINE_NBR , CAT_LINE_NBR , UNIT_OF_MEASURE , CURRENCY_CD , ITM_SETID , INV_ITEM_ID , CATEGORY_SETID , CATEGORY_ID , UNIT_PRICE , MERCHANDISE_AMT , DESCR254_MIXED , PRICE_CNTRCT_BASE , PRICE_ADJUSTED , CURRENCY_CD_CNTR , USE_CNTRCT_BASE , BUYER_ID , MFG_ID , MFG_ITM_ID , ITM_ID_VNDR , UPN_ID , UPN_TYPE_CD , TRANSACTION_PRICE , LN_TYPE , PRICE_INITIAL FROM PS_CNTRCT_SRCH_TM1

# 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
6 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
7 CNTRCT_PROC_OPT Character(4) VARCHAR2(4) NOT NULL Contract Process Option
AP=Recurring Voucher
BPO=Release to Single PO Only
DST=Distributor
GN=General Contract
GRPM=Group Multi Supplier
GRPS=Group Single Supplier
MFG=Manufacturer
PADV=Prepaid Voucher w/ Advance PO
PO=Purchase Order
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher
SPP=Special Purpose
8 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
10 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
11 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
12 PCHOUTPRICE_OPTION Character(4) VARCHAR2(4) NOT NULL Punchout Pricing Option
AUCP=Always Use Contract Price
AUPP=Always Use Punchout Price
UPPL=Use Punchout Price if Lower
X=Not Used
13 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
14 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
15 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: %EDITTABLE6

16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
18 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
19 CATEGORY_SETID Character(5) VARCHAR2(5) NOT NULL Category SetID
20 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
21 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
22 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
23 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
24 PRICE_CNTRCT_BASE Number(16,5) DECIMAL(15,5) NOT NULL Contract Base Price
25 PRICE_ADJUSTED Signed Number(17,5) DECIMAL(15,5) NOT NULL Adjusted Price
26 CURRENCY_CD_CNTR Character(3) VARCHAR2(3) NOT NULL Contract Base Currency
27 USE_CNTRCT_BASE Character(1) VARCHAR2(1) NOT NULL Use Contract Base Price
N=No
Y=Yes

Y/N Table Edit

28 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
29 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
30 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
31 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
32 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
33 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
34 TRANSACTION_PRICE Signed Number(28,3) DECIMAL(26,3) NOT NULL The preferred business price for a given deal transaction.
35 LN_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type
CAT=Catalog Item
CUST=Custom Item
DC=Direct Connect Item
DCEX=Exchange Item
DCPO=Punchout Item
DCRT=Round Trip
DCTP=Transparent Punchout Item
DESR=Ad-hoc Item
EF=Express Form Item
OS=Order Sheet
SDF=Supplemental Data Form
SPRO=Service
SR=ePro Special Request Item
SRFC=Fixed Cost Service Item
SRTM=Time and Material Service Item
SRVC=Variable Cost Service Item
36 PRICE_INITIAL Signed Number(17,5) DECIMAL(15,5) NOT NULL Punchout Price