GPMX_NRP_ELM_VW

(SQL View)
 Index Back

Element Mapping Detail

No Packaging Rule Element Mapping View

SELECT COUNTRY , GPMX_KEY_TYPE ,GPMX_KEY_NAME ,GPMX_MAP_TYPE ,GPMX_MAP_FROM , ENTRY_TYPE_ID , PIN_ELEM_NUM + 50000000 FROM PS_GPMX_ELEM_MAP_D

  • Parent record: GPMX_ELEM_MAP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    2 GPMX_KEY_TYPE Character(1) VARCHAR2(1) NOT NULL Define the Key Type for Element Mapping (Record or Component)
    C=Component
    R=Record
    3 GPMX_KEY_NAME Character(18) VARCHAR2(18) NOT NULL Element Mapping Name

    Prompt Table: %RECNAME_EDIT

    4 GPMX_MAP_TYPE Character(1) VARCHAR2(1) NOT NULL Mapping Type
    F=Field
    O=Other
    5 GPMX_MAP_FROM Character(18) VARCHAR2(18) NOT NULL Element that is going to be mapped (Field or Variable)

    Prompt Table: %RECNAME_EDIT
    Set Control Field: GPMX_KEY_NAME

    6 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

    Prompt Table: %RECNAME_EDIT2

    7 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number

    Prompt Table: %GP_EDIT_FLD2