INV_UOM_TYPEORDR=Ordering
SHIP=Shipping
STCK=Stocking
UOM_TYPE_INV_VW(SQL View) |
Index Back |
|---|---|
Inventory UOM Type View |
| SELECT A.FIELDVALUE FROM PSXLATITEM A WHERE A.FIELDNAME = 'INV_UOM_TYPE' AND %EffdtCheck(PSXLATITEM C, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INV_UOM_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Inventory UOM Type
ORDR=Ordering SHIP=Shipping STCK=Stocking |