PROD_LD_ERR_LNG

(SQL View)
 Index Back

Related Language Record

Related Language Record for PROD_LD_ERR_VW

SELECT ERR.EIP_PROGRAM , ERR.EIP_CTL_ID , ERR.RECNAME , ERR.FIELDNAME , OPT.LANGUAGE_CD , ERR.DESCR254 FROM PS_EO_EIP_CTL EO , PS_PROD_LOAD_ERR ERR , PS_PROD_LOAD_ER_LN OPT WHERE EO.EIP_DTA_STATUS = '1' AND EO.EIP_CTL_ID = ERR.EIP_CTL_ID AND ERR.EIP_PROGRAM = OPT.EIP_PROGRAM AND ERR.EIP_CTL_ID = OPT.EIP_CTL_ID AND ERR.RECNAME = OPT.RECNAME AND ERR.FIELDNAME = OPT.FIELDNAME AND ERR.KEY_CHAR_25_01 = OPT.KEY_CHAR_25_01 AND ERR.KEY_CHAR_25_02 = OPT.KEY_CHAR_25_02 AND ERR.KEY_CHAR_25_03 = OPT.KEY_CHAR_25_03 AND ERR.KEY_CHAR_25_04 = OPT.KEY_CHAR_25_04 AND ERR.KEY_CHAR_25_04 = OPT.KEY_CHAR_25_04 AND ERR.KEY_CHAR_25_06 = OPT.KEY_CHAR_25_06 AND ERR.KEY_DATE_01 = OPT.KEY_DATE_01 AND ERR.KEY_DATE_02 = OPT.KEY_DATE_02 AND ERR.KEY_NUM_01 = OPT.KEY_NUM_01 AND ERR.KEY_NUM_02 = OPT.KEY_NUM_02

  • Related Language Record for PROD_LD_ERR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
    601=Consumer Sync
    701=BOM Sync
    801=Item Revision
    901=Item Bus Unit Sync
    902=Item Sync
    2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254