SYS_TRAN_LVW

(SQL View)
 Index Back

System Tran Type Descriptions


SELECT %Substring(fieldvalue,1,1) , language_cd , xlatlongname , xlatshortname FROM PSXLATITEMLANG WHERE fieldname = 'SYS_TRAN_TYPE'

  • Related Language Record for SYS_TRAN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SYS_TRAN_TYPE Character(1) VARCHAR2(1) NOT NULL Activity Type
    A=Draft Management
    B=Deductions Management
    C=Cash Applied
    D=Discounts
    F=Overdue Charges
    G=Payment Plan Item-Maintenance
    I=Billing
    M=Maintenance
    P=Write-offs - Payments
    R=Refunds - Maintenance
    T=Transfers
    W=Write-offs - Maintenance
    X=Direct Debit
    Y=Write Offs - Deduction
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description