table for recording customer information in AFLS.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| clie_addl_address_info* | NVARCHAR (1000) | Additional Customer Address Information |
| clie_address | NVARCHAR (1000) | Customer address information |
| clie_imported_from | NVARCHAR (200) | A field that allows you to identify which system the client has been imported from (e.g. ASDK). |
| clie_is_imported* | BIT | A field that allows you to identify whether the customer has been imported from an external system or if it has been created directly from AFLS. |
| clie_latitude | DECIMAL | Latitude to set the customer’s location |
| clie_longitude | DECIMAL | Length to set the customer’s location |
| clie_unique_reference* | NVARCHAR (510) | Unique customer reference information |
| comp_id | INT | Company ID associated with the customer. |
| user_id* | INT | Primary Table Key |
Primary Key
| PK_AFLS_USERS_CLIENTS |
|---|
| user_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| comp_id | dbo.AFLS_COMPANIES | comp_id | FK01_AFLS_USERS_CLIENTS |