REPL_SETUP_INV

(SQL Table)
Index Back

Replenishment Setup

2004-07- JBA - Changed BU prompt to SP_BUNVM_NONVW to filter out VMI BUs.

# 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_BUNVM_NONVW

2 ROP_REPLENISH Character(1) VARCHAR2(1) NOT NULL Reorder Point Replenishment

Y/N Table Edit

Default Value: Y

3 FIXED_LOC_REPLEN Character(1) VARCHAR2(1) NOT NULL Fixed Bin Replenishment

Y/N Table Edit

Default Value: N

4 ORDER_PREP_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Avg Order Prep Cost (Base Cur)
5 CARRYING_RATE Number(4,3) DECIMAL(3,3) NOT NULL Inventory Carrying Rate
6 CARRY_RATE_PANEL Number(4,1) DECIMAL(3,1) NOT NULL Inventory Carrying Rate
7 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
8 CALC_DMD Character(1) VARCHAR2(1) NOT NULL Calculate Using Demand

Y/N Table Edit

9 INCL_OPN_DMD Character(1) VARCHAR2(1) NOT NULL Include Open Demand

Y/N Table Edit

10 STOCKOUT_RATE Number(4,1) DECIMAL(3,1) NOT NULL Desired Stock-In Probability

Prompt Table: STKOUT_RATE_INV

11 SHIP_DAYS_MONTH Number(2,0) SMALLINT NOT NULL Ship Days/Month
12 SHIP_DAYS_CONVERT Number(6,3) DECIMAL(5,3) NOT NULL Convert Factor
13 REPL_CALC_PERIOD Number(3,0) SMALLINT NOT NULL Replenish Calc Period (Days)
14 VENDOR_RANGE_PCT Number(4,2) DECIMAL(3,2) NOT NULL Range Checking Pct

Default Value: 1

15 VENDOR_RANGE_CHECK Character(1) VARCHAR2(1) NOT NULL Reorder Point Range Checking
N=No
Y=Yes

Default Value: N

16 RANGE_PCT Number(2,0) SMALLINT NOT NULL Range Checking Percentage
17 INCL_REQ_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Include Requisition Quantities

Y/N Table Edit

Default Value: Y

18 CANCEL_METHOD Character(1) VARCHAR2(1) NOT NULL Cancel Method
C=Cancel
D=Delete

Default Value: D

19 INCL_WIP_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Include WIP Quantity

Y/N Table Edit

Default Value: N