Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Client ID | int | 4 | √ | null |
|
|
||
| Client Name | varchar | 200 | √ | null |
|
|
||
| Facility Number | varchar | 20 | √ | null |
|
|
||
| Client Number | varchar | 20 | √ | null |
|
|
||
| Customer Type | varchar | 100 | √ | null |
|
|
||
| Master Client ID | varchar | 50 | √ | null |
|
|
||
| Address | varchar | 200 | √ | null |
|
|
||
| Address 2 | varchar | 200 | √ | null |
|
|
||
| City | varchar | 100 | √ | null |
|
|
||
| State | varchar | 20 | √ | null |
|
|
||
| Zip | varchar | 20 | √ | null |
|
|
||
| County | varchar | 50 | √ | null |
|
|
||
| Notes | varchar | 4000 | √ | null |
|
|
||
| Notes 2 | varchar | 4000 | √ | null |
|
|
||
| Billing Notes | varchar | 4000 | √ | null |
|
|
||
| Main Phone | varchar | 20 | √ | null |
|
|
||
| Main Fax | varchar | 20 | √ | null |
|
|
||
| Invoice Terms | varchar | 20 | √ | null |
|
|
||
| Invoice PO Number | varchar | 20 | √ | null |
|
|
||
| Num Beds | varchar | 20 | √ | null |
|
|
||
| Date/Time Created | varchar | 50 | √ | null |
|
|
||
| Date/Time Modified | varchar | 50 | √ | null |
|
|
||
| Sales Rep | varchar | 50 | √ | null |
|
|
||
| Region | int | 4 | √ | null |
|
|
||
| Status | varchar | 50 | √ | null |
|
|
||
| Client Type | varchar | 50 | √ | null |
|
|
||
| Website | varchar | 200 | √ | null |
|
|
||
| Staffing Specialist | varchar | 200 | √ | null |
|
|
||
| Referral Source ID | varchar | 50 | √ | null |
|
|
||
| Referred By Name | varchar | 200 | √ | null |
|
|
||
| AVA_insdate | datetime2 | 16 | √ | (getdate()) |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors