ESERVICOS

26 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SERVICO_COD int 4 null
EATIVEXT.CODSERV FKEATIVEXT_ESERVICOSR
EBOLSACRED.CODSERV FKEBOLSACRED_ESERVICOSR
ECCXASERVICO.CODSERVICO FKECCXASERVICO_ESERVICOSR
ECONCESBOLSERV.CODSERVICO FKECONCESBOLSERV_ESERVICOSR
EDESCLAN.TIPOLANC FKEDESCLAN_ESERVICOSR
EMODCONPC.CODSERV FKEMODCONPC_ESERVICOSR
EPARAMFIN.SERVICOACRESCIMOAUTO FKEPARAMFINAC_ESERVICOSR
EPARAMFIN.SERVICODESCONTOAUTO FKEPARAMFINDE_ESERVICOSR
ESERVCONT.CODSERVICO FKESERVCONT_ESERVICOSR
ESERVDOCUMENTO.CODSERVICO FKESERVDOCUMENTO_ESERVICOSR
ESERVICOSTPRD.SERVICO_COD FKPKESERVICOSTPRD_ESERVICOSR
ESERVPER.CODSERV FKESERVPER_ESERVICOSR
ESRVEVENT.SERVICO FKESRVEVENT_ESERVICOSR
ETIPOATENDIMENTO.CODSERVICO FKETIPOATENDIMENTO_ESERVICOSR
ETIPOPROT.CODSERV PKETIPOPROT_ESERVICOSR
USERVPER.CODSERV FKUSERVPER_ESERVICOSR
SERVICO_DESC varchar 30 √ null
VALOR numeric 17,2 √ null
BANCO varchar 6 √ null
ORDEM varchar 10 √ null
PERCIMPOSTO numeric 17,2 √ null
EXTRA varchar 1 √ null
CREDITOEDUCATIVO char 1 √ null
CODCOLCXA DCODCOLIGADANULL 2 √ null
GCOLIGADA.CODCOLIGADA FKESERVICOS_GCOLIGADAR
FCXA.CODCOLIGADA FKESERVICOS_FCXAR
CODCXA varchar 10 √ null
FCXA.CODCXA FKESERVICOS_FCXAR
TIPOCONTABILLAN smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKESERVICOS Primary key Asc SERVICO_COD
ORDEMSERV Performance Asc ORDEM
SERVICO Performance Asc SERVICO_DESC

Relationships

Close relationships within degrees of separation