TFREDUCAOZ

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TFERROR.CODCOLIGADA FKTFERROR_TFREDUCAOZR
TFMOV.CODCOLIGADA FKTFMOV_TFREDUCAOZR
TFREDUCAOZITEM.CODCOLIGADA FKTFREDUCAOZITEM_TFREDUCAOZR
TFREDUCAOZMOV.CODCOLIGADA FKTFREDUCAOZMOV_TFREDUCAOZR
TPONTOVENDA.CODCOLIGADA FKTFREDUCAOZ_TPONTOVENDAR
PONTOVENDA varchar 10 null
TFERROR.PONTOVENDA FKTFERROR_TFREDUCAOZR
TFMOV.PONTOVENDA FKTFMOV_TFREDUCAOZR
TFREDUCAOZITEM.PONTOVENDA FKTFREDUCAOZITEM_TFREDUCAOZR
TFREDUCAOZMOV.PONTOVENDA FKTFREDUCAOZMOV_TFREDUCAOZR
TPONTOVENDA.PONTOVENDA FKTFREDUCAOZ_TPONTOVENDAR
NUMEROREDUCAO int 4 null
TFERROR.NUMEROREDUCAO FKTFERROR_TFREDUCAOZR
TFMOV.NUMEROREDUCAO FKTFMOV_TFREDUCAOZR
TFREDUCAOZITEM.NUMEROREDUCAO FKTFREDUCAOZITEM_TFREDUCAOZR
TFREDUCAOZMOV.NUMEROREDUCAO FKTFREDUCAOZMOV_TFREDUCAOZR
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
DTHRATUALIZACAO datetime 16,3 √ null
DATAGERACAO datetime 16,3 √ null
STATUSREDUCAO 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)
PKTFREDUCAOZ Primary key Asc/Asc/Asc CODCOLIGADA + PONTOVENDA + NUMEROREDUCAO

Relationships

Close relationships within degrees of separation