|
68 |
REATE FUNCTION dbo.dtes_FncJson(@dtes_docs_id as Int, @tpoDTE Varchar(3), @numcontrol Int, @uuid Var... |
dtes_FncJson: mejoras en FSEX |
Y |
3 |
editar
eliminar
|
|
67 |
REATE view [dbo].[_vDatosDTSPDF] as
SELECT
doc.idsalida,
doc.TipoComp,
dte.dtes_docs... |
_vDatosDTSPDF: Actualizar concatenacion de nombre, giro, direccion |
Y |
3 |
editar
eliminar
|
|
66 |
LTER TABLE core.emr_frmnwpatient DISABLE TRIGGER trgcore_emr_hashline_frmnwpatient_upd;
ALTER TABLE... |
EMR_FRMNWPATIENT: cambiar de nombre a columnas de estado y ciudad... |
Y |
1 |
editar
eliminar
|
|
65 |
- DROP FUNCTION core.apicore_getlistforselectbox(int4, text);
CREATE OR REPLACE FUNCTION core.api... |
APICORE_GETLISTFORSELECTBOX: ajustar filtros que llegar por atributo "filterrule" |
Y |
1 |
editar
eliminar
|
|
64 |
- core.c_bpartner_vi source
CREATE OR REPLACE VIEW core.c_bpartner_vi
AS SELECT cb.c_bpartner_id... |
C_BPARTNER_Vi: agregar columnas "subscriptorinfo" y "familygroup" |
Y |
1 |
editar
eliminar
|
|
63 |
- core.c_bpartner_vf source
CREATE OR REPLACE VIEW core.c_bpartner_vf
AS SELECT cb.c_bpartner_id... |
C_BPARTNER_Vf: agregar columnas "subscriptorinfo" y "familygroup" seteados con NULL |
Y |
1 |
editar
eliminar
|
|
62 |
- core.c_bpartner_v source
CREATE OR REPLACE VIEW core.c_bpartner_v
AS SELECT cb.c_bpartner_id AS ... |
C_BPARTNER_V: agregar columnas "subscriptorinfo" y "familygroup" |
Y |
1 |
editar
eliminar
|
|
61 |
- DROP FUNCTION core.apicore_gettabbyid(int4, int4);
CREATE OR REPLACE FUNCTION core.apicore_gett... |
PICORE_GETTABBYID: en atributo "query_data" se agregan atributos de columna a filtrar para modal: se... |
Y |
1 |
editar
eliminar
|
|
60 |
- core.cub_ledger_v source
CREATE OR REPLACE VIEW core.cub_ledger_v
AS SELECT q.ad_client_id,
... |
CUB_LEDGER: agregar C_ProjectLine_ID en todos los atributos "payment_details" |
Y |
1 |
editar
eliminar
|
|
59 |
REATE view [dbo].[_vDatosDTSPDF] as
SELECT
doc.idsalida,
doc.TipoComp,
dte.dtes_docs... |
_vDatosDTSPDF: Actualizar campos concatenados en PDFs (Receptor) |
Y |
3 |
editar
eliminar
|
|
58 |
PDATE core.ad_fieldgroup SET seqno=999 WHERE ad_fieldgroup_id=135;
UPDATE core.ad_fieldgroup SET se... |
AD_FIELDGROUPS / AD_FIELD: Actualizar SEQNo y columndisplay |
Y |
1 |
editar
eliminar
|
|
57 |
CREATE view [dbo].[vEmisorCOFASA] as
Select * from inccfacco.dbo.EmpresaMH where eliminado=... |
COFASA: vEmisorCOFASA - (vw)
Modelo INFO |
Y |
3 |
editar
eliminar
|
|
56 |
reate table _dte_catalogo_opc
(
dte_catalogo_opc_id int not null
constra... |
COFASA: _dte_catalogo_opc - (tb) |
Y |
3 |
editar
eliminar
|
|
55 |
reate table dte_catalogos
(
dte_catalogo_id int not null
constraint dte_cata... |
COFASA: dte_catalogos - (tb) |
Y |
3 |
editar
eliminar
|
|
54 |
reate table dte_configuracion
(
dte_config_id int not null
constraint ... |
COFASA: dte_configuracion - (fn) |
Y |
3 |
editar
eliminar
|
|
53 |
reate table dtes_seqs
(
dtes_seqs_id int identity
constraint PK_dtesseqs
... |
COFASA: dtes_seqs - (tb) |
Y |
3 |
editar
eliminar
|
|
52 |
- auto-generated definition
create table dtes_docsline
(
dtes_docsline_id int identity
... |
COFASA: dtes_docsline - (tb) |
Y |
3 |
editar
eliminar
|
|
51 |
- auto-generated definition
create table dtes_docs
(
dtes_docs_id int identity
c... |
COFASA: dtes_docs - (tb) |
Y |
3 |
editar
eliminar
|
|
50 |
REATE PROCEDURE [dbo].[GetPendientesMHPaginatedFiltered] @PageNumber INT,
... |
COFASA: GetPendientesMHPaginatedFiltered - (fn) |
Y |
3 |
editar
eliminar
|
|
49 |
REATE PROCEDURE [dbo].[GetPendientesMHPaginated]
@PageNumber INT,
@PageSize INT
AS
BEGIN... |
COFASA: GetPendientesMHPaginated - (fn) |
Y |
3 |
editar
eliminar
|
|
48 |
REATE PROCEDURE [dbo].[GetContengencia2MHPaginatedFiltered] @PageNumber INT,
... |
COFASA: GetContengencia2MHPaginatedFiltered - (fn) |
Y |
3 |
editar
eliminar
|
|
47 |
REATE PROCEDURE [dbo].[GetContengencia2MHPaginated]
@PageNumber INT,
@PageSize INT
AS
BE... |
COFASA: GetContengencia2MHPaginated - (fn) |
Y |
3 |
editar
eliminar
|
|
46 |
REATE PROCEDURE [dbo].[GetContengencia1MHPaginatedFiltered] @PageNumber INT,
... |
COFASA: GetContengencia1MHPaginatedFiltered - (fn) |
Y |
3 |
editar
eliminar
|
|
45 |
REATE PROCEDURE [dbo].[GetContengencia1MHPaginated]
@PageNumber INT,
@PageSize INT
AS
BE... |
COFASA: GetContengencia1MHPaginated - (fn) |
Y |
3 |
editar
eliminar
|
|
44 |
REATE PROC dtes_tomarcontrol (@idSalida as Int, @TipoComp varchar(4)) as
BEGIN
DECLARE @i int
... |
COFASA: dtes_tomarcontrol - (fn) |
Y |
3 |
editar
eliminar
|
|
43 |
REATE FUNCTION dbo.dtes_FncJson(@dtes_docs_id as Int, @tpoDTE Varchar(3), @numcontrol Int, @uuid Var... |
COFASA: dtes_FncJson - (fn) |
Y |
3 |
editar
eliminar
|
|
42 |
REATE FUNCTION dbo.dtes_dashboard()
RETURNS varchar(max) AS BEGIN
DECLARE @JsonTxt varchar(max);
... |
COFASA: dtes_dashboard - (fn) |
Y |
3 |
editar
eliminar
|
|
41 |
REATE view [dbo].[vDetalleCOFASA] as
SELECT
'FAC' as TipoComp,
sq.idSalida,
... |
COFASA: vDetalleCOFASA |
Y |
3 |
editar
eliminar
|
|
40 |
REATE view [dbo].[_vDatosDTSECTG] as
select
-- Informacion DOC enContingencia
ectgl.dtes_docs... |
COFASA: _vDatosDTSECTG |
Y |
3 |
editar
eliminar
|
|
39 |
CREATE view [dbo].[_vCatalogoMH] as
Select idCatalogoMH, NoCatalogo,'01'+Codigo as codigo, dbo.... |
COFASA: _vCatalogoMH |
Y |
3 |
editar
eliminar
|
|
38 |
REATE view [dbo].[_vPendientesMH] as
select
pc.idsalida ,
case when pc.numFac is null then 99999... |
COFASA: _vPendientesMH |
Y |
3 |
editar
eliminar
|
|
37 |
REATE view [dbo].[_vNORecibidosMH] as
select
pc.idsalida ,
pc.numFac ,
pc.fechareg ,
pc.TipoCom... |
COFASA:_vNORecibidosMH |
Y |
3 |
editar
eliminar
|
|
36 |
REATE view [dbo].[_vFacturadosMH] as
select
pc.idsalida ,
pc.numFac ,
pc.fechareg ,
pc.TipoComp... |
COFASA: _vFacturadosMH |
Y |
3 |
editar
eliminar
|
|
35 |
REATE view [dbo].[_vDatosDTSINV] as
select DISTINCT inv.id_doc_invalidado, inv.idSalida, inv.idSali... |
COFASA: _vDatosDTSINV |
Y |
3 |
editar
eliminar
|
|
34 |
REATE view [dbo].[_vDatosDTSPDF] as
SELECT
doc.idsalida,
doc.TipoComp,
dte.dtes_docs... |
COFASA: _vDatosDTSPDF |
Y |
3 |
editar
eliminar
|
|
33 |
NSERT INTO core.m_product (m_product_id, ad_client_id, ad_org_id, createdby, updatedby, value, name,... |
Insertar 206 Productos en tabla: M_PRODUCT, EMR_TREATMENT y actualizar la CLASIFICACION DE PRODUCTOS |
Y |
1 |
editar
eliminar
|
|
32 |
- DROP FUNCTION core.apicore_gettabbyid(int4, int4);
CREATE OR REPLACE FUNCTION core.apicore_gett... |
apicore_gettabbyid(int4, int4):
actualizacion |
Y |
1 |
editar
eliminar
|
|
31 |
- DROP FUNCTION core.apicore_gettabledirect(varchar, numeric);
CREATE OR REPLACE FUNCTION core.ap... |
APICORE_GETTABLEDIRECT(varchar, numeric): actualizar función |
Y |
1 |
editar
eliminar
|
|
30 |
ROP VIEW core.ejdsp_manual_v;
DROP VIEW core.ejdsp_manual_h;
DROP VIEW core.ad_field_v;
DROP VIEW... |
AD_FIELD -> Ampliar tamaño de columna "name" |
Y |
1 |
editar
eliminar
|
|
29 |
PDATE core.ad_field SET ad_client_id=0, ad_org_id=0, isactive='Y', created='2023-06-23 03:11:57.773'... |
AD_FIELD: actualizaciones para formulario NEWPATIENT |
Y |
1 |
editar
eliminar
|
|
28 |
- DROP FUNCTION core.apids_getcatalogs(int4, varchar, text);
CREATE OR REPLACE FUNCTION core.apid... |
apids_getcatalogs: dar seguimiento agregando inicio y fin de ejecución |
Y |
1 |
editar
eliminar
|
|
27 |
REATE OR REPLACE VIEW core.c_project_v2now
AS SELECT cp.c_project_id AS c_project_v_id,
cp.c_p... |
_PROJECT_Vhst: VIEW: 1000006, con "level":"2now" filtrando todos los proyectos (planes de tratamient... |
Y |
1 |
editar
eliminar
|
|
26 |
- core.cub_ledger_v source
CREATE OR REPLACE VIEW core.cub_ledger_v
AS SELECT q.ad_client_id,
... |
CUB_LEDGER: corregir respuesta para "medicalname", insuranceinfo".... |
Y |
1 |
editar
eliminar
|
|
25 |
DELETE FROM core.c_payselection WHERE c_payselection_id=1000011;
DELETE FROM core.c_payselection W... |
C_PAYSELECTION: Eliminar registros creados de prueba y se consideran basura |
Y |
1 |
editar
eliminar
|
|
24 |
CREATE OR REPLACE FUNCTION core.apiproc_cprojectline_validateprice(p_projectline_id integer)
RETU... |
C_PROJECTLINE: Validar que al menos en la lista de precios de EJD haya precio > 0 |
Y |
1 |
editar
eliminar
|
|
23 |
pdate core.ad_column set name = 'Employment Status', updated = now() where ad_column_id = 1002034;
... |
MR_FRMNWPATIENT: en AD_Form / AD_Column: Corregir nombre en columna "Gender" y colocar "Employment S... |
Y |
1 |
editar
eliminar
|
|
22 |
- DROP FUNCTION core.apicore_getinfosession(int4);
CREATE OR REPLACE FUNCTION core.apicore_getinf... |
AD_SESSION: Agregar M_PriceList_ID en core.apicore_getinfosession(p_session);
|
Y |
1 |
editar
eliminar
|