Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReceiptTransactionSeq | int | 4 | null |
|
|
|||
| DebtorID | int | 4 | null |
|
|
|||
| DebtorStudentID | int | 4 | null |
|
|
|||
| DebtorSurname | varchar | 30 | √ | null |
|
|
||
| DebtorPreferred | varchar | 20 | √ | null |
|
|
||
| DebtorAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentID | int | 4 | null |
|
|
|||
| ReceiptPostingNumber | int | 4 | null |
|
|
|||
| ReceiptPostingSource | varchar | 10 | null |
|
|
|||
| ReceiptInstalmentSeq | int | 4 | null |
|
|
|||
| ReceiptInstalmentsRemaining | smallint | 2 | null |
|
|
|||
| ReceiptStatementNumber | int | 4 | null |
|
|
|||
| ReceiptNumber | int | 4 | null |
|
|
|||
| ReceiptFeeCode | varchar | 15 | null |
|
|
|||
| ReceiptTransactionDate | datetime | 16,3 | √ | null |
|
|
||
| ReceiptTransactionAmount | money | 21,4 | null |
|
|
|||
| ReceiptTransactionDescription | varchar | 80 | null |
|
|
|||
| ReceiptAllocatedAmount | money | 21,4 | null |
|
|
|||
| ReceiptFeeUnits | decimal | 11,4 | null |
|
|
|||
| ReceiptFeeRate | money | 21,4 | null |
|
|
|||
| ReceiptSaleInvoiceNumber | int | 4 | null |
|
|
|||
| ReceiptCreditorPostingNumber | int | 4 | √ | null |
|
|
||
| ReceiptCreditorTransactionSeq | int | 4 | √ | null |
|
|
||
| ReceiptCreditorGLJournalSeq | int | 4 | √ | null |
|
|
||
| GLCode | varchar | 15 | √ | null |
|
|
||
| GLDescription | varchar | 50 | √ | null |
|
|
||
| TransactionXrefAmount | money | 21,4 | √ | null |
|
|
||
| ChargeTransactionSeq | int | 4 | √ | null |
|
|
||
| ChargeTransactionDate | datetime | 16,3 | √ | null |
|
|
||
| ChargeTransactionAmount | money | 21,4 | √ | null |
|
|
||
| ChargeTransactionDescription | varchar | 80 | √ | null |
|
|
||
| ChargeGLPercent | money | 21,4 | null |
|
|
Table contained 0 rows