PO_SWL_CEXP1_VW (SQL View)	Index Back
swl expiring contract view

PO_SWL_CEXP1_VW

(SQL View)

swl expiring contract view

SELECT A.VENDOR_SETID , A.VENDOR_ID , A.SETID , A.CNTRCT_ID , A.VERSION_NBR , A.CNTRCT_STATUS , A.CNTRCT_TYPE , A.CNTRCT_BEGIN_DT , A.CNTRCT_EXPIRE_DT , A.ENTERED_DT , A.CNTRCT_CORP_FLG , A.BUYER_ID , A.CNTRCT_PROC_OPT , A.DESCR , 'N' FROM PS_CNTRCT_HDR A WHERE A.CNTRCT_STATUS = 'A' AND A.VERSION_STATUS = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

5 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

6 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
Default Value: O

7 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
Default Value: GN

8 CNTRCT_BEGIN_DT Date(10) DATE NOT NULL Contract Begin Date
Default Value: %date

9 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date

10 ENTERED_DT Date(10) DATE NOT NULL Entered on
Default Value: %date

11 CNTRCT_CORP_FLG Character(1) VARCHAR2(1) NOT NULL Corporate Contract Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: Y

12 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
Prompt Table: BUYER_ACTIVE_VW

13 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: GN

14 DESCR Character(30) VARCHAR2(30) NOT NULL Description

15 PO_SEL_OPTION Character(1) VARCHAR2(1) NOT NULL Purchasing Select Options
A=Requisitions / Purchase Orders
P=Purchase Orders
R=Requisitions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
5	VERSION_NBR	Number(5,0)	INTEGER NOT NULL	Contract Version number
6	CNTRCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Status A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled Default Value: O
7	CNTRCT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Contract Type AP=Recurring Voucher GN=General Contract MS=Master Contract PO=Purchase Order Default Value: GN
8	CNTRCT_BEGIN_DT	Date(10)	DATE NOT NULL	Contract Begin Date Default Value: %date
9	CNTRCT_EXPIRE_DT	Date(10)	DATE	Expire Date
10	ENTERED_DT	Date(10)	DATE NOT NULL	Entered on Default Value: %date
11	CNTRCT_CORP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Corporate Contract Flag N=No Y=Yes Y/N Table Edit Default Value: Y
12	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_ACTIVE_VW
13	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: GN
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	PO_SEL_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Purchasing Select Options A=Requisitions / Purchase Orders P=Purchase Orders R=Requisitions