back to htv views

ColumnTypeLengthContents
IDlong int Student ID number
FYsmallint Fiscal year
DistCodechar1Distribution code
DispSemchar6Print semester
SortSemchar6Sort semester
SortCodechar3Sort code
TranCodechar4Transaction code (e.g. CHEK, TUIT)
TranDtdatetime Transaction date
LedgerClasschar2Ledger class
Deptchar4Department
Budgetchar2Budget
Objectchar2Object
Fundchar6Fund
Amountdecimal Amount
DebitCreditchar1Debit/credit code (C=credit, D=debit)
PrelimRealchar1Prelim/real code (P=prelimiary, R=real)
BatchNochar4Batch number
EnteredByvarchar10(not currently in use)
PostDtdatetime Posted date
AcctMochar2Account month
JournalDtdatetime Journal date
Divisionchar2Division
FaCodechar1FA code
MemoDtdatetime Memo date
ThirdPartyIDchar9Third party ID
CheckReqFYsmallint Check request fiscal year
CheckReqBatchchar4Check request batch
CheckReqDtdatetime Check request date
ThirdPartyNamechar4Third party name
MaintDtdatetime Last date record was updated
LastChgIDint (not currently in use)
TranDescvarchar16Description of transaction
BillingIDint Billing ID number