RUN_IN_ITMCH_HD

(SQL Table)
 Index Back

Item Change Header record

Item Change Process - Header record

  • Parent Record Of IN_ITM_RECD_LST IN_ITM_SRCH_LST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    4 TEMPLATE_LIST_ID Character(20) VARCHAR2(20) NOT NULL Change List ID

    Prompt Table: IN_ITM_PRMT_DVW

    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 ITM_SELECTION Character(4) VARCHAR2(4) NOT NULL 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template.Contains translate value for Item Selection for Search Criteria Page in Item Template.
    A=All Items
    R=Range of Items
    S=Specific Item

    Default Value: A

    7 FROM_ITEMID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID

    Prompt Table: MASTER_ITEM_VW

    8 TO_ITEMID Character(18) VARCHAR2(18) NOT NULL To Item ID

    Prompt Table: MASTER_ITEM_VW

    9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    10 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    11 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

    Prompt Table: INV_ITEM_GROUP

    12 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

    Prompt Table: INV_ITEM_FAM

    13 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

    Prompt Table: ITM_CAT_VW

    14 IN_ITM_RPT_OPTN Character(1) VARCHAR2(1) NOT NULL Report Option
    E=Error Report
    F=Full Report
    N=No Report

    Default Value: E

    15 ALLOW_MODIFY Character(1) VARCHAR2(1) NOT NULL Allow Modify Comments
    16 AE_WHERE_LONG1 Long Character(1300) VARCHAR2(1300) AE Where Clause Long String.