Table Columns - Intergraph Smart Materials - Version 2020 (10.0) - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
2020 (10.0)

The changes in database table columns are listed in this section.

TABLE_NAME

COLUMN_NAME

Change

M_APPROVAL_TICKETS

PK_ID2

NEW

M_ATTR_SET_DETAILS

ATTR_COLOR

NEW

M_COMMODITY_RULE_DETAILS

TABLE_COLOR

NEW

M_ECO_ACT_STAGING_RAW

COSTACCOUNTID

NEW

M_ECO_ACT_STAGING_RAW

ECOACTRAW_ID

NEW

M_ECO_ACT_STAGING_RAW

ECOSYS_PROJ_ID

NEW

M_ECO_ACT_STAGING_RAW

INT_REV

NEW

M_ECO_ACT_STAGING_RAW

LMOD

NEW

M_ECO_ACT_STAGING_RAW

PROJ_ID

NEW

M_ECO_ACT_STAGING_RAW

USR_ID

NEW

M_ECO_ACT_STAGING_RAW

WBSPATHID

NEW

M_ECO_ACT_STAGINGS

ATTR_NAME

NEW

M_ECO_ACT_STAGINGS

ATTR_VALUE

NEW

M_ECO_ACT_STAGINGS

ECOAST_ID

NEW

M_ECO_ACT_STAGINGS

ECOAST_REC_ID

NEW

M_ECO_ACT_STAGINGS

ECOSYS_PROJ_ID

NEW

M_ECO_ACT_STAGINGS

INT_REV

NEW

M_ECO_ACT_STAGINGS

LMOD

NEW

M_ECO_ACT_STAGINGS

PROJ_ID

NEW

M_ECO_ACT_STAGINGS

USR_ID

NEW

M_ECO_IVC_STAGINGS

COMMITMENTID

NEW

M_ECO_IVC_STAGINGS

COMMODITYCODE

NEW

M_ECO_IVC_STAGINGS

COST

NEW

M_ECO_IVC_STAGINGS

COSTACCOUNTID

NEW

M_ECO_IVC_STAGINGS

CURRENCY

NEW

M_ECO_IVC_STAGINGS

DESCRIPTION

NEW

M_ECO_IVC_STAGINGS

ECOIVC_ID

NEW

M_ECO_IVC_STAGINGS

ECOSYS_PROJ_ID

NEW

M_ECO_IVC_STAGINGS

INT_REV

NEW

M_ECO_IVC_STAGINGS

INVOICENUMBER

NEW

M_ECO_IVC_STAGINGS

INVOICEPAIDDATE

NEW

M_ECO_IVC_STAGINGS

IVC_ID

NEW

M_ECO_IVC_STAGINGS

IVCI_ID

NEW

M_ECO_IVC_STAGINGS

LINEID

NEW

M_ECO_IVC_STAGINGS

LMOD

NEW

M_ECO_IVC_STAGINGS

PROJ_ID

NEW

M_ECO_IVC_STAGINGS

QUANTITY

NEW

M_ECO_IVC_STAGINGS

STATUS

NEW

M_ECO_IVC_STAGINGS

SUPPLIER

NEW

M_ECO_IVC_STAGINGS

TAGNUMBER

NEW

M_ECO_IVC_STAGINGS

UOC_ID

NEW

M_ECO_IVC_STAGINGS

UOM

NEW

M_ECO_IVC_STAGINGS

USR_ID

NEW

M_ECO_IVC_STAGINGS

WBSPATHID

NEW

M_ECO_PO_HEADER_STAGINGS

AGR_STATUS

NEW

M_ECO_PO_HEADER_STAGINGS

APPROVEDDATE

NEW

M_ECO_PO_HEADER_STAGINGS

BUYER

NEW

M_ECO_PO_HEADER_STAGINGS

COMMITMENTID

NEW

M_ECO_PO_HEADER_STAGINGS

COMMITMENTNAME

NEW

M_ECO_PO_HEADER_STAGINGS

CREATEDBY

NEW

M_ECO_PO_HEADER_STAGINGS

ECOPOHDR_ID

NEW

M_ECO_PO_HEADER_STAGINGS

ECOSYS_PROJ_ID

NEW

