PROD_INVITM2_VW(SQL View) |
Index Back |
|---|---|
Prod Item used by backgroundUsed for price by key field names for sales order background pricing |
| SELECT P.SETID , P.PRODUCT_ID , P.INV_ITEM_ID , I.COMMODITY_CD , M.INVENTORY_ITEM FROM PS_PROD_ITEM P , PS_INV_ITEMS I , PS_MASTER_ITEM_TBL M WHERE P.SETID = I.SETID AND I.SETID = M.SETID AND P.INV_ITEM_ID = I.INV_ITEM_ID AND I.INV_ITEM_ID = M.INV_ITEM_ID AND %EffdtCheck(INV_ITEMS I2, I, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
| 5 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes Y/N Table Edit Default Value: Y |