AUC_CNTRCT_VW2

(SQL View)
 Index Back

Auctions Contract View


SELECT A.SETID , A.CNTRCT_PROC_OPT , A.CNTRCT_ID , A.VENDOR_ID , A.CNTRCT_TYPE , A.DESCR , A.CNTRCT_STATUS FROM PS_CNTRCT_HDR A WHERE A.CNTRCT_STATUS IN ('A','C','O')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: AUC_COPY_WRK.CNTRCT_SETID

2 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

Default Value: AUC_COPY_WRK.CNTRCT_PROC_OPT

3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled