The changes in database table column Nullable property are listed in this section.
TABLE_NAME |
COLUMN_NAME |
NULLABLE |
Change |
---|---|---|---|
M_APPROVAL_TICKETS |
PK_ID2 |
Y |
NEW |
M_ATTR_SET_DETAILS |
ATTR_COLOR |
Y |
NEW |
M_COMMODITY_RULE_DETAILS |
TABLE_COLOR |
Y |
NEW |
M_ECO_ACT_STAGING_RAW |
COSTACCOUNTID |
N |
NEW |
M_ECO_ACT_STAGING_RAW |
ECOACTRAW_ID |
N |
NEW |
M_ECO_ACT_STAGING_RAW |
ECOSYS_PROJ_ID |
N |
NEW |
M_ECO_ACT_STAGING_RAW |
INT_REV |
N |
NEW |
M_ECO_ACT_STAGING_RAW |
LMOD |
N |
NEW |
M_ECO_ACT_STAGING_RAW |
PROJ_ID |
N |
NEW |
M_ECO_ACT_STAGING_RAW |
USR_ID |
N |
NEW |
M_ECO_ACT_STAGING_RAW |
WBSPATHID |
N |
NEW |
M_ECO_ACT_STAGINGS |
ATTR_NAME |
N |
NEW |
M_ECO_ACT_STAGINGS |
ATTR_VALUE |
Y |
NEW |
M_ECO_ACT_STAGINGS |
ECOAST_ID |
N |
NEW |
M_ECO_ACT_STAGINGS |
ECOAST_REC_ID |
N |
NEW |
M_ECO_ACT_STAGINGS |
ECOSYS_PROJ_ID |
N |
NEW |
M_ECO_ACT_STAGINGS |
INT_REV |
N |
NEW |
M_ECO_ACT_STAGINGS |
LMOD |
N |
NEW |
M_ECO_ACT_STAGINGS |
PROJ_ID |
N |
NEW |
M_ECO_ACT_STAGINGS |
USR_ID |
N |
NEW |
M_ECO_IVC_STAGINGS |
COMMITMENTID |
N |
NEW |
M_ECO_IVC_STAGINGS |
COMMODITYCODE |
Y |
NEW |
M_ECO_IVC_STAGINGS |
COST |
N |
NEW |
M_ECO_IVC_STAGINGS |
COSTACCOUNTID |
N |
NEW |
M_ECO_IVC_STAGINGS |
CURRENCY |
Y |
NEW |
M_ECO_IVC_STAGINGS |
DESCRIPTION |
Y |
NEW |
M_ECO_IVC_STAGINGS |
ECOIVC_ID |
N |
NEW |
M_ECO_IVC_STAGINGS |
ECOSYS_PROJ_ID |
N |
NEW |
M_ECO_IVC_STAGINGS |
INT_REV |
N |
NEW |
M_ECO_IVC_STAGINGS |
INVOICENUMBER |
N |
NEW |
M_ECO_IVC_STAGINGS |
INVOICEPAIDDATE |
N |
NEW |
M_ECO_IVC_STAGINGS |
IVC_ID |
N |
NEW |
M_ECO_IVC_STAGINGS |
IVCI_ID |
Y |
NEW |
M_ECO_IVC_STAGINGS |
LINEID |
N |
NEW |
M_ECO_IVC_STAGINGS |
LMOD |
N |
NEW |
M_ECO_IVC_STAGINGS |
PROJ_ID |
N |
NEW |
M_ECO_IVC_STAGINGS |
QUANTITY |
Y |
NEW |
M_ECO_IVC_STAGINGS |
STATUS |
N |
NEW |
M_ECO_IVC_STAGINGS |
SUPPLIER |
Y |
NEW |
M_ECO_IVC_STAGINGS |
TAGNUMBER |
Y |
NEW |
M_ECO_IVC_STAGINGS |
UOC_ID |
Y |
NEW |
M_ECO_IVC_STAGINGS |
UOM |
Y |
NEW |
M_ECO_IVC_STAGINGS |
USR_ID |
N |
NEW |
M_ECO_IVC_STAGINGS |
WBSPATHID |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
AGR_STATUS |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
APPROVEDDATE |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
BUYER |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
COMMITMENTID |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
COMMITMENTNAME |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
CREATEDBY |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
ECOPOHDR_ID |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
ECOSYS_PROJ_ID |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
INT_REV |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
JOB_ID |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
LMOD |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
ORDERTYPE |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
PAYMENTTERMS |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
PROGRESS |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
PROJ_ID |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
STATUS |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
SUPPLEMENT |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
SUPPLEMENTDATE |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
SUPPLIERNAME |
Y |
NEW |
M_ECO_PO_HEADER_STAGINGS |
TYPEID |
N |
NEW |
M_ECO_PO_HEADER_STAGINGS |
USR_ID |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
ACTUALCOST |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
ACTUALQUANTITY |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
APPROVEDDATE |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
COMMITMENTID |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
COMMODITYCODE |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
COST |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
COSTACCOUNTID |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
CURRENCY |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
DESCRIPTION |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
ECOPOLI_ID |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
ECOSYS_PROJ_ID |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
INSERTREASON |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
INTERNALID |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
INT_REV |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
KEYID |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
LINEID |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
LMOD |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
OTHERCOST |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
PROJ_ID |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
PROMISEDDATE |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
QUANTITY |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
RECTYPE |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
STATUS |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
SUPPLEMENT |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
SUPPLEMENTDATE |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
TAGNUMBER |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
UOM |
Y |
NEW |
M_ECO_PO_LI_STAGINGS |
USR_ID |
N |
NEW |
M_ECO_PO_LI_STAGINGS |
WBSPATHID |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
COMMITMENTID |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
COMMITMENTNAME |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
ECOREQHDR_ID |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
ECOSYS_PROJ_ID |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
INT_REV |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
JOB_ID |
Y |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
LMOD |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
ORIGIN |
Y |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
PROJ_ID |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
REQ_STATUS |
Y |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
STATUS |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
SUPPLEMENT |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
SUPPLEMENTDATE |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
TYPEID |
N |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
USR_ID |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
ACTUALCOST |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
ACTUALQUANTITY |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
BASE_RLI_ID |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
COMMITMENTID |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
COMMODITYCODE |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
COST |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
COSTACCOUNTID |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
CURRENCY |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
DESCRIPTION |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
ECOREQLI_ID |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
ECOSYS_PROJ_ID |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
INSERTREASON |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
INTERNALID |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
INT_REV |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
LINEID |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
LMOD |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
PROJ_ID |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
QUANTITY |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
REQUIREDONSITE |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
STATUS |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
SUPPLEMENT |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
SUPPLEMENTDATE |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
TAGNUMBER |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
UOM |
Y |
NEW |
M_ECO_REQ_LI_STAGINGS |
USR_ID |
N |
NEW |
M_ECO_REQ_LI_STAGINGS |
WBSPATHID |
N |
NEW |
M_INQUIRIES |
POST_BID_REQ_RETURN_DATE |
Y |
NEW |
M_INQUIRIES |
POST_REV_REQ_RETURN_DATE |
Y |
NEW |
M_INSPECTION_LEVEL_DETAILS |
DAYS_AFTER |
Y |
NEW |
M_INSPECTION_LEVEL_DETAILS |
PREV_ILD_ID |
Y |
NEW |
M_MERGE_COMPANY_JOBS |
NC_IND_1 |
N |
NEW |
M_MERGE_COMPANY_JOBS |
NC_IND_2 |
N |
NEW |
M_NOTE_COMPANIES |
COMPANY_ID |
N |
NEW |
M_NOTE_COMPANIES |
COMPANY_NOTE_CODE |
N |
NEW |
M_NOTE_COMPANIES |
CONTROL_DATE |
N |
NEW |
M_NOTE_COMPANIES |
CONTROL_STATUS |
N |
NEW |
M_NOTE_COMPANIES |
INT_REV |
N |
NEW |
M_NOTE_COMPANIES |
LMOD |
N |
NEW |
M_NOTE_COMPANIES |
NOTE_ID |
N |
NEW |
M_NOTE_COMPANIES |
PROJ_ID |
N |
NEW |
M_NOTE_COMPANIES |
SDB_INFO |
Y |
NEW |
M_NOTE_COMPANIES |
USR_ID |
N |
NEW |
M_NOTE_COMPANY_NLS |
COMPANY_ID |
N |
NEW |
M_NOTE_COMPANY_NLS |
DESCRIPTION |
Y |
NEW |
M_NOTE_COMPANY_NLS |
INT_REV |
N |
NEW |
M_NOTE_COMPANY_NLS |
LMOD |
N |
NEW |
M_NOTE_COMPANY_NLS |
NLS_ID |
N |
NEW |
M_NOTE_COMPANY_NLS |
NOTE |
N |
NEW |
M_NOTE_COMPANY_NLS |
NOTE_ID |
N |
NEW |
M_NOTE_COMPANY_NLS |
PROJ_ID |
N |
NEW |
M_NOTE_COMPANY_NLS |
SHORT_DESC |
Y |
NEW |
M_NOTE_COMPANY_NLS |
USR_ID |
N |
NEW |
M_NOTE_CONFLICTS_TMP |
IDDSI_ID |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
IDDSP_ID |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
IDSA_ID |
N |
NEW |
M_NOTE_CONFLICTS_TMP |
SPEC_HEADER_ID |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SPEC_ITEM_ID |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE1 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE10 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE2 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE3 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE4 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE5 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE6 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE7 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE8 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
SRD_PIPING_NOTE9 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE1 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE10 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE2 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE3 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE4 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE5 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE6 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE7 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE8 |
Y |
NEW |
M_NOTE_CONFLICTS_TMP |
S3D_PIPING_NOTE9 |
Y |
NEW |
M_NOTE_INTERFACE_NLS |
DESCRIPTION |
Y |
NEW |
M_NOTE_INTERFACE_NLS |
INTERFACE_ID |
N |
NEW |
M_NOTE_INTERFACE_NLS |
INT_REV |
N |
NEW |
M_NOTE_INTERFACE_NLS |
LMOD |
N |
NEW |
M_NOTE_INTERFACE_NLS |
NLS_ID |
N |
NEW |
M_NOTE_INTERFACE_NLS |
NOTE |
N |
NEW |
M_NOTE_INTERFACE_NLS |
NOTE_ID |
N |
NEW |
M_NOTE_INTERFACE_NLS |
PROJ_ID |
N |
NEW |
M_NOTE_INTERFACE_NLS |
SHORT_DESC |
Y |
NEW |
M_NOTE_INTERFACE_NLS |
USR_ID |
N |
NEW |
M_NOTE_INTERFACES |
CONTROL_DATE |
N |
NEW |
M_NOTE_INTERFACES |
CONTROL_STATUS |
N |
NEW |
M_NOTE_INTERFACES |
INTERFACE_ID |
N |
NEW |
M_NOTE_INTERFACES |
INTERFACE_NOTE_CODE |
N |
NEW |
M_NOTE_INTERFACES |
INT_REV |
N |
NEW |
M_NOTE_INTERFACES |
LMOD |
N |
NEW |
M_NOTE_INTERFACES |
NOTE_ID |
N |
NEW |
M_NOTE_INTERFACES |
PROJ_ID |
N |
NEW |
M_NOTE_INTERFACES |
SDB_INFO |
Y |
NEW |
M_NOTE_INTERFACES |
USR_ID |
N |
NEW |
M_PACKAGE_ITEM_INVOICES |
INT_REV |
N |
NEW |
M_PACKAGE_ITEM_INVOICES |
LMOD |
N |
NEW |
M_PACKAGE_ITEM_INVOICES |
PCKI_ID |
N |
NEW |
M_PACKAGE_ITEM_INVOICES |
PLIN_ID |
N |
NEW |
M_PACKAGE_ITEM_INVOICES |
USR_ID |
N |
NEW |
M_PACKAGES |
TSHIP_ARRIVE_DATE |
Y |
NEW |
M_RELEASE_NOTES |
REL_TO_TSHIP_IND |
N |
NEW |
M_RELN_MIG_CR56113 |
PROJ_ID |
N |
NEW |
M_RELN_MIG_CR56113 |
RELN_ID |
N |
NEW |
M_RELN_MIG_CR56113 |
RELN_NUMBER |
N |
NEW |
M_RELN_MIG_CR56113 |
REMARKS |
Y |
NEW |
M_SCHEDULED_MAILS |
BODY |
Y |
NEW |
M_SCHEDULED_MAILS |
CREATED_BY |
N |
NEW |
M_SCHEDULED_MAILS |
CREATED_BY_MAIL |
Y |
NEW |
M_SCHEDULED_MAILS |
CREATED_DATE |
Y |
NEW |
M_SCHEDULED_MAILS |
DATE_SENT |
Y |
NEW |
M_SCHEDULED_MAILS |
DELAY |
Y |
NEW |
M_SCHEDULED_MAILS |
EVT_ID |
N |
NEW |
M_SCHEDULED_MAILS |
HASH |
N |
NEW |
M_SCHEDULED_MAILS |
INT_REV |
Y |
NEW |
M_SCHEDULED_MAILS |
LMOD |
Y |
NEW |
M_SCHEDULED_MAILS |
MINUTES |
Y |
NEW |
M_SCHEDULED_MAILS |
PK_ID |
Y |
NEW |
M_SCHEDULED_MAILS |
PK_TYPE |
Y |
NEW |
M_SCHEDULED_MAILS |
PROJ_ID |
N |
NEW |
M_SCHEDULED_MAILS |
SENT_TO |
Y |
NEW |
M_SCHEDULED_MAILS |
SMAIL_ID |
N |
NEW |
M_SCHEDULED_MAILS |
STATUS |
Y |
NEW |
M_SCHEDULED_MAILS |
STATUS_TEXT |
Y |
NEW |
M_SCHEDULED_MAILS |
SUBJECT |
Y |
NEW |
M_SCHEDULED_MAILS |
TRIES |
Y |
NEW |
M_SCHEDULED_MAILS |
USR_ID |
Y |
NEW |
M_SPEC_ITEM_TAG_IDENTS_TEMP |
IDENT |
N |
NEW |
M_SPEC_ITEM_TAG_IDENTS_TEMP |
PROJ_ID |
N |
NEW |
M_SPEC_ITEM_TAG_IDENTS_TEMP |
SITI_ID |
Y |
NEW |
M_SPEC_ITEM_TAG_IDENTS_TEMP |
SPEC_ITEM_ID |
N |
NEW |
M_SP3D_SHT_CONF_SHT_ATTRS |
ATTR_POSITION |
Y |
NEW |