PV_CO_UPDT_TYPE1=Supplier Products
2=Item Categories
3=Category Hierarchy
PV_CM_CATALOG_IDPV_CM_CAT_HIER_IDPV_MS_SUP_MPID1=Complete
2=Staged
3=In Process
PV_CM_LAST_UPDT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PV_CO_UPDT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Cohera Update Type
1=Supplier Products 2=Item Categories 3=Category Hierarchy |
| 2 | PV_CM_CATALOG_ID |
Character(32) | VARCHAR2(32) NOT NULL | Catalog ID |
| 3 | PV_CM_CAT_HIER_ID |
Character(32) | VARCHAR2(32) NOT NULL | Category Hierarchy ID |
| 4 | PV_MS_SUP_MPID |
Character(50) | VARCHAR2(50) NOT NULL | e |
| 5 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 6 | PV_CO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cohera Processing Status
1=Complete 2=Staged 3=In Process |