CA_TXN_STYPE_V1

(SQL View)
Index Back

Sub Txn Type View

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

%Sql(CA_COM_GET_XLAT,'CA_TXN_SUB_TYPE',3)

  • Related Language Record: CA_TXN_STYPE_L1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 DESCRIPTION Character(35) VARCHAR2(35) NOT NULL DESCRIPTION