LNCLBATOUTVWLNG

(SQL View)
 Index Back

RelLng-CmnLn Expt Hdr Stgn Tbl

LNCLBATOUTVWLNG is the language record view related to LN_CL_BATOUT_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT A.ECTRANSID , A.CL_BATCH_ID ,B.LANGUAGE_CD , B.DESCRSHORT FROM PS_CL_EXP_HEAD_EC A , PS_LN_DESTPR_LANG B WHERE A.LN_DEST_NBR=B.LN_DEST_NBR AND A.ECTRANSINOUTSW='O'

  • Related Language Record for LN_CL_BATOUT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
    2 CL_BATCH_ID Character(12) VARCHAR2(12) NOT NULL CommonLine Batch ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description