CS_POCOPY_VW

(SQL View)
 Index Back

Contract Search for PO's


SELECT B.SETID , B.CNTRCT_ID , H.BUYER_ID , H.CNTRCT_BEGIN_DT , H.CNTRCT_EXPIRE_DT , H.CNTRCT_PROC_OPT , H.CNTRCT_STATUS , A.CS_DOC_ID , A.CS_DOC_OWNER , A.CS_DOC_STATUS , A.CS_DOCUMENT_TYPE , A.CS_SETID , A.CS_SPONSOR , A.DEPTID , H.DESCR , A.DESCR60 , H.MSTR_CNTRCT_ID , H.VENDOR_ID , V.VENDOR_NAME_SHORT , A.CS_TEMPLATE_ID , F.CS_FILE_FORMAT , F.CS_RELXD_CHKIN , F.SCM_ATTACH_ID , F.ATT_VERSION FROM PS_CS_DOC_HDR A , PS_CS_DOC_PO_KEYS B , PS_CNTRCT_HDR H , PS_VENDOR V , PS_CS_DOC_FILES F WHERE A.CS_SOURCE_TRANS = '02' AND A.CS_IMPORT_CODE = '1' AND A.CS_DOC_BLD_STATUS = '1' AND B.CS_DOC_ID = A.CS_DOC_ID AND H.SETID = B.SETID AND H.CNTRCT_ID = B.CNTRCT_ID AND H.VERSION_NBR = B.VERSION_NBR AND V.SETID = H.VENDOR_SETID AND V.VENDOR_ID = H.VENDOR_ID AND F.CS_DOC_ID = A.CS_DOC_ID AND F.CS_DOC_TYPE = '001'

# 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 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
4 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
5 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
6 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
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
8 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
9 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator
10 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review
11 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
12 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
13 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor
14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
16 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
17 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID
18 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
19 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
20 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
21 CS_FILE_FORMAT Character(1) VARCHAR2(1) NOT NULL Created in 9.2 to indicate xml version - word xml vs. open
0=Imported or Signature Document
1=Word 2003 XML
2=Word Open XML
22 CS_RELXD_CHKIN Character(1) VARCHAR2(1) NOT NULL Relaxed CheckIn Used
23 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
24 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.