DREGRAIPI

690 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCFOP.CODCOLIGADA FKDCFOP_DREGRAIPIR
DTRBREGRAIPI.CODCOLIGADA FKDTRBREGRAIPI_DREGRAIPIR
IDREGRAIPI int 4 null
DCFOP.IDREGRAIPI FKDCFOP_DREGRAIPIR
DTRBREGRAIPI.IDREGRAIPI FKDTRBREGRAIPI_DREGRAIPIR
CODIGO varchar 10 null
DESCRICAO varchar 255 √ null
TIPO varchar 2 null
GLOBAL smallint 2 √ null
CODFILIAL int 4 √ null
IPISEMDESCONTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NAFETABASEIPI int 4 √ null
REGRASTRIBUTARIAS int 4 √ null
OPERACAOCOMPLEMENTAR smallint 2 √ null
CONTROLAFECHAMENTO DLOGICO 2 null
SITTRIBUTARIAIPIENT varchar 2 √ null
SITTRIBUTARIAIPISAI varchar 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODENQIPI varchar 3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKDREGRAIPI Primary key Asc/Asc CODCOLIGADA + IDREGRAIPI
DXREGRAIPI Must be unique Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODIGO

Relationships

Close relationships within degrees of separation