FCAPTURACOB

54 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLLAN DCODCOLIGADANULL 2 √ null
FLAN.CODCOLIGADA FKFCAPTURACOB_FLANR
IDCAPTURACOB int 4 null
IDLANCONCILIADO int 4 √ null
FLAN.IDLAN FKFCAPTURACOB_FLANR
STATUS smallint 2 null
DATACAPTURA datetime 16,3 null
DATACONCILIACAO datetime 16,3 √ null
CODIGOBARRA varchar 45 √ null
NUMERODOCUMENTO varchar 40 √ null
DATAEMISSAO datetime 16,3 √ null
DATAVENCIMENTO datetime 16,3 √ null
VALOR RMDVALOR4 17,4 √ null
TIPOINSCCEDENTE smallint 2 √ null
INSCRICAOCEDENTE varchar 20 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLIGADA DCODCOLIGADA 2 null
NOMEFORNECEDOR varchar 40 √ (NULL)

Indexes

Constraint Name Type Sort Column(s)
PKFCAPTURACOB Primary key Asc/Asc CODCOLIGADA + IDCAPTURACOB

Relationships

Close relationships within degrees of separation