CS_CHNG_PUR_VW(SQL View) |
Index Back |
|---|
| SELECT A.CS_DOC_ID , %DateTimeNull , 0 , 0 , 'XX' , C.CHNG_ORD_BATCH , 0 , C.REVISION_DT FROM PS_CS_DOC_HDR A , PS_CS_DOC_PUR_KEYS B , PS_PO_CHNG_ORD C WHERE A.CS_DOC_ID = B.CS_DOC_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PO_ID = C.PO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 3 | CS_VERSION | Number(6,2) | DECIMAL(5,2) NOT NULL | Version |
| 4 | CS_AMENDMENT | Number(3,0) | SMALLINT NOT NULL | Amendment |
| 5 | CS_DOC_ACTION | Character(2) | VARCHAR2(2) NOT NULL | 4/22/08 RMK F-AHAYT-X0ES6 Added action "53" Amendment File Updated 7/08 cel Added 54 Created Executive Summary file |
| 6 | CS_SOURCE_VER | Number(3,0) | SMALLINT NOT NULL | cel 10/19/2007 - will store the associated source version number that this document is build upon. Both PO and Contracts in 9.1 will have a corresponding version. |
| 7 | CS_SOURCE_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 8 | REVISION_DT | Date(10) | DATE | Revision Date |