CS_DOC_IDCS_DOC_ALLKEYVW(SQL View) |
Index Back |
|---|---|
Document keys for all source10/15/2008 RMK Document keys (cs_doc_id) for all source transactions - purchasing contract, purchase order, and ad hoc |
| SELECT cs_doc_id , business_unit , po_id FROM ps_cs_doc_pur_keys UNION SELECT cs_doc_id , setid , cntrct_id FROM PS_CS_DOC_PO_KEYS UNION SELECT cs_doc_id , setid , cs_adhoc_id FROM ps_cs_doc_adh_keys |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CS_CONTENT_ID | Character(30) | VARCHAR2(30) NOT NULL | Content ID |