ITM_SCH_GRP_TBL

(SQL Table)
Index Back

Schedule Group Table

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

  • 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 Item

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

    7 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: OPRID_VW2