SZ0SALDOCENTROCUSTORATEIO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CDCOLIGADA DCODCOLIGADA 2 null
SZ0CENTROCUSTO.CDCOLIGADA FKSZ0SALDOCENTRO_SZ0CENTRO_DESR
SZ0PERIODOCOMPETENCIA.CDCOLIGADA FKSZ0SALDOCENTRO_SZ0PERIODOCOMR
CDFILIAL smallint 2 null
SZ0PERIODOCOMPETENCIA.CDFILIAL FKSZ0SALDOCENTRO_SZ0PERIODOCOMR
SZ0CENTROCUSTO.CDFILIAL FKSZ0SALDOCENTRO_SZ0CENTRO_ORIR
CDPERIODOCOMPETENCIA numeric 12 null
SZ0PERIODOCOMPETENCIA.CDPERIODOCOMPETENCIA FKSZ0SALDOCENTRO_SZ0PERIODOCOMR
CDCENARIO varchar 16 null
SZ0CENARIO.CDCENARIO FKSZ0SALDOCENTRO_SZ0CENARIOR
CDCALCULORATEIO numeric 12 null
CDCENTROCUSTOORIGEM varchar 45 null
SZ0CENTROCUSTO.CDCENTROCUSTO FKSZ0SALDOCENTRO_SZ0CENTRO_ORIR
CDCENTROCUSTODESTINO varchar 45 null
SZ0CENTROCUSTO.CDCENTROCUSTO FKSZ0SALDOCENTRO_SZ0CENTRO_DESR
VLSALDO numeric 16,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CDFILIALCENTROCUSTODESTINO smallint 2 null
SZ0CENTROCUSTO.CDFILIAL FKSZ0SALDOCENTRO_SZ0CENTRO_DESR

Indexes

Constraint Name Type Sort Column(s)
PKSZ0SALDOCENTROCUSTORATEIO Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CDCOLIGADA + CDFILIAL + CDPERIODOCOMPETENCIA + CDCENARIO + CDCALCULORATEIO + CDCENTROCUSTOORIGEM + CDFILIALCENTROCUSTODESTINO + CDCENTROCUSTODESTINO

Relationships

Close relationships within degrees of separation