cfop


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcfop int8 19 null
cfop_aud.idcfop Implied Constraint R
cfopfilial.idcfop fk_ea33kqjejtfkhvvva1sn8n6nq R
cfopfilial_aud.idcfop Implied Constraint R
cfopnotafiscal.idcfop fk_1v9l3ihpuxawsplfsngwvl5p8 R
cfopnotafiscal_aud.idcfop Implied Constraint R
cfoppedido.idcfop fk_5hpnhnhlixv5o40dr60bl85ly R
cfoppedido_aud.idcfop Implied Constraint R
cfoptipopedido.idcfop fk_cxo2wogov92uf4x8y3spuqxyo R
cfoptipopedido_aud.idcfop Implied Constraint R
impostoprodutouf.idcfop fk_s16hdege7ktia2kerka9g7usm R
impostoprodutouf_aud.idcfop Implied Constraint R
notafiscalproduto.idcfop fk_36lqrmiycmj7uuo5prooj75xk R
notafiscalproduto_aud.idcfop Implied Constraint R
transacaofiscal.idcfop fk_464ckyecjpmjq0vjaop2wksr6 R
transacaofiscal_aud.idcfop Implied Constraint R
wagrpedido.idcfop fk_nkmlde93koykjajcef1jxpaud R
wagrpedido_aud.idcfop Implied Constraint R
descricao varchar 4000 √ null
descricaoclassifica varchar 4000 √ null
codigocomplemento varchar 20 √ null
codigoaliquotauf varchar 20 √ null
sglcondicionaicms varchar 10 √ null
observacao varchar 4000 √ null
idnativo int2 5 null
idnreceitafinanceira int2 5 √ null
idntributapis int2 5 √ null
idntributacofins int2 5 √ null
idnicms int2 5 √ null
idnnotafiscalretorno int2 5 √ null
idtipolancamento int8 19 √ null
tipolancamento.idtipolancamento fk_flixccb9vjtf5mf77ek8yi9fy R
idtiponotafiscal int8 19 √ null
tiponotafiscal.idtiponotafiscal fk_rtxib64jooln1gbs5q1eskywy R
idtipomaterialnotafiscal int8 19 √ null
tipomaterialnotafiscal.idtipomaterialnotafiscal fk_k2287yonu6f6fjes7cf6ys0ix R
idtipopedido int8 19 √ null
tipopedido.idtipopedido fk_odg1xp6jmthbn2uh183hk31x9 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
codigo varchar 80 √ null

Indexes

Constraint Name Type Sort Column(s)
pk1f8584 Primary key Asc idcfop
idxa00668be Performance Asc idtipomaterialnotafiscal
idxc8f06fd3 Performance Asc idtiponotafiscal
idxd943104c Performance Asc idtipolancamento
idxdcff4551 Performance Asc idtipopedido
idxwsversao_1f8584 Performance Desc wsversao
uccaa74136 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation