| X | PK | 1 | SignUpId | Registration number | ECPCustSignUpId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | ECPCustSignUpId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SignUpId | | SaveContents | Yes | | StringSize | 20 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 2 | Email | E-mail | ECPEmail | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ECPEmail | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | Email | | SaveContents | Yes | | StringSize | 80 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 3 | TeleFax | Fax | TeleFax | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TeleFax | | GroupPrompt | | | HelpText | @SYS16720 (Customer fax number) | | Label | | | Mandatory | No | | Name | TeleFax | | SaveContents | Yes | | StringSize | 20 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 4 | Phone | Telephone | Phone | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Phone | | GroupPrompt | | | HelpText | @SYS16721 (Customer phone number) | | Label | | | Mandatory | No | | Name | Phone | | SaveContents | Yes | | StringSize | 20 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 5 | Address | Address | Addressing | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Addressing | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Address | | SaveContents | Yes | | StringSize | 250 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 6 | Name | Company name | CustName | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CustName | | GroupPrompt | | | HelpText | | | Label | @SYS15581 (Company name) | | Mandatory | Yes | | Name | Name | | SaveContents | Yes | | StringSize | 30 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 7 | KeepBasket | Keep basket | ECPCustSignUpKeepBasket | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | ECPCustSignUpKeepBasket | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | KeepBasket | | SaveContents | Yes | | Table | ECPCustSignUp | | Type | Enum | | Visible | Yes |
|
| | 8 | CustCreated | Created | ECPCustSignUpCreated | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | No | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | ECPCustSignUpCreated | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | CustCreated | | SaveContents | Yes | | Table | ECPCustSignUp | | Type | Enum | | Visible | Yes |
|
| FK | 9 | LanguageId | Language | CustLanguageId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CustLanguageId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | LanguageId | | SaveContents | Yes | | StringSize | 5 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| FK | 10 | WebLogin | Login name | WebLogin | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | WebLogin | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | WebLogin | | SaveContents | Yes | | StringSize | 10 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 11 | SessionId | Session ID | SessionId | Integer | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | SessionId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SessionId | | SaveContents | Yes | | Table | ECPCustSignUp | | Type | Integer | | Visible | Yes |
|
| | 12 | SessionLoginDate | Login date | TransDate | Date | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | TransDate | | GroupPrompt | | | HelpText | @SYS26134 (Login date of the owner of the current transaction.) | | Label | @SYS26012 (Login date) | | Mandatory | No | | Name | SessionLoginDate | | SaveContents | Yes | | Table | ECPCustSignUp | | Type | Date | | Visible | Yes |
|
| | 13 | SessionLoginTime | Login time | timeOfDay | Time | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | timeOfDay | | GroupPrompt | | | HelpText | @SYS26133 (Login time of the owner of the current transaction.) | | Label | @SYS26013 (Login time) | | Mandatory | No | | Name | SessionLoginTime | | SaveContents | Yes | | Table | ECPCustSignUp | | Type | Time | | Visible | Yes |
|
| | 14 | ContactPersonName | User name | ECPContactPersonName | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ECPContactPersonName | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | ContactPersonName | | SaveContents | Yes | | StringSize | 30 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| TR FK | 15 | 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 | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| FK | 16 | 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 | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| TR | 17 | 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 | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| TR | 18 | 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 | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 19 | AccountNum | Customer number | ECPCustAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ECPCustAccount | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AccountNum | | SaveContents | Yes | | StringSize | 10 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 20 | UserEmail | E-mail | ECPUserEmail | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ECPUserEmail | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | UserEmail | | SaveContents | Yes | | StringSize | 80 | | Table | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 21 | GuestLogin | Guest login | ECPGuest | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | ECPGuest | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | GuestLogin | | SaveContents | Yes | | Table | ECPCustSignUp | | Type | Enum | | Visible | Yes |
|
| | 22 | 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 | ECPCustSignUp | | Type | String | | Visible | Yes |
|
| | 23 | 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 | ECPCustSignUp | | 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 | ECPCustSignUp | | Type | Integer | | Visible | Yes |
|