PRATFINANCEIRO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCCUSTO.CODCOLIGADA FKPRATFINANCEIRO_GCCUSTOR
GCOLIGADA.CODCOLIGADA FKPRATFINANCEIRO_GCOLIGADAR
SITEMCONTABILPROTHEUS.CODCOLIGADA FKPRATFINANCEIRO_SITEMCONTABILR
PFINANCEIRO.CODCOLIGADA FKPRATFINANCEIRO_PFINANCEIROR
SCLASSEVALORPROTHEUS.CODCOLIGADA FKPRATFINANCEIRO_SCLASSEVALORPR
IDRATCCU int 4 null
IDFINANC int 4 null
PFINANCEIRO.IDFINANC FKPRATFINANCEIRO_PFINANCEIROR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKPRATFINANCEIRO_GCCUSTOR
VALOR RMDVALOR4 17,4 √ null
PERCENTUAL RMDVALOR4 17,4 √ null
CODCOLNATFINANCEIRA DCODCOLIGADANULL 2 √ null
TTBORCAMENTO.CODCOLIGADA FKPRATFINANCEIRO_TTBORCAMENTOR
GCOLIGADA.CODCOLIGADA FKPRATFINANCEIRO_COLNATFINANCER
CODNATFINANCEIRA varchar 40 √ null
TTBORCAMENTO.CODTBORCAMENTO FKPRATFINANCEIRO_TTBORCAMENTOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDITEMCONTABIL int 4 √ null
SITEMCONTABILPROTHEUS.IDITEMCONTABIL FKPRATFINANCEIRO_SITEMCONTABILR
IDCLASSEVALOR int 4 √ null
SCLASSEVALORPROTHEUS.IDCLASSEVALOR FKPRATFINANCEIRO_SCLASSEVALORPR

Indexes

Constraint Name Type Sort Column(s)
PKPRATFINANCEIRO Primary key Asc/Asc CODCOLIGADA + IDRATCCU

Relationships

Close relationships within degrees of separation