FO_InsAdds
This table contains the address for each insurance code.
Each insurance code has one address.
| Field | Type | Notes |
|---|---|---|
|
InsAdd_ID |
int |
ID field, a counter. Unique |
|
InsCode |
varchar(50) |
Insurance code. Enter a valid insurance code. |
|
Ins_Name |
varchar(50) |
Insurance name for address. |
|
Add1 |
varchar(80) |
First address line. |
|
Add2 |
varchar(80) |
Second address line. |
|
City |
varchar(50) |
City |
|
St |
varchar(50) |
State |
|
ZipCode |
varchar(50) |
Zip code |
|
Tel |
varchar(50) |
Phone number |
|
DisplayKey |
varchar(100) |
Informational |
|
UserName |
varchar(50) |
Name of user who created the record. Informational |
|
CreateDate |
datetime |
Date record was created. Informational |
|
EditDate |
datetime |
Date record was last edited. Informational |