M_ECO_PO_HEADER_STAGINGS

INT_REV

NEW

M_ECO_PO_HEADER_STAGINGS

JOB_ID

NEW

M_ECO_PO_HEADER_STAGINGS

LMOD

NEW

M_ECO_PO_HEADER_STAGINGS

ORDERTYPE

NEW

M_ECO_PO_HEADER_STAGINGS

PAYMENTTERMS

NEW

M_ECO_PO_HEADER_STAGINGS

PROGRESS

NEW

M_ECO_PO_HEADER_STAGINGS

PROJ_ID

NEW

M_ECO_PO_HEADER_STAGINGS

STATUS

NEW

M_ECO_PO_HEADER_STAGINGS

SUPPLEMENT

NEW

M_ECO_PO_HEADER_STAGINGS

SUPPLEMENTDATE

NEW

M_ECO_PO_HEADER_STAGINGS

SUPPLIERNAME

NEW

M_ECO_PO_HEADER_STAGINGS

TYPEID

NEW

M_ECO_PO_HEADER_STAGINGS

USR_ID

NEW

M_ECO_PO_LI_STAGINGS

ACTUALCOST

NEW

M_ECO_PO_LI_STAGINGS

ACTUALQUANTITY

NEW

M_ECO_PO_LI_STAGINGS

APPROVEDDATE

NEW

M_ECO_PO_LI_STAGINGS

COMMITMENTID

NEW

M_ECO_PO_LI_STAGINGS

COMMODITYCODE

NEW

M_ECO_PO_LI_STAGINGS

COST

NEW

M_ECO_PO_LI_STAGINGS

COSTACCOUNTID

NEW

M_ECO_PO_LI_STAGINGS

CURRENCY

NEW

M_ECO_PO_LI_STAGINGS

DESCRIPTION

NEW

M_ECO_PO_LI_STAGINGS

ECOPOLI_ID

NEW

M_ECO_PO_LI_STAGINGS

ECOSYS_PROJ_ID

NEW

M_ECO_PO_LI_STAGINGS

INSERTREASON

NEW

M_ECO_PO_LI_STAGINGS

INTERNALID

NEW

M_ECO_PO_LI_STAGINGS

INT_REV

NEW

M_ECO_PO_LI_STAGINGS

KEYID

NEW

M_ECO_PO_LI_STAGINGS

LINEID

NEW

M_ECO_PO_LI_STAGINGS

LMOD

NEW

M_ECO_PO_LI_STAGINGS

OTHERCOST

NEW

M_ECO_PO_LI_STAGINGS

PROJ_ID

NEW

M_ECO_PO_LI_STAGINGS

PROMISEDDATE

NEW

M_ECO_PO_LI_STAGINGS

QUANTITY

NEW

M_ECO_PO_LI_STAGINGS

RECTYPE

NEW

M_ECO_PO_LI_STAGINGS

STATUS

NEW

M_ECO_PO_LI_STAGINGS

SUPPLEMENT

NEW

M_ECO_PO_LI_STAGINGS

SUPPLEMENTDATE

NEW

M_ECO_PO_LI_STAGINGS

TAGNUMBER

NEW

M_ECO_PO_LI_STAGINGS

UOM

NEW

M_ECO_PO_LI_STAGINGS

USR_ID

NEW

M_ECO_PO_LI_STAGINGS

WBSPATHID

NEW

M_ECO_REQ_HEADER_STAGINGS

COMMITMENTID

NEW

M_ECO_REQ_HEADER_STAGINGS

COMMITMENTNAME

NEW

M_ECO_REQ_HEADER_STAGINGS

ECOREQHDR_ID

NEW

M_ECO_REQ_HEADER_STAGINGS

ECOSYS_PROJ_ID

NEW

M_ECO_REQ_HEADER_STAGINGS

INT_REV

NEW

M_ECO_REQ_HEADER_STAGINGS

JOB_ID

NEW

M_ECO_REQ_HEADER_STAGINGS

LMOD

NEW

M_ECO_REQ_HEADER_STAGINGS

ORIGIN

NEW

M_ECO_REQ_HEADER_STAGINGS

PROJ_ID

NEW

M_ECO_REQ_HEADER_STAGINGS

REQ_STATUS

