XALGCONTRATOLOCRATEIO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCONTLOC int 4 null
XALGCONTRATOLOC.CODCONTLOC FK_XALGCONTRATCRA_XALGCONTRATLR
CODCOLCONTLOC DCODCOLIGADA 2 null
XALGCONTRATOLOC.CODCOLCONTLOC FK_XALGCONTRATCRA_XALGCONTRATLR
CODRATEIO int 4 null
CODCOLCCUSTO DCODCOLIGADANULL 2 √ null
GCCUSTO.CODCOLIGADA FKXALGCONTRATOLOCRATEIO_GCCUSTR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKXALGCONTRATOLOCRATEIO_GCCUSTR
PERCENTUAL RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLITEMCONTABIL DCODCOLIGADANULL 2 √ null
SITEMCONTABILPROTHEUS.CODCOLIGADA FKXALGCONTRATOLOCRATEIO_SITEMCR
IDITEMCONTABIL int 4 √ null
SITEMCONTABILPROTHEUS.IDITEMCONTABIL FKXALGCONTRATOLOCRATEIO_SITEMCR
CODCOLCLASSEVALOR DCODCOLIGADANULL 2 √ null
SCLASSEVALORPROTHEUS.CODCOLIGADA FKXALGCONTRATOLOCRATEIO_SCLASSR
IDCLASSEVALOR int 4 √ null
SCLASSEVALORPROTHEUS.IDCLASSEVALOR FKXALGCONTRATOLOCRATEIO_SCLASSR

Indexes

Constraint Name Type Sort Column(s)
PKXALGCONTRATOLOCRATEIO Primary key Asc/Asc/Asc CODCONTLOC + CODCOLCONTLOC + CODRATEIO

Relationships

Close relationships within degrees of separation