The BranchOptions table stores information about the Host and Remote Offices. This information includes Company Name, Site code, Address ID, telephone numbers, and paths to attachments and library documents. This information is entered using the Administrator.
Table Relationships
The BranchOptions table has a (Zero or One) to (Many) relationship with the SLXWEBSERVER table.
|
|
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
SITECODE(PK) (FK) |
STANDARDID(12) |
NOT NULL |
BRANCHOPTIONS_SITECODE_PK (CA) |
|
COMPANY |
varchar(64) |
NULLS |
|
|
DIVISION |
varchar(64) |
NULLS |
|
|
ADDRESSID (FK) |
STANDARDID(12) |
NULLS |
|
|
SHIPPINGID (FK) |
STANDARDID(12) |
NULLS |
|
|
MAINPHONE |
varchar(32) |
NULLS |
|
|
ALTERNATEPHONE |
varchar(32) |
NULLS |
|
|
FAX |
varchar(32) |
NULLS |
|
|
TOLLFREE |
varchar(32) |
NULLS |
|
|
ATTACHMENTPATH |
varchar(255) |
NULLS |
|
|
SALESLIBRARYPATH |
varchar(255) |
NULLS |
|
|
DATA |
DATABLOB |
NULLS |
|
|
ACCOUNTASSIGNMENT |
BOOLEAN |
NULLS |
|
|
ASSIGNMENTTYPE |
varchar(80) |
NULLS |
|
|
COEMAILATTACH |
BOOLEAN |
NULLS |
|
|
ENDTIMEMINUTES |
int(4) |
NULLS |
|
|
OPENWEEKEND |
BOOLEAN |
NULLS |
|
|
SERIALNO |
varchar(80) |
NULLS |
|
|
STARTTIMEMINUTES |
int (4) |
NULLS |
|
|
TIMEUNITS |
float(8) |
NULLS |
|
|
DEFAULTPUBLICACCESS |
char(12) |
NULLS |
|
|
USEAPPROVALPROCESS |
char(1) |
NULLS |
|
|
LICNUM |
varchar(32) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|