SZSUSBPALANC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SEQBPALANC int 4 null
SZREPASSESUSITM.SEQBPALANC FKSZREPASSSUSITM_SZSUSBPALANCR
CODCOLIGADA DCODCOLIGADA 2 null
SZREPASSESUSITM.CODCOLIGADA FKSZREPASSSUSITM_SZSUSBPALANCR
GCOLIGADA.CODCOLIGADA FKSZSUSBPALANC_GCOLIGADAR
DATALANC datetime 16,3 null
varchar 9 null
PADV varchar 1 √ null
CODPREST int 4 √ null
CODESPECIALIDADE smallint 2 √ null
CODTIPOATEND smallint 2 √ null
CODGRUPOATEND smallint 2 √ null
CODFAIXA smallint 2 √ null
QTDELANC smallint 2 null
VALORLANC RMDVALOR2 17,2 √ null
NUMEROCONTA varchar 14 √ null
SEQUENCIALCONTA int 4 √ null
SEQDEBITO int 4 √ null
CODGGASTO varchar 2 √ null
COMPETENCIA datetime 16,3 √ null
FOLHA smallint 2 √ null
STATUS varchar 1 √ null
DATAGRAVACAO datetime 16,3 √ null
NOMERESPGRAVACAO varchar 30 √ null
VALORUNITPASP RMDVALOR2 17,2 √ null
CBO varchar 6 √ null
CID varchar 4 √ null
CARACTERATEND varchar 2 √ null
NUMAUTORIZACAO varchar 13 √ null
CODPRESTREP int 4 √ null
STATUSREP varchar 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCFO varchar 25 √ null
CODSERVICO varchar 3 √ null
CODCLASSIFICACAO varchar 3 √ null
CODEQUIPE varchar 12 √ null
CNPJ_OPM varchar 14 √ null
SEQPARCIAL int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSZSUSBPALANC Primary key Asc/Asc SEQBPALANC + CODCOLIGADA
SXSZSUSBPALANC Performance Asc/Asc/Asc/Asc CODCOLIGADA + NUMEROCONTA + SEQUENCIALCONTA + SEQPARCIAL
SZXSUSBPALANC Performance Asc/Asc/Asc CODCOLIGADA + PADV + PAID

Relationships

Close relationships within degrees of separation