Microvellum Data Dictionary

Microvellum Data Dictionary

Microvellum Data Dictionary Introduction

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.  

Use the links in the Table of Contents to navigate this article more efficiently.

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.

Microvellum Data Dictionary General Information

All tables within Microvellum Databases contain an ID field. This field is a global unique identifier (GUID) which serves as the Primary Key (PK) column for each table.  The ID column should not be used as a primary key to foreign key relationship . Instead, all tables in both the Factory and Work Order Databases contain a LinkID column which acts as the table’s Primary Link Key. All Foreign Link Key columns are named LinkID[Parent Table Name]. An example of this would be the Categories table has a column LinkID (Primary Link Key). The Products table has a column LinkIDCategory (Foreign Link Key).  These two columns serve as the Categories and Products table relation.

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.

Microvellum Common Report Relationships

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.

Specification Groups

This demonstrates the relationships between library and project specification groups and the components that make up a specification group.



Work Order Entities

This relation outlines the relationships between common Work Order Entities.

 



Master Cut Report by Work Order

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:

 

Master Cut Report by Batch

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.

 

Nesting Optimization Report

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:

 

Parts by Processing Station

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:

 

Product Detail Report

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:

 

Product Detail with Image Report

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:

 

Work Order Summary Report

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: 


Microvellum Factory Database Tables

ActivityStations

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

 

Attachment

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

 

AutoCADDrawings

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

 

Categories

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

           

CommonCommandsGrids

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

 

Contacts

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

 

CutPartsFiles

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


DoorLayers

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

 

DoorWizardFiles

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

 

EdgebandFiles

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

 

EmployeeLogin

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


Employees

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

 

EmployeeSecure

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

 

EventLogs

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

 

Factory

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


GeneralContacts

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

 

GlobalFiles

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

 

GlobalImages

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

 

HardwareFiles

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

 

JoinProducts

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

 

LabelSettings

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

 

Layers

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

 

Libraries

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

 

Locations

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


MachiningTokenImages

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

 

Macros

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

 

MaterialRendering

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

 

Materials

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