Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CommunicationCurrentSeq | int | 4 | null |
|
|
|||
| RecipientID | int | 4 | null |
|
|
|||
| RecipientIDType | varchar | 1 | null |
|
|
|||
| CommunicationCode | varchar | 15 | null |
|
|
|||
| CommunicationDescription | varchar | 50 | √ | null |
|
|
||
| CommunicationFrom | varchar | 50 | √ | null |
|
|
||
| CommunicationTypeCode | varchar | 15 | √ | null |
|
|
||
| CommunicationNotifyMethod | varchar | 10 | √ | null |
|
|
||
| CommunicationNotifyMeaning | varchar | 10 | √ | null |
|
|
||
| CommunicationSentDate | datetime | 16,3 | √ | null |
|
|
||
| CommunicationComment | varchar | 2147483647 | √ | null |
|
|
||
| CommunicationEmailSubject | nvarchar | 510 | √ | null |
|
|
||
| CommunicationEmailMessage | nvarchar | 1073741823 | √ | null |
|
|
||
| RecipientMailName | varchar | 100 | null |
|
|
|||
| RecipientMailSalutation | varchar | 100 | null |
|
|
|||
| RecipientAddressComma | varchar | 200 | √ | null |
|
|
||
| RecipientAddressFull | varchar | 200 | √ | null |
|
|
||
| RecipientAddress1 | varchar | 40 | √ | null |
|
|
||
| RecipientAddress2 | varchar | 40 | √ | null |
|
|
||
| RecipientAddress3 | varchar | 40 | √ | 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 |
|
|
||
| RecipientAddressComment | varchar | 250 | √ | null |
|
|
||
| RecipientCountryDescription | varchar | 40 | √ | null |
|
|
||
| RecipientNameInternal | varchar | 100 | null |
|
|
|||
| RecipientNameExternal | varchar | 100 | null |
|
|
|||
| RecipientLegalFullName | varchar | 150 | null |
|
|
|||
| RecipientSurname | varchar | 30 | null |
|
|
|||
| RecipientTitle | varchar | 30 | null |
|
|
|||
| RecipientInitials | varchar | 15 | null |
|
|
|||
| RecipientSuffix | varchar | 20 | null |
|
|
|||
| RecipientPreferred | varchar | 20 | null |
|
|
|||
| RecipientPreferredFormal | 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 |
|
|
|||
| RecipientNetworkLogin | 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 |
|
|
|||
| RecipientExternalSystemRegistrationNumber | varchar | 30 | 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 |
|
|
|||
| RecipientOccupAddressComment | varchar | 250 | null |
|
|
|||
| RecipientNotifyMethod | varchar | 10 | null |
|
|
|||
| RecipientNotifyMeaning | varchar | 10 | √ | null |
|
|
||
| RecipientNotifyProcessNumber | int | 4 | null |
|
|
|||
| RecipientNotifyDate | datetime | 16,3 | √ | null |
|
|
||
| RecipientNotifyEmail | varchar | 201 | √ | null |
|
|
||
| RecipientDefaultEmail | varchar | 100 | √ | null |
|
|
||
| RecipientNoNotifyFlag | int | 4 | null |
|
|
|||
| RecipientAddressRegionCode | varchar | 10 | √ | null |
|
|
||
| RecipientAddressRegionDescription | varchar | 30 | √ | null |
|
|
||
| RecipientSpouseNameInternal | varchar | 100 | √ | null |
|
|
||
| RecipientSpouseNameExternal | varchar | 100 | √ | null |
|
|
||
| RecipientSpouseLegalFullName | varchar | 150 | √ | null |
|
|
||
| RecipientSpouseSurname | varchar | 30 | √ | null |
|
|
||
| RecipientSpouseTitle | varchar | 30 | √ | null |
|
|
||
| RecipientSpouseInitials | varchar | 15 | √ | null |
|
|
||
| RecipientSpouseSuffix | varchar | 20 | √ | null |
|
|
||
| RecipientSpousePreferred | varchar | 20 | √ | null |
|
|
||
| RecipientSpousePreferredFormal | varchar | 20 | √ | null |
|
|
||
| RecipientSpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| RecipientSpouseGiven2 | varchar | 50 | √ | null |
|
|
||
| RecipientSpouseGender | varchar | 15 | √ | null |
|
|
||
| RecipientSpouseMobilePhone | varchar | 15 | √ | null |
|
|
||
| RecipientSpouseDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| RecipientSpouseHomeEmail | varchar | 100 | √ | null |
|
|
||
| RecipientSpouseNetworkLogin | varchar | 100 | √ | null |
|
|
||
| RecipientSpouseOccupCode | varchar | 15 | √ | null |
|
|
||
| RecipientSpouseOccupDesc | varchar | 50 | √ | null |
|
|
||
| RecipientSpouseOccupDescIncludeInAddressFlag | bit | 1 | √ | null |
|
|
||
| RecipientSpouseOccupCompany | varchar | 50 | √ | null |
|
|
||
| RecipientSpouseOccupIndustryCode | varchar | 8 | √ | null |
|
|
||
| RecipientSpouseOccupPositionCode | varchar | 8 | √ | null |
|
|
||
| RecipientSpouseOccupPhone | varchar | 15 | √ | null |
|
|
||
| RecipientSpouseOccupFax | varchar | 15 | √ | null |
|
|
||
| RecipientSpouseOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| RecipientSpouseOccupEmail | varchar | 100 | √ | null |
|
|
||
| RecipientSpouseDeceasedDate | datetime | 16,3 | √ | null |
|
|
||
| RecipientSpouseDeceasedFlag | bit | 1 | √ | null |
|
|
||
| RecipientSpouseReligionCode | varchar | 5 | √ | null |
|
|
||
| RecipientSpouseCountryOfBirthCode | varchar | 5 | √ | null |
|
|
||
| RecipientSpouseHomeLanguageCode | varchar | 5 | √ | null |
|
|
||
| RecipientSpouseExternalSystemRegistrationNumber | varchar | 30 | √ | null |
|
|
||
| RecipientSpouseOccupAddressFull | varchar | 200 | √ | null |
|
|
||
| RecipientSpouseOccupAddressComma | varchar | 200 | √ | null |
|
|
||
| RecipientSpouseOccupAddress1 | varchar | 40 | √ | null |
|
|
||
| RecipientSpouseOccupAddressDPID | varchar | 8 | √ | null |
|
|
||
| RecipientSpouseOccupAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| RecipientSpouseOccupAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| RecipientSpouseOccupAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| RecipientSpouseOccupAddressComment | varchar | 250 | √ | null |
|
|
||
| RecipientNotifyMobilePhone | varchar | 15 | √ | null |
|
|
||
| CommunicationsSeq | int | 4 | √ | null |
|
|
||
| RecipientMailSalutationPreferred | varchar | 45 | √ | null |
|
|
Table contained 0 rows