| TR | 1 | AddrTableId | Table ID of the main table | tableId | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | tableId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS27713 (This field is used together with address record ID and line number to form a unique key.) | | Label | @SYS27712 (Table ID of the main table) | | Mandatory | No | | Name | AddrTableId | | SaveContents | Yes | | Table | Address | | Type | Integer | | Visible | Yes |
|
| TR | 2 | AddrRecId | --- | recId | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | recId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AddrRecId | | SaveContents | Yes | | Table | Address | | Type | Integer | | Visible | Yes |
|
| | 3 | LineNum | Line No | LineNum | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | LineNum | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | LineNum | | SaveContents | Yes | | Table | Address | | Type | Real | | Visible | Yes |
|
| | 4 | type | Address type | AddressType | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | AddressType | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | type | | SaveContents | Yes | | Table | Address | | Type | Enum | | Visible | Yes |
|
| | 5 | Name | Name | Name | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Name | | GroupPrompt | | | HelpText | @SYS67298 (Name of the current address) | | Label | | | Mandatory | No | | Name | Name | | SaveContents | Yes | | StringSize | 30 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 6 | Address | Address | Addressing | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | Addressing | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Address | | SaveContents | Yes | | StringSize | 250 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 7 | Phone | Telephone | Phone | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Phone | | GroupPrompt | | | HelpText | @SYS9249 (Phone number for current address) | | Label | | | Mandatory | No | | Name | Phone | | SaveContents | Yes | | StringSize | 20 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 8 | TeleFax | Fax | TeleFax | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TeleFax | | GroupPrompt | | | HelpText | @SYS10430 (Fax number for current address) | | Label | | | Mandatory | No | | Name | TeleFax | | SaveContents | Yes | | StringSize | 20 | | Table | Address | | Type | String | | Visible | Yes |
|
| TR FK | 9 | Country | Country | CountryId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CountryId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Country | | SaveContents | Yes | | StringSize | 10 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 10 | DEL_SWIFTNumber | SWIFT code | SWIFTNo | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | SWIFTNo | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_SWIFTNumber | | SaveContents | Yes | | StringSize | 20 | | Table | Address | | Type | String | | Visible | Yes |
|
| FK | 11 | ZipCode | Postal (Zip) code | ZipCodeId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ZipCodeId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ZipCode | | SaveContents | Yes | | StringSize | 10 | | Table | Address | | Type | String | | Visible | Yes |
|
| TR | 12 | State | State | StateId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | StateId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | State | | SaveContents | Yes | | StringSize | 10 | | Table | Address | | Type | String | | Visible | Yes |
|
| TR | 13 | County | County | CountyId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CountyId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | County | | SaveContents | Yes | | StringSize | 10 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 14 | Telex | Telex number | Telex | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Telex | | GroupPrompt | | | HelpText | @SYS67297 (Telex number of the current address) | | Label | | | Mandatory | No | | Name | Telex | | SaveContents | Yes | | StringSize | 20 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 15 | URL | WWW address | URL | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | URL | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | URL | | SaveContents | Yes | | StringSize | 255 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 16 | PhoneLocal | Extension | PhoneLocal | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | PhoneLocal | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | PhoneLocal | | SaveContents | Yes | | StringSize | 10 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 17 | CellularPhone | Mobile phone | PhoneMobile | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | PhoneMobile | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | CellularPhone | | SaveContents | Yes | | StringSize | 20 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 18 | Email | E-mail | Email | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Email | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Email | | SaveContents | Yes | | StringSize | 80 | | Table | Address | | Type | String | | Visible | Yes |
|
| FK | 19 | TaxGroup | Sales tax group | TaxGroup | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TaxGroup | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | TaxGroup | | SaveContents | Yes | | StringSize | 10 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 20 | City | City | City | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | City | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | City | | SaveContents | Yes | | StringSize | 30 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 21 | Street | Street name | AddressingStreet | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AddressingStreet | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Street | | SaveContents | Yes | | StringSize | 250 | | Table | Address | | Type | String | | Visible | Yes |
|
| | 23 | SMS | SMS | SMS | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | SMS | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SMS | | SaveContents | Yes | | StringSize | 80 | | Table | Address | | Type | String | | Visible | Yes |
|
| TR | 24 | RefZipCode | Reference | RefRecId | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | RefRecId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | RefZipCode | | SaveContents | Yes | | Table | Address | | Type | Integer | | Visible | Yes |
|