DAPURACAOITEM

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DLANCLALURB.CODCOLIGADA FKDLANCLALURB_DAPURACAOITEMR
DPERIODO.CODCOLIGADA FKDAPURACAOITEM_DPERIODOR
DEVCTRBLANC.CODCOLIGADA FKDAPURACAOITEM_R
DITMEVCTRB.CODCOLIGADA FKDAPURACAOITEM_DITMEVCTRBR
IDPERITEM int 4 null
DLANCLALURB.IDPERITEM FKDLANCLALURB_DAPURACAOITEMR
ORIGEM smallint 2 null
GRUPO int 4 null
IDPER int 4 null
DPERIODO.IDPER FKDAPURACAOITEM_DPERIODOR
IDEVCTRB int 4 √ null
DITMEVCTRB.IDEVCTRB FKDAPURACAOITEM_DITMEVCTRBR
NUMITEM int 4 √ null
DITMEVCTRB.NUMITEM FKDAPURACAOITEM_DITMEVCTRBR
IDLANCPERIODO int 4 √ null
DEVCTRBLANC.IDLANCPERIODO FKDAPURACAOITEM_R
VALOR numeric 40,4 √ null
IDTABDINAMECF int 4 √ null
DTABELADINAMICAECF.IDTABDINAMECF FKDAPURACAOITEM_DTABELADINECFR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLCONTALEFEITOPTB DCODCOLIGADANULL 2 √ null
CCONTA2.CODCOLIGADA FKDAPURACAOITEM_CCONTA2R
CODPARALELOEFEITOPTB varchar 10 √ null
CCONTA2.CODPARALELO FKDAPURACAOITEM_CCONTA2R
CODCONTALEFEITOPTB DCODCONTA 40 √ null
CCONTA2.CODCONTA FKDAPURACAOITEM_CCONTA2R

Indexes

Constraint Name Type Sort Column(s)
PKDAPURACAOITEM Primary key Asc/Asc CODCOLIGADA + IDPERITEM

Relationships

Close relationships within degrees of separation