IN_VMI_SHCT_LVW

(SQL View)
 Index Back

Rel Lang Vw of IN_VMI_SHCST_VW

ShipTo Customers that are VMI enabled

SELECT DISTINCT A.SETID , A.CUST_ID , B.NAME1 , L.LANGUAGE_CD , A.SELL_CONSIGNED_FLG , A.BUSINESS_UNIT_IN , A.VMI_CUST_FLG , A.VMI_MANAGER , A.VMI_REORDER_CHK , 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 , PS_CUSTOMER_LANG L WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND A.SETID = L.SETID AND A.CUST_ID = L.CUST_ID AND B.CUST_STATUS = 'A' AND B.SHIP_TO_FLG = 'Y' AND A.VMI_CUST_FLG = 'Y'

  • Related Language Record for IN_VMI_SHCST_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SELL_CONSIGNED_FLG Character(1) VARCHAR2(1) NOT NULL Goods Consigned at Customer
    6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    7 VMI_CUST_FLG Character(1) VARCHAR2(1) NOT NULL VMI Enabled Customer
    8 VMI_MANAGER Character(30) VARCHAR2(30) NOT NULL VMI Manager
    9 VMI_REORDER_CHK Character(1) VARCHAR2(1) NOT NULL Reorder Point Range Checking
    N=No
    U=Use Default
    Y=Yes
    10 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    11 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    12 CONTAINER_CONTROL Character(1) VARCHAR2(1) NOT NULL Container Control
    13 STAGED_DATE_CNTRL Character(1) VARCHAR2(1) NOT NULL Staged Date Control
    14 DEFAULT_PO Character(25) VARCHAR2(25) NOT NULL Customer PO Number