PV_CP_ITEMS_AET(SQL Table) |
Index Back |
|---|---|
PV_CP_ITM_LD State RecordPV_CP_ITM_LD State Record |
| # | 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_CP_APPROVE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Build as Approved
A=Approve MarketSite Item P=Pending Approval |
| 6 | PV_CP_LOAD_FLG | Character(1) | VARCHAR2(1) NOT NULL | Run Item Load Process |
| 7 | PV_CP_INBD_FLG | Character(1) | VARCHAR2(1) NOT NULL | Run Inbound Items Process |
| 8 | PV_CP_IMAGE_LOC | Character(40) | VARCHAR2(40) NOT NULL | Item Image Sub Folder |
| 9 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 10 | PV_CO_SCHEMA_NAME | Character(128) | VARCHAR2(128) NOT NULL | Cohera Catalog Name |
| 11 | PV_MS_SUP_MPID | Character(50) | VARCHAR2(50) NOT NULL | e |
| 12 | 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 |
| 13 | PRICE_CHANGE | Character(1) | VARCHAR2(1) NOT NULL |
Update Standard Price
Y/N Table Edit Default Value: N |
| 14 | BU_UPD_PRICE | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Update Price
Y/N Table Edit Default Value: N |
| 15 | ORIG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Original Process Instance |
| 16 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |
| 17 | PV_CAT_DEST_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Destination for the Catalog Items being loaded e.g. Master Items
1=Master 2=Express Default Value: 1 |
| 18 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 19 | BASE_LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 20 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 21 | PV_CP_INDEX | Character(1) | VARCHAR2(1) NOT NULL | Add Items to Search Index |
| 22 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |
| 23 | PV_MS_DOC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Input Source Type
1=CUP File (Access Database) 2=xCBL 3.0 XML File 3=Cohera 4=Catalog Management 5=Express Catalog 6=Item PriceList |
| 24 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 25 | PV_NONDYNAMICRANGE | Character(1) | VARCHAR2(1) NOT NULL | Non Dynamic Range |
| 26 | PV_OVERWRTE_CAT | Character(1) | VARCHAR2(1) NOT NULL | Overwrite Existing Categories |
| 27 | PV_CM_CATALOG_ID | Character(32) | VARCHAR2(32) NOT NULL | Catalog ID |