LOANECQUEUEVWLN

(SQL View)
 Index Back

Electronic Commerce Queue

LOANECQUEUEVWLN is the language record related to LOAN_ECQUEUE_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.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.ECBUSDOCID , C.LANGUAGE_CD , C.DESCR FROM PS_ECQUEUE A , PS_FA_ECTRANS B , PS_FA_ECTRANS_LANG C WHERE A.ECTRANSID = B.ECTRANSID AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND B.FA_PROCESS_USE IN ('C','D') AND A.ECQUEUESTATUS IN ('L', 'P','E') AND B.ECTRANSID = C.ECTRANSID AND B.ECTRANSINOUTSW = C.ECTRANSINOUTSW

  • Related Language Record for LOAN_ECQUEUE_VW

  • Parent record: ECBUSDOCHDR

    • # 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 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
    3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
    I=Inbound
    O=Outbound
    4 ECBUSDOCID Number(9,0) DECIMAL(9) NOT NULL EC Business Document ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description