TVEN

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCFO.CODCOLCHAVESESTRANG FKFCFO_TVENR
FCFODEF.CODCOLIGADA FKFCFODEF_TVENR
FLAN.CODCOLIGADA FKFLAN_TVENR
TCCOTACAO.CODCOLIGADA FKTCCOTACAO_TVENR
TCNT.CODCOLIGADA FKTCNT_TVEN2R
TFITMMOV.CODCOLIGADA FKTFITMMOV_TVENR
TFMOV.CODCOLIGADA FKTFMOV_TVEN2R
TITMCNT.CODCOLIGADA FKTITMCNT_TVEN1R
TITMMOV.CODCOLIGADA FKTITMMOV_TVENR
TMOV.CODCOLIGADA FKTMOV_TVEN4R
TPONTOVENDA.CODCOLIGADA FKTPONTOVENDA_TVEN1R
TPRDVEN.CODCOLIGADA FKTPRDVEN_TVENR
TTMV.CODCOLIGADA FKTTMV_TVEN3R
TTMVEXT.CODCOLIGADA FKTTMVEXT_TVENR
TVENCOMPL.CODCOLIGADA FKTVENCOMPL_TVENR
TVENFAMILIA.CODCOLIGADA FKTVENFAMILIA_TVENR
TVENVAL.CODCOLIGADA FKTVENVAL_TVENR
GCOLIGADA.CODCOLIGADA FKTVEN_GCOLR
GFILIAL.CODCOLIGADA FKTVEN_GFILR
CODVEN varchar 16 null
FCFO.CHAPA FKFCFO_TVENR
FCFODEF.CODVEN FKFCFODEF_TVENR
FLAN.CODVEN FKFLAN_TVENR
TCCOTACAO.CODCOMPRADOR FKTCCOTACAO_TVENR
TCNT.CODVEN FKTCNT_TVENR
TCNT.CODVEN2 FKTCNT_TVEN2R
TFITMMOV.CODVEN1 FKTFITMMOV_TVENR
TFMOV.CODVEN1 FKTFMOV_TVEN1R
TFMOV.CODVEN2 FKTFMOV_TVEN2R
TITMCNT.CODVEN1 FKTITMCNT_TVEN1R
TITMCNT.CODVEN2 FKTITMCNT_TVEN2R
TITMMOV.CODVEN1 FKTITMMOV_TVENR
TMOV.CODVEN1 FKTMOV_TVEN1R
TMOV.CODVEN2 FKTMOV_TVEN2R
TMOV.CODVEN3 FKTMOV_TVEN3R
TMOV.CODVEN4 FKTMOV_TVEN4R
TPONTOVENDA.CODVEN1 FKTPONTOVENDA_TVEN1R
TPONTOVENDA.CODVEN2 FKTPONTOVENDA_TVEN2R
TPRDVEN.CODVEN FKTPRDVEN_TVENR
TTMV.CODVEN1 FKTTMV_TVEN1R
TTMV.CODVEN2 FKTTMV_TVEN2R
TTMV.CODVEN3 FKTTMV_TVEN3R
TTMV.CODVEN4 FKTTMV_TVEN4R
TTMVEXT.CODVEN1IT FKTTMVEXT_TVENR
TVENCOMPL.CODVEN FKTVENCOMPL_TVENR
TVENFAMILIA.CODVEN FKTVENFAMILIA_TVENR
TVENVAL.CODVEN FKTVENVAL_TVENR
NOME varchar 80 √ null
CARGO varchar 30 √ null
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKTVEN_GFILR
CODLOC varchar 15 √ null
COMISSAO1 RMDVALOR4 17,4 √ null
COMISSAO2 RMDVALOR4 17,4 √ null
COMISSAO3 RMDVALOR4 17,4 √ null
CODPESSOA int 4 √ null
PPESSOA.CODIGO FKTVEN_PPESSOAR
VENDECOMPRA smallint 2 √ null
CODUSUARIO varchar 20 √ null
GUSUARIO.CODUSUARIO FKTVEN_GUSUARIOR
SENHA varchar 80 √ null
INATIVO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PFVENDEDOR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PFCAIXA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PFSUPERVISOR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PFGERENTE DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IDFUNCIONARIO int 4 null
COMISSAO4 RMDVALOR4 17,4 √ null
DESCMAXIMO RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTVEN Primary key Asc/Asc CODCOLIGADA + CODVEN

Relationships

Close relationships within degrees of separation