FTEMPLATEACORDO

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FACORDO.CODCOLIGADA FKFACORDO_FTEMPLATEACORDOR
FCONTRATO.CODCOLIGADA FKFCONTRATO_FTEMPLATEACORDOR
FTEMPLATEACORDOHABILITFILIAL.CODCOLIGADA FKFTEMPLATEACHBTFILIAL_FTEMPLAR
FTEMPLATEACORDOPAGTO.CODCOLIGADA FKFTEMPLATEACORDOPAGTO_FTEMPLAR
FTEMPLATEACORDOPERFIL.CODCOLIGADA FKFTEMPLATEACORDOPERFIL_FTEMPLR
STEMPLATEACORDOSERVICO.CODCOLIGADA FKSTEMPLATEACORDOSERVICO_FTEMR
FTB2.CODCOLIGADA FKFTEMPLATEACORDO_FTB2R
GCCUSTO.CODCOLIGADA FKFTEMPLATEACORDO_GCCUSTOR
FTDO.CODCOLIGADA FKFTEMPLATEACORDO_FTDOR
FTB3.CODCOLIGADA FKFTEMPLATEACORDO_FTB3R
FTB1.CODCOLIGADA FKFTEMPLATEACORDO_FTB1R
FTB4.CODCOLIGADA FKFTEMPLATEACORDO_FTB4R
GFILIAL.CODCOLIGADA FKFTEMPLATEACORDO_GFILIALR
FTB5.CODCOLIGADA FKFTEMPLATEACORDO_FTB5R
IDTEMPLATEACORDO int 4 null
FACORDO.IDTEMPLATEACORDO FKFACORDO_FTEMPLATEACORDOR
FCONTRATO.IDTEMPLATEACORDO FKFCONTRATO_FTEMPLATEACORDOR
FTEMPLATEACORDOHABILITFILIAL.IDTEMPLATEACORDO FKFTEMPLATEACHBTFILIAL_FTEMPLAR
FTEMPLATEACORDOPAGTO.IDTEMPLATEACORDO FKFTEMPLATEACORDOPAGTO_FTEMPLAR
FTEMPLATEACORDOPERFIL.IDTEMPLATEACORDO FKFTEMPLATEACORDOPERFIL_FTEMPLR
STEMPLATEACORDOSERVICO.IDTEMPLATEACORDO FKSTEMPLATEACORDOSERVICO_FTEMR
DESCRICAO varchar 100 √ null
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKFTEMPLATEACORDO_GFILIALR
CODDEPARTAMENTO varchar 25 √ null
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKFTEMPLATEACORDO_GCCUSTOR
CODTDO varchar 10 √ null
FTDO.CODTDO FKFTEMPLATEACORDO_FTDOR
CODCOLCXA DCODCOLIGADANULL 2 √ null
FCXA.CODCOLIGADA FKFTEMPLATEACORDO_FCXAR
CODCXA varchar 10 √ null
FCXA.CODCXA FKFTEMPLATEACORDO_FCXAR
CODTB1FLX varchar 25 √ null
FTB1.CODTB1FLX FKFTEMPLATEACORDO_FTB1R
CODTB2FLX varchar 25 √ null
FTB2.CODTB2FLX FKFTEMPLATEACORDO_FTB2R
CODTB3FLX varchar 25 √ null
FTB3.CODTB3FLX FKFTEMPLATEACORDO_FTB3R
CODTB4FLX varchar 25 √ null
FTB4.CODTB4FLX FKFTEMPLATEACORDO_FTB4R
CODTB5FLX varchar 25 √ null
FTB5.CODTB5FLX FKFTEMPLATEACORDO_FTB5R
USARJUROSFUTUROS smallint 2 √ null
GERANUMDOCUMENTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
MANTERDIAVENC DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
QUANTIDADEPARCELAS smallint 2 √ null
INTERVALODIAS smallint 2 √ null
PRAZO smallint 2 √ null
TAXAJUROSDIAMIN RMDVALOR4 17,4 √ null
TAXAJUROSDIAMAX RMDVALOR4 17,4 √ null
VALORACRESCIMO RMDVALOR4 17,4 √ null
PERCACRESCIMOMIN RMDVALOR4 17,4 √ null
PERCACRESCIMOMAX RMDVALOR4 17,4 √ null
VALORLCTSMIN RMDVALOR4 17,4 √ null
VALORLCTSMAX RMDVALOR4 17,4 √ null
DISPONIVELWEB DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
EFETIVACAOACORDO smallint 2 √ null
HISTORICODEFAULT varchar 250 √ null
COPIARCAMPOSCOMPLACORDO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PERMITEALTERARJUROS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PERMITEALTERARDESCONTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PERMITEALTERARACRESCIMO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PERMITEALTERARNUMPARC DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PERMITELANCSAVENCER DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
INFORMARDEFAULTS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
EXIBIRSOMAVALORES DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
MEIOPAGTOOBRIGATORIO smallint 2 √ null
UTILIZARAPROVACAO smallint 2 √ null
CODCOLATENDIMENTO DCODCOLIGADANULL 2 √ null
HCLASSIFATENDIMENTO.CODCOLIGADA FKFTEMPLATEACORDO_HCLASSIFATENR
HTIPOSATENDDOGRUPOATEND.CODCOLIGADA FKFTEMPLATEACORDO_HTIPOSATENDDR
CODGRUPOATENDIMENTO int 4 √ null
HTIPOSATENDDOGRUPOATEND.CODGRUPOATENDIMENTO FKFTEMPLATEACORDO_HTIPOSATENDDR
CODTIPOATENDIMENTO int 4 √ null
HTIPOSATENDDOGRUPOATEND.CODTIPOATENDIMENTO FKFTEMPLATEACORDO_HTIPOSATENDDR
CODCLASSIFICACAO varchar 5 √ null
HCLASSIFATENDIMENTO.CODCLASSIFICACAO FKFTEMPLATEACORDO_HCLASSIFATENR
PRIORIDADE int 4 √ null
OBTERACEITEDOC DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODCOLRELATACEITE DCODCOLIGADANULL 2 √ null
RRPTREPORT.CODCOLIGADA FKFTEMPLATEACORDO_RRPTREPORTR
IDRELATACEITE int 4 √ null
RRPTREPORT.ID FKFTEMPLATEACORDO_RRPTREPORTR
VALORDESCONTO RMDVALOR4 17,4 √ null
PERCDESCONTOMIN RMDVALOR4 17,4 √ null
PERCDESCONTOMAX RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLRELATNEGOCIACAO DCODCOLIGADANULL 2 √ null
IDRELATNEGOCIACAO int 4 √ null
PROCESSOFLUIG varchar 30 √ null
FLUIGIDEMPRESA int 4 √ null
PERMITEACORDOBOLETO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
SOBREPORDEFTEMPLATESOBRELAN DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DATADEFBXACORDO int 4 √ null
PERMITENEGLANACORDO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PERMITETROCACFO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DATAINIVIGENCIA datetime2 16,7 √ null
DATAFIMVIGENCIA datetime2 16,7 √ null
PERCENTPRIMEIRAPARCELA RMDVALOR2 17,2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKFTEMPLATEACORDO Primary key Asc/Asc CODCOLIGADA + IDTEMPLATEACORDO

Relationships

Close relationships within degrees of separation