lbr_docfiscal

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lbr_docfiscal_id numeric 10 null
c_invoice.lbr_docfiscal_id lbrdocfiscal_cinvoice N
cof_c_taxdetermination_fact.cof_docfiscal_id cofdocfiscal_cofctaxdeterminat R
cof_c_taxdetermination_line.lbr_docfiscal_id lbrdocfiscal_cofctaxdeterminat R
cof_controleremessasind.lbr_docfiscal_id lbrdocfiscal_cofcontroleremess C
cof_packinglist_line.lbr_docfiscal_id lbrdocfiscal_cofpackinglistlin N
cof_pneu.lbr_docfiscal_id lbrdocfiscal_cofpneu C
cof_pneu_manutencao.cof_docfiscal_id cofdocfiscal_cofpneumanutencao N
cof_pneu_manutencao.lbr_docfiscal_id lbrdocfiscal_cofpneumanutencao C
cof_rv_detalheslistaembarque.lbr_docfiscal_id Implied Constraint R
cof_rv_detalhespneu.lbr_docfiscal_id Implied Constraint R
cof_rv_docfiscal.lbr_docfiscal_id Implied Constraint R
cof_rv_infodevolucao.lbr_docfiscal_id Implied Constraint R
cof_rv_itenspago.lbr_docfiscal_id Implied Constraint R
cof_rv_titulos.lbr_docfiscal_id Implied Constraint R
cof_titulo.lbr_docfiscal_id lbrdocfiscal_coftitulo N
cof_transacoesfiscais.lbr_docfiscal_id Implied Constraint R
lbr_de.lbr_docfiscal_id lbrdocfiscal_lbrde R
lbr_docfiscal_autxml.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalautxm C
lbr_docfiscal_cana_deduc.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalcanad C
lbr_docfiscal_cana_fordia.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalcanaf C
lbr_docfiscal_cobr_dup.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalcobrd C
lbr_docfiscal_detpag.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalpag C
lbr_docfiscal_line.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalline C
lbr_docfiscal_obscont.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalobsco C
lbr_docfiscal_obsfisco.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalobsfi C
lbr_docfiscal_procref.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalprocr C
lbr_docfiscal_ref.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscalref C
lbr_docfiscal_ref.ref_docfiscal_id refdocfiscal_lbrdocfiscalref R
lbr_docfiscal_transp_vol.lbr_docfiscal_id lbrdocfiscal_lbrdocfiscaltrans C
lbr_eventonfe.lbr_docfiscal_id lbrdocfiscal_lbreventonfe R
lbr_nfdi.lbr_docfiscal_id lbrdocfiscal_lbrnfdi R
m_inout.lbr_docfiscal_id lbrdocfiscal_minout C
m_movement.cof_docfiscal_id cofdocfiscal_mmovement N
m_movement.lbr_docfiscal_id lbrdocfiscal_mmovement N
m_rma.lbr_docfiscal_id lbrdocfiscal_mrma N
rv_c_invoice.lbr_docfiscal_id Implied Constraint R
rv_invoicepayschedule.lbr_docfiscal_id Implied Constraint R
rv_openitem.lbr_docfiscal_id Implied Constraint R
rv_openitemtodate.lbr_docfiscal_id Implied Constraint R
t_aging.lbr_docfiscal_id lbrdocfiscal_taging C
created timestamp 29,6 null
updated timestamp 29,6 null
createdby numeric 10 null
updatedby numeric 10 null
c_doctype_id numeric 10 √ NULL::numeric
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::character varying
ide_cuf numeric 10 √ null
ide_cnf numeric 0 √ null
ide_natop varchar 60 √ NULL::character varying
ide_tpimp bpchar 1 √ NULL::bpchar
ide_tpemis bpchar 1 √ NULL::bpchar
ide_cdv numeric 10 √ null
ide_tpamb bpchar 1 √ NULL::bpchar
dest_xnome varchar 60 √ NULL::character varying
dest_enderdest_xlgr varchar 60 √ NULL::character varying
dest_enderdest_nro varchar 60 √ NULL::character varying
dest_enderdest_xcpl varchar 60 √ NULL::character varying
dest_enderdest_xbairro varchar 60 √ NULL::character varying
dest_enderdest_cmun numeric 10 √ null
dest_enderdest_xmun varchar 60 √ NULL::character varying
dest_enderdest_uf varchar 2 √ NULL::character varying
dest_enderdest_cep varchar 9 √ NULL::character varying
dest_enderdest_cpais numeric 10 √ null
dest_enderdest_xpais varchar 60 √ NULL::character varying
dest_enderdest_fone varchar 14 √ NULL::character varying
dest_ie varchar 14 √ NULL::character varying
dest_isuf varchar 9 √ NULL::character varying
dest_email varchar 60 √ NULL::character varying
retirada_cnpj varchar 18 √ NULL::character varying
retirada_cpf varchar 14 √ NULL::character varying
retirada_xlgr varchar 60 √ NULL::character varying
retirada_nro varchar 60 √ NULL::character varying
retirada_xcpl varchar 60 √ NULL::character varying
retirada_xbairro varchar 60 √ NULL::character varying
retirada_cmun numeric 10 √ null
retirada_xmun varchar 60 √ NULL::character varying
retirada_uf varchar 2 √ NULL::character varying
entrega_bpartner_location_id numeric 10 √ NULL::numeric
entrega_cnpj varchar 18 √ NULL::character varying
entrega_cpf varchar 14 √ NULL::character varying
entrega_xlgr varchar 60 √ NULL::character varying
entrega_nro varchar 60 √ NULL::character varying
entrega_xcpl varchar 60 √ NULL::character varying
entrega_xbairro varchar 60 √ NULL::character varying
transp_vagao varchar 20 √ NULL::character varying
transp_balsa varchar 20 √ NULL::character varying
cobr_fat_vdesc numeric 0 √ (0)::numeric
ide_tpnf bpchar 1 '0'::bpchar
ide_cmunfg numeric 10 √ null
ide_finnfe bpchar 1 '1'::bpchar
ide_procemi bpchar 1 √ NULL::bpchar
ide_verproc varchar 20 NULL::character varying
ide_dhcont timestamp 29,6 √ null
emit_enderemit_cmun numeric 10 √ null
transp_rettransp_picmsret numeric 0 √ (0)::numeric
ide_indpag bpchar 1 '2'::bpchar
ide_mod varchar 2 √ NULL::character varying
ide_serie numeric 10 √ null
ide_nnf numeric 10 √ NULL::numeric
ide_demi timestamp 29,6 √ null
ide_dsaient timestamp 29,6 √ null
ide_hsaient varchar 8 √ null
ide_xjust varchar 256 √ NULL::character varying
emit_cnpj varchar 18 √ NULL::character varying
emit_xnome varchar 60 √ NULL::character varying
transp_reboque_rntc varchar 20 √ NULL::character varying
cobr_fat_nfat varchar 60 √ NULL::character varying
cobr_fat_vorig numeric 0 √ (0)::numeric
cobr_fat_vliq numeric 0 √ (0)::numeric
infadic_infadcpl text 2147483647 √ null
exporta_ufembarq varchar 2 √ NULL::character varying
exporta_xlocembarq varchar 60 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 null
emit_cnae varchar 7 √ NULL::character varying
total_icmstotal_vbc numeric 0 (0)::numeric
total_icmstotal_vbcst numeric 0 (0)::numeric
total_icmstotal_vdesc numeric 0 √ (0)::numeric
transp_rettransp_cmunfg numeric 10 √ null
transp_veictransp_placa varchar 8 √ NULL::character varying
emit_xfant varchar 60 √ NULL::character varying
emit_enderemit_xlgr varchar 60 √ NULL::character varying
emit_enderemit_nro varchar 60 √ NULL::character varying
emit_enderemit_xcpl varchar 60 √ NULL::character varying
emit_enderemit_xbairro varchar 60 √ NULL::character varying
emit_enderemit_xmun varchar 60 √ NULL::character varying
emit_enderemit_uf varchar 2 √ NULL::character varying
emit_enderemit_cep varchar 9 √ NULL::character varying
emit_enderemit_cpais numeric 10 √ (1058)::numeric
emit_enderemit_xpais varchar 60 √ NULL::character varying
emit_enderemit_fone varchar 14 √ NULL::character varying
emit_ie varchar 14 √ NULL::character varying
emit_iest varchar 14 √ NULL::character varying
emit_im varchar 15 √ null
emit_crt bpchar 1 √ '3'::bpchar
dest_bpartner_id numeric 10 √ NULL::numeric
dest_bpartner_location_id numeric 10 √ NULL::numeric
dest_cnpj varchar 18 √ NULL::character varying
dest_cpf varchar 14 √ NULL::character varying
entrega_cmun numeric 0 √ null
entrega_xmun varchar 60 √ NULL::character varying
entrega_uf varchar 2 √ NULL::character varying
total_icmstotal_vicms numeric 0 (0)::numeric
total_icmstotal_vst numeric 0 (0)::numeric
total_icmstotal_vprod numeric 0 (0)::numeric
total_icmstotal_vfrete numeric 0 √ (0)::numeric
total_icmstotal_vseg numeric 0 √ (0)::numeric
total_icmstotal_vii numeric 0 √ (0)::numeric
total_icmstotal_vipi numeric 0 √ (0)::numeric
total_icmstotal_vpis numeric 0 (0)::numeric
total_icmstotal_vcofins numeric 0 (0)::numeric
total_icmstotal_voutro numeric 0 √ (0)::numeric
total_icmstotal_vnf numeric 0 (0)::numeric
m_shipper_id numeric 10 √ NULL::numeric
m_shipper.m_shipper_id Implied Constraint R
transp_modfrete bpchar 1 '1'::bpchar
transp_transporta_cnpj varchar 18 √ NULL::character varying
transp_transporta_cpf varchar 14 √ NULL::character varying
transp_transporta_xnome varchar 60 √ NULL::character varying
transp_transporta_ie varchar 14 √ NULL::character varying
transp_transporta_xender varchar 60 √ NULL::character varying
transp_transporta_xmun varchar 60 √ NULL::character varying
transp_transporta_uf varchar 2 √ NULL::character varying
transp_rettransp_vserv numeric 0 √ (0)::numeric
transp_rettransp_vbcret numeric 0 √ (0)::numeric
transp_rettransp_vicmsret numeric 0 √ (0)::numeric
transp_rettransp_cfop numeric 0 √ null
transp_veictransp_uf varchar 2 √ NULL::character varying
transp_veictransp_rntc varchar 20 √ NULL::character varying
transp_reboque_placa varchar 8 √ NULL::character varying
transp_reboque_uf varchar 2 √ NULL::character varying
infadic_infadfisco varchar 2000 √ NULL::character varying
emit_cpf varchar 14 √ NULL::character varying
documentno varchar 30 null
emit_bpartner_id numeric 10 √ NULL::numeric
emit_bpartner_location_id numeric 10 √ NULL::numeric
dest_country_id numeric 10 √ (139)::numeric
emit_country_id numeric 10 √ (139)::numeric
entrega_region_id numeric 10 √ NULL::numeric
emit_region_id numeric 10 √ NULL::numeric
dest_region_id numeric 10 √ NULL::numeric
entrega_city_id numeric 10 √ NULL::numeric
emit_city_id numeric 10 √ NULL::numeric
dest_city_id numeric 10 √ NULL::numeric
c_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id Implied Constraint R
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id Implied Constraint R
m_inout_id numeric 10 √ NULL::numeric
m_inout.m_inout_id Implied Constraint R
lbr_transactiontype varchar 3 'RES'::character varying
m_pricelist_id numeric 10 √ NULL::numeric
m_pricelist.m_pricelist_id Implied Constraint R
paymentrule bpchar 1 'P'::bpchar
c_paymentterm_id numeric 10 √ NULL::numeric
c_paymentterm.c_paymentterm_id Implied Constraint R
lbr_isimport bpchar 1 'N'::bpchar
docaction bpchar 2 'CO'::bpchar
docstatus varchar 2 'DR'::character varying
ad_orgtrx_id numeric 10 √ NULL::numeric
issotrx bpchar 1 'N'::bpchar
org_location_id numeric 10 √ NULL::numeric
lbr_generatenfe bpchar 5 √ NULL::bpchar
lbr_nfestatus varchar 3 √ NULL::character varying
lbr_nfedesc text 2147483647 √ null
lbr_nfeprot varchar 60 √ NULL::character varying
lbr_nfelot_id numeric 10 √ NULL::numeric
lbr_nfelot.lbr_nfelot_id Implied Constraint R
lbr_digestvalue varchar 255 √ NULL::character varying
datetrx timestamp 29,6 √ null
lbr_nfestatusemail bpchar 1 √ '1'::bpchar
lbr_retransmitenota bpchar 1 √ NULL::bpchar
lbr_isowndocument bpchar 1 'Y'::bpchar
isprinted bpchar 1 √ 'N'::bpchar
dateprinted timestamp 29,6 √ null
createdocfiscal bpchar 1 √ null
cof_processing bpchar 1 √ NULL::bpchar
ide_dhemi timestamp 29,6 √ null
ide_dhsaient timestamp 29,6 √ null
ide_iddest bpchar 1 √ NULL::bpchar
ide_indfinal bpchar 1 '0'::bpchar
ide_indpres bpchar 1 '1'::bpchar
dest_idestrangeiro varchar 20 √ NULL::character varying
dest_indiedest bpchar 1 √ NULL::bpchar
dest_im varchar 15 √ NULL::character varying
total_icmstotal_vicmsdeson numeric 0 √ (0)::numeric
total_icmstotal_vtottrib numeric 0 √ (0)::numeric
total_issqntot_vserv numeric 0 √ (0)::numeric
total_issqntot_vbc numeric 0 √ (0)::numeric
total_issqntot_viss numeric 0 √ (0)::numeric
total_issqntot_vpis numeric 0 √ (0)::numeric
total_issqntot_vcofins numeric 0 √ (0)::numeric
total_issqntot_dcompet timestamp 29,6 √ null
total_issqntot_vdeducao numeric 0 √ (0)::numeric
total_issqntot_voutro numeric 0 √ (0)::numeric
total_issqntot_vdescincond numeric 0 √ (0)::numeric
total_issqntot_vdesccond numeric 0 √ (0)::numeric
total_issqntot_vissret numeric 0 √ (0)::numeric
total_issqntot_cregtrib varchar 2 √ NULL::character varying
total_rettrib_vretpis numeric 0 √ (0)::numeric
total_rettrib_vretcofins numeric 0 √ (0)::numeric
total_rettrib_vretcsll numeric 0 √ (0)::numeric
total_rettrib_vbcirrf numeric 0 √ (0)::numeric
total_rettrib_virrf numeric 0 √ (0)::numeric
total_rettrib_vbcretprev numeric 0 √ (0)::numeric
total_rettrib_vretprev numeric 0 √ (0)::numeric
infadic_infcpl text 2147483647 √ null
exporta_ufsaidapais varchar 2 √ NULL::character varying
exporta_xlocexporta varchar 60 √ NULL::character varying
exporta_xlocdespacho varchar 60 √ NULL::character varying
compra_xnemp varchar 22 √ NULL::character varying
compra_xped varchar 60 √ NULL::character varying
compra_xcont varchar 60 √ NULL::character varying
cana_safra varchar 9 √ NULL::character varying
cana_ref varchar 7 √ NULL::character varying
lbr_motivocancel varchar 255 √ NULL::character varying
lbr_docfiscal_uu varchar 36 √ NULL::character varying
posted bpchar 1 'N'::bpchar
processedon numeric 0 √ null
dateacct timestamp 29,6 √ null
datedoc timestamp 29,6 √ null
c_currency_id numeric 10 √ NULL::numeric
c_currency.c_currency_id ccurrency_lbrdocfiscal R
cof_consultaprotocolo bpchar 1 √ NULL::bpchar
deliveryviarule bpchar 1 √ null
cof_processing2 bpchar 1 √ NULL::bpchar
m_movement_id numeric 10 √ NULL::numeric
m_movement.m_movement_id mmovement_lbrdocfiscal R
iscancelled bpchar 1 √ 'N'::bpchar
infnfesupl_qrcode varchar 600 √ NULL::character varying
total_icmstotal_vfcpufdest numeric 0 √ (0)::numeric
total_icmstotal_vicmsufdest numeric 0 √ (0)::numeric
total_icmstotal_vicmsufremet numeric 0 √ (0)::numeric
cof_isindustrialization bpchar 1 √ 'N'::bpchar
cof_islabelprinted bpchar 1 √ 'N'::bpchar
ide_veraplic varchar 20 √ NULL::character varying
total_icmstotal_vfcp numeric 0 √ '0'::numeric
total_icmstotal_vfcpst numeric 0 √ '0'::numeric
total_icmstotal_vfcpstret numeric 0 √ '0'::numeric
total_icmstotal_vipidevol numeric 0 √ '0'::numeric
infnfesupl_urlchave varchar 85 √ NULL::character varying
pag_vtroco numeric 0 √ '0'::numeric
cof_dfe_id numeric 10 √ NULL::numeric
cof_dfe.cof_dfe_id cofdfe_lbrdocfiscal R
retirada_xnome varchar 60 √ NULL::character varying
retirada_cep varchar 9 √ NULL::character varying
retirada_cpais numeric 10 √ NULL::numeric
retirada_xpais varchar 60 √ NULL::character varying
retirada_fone varchar 14 √ NULL::character varying
retirada_email varchar 60 √ NULL::character varying
retirada_ie varchar 14 √ NULL::character varying
cof_pnretira_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofpnretira_lbrdocfiscal R
cof_pnlocationretira_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cofpnlocationretira_lbrdocfisc R
retira_city_id numeric 10 √ NULL::numeric
c_city.c_city_id retiracity_lbrdocfiscal R
retira_region_id numeric 10 √ NULL::numeric
c_region.c_region_id retiraregion_lbrdocfiscal R
retira_country_id numeric 10 √ '139'::numeric
c_country.c_country_id retiracountry_lbrdocfiscal R
entrega_xnome varchar 60 √ NULL::character varying
entrega_cep varchar 9 √ NULL::character varying
entrega_cpais numeric 10 √ NULL::numeric
entrega_xpais varchar 60 √ NULL::character varying
entrega_fone varchar 14 √ NULL::character varying
entrega_email varchar 60 √ NULL::character varying
entrega_ie varchar 14 √ NULL::character varying
entrega_country_id numeric 10 √ '139'::numeric
c_country.c_country_id entregacountry_lbrdocfiscal R
infresptec_cnpj varchar 18 √ NULL::character varying
infresptec_xcontato varchar 60 √ NULL::character varying
infresptec_email varchar 60 √ NULL::character varying
infresptec_fone varchar 14 √ NULL::character varying
infresptec_idcsrt varchar 2 √ null
infresptec_hashcsrt varchar 28 √ NULL::character varying
infprot_xmsg varchar 200 √ NULL::character varying
infprot_cmsg varchar 4 √ NULL::character varying
ide_indintermed bpchar 1 √ NULL::bpchar
infintermed_cnpj varchar 25 √ NULL::character varying
infintermed_idcadinttran varchar 60 √ NULL::character varying
imposto_fcpst numeric 0 √ '0'::numeric

Indexes

Constraint Name Type Sort Column(s)
lbr_docfiscal_key Primary key Asc lbr_docfiscal_id
cof_lbr_docfiscal_c_invoice_id Performance Asc c_invoice_id
cof_lbr_docfiscal_lbr_nfestatus Performance Asc lbr_nfestatus
lbr_docfiscal_uu_idx Must be unique Asc lbr_docfiscal_uu

Check Constraints

Constraint Name Constraint
lbr_docfiscal_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_lbr_isowndocument_check ((lbr_isowndocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_iscancelled_check ((iscancelled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_processing_check ((processing = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_cof_islabelprinted_check ((cof_islabelprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_lbr_isimport_check ((lbr_isimport = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_docfiscal_cof_isindustrialization_check ((cof_isindustrialization = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation