TTMVEXT

193 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TTMVEXTWFLUIG.CODCOLIGADA FKTTMVEXTWFLUIG_TTMVEXTR
TVEN.CODCOLIGADA FKTTMVEXT_TVENR
CPDIARIOPTG.CODCOLIGADA FKTTMVEXT_CPDIARIOPTGR
FTDO.CODCOLIGADA FKTTMVEXT_FTDOR
TRPR.CODCOLIGADA FKTTMVEXT_TRPRR
DCFOP.CODCOLIGADA FKTTMVEXT_DCFOPR
GFORMULA.CODCOLIGADA FKTTMEXT_GFORMULAPESOLIQR
TTMV.CODCOLIGADA FKTTMVEXT_TTMVINDR
TMOTIVOREFMOV.CODCOLIGADA FKTTMVEXT_TMOTIVOREFMOVR
CODTMV varchar 10 null
TTMVEXTWFLUIG.CODTMV FKTTMVEXTWFLUIG_TTMVEXTR
TTMV.CODTMV FKTTMVEXT_TTMVR
GERARNCM smallint 2 √ null
COPIAPERCENTDESCPRD smallint 2 √ null
CODFRMVALOROPLF1 varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFRMVALOROPLF1R
CODFRMVALOROPLF2 varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFRMVALOROPLF2R
CODFRMVALOROPLF3 varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFRMVALOROPLF3R
CODFRMVALOROPLF4 varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFRMVALOROPLF4R
APLICACAOFRM varchar 1 √ null
GFORMULA.APLICACAO FKTTMVEXT_GFORMULAR
EDICAOREPRIT varchar 1 √ null
CODRPRIT varchar 15 √ null
TRPR.CODRPR FKTTMVEXT_TRPRR
EDICAOCOMISREPRIT varchar 1 √ null
PERCCOMISREPRIT RMDVALOR2 17,2 √ null
CARREGALOTEMAISANTIGO smallint 2 √ null
CAMPOSCOMPLMOVVISIVEIS varchar 4000 √ null
CAMPOSCOMPLITMMOVVISIVEIS varchar 4000 √ null
MANTERMOEDAPED DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODFRMVALORIRLAN varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFRMVALORIRLANR
EDICAOPRAZOENTREGA varchar 1 √ null
PRECOTABELA int 4 √ null
PERMITEVALORFINMAIORTOTAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USARCOPIA smallint 2 √ null
CONTROLARDISPOSITIVOSEG smallint 2 √ null
MOTIVOREF varchar 2 √ null
CAMPODESCMOTIVOREF int 4 √ null
COPIARDEPTOMOVPARITEM DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGADEPTOITMMOV DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGADEPTOMOV DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAHORASAIDA smallint 2 √ (0)
EDITARCCOMPLMOVSEPARADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
POSINICIALCODLOTE int 4 √ null
TAMCODLOTE int 4 √ null
COPIARTABOPPARAITEM DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IGNORARSEGCALCULOTRBIT DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CALCULOFINALFAT DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IDMOTIVOREF int 4 √ null
TMOTIVOREFMOV.IDMOTIVOREF FKTTMVEXT_TMOTIVOREFMOVR
GERAAPROPRIACAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
BUSCARTIPODOCDUPEM varchar 1 √ null
EDICAOFILIAL varchar 1 √ null
GERARTRANSFERENCIA smallint 2 √ null
CODDIARIO varchar 5 √ null
CPDIARIOPTG.CODDIARIO FKTTMVEXT_CPDIARIOPTGR
GERALCTAGRUPADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DTEMISSAOBRANCO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
BLOQUEARIMPDOCFORAORDEM smallint 2 √ null
POSINICIALCODGRADE int 4 √ null
TAMCODGRADE int 4 √ null
TIPORATEIO varchar 1 √ ('V')
CODTDO varchar 10 √ null
FTDO.CODTDO FKTTMVEXT_FTDOR
USAVALOROPFRM1 smallint 2 √ null
USAVALOROPFRM2 smallint 2 √ null
CODVALOROPFRM1 varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAFRM1R
CODVALOROPFRM2 varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAFRM2R
CODFRMDESCCONDICIONAL varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAFRMR
CODFRMDESPCONDICIONAL varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULADESPR
ASSOCIAOBJOFICINAIT smallint 2 √ null
GERARLCTCARTAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CONSISTECFOLOTEMOV smallint 2 √ null
QUEBRAFATURAMENTOOPC smallint 2 √ null
USACONTATOFORNECEMAIL smallint 2 √ null
TIPOCARENCIACPG smallint 2 √ null
REGISTRARNFTERCEIROS smallint 2 √ null
AJUSTESALDOFINANCEIRO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAGRPFATURAMENTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
SEGURODEFAULT RMDVALOR4 17,4 √ null
LIBERARDESCSENHA smallint 2 √ null
CODFRMVALSERVICO varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAR
NOMEVALOROPFRM1 varchar 20 √ null
NOMEVALOROPFRM2 varchar 20 √ null
EDITADADOSCOLETA smallint 2 √ null
PEDIDOWEB smallint 2 √ null
USARMOEDAMOV smallint 2 √ null
DISTVALORESOPCIONAIS smallint 2 √ null
CODGRUPOATENDIMENTO int 4 √ null
HTIPOSATENDDOGRUPOATEND.CODGRUPOATENDIMENTO FKTTMVEXT_HTIPOSATENDDOGRUPOATR
CODTIPOATENDIMENTO int 4 √ null
HTIPOSATENDDOGRUPOATEND.CODTIPOATENDIMENTO FKTTMVEXT_HTIPOSATENDDOGRUPOATR
USARLOCALIZACAOBN smallint 2 √ null
DEDUZIRVALORCTRCMOV int 4 √ null
CODFRMCONSISTEMOV varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXTCONSISTE_GFORMULAR
CANCELARMOVFACTOR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IMPORTACAOEXPORTACAO smallint 2 √ (0)
CODFRMDESCCONDICIONALITM varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFRMDESCCONR
CODFRMDESPCONDICIONALITM varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFRMDESPCONR
MOVGERACONTROLEEPI smallint 2 √ (0)
DATALANCAMENTO varchar 1 √ null
EDICAODATALANCAMENTO varchar 1 √ null
NOMEDATALANCAMENTO varchar 20 √ null
TIPOENDERECO smallint 2 √ null
NFE smallint 2 √ null
IDRELATNFE int 4 √ null
TIPORATEIOFRETE smallint 2 √ null
TIPORATEIOSEGURO smallint 2 √ null
TIPORATEIODESC smallint 2 √ null
TIPORATEIODESP smallint 2 √ null
TIPORATEIOEXTRA1 smallint 2 √ null
TIPORATEIOEXTRA2 smallint 2 √ null
TIPORATEIOFRETECTRC smallint 2 √ null
TIPORATEIODEDMAT smallint 2 √ null
TIPORATEIODEDSUB smallint 2 √ null
TIPORATEIODEDOUT smallint 2 √ null
CODFRMRATEIOFRETE varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAFRETER
CODFRMRATEIOSEGURO varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULASEGUROR
CODFRMRATEIODESC varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULADESCR
CODFRMRATEIODESP varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULARATDESPR
CODFRMRATEIOEXTRA1 varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAEXTRA1R
CODFRMRATEIOEXTRA2 varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAEXTRA2R
CODFRMRATEIOFRETECTRC varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAFRETECTRCR
CODFRMRATEIODEDMAT varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULADEDMATR
CODFRMRATEIODEDSUB varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULADEDSUBR
CODFRMRATEIODEDOUT varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULADEDOUTR
IDNATFORAESTADO int 4 √ null
DCFOP.IDNAT FKTTMVEXT_DCFOPR
IDNATFORAESTADO2 int 4 √ null
DCFOP.IDNAT FKTTMVEXT_DCFOP2R
CODFRMVALORUNTORCAMENTO varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULAORCAMENTOR
EDICAOTBORCAMENTOIT varchar 1 √ null
CODFRMVALSERVICONFE varchar 8 √ null
USARATEIOORCAMENTO smallint 2 √ null
AJUSTARCUSTOMEDIOFILIAL smallint 2 √ (0)
NFEESTADUAL smallint 2 √ null
IDRELATDANFE int 4 √ null
FORMATODANFE smallint 2 √ null
DISTVALOROPC1 smallint 2 √ null
DISTVALOROPC2 smallint 2 √ null
DISTVALOROPC3 smallint 2 √ null
DISTVALOROPC4 smallint 2 √ null
DISTVALOROPC5 smallint 2 √ null
DISTVALOROPC6 smallint 2 √ null
DISTVALOROPC7 smallint 2 √ null
DISTVALOROPC8 smallint 2 √ null
CODFRMCTRCARATEAR varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFRMCTRCARATEARR
SEQUENCIACALCULO varchar 40 √ null
EDITAVENDEDORIT smallint 2 √ null
CODVEN1IT varchar 16 √ null
TVEN.CODVEN FKTTMVEXT_TVENR
COPIARVENMOVPARAITEM DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODFRMRATEIOCCUSTODEPTOMOV varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULACUSTODEPTOR
LOCALESTOQUEPORITEM DLOGICO 2 (0)
EDITAMUNICIPIOITEM smallint 2 √ null
CONTROLETERCEIROS smallint 2 √ null
CODFRMVALORFINTERCEIROS varchar 8 √ null
GFORMULA.CODIGO FKTTMVEXT_GFORMULATERCEIROSR
CODTMVINDUSTRIALIZACAO varchar 10 √ null
TTMV.CODTMV FKTTMVEXT_TTMVINDR
EDITACONDPAGTOCLIFOR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VISUALIZACLIFORRPR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODCLASSIFICACAO varchar 5 √ null
HCLASSIFATENDIMENTO.CODCLASSIFICACAO FKTTMVEXT_HCLASSIFATENDIMENTOR
PRIORIDADE int 4 √ null
NFEMUNICIPAL smallint 2 √ null
TIPOVINCULOMOV int 4 √ null
DATAPRAZOENTREGA varchar 1 √ null
INTEGRARBIBLIOS smallint 2 √ null
EDICAOTBGRUPOORCAMENTOIT varchar 1 √ null
CODCOLATENDIMENTO DCODCOLIGADANULL 2 √ null
HCLASSIFATENDIMENTO.CODCOLIGADA FKTTMVEXT_HCLASSIFATENDIMENTOR
HTIPOSATENDDOGRUPOATEND.CODCOLIGADA FKTTMVEXT_HTIPOSATENDDOGRUPOATR
EDITARPARCELAMENTO varchar 1 √ null
USARATEIOTAREFA smallint 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODFRMPESOBRU varchar 8 √ null
GFORMULA.CODIGO FKTTMEXT_GFORMULAPESOBRUR
CODFRMPESOLIQ varchar 8 √ null
GFORMULA.CODIGO FKTTMEXT_GFORMULAPESOLIQR
SEQCALCULOVALFINRAT varchar 40 √ null
IDPRDFRETE int 4 √ null
TPRODUTO.IDPRD FKTTMVEXT_TPRDR
USATOTVSCOLABORACAO smallint 2 √ null
TIPOENVIOXML smallint 2 √ null
MENSAGEMPADRAOEMAIL varchar 5 √ null
CODCOLRELATDANFENET DCODCOLIGADANULL 2 √ null
RRPTREPORT.CODCOLIGADA FKTTMVEXT_RRPTREPORTR
IDRELATDANFENET int 4 √ null
RRPTREPORT.ID FKTTMVEXT_RRPTREPORTR
CTE smallint 2 √ null
FORMATODACTE smallint 2 √ null
IDRELATDACTE int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
COLIGADACENTRALIZADORA smallint 2 √ null
CLASSVINCULOMOV smallint 2 √ null
CALCULAICMSSTCST60 smallint 2 √ null
USADEDUCAOCNT smallint 2 √ null
VALFATPARCVALORMOV smallint 2 √ null
VALFATPARCVALORITEM smallint 2 √ null
INTEGRASIGAMNT smallint 2 √ null
INTEGRAMULTADOCUMENTOHONORARIO smallint 2 √ null
IDPRDRECEBIMENTOCTE int 4 √ null
TIPOAJUSTEOP int 4 √ null
TIPOAPROVACAOFLUIG int 4 ((0))
PROCFLUIGFATURAMENTO varchar 30 √ null
TIPOAGRUPFLUIGFATURAMENTO int 4 √ null
PROCFLUIGCOTACAO varchar 30 √ null
TIPOAGRUPFLUIGCOTACAO int 4 √ null
CODCOLRELATDACTE DCODCOLIGADANULL 2 √ null
CODCOLRELATDAMDFE DCODCOLIGADANULL 2 √ null
IDRELATDAMDFE int 4 √ null
MODAL smallint 2 √ null
TIPOEMITENTEMDFE smallint 2 √ null
BUSCAPISCOFINSEM varchar 1 √ null
CALCULALEITRANSP smallint 2 √ null
MANTEMNUMERORENUMERA smallint 2 √ null
PERMITECANCELARLAN DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODCOLRELDUPNET DCODCOLIGADANULL 2 √ null
RRPTREPORT.CODCOLIGADA FKTTMVEXT_RRPTREPORTDUPNETR
IDRELATDUPNET int 4 √ null
RRPTREPORT.ID FKTTMVEXT_RRPTREPORTDUPNETR
CODCOLRELFATNET DCODCOLIGADANULL 2 √ null
RRPTREPORT.CODCOLIGADA FKTTMVEXT_RRPTREPORTFATNETR
IDRELATFATNET int 4 √ null
RRPTREPORT.ID FKTTMVEXT_RRPTREPORTFATNETR
CODCOLRELMOVNET DCODCOLIGADANULL 2 √ null
RRPTREPORT.CODCOLIGADA FKTTMVEXT_RRPTREPORTMOVNETR
IDRELATMOVNET int 4 √ null
RRPTREPORT.ID FKTTMVEXT_RRPTREPORTMOVNETR
INTEGRADOPARADIGMA smallint 2 √ null
VALIDATRIBUTOSXML varchar 1 √ null
USARETENCAOIT varchar 1 √ null
NFCE smallint 2 √ null
FORMATONFCE smallint 2 √ null
CODCOLRELATNFCE DCODCOLIGADANULL 2 √ null
RRPTREPORT.CODCOLIGADA FKTTMVEXT_IDRELATNFCER
IDRELATNFCE int 4 √ null
RRPTREPORT.ID FKTTMVEXT_IDRELATNFCER
NAOCONSISTECLIFORMOVRELAC smallint 2 √ null
DISTVALORSERV smallint 2 √ null
USADEDUCAOIT smallint 2 √ null
DATAREGISTROK280 varchar 1 √ null
CODMENSAGEMINTEGRACAO smallint 2 ((0))
USAQTDETRIBUTAVEL smallint 2 ((0))
TIPOSERVICOCTEOS varchar 1 √ null
MOVIMENTOREPASSEREINF smallint 2 √ null
ASSOCIACODBEMSIGAMNTIT smallint 2 √ null
EDITANUMPEDIDO smallint 2 √ null
BUSCARNATORCDEFAULTPRD varchar 1 √ null
TIPOORCAMENTO varchar 1 √ null
MOVIMENTOREMESSASIMBOLICA smallint 2 √ null
INCLUSAOAUTOMATICACOTACAO smallint 2 √ null
ENVIOAUTOMATICOPARADIGMA smallint 2 √ null
EDITARCNTITEM varchar 1 √ null
MOVIMENTOREMESSAPARCELADAEXPOR smallint 2 √ null
CODFRMPRECOITEMBAIXAMU varchar 8 √ null
RELACIONARNOTAS DLOGICONULL 2 √ null
GERACONTRATOTCOP DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODTMVREPORTEINSUMOAUTOMATICO varchar 10 √ null
INTEGRAREPORTINSUMO smallint 2 √ null
CODFRMREPORTINSUMO varchar 8 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTTMVEXT Primary key Asc/Asc CODCOLIGADA + CODTMV

Relationships

Close relationships within degrees of separation