Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReceiptSeq | int | 4 | null |
|
|
|||
| PledgeSeq | int | 4 | null |
|
|
|||
| DonorID | int | 4 | null |
|
|
|||
| DonorIDJoint | int | 4 | null |
|
|
|||
| DonorName | varchar | 100 | null |
|
|
|||
| DonorNameRaw | varchar | 100 | null |
|
|
|||
| DonorMailName | varchar | 100 | √ | null |
|
|
||
| DonorMailSalutation | varchar | 100 | √ | null |
|
|
||
| DonorNameInternal | varchar | 100 | √ | null |
|
|
||
| DonorNameExternal | varchar | 100 | √ | null |
|
|
||
| DonorLegalFullName | varchar | 150 | √ | null |
|
|
||
| DonorSurname | varchar | 30 | √ | null |
|
|
||
| DonorPreferred | varchar | 20 | √ | null |
|
|
||
| DonorPreferredFormal | varchar | 20 | √ | null |
|
|
||
| DonorGiven1 | varchar | 20 | √ | null |
|
|
||
| DonorGiven2 | varchar | 50 | √ | null |
|
|
||
| DonorInitials | varchar | 15 | √ | null |
|
|
||
| DonorAddressFull | varchar | 200 | √ | null |
|
|
||
| DonorAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| DonorAddressComma | varchar | 200 | √ | null |
|
|
||
| DonorHomePhone | varchar | 15 | √ | null |
|
|
||
| DonorHomeFax | varchar | 15 | √ | null |
|
|
||
| DonorOccupPhone | varchar | 15 | √ | null |
|
|
||
| DonorOccupFax | varchar | 15 | √ | null |
|
|
||
| DonorMobilePhone | varchar | 15 | √ | null |
|
|
||
| DonorDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| DonorOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| DonorHomeEmail | varchar | 100 | √ | null |
|
|
||
| DonorOccupEmail | varchar | 100 | √ | null |
|
|
||
| DonorDeceasedFlag | bit | 1 | √ | null |
|
|
||
| ReceiptNo | varchar | 10 | null |
|
|
|||
| ReceiptAmount | money | 21,4 | null |
|
|
|||
| ReceiptPaymentMethodCode | varchar | 15 | null |
|
|
|||
| ReceiptDrawer | varchar | 50 | √ | null |
|
|
||
| ReceiptDate | datetime | 16,3 | √ | null |
|
|
||
| ReceiptAppeal | varchar | 10 | null |
|
|
|||
| ReceiptAppealDescription | varchar | 100 | √ | null |
|
|
||
| ReceiptFund | varchar | 15 | √ | null |
|
|
||
| ReceiptFundDescription | varchar | 100 | √ | null |
|
|
||
| ReceiptFundTaxDeductableFlag | bit | 1 | √ | null |
|
|
||
| ReceiptAnonymousFlag | bit | 1 | null |
|
|
|||
| ReceiptRecognitionFlag | bit | 1 | null |
|
|
|||
| ReceiptComments | varchar | 2000 | null |
|
|
|||
| PostingNumber | int | 4 | null |
|
|
|||
| ReceiptNumber | int | 4 | null |
|
|
|||
| DonorSpouseSurname | varchar | 30 | √ | null |
|
|
||
| DonorSpousePreferred | varchar | 20 | √ | null |
|
|
||
| DonorSpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| DonorSpouseGiven2 | varchar | 50 | √ | null |
|
|
||
| DonorSpouseID | int | 4 | √ | null |
|
|
||
| DonorDefaultEmail | varchar | 201 | √ | null |
|
|
||
| DonorOccupDesc | varchar | 50 | √ | null |
|
|
||
| DonorSpouseDefaultEmail | varchar | 201 | √ | null |
|
|
||
| DonorSpouseOccupDesc | varchar | 50 | √ | null |
|
|
Table contained 0 rows