PCONTASGER

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GDEPTO.CODCOLIGADA FKPCONTASGER_GDEPTOR
PCCUSTO.CODCOLIGADA FKPCONTASGER_PCCUSTOR
PCODINTGER.CODCOLIGADA FKPCONTASGER_PCODINTGERR
GCOLIGADA.CODCOLIGADA FKPCONTASGER_GCOLIGADAR
GFILIAL.CODCOLIGADA FKPCONTASGER_GFILIALR
PGRPCONTAGER.CODCOLIGADA FKPCONTASGER_PGRPCONTAGERR
PCODINTGERFUNC.CODCOLIGADA FKPCONTASGER_PCODINTGERFUNCR
PCONTASGERID int 4 null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKPCONTASGER_GDEPTOR
GFILIAL.CODFILIAL FKPCONTASGER_GFILIALR
CONTASALDUS DCODCONTA 40 √ null
CGERENCIA.CODCONTA FKPCONTASGER_CGERENCIAR
CODCOLCONTA DCODCOLIGADA 2 null
CGERENCIA.CODCOLIGADA FKPCONTASGER_CGERENCIAR
CODCCUSTO varchar 25 √ null
PCCUSTO.CODCCUSTO FKPCONTASGER_PCCUSTOR
GRPCONTA varchar 22 √ null
PGRPCONTAGER.CODCLIENTE FKPCONTASGER_PGRPCONTAGERR
CODINTEGR varchar 22 √ null
PCODINTGER.CODCLIENTE FKPCONTASGER_PCODINTGERR
INTEGRCFUNC varchar 22 √ null
PCODINTGERFUNC.CODCLIENTE FKPCONTASGER_PCODINTGERFUNCR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKPCONTASGER_GDEPTOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPCONTAGER Primary key Asc/Asc CODCOLIGADA + PCONTASGERID
PXCONTALABOREGER Performance Asc/Asc/Asc/Asc CODCOLIGADA + GRPCONTA + CODINTEGR + INTEGRCFUNC

Relationships

Close relationships within degrees of separation