IN_VMI_RPLN_SVW(SQL View) |
Index Back |
|---|---|
VMI Replenishment Setup Search07/20/04 - LLR Search record for the VMI Business Unit replenishment setup records. |
| SELECT A.BUSINESS_UNIT , A.REORD_QTY_OPTION , A.ORDER_PREP_COST , A.CARRYING_RATE , A.RANGE_PCT , A.STOCKOUT_RATE , A.REPL_CALC_PERIOD FROM PS_REPL_SETUP_INV A ,PS_BUS_UNIT_TBL_IN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.VMI_UNIT_FLG = 'Y' |
| # | 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_BUVM_NONVW |
| 2 | REORD_QTY_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Reorder Point Order Quantities
1=EOQ 2=Min/Max 3=AOQ 4=Static Reorder Qty 5=Demand Quantity 99=Use Business Unit Default Default Value: 4 |
| 3 | ORDER_PREP_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Avg Order Prep Cost (Base Cur) |
| 4 | CARRYING_RATE | Number(4,3) | DECIMAL(3,3) NOT NULL | Inventory Carrying Rate |
| 5 | RANGE_PCT | Number(2,0) | SMALLINT NOT NULL | Range Checking Percentage |
| 6 | STOCKOUT_RATE | Number(4,1) | DECIMAL(3,1) NOT NULL |
Desired Stock-In Probability
Default Value: 95 Prompt Table: STKOUT_RATE_INV |
| 7 | REPL_CALC_PERIOD | Number(3,0) | SMALLINT NOT NULL |
Replenish Calc Period (Days)
Default Value: 365 |