CA_TXN_STYPE_LG

(SQL View)
 Index Back

CA_TXN_TYPE_LG

CRM/Contracts Transaction Type language view created from translate values of field CA_TXN_TYPE.

SELECT A.CA_TXN_TYPE , A.CA_TXN_SUB_TYPE , B.LANGUAGE_CD , B.DESCRIPTION FROM PS_CA_TXN_STYPE_VW A , PS_CA_TXN_STYPE_L1 B WHERE A.CA_TXN_SUB_TYPE = B.CA_TXN_SUB_TYPE

  • Related Language Record for CA_TXN_STYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CA_TXN_TYPE Character(3) VARCHAR2(3) NOT NULL CRM Transaction Type
    01=Agreement
    02=Service Order
    03=Case
    04=Order Capture
    2 CA_TXN_SUB_TYPE Character(3) VARCHAR2(3) NOT NULL CRM Transaction Subtype
    01=Fee
    02=Uplift/Discount
    03=Material
    04=Labor
    05=Expense
    06=Onetime Fee
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRIPTION Character(35) VARCHAR2(35) NOT NULL DESCRIPTION