CA_TXN_STYPE_VW

(SQL View)
 Index Back

CA_TXN_STYPE_VW1

CRM/Contracts Transaction Sub-type view created from translate values of field CA_TXN_SUB_TYPE.

SELECT A.CA_TXN_TYPE , B.CA_TXN_SUB_TYPE , B.DESCRIPTION FROM PS_CA_TXN_TYPE_VW A , PS_CA_TXN_STYPE_V1 B WHERE ( (A.CA_TXN_TYPE = '01' AND B.CA_TXN_SUB_TYPE IN ('01','02')) OR (A.CA_TXN_TYPE = '02' AND B.CA_TXN_SUB_TYPE IN ('01','02','03','04','05')) OR (A.CA_TXN_TYPE = '03' AND B.CA_TXN_SUB_TYPE IN ('01')) OR (A.CA_TXN_TYPE = '04' AND B.CA_TXN_SUB_TYPE IN ('01','06')))

  • Related Language Record: CA_TXN_STYPE_LG

    • # 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 DESCRIPTION Character(35) VARCHAR2(35) NOT NULL DESCRIPTION