SYS_TRAN_VW

(SQL View)
 Index Back

System Tran Type Descriptions


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

  • Related Language Record: SYS_TRAN_LVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description