Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.

The first step is to check that they have all the tables, specified in the Table Generation Script of the latest version, attached in the annex of this document.

We create the tables that are missing so that they work with the latest version.

In the CERTIFICATES table, the creation user of the certificate identified by the CRTBY field must be assigned by the user of the certificate manager assigned to the companies that use that certificate.

IT IS VERY IMPORTANT NOT TO DIRECTLY EXECUTE THE SCRIPT OF GENERATION OF TABLES !!! Since we expose ourselves to losing customer data. 


The second step to take into account in the database, is to create the data correlation for the new operation (SuminsitroLRinmueblesAdicionales):

...

  1. Create Default route for that Tenant: INSERT INTO "RUTAS" ("ID_RUTA","DESCRIPCION") VALUES ('RTENVLOTDAS-???ANY-SUMINA-V1','Ruta de envio de lotes para Techedge Desarrollo');
  2. Create the route steps: INSERT INTO "PASOS_RUTA" ("ID_RUTA","ID_SECUENCIA","ID_MODULO") VALUES ('RTENVLOTDAS-??????-SUMINA-V1',1,'STP-COM-SUMINA'); INSERT INTO "PASOS_RUTA" ("ID_RUTA","ID_SECUENCIA","ID_MODULO") VALUES ('RTENVLOTDAS-??????-SUMINA-V1',2,'STP-COM-SAPRES');
  3. Create the generic route calculation: INSERT INTO "CALCULO_RUTA" ("ID_ESCENARIO", "ID_TENANT_FUSE", "ID_AGRUPACION_FUSE", "ID_TIPO_DOC_FUSE", "ID_RUTA") VALUES ('ENVLOTDAS','???','???','SUMINA','RTENVLOTDAS-??????-SUMINA-V1');
  4. Extract tenant societies: SELECT DISTINCT "ID_AGRUPACION_EXT","ID_TENANT_FUSE","ID_ORIGEN","ID_AGRUPACION_FUSE" FROM "CORRELACIONES" WHERE "ID_TENANT_EXT"='?';
  5. Make queries for each company: INSERT INTO "CORRELACIONES" ("ID_ESCENARIO","ID_TENANT_EXT", "ID_AGRUPACION_EXT", "ID_ORIGEN", "ID_TIPO_DOC_EXT", "ID_VER_DOC_EXT","ID_TENANT_FUSE","ID_AGRUPACION_FUSE","ID_TIPO_DOC_FUSE") VALUES ('ENVLOTDAS','?','?','?','SuministroLRInmueblesAdicionales','ANY','???','???','SUMINA');
Companies must also be included to modify the ANY company for each internal Tenant, to ensure at least one generic route.