Table Columns Length - 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 column length are listed in this section.

TABLE_NAME

COLUMN_NAME

DATA_TYPE

LENGTH

Change

M_APPROVAL_TICKETS

PK_ID2

NUMBER

22

NEW

M_ATTR_SET_DETAILS

ATTR_COLOR

VARCHAR2

11

NEW

M_COMMODITY_RULE_DETAILS

TABLE_COLOR

VARCHAR2

11

NEW

M_ECO_ACT_STAGING_RAW

COSTACCOUNTID

VARCHAR2

100

NEW

M_ECO_ACT_STAGING_RAW

ECOACTRAW_ID

NUMBER

22

NEW

M_ECO_ACT_STAGING_RAW

ECOSYS_PROJ_ID

VARCHAR2

200

NEW

M_ECO_ACT_STAGING_RAW

INT_REV

NUMBER

22

NEW

M_ECO_ACT_STAGING_RAW

LMOD

DATE

7

NEW

M_ECO_ACT_STAGING_RAW

PROJ_ID

VARCHAR2

10

NEW

M_ECO_ACT_STAGING_RAW

USR_ID

VARCHAR2

10

NEW

M_ECO_ACT_STAGING_RAW

WBSPATHID

VARCHAR2

100

NEW

M_ECO_ACT_STAGINGS

ATTR_NAME

VARCHAR2

60

NEW

M_ECO_ACT_STAGINGS

ATTR_VALUE

VARCHAR2

4000

NEW

M_ECO_ACT_STAGINGS

ECOAST_ID

NUMBER

22

NEW

M_ECO_ACT_STAGINGS

ECOAST_REC_ID

NUMBER

22

NEW

M_ECO_ACT_STAGINGS

ECOSYS_PROJ_ID

VARCHAR2

200

NEW

M_ECO_ACT_STAGINGS

INT_REV

NUMBER

22

NEW

M_ECO_ACT_STAGINGS

LMOD

DATE

7

NEW

M_ECO_ACT_STAGINGS

PROJ_ID

VARCHAR2

10

NEW

M_ECO_ACT_STAGINGS

USR_ID

VARCHAR2

10

NEW

M_ECO_IVC_STAGINGS

COMMITMENTID

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

COMMODITYCODE

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

COST

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

COSTACCOUNTID

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

CURRENCY

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

DESCRIPTION

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

ECOIVC_ID

NUMBER

22

NEW

M_ECO_IVC_STAGINGS

ECOSYS_PROJ_ID

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

INT_REV

NUMBER

22

NEW

M_ECO_IVC_STAGINGS

INVOICENUMBER

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

INVOICEPAIDDATE

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

IVC_ID

NUMBER

22

NEW

M_ECO_IVC_STAGINGS

IVCI_ID

NUMBER

22

NEW

M_ECO_IVC_STAGINGS

LINEID

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

LMOD

DATE

7

NEW

M_ECO_IVC_STAGINGS

PROJ_ID

VARCHAR2

10

NEW

M_ECO_IVC_STAGINGS

QUANTITY

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

STATUS

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

SUPPLIER

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

TAGNUMBER

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

UOC_ID

NUMBER

22

NEW

M_ECO_IVC_STAGINGS

UOM

VARCHAR2

120

NEW

M_ECO_IVC_STAGINGS

USR_ID

VARCHAR2

10

NEW

M_ECO_IVC_STAGINGS

WBSPATHID

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

AGR_STATUS

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

APPROVEDDATE

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

BUYER

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

COMMITMENTID

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

COMMITMENTNAME

VARCHAR2

4000

NEW

M_ECO_PO_HEADER_STAGINGS

CREATEDBY

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

ECOPOHDR_ID

NUMBER

22

NEW

M_ECO_PO_HEADER_STAGINGS

ECOSYS_PROJ_ID

VARCHAR2

200

NEW

M_ECO_PO_HEADER_STAGINGS

INT_REV

NUMBER

22

NEW

M_ECO_PO_HEADER_STAGINGS

JOB_ID

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

LMOD

DATE

7

NEW

M_ECO_PO_HEADER_STAGINGS

ORDERTYPE

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

PAYMENTTERMS

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

PROGRESS

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

PROJ_ID

VARCHAR2

10

NEW

M_ECO_PO_HEADER_STAGINGS

STATUS

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

SUPPLEMENT

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

SUPPLEMENTDATE

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

SUPPLIERNAME

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

TYPEID

VARCHAR2

120

NEW

M_ECO_PO_HEADER_STAGINGS

USR_ID

VARCHAR2

10

NEW