NEW

M_ECO_REQ_HEADER_STAGINGS

STATUS

NEW

M_ECO_REQ_HEADER_STAGINGS

SUPPLEMENT

NEW

M_ECO_REQ_HEADER_STAGINGS

SUPPLEMENTDATE

NEW

M_ECO_REQ_HEADER_STAGINGS

TYPEID

NEW

M_ECO_REQ_HEADER_STAGINGS

USR_ID

NEW

M_ECO_REQ_LI_STAGINGS

ACTUALCOST

NEW

M_ECO_REQ_LI_STAGINGS

ACTUALQUANTITY

NEW

M_ECO_REQ_LI_STAGINGS

BASE_RLI_ID

NEW

M_ECO_REQ_LI_STAGINGS

COMMITMENTID

NEW

M_ECO_REQ_LI_STAGINGS

COMMODITYCODE

NEW

M_ECO_REQ_LI_STAGINGS

COST

NEW

M_ECO_REQ_LI_STAGINGS

COSTACCOUNTID

NEW

M_ECO_REQ_LI_STAGINGS

CURRENCY

NEW

M_ECO_REQ_LI_STAGINGS

DESCRIPTION

NEW

M_ECO_REQ_LI_STAGINGS

ECOREQLI_ID

NEW

M_ECO_REQ_LI_STAGINGS

ECOSYS_PROJ_ID

NEW

M_ECO_REQ_LI_STAGINGS

INSERTREASON

NEW

M_ECO_REQ_LI_STAGINGS

INTERNALID

NEW

M_ECO_REQ_LI_STAGINGS

INT_REV

NEW

M_ECO_REQ_LI_STAGINGS

LINEID

NEW

M_ECO_REQ_LI_STAGINGS

LMOD

NEW

M_ECO_REQ_LI_STAGINGS

PROJ_ID

NEW

M_ECO_REQ_LI_STAGINGS

QUANTITY

NEW

M_ECO_REQ_LI_STAGINGS

REQUIREDONSITE

NEW

M_ECO_REQ_LI_STAGINGS

STATUS

NEW

M_ECO_REQ_LI_STAGINGS

SUPPLEMENT

NEW

M_ECO_REQ_LI_STAGINGS

SUPPLEMENTDATE

NEW

M_ECO_REQ_LI_STAGINGS

TAGNUMBER

NEW

M_ECO_REQ_LI_STAGINGS

UOM

NEW

M_ECO_REQ_LI_STAGINGS

USR_ID

NEW

M_ECO_REQ_LI_STAGINGS

WBSPATHID

NEW

M_INQUIRIES

POST_BID_REQ_RETURN_DATE

NEW

M_INQUIRIES

POST_REV_REQ_RETURN_DATE

NEW

M_INSPECTION_LEVEL_DETAILS

DAYS_AFTER

NEW

M_INSPECTION_LEVEL_DETAILS

PREV_ILD_ID

NEW

M_MERGE_COMPANY_JOBS

NC_IND_1

NEW

M_MERGE_COMPANY_JOBS

NC_IND_2

NEW

M_NOTE_COMPANIES

COMPANY_ID

NEW

M_NOTE_COMPANIES

COMPANY_NOTE_CODE

NEW

M_NOTE_COMPANIES

CONTROL_DATE

NEW

M_NOTE_COMPANIES

CONTROL_STATUS

NEW

M_NOTE_COMPANIES

INT_REV

NEW

M_NOTE_COMPANIES

LMOD

NEW

M_NOTE_COMPANIES

NOTE_ID

NEW

M_NOTE_COMPANIES

PROJ_ID

NEW

M_NOTE_COMPANIES

SDB_INFO

NEW

M_NOTE_COMPANIES

USR_ID

NEW

M_NOTE_COMPANY_NLS

COMPANY_ID

NEW

M_NOTE_COMPANY_NLS

DESCRIPTION

NEW

M_NOTE_COMPANY_NLS

INT_REV

NEW

M_NOTE_COMPANY_NLS

LMOD

NEW

M_NOTE_COMPANY_NLS

NLS_ID

NEW

M_NOTE_COMPANY_NLS

NOTE

NEW

M_NOTE_COMPANY_NLS

NOTE_ID

