Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CommunicationSeq | int | 4 | null |
|
|
|||
| RecipientID | int | 4 | null |
|
|
|||
| RecipientIDType | varchar | 1 | null |
|
|
|||
| RecipientIDJoint | int | 4 | null |
|
|
|||
| CommunicationCode | varchar | 15 | null |
|
|
|||
| CommunicationDescription | varchar | 50 | √ | null |
|
|
||
| CommunicationTypeCode | varchar | 15 | √ | null |
|
|
||
| CommunicationNotifyMethod | varchar | 10 | √ | null |
|
|
||
| CommunicationNotifyMeaning | varchar | 10 | √ | null |
|
|
||
| CommunicationFrom | varchar | 50 | √ | null |
|
|
||
| CommunicationSentDate | datetime | 16,3 | √ | null |
|
|
||
| CommunicationComment | varchar | 2147483647 | √ | null |
|
|
||
| CommunicationResponse | varchar | 255 | null |
|
|
|||
| RecipientMailName | varchar | 100 | null |
|
|
|||
| RecipientAddressComma | varchar | 200 | √ | null |
|
|
||
| RecipientAddressFull | varchar | 200 | √ | null |
|
|
||
| RecipientSuburb | varchar | 40 | √ | null |
|
|
||
| RecipientState | varchar | 5 | √ | null |
|
|
||
| RecipientPostcode | varchar | 5 | √ | null |
|
|
||
| RecipientCountryCode | varchar | 5 | √ | null |
|
|
||
| RecipientAddressDPID | varchar | 8 | √ | null |
|
|
||
| RecipientAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| RecipientAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| RecipientAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| RecipientSurname | varchar | 30 | null |
|
|
|||
| RecipientTitle | varchar | 30 | null |
|
|
|||
| RecipientInitials | varchar | 15 | null |
|
|
|||
| RecipientSuffix | varchar | 20 | null |
|
|
|||
| RecipientPreferred | varchar | 20 | null |
|
|
|||
| RecipientGiven1 | varchar | 20 | null |
|
|
|||
| RecipientGiven2 | varchar | 50 | null |
|
|
|||
| RecipientGender | varchar | 15 | null |
|
|
|||
| RecipientHomePhone | varchar | 15 | √ | null |
|
|
||
| RecipientHomeFax | varchar | 15 | √ | null |
|
|
||
| RecipientMobilePhone | varchar | 15 | null |
|
|
|||
| RecipientDefaultMobilePhone | varchar | 15 | null |
|
|
|||
| RecipientHomeEmail | varchar | 100 | null |
|
|
|||
| RecipientValidAddressFlag | bit | 1 | √ | null |
|
|
||
| RecipientSoliciationFlag | bit | 1 | √ | null |
|
|
||
| RecipientMagazineFlag | bit | 1 | √ | null |
|
|
||
| RecipientOccupCode | varchar | 15 | √ | null |
|
|
||
| RecipientOccupDesc | varchar | 50 | null |
|
|
|||
| RecipientOccupDescIncludeInAddressFlag | bit | 1 | null |
|
|
|||
| RecipientOccupCompany | varchar | 50 | null |
|
|
|||
| RecipientOccupIndustryCode | varchar | 8 | null |
|
|
|||
| RecipientOccupPositionCode | varchar | 8 | null |
|
|
|||
| RecipientOccupPhone | varchar | 15 | null |
|
|
|||
| RecipientOccupFax | varchar | 15 | null |
|
|
|||
| RecipientOccupMobilePhone | varchar | 15 | null |
|
|
|||
| RecipientOccupEmail | varchar | 100 | null |
|
|
|||
| RecipientDeceasedDate | datetime | 16,3 | √ | null |
|
|
||
| RecipientDeceasedFlag | bit | 1 | null |
|
|
|||
| RecipientReligionCode | varchar | 5 | null |
|
|
|||
| RecipientCountryOfBirthCode | varchar | 5 | null |
|
|
|||
| RecipientHomeLanguageCode | varchar | 5 | null |
|
|
|||
| RecipientOccupAddressFull | varchar | 200 | null |
|
|
|||
| RecipientOccupAddressComma | varchar | 200 | null |
|
|
|||
| RecipientOccupAddress1 | varchar | 40 | null |
|
|
|||
| RecipientOccupAddressDPID | varchar | 8 | null |
|
|
|||
| RecipientOccupAddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| RecipientOccupAddressSortPlanNumber | varchar | 3 | null |
|
|
|||
| RecipientOccupAddressPAFVersion | varchar | 10 | null |
|
|
|||
| RecipientNotifyMethod | varchar | 10 | null |
|
|
|||
| RecipientNotifyMeaning | varchar | 10 | √ | null |
|
|
||
| RecipientNotifyProcessNumber | int | 4 | null |
|
|
|||
| RecipientNotifyDate | datetime | 16,3 | √ | null |
|
|
||
| RecipientNotifyEmail | varchar | 100 | null |
|
|
|||
| RecipientNoNotifyFlag | int | 4 | null |
|
|
|||
| RecipientAddressRegionCode | varchar | 10 | √ | null |
|
|
||
| RecipientAddressRegionDescription | varchar | 30 | √ | null |
|
|
Table contained 0 rows