SETIDPrompt Table: SP_SETID_NONVW
INV_ITEM_IDPrompt Table: MST_ITM_PRP4_VW
CATEGORY_CDPrompt Table: ITM_CAT_VW
Y/N Table Edit
Default Value: N
MASTER_CAT_EVW(SQL View) |
Index Back |
|---|---|
Master Item Category |
| SELECT A.SETID , M.INV_ITEM_ID , B.CATEGORY_CD , A.PV_PREFERRED_CAT FROM PS_PV_ITM_CATEGORY A , PS_ITM_CAT_TBL B , PS_INSTALLATION_PO I , PS_MASTER_ITEM_TBL M WHERE B.SETID = A.SETID AND B.SETID = M.SETID AND A.INV_ITEM_ID = M.INV_ITEM_ID AND B.CATEGORY_TYPE = I.CATEGORY_TYPE AND B.CATEGORY_ID = A.CATEGORY_ID AND B.CATEGORY_ID = M.CATEGORY_ID AND %EffdtCheck(ITM_CAT_TBL C, B, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MST_ITM_PRP4_VW |
| 3 | CATEGORY_CD |
Character(18) | VARCHAR2(18) NOT NULL |
Category Code
Prompt Table: ITM_CAT_VW |
| 4 | PV_PREFERRED_CAT | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Catalog
Y/N Table Edit Default Value: N |