--ABS-73805

-------------- ERP_O_WORKORDER --------------
ALTER TABLE ERP_O_WORKORDER ADD (EXT_ERR_CODE VARCHAR2(20) NULL,
                                 EXT_ERR_DESC VARCHAR2(1000) NULL,
                                 EXT_TRANSFER_ID NUMBER NULL,
                                 EXT_INST_ID VARCHAR2(40) NULL,
                                 EXT_STATUS VARCHAR2(1) DEFAULT 'C' NULL);
                                 
CREATE INDEX XIE2ERP_O_WORKORDER ON ERP_O_WORKORDER (EXT_ERR_CODE ASC);
CREATE INDEX XIE3ERP_O_WORKORDER ON ERP_O_WORKORDER (EXT_TRANSFER_ID ASC);

-------------- ERP_O_WORKORDERLINE --------------
ALTER TABLE ERP_O_WORKORDERLINE ADD (EXT_ERR_CODE VARCHAR2(20) NULL,
                                     EXT_ERR_DESC VARCHAR2(1000) NULL,
                                     EXT_TRANSFER_ID NUMBER NULL,
                                     EXT_INST_ID VARCHAR2(40) NULL,
                                     EXT_STATUS VARCHAR2(1) DEFAULT 'C' NULL);
                                     
CREATE INDEX XIE2ERP_O_WORKORDERLINE ON ERP_O_WORKORDERLINE (EXT_ERR_CODE ASC);
CREATE INDEX XIE3ERP_O_WORKORDERLINE ON ERP_O_WORKORDERLINE (EXT_TRANSFER_ID  ASC);

-------------- ERP_O_WORKORDERLINEMEBLEM --------------
ALTER TABLE ERP_O_WORKORDERLINEMEBLEM ADD (EXT_ERR_CODE VARCHAR2(20) NULL,
                                           EXT_ERR_DESC VARCHAR2(1000) NULL,
                                           EXT_TRANSFER_ID NUMBER NULL,
                                           EXT_INST_ID VARCHAR2(40) NULL,
                                           EXT_STATUS VARCHAR2(1) DEFAULT 'C' NULL);
                                           
CREATE INDEX XIE2ERP_O_WORKORDINEMEBLEM ON ERP_O_WORKORDERLINEMEBLEM (EXT_ERR_CODE ASC);
CREATE INDEX XIE3ERP_O_WORKORDINEMEBLEM ON ERP_O_WORKORDERLINEMEBLEM (EXT_TRANSFER_ID ASC);

-------------- ERP_O_WORKORDERLINERES --------------
ALTER TABLE ERP_O_WORKORDERLINERES ADD (EXT_ERR_CODE VARCHAR2(20) NULL,
                                        EXT_ERR_DESC VARCHAR2(1000) NULL,
                                        EXT_TRANSFER_ID NUMBER NULL,
                                        EXT_INST_ID VARCHAR2(40) NULL,
                                        EXT_STATUS VARCHAR2(1) DEFAULT 'C' NULL);
                                        
CREATE INDEX XIE2ERP_O_WORKORDLINERES ON ERP_O_WORKORDERLINERES (EXT_ERR_CODE ASC);
CREATE INDEX XIE3ERP_O_WORKORDLINERES ON ERP_O_WORKORDERLINERES (EXT_TRANSFER_ID ASC);

-------------- ERP_O_WORKORDERLINE_ISSUE --------------
ALTER TABLE ERP_O_WORKORDERLINE_ISSUE ADD (EXT_ERR_CODE VARCHAR2(20) NULL,
                                           EXT_ERR_DESC VARCHAR2(1000) NULL,
                                           EXT_TRANSFER_ID NUMBER NULL,
                                           EXT_INST_ID VARCHAR2(40) NULL,
                                           EXT_STATUS VARCHAR2(1) DEFAULT 'C' NULL);
                                           
CREATE INDEX XIE2ERP_O_WORKORD_ISSUE ON ERP_O_WORKORDERLINE_ISSUE (EXT_ERR_CODE ASC);
CREATE INDEX XIE3ERP_O_WORKORD_ISSUE ON ERP_O_WORKORDERLINE_ISSUE (EXT_TRANSFER_ID ASC);

-------------- ERP_O_WORKORDER_LOG --------------
ALTER TABLE ERP_O_WORKORDER_LOG ADD (EXT_ERR_CODE VARCHAR2(20) NULL,
                                     EXT_ERR_DESC VARCHAR2(1000) NULL,
                                     EXT_TRANSFER_ID NUMBER NULL,
                                     EXT_INST_ID VARCHAR2(40) NULL,
                                     EXT_STATUS VARCHAR2(1) DEFAULT 'C' NULL);
                                     
CREATE INDEX XIE2ERP_O_WORKORDER_LOG ON ERP_O_WORKORDER_LOG (EXT_ERR_CODE ASC);
CREATE INDEX XIE3ERP_O_WORKORDER_LOG ON ERP_O_WORKORDER_LOG (EXT_TRANSFER_ID ASC);


-------------- ERP_I_CONTRACTCOMPONENT --------------  
ALTER TABLE ERP_I_CONTRACTCOMPONENT ADD (SPECIALSIZECHARGE VARCHAR2(1) DEFAULT 'N' NULL);

-------------- ERP_I_CUSTOMER --------------
ALTER TABLE ERP_I_CUSTOMER ADD (SPECIALSIZECHARGE VARCHAR2(1) DEFAULT 'N' NULL);

-------------- ERP_I_SUPPLIER --------------
ALTER TABLE ERP_I_SUPPLIER ADD (STATE VARCHAR2(20) NULL);