CS_DOC_CNTL_SVW(SQL View) |
Index Back |
---|---|
PTSF Contract Document LinesContract 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. |