IN_VMI_ITEMS_VW

(SQL View)
 Index Back

Supplier Managed Items


SELECT BUSINESS_UNIT ,VMI_OM_BU ,SHIP_TO_CUST_ID ,INV_ITEM_ID ,VMI_REPLEN_UOM ,REPLENISH_CLASS ,NO_REPLENISH_FLG ,REORD_QTY_OPTION ,STOCKOUT_RATE ,REPL_CALC_PERIOD ,VMI_REORDER_CHK ,RANGE_PCT ,REORDER_POINT ,QTY_MAXIMUM ,LAST_ANNUAL_DEMAND ,REPLENISH_LEAD ,REORDER_QTY ,EOQ ,SOURCE_BUS_UNIT ,PRODUCT_ID ,UPDATE_STATUS ,SAFETY_STOCK ,DT_TIMESTAMP FROM PS_IN_VMI_ITEMS

# 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 VMI_OM_BU Character(5) VARCHAR2(5) NOT NULL OM Business Unit Related to VMI

Prompt Table: OM_BU_NONVW

3 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: INV_CUST_SHP_VW

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: IN_ITEM_VM_VW

5 VMI_REPLEN_UOM Character(3) VARCHAR2(3) NOT NULL Replenishment UOM

Prompt Table: IN_SHP_UOM_VW1

6 REPLENISH_CLASS Character(4) VARCHAR2(4) NOT NULL Replenish Class

Prompt Table: REPLEN_CLS_INV

7 NO_REPLENISH_FLG Character(1) VARCHAR2(1) NOT NULL Not Included In Replenishment

Y/N Table Edit

Default Value: N

8 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
9 STOCKOUT_RATE Number(4,1) DECIMAL(3,1) NOT NULL Desired Stock-In Probability

Prompt Table: STKOUT_RATE_INV

10 REPL_CALC_PERIOD Number(3,0) SMALLINT NOT NULL Replenish Calc Period (Days)
11 VMI_REORDER_CHK Character(1) VARCHAR2(1) NOT NULL Reorder Point Range Checking
N=No
U=Use Default
Y=Yes

Default Value: U

12 RANGE_PCT Number(2,0) SMALLINT NOT NULL Range Checking Percentage
13 REORDER_POINT Signed Number(17,4) DECIMAL(15,4) NOT NULL Reorder Point
14 QTY_MAXIMUM Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Qty
15 LAST_ANNUAL_DEMAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Last Ann. Demand
16 REPLENISH_LEAD Signed Number(16,2) DECIMAL(14,2) NOT NULL Replenish Lead (Days)
17 REORDER_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Reorder Qty
18 EOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Economic Order Quantity
19 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BUNVM_NONVW

20 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: IN_ITEM_PROD_VW

21 UPDATE_STATUS Character(1) VARCHAR2(1) NOT NULL Update status
22 SAFETY_STOCK Signed Number(17,4) DECIMAL(15,4) NOT NULL Safety Stock
23 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

Default Value: %Datetime