PROCESS_INSTANCEBUSINESS_UNITSETID_INV_ITEMINV_ITEM_IDUNIT_MEASURE_STDUNIT_OF_MEASUREMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
ORDR=Ordering
SHIP=Shipping
STCK=Stocking
IN_ITM_WT_TAO(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | SETID_INV_ITEM |
Character(5) | VARCHAR2(5) NOT NULL | Inv Items SETID |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | UNIT_MEASURE_STD |
Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 6 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 7 | INV_UOM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Inventory UOM Type
ORDR=Ordering SHIP=Shipping STCK=Stocking |
| 8 | UOM_WEIGHT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 9 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |