SETIDINV_ITEM_IDSHIP_FROM_BUUNIT_OF_MEASUREMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
CDT_AVAIL_VW(SQL View) |
Index Back |
|---|---|
CDT Availability |
| SELECT CONV.SETID , B.INV_ITEM_ID , B.BUSINESS_UNIT , CONV.UNIT_OF_MEASURE , %Round(%DecDiv(B.QTY_ONHAND, CONV.CONVERSION_RATE), 4) , %Round(%DecDiv(B.QTY_RESERVED, CONV.CONVERSION_RATE), 4) FROM PS_SET_CNTRL_REC SC , PS_INV_ITEM_UOM CONV , PS_BU_ITEMS_INV B WHERE SC.SETCNTRLVALUE = B.BUSINESS_UNIT AND SC.RECNAME = 'INV_ITEM_UOM' AND CONV.SETID = SC.SETID AND CONV.INV_ITEM_ID = B.INV_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | SHIP_FROM_BU |
Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 4 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 5 | QTY_ONHAND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity On Hand |
| 6 | QTY_RESERVED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Reserved |