Table Structures for EXPOCAD
These are the tables and fields involved in EXPOCAD:
Expo_Control
Stored in System_Params where ParameterName = Expo_Control. Additional fields have been added to the Expo_Control table. These fields will be used in the Expo System Setup window.
| Column Name | Data Type/Size | Description |
|---|---|---|
| UseQtyOrSqrFt | Boolean | 0 if using Quantity 1 if using Area (Square Units) |
| ImportRunning | Boolean | 1 if import is running |
ExpoCad_Prod
Stores the product mapping between EXPOCAD and iMIS.
| Column Name | Data Type/Size | Description |
|---|---|---|
| MEET\_ID | Char(10) | Event in EXPOCAD Exposition code in *iMIS* |
| ExpoCad\_Type | Char(40) | Booth Type in EXPOCAD Island, Peninsula, Corner, Inline, Custom and Aisle Booth |
| Product\_Code | Char(31) | Exposition ‘Booth’ product code |
| Premium\_1 | Char(31) | Exposition ‘Other’ or ‘Paid Pass’ product code |
| Qty\_1 | Numeric | Quantity for Premium\_1 |
| Premium\_2 | Char(31) | Exposition ‘Other’ or ‘Paid Pass’ product code |
| Qty\_2 | Numeric | Quantity for Premium\_2 |
Meet_Master
Additional field has been added.
| Column Name | Data Type/Size | Description |
|---|---|---|
| Meet\_Category | Numeric | 0 if *iMIS* exposition 1 if EXPOCAD exposition |
Exhb_Booth
Additional field has been added.
| Column Name | Data Type/Size | Description |
|---|---|---|
| Booth\_Type | Char(40) | Stores the Booth Type from EXPOCAD |
EXPOCAD: ExpoCadExp
A FoxPro database file created when an event in EXPOCAD is initially setup.
| Column Name | Data Type/Size | Description |
|---|---|---|
| Count\_Val | Numeric(18) | Value of the current counter. Equal to 0 when Proc\_Desc =’iMISCounter’ |
| UniqueID | Numeric(18) | Unique ID generated from the increment of Count\_Val |
| Orig\_Booth | Char(20) | Original Booth Number |
| New\_Booth | Char(20) | New Booth Number |
| Booth\_Size | Numeric(18) | Size of booth in square units |
| Booth\_Type | Char(40) | Booth Type in EXPOCAD Island, Peninsula, Corner, Inline, Custom and ab |
| Exhb\_ID | Char(20) | Exhibitor ID |
| Event\_Name | Char(20) | Event name in EXPOCAD Exposition name in *iMIS* |
| Proc\_Desc | Char(100) | Description of EXPOCAD activity ‘Rent Booth’,’Unrent Booth’,’Booth Num Change’,’Booth Class Change’, and ‘iMISCounter’ |
| Insert\_Dat | Char(22) | Date record was added in EXPOCAD stored in CCYYMMDD HH:MM:SS format |
| Retrv\_By | Char(100) | Upon successful import, stores the UserID+RetrieveDate, marking that line for deletion. If the record fails the import, stores FAIL\_UserID+RetrieveDate |