Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CreditorID | int | 4 | null |
|
|
|||
| MailAddressCode | varchar | 1 | null |
|
|
|||
| CreditorAddress1 | varchar | 40 | √ | null |
|
|
||
| CreditorAddress2 | varchar | 40 | √ | null |
|
|
||
| CreditorAddress3 | varchar | 40 | √ | null |
|
|
||
| CreditorSuburb | varchar | 40 | √ | null |
|
|
||
| CreditorState | varchar | 40 | √ | null |
|
|
||
| CreditorCountryCode | varchar | 5 | √ | null |
|
|
||
| CreditorPostCode | varchar | 5 | √ | null |
|
|
||
| CreditorAddressComma | varchar | 200 | √ | null |
|
|
||
| CreditorAddressFull | varchar | 200 | √ | null |
|
|
||
| CreditorAddressDPID | varchar | 8 | √ | null |
|
|
||
| CreditorAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| CreditorAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| CreditorAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| CreditorEmailAddress | varchar | 100 | √ | null |
|
|
||
| OccupAddress1 | varchar | 40 | null |
|
|
|||
| OccupAddress2 | varchar | 40 | null |
|
|
|||
| OccupAddress3 | varchar | 40 | null |
|
|
|||
| OccupSuburb | varchar | 40 | null |
|
|
|||
| OccupState | varchar | 5 | √ | null |
|
|
||
| OccupCountryCode | varchar | 5 | null |
|
|
|||
| OccupPostCode | varchar | 5 | null |
|
|
|||
| OccupAddressComma | varchar | 200 | null |
|
|
|||
| OccupAddressFull | varchar | 200 | null |
|
|
|||
| OccupAddressDPID | varchar | 8 | null |
|
|
|||
| OccupAddressSortPlanNumber | varchar | 3 | null |
|
|
|||
| OccupAddressPAFVersion | varchar | 10 | null |
|
|
|||
| OccupEmail | varchar | 100 | null |
|
|
|||
| varchar | 100 | null |
|
|
||||
| OccupAddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| Address1 | varchar | 40 | null |
|
|
|||
| Address2 | varchar | 40 | null |
|
|
|||
| Address3 | varchar | 40 | null |
|
|
|||
| Suburb | varchar | 40 | null |
|
|
|||
| State | varchar | 5 | null |
|
|
|||
| CountryCode | varchar | 5 | null |
|
|
|||
| PostCode | varchar | 5 | null |
|
|
|||
| AddressComma | varchar | 200 | √ | null |
|
|
||
| AddressFull | varchar | 200 | √ | null |
|
|
||
| AddressDPID | varchar | 8 | null |
|
|
|||
| AddressSortPlanNumber | varchar | 3 | null |
|
|
|||
| AddressPAFVersion | varchar | 10 | null |
|
|
|||
| AddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| HomeAddress1 | varchar | 40 | null |
|
|
|||
| HomeAddress2 | varchar | 40 | null |
|
|
|||
| HomeAddress3 | varchar | 40 | null |
|
|
|||
| HomeSuburb | varchar | 40 | null |
|
|
|||
| HomeState | varchar | 5 | null |
|
|
|||
| HomeCountryCode | varchar | 5 | null |
|
|
|||
| HomePostCode | varchar | 5 | null |
|
|
|||
| HomeAddressComma | varchar | 200 | √ | null |
|
|
||
| HomeAddressFull | varchar | 200 | √ | null |
|
|
||
| HomeAddressDPID | varchar | 8 | null |
|
|
|||
| HomeAddressSortPlanNumber | varchar | 3 | null |
|
|
|||
| HomeAddressPAFVersion | varchar | 10 | null |
|
|
|||
| HomeAddressDPIDBarcode | varchar | 60 | null |
|
|
Table contained 0 rows