NEW

M_NOTE_COMPANY_NLS

PROJ_ID

NEW

M_NOTE_COMPANY_NLS

SHORT_DESC

NEW

M_NOTE_COMPANY_NLS

USR_ID

NEW

M_NOTE_CONFLICTS_TMP

IDDSI_ID

NEW

M_NOTE_CONFLICTS_TMP

IDDSP_ID

NEW

M_NOTE_CONFLICTS_TMP

IDSA_ID

NEW

M_NOTE_CONFLICTS_TMP

SPEC_HEADER_ID

NEW

M_NOTE_CONFLICTS_TMP

SPEC_ITEM_ID

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE1

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE2

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE3

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE4

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE5

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE6

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE7

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE8

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE9

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE1

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE2

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE3

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE4

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE5

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE6

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE7

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE8

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE9

NEW

M_NOTE_INTERFACE_NLS

DESCRIPTION

NEW

M_NOTE_INTERFACE_NLS

INTERFACE_ID

NEW

M_NOTE_INTERFACE_NLS

INT_REV

NEW

M_NOTE_INTERFACE_NLS

LMOD

NEW

M_NOTE_INTERFACE_NLS

NLS_ID

NEW

M_NOTE_INTERFACE_NLS

NOTE

NEW

M_NOTE_INTERFACE_NLS

NOTE_ID

NEW

M_NOTE_INTERFACE_NLS

PROJ_ID

NEW

M_NOTE_INTERFACE_NLS

SHORT_DESC

NEW

M_NOTE_INTERFACE_NLS

USR_ID

NEW

M_NOTE_INTERFACES

CONTROL_DATE

NEW

M_NOTE_INTERFACES

CONTROL_STATUS

NEW

M_NOTE_INTERFACES

INTERFACE_ID

NEW

M_NOTE_INTERFACES

INTERFACE_NOTE_CODE

NEW

M_NOTE_INTERFACES

INT_REV

NEW

M_NOTE_INTERFACES

LMOD

NEW

M_NOTE_INTERFACES

NOTE_ID

NEW

M_NOTE_INTERFACES

PROJ_ID

NEW

M_NOTE_INTERFACES

SDB_INFO

NEW

M_NOTE_INTERFACES

USR_ID

NEW

M_PACKAGE_ITEM_INVOICES

INT_REV

NEW

M_PACKAGE_ITEM_INVOICES

LMOD

NEW

M_PACKAGE_ITEM_INVOICES

PCKI_ID

NEW

M_PACKAGE_ITEM_INVOICES

PLIN_ID

NEW

M_PACKAGE_ITEM_INVOICES

USR_ID

NEW

M_PACKAGES

TSHIP_ARRIVE_DATE

NEW

M_RELEASE_NOTES

REL_TO_TSHIP_IND

NEW

M_RELN_MIG_CR56113

PROJ_ID

NEW

M_RELN_MIG_CR56113

RELN_ID

NEW

M_RELN_MIG_CR56113

RELN_NUMBER

NEW

M_RELN_MIG_CR56113

REMARKS

NEW

M_SCHEDULED_MAILS

BODY

NEW

M_SCHEDULED_MAILS

CREATED_BY

NEW

M_SCHEDULED_MAILS

CREATED_BY_MAIL

NEW

M_SCHEDULED_MAILS

CREATED_DATE

NEW

M_SCHEDULED_MAILS

DATE_SENT

NEW

M_SCHEDULED_MAILS

DELAY

NEW

M_SCHEDULED_MAILS

EVT_ID

NEW

M_SCHEDULED_MAILS

HASH

NEW

M_SCHEDULED_MAILS

INT_REV

NEW

M_SCHEDULED_MAILS

LMOD

NEW

M_SCHEDULED_MAILS

MINUTES

NEW

M_SCHEDULED_MAILS

PK_ID

NEW

M_SCHEDULED_MAILS

PK_TYPE

NEW

M_SCHEDULED_MAILS

PROJ_ID

NEW

M_SCHEDULED_MAILS

SENT_TO

NEW

M_SCHEDULED_MAILS

SMAIL_ID

NEW

M_SCHEDULED_MAILS

STATUS

NEW

M_SCHEDULED_MAILS

