COMPANYDEFAULT_SETIDPCMP_PROD_TYPEPrompt Table: PCMP_PROD_TYPE
PCMP_PRODUCTPrompt Table: PCMP_PRODUCT
PCMP_PRODUCT_VW(SQL View) |
Index Back |
|---|---|
Prof Comp Product viewUsed in the Professional Compliance module. View of available Products for a company. |
| SELECT A.COMPANY ,A.DEFAULT_SETID ,B.PCMP_PROD_TYPE ,B.PCMP_PRODUCT ,B.PCMP_PRODUCT_DESCR FROM PS_COMPANY_TBL A ,PS_PCMP_PRODUCT B WHERE A.DEFAULT_SETID=B.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | DEFAULT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Default Set ID |
| 3 | PCMP_PROD_TYPE |
Character(6) | VARCHAR2(6) NOT NULL |
Used in the Professional ompliance module.
Prodtuct Type category.
Prompt Table: PCMP_PROD_TYPE |
| 4 | PCMP_PRODUCT |
Character(6) | VARCHAR2(6) NOT NULL |
Used in the Professional Compliance module.
Product that a Company sells.
Prompt Table: PCMP_PRODUCT |
| 5 | PCMP_PRODUCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Used in the Professional Compliance module. Product description. |