CS_CNT_DOC_VW(SQL View) |
Index Back |
|---|---|
Contract Document Mappingsview that joins po contract with doc managmenet used in source transactions. |
| SELECT B.SETID , B.CNTRCT_ID , B.VERSION_NBR , A.CS_DOC_ID , A.DESCR60 , A.CS_DOC_STATUS , A.CS_DOC_OWNER , A.CS_SPONSOR , A.DEPTID , A.CS_VERSION , A.CS_AMENDMENT , A.CS_SOURCE_TRANS , %subrec(CS_USER_FLD_SBR,A) , A.CNTRCT_STYLE , CASE WHEN A.CNTRCT_STYLE = ' ' THEN ' ' ELSE ( SELECT S.CNTRCT_STYLE_NAME FROM PS_CNTRCT_STYLE S WHERE A.CNTRCT_STYLE = S.CNTRCT_STYLE) END FROM PS_CS_DOC_HDR A , PS_CS_DOC_PO_KEYS B WHERE A.CS_DOC_ID = B.CS_DOC_ID |
| # | 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 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 4 | CS_DOC_ID | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | 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 |
| 7 | CS_DOC_OWNER | Character(30) | VARCHAR2(30) NOT NULL |
Document Administrator
Prompt Table: PSOPRDEFN_VW |
| 8 | CS_SPONSOR | Character(30) | VARCHAR2(30) NOT NULL |
Sponsor
Prompt Table: PSOPRDEFN_VW |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: CS_DEPTID_VW |
| 10 | CS_VERSION | Number(6,2) | DECIMAL(5,2) NOT NULL | Version |
| 11 | CS_AMENDMENT | Number(3,0) | SMALLINT NOT NULL | Amendment |
| 12 | CS_SOURCE_TRANS | Character(2) | VARCHAR2(2) NOT NULL |
Source Transaction
03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction
01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
01=Ad Hoc 02=Purchasing Contracts 03=Purchase Orders 04=Sourcing Events 97=All Sources 98=Multiple Sources 99=Not Transactional |
| 13 | CS_CHAR_USER1 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 1 |
| 14 | CS_CHAR_USER2 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 2 |
| 15 | CS_CHAR_USER3 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 3 |
| 16 | CS_CHAR_USER4 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 4 |
| 17 | CS_CHAR_USER5 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 5 |
| 18 | CS_CHAR_USER6 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 6 |
| 19 | CS_CHAR_USER7 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 7 |
| 20 | CS_CHAR_USER8 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 8 |
| 21 | CS_CHAR_USER9 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 9 |
| 22 | CS_CHAR_USER10 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 10 |
| 23 | CS_CHAR_USER11 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 11 |
| 24 | CS_CHAR_USER12 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 12 |
| 25 | CS_CHAR_USER13 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 13 |
| 26 | CS_CHAR_USER14 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 14 |
| 27 | CS_CHAR_USER15 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 15 |
| 28 | CS_CHAR_USER16 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 16 |
| 29 | CS_CHAR_USER17 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 17 |
| 30 | CS_CHAR_USER18 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 18 |
| 31 | CS_CHAR_USER19 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 19 |
| 32 | CS_CHAR_USER20 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 20 |
| 33 | CS_CHAR_USER21 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 21 |
| 34 | CS_CHAR_USER22 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 22 |
| 35 | CS_CHAR_USER23 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 23 |
| 36 | CS_CHAR_USER24 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 24 |
| 37 | CS_CHAR_USER25 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 25 |
| 38 | CS_CHAR_USER26 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 26 |
| 39 | CS_CHAR_USER27 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 27 |
| 40 | CS_CHAR_USER28 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 28 |
| 41 | CS_CHAR_USER29 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 29 |
| 42 | CS_CHAR_USER30 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 30 |
| 43 | CS_CHAR_USER31 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 31 |
| 44 | CS_CHAR_USER32 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 32 |
| 45 | CS_CHAR_USER33 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 33 |
| 46 | CS_CHAR_USER34 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 34 |
| 47 | CS_CHAR_USER35 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 35 |
| 48 | CS_CHAR_USER36 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 36 |
| 49 | CS_CHAR_USER37 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 37 |
| 50 | CS_CHAR_USER38 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 38 |
| 51 | CS_DATE_USER1 | Date(10) | DATE | Date User Field 1 |
| 52 | CS_DATE_USER2 | Date(10) | DATE | Date User Field 2 |
| 53 | CS_DATE_USER3 | Date(10) | DATE | Date User Field 3 |
| 54 | CS_DATE_USER4 | Date(10) | DATE | Date User Field 4 |
| 55 | CS_DATE_USER5 | Date(10) | DATE | Date User Field 5 |
| 56 | CS_DATE_USER6 | Date(10) | DATE | Date User Field 6 |
| 57 | CS_DATE_USER7 | Date(10) | DATE | Date User Field 7 |
| 58 | CS_DATE_USER8 | Date(10) | DATE | Date User Field 8 |
| 59 | CS_DATE_USER9 | Date(10) | DATE | Date User Field 9 |
| 60 | CS_DATE_USER10 | Date(10) | DATE | Date User Field 10 |
| 61 | CS_DATE_USER11 | Date(10) | DATE | Date User Field 11 |
| 62 | CS_DATE_USER12 | Date(10) | DATE | Date User Field 12 |
| 63 | CS_DATE_USER13 | Date(10) | DATE | Date User Field 13 |
| 64 | CS_DATE_USER14 | Date(10) | DATE | Date User Field 14 |
| 65 | CS_DATE_USER15 | Date(10) | DATE | Date User Field 15 |
| 66 | CS_DEC_USER1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 1 (23.3) |
| 67 | CS_DEC_USER2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 2 (23.3) |
| 68 | CS_DEC_USER3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 3 (23.3) |
| 69 | CS_DEC_USER4 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 4 (11.4) |
| 70 | CS_DEC_USER5 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field5 (11.4) |
| 71 | CS_DEC_USER6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 6 (23.3) |
| 72 | CS_DEC_USER7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 7 (23.3) |
| 73 | CS_DEC_USER8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 8 (23.3) |
| 74 | CS_DEC_USER9 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 9 (23.3) |
| 75 | CS_DEC_USER10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 10 (23.3) |
| 76 | CS_DEC_USER11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 11 (23.3) |
| 77 | CS_DEC_USER12 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 12 (11.4) |
| 78 | CS_DEC_USER13 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 13 (11.4) |
| 79 | CS_DEC_USER14 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 14 (11.4) |
| 80 | CS_DEC_USER15 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 15 (11.4) |
| 81 | CS_INT_USER1 | Number(8,0) | INTEGER NOT NULL | Integer User Field 1 |
| 82 | CS_INT_USER2 | Number(8,0) | INTEGER NOT NULL | Integer User Field 2 |
| 83 | CS_INT_USER3 | Number(8,0) | INTEGER NOT NULL | Integer User Field 3 |
| 84 | CS_INT_USER4 | Number(8,0) | INTEGER NOT NULL | Integer User Field 4 |
| 85 | CS_INT_USER5 | Number(8,0) | INTEGER NOT NULL | Integer User Field 5 |
| 86 | CS_INT_USER6 | Number(8,0) | INTEGER NOT NULL | Integer User Field 6 |
| 87 | CS_INT_USER7 | Number(8,0) | INTEGER NOT NULL | Integer User Field 7 |
| 88 | CS_INT_USER8 | Number(8,0) | INTEGER NOT NULL | Integer User Field 8 |
| 89 | CS_INT_USER9 | Number(8,0) | INTEGER NOT NULL | Integer User Field 9 |
| 90 | CS_INT_USER10 | Number(8,0) | INTEGER NOT NULL | Integer User Field 10 |
| 91 | CS_INT_USER11 | Number(8,0) | INTEGER NOT NULL | Integer User Field 11 |
| 92 | CS_INT_USER12 | Number(8,0) | INTEGER NOT NULL | Integer User Field 12 |
| 93 | CS_INT_USER13 | Number(8,0) | INTEGER NOT NULL | Integer User Field 13 |
| 94 | CS_INT_USER14 | Number(8,0) | INTEGER NOT NULL | Integer User Field 14 |
| 95 | CS_INT_USER15 | Number(8,0) | INTEGER NOT NULL | Integer User Field 15 |
| 96 | CS_INT_USER16 | Number(8,0) | INTEGER NOT NULL | Integer User Field 16 |
| 97 | CS_INT_USER17 | Number(8,0) | INTEGER NOT NULL | Integer User Field 17 |
| 98 | CS_INT_USER18 | Number(8,0) | INTEGER NOT NULL | Integer User Field 18 |
| 99 | CS_INT_USER19 | Number(8,0) | INTEGER NOT NULL | Integer User Field 19 |
| 100 | CS_INT_USER20 | Number(8,0) | INTEGER NOT NULL | Integer User Field 20 |
| 101 | CS_INT_USER21 | Number(8,0) | INTEGER NOT NULL | Integer User Field 21 |
| 102 | CS_INT_USER22 | Number(8,0) | INTEGER NOT NULL | Integer User Field 22 |
| 103 | CS_INT_USER23 | Number(8,0) | INTEGER NOT NULL | Integer User Field 23 |
| 104 | CS_INT_USER24 | Number(8,0) | INTEGER NOT NULL | Integer User Field 24 |
| 105 | CNTRCT_STYLE | Character(10) | VARCHAR2(10) NOT NULL | Contract Style |
| 106 | CNTRCT_STYLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Style Description |