FCONCILAPURACAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCONCILCARTAOTRANS.CODCOLIGADA FKFCONCILAPURACAO_FCONCILCARTR
ID int 4 null
IDTRANSACAO int 4 √ null
FINTEGRACAOCARTAO.IDTRANSACAO FKFCONCILAPURACAO_FINTEGRACAOCR
IDCONCILIACAO int 4 null
FCONCILCARTAOTRANS.IDCONCILIACAO FKFCONCILAPURACAO_FCONCILCARTR
TID varchar 50 null
FCONCILCARTAOTRANS.TID FKFCONCILAPURACAO_FCONCILCARTR
IDINTERNO int 4 null
FCONCILCARTAOTRANS.IDINTERNO FKFCONCILAPURACAO_FCONCILCARTR
NUMEROPARCELA smallint 2 null
FCONCILCARTAOTRANS.NUMEROPARCELA FKFCONCILAPURACAO_FCONCILCARTR
TIPOCONCILIACAO smallint 2 √ null
TIPOEXTRATO int 4 null
RESULTADOCONCILIACAO int 4 null
TRANSACAOINEXISTENTE DLOGICO 2 ((0))
DIVERGENCIATAXA DLOGICO 2 ((0))
DIVERGENCIAVALOR DLOGICO 2 ((0))
DIVERGENCIADATA DLOGICO 2 ((0))
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
IDPAGAMENTO smallint 2 √ null
FINTEGRACAOCARTAO.IDPAGAMENTO FKFCONCILAPURACAO_FINTEGRACAOCR
NSU varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PKFCONCILAPURACAO Primary key Asc/Asc CODCOLIGADA + ID

Relationships

Close relationships within degrees of separation