MOC_PROD_GRP_VW(SQL View) |
Index Back |
|---|---|
View for Product groupMobile Order Capture uses this Level 1 view to join the Product group with Product ID and setid. |
| SELECT A.SETID , A.PRODUCT_ID , A.PRODUCT_GROUP , A.PROD_GRP_TYPE , B.DESCR , A.SYNCID , A.SYNCDTTM FROM PS_PROD_PGRP_LNK A , PS_PROD_GROUP_TBL B WHERE A.SETID = B.SETID AND A.PROD_GRP_TYPE = B.PROD_GRP_TYPE AND A.PRODUCT_GROUP = B.PRODUCT_GROUP |
| # | 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.
Prompt Table: SP_SETID_NONVW |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM |
| 3 | PRODUCT_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
PRoduct Group
Prompt Table: %EDITTABLE |
| 4 | PROD_GRP_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Product Group Type
ACCT=Accounting CTLG=Product Catalogs CUST=Customer Target CZ=Configurator FCST=Forecast FRT=Freight GEN=General LIT=Literature ORG=Organization PLIN=Product Line PRC=Pricing REPE=Reporting Externally REPI=Reporting Internally RPT=Reporting SCON=Buying Agreement SSP=Self-Service Products TAX=Tax TRPT=Transportations VAT=VAT WEB=WEB Order Entry Default Value: GEN |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | 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. |
| 7 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |