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