PROCESS_INSTANCEA=Approve MarketSite Item
P=Pending Approval
Y/N Table Edit
Default Value: N
01=User Defined
02=UN/SPSC
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
PV_CM_CAT_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 5 | PV_CO_SCHEMA_NAME | Character(128) | VARCHAR2(128) NOT NULL | Cohera Catalog Name |
| 6 | PV_CP_APPROVE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Build as Approved
A=Approve MarketSite Item P=Pending Approval |
| 7 | FROMPHRASE | Character(254) | VARCHAR2(254) NOT NULL | From Phrase |
| 8 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 9 | PV_CO_CWB_CAT_HIER | Character(128) | VARCHAR2(128) NOT NULL | CWB_CATEGORY_HIERARCHY |
| 10 | PV_CO_CWB_CAT | Character(128) | VARCHAR2(128) NOT NULL | CWB_CATEGORIES Table Name |
| 11 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 12 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 13 | PV_DBLINK_NAME | Character(60) | VARCHAR2(60) NOT NULL | Database Link Name |
| 14 | PV_CO_DB_NAME | Character(50) | VARCHAR2(50) NOT NULL | Cohera Database Name |
| 15 | PV_SERVER_SW | Character(1) | VARCHAR2(1) NOT NULL |
Same Server?
Y/N Table Edit Default Value: N |
| 16 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 17 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |
| 18 | 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. |
| 19 | PV_CO_ACTION_TIME | DateTime(26) | TIMESTAMP | Cohera PS Action Time |
| 20 | PV_CO_BY_DATE | Character(1) | VARCHAR2(1) NOT NULL | Process by date/time |
| 21 | PV_CO_BY_PROD | Character(1) | VARCHAR2(1) NOT NULL | Import Product Categories only |
| 22 | MARKETCODE | Character(2) | VARCHAR2(2) NOT NULL |
This field is added to help the following data entry programs to determine how to handle different coding schemes for CATEGORY_CD:
- Item Categories (Component)
- PV_CP_LOAD (App. Engine)
- IN_ITMLOAD (App. Engine)
Since release 8, CATEGORY_TYPE was added to allow multiple coding schemes for CATEGORY_CD. The limitation imposed upon by how it was implemented is that although multiple coding schemes can be maintained separately but only one coding schemes can be used based on INSTALLATION_PO.CATEGORY_TYPE.
01=User Defined 02=UN/SPSC |
| 23 | PV_CO_SEG1 | Character(2) | VARCHAR2(2) NOT NULL | UN/SPSC Segment From |
| 24 | PV_CO_SEG2 | Character(2) | VARCHAR2(2) NOT NULL | UN/SPSC Segment To |
| 25 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 26 | PV_CM_EXTERNAL | Character(1) | VARCHAR2(1) NOT NULL | Catalog Managment Exists |
| 27 | PV_CM_CATALOG_ID | Character(32) | VARCHAR2(32) NOT NULL | Catalog ID |
| 28 | PV_CM_CAT_HIER_ID | Character(32) | VARCHAR2(32) NOT NULL | Category Hierarchy ID |
| 29 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 30 | PV_CM_LAST_DTTM | DateTime(26) | TIMESTAMP | Catalog Managements Last Dttm |
| 31 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 32 | PV_CM_HIER_ID_NODE | Character(1) | VARCHAR2(1) NOT NULL |
Add Hierarchy ID as Node
Y/N Table Edit Default Value: Y |