TREDUCAOZ

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DLAF.CODCOLIGADA FKDLAF_TREDUCAOZR
DLAFHISTORICO.CODCOLIGADA FKDLAFHISTORICO_TREDUCAOZR
TCUPOMFISCAL.CODCOLIGADA FKTCUPOMFISCAL_TREDUCAOZR
TMOV.CODCOLIGADA FKTMOV_TFREDUCAOZR
TREDUCAOZITEM.CODCOLIGADA FKTREDUCAOZITEM_TREDUCAOZR
TREDUCAOZTRB.CODCOLIGADA FKTREDUCAOZTRB_TREDUCAOZR
TSERIE.CODCOLIGADA FKTREDUCAOZ_TSERIER
FTDO.CODCOLIGADA FKTREDUCAOZ_FTDOR
TPONTOVENDA.CODCOLIGADA FKTREDUCAOZ_TPONTOVENDAR
IDREDUCAOZ int 4 null
DLAF.IDREDUCAOZ FKDLAF_TREDUCAOZR
DLAFHISTORICO.IDREDUCAOZ FKDLAFHISTORICO_TREDUCAOZR
TCUPOMFISCAL.IDREDUCAOZ FKTCUPOMFISCAL_TREDUCAOZR
TMOV.IDREDUCAOZ FKTMOV_TFREDUCAOZR
TREDUCAOZITEM.IDREDUCAOZ FKTREDUCAOZITEM_TREDUCAOZR
TREDUCAOZTRB.IDREDUCAOZ FKTREDUCAOZTRB_TREDUCAOZR
PONTOVENDA varchar 10 null
TPONTOVENDA.PONTOVENDA FKTREDUCAOZ_TPONTOVENDAR
NUMEROREDUCAO int 4 null
DATAMOVIMENTO datetime 16,3 √ null
DATAREDUCAO datetime 16,3 √ null
GRANDETOTAL RMDVALOR4 17,4 √ null
CANCELAMENTOS RMDVALOR4 17,4 √ null
DESCONTOS RMDVALOR4 17,4 √ null
ACRESCIMOS RMDVALOR4 17,4 √ null
ACRESCIMOSFIN RMDVALOR4 17,4 √ null
COO int 4 √ null
CNSI int 4 √ null
GRANDETOTALANT RMDVALOR4 17,4 √ null
COOANT int 4 √ null
SERIE varchar 5 √ null
TSERIE.SERIE FKTREDUCAOZ_TSERIER
CODTDO varchar 10 √ null
FTDO.CODTDO FKTREDUCAOZ_FTDOR
CODLAF varchar 15 √ null
CODCOLCFO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKTREDUCAOZ_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKTREDUCAOZ_FCFOR
STATUS varchar 1 √ null
QTDEDOCCANCELADOS int 4 √ null
COORZ int 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)
PKTREDUCAOZ Primary key Asc/Asc CODCOLIGADA + IDREDUCAOZ
TXTREDUCAOZ Must be unique Asc/Asc/Asc CODCOLIGADA + PONTOVENDA + NUMEROREDUCAO

Relationships

Close relationships within degrees of separation