M_ECO_PO_LI_STAGINGS

ACTUALCOST

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

ACTUALQUANTITY

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

APPROVEDDATE

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

COMMITMENTID

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

COMMODITYCODE

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

COST

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

COSTACCOUNTID

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

CURRENCY

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

DESCRIPTION

VARCHAR2

4000

NEW

M_ECO_PO_LI_STAGINGS

ECOPOLI_ID

NUMBER

22

NEW

M_ECO_PO_LI_STAGINGS

ECOSYS_PROJ_ID

VARCHAR2

200

NEW

M_ECO_PO_LI_STAGINGS

INSERTREASON

VARCHAR2

30

NEW

M_ECO_PO_LI_STAGINGS

INTERNALID

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

INT_REV

NUMBER

22

NEW

M_ECO_PO_LI_STAGINGS

KEYID

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

LINEID

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

LMOD

DATE

7

NEW

M_ECO_PO_LI_STAGINGS

OTHERCOST

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

PROJ_ID

VARCHAR2

10

NEW

M_ECO_PO_LI_STAGINGS

PROMISEDDATE

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

QUANTITY

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

RECTYPE

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

STATUS

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

SUPPLEMENT

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

SUPPLEMENTDATE

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

TAGNUMBER

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

UOM

VARCHAR2

120

NEW

M_ECO_PO_LI_STAGINGS

USR_ID

VARCHAR2

10

NEW

M_ECO_PO_LI_STAGINGS

WBSPATHID

VARCHAR2

120

NEW

M_ECO_REQ_HEADER_STAGINGS

COMMITMENTID

VARCHAR2

120

NEW

M_ECO_REQ_HEADER_STAGINGS

COMMITMENTNAME

VARCHAR2

260

NEW

M_ECO_REQ_HEADER_STAGINGS

ECOREQHDR_ID

NUMBER

22

NEW

M_ECO_REQ_HEADER_STAGINGS

ECOSYS_PROJ_ID

VARCHAR2

200

NEW

M_ECO_REQ_HEADER_STAGINGS

INT_REV

NUMBER

22

NEW

M_ECO_REQ_HEADER_STAGINGS

JOB_ID

NUMBER

22

NEW

M_ECO_REQ_HEADER_STAGINGS

LMOD

DATE

7

NEW

M_ECO_REQ_HEADER_STAGINGS

ORIGIN

VARCHAR2

120

NEW

M_ECO_REQ_HEADER_STAGINGS

PROJ_ID

VARCHAR2

10

NEW

M_ECO_REQ_HEADER_STAGINGS

REQ_STATUS

VARCHAR2

10

NEW

M_ECO_REQ_HEADER_STAGINGS

STATUS

VARCHAR2

60

NEW

M_ECO_REQ_HEADER_STAGINGS

SUPPLEMENT

VARCHAR2

240

NEW

M_ECO_REQ_HEADER_STAGINGS

SUPPLEMENTDATE

VARCHAR2

120

NEW

M_ECO_REQ_HEADER_STAGINGS

TYPEID

VARCHAR2

120

NEW

M_ECO_REQ_HEADER_STAGINGS

USR_ID

VARCHAR2

10

NEW

M_ECO_REQ_LI_STAGINGS

ACTUALCOST

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

ACTUALQUANTITY

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

BASE_RLI_ID

NUMBER

22

NEW

M_ECO_REQ_LI_STAGINGS

COMMITMENTID

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

COMMODITYCODE

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

COST

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

COSTACCOUNTID

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

CURRENCY

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

DESCRIPTION

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

ECOREQLI_ID

NUMBER

22

NEW

M_ECO_REQ_LI_STAGINGS

ECOSYS_PROJ_ID

VARCHAR2

200

NEW

M_ECO_REQ_LI_STAGINGS

INSERTREASON

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

INTERNALID

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

INT_REV

NUMBER

22

NEW

M_ECO_REQ_LI_STAGINGS

LINEID

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

LMOD

DATE

7

NEW

M_ECO_REQ_LI_STAGINGS

PROJ_ID

VARCHAR2

10

NEW

M_ECO_REQ_LI_STAGINGS

QUANTITY

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

REQUIREDONSITE

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

STATUS

VARCHAR2

60

NEW

M_ECO_REQ_LI_STAGINGS

SUPPLEMENT

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

SUPPLEMENTDATE

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

TAGNUMBER

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

UOM

VARCHAR2

120

NEW

M_ECO_REQ_LI_STAGINGS

USR_ID

VARCHAR2

10

NEW

M_ECO_REQ_LI_STAGINGS

WBSPATHID

VARCHAR2

