TCNTPAR

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TTB3.CODCOLIGADA FKTCNTPAR_TTB3R
FTB4.CODCOLIGADA FKTCNTPAR_FTB4R
TTB1.CODCOLIGADA FKTCNTPAR_TTB1R
TEVENTOSCONT.CODCOLIGADA FKTCNTPAR_TEVCRECCNTR
FTB2.CODCOLIGADA FKTCNTPAR_FTB2R
FTB3.CODCOLIGADA FKTCNTPAR_FTB3R
TTB5.CODCOLIGADA FKTCNTPAR_TTB5R
CLOTE.CODCOLIGADA FKTCNTPAR_CLOTEITMCNTR
TTB4.CODCOLIGADA FKTCNTPAR_TTB4R
FTB1.CODCOLIGADA FKTCNTPAR_FTB1R
TTMV.CODCOLIGADA FKTCNTPAR_TTMVVENDAR
TTB2.CODCOLIGADA FKTCNTPAR_TTB2R
FTB5.CODCOLIGADA FKTCNTPAR_FTB5R
MASCCODCONTRATO varchar 20 √ null
MASCNUMEROSERIE varchar 15 √ null
USANUMEROSERIE smallint 2 √ null
USANUMSERIESEQ smallint 2 √ null
USAREPRESENTANTE smallint 2 √ null
USANUMSEQCONTRATO smallint 2 √ null
USACODFATURAMENTO smallint 2 √ null
JUROSPORDIA RMDVALOR4 17,4 √ null
DIASCARENPARAFAT smallint 2 √ null
DIASCARENCANCFAT smallint 2 √ null
INICIOOPERACAO datetime 16,3 √ null
VALORMINIMONF RMDVALOR4 17,4 √ null
USACNTMOVCANCEL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USACNTMOVFATURA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DIAFINALCARENCIA smallint 2 √ null
NUMMESESCARENCIA smallint 2 √ null
USADATAAUX DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USATIPOPRODFAT DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFUNCCNTNOIT DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
QUEBRAPERDESTCFO varchar 250 √ null
QUEBRAPERDESTRPR varchar 250 √ null
QUEBRANAOPERDESTCFO varchar 250 √ null
QUEBRANAOPERDESTRPR varchar 250 √ null
CODTMV varchar 10 √ null
TTMV.CODTMV FKTCNTPAR_TTMVR
EDICAOCODTMV varchar 1 √ null
EDICAOTB1FLX varchar 1 √ null
CODTB1FLX varchar 25 √ null
FTB1.CODTB1FLX FKTCNTPAR_FTB1R
EDICAOTB2FLX varchar 1 √ null
CODTB2FLX varchar 25 √ null
FTB2.CODTB2FLX FKTCNTPAR_FTB2R
EDICAOTB3FLX varchar 1 √ null
CODTB3FLX varchar 25 √ null
FTB3.CODTB3FLX FKTCNTPAR_FTB3R
EDICAOTB4FLX varchar 1 √ null
CODTB4FLX varchar 25 √ null
FTB4.CODTB4FLX FKTCNTPAR_FTB4R
EDICAOTB5FLX varchar 1 √ null
CODTB5FLX varchar 25 √ null
FTB5.CODTB5FLX FKTCNTPAR_FTB5R
TIPOHISTORICO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
EDICAOHISTORCNT DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
EDICAOCAMPOCOMPLCNT DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAPRDDEFAULTNOIT DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
COPIAHISTORPARAMOV DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODTMVCOMPRA varchar 10 √ null
TTMV.CODTMV FKTCNTPAR_TTMVVENDAR
FATURAEMDIASFIXOS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ARREDONDAMENTOREAJUSTE varchar 1 √ null
LIMITEREAJUSTE smallint 2 √ null
BUSCARPRECOEM int 4 √ (1)
COPIARDATAVENC varchar 1 √ null
COPIAHISTORCNTPARAMOV smallint 2 √ null
USARATEIOCCUITEM smallint 2 √ null
USARATEIODEPITEM smallint 2 √ null
CONTROLARESTOQUE smallint 2 √ null
NOMECAMPOLIVRE1CNT varchar 15 √ null
NOMECAMPOLIVRE2CNT varchar 15 √ null
NOMECAMPOLIVRE3CNT varchar 15 √ null
NOMECAMPOLIVRE1ITMCNT varchar 15 √ null
NOMECAMPOLIVRE2ITMCNT varchar 15 √ null
EDICAOTBFAT1 varchar 1 √ null
EDICAOTBFAT2 varchar 1 √ null
EDICAOTBFAT3 varchar 1 √ null
EDICAOTBFAT4 varchar 1 √ null
EDICAOTBFAT5 varchar 1 √ null
CODTB1FAT varchar 10 √ null
TTB1.CODTB1FAT FKTCNTPAR_TTB1R
CODTB2FAT varchar 10 √ null
TTB2.CODTB2FAT FKTCNTPAR_TTB2R
CODTB3FAT varchar 10 √ null
TTB3.CODTB3FAT FKTCNTPAR_TTB3R
CODTB4FAT varchar 10 √ null
TTB4.CODTB4FAT FKTCNTPAR_TTB4R
CODTB5FAT varchar 10 √ null
TTB5.CODTB5FAT FKTCNTPAR_TTB5R
CODPRDUTILIZADO varchar 1 √ ('0')
PRIORIDADEORIGEMTABMOV smallint 2 √ (0)
PERCENTUALMAXREAJUSTE RMDVALOR4 17,4 √ null
USATABPRECO smallint 2 √ null
SELECAOTABPRECO varchar 1 √ null
PRIORIDADETABPRECO varchar 20 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATAMEDUTILIZADA smallint 2 √ null
REAJUSTEAUTPREV smallint 2 √ null
EFEITOORCAMENTO char 1 √ null
ACAOEXCEDERORCAMENTO char 1 √ null
UTILIZARATEIOORCAMENTO smallint 2 √ null
USAFATCALCITMCNT smallint 2 √ null
USAREAJUSTEPRIMPARC smallint 2 √ null
USAAPROVACAO smallint 2 √ null
GERAWORKFLOWAUTOMATICO smallint 2 √ ((1))
USAREVC smallint 2 √ null
EDITAEVENTOCONT varchar 1 √ null
OBRIGAEVENTOCONT DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODEVENTOITEMCONTRATO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKTCNTPAR_TEVENTOSCONTR
CODLOTEITEMCONTRATO int 4 √ null
CLOTE.CODLOTE FKTCNTPAR_CLOTEITMCNTR
CODLOTEESTORNOITEMCONTRATO int 4 √ null
CLOTE.CODLOTE FKTCNTPAR_CLOTEESTORNOITMCNTR
CODEVENTORECLASSIFICACAO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKTCNTPAR_TEVCRECCNTR
CODLOTERECLASSIFICACAO int 4 √ null
CLOTE.CODLOTE FKTCNTPAR_CLOTERECCNTR
CODLOTEESTORNORECLASSIFICACAO int 4 √ null
CLOTE.CODLOTE FKTCNTPAR_CLOTEESTRECCNTR
CODEVENTOREAJUSTECONTRATO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKTCNTPAR_TEVCREAJCNTR
CODLOTEREAJUSTECONTRATO int 4 √ null
CLOTE.CODLOTE FKTCNTPAR_CLOTEREAJCNTR
CODLOTEESTORNOREAJUSTECONTRATO int 4 √ null
CLOTE.CODLOTE FKTCNTPAR_CLOTEESTORNOREAJCNTR
NOMEVEN1 varchar 20 √ null
NOMEVEN2 varchar 20 √ null
NOMEVEN3 varchar 20 √ null
NOMEVEN4 varchar 20 √ null
NOMECOMP1 varchar 20 √ null
NOMECOMP2 varchar 20 √ null
NOMECOMP3 varchar 20 √ null
NOMECOMP4 varchar 20 √ null
EDITAVEN1 varchar 1 √ null
EDITAVEN2 varchar 1 √ null
EDITAVEN3 varchar 1 √ null
EDITAVEN4 varchar 1 √ null
EDITACOMP1 varchar 1 √ null
EDITACOMP2 varchar 1 √ null
EDITACOMP3 varchar 1 √ null
EDITACOMP4 varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTCNTPAR Primary key Asc CODCOLIGADA

Relationships

Close relationships within degrees of separation