CC_VISA_TTYPE

(SQL Table)
Index Back

ProCard Visa Trans Type Code

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VS_CCTRANS_TYP_CD Character(2) VARCHAR2(2) NOT NULL Visa Transaction Type Code
10=Purchase
11=Credit Voucher
20=Manual Cash Disbursement
22=ATM Cash Disbursement
30=Payment Reversal - NSF Check
31=Payment
40=Finance Charge
50=Annual Fee
52=Miscellaneous Fees
54=NSF Check Fee
56=Report Fee
61=Credit Adjustment
62=Debit Adjustment
63=Finance Charge Credit Adjust
64=Finance Charge Debit Adjust
65=Other Credits
66=Other Debits
71=Fuel Discount
73=Non-Fuel Discount
80=Convenience Checks
82=Convenience Checks Fees
84=Travelers Checks Fees
86=ATM Fees
88=Late Fees
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
4 CHARGE_CATEGORY Character(3) VARCHAR2(3) NOT NULL Transaction Charge Type
1=New Charge
2=Other Debits
4=Payment
5=Other Credits