120

NEW

M_INQUIRIES

POST_BID_REQ_RETURN_DATE

DATE

7

NEW

M_INQUIRIES

POST_REV_REQ_RETURN_DATE

DATE

7

NEW

M_INSPECTION_LEVEL_DETAILS

DAYS_AFTER

NUMBER

22

NEW

M_INSPECTION_LEVEL_DETAILS

PREV_ILD_ID

NUMBER

22

NEW

M_MERGE_COMPANY_JOBS

NC_IND_1

VARCHAR2

1

NEW

M_MERGE_COMPANY_JOBS

NC_IND_2

VARCHAR2

1

NEW

M_NOTE_COMPANIES

COMPANY_ID

NUMBER

22

NEW

M_NOTE_COMPANIES

COMPANY_NOTE_CODE

VARCHAR2

255

NEW

M_NOTE_COMPANIES

CONTROL_DATE

DATE

7

NEW

M_NOTE_COMPANIES

CONTROL_STATUS

NUMBER

22

NEW

M_NOTE_COMPANIES

INT_REV

NUMBER

22

NEW

M_NOTE_COMPANIES

LMOD

DATE

7

NEW

M_NOTE_COMPANIES

NOTE_ID

NUMBER

22

NEW

M_NOTE_COMPANIES

PROJ_ID

VARCHAR2

10

NEW

M_NOTE_COMPANIES

SDB_INFO

VARCHAR2

256

NEW

M_NOTE_COMPANIES

USR_ID

VARCHAR2

10

NEW

M_NOTE_COMPANY_NLS

COMPANY_ID

NUMBER

22

NEW

M_NOTE_COMPANY_NLS

DESCRIPTION

VARCHAR2

4000

NEW

M_NOTE_COMPANY_NLS

INT_REV

NUMBER

22

NEW

M_NOTE_COMPANY_NLS

LMOD

DATE

7

NEW

M_NOTE_COMPANY_NLS

NLS_ID

NUMBER

22

NEW

M_NOTE_COMPANY_NLS

NOTE

VARCHAR2

2000

NEW

M_NOTE_COMPANY_NLS

NOTE_ID

NUMBER

22

NEW

M_NOTE_COMPANY_NLS

PROJ_ID

VARCHAR2

10

NEW

M_NOTE_COMPANY_NLS

SHORT_DESC

VARCHAR2

4000

NEW

M_NOTE_COMPANY_NLS

USR_ID

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

IDDSI_ID

NUMBER

22

NEW

M_NOTE_CONFLICTS_TMP

IDDSP_ID

NUMBER

22

NEW

M_NOTE_CONFLICTS_TMP

IDSA_ID

NUMBER

22

NEW

M_NOTE_CONFLICTS_TMP

SPEC_HEADER_ID

NUMBER

22

NEW

M_NOTE_CONFLICTS_TMP

SPEC_ITEM_ID

NUMBER

22

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE1

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE10

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE2

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE3

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE4

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE5

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE6

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE7

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE8

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

SRD_PIPING_NOTE9

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE1

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE10

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE2

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE3

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE4

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE5

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE6

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE7

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE8

VARCHAR2

10

NEW

M_NOTE_CONFLICTS_TMP

S3D_PIPING_NOTE9

VARCHAR2

10

NEW

M_NOTE_INTERFACE_NLS

DESCRIPTION

VARCHAR2

4000

NEW

M_NOTE_INTERFACE_NLS

INTERFACE_ID

NUMBER

22

NEW

M_NOTE_INTERFACE_NLS

INT_REV

NUMBER

22

NEW

M_NOTE_INTERFACE_NLS

LMOD

DATE

7

NEW

M_NOTE_INTERFACE_NLS

NLS_ID

NUMBER

22

NEW

M_NOTE_INTERFACE_NLS

NOTE

VARCHAR2

2000

NEW

M_NOTE_INTERFACE_NLS

NOTE_ID

NUMBER

22

NEW

M_NOTE_INTERFACE_NLS

PROJ_ID

VARCHAR2

10

NEW

M_NOTE_INTERFACE_NLS

SHORT_DESC

VARCHAR2

4000

NEW

M_NOTE_INTERFACE_NLS

USR_ID

VARCHAR2

10

NEW

M_NOTE_INTERFACES

CONTROL_DATE

DATE

7

NEW

M_NOTE_INTERFACES

CONTROL_STATUS

NUMBER

22

NEW

M_NOTE_INTERFACES

INTERFACE_ID

NUMBER

22

NEW

M_NOTE_INTERFACES

INTERFACE_NOTE_CODE

