lbr_eventonfe

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_org_id numeric 10 null
created timestamp 29,6 null
createdby numeric 10 null
datedoc timestamp 29,6 null
datetrx timestamp 29,6 √ null
description varchar 1000 null
docaction bpchar 2 'CO'::bpchar
docstatus varchar 2 'DR'::character varying
email varchar 60 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
lbr_eventonfe_id numeric 10 null
lbr_eventonfe.lbr_tpeventoaut_id lbrtpeventoaut_lbreventonfe R
processed bpchar 1 'N'::bpchar
seqno numeric 10 1
updated timestamp 29,6 null
updatedby numeric 10 null
lbr_cnpj varchar 30 √ NULL::character varying
lbr_cpf varchar 30 √ NULL::character varying
lbr_nfeprot varchar 60 √ NULL::character varying
lbr_nfestatus varchar 4 √ null
status varchar 255 √ null
documentno varchar 10 null
lbr_docfiscal_id numeric 10 √ null
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_lbreventonfe R
eventtype varchar 6 '110110'::character varying
lbr_eventonfe_uu varchar 36 √ NULL::character varying
cof_procprintcce bpchar 22 √ NULL::bpchar
cof_procprintcanc bpchar 22 √ NULL::bpchar
lbr_nfmodel varchar 2 √ '55'::character varying
cof_processing bpchar 1 √ 'N'::bpchar
cof_dfe_id numeric 10 √ null
cof_dfe.cof_dfe_id cofdfe_lbreventonfe R
isapproved bpchar 1 √ 'N'::bpchar
lbr_tpautor bpchar 1 √ NULL::bpchar
lbr_cpfautorizado varchar 30 √ NULL::character varying
lbr_cnpjautorizado varchar 30 √ NULL::character varying
lbr_tpautorizacao bpchar 1 √ NULL::bpchar
lbr_vibs numeric 0 √ '0'::numeric
lbr_vcbs numeric 0 √ '0'::numeric
lbr_qtde numeric 0 √ '0'::numeric
c_uom_id numeric 10 √ null
c_uom.c_uom_id cuom_lbreventonfe R
lbr_nitemdferef numeric 10 √ '0'::numeric
lbr_vcredibs numeric 0 √ '0'::numeric
lbr_vcredcbs numeric 0 √ '0'::numeric
lbr_indaceitacao bpchar 1 √ null
lbr_tpeventoaut_id numeric 10 √ null
lbr_eventonfe.lbr_eventonfe_id lbrtpeventoaut_lbreventonfe R
lbr_dpreventrega timestamp 29,6 √ null
lbr_nitem_id numeric 10 √ null
lbr_docfiscal_line.lbr_docfiscal_line_id lbrnitem_lbreventonfe R

Indexes

Constraint Name Type Sort Column(s)
lbr_cce_key Primary key Asc lbr_eventonfe_id
lbr_eventonfe_uu_idx Must be unique Asc lbr_eventonfe_uu

Check Constraints

Constraint Name Constraint
lbr_cce_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_cce_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_eventonfe_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation