22 lines
806 B
SQL
22 lines
806 B
SQL
alter table MNP_DBCGO_NOTIFICA_DONOR_OUT add (
|
|
DATA_VALIDAZIONE_EFF DATE,
|
|
DATA_CUT_OVER_EFF DATE,
|
|
FLAG_ESP NUMBER(1),
|
|
BUSINESS_ID VARCHAR2(36));
|
|
|
|
alter table MNP_DBCGO_NOTIFICA_REC_OUT add (
|
|
DATA_CUT_OVER_EFF DATE,
|
|
FLAG_ESP NUMBER(1),
|
|
DATA_VALIDAZIONE_EFF DATE,
|
|
BUSINESS_ID VARCHAR2(36));
|
|
|
|
alter table MNP_DBCGO_NOTIFICA_DON_TC_OUT add FLAG_VERIFICA_CREDITO_ANOMALO number;
|
|
|
|
alter table MNP_DBCGO_NOTIFICA_REC_TC_OUT add FLAG_VERIFICA_CREDITO_ANOMALO number;
|
|
|
|
alter table MNP_DBCGO_NOT_REC_VIRT_TC_OUT add FLAG_VERIFICA_CREDITO_ANOMALO number;
|
|
|
|
alter table MNP_DBCGO_NOT_DON_VIRT_OUT add (RICHIESTAADHOC number, DATA_CUT_OVER_EFF DATE);
|
|
|
|
alter table MNP_DBCGO_NOT_REC_VIRT_OUT add (RICHIESTAADHOC number, DATA_CUT_OVER_EFF DATE);
|