PCONTAS

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GDEPTO.CODCOLIGADA FKPCONTAS_GDEPTOR
PCCUSTO.CODCOLIGADA FKPCONTAS_PCCUSTOR
PCODINTCONT.CODCOLIGADA FKPCONTAS_PCODINTCONTR
GCOLIGADA.CODCOLIGADA FKPCONTAS_GCOLIGADAR
PGRPCONTACONT.CODCOLIGADA FKPCONTAS_PGRPCONTACONTR
PCODINTCONTFUNC.CODCOLIGADA FKPCONTAS_PCODINTCONTFUNCR
SITEMCONTABILPROTHEUS.CODCOLIGADA FKPCONTAS_SITEMCONTABILPROTHEUR
GFILIAL.CODCOLIGADA FKPCONTAS_GFILIALR
SCLASSEVALORPROTHEUS.CODCOLIGADA FKPCONTAS_SCLASSEVALORPROTHEUSR
PCONTASID int 4 null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKPCONTAS_GDEPTOR
GFILIAL.CODFILIAL FKPCONTAS_GFILIALR
CONTASALDUS DCODCONTA 40 √ null
CCONTA.CODCONTA FKPCONTAS_CCONTAR
CODCOLCONTA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKPCONTAS_CCONTAR
CODCCUSTO varchar 25 √ null
PCCUSTO.CODCCUSTO FKPCONTAS_PCCUSTOR
GRPCONTA varchar 22 √ null
PGRPCONTACONT.CODCLIENTE FKPCONTAS_PGRPCONTACONTR
CODINTEGR varchar 22 √ null
PCODINTCONT.CODCLIENTE FKPCONTAS_PCODINTCONTR
INTEGRCFUNC varchar 22 √ null
PCODINTCONTFUNC.CODCLIENTE FKPCONTAS_PCODINTCONTFUNCR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKPCONTAS_GDEPTOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDITEMCONTABIL int 4 √ null
SITEMCONTABILPROTHEUS.IDITEMCONTABIL FKPCONTAS_SITEMCONTABILPROTHEUR
IDCLASSEVALOR int 4 √ null
SCLASSEVALORPROTHEUS.IDCLASSEVALOR FKPCONTAS_SCLASSEVALORPROTHEUSR

Indexes

Constraint Name Type Sort Column(s)
PKPCONTAS Primary key Asc/Asc CODCOLIGADA + PCONTASID
PXCONTALABORECONT Performance Asc/Asc/Asc/Asc CODCOLIGADA + GRPCONTA + CODINTEGR + INTEGRCFUNC

Relationships

Close relationships within degrees of separation