PV_CP_QUERY(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PV_CP_PARTNER_ID | 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 |