VARCHAR2

255

NEW

M_NOTE_INTERFACES

INT_REV

NUMBER

22

NEW

M_NOTE_INTERFACES

LMOD

DATE

7

NEW

M_NOTE_INTERFACES

NOTE_ID

NUMBER

22

NEW

M_NOTE_INTERFACES

PROJ_ID

VARCHAR2

10

NEW

M_NOTE_INTERFACES

SDB_INFO

VARCHAR2

256

NEW

M_NOTE_INTERFACES

USR_ID

VARCHAR2

10

NEW

M_PACKAGE_ITEM_INVOICES

INT_REV

NUMBER

22

NEW

M_PACKAGE_ITEM_INVOICES

LMOD

DATE

7

NEW

M_PACKAGE_ITEM_INVOICES

PCKI_ID

NUMBER

22

NEW

M_PACKAGE_ITEM_INVOICES

PLIN_ID

NUMBER

22

NEW

M_PACKAGE_ITEM_INVOICES

USR_ID

VARCHAR2

10

NEW

M_PACKAGES

TSHIP_ARRIVE_DATE

DATE

7

NEW

M_QT_PROJ_ADM

DEQ_UID

VARCHAR2

128

NEW

M_QT_PROJ_ADM

ENQ_UID

VARCHAR2

128

NEW

M_QT_PROJ_ADM

EXCEPTION_QSCHEMA

VARCHAR2

128

NEW

M_QT_PROJ_ADM

EXCEPTION_QUEUE

VARCHAR2

128

NEW

M_QT_PROJ_ADM

Q_NAME

VARCHAR2

128

NEW

M_QT_PROJ_ADM

SENDER_NAME

VARCHAR2

128

NEW

M_RELEASE_NOTES

REL_TO_TSHIP_IND

VARCHAR2

1

NEW

M_RELN_MIG_CR56113

PROJ_ID

VARCHAR2

10

NEW

M_RELN_MIG_CR56113

RELN_ID

NUMBER

22

NEW

M_RELN_MIG_CR56113

RELN_NUMBER

VARCHAR2

60

NEW

M_RELN_MIG_CR56113

REMARKS

VARCHAR2

4000

NEW

M_SCHEDULED_MAILS

BODY

CLOB

4000

NEW

M_SCHEDULED_MAILS

CREATED_BY

VARCHAR2

10

NEW

M_SCHEDULED_MAILS

CREATED_BY_MAIL

VARCHAR2

255

NEW

M_SCHEDULED_MAILS

CREATED_DATE

DATE

7

NEW

M_SCHEDULED_MAILS

DATE_SENT

DATE

7

NEW

M_SCHEDULED_MAILS

DELAY

VARCHAR2

1

NEW

M_SCHEDULED_MAILS

EVT_ID

NUMBER

22

NEW

M_SCHEDULED_MAILS

HASH

VARCHAR2

64

NEW

M_SCHEDULED_MAILS

INT_REV

NUMBER

22

NEW

M_SCHEDULED_MAILS

LMOD

DATE

7

NEW

M_SCHEDULED_MAILS

MINUTES

NUMBER

22

NEW

M_SCHEDULED_MAILS

PK_ID

NUMBER

22

NEW

M_SCHEDULED_MAILS

PK_TYPE

VARCHAR2

5

NEW

M_SCHEDULED_MAILS

PROJ_ID

VARCHAR2

10

NEW

M_SCHEDULED_MAILS

SENT_TO

CLOB

4000

NEW

M_SCHEDULED_MAILS

SMAIL_ID

NUMBER

22

NEW

M_SCHEDULED_MAILS

STATUS

VARCHAR2

32

NEW

M_SCHEDULED_MAILS

STATUS_TEXT

CLOB

4000

NEW

M_SCHEDULED_MAILS

SUBJECT

VARCHAR2

256

NEW

M_SCHEDULED_MAILS

TRIES

NUMBER

22

NEW

M_SCHEDULED_MAILS

USR_ID

VARCHAR2

20

NEW

M_SPEC_ITEM_TAG_IDENTS_TEMP

IDENT

NUMBER

22

NEW

M_SPEC_ITEM_TAG_IDENTS_TEMP

PROJ_ID

VARCHAR2

10

NEW

M_SPEC_ITEM_TAG_IDENTS_TEMP

SITI_ID

NUMBER

22

NEW

M_SPEC_ITEM_TAG_IDENTS_TEMP

SPEC_ITEM_ID

NUMBER

22

NEW

M_SP3D_SHT_CONF_SHT_ATTRS

ATTR_POSITION

VARCHAR2

50

