This manual is a guide to the Microvellum Factory and Work Order Databases. This manual has four sections. The first section includes this introduction, and the remainder is General Information about this manual. The second section contains general/common report table definitions and their relationships. The third section contains the table metadata for all tables in both the Microvellum Factory and Work Order Databases. The fouth section contains the descriptive definitions of all Microvellum Type Definitions.
There are several conventions used in this manual. The names of attributes (i.e., columns within tables) and table names appear in Camel Case format where the first letter of each word is capitalized (e.g., ActivityStations, LinkIDCategory). Some attribute descriptions give reference to a Microvellum Type Definitions defined in Section 4 of this manual. An example of this can be found with the UnitType column found in the ActivityStations table. The Description for UnitType is ‘See Process Unit Types’ which can be found in section 4 of this manual.
There are two types of values allowed within the Microvellum Type definitions. The first and most common are simple integer type values (i.e., 0,1, 2, 3, 4). These values are generally consecutive and usually start with 0 (zero). In some cases, consecutive numbers may be missing. The second type of value which is signified with (Bit Flags) in the definition name (e.g., Business Types (Bit Flags)) can either be the single value indicated by its type definitions or a combination of values added together to represent the value made up of multiple values.
An example of Bit Flags usage: Color Types (Bit Flags) {Black = 1, Red = 2, Blue = 4}. If the value stored in the database is a 5, the Type Definition value is Black and Blue.
Important Note: This manual does not contain information about some tables and columns that can be found in both the Factory and Work Order databases. These missing tables and columns are no longer supported by current versions of Microvellum Software and are only available for backward compatibility of older versions of the software.
At times, tables and/or columns will be depreciated and no longer be needed for the software to operate. Again, for backward compatibility, these tables and/or columns will not be removed from the databases but will no longer be documented in this manual.
All table relations, data types, and sizes are subject to change without notice.
This section of the manual provides several common example relationships, many of which are used in the stock Reports provided with the software. There are numerous other stock reports that ship with the software and are not represented in this manual. These relationship examples are meant for illustration purposes only and are subject to change without notice.
Important Note: Many reports contain additional tables that may not be represented in the relationships below. These additional tables are added to the reports to facilitate the need for additional data during report customization.
This demonstrates the relationships between library and project specification groups and the components that make up a specification group.
This relation outlines the relationships between common Work Order Entities.
NOTE: this report does not use data from batch processing
This report groups part data by: 1) Materials.
This report uses data from the following Work Order Tables: Projects, Products, Subassemblies and Parts. The relationships are as follows:
NOTE: this report uses data from batch processing
This report groups part data by: 1) Batch and 2) Materials.
This report is the same as the Master Cut Report by Work Order except for the addition of the Work Order Batches and OptimizationResults tables. The addition of these two tables allows new relationships between the Parts, OptimizationResults and a WorkOrderBatches tables.
NOTE: this report uses data from batch processing
This report is displays each nest layout with the parts being cut.
This report uses data from the following Work Order Tables: WorkOrderBatches, Projects, Products, Parts, OptimizationResults, PlacedSheets, Sheets and MaterialStorageLocations. The relationships are as follows:
NOTE: this report uses data from batch processing
This report groups part data by: 1) Batch and 2) Processing Stations. Parts not processed will show up a the end of the report.
This report uses data from the following Work Order Tables: WorkOrderBatches, Projects, Products, Parts, ProcessingStations and PartsProcessingStations. The relationships are as follows:
NOTE: this report does not use data from batch processing
This report groups data by: 1) Product. It displays a hardware list, subassembly list, and part list for each Product.
This report uses data from the following Work Order Tables: Projects, Products, Subassemblies, Parts, Hardware, Prompts and ProductPrompts. The relationships are as follows:
NOTE: this report does not use data from batch processing
This report groups data by: 1) Product. It displays an isometric image, hardware list, subassembly list, and part list for each Product.
This report uses data from the following Work Order Tables: Projects, Products, Subassemblies, Parts, Hardware, Prompts, ProductPrompts and FaceFrameImages. The relationships are as follows:
NOTE: This report uses data from batch processing
This report groups data by: 1) Room. The second section of the report displays batch sheet summaries along with solid stock, buyout, edgebanding and hardware totals.
This report uses data from the following Work Order Tables: Projects, Products, Subassemblies, Parts, Hardware, Edgebanding, Sheets, PlacedSheets, Prompts, ProductPrompts and OptimizationResults. The relationships are as follows:
Column |
Datatype |
Size |
Nullable |
Description |
Comments |
NVarChar |
255 |
Y |
User supplied comments for item |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LaborRate |
Float |
8 |
Y |
Labor rate for the Activity Station |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDParentStation |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProcessingStation |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
NumberOfEmployeesRequired |
Int |
4 |
Y |
Number of Employees Required |
StationNumber |
Float |
8 |
Y |
Station Number |
UnitsPerMinuteFactoryTime |
Float |
8 |
Y |
Units per minute of Factory time |
UnitType |
Int |
4 |
Y |
See Process Unit Types |
Column |
Datatype |
Size |
Nullable |
Description |
Attachment |
VarBinaryMax |
-1 |
Y |
Attachment Item |
DateCreated |
DateTime |
8 |
Y |
Date when the attachment was created |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDCreator |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDParent |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Notes |
NVarChar |
255 |
Y |
User supplied notes for the Attachment |
Size |
Float |
8 |
Y |
Attachment Size |
Column |
Datatype |
Size |
Nullable |
Description |
Drawing |
VarBinaryMax |
-1 |
Y |
Drawing |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
JPegName |
NVarChar |
255 |
Y |
Picture Name |
JPegStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
TiffName |
NVarChar |
255 |
Y |
Picture Name |
TiffStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
Type |
Int |
4 |
Y |
See Drawing Types |
WMFName |
NVarChar |
255 |
Y |
Picture Name |
WMFStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
CategoryFilter |
Int |
4 |
Y |
Category Filter |
CategoryLevel |
Int |
4 |
Y |
Category Level |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
IsDefault |
Bit |
1 |
Y |
True for Default Category |
IsExpanded |
Bit |
1 |
Y |
UI Element Item |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDParent |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Type |
Int |
4 |
Y |
See Category Types |
Visible |
Bit |
1 |
Y |
UI Element Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
WorkBook |
VarBinaryMax |
-1 |
Y |
Work Book BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
Age |
Int |
4 |
Y |
Age |
Anniversary |
DateTime |
8 |
Y |
Anniversary |
Birthday |
DateTime |
8 |
Y |
Birthday |
CellPhone |
NVarChar |
255 |
Y |
Cell Phone Number |
City |
NVarChar |
255 |
Y |
City |
Comments |
NVarChar |
255 |
Y |
User supplied comments for item |
Country |
NVarChar |
255 |
Y |
Country |
DateFirstContact |
DateTime |
8 |
Y |
Date First Contact |
Department |
NVarChar |
255 |
Y |
Department |
EmailDefault |
NVarChar |
255 |
Y |
Default email address |
FaxDefault |
NVarChar |
255 |
Y |
Default Fax Number |
FirstName |
NVarChar |
255 |
Y |
First Name |
HomePhone |
NVarChar |
255 |
Y |
Home Phone Number |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
JPegName |
NVarChar |
255 |
Y |
Picture Name |
JPegStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
LastName |
NVarChar |
255 |
Y |
Last Name |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDCompany |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
MailCity |
NVarChar |
255 |
Y |
Mail City |
MailCountry |
NVarChar |
255 |
Y |
Mail Country |
MailPOBox |
NVarChar |
255 |
Y |
Mail PO Box |
MailState |
NVarChar |
255 |
Y |
Mail State |
MailStreet |
NVarChar |
255 |
Y |
Mail Street |
MailZipCode |
NVarChar |
255 |
Y |
Mail Zip Code |
ManagerName |
NVarChar |
255 |
Y |
Manager Name |
MiddleName |
NVarChar |
255 |
Y |
Middle Name |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
NameNickname |
NVarChar |
255 |
Y |
Nickname |
NamePartner |
NVarChar |
255 |
Y |
Partner's Name |
NameSuffix |
NVarChar |
255 |
Y |
Suffix |
Office |
NVarChar |
255 |
Y |
Office |
OtherAddressStreet |
NVarChar |
255 |
Y |
Other Address Street |
PhoneDefault |
NVarChar |
255 |
Y |
Default Phone |
POBox |
NVarChar |
255 |
Y |
PO Box |
Profession |
NVarChar |
255 |
Y |
Profession |
RestrictAccess |
NVarChar |
255 |
Y |
Restrict Access |
Salutation |
NVarChar |
255 |
Y |
Salutation |
State |
NVarChar |
255 |
Y |
State |
Street |
NVarChar |
255 |
Y |
Street |
TiffName |
NVarChar |
255 |
Y |
Picture Name |
TiffStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
Title |
NVarChar |
255 |
Y |
Title |
Type |
Int |
4 |
Y |
See Company/Contact Types |
WebSiteDefault |
NVarChar |
255 |
Y |
Web Site Address |
WMFName |
NVarChar |
255 |
Y |
Picture Name |
WMFStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
ZipCode |
NVarChar |
255 |
Y |
Zip Code |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProject |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Type |
Int |
4 |
Y |
See Product Use Types |
WorkBook |
VarBinaryMax |
-1 |
Y |
Workbook BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProject |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Type |
Int |
4 |
Y |
See Product Use Types |
WorkBook |
VarBinaryMax |
-1 |
Y |
Work Book BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProject |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Type |
Int |
4 |
Y |
See Product Use Types |
WorkBook |
VarBinaryMax |
-1 |
Y |
Workbook BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
AllowLogin |
Bit |
1 |
Y |
Allow employee login |
AllowSecurityByPass |
Bit |
1 |
Y |
Allow Security By Pass |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Column |
Datatype |
Size |
Nullable |
Description |
Age |
Int |
4 |
Y |
Age |
Anniversary |
DateTime |
8 |
Y |
Anniversary |
Birthday |
DateTime |
8 |
Y |
Birthday |
CellPhone |
NVarChar |
255 |
Y |
Cell Phone Number |
City |
NVarChar |
255 |
Y |
City |
Comments |
NVarChar |
255 |
Y |
User supplied comments for item |
Country |
NVarChar |
255 |
Y |
Country |
DateFirstContact |
DateTime |
8 |
Y |
Date First Contact |
Department |
NVarChar |
255 |
Y |
Department |
Department1Efficiency |
Float |
8 |
Y |
Department 1 Efficiency |
Department1HoursAllocation |
Float |
8 |
Y |
Department 1 Hours Allocation |
Department2Efficiency |
Float |
8 |
Y |
Department 2 Efficiency |
Department2HoursAllocation |
Float |
8 |
Y |
Department 2 Hours Allocation |
Department3Efficiency |
Float |
8 |
Y |
Department 3 Efficiency |
Department3HoursAllocation |
Float |
8 |
Y |
Department 3 Hours Allocation |
EmailDefault |
NVarChar |
255 |
Y |
Email Default |
FaxDefault |
NVarChar |
255 |
Y |
Fax Default |
FirstName |
NVarChar |
255 |
Y |
First Name |
HomePhone |
NVarChar |
255 |
Y |
Home Phone |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
JPegName |
NVarChar |
255 |
Y |
Picture Name |
JPegStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
LastName |
NVarChar |
255 |
Y |
Last Name |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDActivityStation |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDCompany |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDPrimaryDepartment |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDSecondaryDepartment |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDSecondaryShift |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDShift |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDTertiaryDepartment |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDTertiaryShift |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
MailCity |
NVarChar |
255 |
Y |
Mail City |
MailCountry |
NVarChar |
255 |
Y |
Mail Country |
MailPOBox |
NVarChar |
255 |
Y |
Mail PO Box |
MailState |
NVarChar |
255 |
Y |
Mail State |
MailStreet |
NVarChar |
255 |
Y |
Mail Street |
MailZipCode |
NVarChar |
255 |
Y |
Mail Zip Code |
ManagerName |
NVarChar |
255 |
Y |
Manager Name |
MiddleName |
NVarChar |
255 |
Y |
Middle Name |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
NameNickname |
NVarChar |
255 |
Y |
Name Nickname |
NamePartner |
NVarChar |
255 |
Y |
Name Partner |
NameSuffix |
NVarChar |
255 |
Y |
Name Suffix |
Office |
NVarChar |
255 |
Y |
Office |
OtherAddressStreet |
NVarChar |
255 |
Y |
Other Address Street |
PhoneDefault |
NVarChar |
255 |
Y |
Phone Default |
POBox |
NVarChar |
255 |
Y |
POBox |
Profession |
NVarChar |
255 |
Y |
Profession |
RestrictAccess |
NVarChar |
255 |
Y |
Restrict Access |
Salutation |
NVarChar |
255 |
Y |
Salutation |
State |
NVarChar |
255 |
Y |
State |
Street |
NVarChar |
255 |
Y |
Street |
TiffName |
NVarChar |
255 |
Y |
Picture Name |
TiffStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
Title |
NVarChar |
255 |
Y |
Title |
Type |
Int |
4 |
Y |
See Company/Contact Types |
WebSiteDefault |
NVarChar |
255 |
Y |
Default Web Site Address |
WMFName |
NVarChar |
255 |
Y |
Picture Name |
WMFStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
ZipCode |
NVarChar |
255 |
Y |
Zip Code |
Column |
Datatype |
Size |
Nullable |
Description |
AllowAccessLibraryDesigner |
Bit |
1 |
Y |
Allow Access Library Designer |
AllowAccesstoDatabaseExplorer |
Bit |
1 |
Y |
Allow Access to Database Explorer |
AllowAccesstoDatabaseUtilities |
Bit |
1 |
Y |
Allow Access to Database Utilities |
AllowAccesstoTransferTables |
Bit |
1 |
Y |
Allow Access to Transfer Tables |
AllowAddProjectComponentFromTemplate |
Bit |
1 |
Y |
Allow Add Project Component from Template |
AllowAssignComponentToProjectSpecGroup |
Bit |
1 |
Y |
Allow Assign Component to Project Spec Group |
AllowAssignComponentToTemplateSpecGroup |
Bit |
1 |
Y |
Allow Assign Component to Template Spec Group |
AllowCompanyManagement |
Bit |
1 |
Y |
Allow Company Management |
AllowCopyProjectComponent |
Bit |
1 |
Y |
Allow Copy Project Component |
AllowCopyProjectSpecGroup |
Bit |
1 |
Y |
Allow Copy Project Spec Group |
AllowCopyTemplateComponent |
Bit |
1 |
Y |
Allow Copy Template Component |
AllowCopyTemplateSpecGroup |
Bit |
1 |
Y |
Allow Copy Template Spec Group |
AllowDBUExport |
Bit |
1 |
Y |
Allow DBU Export |
AllowDBUExportAndDelete |
Bit |
1 |
Y |
Allow DBU Export and Delete |
AllowDBUImport |
Bit |
1 |
Y |
Allow DBU Import |
AllowDBUImportAndOverwrite |
Bit |
1 |
Y |
Allow DBU Import and Overwrite |
AllowDeleteProjectComponent |
Bit |
1 |
Y |
Allow Delete Project Component |
AllowDeleteProjectSpecificationGroup |
Bit |
1 |
Y |
Allow Delete Project Specification Group |
AllowDeleteTemplateComponent |
Bit |
1 |
Y |
Allow Delete Template Component |
AllowDeleteTemplateSpecificationGroup |
Bit |
1 |
Y |
Allow Delete Template Specification Group |
AllowEditTimeClock |
Bit |
1 |
Y |
Allow Edit Time Clock |
AllowEstimating |
Bit |
1 |
Y |
Allow Estimating |
AllowEventLogArchive |
Bit |
1 |
Y |
Allow Event Log Archive |
AllowEventLogDelete |
Bit |
1 |
Y |
Allow Event Log Delete |
AllowImportData |
Bit |
1 |
Y |
Allow Import Data |
AllowImportProjectSpecGroup |
Bit |
1 |
Y |
Allow Import Project Spec Group |
AllowOptionsData |
Bit |
1 |
Y |
Allow Options Data |
AllowOptionsGeneral |
Bit |
1 |
Y |
Allow Options General |
AllowOptionsMachining |
Bit |
1 |
Y |
Allow Options Machining |
AllowProcessingStationManagement |
Bit |
1 |
Y |
Allow Processing Station Management |
AllowProduction |
Bit |
1 |
Y |
Allow Production |
AllowProjectCutPartWizard |
Bit |
1 |
Y |
Allow Project Cut Part Wizard |
AllowProjectDelete |
Int |
4 |
Y |
Allow Project Delete |
AllowProjectDoorWizard |
Bit |
1 |
Y |
Allow Project Door Wizard |
AllowProjectEdgeBandWizard |
Bit |
1 |
Y |
Allow Project Edge Band Wizard |
AllowProjectGlobals |
Bit |
1 |
Y |
Allow Project Globals |
AllowProjectHardwareWizard |
Bit |
1 |
Y |
Allow Project Hardware Wizard |
AllowProjectMaterials |
Bit |
1 |
Y |
Allow Project Materials |
AllowProjectWizard |
Bit |
1 |
Y |
Allow Project Wizard |
AllowProjectWorkBookDesigner |
Bit |
1 |
Y |
Allow Project Workbook Designer |
AllowPurchasing |
Bit |
1 |
Y |
Allow Purchasing |
AllowRenameProjectomponent |
Bit |
1 |
Y |
Allow Rename Project Component |
AllowRenameProjectSpecGroup |
Bit |
1 |
Y |
Allow Rename Project Spec Group |
AllowRenameTemplateComponent |
Bit |
1 |
Y |
Allow Rename Template Component |
AllowRenameTemplateSpecGroup |
Bit |
1 |
Y |
Allow Rename Template Spec Group |
AllowReportDesigner |
Bit |
1 |
Y |
Allow Report Designer |
AllowRevertProjectComponent |
Bit |
1 |
Y |
Allow Revert Project Component |
AllowSaveProductstoLibrary |
Bit |
1 |
Y |
Allow Save Products to Library |
AllowSaveProjectComponentToTemplate |
Bit |
1 |
Y |
Allow Save Project Component To Template |
AllowSaveProjectSpecificationGroupToTemplate |
Bit |
1 |
Y |
Allow Save Project Specification Group To Template |
AllowSaveSpecificationGroupstoTemplate |
Bit |
1 |
Y |
Allow Save Specification Groups to Template |
AllowSaveSubassembliestoLibrary |
Bit |
1 |
Y |
Allow Save Subassemblies to Library |
AllowScheduling |
Bit |
1 |
Y |
Allow Scheduling |
AllowSetup |
Bit |
1 |
Y |
Allow Setup |
AllowTemplateCutPartWizard |
Bit |
1 |
Y |
Allow Template Cut Part Wizard |
AllowTemplateDoorWizard |
Bit |
1 |
Y |
Allow Template Door Wizard |
AllowTemplateEdgeBandWizard |
Bit |
1 |
Y |
Allow Template Edge Band Wizard |
AllowTemplateGlobals |
Bit |
1 |
Y |
Allow Template Globals |
AllowTemplateHardwareWizard |
Bit |
1 |
Y |
Allow Template Hardware Wizard |
AllowTemplateMaterials |
Bit |
1 |
Y |
Allow Template Materials |
AllowTemplateProjectWizard |
Bit |
1 |
Y |
Allow Template Project Wizard |
AllowTemplateWorkBookDesigner |
Bit |
1 |
Y |
Allow Template Workbook Designer |
AllowToolFileManagement |
Bit |
1 |
Y |
Allow Tool File Management |
AllowUpdates |
Bit |
1 |
Y |
Allow Updates |
AllowWorkOrderModify |
Bit |
1 |
Y |
Allow Work Order Modify |
EmployeePassword |
NVarChar |
255 |
Y |
Employee Password |
HourlyPay |
Float |
8 |
Y |
Hourly Pay |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDEmployee |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
MmAlertSettings |
Int |
4 |
Y |
MM Alert Settings |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
SoftwareSecurityType |
Int |
4 |
Y |
See Software Security Types |
SSNumber |
NVarChar |
255 |
Y |
SS Number |
WebSupportRolls |
Int |
4 |
Y |
Web Support Rolls |
Column |
Datatype |
Size |
Nullable |
Description |
AlertType |
Int |
4 |
Y |
See Event Log Alert Types |
Archived |
Bit |
1 |
Y |
Archived |
DateTime |
DateTime |
8 |
Y |
Date Time |
Description |
NVarChar |
255 |
Y |
Description |
EventType |
Int |
4 |
Y |
See Event Log Types |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
InnerMessage |
NVarCharMax |
-1 |
Y |
Secondary error message |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDGrandParent |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDParent |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
MachineName |
NVarChar |
255 |
Y |
Machine Name |
Message |
NVarCharMax |
-1 |
Y |
Message |
SeverityLevel |
Int |
4 |
Y |
See Event Log Severity Levels |
Source |
Int |
4 |
Y |
See Event Log Sources |
StackTrace |
NVarCharMax |
-1 |
Y |
Error stack trace |
User |
NVarChar |
255 |
Y |
Username |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProject |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Type |
Int |
4 |
Y |
See Product Use Types |
WorkBook |
VarBinaryMax |
-1 |
Y |
Workbook BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
CellPhone |
NVarChar |
255 |
Y |
Cell Phone |
City |
NVarChar |
255 |
Y |
City |
Comments |
NVarChar |
255 |
Y |
User supplied comments for item |
Country |
NVarChar |
255 |
Y |
Country |
EmailDefault |
NVarChar |
255 |
Y |
Email Default |
FaxDefault |
NVarChar |
255 |
Y |
Fax Default |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDPrimaryContact |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
MailCity |
NVarChar |
255 |
Y |
Mail City |
MailCountry |
NVarChar |
255 |
Y |
Mail Country |
MailPOBox |
NVarChar |
255 |
Y |
Mail PO Box |
MailState |
NVarChar |
255 |
Y |
Mail State |
MailStreet |
NVarChar |
255 |
Y |
Mail Street |
MailZipCode |
NVarChar |
255 |
Y |
Mail Zip Code |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
OrderPrefix |
NVarChar |
255 |
Y |
Order Prefix |
PhoneDefault |
NVarChar |
255 |
Y |
Phone Default |
POBox |
NVarChar |
255 |
Y |
POBox |
State |
NVarChar |
255 |
Y |
State |
Street |
NVarChar |
255 |
Y |
Street |
Type |
Int |
4 |
Y |
See Company/Contact Types |
WebSiteDefault |
NVarChar |
255 |
Y |
Web Site Default |
ZipCode |
NVarChar |
255 |
Y |
Zip Code |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProject |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Type |
Int |
4 |
Y |
See Product Use Types |
WorkBook |
VarBinaryMax |
-1 |
Y |
Work Book BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
JPegName |
NVarChar |
255 |
Y |
Picture Name |
JPegStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
TiffName |
NVarChar |
255 |
Y |
Picture Name |
TiffStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
WMFName |
NVarChar |
255 |
Y |
Picture Name |
WMFStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProject |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Type |
Int |
4 |
Y |
See Product Use Types |
WorkBook |
VarBinaryMax |
-1 |
Y |
Work Book BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLibrary |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
ProductStarterName |
NVarChar |
255 |
Y |
Product Starter Name |
SubassemblyName |
NVarChar |
255 |
Y |
Subassembly Name |
Column |
Datatype |
Size |
Nullable |
Description |
AllowRotation |
Bit |
1 |
Y |
Allow Rotation |
CenterDeviation |
Float |
8 |
Y |
Center Deviation |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LabelPrinterHeadOrientation |
Int |
4 |
Y |
Label Printer Head Orientation |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
MarginBorder |
Float |
8 |
Y |
Margin Border |
MarginMachining |
Float |
8 |
Y |
Margin Machining |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
PlacementType |
Int |
4 |
Y |
See Label Placement Types |
ShowLocationsInNest |
Bit |
1 |
Y |
Show Locations In Nest |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
PartName |
NVarChar |
255 |
Y |
Part Name |
RenderLayerType |
Int |
4 |
Y |
See Render Layer Types |
SavedGroupName |
NVarChar |
255 |
Y |
Saved Group Name |
SavedRenderMaterialName |
NVarChar |
255 |
Y |
Saved Render Material Name |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDTemplate |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
Type |
Int |
4 |
Y |
See Product Use Types |
Column |
Datatype |
Size |
Nullable |
Description |
CategoryLevel |
Int |
4 |
Y |
Category Level |
DesignFileSyncDate |
DateTime |
8 |
Y |
Design File Sync Date |
DrawingName |
NVarChar |
255 |
Y |
Drawing Name |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
JPegName |
NVarChar |
255 |
Y |
Picture Name |
JPegStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLocation |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDLocationCopy |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProject |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
PrintFlag |
Bit |
1 |
Y |
Print Flag |
TiffName |
NVarChar |
255 |
Y |
Picture Name |
TiffStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
WMFName |
NVarChar |
255 |
Y |
Picture Name |
WMFStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
JPegName |
NVarChar |
255 |
Y |
Picture Name |
JPegStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
TiffName |
NVarChar |
255 |
Y |
Picture Name |
TiffStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
WMFName |
NVarChar |
255 |
Y |
Picture Name |
WMFStream |
VarBinaryMax |
-1 |
Y |
Picture BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
WorkBook |
VarBinaryMax |
-1 |
Y |
Workbook BLOB Item |
Column |
Datatype |
Size |
Nullable |
Description |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
PictureName |
NVarChar |
255 |
Y |
Picture Name |
RGBNumber |
NVarChar |
255 |
Y |
RGB Number |
Column |
Datatype |
Size |
Nullable |
Description |
AssociativeDrawingName |
NVarChar |
255 |
Y |
Associative Drawing Name |
AssociativeDrawingNameFormula |
NVarChar |
255 |
Y |
Associative Drawing Name Formula |
Cloneable |
Bit |
1 |
Y |
Cloneable |
Code |
NVarChar |
255 |
Y |
Code |
CodeFormula |
VarCharMax |
-1 |
Y |
Code Formula |
Comments |
NVarChar |
255 |
Y |
User supplied comments for item |
CustomSizeAdjustment |
Float |
8 |
Y |
Custom Size Adjustment |
CustomSizeAdjustmentFormula |
VarCharMax |
-1 |
Y |
Custom Size Adjustment Formula |
ElvBlockFileName |
NVarChar |
255 |
Y |
Elv Block File Name |
ElvBlockFileNameFormula |
NVarChar |
255 |
Y |
Elv Block File Name Formula |
FormulaMaterialAlias |
NVarChar |
255 |
Y |
Formula Material Alias |
Grain |
Int |
4 |
Y |
See Grain Direction Types |
GrainFormula |
VarCharMax |
-1 |
Y |
Grain Formula |
HandlingCode |
NVarChar |
255 |
Y |
Handling Code |
HandlingCodeFormula |
VarCharMax |
-1 |
Y |
Handling Code Formula |
HatchName |
NVarChar |
255 |
Y |
Hatch Name |
HatchType |
Int |
4 |
Y |
See Hatch Types |
ID |
UniqueIdentifier |
16 |
N |
PK - Unique ID Auto Generated |
InventoryAvailableQty |
Float |
8 |
Y |
Inventory Available Qty |
InventoryCurrentQty |
Float |
8 |
Y |
Inventory Current Qty |
InventoryMinQty |
Float |
8 |
Y |
Inventory Min Qty |
InventoryValue |
Float |
8 |
Y |
Inventory Value |
IsFormulaMaterial |
Bit |
1 |
Y |
Is Formula Material |
LinkID |
NVarChar |
255 |
Y |
Microvellum Primary Link Key |
LinkIDBottomFaceRendering |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDCategory |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDCoreRendering |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDDefaultVendor |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDMaterialStorageLocation |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDProject |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDSheetSize |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
LinkIDTopFaceRendering |
NVarChar |
255 |
Y |
Microvellum Foreign Link Key |
MarkUp |
Float |
8 |
Y |
Mark Up |
MarkUpFormula |
VarCharMax |
-1 |
Y |
Mark Up Formula |
MaterialCommentsFormula |
VarCharMax |
-1 |
Y |
Material Comments Formula |
MaterialEstimateCost |
Float |
8 |
Y |
Material Estimate Cost |
MaterialEstimateCostFormula |
VarCharMax |
-1 |
Y |
Material Estimate Cost Formula |
MaterialFlipSetting |
Int |
4 |
Y |
Material Flip Setting |
MaterialLaborValue |
Float |
8 |
Y |
Material Labor Value |
MaterialLaborValueFormula |
VarCharMax |
-1 |
Y |
Material Labor Value Formula |
MaterialXData1 |
VarCharMax |
-1 |
Y |
Material XData1 |
MaterialXData1Formula |
VarCharMax |
-1 |
Y |
Material XData1 Formula |
MaterialXData2 |
VarCharMax |
-1 |
Y |
Material XData2 |
MaterialXData2Formula |
VarCharMax |
-1 |
Y |
Material XData2 Formula |
MaterialXData3 |
VarCharMax |
-1 |
Y |
Material XData3 |
MaterialXData3Formula |
VarCharMax |
-1 |
Y |
Material XData3 Formula |
Modified |
Bit |
1 |
Y |
True if the item has been modified |
Name |
NVarChar |
255 |
Y |
User supplied Name for the item |
NameFormula |
VarCharMax |
-1 |
Y |
Name Formula |
NonassociativeDrawingName |
NVarChar |
255 |
Y |
Non associative Drawing Name |
NonassociativeDrawingNameFormula |
NVarChar |
255 |
Y |
Non associative Drawing Name Formula |
Quantity |
Float |
8 |
Y |
Quantity |
Region |
Int |
4 |
Y |
See Material Regions |
SkipSpreadsheetSync |
Bit |
1 |
Y |
Skip Spreadsheet Sync |
StandardPrice |
Float |
8 |
Y |
Standard Price |
Thickness |
Float |
8 |
Y |
Thickness |
ThicknessFormula |
VarCharMax |
-1 |
Y |
Thickness Formula |
Type |
Int |