SSERVICO

28 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
LSERVICO.CODCOLIGADA FKLSERVICO_SSERVICOR
SATIVIDADE.CODCOLIGADA FKSATIVIDADE_SSERVICOR
SBOLSA.CODCOLIGADA FKSBOLSA_SSERVICOR
SBOLSAALUNO.CODCOLIGADA FKSBOLSAALUNO_SSERVICOR
SCFGSERVBOLSAIRMAOS.CODCOLIGADA FKSCFGSERVBOLSAIRMAOS_SSERVICOR
SCONCESSAOBOLSASERVICO.CODCOLIGADA FKSCONCBOLSASERV_SSERVICOR
SCONTRATOSERVICO.CODCOLIGADA FKSCONTRATOSERVICO_SSERVICOR
SCONTRATOSERVICOCONT.CODCOLIGADA FKSCONTRATOSERVICOCONT_SSERVICR
SEXTVISITAEVENTO.CODCOLIGADA FKSEXTVISITAEVENTO_SSERVICOR
SPARCELA.CODCOLIGADA FKSPARCELA_SSERVICOR
SPARCELASERVICOCONT.CODCOLIGADA FKSPARCELASERVICOCONT_SSERVICOR
SPARCPLANO.CODCOLIGADA FKSPARCPLANO_SSERVICOR
SPROJBOLSISTABOLSA.CODCOLIGADA FKSPROJBOLSISTABOLSA_SSERVICOR
SPROSPECTBOLSA.CODCOLIGADA FKSPROSPECTBOLSA_SSERVICOR
SPSCONCURSOBOLSASEREVICO.CODCOLIGADA FKSPSCONCURSOBOLSASEREVICO_SSR
SSERVICOCONT.CODCOLIGADA FKSSERVICOCONT_SSERVICOR
SSERVICOPLANOPGTO.CODCOLIGADA FKSSERVICOPLANOPGTO_SSERVICOR
SSERVICORAT.CODCOLIGADA FKSSERVICORAT_SSERVICOR
STEMPLATEACORDOSERVICO.CODCOLIGADA FKSTEMPLATEACORDOSERVICO_SSERR
STIPOATENDIMENTO.CODCOLIGADA FKSTIPOATENDIMENTO_SSERVICOR
FTB2.CODCOLIGADA FKSSERVICO_FTB2R
STIPOCURSO.CODCOLIGADA FKSSERVICO_STIPOCURSOR
FTDO.CODCOLIGADA FKSSERVICO_FTDOR
FTB3.CODCOLIGADA FKSSERVICO_FTB3R
FTB1.CODCOLIGADA FKSSERVICO_FTB1R
FTB4.CODCOLIGADA FKSSERVICO_FTB4R
FTB5.CODCOLIGADA FKSSERVICO_FTB5R
CODSERVICO varchar 10 null
LSERVICO.CODSERVICO FKLSERVICO_SSERVICOR
SATIVIDADE.CODSERVICO FKSATIVIDADE_SSERVICOR
SBOLSA.CODSERVICOBOLSACRED FKSBOLSA_SSERVICOR
SBOLSAALUNO.CODSERVICO FKSBOLSAALUNO_SSERVICOR
SCFGSERVBOLSAIRMAOS.CODSERVICO FKSCFGSERVBOLSAIRMAOS_SSERVICOR
SCONCESSAOBOLSASERVICO.CODSERVICO FKSCONCBOLSASERV_SSERVICOR
SCONTRATOSERVICO.CODSERVICO FKSCONTRATOSERVICO_SSERVICOR
SCONTRATOSERVICOCONT.CODSERVICO FKSCONTRATOSERVICOCONT_SSERVICR
SEXTVISITAEVENTO.CODSERVICO FKSEXTVISITAEVENTO_SSERVICOR
SPARCELA.CODSERVICO FKSPARCELA_SSERVICOR
SPARCELASERVICOCONT.CODSERVICO FKSPARCELASERVICOCONT_SSERVICOR
SPARCPLANO.CODSERVICO FKSPARCPLANO_SSERVICOR
SPROJBOLSISTABOLSA.CODSERVICO FKSPROJBOLSISTABOLSA_SSERVICOR
SPROSPECTBOLSA.CODSERVICO FKSPROSPECTBOLSA_SSERVICOR
SPSCONCURSOBOLSASEREVICO.CODSERVICO FKSPSCONCURSOBOLSASEREVICO_SSR
SSERVICOCONT.CODSERVICO FKSSERVICOCONT_SSERVICOR
SSERVICOPLANOPGTO.CODSERVICO FKSSERVICOPLANOPGTO_SSERVICOR
SSERVICORAT.CODSERVICO FKSSERVICORAT_SSERVICOR
STEMPLATEACORDOSERVICO.CODSERVICO FKSTEMPLATEACORDOSERVICO_SSERR
STIPOATENDIMENTO.CODSERVICO FKSTIPOATENDIMENTO_SSERVICOR
NOME varchar 60 null
VALOR RMDVALOR4 17,4 √ null
HIERARQUIA varchar 20 √ null
CODTIPOCURSO smallint 2 null
STIPOCURSO.CODTIPOCURSO FKSSERVICO_STIPOCURSOR
CODCOLCXA DCODCOLIGADANULL 2 √ null
FCXA.CODCOLIGADA FKSSERVICO_FCXAR
CODCXA varchar 10 √ null
FCXA.CODCXA FKSSERVICO_FCXAR
VERIFICAINADIMPLENCIA varchar 1 √ ('S')
TIPOCONTABILLAN smallint 2 √ null
CODTDO varchar 10 √ null
FTDO.CODTDO FKSSERVICO_FTDOR
CODTB1FLX varchar 25 √ null
FTB1.CODTB1FLX FKSSERVICO_FTB1R
CODTB2FLX varchar 25 √ null
FTB2.CODTB2FLX FKSSERVICO_FTB2R
CODTB3FLX varchar 25 √ null
FTB3.CODTB3FLX FKSSERVICO_FTB3R
CODTB4FLX varchar 25 √ null
FTB4.CODTB4FLX FKSSERVICO_FTB4R
CODTB5FLX varchar 25 √ null
FTB5.CODTB5FLX FKSSERVICO_FTB5R
CONTABCOMPETENCIA varchar 1 √ null
IDPRD int 4 √ null
TPRODUTO.IDPRD FKSSERVICO_TPRDR
CODCOLNATFINANCEIRA DCODCOLIGADANULL 2 √ null
TTBORCAMENTO.CODCOLIGADA FKSSERVICO_TTBORCAMENTOR
CODNATFINANCEIRA varchar 40 √ null
TTBORCAMENTO.CODTBORCAMENTO FKSSERVICO_TTBORCAMENTOR
IDFT int identity 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
PERMITEACORDO varchar 1 null
APROVEITACONTACORRENTE varchar 1 √ null
CONSIDERAPARCELAFIXA varchar 1 √ null
DISPONIVELEXTENSAO varchar 1 √ null
DESCONSIDERACREDITORETROATIVO varchar 1 √ null
PGCARTAODEBITO char 1 ('S')
PGCARTAOCREDITO char 1 ('S')
CONSIDERADESCANTECIPACAO varchar 1 √ ('N')
DESCONSIDERANFECOMPETENCIA varchar 1 ('N')
PGBOLETO varchar 1 ('S')
NUMEROMAXIMOPARCELAS int 4 √ null
CARREGATRBDEFAULTCLIFOR varchar 1 √ ('N')
PGPIX varchar 1 ('N')

Indexes

Constraint Name Type Sort Column(s)
PKSSERVICO Primary key Asc/Asc CODCOLIGADA + CODSERVICO
SXSSERVICOIDFT Must be unique Asc IDFT
SXSSERVICOVERINADIMP Performance Asc VERIFICAINADIMPLENCIA

Check Constraints

Constraint Name Constraint
CK__SSERVICO__7ECD872A ([VERIFICAINADIMPLENCIA] = 'S' or [VERIFICAINADIMPLENCIA] = 'N')

Relationships

Close relationships within degrees of separation