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 |