STATUS_TEXT

NEW

M_SCHEDULED_MAILS

SUBJECT

NEW

M_SCHEDULED_MAILS

TRIES

NEW

M_SCHEDULED_MAILS

USR_ID

NEW

M_SPEC_ITEM_TAG_IDENTS_TEMP

IDENT

NEW

M_SPEC_ITEM_TAG_IDENTS_TEMP

PROJ_ID

NEW

M_SPEC_ITEM_TAG_IDENTS_TEMP

SITI_ID

NEW

M_SPEC_ITEM_TAG_IDENTS_TEMP

SPEC_ITEM_ID

NEW

M_SP3D_SHT_CONF_SHT_ATTRS

ATTR_POSITION

NEW

M_SP3D_SHT_CONF_SHT_ATTRS

ORIENTATION

NEW

M_SP3D_SHT_CONF_SHTS

ALT_SHT_NAME

NEW

M_TMP_ADDED_SUPPS

SUP_ID

NEW

M_TMP_SP3D_IMP_SPEC_CONFLICTS

SRD_PIPINGNOTE_VALUE

NEW

M_TMP_SP3D_IMP_SPEC_CONFLICTS

S3D_PIPINGNOTE_VALUE

NEW

M_USED_FILES

PROJ_ID

NEW

M_VENDOR_PROGRESS

APPROVED_BY

NEW

M_VENDOR_PROGRESS

APPROVED_DATE

NEW

M_VENDOR_PROGRESS

INT_REV

NEW

M_VENDOR_PROGRESS

LMOD

NEW

M_VENDOR_PROGRESS

PK_ID

NEW

M_VENDOR_PROGRESS

PK_TYPE

NEW

M_VENDOR_PROGRESS

POH_ID

NEW

M_VENDOR_PROGRESS

READY_FOR_APPROVAL_IND

NEW

M_VENDOR_PROGRESS

USR_ID

NEW

M_VENDOR_PROGRESS

VP_ID

NEW

MW_API_OPEN_INTERFACES

AOI_ID

NEW

MW_API_OPEN_INTERFACES

DESCRIPTION

NEW

MW_API_OPEN_INTERFACES

FILENAME

NEW

MW_API_OPEN_INTERFACES

INTERFACE_DATA

NEW

MW_API_OPEN_INTERFACES

INT_REV

NEW

MW_API_OPEN_INTERFACES

LMOD

NEW

MW_API_OPEN_INTERFACES

PROG_CMD

NEW

MW_API_OPEN_INTERFACES

PROG_ID

NEW

MW_API_OPEN_INTERFACES

PROJ_ID

NEW

MW_API_OPEN_INTERFACES

REC_ID

NEW

MW_API_OPEN_INTERFACES

RESPONSE_DATA

NEW

MW_API_OPEN_INTERFACES

STATUS

NEW

MW_API_OPEN_INTERFACES

TYPE

NEW

MW_API_OPEN_INTERFACES

USR_ID

NEW

MW_API_OPEN_INTERFACES

VERSION

NEW

MW_INSTALL_INFOS

COPYRIGHT_TEXT_1

NEW

MW_INSTALL_INFOS

COPYRIGHT_TEXT_2

NEW

MW_INSTALL_INFOS

FOURTH_NR

NEW

MW_INSTALL_INFOS

INSI_ID

NEW

MW_INSTALL_INFOS

INSI_NAME

NEW

MW_INSTALL_INFOS

INSTALL_DATE

NEW

MW_INSTALL_INFOS

INSTALL_FEEDBACK

NEW

MW_INSTALL_INFOS

INT_REV

NEW

MW_INSTALL_INFOS

LMOD

NEW

MW_INSTALL_INFOS

MAJOR_NR

NEW

MW_INSTALL_INFOS

MARKETING_MAJOR_NR

NEW

MW_INSTALL_INFOS

MARKETING_MINOR_NR

NEW

MW_INSTALL_INFOS

PARENT_INSI_ID

NEW

MW_INSTALL_INFOS

SECOND_NR

NEW

MW_INSTALL_INFOS

SPECIFICATION

NEW

MW_INSTALL_INFOS

THIRD_NR

NEW

MW_INSTALL_INFOS

USR_ID

NEW