cof_rv_docfiscal

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lbr_docfiscal_id numeric 10 √ null
lbr_docfiscal.lbr_docfiscal_id Implied Constraint R
created timestamp 29,6 √ null
updated timestamp 29,6 √ null
createdby numeric 10 √ null
updatedby numeric 10 √ null
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id Implied Constraint R
c_doctypetarget_id numeric 10 √ null
processing bpchar 1 √ null
processed bpchar 1 √ null
infnfe_versao numeric 0 √ null
infnfe_id varchar 47 √ null
ide_cuf numeric 10 √ null
ide_cnf numeric 0 √ null
ide_natop varchar 60 √ null
ide_tpimp bpchar 1 √ null
ide_tpemis bpchar 1 √ null
ide_cdv numeric 10 √ null
ide_tpamb bpchar 1 √ null
dest_xnome varchar 60 √ null
dest_enderdest_xlgr varchar 60 √ null
dest_enderdest_nro varchar 60 √ null
dest_enderdest_xcpl varchar 60 √ null
dest_enderdest_xbairro varchar 60 √ null
dest_enderdest_cmun numeric 10 √ null
dest_enderdest_xmun varchar 60 √ null
dest_enderdest_uf varchar 2 √ null
dest_enderdest_cep varchar 9 √ null
dest_enderdest_cpais numeric 10 √ null
dest_enderdest_xpais varchar 60 √ null
dest_enderdest_fone varchar 14 √ null
dest_ie varchar 14 √ null
dest_isuf varchar 9 √ null
dest_email varchar 60 √ null
retirada_cnpj varchar 18 √ null
retirada_cpf varchar 14 √ null
retirada_xlgr varchar 60 √ null
retirada_nro varchar 60 √ null
retirada_xcpl varchar 60 √ null
retirada_xbairro varchar 60 √ null
retirada_cmun numeric 10 √ null
retirada_xmun varchar 60 √ null
retirada_uf varchar 2 √ null
entrega_bpartner_location_id numeric 10 √ null
entrega_cnpj varchar 18 √ null
entrega_cpf varchar 14 √ null
entrega_xlgr varchar 60 √ null
entrega_nro varchar 60 √ null
entrega_xcpl varchar 60 √ null
entrega_xbairro varchar 60 √ null
transp_vagao varchar 20 √ null
transp_balsa varchar 20 √ null
cobr_fat_vdesc numeric 0 √ null
ide_tpnf bpchar 1 √ null
ide_cmunfg numeric 10 √ null
ide_finnfe bpchar 1 √ null
ide_procemi bpchar 1 √ null
ide_verproc varchar 20 √ null
ide_dhcont timestamp 29,6 √ null
emit_enderemit_cmun numeric 10 √ null
transp_rettransp_picmsret numeric 0 √ null
ide_indpag bpchar 1 √ null
ide_mod varchar 2 √ null
ide_serie numeric 10 √ null
ide_nnf numeric 10 √ null
ide_demi timestamp 29,6 √ null
ide_dsaient timestamp 29,6 √ null
ide_hsaient varchar 8 √ null
ide_xjust varchar 256 √ null
emit_cnpj varchar 18 √ null
emit_xnome varchar 60 √ null
transp_reboque_rntc varchar 20 √ null
cobr_fat_nfat varchar 60 √ null
cobr_fat_vorig numeric 0 √ null
cobr_fat_vliq numeric 0 √ null
infadic_infadcpl text 2147483647 √ null
exporta_ufembarq varchar 2 √ null
exporta_xlocembarq varchar 60 √ null
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ null
emit_cnae varchar 7 √ null
total_icmstotal_vbc numeric 0 √ null
total_icmstotal_vbcst numeric 0 √ null
total_icmstotal_vdesc numeric 0 √ null
transp_rettransp_cmunfg numeric 10 √ null
transp_veictransp_placa varchar 8 √ null
emit_xfant varchar 60 √ null
emit_enderemit_xlgr varchar 60 √ null
emit_enderemit_nro varchar 60 √ null
emit_enderemit_xcpl varchar 60 √ null
emit_enderemit_xbairro varchar 60 √ null
emit_enderemit_xmun varchar 60 √ null
emit_enderemit_uf varchar 2 √ null
emit_enderemit_cep varchar 9 √ null
emit_enderemit_cpais numeric 10 √ null
emit_enderemit_xpais varchar 60 √ null
emit_enderemit_fone varchar 14 √ null
emit_ie varchar 14 √ null
emit_iest varchar 14 √ null
emit_im varchar 15 √ null
emit_crt bpchar 1 √ null
dest_bpartner_id numeric 10 √ null
dest_bpartner_location_id numeric 10 √ null
dest_cnpj varchar 18 √ null
dest_cpf varchar 14 √ null
entrega_cmun numeric 0 √ null
entrega_xmun varchar 60 √ null
entrega_uf varchar 2 √ null
total_icmstotal_vicms numeric 0 √ null
total_icmstotal_vst numeric 0 √ null
total_icmstotal_vprod numeric 0 √ null
total_icmstotal_vfrete numeric 0 √ null
total_icmstotal_vseg numeric 0 √ null
total_icmstotal_vii numeric 0 √ null
total_icmstotal_vipi numeric 0 √ null
total_icmstotal_vpis numeric 0 √ null
total_icmstotal_vcofins numeric 0 √ null
total_icmstotal_voutro numeric 0 √ null
total_icmstotal_vnf numeric 0 √ null
m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id Implied Constraint R
transp_modfrete bpchar 1 √ null
transp_transporta_cnpj varchar 18 √ null
transp_transporta_cpf varchar 14 √ null
transp_transporta_xnome varchar 60 √ null
transp_transporta_ie varchar 14 √ null
transp_transporta_xender varchar 60 √ null
transp_transporta_xmun varchar 60 √ null
transp_transporta_uf varchar 2 √ null
transp_rettransp_vserv numeric 0 √ null
transp_rettransp_vbcret numeric 0 √ null
transp_rettransp_vicmsret numeric 0 √ null
transp_rettransp_cfop numeric 0 √ null
transp_veictransp_uf varchar 2 √ null
transp_veictransp_rntc varchar 20 √ null
transp_reboque_placa varchar 8 √ null
transp_reboque_uf varchar 2 √ null
infadic_infadfisco varchar 2000 √ null
emit_cpf varchar 14 √ null
documentno varchar 30 √ null
emit_bpartner_id numeric 10 √ null
emit_bpartner_location_id numeric 10 √ null
dest_country_id numeric 10 √ null
emit_country_id numeric 10 √ null
entrega_region_id numeric 10 √ null
emit_region_id numeric 10 √ null
dest_region_id numeric 10 √ null
entrega_city_id numeric 10 √ null
emit_city_id numeric 10 √ null
dest_city_id numeric 10 √ null
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id Implied Constraint R
c_order_id numeric 10 √ null
c_order.c_order_id Implied Constraint R
m_inout_id numeric 10 √ null
m_inout.m_inout_id Implied Constraint R
lbr_transactiontype varchar 3 √ null
m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id Implied Constraint R
paymentrule bpchar 1 √ null
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id Implied Constraint R
lbr_isimport bpchar 1 √ null
docaction bpchar 2 √ null
docstatus varchar 2 √ null
ad_orgtrx_id numeric 10 √ null
issotrx bpchar 1 √ null
org_location_id numeric 10 √ null
lbr_generatenfe bpchar 5 √ null
lbr_nfestatus varchar 3 √ null
lbr_nfedesc text 2147483647 √ null
lbr_nfeprot varchar 60 √ null
lbr_nfelot_id numeric 10 √ null
lbr_nfelot.lbr_nfelot_id Implied Constraint R
lbr_digestvalue varchar 255 √ null
datetrx timestamp 29,6 √ null
lbr_nfestatusemail bpchar 1 √ null
lbr_retransmitenota bpchar 1 √ null
lbr_isowndocument bpchar 1 √ null
isprinted bpchar 1 √ null
dateprinted timestamp 29,6 √ null
createdocfiscal bpchar 1 √ null
cof_processing bpchar 1 √ null
ide_dhemi timestamp 29,6 √ null
ide_dhsaient timestamp 29,6 √ null
ide_iddest bpchar 1 √ null
ide_indfinal bpchar 1 √ null
ide_indpres bpchar 1 √ null
dest_idestrangeiro varchar 20 √ null
dest_indiedest bpchar 1 √ null
dest_im varchar 15 √ null
total_icmstotal_vicmsdeson numeric 0 √ null
total_icmstotal_vtottrib numeric 0 √ null
total_issqntot_vserv numeric 0 √ null
total_issqntot_vbc numeric 0 √ null
total_issqntot_viss numeric 0 √ null
total_issqntot_vpis numeric 0 √ null
total_issqntot_vcofins numeric 0 √ null
total_issqntot_dcompet timestamp 29,6 √ null
total_issqntot_vdeducao numeric 0 √ null
total_issqntot_voutro numeric 0 √ null
total_issqntot_vdescincond numeric 0 √ null
total_issqntot_vdesccond numeric 0 √ null
total_issqntot_vissret numeric 0 √ null
total_issqntot_cregtrib varchar 2 √ null
total_rettrib_vretpis numeric 0 √ null
total_rettrib_vretcofins numeric 0 √ null
total_rettrib_vretcsll numeric 0 √ null
total_rettrib_vbcirrf numeric 0 √ null
total_rettrib_virrf numeric 0 √ null
total_rettrib_vbcretprev numeric 0 √ null
total_rettrib_vretprev numeric 0 √ null
infadic_infcpl text 2147483647 √ null
exporta_ufsaidapais varchar 2 √ null
exporta_xlocexporta varchar 60 √ null
exporta_xlocdespacho varchar 60 √ null
compra_xnemp varchar 22 √ null
compra_xped varchar 60 √ null
compra_xcont varchar 60 √ null
cana_safra varchar 9 √ null
cana_ref varchar 7 √ null
lbr_motivocancel varchar 255 √ null
lbr_docfiscal_uu varchar 36 √ null
posted bpchar 1 √ null
processedon numeric 0 √ null
dateacct timestamp 29,6 √ null
datedoc timestamp 29,6 √ null
c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
cof_consultaprotocolo bpchar 1 √ null
deliveryviarule bpchar 1 √ null
cof_processing2 bpchar 1 √ null
m_movement_id numeric 10 √ null
m_movement.m_movement_id Implied Constraint R
lbr_docfiscal_line_id numeric 10 √ null
lbr_docfiscal_line.lbr_docfiscal_line_id Implied Constraint R
det_nitem numeric 10 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
det_prod_cprod varchar 60 √ null
det_prod_cean varchar 14 √ null
det_prod_xprod varchar 120 √ null
det_prod_ncm varchar 8 √ null
det_prod_extipi varchar 3 √ null
det_prod_cfop varchar 4 √ null
det_prod_ucom varchar 6 √ null
det_prod_qcom numeric 0 √ null
det_prod_vuncom numeric 0 √ null
det_prod_vprod numeric 0 √ null
det_prod_ceantrib varchar 14 √ null
det_prod_utrib varchar 6 √ null
det_prod_qtrib numeric 0 √ null
det_prod_vuntrib numeric 0 √ null
det_prod_vfrete numeric 0 √ null
det_prod_vseg numeric 0 √ null
det_prod_vdesc numeric 0 √ null
det_prod_voutro numeric 0 √ null
det_prod_indtot bpchar 1 √ null
det_infadprod varchar 500 √ null
imposto_icms_orig bpchar 1 √ null
imposto_icms_cst varchar 2 √ null
imposto_icmssn_csosn varchar 3 √ null
imposto_icms_modbc bpchar 1 √ null
imposto_icms_predbc numeric 0 √ null
imposto_icms_vbc numeric 0 √ null
imposto_icms_picms numeric 0 √ null
imposto_icms_vicms numeric 0 √ null
imposto_icms_modbcst bpchar 1 √ null
imposto_icms_pmvast numeric 0 √ null
imposto_icms_predbcst numeric 0 √ null
imposto_icms_vbcst numeric 0 √ null
imposto_icms_picmsst numeric 0 √ null
imposto_icms_vicmsst numeric 0 √ null
imposto_icms_ufst varchar 2 √ null
imposto_icms_pbcop numeric 0 √ null
imposto_icms_vbcstret numeric 0 √ null
imposto_icms_vicmsstret numeric 0 √ null
imposto_icms_motdesicms varchar 2 √ null
imposto_icmssn_pcredsn numeric 0 √ null
imposto_icmssn_vcredicmssn numeric 0 √ null
imposto_ipi_clenq varchar 5 √ null
imposto_ipi_cnpjprod varchar 14 √ null
imposto_ipi_cselo varchar 60 √ null
imposto_ipi_qselo numeric 0 √ null
imposto_ipi_cenq varchar 13 √ null
imposto_ipi_cst varchar 2 √ null
imposto_ipi_vbc numeric 0 √ null
imposto_ipi_qunid numeric 0 √ null
imposto_ipi_vunid numeric 0 √ null
imposto_ipi_pipi numeric 0 √ null
imposto_ipi_vipi numeric 0 √ null
imposto_ii_vbc numeric 0 √ null
imposto_ii_vdespadu numeric 0 √ null
imposto_ii_vii numeric 0 √ null
imposto_ii_viof numeric 0 √ null
imposto_pis_cst varchar 2 √ null
imposto_pis_vbc numeric 0 √ null
imposto_pis_ppis numeric 0 √ null
imposto_pis_vpis numeric 0 √ null
imposto_pis_qbcprod numeric 0 √ null
imposto_pis_valiqprod numeric 0 √ null
imposto_pisst_vbc numeric 0 √ null
imposto_pisst_ppis numeric 0 √ null
imposto_pisst_qbcprod numeric 0 √ null
imposto_pisst_valiqprod numeric 0 √ null
imposto_pisst_vpis numeric 0 √ null
imposto_cofins_cst varchar 2 √ null
imposto_cofins_vbc numeric 0 √ null
imposto_cofins_pcofins numeric 0 √ null
imposto_cofins_qbcprod numeric 0 √ null
imposto_cofins_valiqprod numeric 0 √ null
imposto_cofins_vcofins numeric 0 √ null
imposto_cofinsst_vbc numeric 0 √ null
imposto_cofinsst_pcofins numeric 0 √ null
imposto_cofinsst_qbcprod numeric 0 √ null
imposto_cofinsst_valiqprod numeric 0 √ null
imposto_cofinsst_vcofins numeric 0 √ null
lineno numeric 10 √ null
c_charge_id numeric 10 √ null
c_charge.c_charge_id Implied Constraint R
imposto_vbcpauta numeric 0 √ null
cof_specificproduct varchar 2 √ null
det_prod_veicprod_tpop bpchar 1 √ null
det_prod_veicprod_chassi varchar 17 √ null
det_prod_veicprod_ccor varchar 4 √ null
det_prod_veicprod_xcor varchar 40 √ null
det_prod_veicprod_pot varchar 4 √ null
det_prod_veicprod_cilin varchar 4 √ null
det_prod_veicprod_pesol varchar 9 √ null
det_prod_veicprod_pesob varchar 9 √ null
det_prod_veicprod_nserie varchar 9 √ null
det_prod_veicprod_tpcomb varchar 2 √ null
det_prod_veicprod_nmotor varchar 21 √ null
det_prod_veicprod_cmt varchar 9 √ null
det_prod_veicprod_dist varchar 4 √ null
det_prod_veicprod_anomod numeric 10 √ null
det_prod_veicprod_anofab numeric 10 √ null
det_prod_veicprod_tppint varchar 1 √ null
det_prod_veicprod_tpveic varchar 2 √ null
det_prod_veicprod_espveic bpchar 1 √ null
det_prod_veicprod_vin bpchar 1 √ null
det_prod_veicprod_condveic bpchar 1 √ null
det_prod_veicprod_cmod varchar 6 √ null
det_prod_veicprod_ccordenatran varchar 2 √ null
det_prod_veicprod_lota numeric 10 √ null
det_prod_veicprod_tprest bpchar 1 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
lbr_cfop_id numeric 10 √ null
lbr_cfop.lbr_cfop_id Implied Constraint R
c_invoiceline_id numeric 10 √ null
c_invoiceline.c_invoiceline_id Implied Constraint R
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
det_prod_xped varchar 15 √ null
det_prod_nitemped numeric 10 √ null
det_prod_nfci varchar 36 √ null
det_prod_comb_cprodanp numeric 10 √ null
det_prod_comb_pmixgn numeric 0 √ null
det_prod_comb_codif numeric 0 √ null
det_prod_comb_qtemp numeric 0 √ null
det_prod_comb_ufcons varchar 2 √ null
det_prod_comb_cide_qbcprod numeric 0 √ null
det_prod_comb_cide_valiqprod numeric 0 √ null
det_prod_comb_cide_vcide numeric 0 √ null
det_prod_nrecopi numeric 0 √ null
imposto_vtottrib numeric 0 √ null
imposto_icms_vicmsdeson numeric 0 √ null
imposto_icms_vicmsop numeric 0 √ null
imposto_icms_pdif numeric 0 √ null
imposto_icms_vicmsdif numeric 0 √ null
imposto_icms_vbcstdest numeric 0 √ null
imposto_icms_vicmsstdest numeric 0 √ null
imposto_issqn_vbc numeric 0 √ null
imposto_issqn_valiq numeric 0 √ null
imposto_issqn_vissqn numeric 0 √ null
imposto_issqn_cmunfg numeric 0 √ null
imposto_issqn_clistserv varchar 5 √ null
imposto_issqn_vdeducao numeric 0 √ null
imposto_issqn_voutro numeric 0 √ null
imposto_issqn_vdescincond numeric 0 √ null
imposto_issqn_vdesccond numeric 0 √ null
imposto_issqn_vissret numeric 0 √ null
imposto_issqn_indiss varchar 2 √ null
imposto_issqn_cservico varchar 20 √ null
imposto_issqn_cmun numeric 0 √ null
imposto_issqn_cpais numeric 0 √ null
imposto_issqn_nprocesso varchar 30 √ null
imposto_issqn_indincentivo bpchar 1 √ null
det_impostodevol_pdevol numeric 0 √ null
det_impostodevol_ipi_vipidevol numeric 0 √ null
lbr_docfiscal_line_uu varchar 36 √ null
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id Implied Constraint R
m_movementline_id numeric 10 √ null
m_movementline.m_movementline_id Implied Constraint R
cof_producttype_id numeric 10 √ null
cof_producttype.cof_producttype_id Implied Constraint R
cof_productclass_id numeric 10 √ null
cof_productclass.cof_productclass_id Implied Constraint R
cof_productgroup_id numeric 10 √ null
cof_productgroup.cof_productgroup_id Implied Constraint R
m_product_category_id numeric 10 √ null
m_product_category.m_product_category_id Implied Constraint R
imposto_icmsufdest_vicmsufdest numeric 0 √ null
total_icmstotal_vicmsufdest numeric 0 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views