SETIDBUSINESS_UNITPrompt Table: SP_BU_FS_NONVW
CM_BOOKINV_ITEM_IDA=Active
I=Inactive
CM_ADD_PERR_VW(SQL View) |
Index Back |
|---|---|
Item Master Average Cst View11/02 mxs This view retrieves only retroactive average costed items. Used on Average Cost Adjustment panel (record cm_cost_adjrwrk). Created for release 8.8 . |
| SELECT B.SETID , F.BUSINESS_UNIT , F.CM_BOOK , F.INV_ITEM_ID , B.DESCR , B.UNIT_MEASURE_STD , A.QTY_OWNED , A.ITM_STATUS_CURRENT , E.BASE_CURRENCY FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , PS_BUS_UNIT_TBL_IN E , PS_CM_ITEM_METH_VW F WHERE A.ITM_STATUS_CURRENT IN ('1','2','3') AND A.INV_ITEM_ID = B.INV_ITEM_ID AND C.RECNAME = 'MASTER_ITEM_TBL' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.SETID = C.SETID AND F.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND F.INV_ITEM_ID= A.INV_ITEM_ID AND F.CM_METHOD ='9' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 3 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 7 | QTY_OWNED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Owned |
| 8 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |