5.1. Database

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 company codes  that make use of that certificate.

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

1. Create the document type: INSERT INTO "TIPOS_DOCUMENTO" ("ID_TIPO_DOC_FUSE","DESCRIPCION", "URN") VALUES ('SUMINA','SuministroLRInmueblesAdicionales','urn:es:techedge:documento:suministro:inmuebles:adicionales');
2. Create the external document: INSERT INTO "DOCUMENTOS_EXT" ("ID_TIPO_DOC_EXT","ID_VER_DOC_EXT", "XML_SCHEMA_REF", "MIME_TYPE", "DESCRIPCION") VALUES ('SuministroLRInmueblesAdicionales','ANY','SuministroLRInmueblesAdicionales','text/xml','SuministroLRInmueblesAdicionales');

The third step is to include the correlation of the new SUMINA operation for each scenario in which it applies (ENVLOTDAS, ENVLOTCSVD, ENVLOTXML). These steps are unique for Tenant and society, so they must be iterated for each case (the interrogation symbols represent the Tenant and the grouping in that order, for example ‘??????’ corresponds to X02A01 when X02 the internal Tenant, and A01 is the internal group):

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');