MCNTPDODEDITM

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MTAREFA.CODCOLIGADA FKMCNTPDODEDITM_MTAREFAR
MPDODETRET.CODCOLIGADA FKMCNTPDODEDITM_MPDODETRETR
ID int 4 null
IDPRJ int 4 null
MPDODETRET.IDPRJ FKMCNTPDODEDITM_MPDODETRETR
MTAREFA.IDPRJ FKMCNTPDODEDITM_MTAREFAR
IDCNT int 4 null
MPDODETRET.IDCNT FKMCNTPDODEDITM_MPDODETRETR
PERIODOMED varchar 10 null
MPDODETRET.PERIODOMED FKMCNTPDODEDITM_MPDODETRETR
CLASSIFICACAO smallint 2 null
MPDODETRET.CLASSIFICACAO FKMCNTPDODEDITM_MPDODETRETR
IDDED int 4 null
MPDODETRET.IDDETRET FKMCNTPDODEDITM_MPDODETRETR
IDINTEGRACAO varchar 200 √ null
IDITEMINTEGRACAO varchar 200 √ null
IDPRD int 4 null
TPRODUTO.IDPRD FKMCNTPDODEDITM_TPRODUTOR
CODUND varchar 5 √ null
TUND.CODUND FKMCNTPDODEDITM_TUNDR
IDTRF int 4 √ null
MTAREFA.IDTRF FKMCNTPDODEDITM_MTAREFAR
CODMOEDA varchar 10 √ null
GMOEDA.SIMBOLO FKMCNTPDODEDITM_GMOEDAR
VALORDEDUZIDO numeric 23,10 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null

Indexes

Constraint Name Type Sort Column(s)
PKMCNTPDODEDITM Primary key Asc/Asc CODCOLIGADA + ID

Relationships

Close relationships within degrees of separation