SZ0CONSUMOHOSPITALARDETALHE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CDCOLIGADA DCODCOLIGADA 2 null
SZ0CONSUMOHOSPITALARDETALHELOG.CDCOLIGADA FKSZ0CONSUMOHOSPITALARDETALHELC
SZ0CONSUMOHOSPITALARDETCOMPL.CDCOLIGADA FKSZ0CONDET_SZ0CONHOSPDETCMPLC
SZ0CONSUMOHOSPITALAR.CDCOLIGADA FKSZ0CONSUMOHOSPDET_SZ0CONHOSPC
CDFILIAL smallint 2 null
SZ0CONSUMOHOSPITALARDETALHELOG.CDFILIAL FKSZ0CONSUMOHOSPITALARDETALHELC
SZ0CONSUMOHOSPITALARDETCOMPL.CDFILIAL FKSZ0CONDET_SZ0CONHOSPDETCMPLC
SZ0CONSUMOHOSPITALAR.CDFILIAL FKSZ0CONSUMOHOSPDET_SZ0CONHOSPC
CDCONSUMOHOSPITALAR numeric 12 null
SZ0CONSUMOHOSPITALARDETALHELOG.CDCONSUMOHOSPITALAR FKSZ0CONSUMOHOSPITALARDETALHELC
SZ0CONSUMOHOSPITALARDETCOMPL.CDCONSUMOHOSPITALAR FKSZ0CONDET_SZ0CONHOSPDETCMPLC
SZ0CONSUMOHOSPITALAR.CDCONSUMOHOSPITALAR FKSZ0CONSUMOHOSPDET_SZ0CONHOSPC
CDCONSUMOHOSPITALARDETALHE numeric 12 null
SZ0CONSUMOHOSPITALARDETALHELOG.CDCONSUMOHOSPITALARDETALHE FKSZ0CONSUMOHOSPITALARDETALHELC
SZ0CONSUMOHOSPITALARDETCOMPL.CDCONSUMOHOSPITALARDETALHE FKSZ0CONDET_SZ0CONHOSPDETCMPLC
DTLANCAMENTO DDATETIME 16,3 √ null
CDMEDICO varchar 50 √ null
CDCONVENIO varchar 50 √ null
CDCENTROCUSTO varchar 45 √ null
CDUNIDADEATENDIMENTO varchar 50 √ null
CDPROCEDIMENTOGRUPO varchar 50 √ null
CDPROCEDIMENTO varchar 50 √ null
DTPROCEDIMENTOINICIO DDATETIME 16,3 √ null
DTPROCEDIMENTOFIM DDATETIME 16,3 √ null
STATUSITEM varchar 25 √ null
CDGRUPOINSUMO varchar 50 null
CDINSUMO varchar 50 null
QTUTILIZADA numeric 16,2 √ null
VLCUSTOUNITARIO numeric 18,4 √ null
VLCUSTOTOTAL numeric 18,4 √ null
QTCOBRADA numeric 16,2 √ null
VLCOBRADOUNITARIO numeric 16,2 √ null
VLCOBRADOTOTAL numeric 16,2 √ null
VLFATORCOBRANCA numeric 16,2 √ null
CDPACOTE varchar 50 √ null
VLCUSTOVARIAVEL numeric 35,18 √ null
VLCUSTOREFEICAO numeric 35,18 √ null
VLCUSTODOACAO numeric 35,18 √ null
VLCUSTOREPASSE numeric 35,18 √ null
VLCUSTOFIXOESPECIFICO numeric 35,18 √ null
VLCUSTOFIXOAPOIO numeric 35,18 √ null
VLCUSTOFIXOADM numeric 35,18 √ null
DTPACIENTEADMISSAO DDATETIME 16,3 √ null
DTPACIENTESAIDA DDATETIME 16,3 √ null
TEMPO numeric 16,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CDTABELAINSUMO varchar 50 null
CDCHAVEORIGEM varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSZ0CONSUMOHOSPITALARDETALHE Primary key Asc/Asc/Asc/Asc CDCOLIGADA + CDFILIAL + CDCONSUMOHOSPITALAR + CDCONSUMOHOSPITALARDETALHE

Relationships

Close relationships within degrees of separation