TTMV

207 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODTMV varchar 10 null
KPARAMETROSFACTOR.CODCAUSALENTRADA FKXPARAMCODTMVPEDABERTO_TTMVR
KPARAMETROSFACTOR.CODTMVENTRADA FKXPARAMCODTMVENTRADA_TTMVR
KPARAMETROSFACTOR.CODTMVENTRADAMP FKXPARAMCODTMVMP_TTMVR
KPARAMETROSFACTOR.CODTMVENTRADAPERDAMATERIAL FKXPARAMCODTMVPERDAMATER_TTMVR
KPARAMETROSFACTOR.CODTMVENTRADASUBP FKXPARAMCODTMVSUBPRODUTO_TTMVR
KPARAMETROSFACTOR.CODTMVSAIDA FKXPARAMCODTMVSAIDA_TTMVR
KPARAMETROSFACTOR.CODTMVSOLICITACAOCOMPRA FKXPARAMCODTMVSOLCOMPRAS_TTMVR
KPARAMETROSFACTOR.CODTMVTRANSFESTQRESERVA FKXPARAMCODTMVEMPENHO_TTMVR
KTMVRESERVAVEL.CODTMV FKKTMVRESERVAVEL_TTMVR
MCNT.CODTMVESTORNODEFAULT FKMCNT_TTMVESTORNOR
MCNT.IDMOVDEFAULT FKMCNT_TTMVR
MTMVPAR.CODTMV FKMTMVPAR_TTMVR
OFAGENDASERV.CODTMV FKOFAGENDASERV_TTMVR
OFATENDIMENTOEXTOS.CODTMV FKOFATENDEXTOS_TTMVR
OFMOVPROCESSAMOS.CODTMV FKOFMOVPROCESSAMOS_TTMVR
OFPARAMS.CODTMVABASTECIMENTOEXTERNO FKOFPARAMS_TTMVCODEXTR
OFPARAMS.CODTMVABASTECIMENTOINTERNO FKOFPARAMS_TTMVCODINTR
OFPARAMS.CODTMVAPROPRIACAOPRD FKOFPARAMS_TTMVR
OFPARAMS.CODTMVENTRADA FKOFPARAMSENTRADA_TTMVR
OFPARAMS.CODTMVORDSERVTERC FKOFPARAMSSAIDASERVTERC_TTMVR
OFPARAMS.CODTMVPROCESSAMENTO FKOFPARAMS_TTMVPROCR
OFPARAMS.CODTMVREQUISICAO FKOFPARAMS_TTMVREQUISICAOR
OFPARAMS.CODTMVSAIDA FKOFPARAMSSAIDA_TTMVR
OFPARAMS.CODTMVSAIREFOR FKOFPARAMS_TTMV1R
OFPARAMS.CODTMVTRANFOBJCOLIGADA FKOFPARAMS_TTMV5R
OFPARAMSINDICE.CODTMV FKOFPARAMSINDICE_TTMVR
OFPARAMSPLANOMANUT.CODTMV FKOFPARAMSPLANOMANUT_TTMVR
OFPARAMSTMV.CODTMV FKFKOFPARAMSTMV_TTMVR
SFILIALTIPOMOVAGRUPALAN.CODTMV FKSFILIALTIPOMOVAGRUPALAN_TTMVR
SZTIPOMOV.CODTMV FKSZTIPOMOV_TTMVR
SZTIPOMOV.CODTMVNBX FKSZTIPOMOV_TTMVNBXR
TCNTPAR.CODTMV FKTCNTPAR_TTMVR
TCNTPAR.CODTMVCOMPRA FKTCNTPAR_TTMVVENDAR
TITMCNT.CODTMV FKTITMCNT_TTMVR
TITMTMV.CODTMV FKTITMTMV_TTMVR
TLAF.CODTMV FKTLAF_TTMVR
TLOT.CODTMVFAT FKTLOT_TTMVR
TLOTEEXPCONTABIL.CODTMVFINAL FKTLOTEEXPCONTABIL_TTMVFINALR
TLOTEEXPCONTABIL.CODTMVINICIAL FKTLOTEEXPCONTABIL_TTMVINICIALR
TLOTEPROCESSO.CODTMV FKTLOTPROC_TTMVR
TMOTIVOREFMOV.CODTMOVDEFAULT FKTMOTIVOREFMOV_TTMVR
TMOV.CODTMV FKTMOV_TTMVR
TPAR.CODTMVSOLICITACAOFATURA FKCODTMVSOLFAT_TTMVR
TPAR.CODTMVSOLICITACAONFE FKCODTMVSOLNFE_TTMVR
TPAR.CODTMVSOLICITACAONFSE FKCODTMVSOLNFSE_TTMVR
TPAR.CODTMVSOLICITACAOREMESSA FKCODTMVSOLREM_TTMVR
TPAR.CODTMVSOLPRDNAOESTOCAVEL FKTPAR_TTMVR
TPONTOVENDA.CODTMV FKTPONTOVENDA_TTMVR
TPONTOVENDA.CODTMVDEVOLUCAO FKTPONTOVENDADEVOLUCAO_TTMVR
TPONTOVENDA.CODTMVPEDIDO FKTPONTOVENDAPEDIDO_TTMVR
TPONTOVENDA.CODTMVRECEB FKTPONTOVENDA_TTMVRECEBR
TPONTOVENDA.CODTMVTRANSF FKTPONTOVENDATRANSF_TTMVR
TSTATUSLOTEPRDTMV.CODTMV FKTSTATUSLOTEPRDTMV_TTMVR
TTMV.CODTMVPED FKTTMV_TTMVPEDR
TTMVEXT.CODTMV FKTTMVEXT_TTMVR
TTMVEXT.CODTMVINDUSTRIALIZACAO FKTTMVEXT_TTMVINDR
TTMVFATURAMENTO.CODTMV FKTTMVFATURAMENTO_TTMVR
TTMVFATURAMENTO.CODTMVFAT FKTTMVFATURAMENTO_TTMVFATR
TTMVPERFILPROCESSO.CODTMV FKTTMVPERFILPROCESSO_TTMVR
TTMVRESERVA.CODTMV FKTTMVRESERVA_TTMVR
TTMVSERIE.CODTMV FKTTMVSERIE_TTMVR
TTMVTIPODOC.CODTMV FKTTMVTIPODOC_TTMVR
TTRBTMV.CODTMV FKTTRBTMV_TTMVR
TUSRTMV.CODTMV FKTUSRTMV_TTMVR
VCONTROLESISTEMA.CODTMVDEVOLUCAO FKVCONTROLESISTEMA_TTMVDEVOLR
VCONTROLESISTEMA.CODTMVEMPRESTIMO FKVCONTROLESISTEMA_TTMVEMPRESTR
XPARAMETROSCOLIGADA.CODTMVCOMISFAT FKXPARAMETROSCOLIGADA_TTMVR
XPARAMMVTO.CODTMV FKXPARAMMVTO_TTMVR
NOME varchar 100 √ null
EPLANILHASEXP.NOME Implied ConstraintR
CODIGOMOVFIXO smallint 2 √ null
TIPOEMITENTE varchar 1 √ null
CODCFOEMISSAO varchar 25 √ null
FCFO.CODCFO FKTTMV_FCFOEMISSAOR
NOMELOCALSAIDA varchar 100 √ null
EDICAOLOCALSAIDA varchar 1 √ null
TIPODESTIN varchar 1 √ null
EDICAODESTIN varchar 1 √ null
CODCFODESTIN varchar 25 √ null
FCFO.CODCFO FKTTMV_FCFODESTINR
TIPOIDENTIFIC varchar 1 √ null
MASCARANUMEROMOV varchar 18 √ null
EDICAONUMEROMOV varchar 1 √ null
BUSCARNUMEROMOV varchar 1 √ null
EDICAOSERIE varchar 1 √ null
SEGNUMSEQUENCIAL varchar 1 √ null
LABELNUMPEDIDO varchar 20 √ null
EDICAONUMPEDIDO smallint 2 √ null
NUMEROPEDIDO varchar 30 √ null
LABELNUMPEDCF varchar 20 √ null
EDICAONUMPEDCF smallint 2 √ null
NUMEROPEDCF varchar 30 √ null
EDICAONATUREZA varchar 1 √ null
TIPONATUREZANOTA varchar 1 √ null
EDICAONATUREZA2 varchar 1 √ null
CODMODELODOCFISC smallint 2 √ null
TIPOICMS varchar 1 √ null
TIPOIPI varchar 1 √ null
NOMEDATASAIDA varchar 20 √ null
EDICAOSAIDA varchar 1 √ null
DATASAIDA varchar 1 √ null
NOMEDATADIGIT varchar 20 √ null
EDICAODIGIT varchar 1 √ null
DATADIGIT varchar 1 √ null
NOMEDATA varchar 20 √ null
EDICAODATA varchar 1 √ null
DATADATA varchar 1 √ null
EDICAOREPR varchar 1 √ null
CODRPR varchar 15 √ null
TRPR.CODRPR FKTTMV_TRPRR
EDICAOCOMISREPR varchar 1 √ null
PERCCOMISREPR RMDVALOR2 17,2 √ null
EDICAOTRANSP smallint 2 √ null
EDICAOTRANSP2 smallint 2 √ null
CODTRA varchar 5 √ null
TTRA.CODTRA FKTTMV_TTRAR
CODTRA2 varchar 5 √ null
TTRA.CODTRA FKTTMV_TTRA2R
EDICAOVIATRANSP smallint 2 √ null
VIATRANSPORTE varchar 15 √ null
EDITADADOSPLACA smallint 2 √ null
EDICAOOBSERVACAO smallint 2 √ null
OBSERVACAO varchar 30 √ null
USAMENSAGEMMOV1 smallint 2 √ null
CODMENMOV1 varchar 5 √ null
TMEN.CODMEN FKTTMV_TMENMOV1R
USAMENSAGEMMOV2 smallint 2 √ null
CODMENMOV2 varchar 5 √ null
TMEN.CODMEN FKTTMV_TMENMOV2R
EDICAOHISTORMOV smallint 2 √ null
EDICAOMARCAVOL smallint 2 √ null
MARCAVOL varchar 10 √ null
EDICAOQTDEVOL smallint 2 √ null
QTDEMOVEASOMA smallint 2 √ null
EDICAOESPECIEVOL smallint 2 √ null
ESPECIEVOL varchar 15 √ null
EDICAOPESOLIQ smallint 2 √ null
EDICAOPESOBRU smallint 2 √ null
PESOLIQMOVEASOMA smallint 2 √ null
PESOBRUMOVEASOMA smallint 2 √ null
CONFITEMPESOZERO varchar 1 √ null
EDICAOCONDPGTO varchar 1 √ null
ALTERACONDPGTO smallint 2 √ null
CODCPG varchar 5 √ null
TCPG.CODCPG FKTTMV_TCPGR
EDICAOTB1FATMOV smallint 2 √ null
CODTB1FATMOV varchar 10 √ null
TTB1.CODTB1FAT FKTTMV_TTB1R
EDICAOTB2FATMOV smallint 2 √ null
CODTB2FATMOV varchar 10 √ null
TTB2.CODTB2FAT FKTTMV_TTB2R
EDICAOTB3FATMOV smallint 2 √ null
CODTB3FATMOV varchar 10 √ null
TTB3.CODTB3FAT FKTTMV_TTB3R
EDICAOTB4FATMOV smallint 2 √ null
CODTB4FATMOV varchar 10 √ null
TTB4.CODTB4FAT FKTTMV_TTB4R
EDICAOTB5FATMOV smallint 2 √ null
CODTB5FATMOV varchar 10 √ null
TTB5.CODTB5FAT FKTTMV_TTB5R
EDICAOTB1FLXMOV smallint 2 √ null
CODTB1FLXMOV varchar 25 √ null
FTB1.CODTB1FLX FKTTMV_FTB1R
EDICAOTB2FLXMOV smallint 2 √ null
CODTB2FLXMOV varchar 25 √ null
FTB2.CODTB2FLX FKTTMV_FTB2R
EDICAOTB3FLXMOV smallint 2 √ null
CODTB3FLXMOV varchar 25 √ null
FTB3.CODTB3FLX FKTTMV_FTB3R
EDICAOTB4FLXMOV smallint 2 √ null
CODTB4FLXMOV varchar 25 √ null
FTB4.CODTB4FLX FKTTMV_FTB4R
EDICAOTB5FLXMOV smallint 2 √ null
CODTB5FLXMOV varchar 25 √ null
FTB5.CODTB5FLX FKTTMV_FTB5R
USACAMPOLIVMOV1 smallint 2 √ null
NOMECAMPOLIVMOV1 varchar 15 √ null
CAMPOLIVMOV1 varchar 100 √ null
USACAMPOLIVMOV2 smallint 2 √ null
NOMECAMPOLIVMOV2 varchar 15 √ null
CAMPOLIVMOV2 varchar 100 √ null
USACAMPOLIVMOV3 smallint 2 √ null
NOMECAMPOLIVMOV3 varchar 15 √ null
CAMPOLIVMOV3 varchar 100 √ null
EDICAOFRETE smallint 2 √ null
TIPOFRETE varchar 1 √ null
INFORMACIFFOB smallint 2 √ null
CODMENFRETECIF varchar 5 √ null
TMEN.CODMEN FKTTMV_TMENCIFR
CODMENFRETEFOB varchar 5 √ null
TMEN.CODMEN FKTTMV_TMENFOBR
EDICAOSEGURO smallint 2 √ null
TIPOSEGURO varchar 1 √ null
EDICAODESCMOV smallint 2 √ null
TIPODESCMOV varchar 1 √ null
DESCMAXIMOMOV RMDVALOR4 17,4 √ null
CODMENDESCMOV varchar 5 √ null
TMEN.CODMEN FKTTMV_TMENDESCMOVR
EDICAODESPMOV smallint 2 √ null
TIPODESPMOV varchar 1 √ null
CODMENDESPMOV varchar 5 √ null
TMEN.CODMEN FKTTMV_TMENDESPMOVR
USADESPFINANC smallint 2 √ null
NOMEEXTRA1 varchar 10 √ null
EDICAOEXTRA1 smallint 2 √ null
TIPOEXTRA1 varchar 1 √ null
NOMEEXTRA2 varchar 10 √ null
EDICAOEXTRA2 smallint 2 √ null
TIPOEXTRA2 varchar 1 √ null
EDICAOADIANTPED smallint 2 √ null
DATABASEMOV varchar 1 √ null
CODMOEDA varchar 10 √ null
GMOEDA.SIMBOLO FKTTMV_GMOER
NOMESUBTOTAL varchar 15 √ null
EDITAVALFINLIVRE smallint 2 √ null
USATRBMOV smallint 2 √ null
EDITATRBMOV smallint 2 √ null
EDITABCTRBMOV smallint 2 √ null
NUMTRBSELECMOV smallint 2 √ null
TIPOLANCAMENTO varchar 1 √ null
FATURA smallint 2 √ null
FATURAMANUTENCAO smallint 2 √ null
EDICAOLAN varchar 1 √ null
TIPODOCGERADO varchar 1 √ null
IDRELATFAT int 4 √ null
RRELAT.ID FKTTMV_RRELATFATR
IDRELATDUP int 4 √ null
RRELAT.ID FKTTMV_RRELATDUPR
IDRELATMOV int 4 √ null
RRELAT.ID FKTTMV_RRELATMOVR
IMPINSTFAT varchar 1 √ null
IMPINSTDUP varchar 1 √ null
IMPINSTDOC varchar 1 √ null
DATAEMISSAOLAN varchar 1 √ null
DATAPREVISAOLAN varchar 1 √ null
DATA1LAN varchar 1 √ null
DATA2LAN varchar 1 √ null
DATA3LAN varchar 1 √ null
NUMERACAOLAN varchar 1 √ null
CONTABILLAN varchar 1 √ null
HISTORICOLAN varchar 40 √ null
CODMOEDALAN varchar 10 √ null
GMOEDA.SIMBOLO FKTTMV_GMOELANR
CODINDEXADORLAN varchar 10 √ null
GMOEDA.SIMBOLO FKTTMV_GIDXLANR
BUSCARCAIXALAN varchar 1 √ null
BAIXARLAN smallint 2 √ null
PERCENTDESCLAN RMDVALOR4 17,4 √ null
PERCENTJUROSLAN RMDVALOR4 17,4 √ null
STATUSCNABLAN smallint 2 √ null
COMANDOCNABLAN smallint 2 √ null
ACEITECNABLAN smallint 2 √ null
INSTCOD1CNABLAN smallint 2 √ null
INSTCOD2CNABLAN smallint 2 √ null
CARTEIRACNABLAN smallint 2 √ null
ASSOCIASEGNUMLAN varchar 1 √ null
DATABASEVENCLAN varchar 1 √ null
CAPITALMENSALLAN RMDVALOR4 17,4 √ null
PAGOURECLAN varchar 1 √ null
NUMEROPRECOVEND smallint 2 √ null
FLAGDATAMOV varchar 1 √ null
GERAMOVPED smallint 2 √ null
GERAMOVAUTOPED smallint 2 √ null
CODTMVPED varchar 10 √ null
TTMV.CODTMV FKTTMV_TTMVPEDR
BAIXAGERACAOPED smallint 2 √ null
CONFIRMABAIXAPED smallint 2 √ null
CANCELALCTPED smallint 2 √ null
CONTROLASENHAPED smallint 2 √ null
PRECOCOMDESCPED smallint 2 √ null
PRECOMOVGERPED smallint 2 √ null
CANCELACOMMOVPED smallint 2 √ null
NUMEROVERSAOTMOV smallint 2 √ null
ALTERATIPOLAN smallint 2 √ null
CODTRBRATEIOLAN varchar 10 √ null
DTRIBUTO.CODTRB FKTTMV_DTRIBUTORATEIOR
USAVORCCCUSTO varchar 1 √ null
USAVORCFISCCTTIP varchar 1 √ null
AVIVORCCCUSTO varchar 1 √ null
AVIVORCFISCCTTIP varchar 1 √ null
AVICREDITOCLIFOR varchar 1 √ null
EDITATROCO smallint 2 √ null
CODVEN1 varchar 16 √ null
TVEN.CODVEN FKTTMV_TVEN1R
CODVEN2 varchar 16 √ null
TVEN.CODVEN FKTTMV_TVEN2R
CODVEN3 varchar 16 √ null
TVEN.CODVEN FKTTMV_TVEN3R
CODVEN4 varchar 16 √ null
TVEN.CODVEN FKTTMV_TVEN4R
EDICAOVEN1 varchar 1 √ null
EDICAOCOMISVEN1 varchar 1 √ null
PERCCOMISVEN1 RMDVALOR2 17,2 √ null
EDICAOVEN2 varchar 1 √ null
EDICAOCOMISVEN2 varchar 1 √ null
PERCCOMISVEN2 RMDVALOR2 17,2 √ null
EDICAOVEN3 varchar 1 √ null
EDICAOCOMISVEN3 varchar 1 √ null
PERCCOMISVEN3 RMDVALOR2 17,2 √ null
EDICAOVEN4 varchar 1 √ null
EDICAOCOMISVEN4 varchar 1 √ null
PERCCOMISVEN4 RMDVALOR2 17,2 √ null
CODCOLCFOEMISSAO smallint 2 √ null
FCFO.CODCOLIGADA FKTTMV_FCFOEMISSAOR
CODCOLCFODESTIN smallint 2 √ null
FCFO.CODCOLIGADA FKTTMV_FCFODESTINR
APLICACAOFRM varchar 1 √ null
GFORMULA.APLICACAO FKTTMV_GFRMBRUTOR
AFETACUSTOREP smallint 2 √ null
AFETACUSTOREPB smallint 2 √ null
CODCOLCXA DCODCOLIGADANULL 2 √ null
FCXA.CODCOLIGADA FKTTMV_FCXAR
EDITACCUSTO smallint 2 √ (0)
TIPOTRANSFFAT smallint 2 √ null
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKTTMV_GCCUR
CODFRMLIQUIDO varchar 8 √ null
GFORMULA.CODIGO FKTTMV_GFRMLIQR
CODFRMSUBTOTAL varchar 8 √ null
GFORMULA.CODIGO FKTTMV_GFRMSUBR
CODFRMBRUTO varchar 8 √ null
GFORMULA.CODIGO FKTTMV_GFRMBRUTOR
CODFRMCUSTOREP varchar 8 √ null
GFORMULA.CODIGO FKTTMV_GFRMCUSTOREPR
CODFRMCUSTOREPB varchar 8 √ null
GFORMULA.CODIGO FKTTMV_GFRMCUSTOREPBR
CODFRMPRECOVEND varchar 8 √ null
GFORMULA.CODIGO FKTTMV_GFRMPRECOVENDR
CODFRMRATEIOLAN varchar 8 √ null
GFORMULA.CODIGO FKTTMV_GFRMRATEIOR
CODCXALAN varchar 10 √ null
FCXA.CODCXA FKTTMV_FCXAR
CODCOLIGADA DCODCOLIGADA 2 null
KPARAMETROSFACTOR.CODCOLCAUSALENTRADA FKXPARAMCODTMVPEDABERTO_TTMVR
KPARAMETROSFACTOR.CODCOLIGADA FKXPARAMCODTMVPERDAMATER_TTMVR
KPARAMETROSFACTOR.CODCOLTMVENTRADA FKXPARAMCODTMVENTRADA_TTMVR
KPARAMETROSFACTOR.CODCOLTMVSAIDA FKXPARAMCODTMVSAIDA_TTMVR
KPARAMETROSFACTOR.CODCOLTMVSOLICITACAOCOMPRA FKXPARAMCODTMVSOLCOMPRAS_TTMVR
KTMVRESERVAVEL.CODCOLIGADA FKKTMVRESERVAVEL_TTMVR
MCNT.CODCOLIGADA FKMCNT_TTMVESTORNOR
MTMVPAR.CODCOLIGADA FKMTMVPAR_TTMVR
OFAGENDASERV.CODCOLIGADA FKOFAGENDASERV_TTMVR
OFATENDIMENTOEXTOS.CODCOLIGADA FKOFATENDEXTOS_TTMVR
OFMOVPROCESSAMOS.CODCOLIGADA FKOFMOVPROCESSAMOS_TTMVR
OFPARAMS.CODCOLIGADA FKOFPARAMS_TTMVCODEXTR
OFPARAMSINDICE.CODCOLIGADA FKOFPARAMSINDICE_TTMVR
OFPARAMSPLANOMANUT.CODCOLIGADA FKOFPARAMSPLANOMANUT_TTMVR
OFPARAMSTMV.CODCOLIGADA FKFKOFPARAMSTMV_TTMVR
SFILIALTIPOMOVAGRUPALAN.CODCOLIGADA FKSFILIALTIPOMOVAGRUPALAN_TTMVR
SZTIPOMOV.CODCOLIGADA FKSZTIPOMOV_TTMVNBXR
TCNTPAR.CODCOLIGADA FKTCNTPAR_TTMVVENDAR
TITMCNT.CODCOLIGADA FKTITMCNT_TTMVR
TITMTMV.CODCOLIGADA FKTITMTMV_TTMVR
TLAF.CODCOLIGADA FKTLAF_TTMVR
TLOT.CODCOLIGADA FKTLOT_TTMVR
TLOTEEXPCONTABIL.CODCOLIGADA FKTLOTEEXPCONTABIL_TTMVINICIALR
TLOTEPROCESSO.CODCOLIGADA FKTLOTPROC_TTMVR
TMOTIVOREFMOV.CODCOLIGADA FKTMOTIVOREFMOV_TTMVR
TMOV.CODCOLIGADA FKTMOV_TTMVR
TPAR.CODCOLIGADA FKCODTMVSOLNFE_TTMVR
TPONTOVENDA.CODCOLIGADA FKTPONTOVENDA_TTMVRECEBR
TSTATUSLOTEPRDTMV.CODCOLIGADA FKTSTATUSLOTEPRDTMV_TTMVR
TTMV.CODCOLIGADA FKTTMV_TTMVPEDR
TTMVEXT.CODCOLIGADA FKTTMVEXT_TTMVINDR
TTMVFATURAMENTO.CODCOLIGADA FKTTMVFATURAMENTO_TTMVFATR
TTMVPERFILPROCESSO.CODCOLIGADA FKTTMVPERFILPROCESSO_TTMVR
TTMVRESERVA.CODCOLIGADA FKTTMVRESERVA_TTMVR
TTMVSERIE.CODCOLIGADA FKTTMVSERIE_TTMVR
TTMVTIPODOC.CODCOLIGADA FKTTMVTIPODOC_TTMVR
TTRBTMV.CODCOLIGADA FKTTRBTMV_TTMVR
TUSRTMV.CODCOLIGADA FKTUSRTMV_TTMVR
VCONTROLESISTEMA.CODCOLIGADA FKVCONTROLESISTEMA_TTMVEMPRESTR
XPARAMETROSCOLIGADA.CODCOLTMVCOMISFAT FKXPARAMETROSCOLIGADA_TTMVR
XPARAMMVTO.CODCOLGERAMVTO FKXPARAMMVTO_TTMVR
GCCUSTO.CODCOLIGADA FKTTMV_GCCUR
FTDO.CODCOLIGADA FKTTMV_FTDONFR
GCOLIGADA.CODCOLIGADA FKTTMV_GCOLR
FTB4.CODCOLIGADA FKTTMV_FTB4R
TTB1.CODCOLIGADA FKTTMV_TTB1R
TTRA.CODCOLIGADA FKTTMV_TTRA2R
TTB5.CODCOLIGADA FKTTMV_TTB5R
DCFOP.CODCOLIGADA FKTTMV_DCFOP2R
TCPG.CODCOLIGADA FKTTMV_TCPGR
TTB4.CODCOLIGADA FKTTMV_TTB4R
FTB1.CODCOLIGADA FKTTMV_FTB1R
GFORMULA.CODCOLIGADA FKTTMV_GFRMPRECOVENDR
TTMV.CODCOLIGADA FKTTMV_TTMVPEDR
FTB5.CODCOLIGADA FKTTMV_FTB5R
TMEN.CODCOLIGADA FKTTMV_TMENMOV2R
TRPR.CODCOLIGADA FKTTMV_TRPRR
TTB3.CODCOLIGADA FKTTMV_TTB3R
TLOC.CODCOLIGADA FKTTMV_TLOCR
DTRIBUTO.CODCOLIGADA FKTTMV_DTRIBUTORATEIOR
TEVENTOSCONT.CODCOLIGADA FKTTMV_TEVCR
FTB2.CODCOLIGADA FKTTMV_FTB2R
TVEN.CODCOLIGADA FKTTMV_TVEN3R
GDEPTO.CODCOLIGADA FKTTMVITEM_GDEPTOR
FTB3.CODCOLIGADA FKTTMV_FTB3R
TTB2.CODCOLIGADA FKTTMV_TTB2R
CODTDOLANNF varchar 10 √ null
FTDO.CODTDO FKTTMV_FTDONFR
CODTDOLANDUP varchar 10 √ null
FTDO.CODTDO FKTTMV_FTDODUPR
RENUMERARIMPRESSAO smallint 2 √ null
USAREVC smallint 2 √ null
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKTTMV_TEVCR
EDITAEVENTOCONT varchar 1 √ null
CADASTRACHEQLAN smallint 2 √ null
EDICAOENTREGA varchar 1 √ null
DATAENTREGA varchar 1 √ null
INTEGRADOFACTOR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
EDICAODEPARTAMENTO smallint 2 √ null
MARCARITENSFATPED DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NAOAGRUPARITENSPED DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
EDICAOLOCALESTOQUE varchar 1 √ null
CODFILIAL smallint 2 √ null
TLOC.CODFILIAL FKTTMV_TLOCR
GDEPTO.CODFILIAL FKTTMVMOV_GDEPTOR
CODLOC varchar 15 √ null
TLOC.CODLOC FKTTMV_TLOCR
TIPOHISTORICO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
TIPOMOVTRANSF varchar 1 √ null
NUMEROMAXPARCELAS int 4 √ null
VALORMINPARCELA RMDVALOR4 17,4 √ null
USARDEVOLUCAO int 4 √ null
TIPODEVOLUCAO int 4 √ null
RELACITENSFATURAMENTO smallint 2 √ null
DATAORCAMENTO varchar 1 √ null
TABBASEORCAMENTO varchar 1 √ null
ACEITANUMSERIE smallint 2 √ null
USANUMSERIESEQ smallint 2 √ null
CODDEPTODEFAULTMOV varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKTTMVMOV_GDEPTOR
CODDEPTODEFAULTITEM varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKTTMVITEM_GDEPTOR
CODCOLRELDUP DCODCOLIGADANULL 2 √ null
RRELAT.CODCOLIGADA FKTTMV_RRELATDUPR
CODCOLRELFAT DCODCOLIGADANULL 2 √ null
RRELAT.CODCOLIGADA FKTTMV_RRELATFATR
CODCOLRELMOV DCODCOLIGADANULL 2 √ null
RRELAT.CODCOLIGADA FKTTMV_RRELATMOVR
IDNAT int 4 √ null
DCFOP.IDNAT FKTTMV_DCFOPR
IDNAT2 int 4 √ null
DCFOP.IDNAT FKTTMV_DCFOP2R
CLASSIFICACAO varchar 10 √ null
CODMENFRETETERCEIRO varchar 5 √ null
TMEN.CODMEN FKTTMV_TMENR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDFORMAPAGTOBAIXARLAN int 4 √ null
EDICAOENDCOLETAENTREGADEST smallint 2 √ null
DESCONSIDERARSN smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTTMV Primary key Asc/Asc CODCOLIGADA + CODTMV
TXTMVCOD Performance Asc CODTMV

Relationships

Close relationships within degrees of separation