TITMTMV

181 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCCUSTO.CODCOLIGADA FKTITMTMV_GCCUR
FTDO.CODCOLIGADA FKTITMTMV_FTDOR
TMEN.CODCOLIGADA FKTITMTMV_TMENR
TTB3.CODCOLIGADA FKTITMTMV_TTB3R
TLOC.CODCOLIGADA FKTITMTMV_TLOCR
FTB4.CODCOLIGADA FKTITMTMV_FTB4R
DTRIBUTO.CODCOLIGADA FKTITMTMV_DTRIBUTOR
TTB1.CODCOLIGADA FKTITMTMV_TTB1R
FTB2.CODCOLIGADA FKTITMTMV_FTB2R
FTB3.CODCOLIGADA FKTITMTMV_FTB3R
TTB5.CODCOLIGADA FKTITMTMV_TTB5R
CLOTE.CODCOLIGADA FKTITMTMV_CLOTER
TTB4.CODCOLIGADA FKTITMTMV_TTB4R
FTB1.CODCOLIGADA FKTITMTMV_FTB1R
GFORMULA.CODCOLIGADA FKCODFRMVALOROP2LAN_TITMTMVR
TTMV.CODCOLIGADA FKTITMTMV_TTMVR
TTB2.CODCOLIGADA FKTITMTMV_TTB2R
FTB5.CODCOLIGADA FKTITMTMV_FTB5R
CODTMV varchar 10 null
TTMV.CODTMV FKTITMTMV_TTMVR
NUMEROMAXIMOIT smallint 2 null
QUALCODIGOIT varchar 1 null
INCREMENTAETIQ smallint 2 null
ITEMREPETIDO smallint 2 null
CADASTRAUNID smallint 2 null
QUALTIPOUNID varchar 1 null
CODUNDPADRAOIT varchar 5 null
TUND.CODUND FKTITMTMV_TUNDR
EFEITOSALDOA1 varchar 1 null
EFEITOSALDOA2 varchar 1 null
EFEITOSALDOA3 varchar 1 null
EFEITOSALDOA4 varchar 1 null
EFEITOSALDOA5 varchar 1 null
EFEITOSALDOA6 varchar 1 null
EFEITOSALDOA7 varchar 1 null
EFEITOSALDOA8 varchar 1 null
EFEITOSALDOA9 varchar 1 null
EFEITOSALDOA10 varchar 1 null
EFEITOSALDOB2 varchar 1 null
EDICAOPRECO varchar 1 null
ACEITAPRECOZERO smallint 2 null
USADESCIT smallint 2 null
NOMEDESCIT varchar 20 null
DESCMINIMOIT RMDVALOR2 17,2 null
DESCMAXIMOIT RMDVALOR2 17,2 null
TIPODESCIT varchar 1 null
DESCITAFETAMOV smallint 2 null
USADESPIT smallint 2 null
NOMEDESPIT varchar 20 null
TIPODESPIT varchar 1 null
DESPITAFETAMOV smallint 2 null
USAMENSAGEMIT smallint 2 null
CODMENIT varchar 5 null
TMEN.CODMEN FKTITMTMV_TMENR
USACAMPOLIVREIT smallint 2 null
NOMECAMPOLIVREIT varchar 15 null
EDITAHISTORIT smallint 2 null
EDITANATIT smallint 2 null
EDITACONDPGTOIT smallint 2 null
EDITADTENTREGAIT smallint 2 null
USAPRATELEIRAIT smallint 2 null
EDITAPRECOTOTIT smallint 2 null
ALTERAPRECOUNIT smallint 2 null
EDICAOTB1FATIT smallint 2 null
CODTB1FATIT varchar 10 null
TTB1.CODTB1FAT FKTITMTMV_TTB1R
EDICAOTB2FATIT smallint 2 null
CODTB2FATIT varchar 10 null
TTB2.CODTB2FAT FKTITMTMV_TTB2R
EDICAOTB3FATIT smallint 2 null
CODTB3FATIT varchar 10 null
TTB3.CODTB3FAT FKTITMTMV_TTB3R
EDICAOTB4FATIT smallint 2 null
CODTB4FATIT varchar 10 null
TTB4.CODTB4FAT FKTITMTMV_TTB4R
EDICAOTB5FATIT smallint 2 null
CODTB5FATIT varchar 10 null
TTB5.CODTB5FAT FKTITMTMV_TTB5R
EDICAOTB1FLXIT smallint 2 null
CODTB1FLXIT varchar 25 null
FTB1.CODTB1FLX FKTITMTMV_FTB1R
EDICAOTB2FLXIT smallint 2 null
CODTB2FLXIT varchar 25 null
FTB2.CODTB2FLX FKTITMTMV_FTB2R
EDICAOTB3FLXIT smallint 2 null
CODTB3FLXIT varchar 25 null
FTB3.CODTB3FLX FKTITMTMV_FTB3R
EDICAOTB4FLXIT smallint 2 null
CODTB4FLXIT varchar 25 null
FTB4.CODTB4FLX FKTITMTMV_FTB4R
EDICAOTB5FLXIT smallint 2 null
CODTB5FLXIT varchar 25 null
FTB5.CODTB5FLX FKTITMTMV_FTB5R
USATRBIT smallint 2 null
EDITATRBIT smallint 2 null
EDITABCTRBIT smallint 2 null
NUMTRBSELECIT smallint 2 null
EDITACCUSTO smallint 2 (0)
EDITACNT smallint 2 (0)
CODCCUSTO varchar 25 null
GCCUSTO.CODCCUSTO FKTITMTMV_GCCUR
CODFRMVALORFINANC varchar 8 null
GFORMULA.CODIGO FKTITMTMV_GFORMULAR
EDICAOITMMOVGRD smallint 2 null
USAMULTIPLOPRD smallint 2 null
USAORDENARALIQ smallint 2 null
TRBORDENACAO varchar 10 null
DTRIBUTO.CODTRB FKTITMTMV_DTRIBUTOR
USARELACPRODFORN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAQTDEORIGINAL DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB1FATMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB2FATMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB3FATMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB4FATMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB5FATMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB1FLXMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB2FLXMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB3FLXMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB4FLXMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB5FLXMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB1FATIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB2FATIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB3FATIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB4FATIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB5FATIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB1FLXIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB2FLXIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB3FLXIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB4FLXIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGATB5FLXIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USACONTATRABALHO varchar 1 null
CODCOLCFOCT DCODCOLIGADANULL 2 null
FCFO.CODCOLIGADA FKTITMTMV_FCFOR
CODCFOCT varchar 25 null
FCFO.CODCFO FKTITMTMV_FCFOR
EDICAOLOCALESTOQUEDESTINO varchar 1 null
CODFILIALDESTINO smallint 2 null
TLOC.CODFILIAL FKTITMTMV_TLOCR
CODLOCDESTINO varchar 15 null
TLOC.CODLOC FKTITMTMV_TLOCR
APLICACAOFRM varchar 1 null
GFORMULA.APLICACAO FKTITMTMV_GFORMULAR
CODFRMCONSISTEITEM varchar 8 null
GFORMULA.CODIGO FKTITMTMV_GFRMR
CONTABILIZAPORTOTAL DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
CODLOTESALDUS int 4 null
CLOTE.CODLOTE FKTITMTMV_CLOTER
USARELACNATMEN smallint 2 null
TIPOINTEGRACAOFACTOR smallint 2 (0)
EMITERECIBOAD DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
PEDEDISTRIBUICAO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
TIPODISTRIBUICAO smallint 2 null
ASSOCIASEGNUMEROCONT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
CODMOEHORAPAD varchar 10 null
GMOEDA.SIMBOLO FKTITMTMV_GMOEDAR
VLHORAPAD RMDVALOR2 17,2 null
PERCPRECOPAD RMDVALOR2 17,2 null
EMITECUPOMFISCAL smallint 2 (0)
CONSISTEVALORLIQUIDO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USACALCULADORA DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USADESCONTOPARADESPESA DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USASUBSERIE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
AFETAGIROPROD varchar 1 null
GERARLOGMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
TIPOMOVCOMPRAS DTIDENTIFICADOR 4 null
HISTORICODEFAULT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
EDICAOCLASSMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
IDCLASSMOVGERADO DTIDENTIFICADOR 4 null
USARBASEICMSCOMOREDUZIDA DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
RATEARVALFINBASEICMS smallint 2 (0)
CODLOTEESTORNO int 4 null
CLOTE.CODLOTE FKTITMTMV_CLOTEESTORNOR
NOMEVEN1 varchar 20 null
NOMEVEN2 varchar 20 null
NOMEVEN3 varchar 20 null
NOMEVEN4 varchar 20 null
ACEITAITMQTDEZERO smallint 2 (0)
CALCULAJUROS smallint 2 (0)
CONTROLEENTREGA smallint 2 (0)
FATGERANMOVIMENTOS smallint 2 (0)
EDICAOQUANTIDADE varchar 1 ('E')
COPIALANCTOSPED varchar 1 ('N')
STATUSINICIAL varchar 1 null
USAMASCCCUSTOREDUZIDO varchar 25 null
VERPRJTRF smallint 2 null
NAODESDOBRAR smallint 2 (0)
AFETAESTOQUEAPOSFAT smallint 2 (0)
COPIANUMEROMOVFAT smallint 2 (0)
ATUALIZARPARAMESTOQUE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
NAOAFETARCUSTOUNIT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USARCONVUNDITEMMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USARCUSTOMOVRELAC DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
VERIFICALIMITECREDITO varchar 1 null
VERIFICADIASATRASO varchar 1 null
VERIFICACLIENTEANTIGO varchar 1 null
LIBERACAOVIASENHA DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
CODPERFILLIBERACAO varchar 15 null
HABILITAORCAMENTO varchar 1 null
EFEITOSALDOORCA varchar 1 null
CONSISTEQTDMAIOR smallint 2 (0)
USARTOLERANCIA smallint 2 null
USARAPROVACAO smallint 2 null
IMPRIMEBOLETO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
RATEARVALFINANCPED DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
TIPOCONSUMO int 4 null
DATALF varchar 1 null
INTEGRARBONUM smallint 2 null
CONSIDERARSALDOAOFATURARPED DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
SUBSERIE varchar 3 null
FATORCONVERSAOITMMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
QTDRECEBIDAUNDPEDIDO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
EDICAODATAEMISSAO varchar 1 null
TIPOGESTAOMAT smallint 2 (0)
CAMPOSCOMPLEMENTARES smallint 2 null
USARADIANTAMENTO varchar 1 null
CODTDOADIANTAMENTO varchar 10 null
FTDO.CODTDO FKTITMTMV_FTDOR
EDITAMOEDAMOV smallint 2 null
IGNORAQTDECOTADA DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
GERARTPRDCFOAUTO smallint 2 null
USATIPOCONSUMO smallint 2 null
GERAHISTLCTFISC DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
EDITATIPOENTREGA DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAHORARIOEMISSAO int 4 null
HABILITAPRDCOMPOSTO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALFINTRANSF DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGACCUSTOMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGACCUSTOITMMOV DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
OBRIGACONTACAIXA DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
TIPOREMESSA smallint 2 (0)
USARRATCCU smallint 2 null
USARRATDEP smallint 2 null
EDITARFORMAPAGAMENTO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALOROP1LAN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALOROP2LAN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALOROP3LAN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALOROP4LAN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALOROP5LAN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALOROP6LAN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALOROP7LAN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFRMVALOROP8LAN DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
CODFRMVALOROP1LAN varchar 8 null
GFORMULA.CODIGO FKCODFRMVALOROP1LAN_TITMTMVR
CODFRMVALOROP2LAN varchar 8 null
GFORMULA.CODIGO FKCODFRMVALOROP2LAN_TITMTMVR
CODFRMVALOROP3LAN varchar 8 null
GFORMULA.CODIGO FKCODFRMVALOROP3LAN_TITMTMVR
CODFRMVALOROP4LAN varchar 8 null
GFORMULA.CODIGO FKCODFRMVALOROP4LAN_TITMTMVR
CODFRMVALOROP5LAN varchar 8 null
GFORMULA.CODIGO FKCODFRMVALOROP5LAN_TITMTMVR
CODFRMVALOROP6LAN varchar 8 null
GFORMULA.CODIGO FKCODFRMVALOROP6LAN_TITMTMVR
CODFRMVALOROP7LAN varchar 8 null
GFORMULA.CODIGO FKCODFRMVALOROP7LAN_TITMTMVR
CODFRMVALOROP8LAN varchar 8 null
GFORMULA.CODIGO FKCODFRMVALOROP8LAN_TITMTMVR
TMVMOVRELAC varchar 10 null
TIPOCONTROLEORCAMENTO varchar 1 null
LIMESTOUROORCAMENTO varchar 1 null
CONSISTECODCFO smallint 2 null
NAOCONTABILIZARDESDOBRADO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
COPIARCCUSTOMOVPARAITEM DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
COPIAVENDEDORFAT smallint 2 null
SOMARVALFINFAT smallint 2 null
CONSISTEFILIALMOV smallint 2 null
EDICAODEPARTAMENTOIT smallint 2 null
BUSCARPRECOEM int 4 null
USACONTATO smallint 2 null
EXIBIRDIALOGOAPOSFAT int 4 null
DEVOLUCAO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
CONSISTEESCRITURACAO smallint 2 (0)
DIFMAXVALORLIQ RMDVALOR2 17,2 null
EDITACFOORIGEMDESTINO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
IGNORARFRMPRECONOCALCULO smallint 2 (0)
CODTRB1RATEIOLAN varchar 10 null
COPIALANCTOSPFAT varchar 1 null
SEPARACAO DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
CONSISTELOTE smallint 2 null
USARAMBOSEDITEXT1MOV smallint 2 null
USARAMBOSEDITEXT2MOV smallint 2 null
USARAMBOSEDITFRETEMOV smallint 2 null
USARAMBOSEDITSEGUROMOV smallint 2 null
USARAMBOSEDITDESPIT smallint 2 null
USARAMBOSEDITDESCIT smallint 2 null
CONSISTIRMAXPRODESERV smallint 2 null
NUMEROMAXIMOITPRODUTO smallint 2 null
DESCMAXIMOITSERVICO RMDVALOR2 17,2 null
USARCTRC smallint 2 null
OBRIGAEVENTOCONT DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
VALORPRIMPARCELA smallint 2 null
OPERACAOPRIMPARCELA varchar 1 null
ENVIAEMAIL DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
CODFILIALSAIDA smallint 2 null
CODLOCALSAIDA varchar 15 null
USARQTDEPRODUCAOCT smallint 2 null
AGRUPARITENSINCLUSAO smallint 2 null
USARRATCCUIT smallint 2 null
USARRATDEPIT smallint 2 null
GERAESCRITURACAO smallint 2 null
USACOMISSAOPRD DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
QUALCODIGOSEP varchar 1 null
CARREGACOMISSAOPRD varchar 1 null
DISTVALORESOPPARCELAS smallint 2 null
CODFRMVALORBEM varchar 8 null
GFORMULA.CODIGO FKTITMTMV_GFORMULABEMR
EDICAOCOMISSAOPRD varchar 1 ('N')
CODFRMRATEIOCCUSTODEPTOITEM varchar 8 null
GFORMULA.CODIGO FKTITMTMV_GFORMULACUSTODEPTOR
EFEITODETERCEIROS varchar 1 null
EFEITOCOMTERCEIROS varchar 1 null
USATABPRECO smallint 2 null
SELECAOTABPRECO varchar 1 null
PRIORIDADETABPRECO varchar 20 null
TRATAPRODUTOSUBSTITUTO varchar 1 ('N')
RECCREATEDBY varchar 50 null
RECCREATEDON datetime 16,3 null
RECMODIFIEDBY varchar 50 null
RECMODIFIEDON datetime 16,3 null
EFEITOVENDIDODETERCEIROS varchar 1 null
TIPOMOVVENDAS DTIDENTIFICADOR 4 null
AFETAQUALIFICFORN smallint 2 null
CODFRMHISTORICOMOV varchar 8 null
GFORMULA.CODIGO FKTITMTMV_CODFRMHISTORICOMOVR
CODFRMHISTORICOITEM varchar 8 null
GFORMULA.CODIGO FKTITMTMV_CODFRMHISTORICOITEMR
GERACONTRATO smallint 2 null
GERARCONTBONUM smallint 2 null
CODFRMINFADICFISCOMOV varchar 8 null
CODFRMINFADICFISCOITEM varchar 8 null
EDITAMARCA varchar 1 null
USAVALOROP1NFE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAVALOROP2NFE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAVALOROP3NFE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAVALOROP4NFE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAVALOROP5NFE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAVALOROP6NFE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAVALOROP7NFE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
USAVALOROP8NFE DLOGICONULL 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
CODFRMVALORBASEDEPREC varchar 8 null
GFORMULA.CODIGO FKTITMTMV_GFORMULADEPRECBEMR
IDSTATUSLOTEPRD int 4 null
TSTATUSLOTEPRD.IDSTATUS FKTITMTMV_TSTATUSLOTEPRDR

Indexes

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

Relationships