BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
UTILIZ_GROUPCYCL=Cycle Count
Default Value: CYCL
UTILIZ_CDPrompt Table: UTILIZ_TYPE_INV
UTIL_RULES_TMP(SQL Table) |
Index Back |
|---|---|
Util Type Rules Temp Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | UTILIZ_GROUP |
Character(4) | VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count Default Value: CYCL |
| 3 | UTILIZ_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table: UTILIZ_TYPE_INV |
| 4 | ONHAND_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | On Hand Quantity |
| 5 | ONHAND_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | On Hand Amount |
| 6 | UNIT_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost |
| 7 | LEAD_TIME_DAYS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Lead Time (Days) |
| 8 | HIST_USAGE_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Historical Usage Quantity |
| 9 | HIST_USAGE_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Hist Usage Amt |
| 10 | HIST_ADJUST_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Hist Adjustment Qty |
| 11 | HIST_ADJUST_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Hist Adjustment Amt |
| 12 | HIST_NUM_TRANS | Number(10,0) | DECIMAL(10) NOT NULL | Hist # of Transactions |
| 13 | QTY_FORECAST | Number(16,4) | DECIMAL(15,4) NOT NULL | 11/01/01 PCL (CN#PL900-1): Added |
| 14 | AMT_FORECAST | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Forecasted Amount |
| 15 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |