FO_Hub_Definition
This table is used to create a Hub definition.
| Field | Type | Notes |
|---|---|---|
|
Hub_Def_ID |
int |
ID field, a counter. Unique |
|
HubCode |
varchar(50) |
Code for HUB |
|
HubName |
varchar(80) |
Name or description of HUB. Required field. |
|
HubAdd1 |
varchar(80) |
First address line. Informational |
|
HubAdd2 |
varchar(80) |
Second address line. Informational |
|
HubCity |
varchar(50) |
City. Informational |
|
HubState |
varchar(50) |
State. Informational |
|
HubCounty |
varchar(50) |
County. Informational |
|
HubCountry |
varchar(50) |
Country. Informational |
|
HubTel |
varchar(50) |
Phone number. Informational |
|
CreateDate |
datetime |
Date record was created. Informational |
|
EditDate |
datetime |
Date record was last edited. Informational |
|
CreateUser |
varchar(50) |
User who created record. Informational |
|
EditUser |
varchar(50) |
User who last edited record. Informational |
|
ZipCode |
varchar(50) |
Zip code. Informational |