EXD_DOCNBR_LVW

(SQL View)
 Index Back

relative language record

relative language record of EXD_DOCNBR_VW_L

SELECT BUSINESS_UNIT ,A.EXD_DOC_NBR_SER ,D.language_cd , D.DESCR1 FROM PS_ORG_DOC_NBR_RNG A , PS_ORG_DOC_NBR_SER B , PS_ORG_BU_TAX_APPL C ,PS_ORG_DOC_SER_LNG D WHERE B.setid=d.setid AND B.EXD_DOC_NBR_SER=d.EXD_DOC_NBR_SER AND A.START_DT =( SELECT MAX(START_DT) FROM PS_ORG_DOC_NBR_RNG WHERE START_DT <= %CurrentDateIn AND SETID=B.SETID AND SETID=C.ORG_SETID AND ORG_CODE=C.ORG_CODE AND ORG_TAX_LOC_CD=C.ORG_TAX_LOC_CD AND C.ORG_BU_TYPE='IN' AND EXD_DOC_NBR_SER=B.EXD_DOC_NBR_SER) AND A.SETID=B.SETID AND A.SETID=C.ORG_SETID AND A.ORG_CODE=C.ORG_CODE AND A.ORG_TAX_LOC_CD=C.ORG_TAX_LOC_CD AND C.ORG_BU_TYPE='IN' AND A.EXD_DOC_NBR_SER=B.EXD_DOC_NBR_SER AND B.EXD_TXN_TYPE IN ('DOMS', 'DEXB', 'DEXP', 'EXP', 'EXPB', 'MEIN', 'STFR')

  • Related Language Record for EXD_DOCNBR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EXD_DOC_NBR_SER Character(6) VARCHAR2(6) NOT NULL Excise Document Number Series. Excise Document number series group will be created against each excise transaction type.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr