P6_RSRC_ITMGRP

(SQL Table)
Index Back

Material Inventory Item Group

Run Control Record Master/Global Data synchronization for Material Inventory Item Group.

  • Parent record: RUN_CNTL_PGM_P6
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_PC.OPRID

    2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
    3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    4 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

    Default Value: 1

    5 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

    Prompt Table: INV_ITEM_GROUP
    Set Control Field: BUSINESS_UNIT_IN