ITM_GRP_UOM_VW

(SQL View)
 Index Back

Schedule Group with UOM key

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

SELECT SETID , UNIT_MEASURE_STD , SCHED_GROUP_CD , DESCR , SCHED_FLAG , VMI_FLAG FROM PS_ITM_SCH_GRP_TBL

  • Related Language Record: ITM_GRP_UOM_LVW

    • # 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 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

    Prompt Table: UNITS_TBL

    3 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
    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