CS_DOC_CNTL_SVW

(SQL View)
Index Back

PTSF Contract Document Lines

Contract Document Lines view for PTSF

SELECT DISTINCT '0008' ,PO.CS_DOC_ID ,PO.SETID ,PO.CNTRCT_ID ,CNT.CNTRCT_LINE_NBR ,CNT.VERSION_NBR ,CNT.LINE_STATUS ,CNT.ITM_SETID ,CNT.INV_ITEM_ID ,CNT.DESCR254_MIXED ,CNT.CATEGORY_ID ,CNT.MFG_ID ,CNT.MFG_ITM_ID ,CNT.QTY_LINE_MIN ,CNT.QTY_LINE_MAX ,R.QTY_LINE_RELEASED ,CNT.AMT_LINE_MIN ,CNT.AMT_LINE_MAX ,R.AMT_LINE_RELEASED ,%subrec(PUR_USR_LIN_SBR,CNT) ,CNT.OPRID_MODIFIED_BY ,%Coalesce(CNT.LAST_DTTM_UPDATE, %datetimein('1900-01-01-00.00.00.000000')) FROM PS_CS_DOC_PO_KEYS PO ,PS_CS_DOC_HDR H ,PS_CNTRCT_LINE CNT ,PS_CNTRCT_LIN_RLS R WHERE PO.CS_DOC_ID = H.CS_DOC_ID AND PO.SETID = CNT.SETID AND PO.CNTRCT_ID = CNT.CNTRCT_ID AND PO.VERSION_NBR = CNT.VERSION_NBR AND R.SETID = CNT.SETID AND R.CNTRCT_ID = CNT.CNTRCT_ID AND R.CNTRCT_LINE_NBR = CNT.CNTRCT_LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0009=Contract Agreement
0010=Bid Factor
0011=Contract
0012=Sourcing Event
0013=Question Group
0014=Document Type
0015=Word Template
0016=Document Format and Options
2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
5 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

Default Value: 1

6 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
7 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
A=Active
C=Cancelled
I=Inactive
O=Open
P=Pending

Default Value: O

8 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE13

10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
12 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

13 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: %EDIT_MFGITM_ID

14 QTY_LINE_MIN Number(15,2) DECIMAL(14,2) NOT NULL Min Line Qty Per Order
15 QTY_LINE_MAX Number(15,2) DECIMAL(14,2) NOT NULL Max Line Qty Per Contract
16 QTY_LINE_RELEASED Number(15,2) DECIMAL(14,2) NOT NULL Total Line Qty Released
17 AMT_LINE_MIN Number(27,3) DECIMAL(26,3) NOT NULL Min Line Amt Per Order
18 AMT_LINE_MAX Number(27,3) DECIMAL(26,3) NOT NULL Max Line Amt Per Contract
19 AMT_LINE_RELEASED Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Amt Released
20 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
21 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
22 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
23 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
24 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
25 CUSTOM_DATE_B Date(10) DATE Custom Date
26 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
27 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
28 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.