NEW

M_SP3D_SHT_CONF_SHT_ATTRS

ORIENTATION

VARCHAR2

240

NEW

M_SP3D_SHT_CONF_SHTS

ALT_SHT_NAME

VARCHAR2

256

NEW

M_TMP_ADDED_SUPPS

SUP_ID

NUMBER

22

NEW

M_TMP_SP3D_IMP_SPEC_CONFLICTS

SRD_PIPINGNOTE_VALUE

VARCHAR2

10

NEW

M_TMP_SP3D_IMP_SPEC_CONFLICTS

S3D_PIPINGNOTE_VALUE

VARCHAR2

10

NEW

M_USED_FILES

PROJ_ID

VARCHAR2

10

NEW

M_VENDOR_PROGRESS

APPROVED_BY

VARCHAR2

10

NEW

M_VENDOR_PROGRESS

APPROVED_DATE

DATE

7

NEW

M_VENDOR_PROGRESS

INT_REV

NUMBER

22

NEW

M_VENDOR_PROGRESS

LMOD

DATE

7

NEW

M_VENDOR_PROGRESS

PK_ID

NUMBER

22

NEW

M_VENDOR_PROGRESS

PK_TYPE

VARCHAR2

5

NEW

M_VENDOR_PROGRESS

POH_ID

NUMBER

22

NEW

M_VENDOR_PROGRESS

READY_FOR_APPROVAL_IND

VARCHAR2

1

NEW

M_VENDOR_PROGRESS

USR_ID

VARCHAR2

10

NEW

M_VENDOR_PROGRESS

VP_ID

NUMBER

22

NEW

MW_API_OPEN_INTERFACES

AOI_ID

NUMBER

22

NEW

MW_API_OPEN_INTERFACES

DESCRIPTION

VARCHAR2

4000

NEW

MW_API_OPEN_INTERFACES

FILENAME

VARCHAR2

500

NEW

MW_API_OPEN_INTERFACES

INTERFACE_DATA

CLOB

4000

NEW

MW_API_OPEN_INTERFACES

INT_REV

NUMBER

22

NEW

MW_API_OPEN_INTERFACES

LMOD

DATE

7

NEW

MW_API_OPEN_INTERFACES

PROG_CMD

VARCHAR2

4000

NEW

MW_API_OPEN_INTERFACES

PROG_ID

VARCHAR2

60

NEW

MW_API_OPEN_INTERFACES

PROJ_ID

VARCHAR2

10

NEW

MW_API_OPEN_INTERFACES

REC_ID

NUMBER

22

NEW

MW_API_OPEN_INTERFACES

RESPONSE_DATA

CLOB

4000

NEW

MW_API_OPEN_INTERFACES

STATUS

VARCHAR2

4000

NEW

MW_API_OPEN_INTERFACES

TYPE

VARCHAR2

1000

NEW

MW_API_OPEN_INTERFACES

USR_ID

VARCHAR2

10

NEW

MW_API_OPEN_INTERFACES

VERSION

NUMBER

22

NEW

MW_INSTALL_INFOS

COPYRIGHT_TEXT_1

VARCHAR2

80

NEW

MW_INSTALL_INFOS

COPYRIGHT_TEXT_2

VARCHAR2

80

NEW

MW_INSTALL_INFOS

FOURTH_NR

VARCHAR2

10

NEW

MW_INSTALL_INFOS

INSI_ID

NUMBER

22

NEW

MW_INSTALL_INFOS

INSI_NAME

VARCHAR2

30

NEW

MW_INSTALL_INFOS

INSTALL_DATE

DATE

7

NEW

MW_INSTALL_INFOS

INSTALL_FEEDBACK

VARCHAR2

255

NEW

MW_INSTALL_INFOS

INT_REV

NUMBER

22

NEW

MW_INSTALL_INFOS

LMOD

DATE

7

NEW

MW_INSTALL_INFOS

MAJOR_NR

NUMBER

22

NEW

MW_INSTALL_INFOS

MARKETING_MAJOR_NR

VARCHAR2

240

NEW

MW_INSTALL_INFOS

MARKETING_MINOR_NR

VARCHAR2

240

NEW

MW_INSTALL_INFOS

PARENT_INSI_ID

NUMBER

22

NEW

MW_INSTALL_INFOS

SECOND_NR

NUMBER

22

NEW

MW_INSTALL_INFOS

SPECIFICATION

VARCHAR2

80

NEW

MW_INSTALL_INFOS

THIRD_NR

NUMBER

22

NEW

MW_INSTALL_INFOS

USR_ID

VARCHAR2

10

NEW