ITM_GRP_WSCH_VW

(SQL View)
 Index Back

Group with schedule flag on

05/22/02 SCC CN#WV900-1.0: Supplier Collaboration

SELECT SETID , SCHED_GROUP_CD , UNIT_MEASURE_STD , DESCR , SCHED_FLAG , VMI_FLAG FROM PS_ITM_SCH_GRP_TBL WHERE SCHED_FLAG = 'Y'

  • Related Language Record: ITM_SCH_GRP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
    3 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

    Prompt Table: UNITS_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SCHED_FLAG Character(1) VARCHAR2(1) NOT NULL Schedule Flag

    Y/N Table Edit

    Default Value: Y

    6 VMI_FLAG Character(1) VARCHAR2(1) NOT NULL VMI Item

    Y/N Table Edit

    Default Value: N