MOC_PRODITEM_VW(SQL View) |
Index Back |
|---|---|
Product Item View.Mobile Order Capture uses this Level 0 Product Item view to syncronise the Products on to the mobile device. |
| SELECT SETID , PRODUCT_ID , DESCR , PRODUCT_KIT_FLAG , CFG_KIT_FLAG , EFF_STATUS , PROD_CATEGORY , SYNCID , SYNCDTTM FROM PS_PROD_ITEM WHERE EFF_STATUS = 'A' AND PROD_TYPE IN ('PHY', 'PKG') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PRODUCT_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Product Kit Flag
Y/N Table Edit Default Value: N |
| 5 | CFG_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Configured Kit Package
M=Multilevel Bundle Component N=Lightly Configured Y=Schema Enabled Y/N Table Edit Default Value: N |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | PROD_CATEGORY | Character(15) | VARCHAR2(15) NOT NULL |
Product Category
Prompt Table: PROD_CATGRY_TBL |
| 8 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 9 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |