Column | Type | Length | Contents |
---|
ID | long int | | Student ID number |
FY | smallint | | Fiscal year |
DistCode | char | 1 | Distribution code |
DispSem | char | 6 | Print semester |
SortSem | char | 6 | Sort semester |
SortCode | char | 3 | Sort code |
TranCode | char | 4 | Transaction code (e.g. CHEK, TUIT) |
TranDt | datetime | | Transaction date |
LedgerClass | char | 2 | Ledger class |
Dept | char | 4 | Department |
Budget | char | 2 | Budget |
Object | char | 2 | Object |
Fund | char | 6 | Fund |
Amount | decimal | | Amount |
DebitCredit | char | 1 | Debit/credit code (C=credit, D=debit) |
PrelimReal | char | 1 | Prelim/real code (P=prelimiary, R=real) |
BatchNo | char | 4 | Batch number |
EnteredBy | varchar | 10 | (not currently in use) |
PostDt | datetime | | Posted date |
AcctMo | char | 2 | Account month |
JournalDt | datetime | | Journal date |
Division | char | 2 | Division |
FaCode | char | 1 | FA code |
MemoDt | datetime | | Memo date |
ThirdPartyID | char | 9 | Third party ID |
CheckReqFY | smallint | | Check request fiscal year |
CheckReqBatch | char | 4 | Check request batch |
CheckReqDt | datetime | | Check request date |
ThirdPartyName | char | 4 | Third party name |
MaintDt | datetime | | Last date record was updated |
LastChgID | int | | (not currently in use) |
TranDesc | varchar | 16 | Description of transaction |
BillingID | int | | Billing ID number |