IN_VMI_SHCST_VW

(SQL View)
 Index Back

VMI Ship To Customers - IN

ShipTo Customers that are VMI enabled

SELECT DISTINCT A.SETID , A.CUST_ID , B.NAME1 , A.SELL_CONSIGNED_FLG , A.BUSINESS_UNIT_IN , A.VMI_CUST_FLG , A.VMI_MANAGER , A.REORD_QTY_OPTION , A.STOCKOUT_RATE , A.VMI_REORDER_CHK , A.RANGE_PCT , A.REPL_CALC_PERIOD , A.LOT_CONTROL , A.SERIAL_CONTROL , A.CONTAINER_CONTROL , A.STAGED_DATE_CNTRL , A.DEFAULT_PO FROM PS_CUST_SHIPTO_OPT A , PS_CUSTOMER B WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND B.CUST_STATUS = 'A' AND B.SHIP_TO_FLG = 'Y' AND A.VMI_CUST_FLG = 'Y' AND A.EFFDT = ( SELECT MAX(A_EFF.EFFDT) FROM PS_CUST_SHIPTO_OPT A_EFF WHERE A_EFF.SETID = A.SETID AND A_EFF.CUST_ID = A.CUST_ID ) AND A.EFF_STATUS = 'A'

  • Related Language Record: IN_VMI_SHCT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 SELL_CONSIGNED_FLG Character(1) VARCHAR2(1) NOT NULL Goods Consigned at Customer
    5 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    6 VMI_CUST_FLG Character(1) VARCHAR2(1) NOT NULL VMI Enabled Customer
    7 VMI_MANAGER Character(30) VARCHAR2(30) NOT NULL VMI Manager
    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
    10 VMI_REORDER_CHK Character(1) VARCHAR2(1) NOT NULL Reorder Point Range Checking
    N=No
    U=Use Default
    Y=Yes
    11 RANGE_PCT Number(2,0) SMALLINT NOT NULL Range Checking Percentage
    12 REPL_CALC_PERIOD Number(3,0) SMALLINT NOT NULL Replenish Calc Period (Days)
    13 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    14 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    15 CONTAINER_CONTROL Character(1) VARCHAR2(1) NOT NULL Container Control
    16 STAGED_DATE_CNTRL Character(1) VARCHAR2(1) NOT NULL Staged Date Control
    17 DEFAULT_PO Character(25) VARCHAR2(25) NOT NULL Customer PO Number