PROCESS_INSTANCEBUSINESS_UNITPrompt Table: SP_BUIN_NONVW
UTILIZ_GROUPCYCL=Cycle Count
Default Value: CYCL
UTILIZ_CDPrompt Table: UTILIZ_TYPE_INV
INV_ITEM_ID1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
UTIL_CALC_TMP(SQL Table) |
Index Back |
|---|---|
Util Type Calculation - Temp |
| # | 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
Prompt Table: SP_BUIN_NONVW |
| 3 | UTILIZ_GROUP |
Character(4) | VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count Default Value: CYCL |
| 4 | UTILIZ_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table: UTILIZ_TYPE_INV |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 8 | INV_STOCK_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Stock Type |
| 9 | SOURCE_CODE | Character(2) | VARCHAR2(2) NOT NULL |
8/5/97 lee - inactivated source code 4 - service
1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning |
| 10 | ONHAND_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | On Hand Quantity |
| 11 | ONHAND_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | On Hand Amount |
| 12 | UNIT_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost |
| 13 | LEAD_TIME_DAYS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Lead Time (Days) |
| 14 | HIST_USAGE_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Historical Usage Quantity |
| 15 | HIST_USAGE_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Hist Usage Amt |
| 16 | HIST_ADJUST_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Hist Adjustment Qty |
| 17 | HIST_ADJUST_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Hist Adjustment Amt |
| 18 | HIST_NUM_TRANS | Number(10,0) | DECIMAL(10) NOT NULL | Hist # of Transactions |
| 19 | QTY_FORECAST | Number(16,4) | DECIMAL(15,4) NOT NULL | 11/01/01 PCL (CN#PL900-1): Added |
| 20 | AMT_FORECAST | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Forecasted Amount |
| 21 | PREV_UTILIZ_CD | Character(4) | VARCHAR2(4) NOT NULL | Previous Utilization Type |