PV_CP_QUERY(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(3,0) | SMALLINT NOT NULL | CUP Partner ID | |
| 2 | PV_CP_TP_NAME | Character(100) | VARCHAR2(100) NOT NULL | CUP Partner Name |
| 3 | PV_CP_CREATE_DATE | Date(10) | DATE | CUP Create Date |
| 4 | PV_CP_CAT_UPDATEID | Number(3,0) | SMALLINT NOT NULL | CUP Catalog Update ID |
| 5 | PV_CP_ITEM_COUNT | Number(6,0) | INTEGER NOT NULL | CUP Item Count |