SZATENDRESUMOCOMPCCUSTOESPEC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKSZATRESCOMPCCU_GCOLIGADAR
SZATENDIMENTO.CODCOLIGADA FKSZATRESCOMPCCU_SZATENDIMENTOR
NUMEROCONTA varchar 14 null
SZATENDIMENTO.NUMEROCONTA FKSZATRESCOMPCCU_SZATENDIMENTOR
SEQUENCIALCONTA int 4 null
SZATENDIMENTO.SEQUENCIALCONTA FKSZATRESCOMPCCU_SZATENDIMENTOR
DATAFATURA datetime 16,3 null
CODCOMPRADOR int 4 null
CODMEDRESPONSAVEL int 4 null
CODESPECGRUPO varchar 4 null
CODCENTCUSTO int 4 null
CUSTOHONO RMDVALOR2 17,2 √ (0)
FATHONO RMDVALOR2 17,2 √ (0)
FATHOSPHONO RMDVALOR2 17,2 √ (0)
CUSTOREPHONO RMDVALOR2 17,2 √ (0)
FATREPHONO RMDVALOR2 17,2 √ (0)
CUSTODIARIA RMDVALOR2 17,2 √ (0)
FATDIARIA RMDVALOR2 17,2 √ (0)
CUSTODIAG RMDVALOR2 17,2 √ (0)
FATDIAG RMDVALOR2 17,2 √ (0)
CUSTOHOSPDIAG RMDVALOR2 17,2 √ (0)
FATHOSPDIAG RMDVALOR2 17,2 √ (0)
CUSTOREPDIAG RMDVALOR2 17,2 √ (0)
FATREPDIAG RMDVALOR2 17,2 √ (0)
CUSTOTAXA RMDVALOR2 17,2 √ (0)
FATTAXA RMDVALOR2 17,2 √ (0)
CUSTOSERVICO RMDVALOR2 17,2 √ (0)
FATSERVICO RMDVALOR2 17,2 √ (0)
CUSTOMAT RMDVALOR2 17,2 √ (0)
FATMAT RMDVALOR2 17,2 √ (0)
CUSTOMED RMDVALOR2 17,2 √ (0)
FATMED RMDVALOR2 17,2 √ (0)
CUSTOORTESE RMDVALOR2 17,2 √ (0)
FATORTESE RMDVALOR2 17,2 √ (0)
CUSTOPROTESE RMDVALOR2 17,2 √ (0)
FATPROTESE RMDVALOR2 17,2 √ (0)
FATPACOTE RMDVALOR2 17,2 √ (0)
SEQPARCIAL 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)
PKSZATENDRESUMOCOMPCCUSTOESPEC Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + NUMEROCONTA + SEQUENCIALCONTA + DATAFATURA + CODCOMPRADOR + CODMEDRESPONSAVEL + CODESPECGRUPO + CODCENTCUSTO + SEQPARCIAL
SZXATENDRESUMOCOMPCCUSTOESPEC Performance Asc/Asc CODCOLIGADA + SEQUENCIALCONTA

Relationships

Close relationships within degrees of separation