cof_titulo

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_coftitulo R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_coftitulo R
cof_titulo_aceite varchar 1 √ null
cof_titulo_id numeric 10 null
cof_rv_gencnab.cof_titulo_id Implied Constraint R
cof_rv_itenspago.cof_titulo_id Implied Constraint R
cof_rv_titulos.cof_titulo_id Implied Constraint R
rv_openitem.cof_titulo_id Implied Constraint R
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_coftitulo R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_coftitulo R
cof_tituloacrescimo numeric 0 √ (0)::numeric
cof_titulo_contabancaria varchar 100 √ NULL::character varying
cof_titulo_datadocumento timestamp 29,6 √ null
cof_titulo_datavencimento timestamp 29,6 √ null
cof_titulo_deducao numeric 0 √ (0)::numeric
cof_titulo_desconto numeric 0 √ (0)::numeric
cof_titulo_dignossonumero varchar 200 √ NULL::character varying
cof_titulo_moramulta numeric 0 √ (0)::numeric
cof_titulo_nossonumero varchar 22 √ NULL::character varying
cof_titulo_numdoc varchar 22 √ NULL::character varying
cof_titulo_tipodocumento varchar 22 √ NULL::character varying
cof_titulo_tipomoeda varchar 3 √ NULL::character varying
cof_titulo_valor numeric 0 √ (0)::numeric
c_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id cinvoice_coftitulo R
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_coftitulo R
c_orderpayschedule_id numeric 10 √ NULL::numeric
c_orderpayschedule.c_orderpayschedule_id corderpayschedule_coftitulo R
c_invoicepayschedule_id numeric 10 √ NULL::numeric
c_invoicepayschedule.c_invoicepayschedule_id cinvoicepayschedule_coftitulo R
lbr_docfiscal_id numeric 10 √ null
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_coftitulo N
cof_processed bpchar 1 √ 'N'::bpchar
cof_processed2 bpchar 1 √ 'N'::bpchar
ispaid bpchar 1 √ 'N'::bpchar
cof_recordhistory varchar 2000 √ null
cof_borderoname varchar 60 √ NULL::character varying
cof_payscheduleno varchar 20 √ NULL::character varying
cof_titulo_datadesconto timestamp 29,6 √ null
cof_titulo_datapagamento timestamp 29,6 √ null
cof_titulo_vdescontoefetivado numeric 0 √ (0)::numeric
cof_titulo_vacrescimoefetiv numeric 0 √ (0)::numeric
cof_titulo_valorabatimento numeric 0 √ (0)::numeric
cof_titulo_valorjuros numeric 0 √ (0)::numeric
cof_titulo_vmultaefetivada numeric 0 √ (0)::numeric
cof_titulo_valorcredito numeric 0 √ (0)::numeric
cof_titulo_valortarifas numeric 0 √ (0)::numeric
cof_titulo_canalpagamento varchar 2 √ NULL::character varying
cof_titulo_datadebito timestamp 29,6 √ null
cof_titulo_formapagamento bpchar 1 √ NULL::bpchar
cof_conta_numagencia varchar 10 √ NULL::character varying
cof_conta_cbanco varchar 10 √ NULL::character varying
cof_conta_carteira varchar 4 √ NULL::character varying
cof_conta_modalidade varchar 3 √ NULL::character varying
cof_conta_numconta varchar 10 √ NULL::character varying
cof_conta_titular varchar 100 √ NULL::character varying
cof_c_bankintegration_id numeric 10 √ NULL::numeric
cof_c_bankintegration.cof_c_bankintegration_id cofcbankintegration_coftitulo R
c_bank_id numeric 10 √ NULL::numeric
c_bank.c_bank_id cbank_coftitulo C
c_bankaccount_id numeric 10 √ NULL::numeric
c_bankaccount.c_bankaccount_id cbankaccount_coftitulo R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_coftitulo R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_coftitulo R
lbr_bptypebr varchar 2 √ NULL::character varying
cof_sacado_contabancaria varchar 10 √ NULL::character varying
cof_sacado_cpfcnpj varchar 22 √ NULL::character varying
cof_sacado_nome varchar 250 √ null
cof_sacado_telefone varchar 22 √ null
cof_sacado_bairro varchar 50 √ null
cof_sacado_cep varchar 8 √ NULL::character varying
cof_sacado_complemento varchar 22 √ NULL::character varying
cof_sacado_localidade varchar 22 √ NULL::character varying
cof_sacado_logradouro varchar 40 √ NULL::character varying
cof_sacado_numero varchar 15 √ NULL::character varying
cof_sacado_pais varchar 15 √ NULL::character varying
cof_sacado_uf varchar 2 √ NULL::character varying
cof_cedente_contabancaria varchar 10 √ null
cof_cedente_cpfcnpj varchar 22 √ NULL::character varying
org_location_id numeric 10 √ null
c_location.c_location_id orglocation_coftitulo R
cof_cedente_nome varchar 120 √ null
cof_cedente_telefone varchar 22 √ null
cof_cedente_bairro varchar 60 √ null
cof_cedente_cep varchar 8 √ NULL::character varying
cof_cedente_complemento varchar 22 √ NULL::character varying
cof_cedente_logradouro varchar 40 √ NULL::character varying
cof_cedente_numero varchar 15 √ NULL::character varying
cof_cedente_pais varchar 15 √ NULL::character varying
cof_boleto_codigobarras varchar 44 √ null
cof_boleto_dataprocess timestamp 29,6 √ null
cof_boleto_instrucao1 varchar 60 √ NULL::character varying
cof_boleto_instrucao2 varchar 60 √ NULL::character varying
cof_boleto_instrucao3 varchar 60 √ NULL::character varying
cof_boleto_instrucao4 varchar 60 √ NULL::character varying
cof_boleto_instrucao5 varchar 60 √ NULL::character varying
cof_boleto_instrucao6 varchar 60 √ NULL::character varying
cof_boleto_instrucao7 varchar 60 √ NULL::character varying
cof_boleto_instrucao8 varchar 60 √ NULL::character varying
cof_boleto_instrucaosacado varchar 60 √ NULL::character varying
cof_boleto_linhadigitavel varchar 60 √ NULL::character varying
cof_boleto_localpagamento varchar 200 √ NULL::character varying
cof_boleto_textoextra varchar 200 √ NULL::character varying
processed bpchar 1 √ NULL::bpchar
cof_cedente_uf varchar 2 √ NULL::character varying
cof_cedente_bpartner_id numeric 10 √ null
ad_org.ad_org_id cofcedentebpartner_coftitulo R
cof_conta_digagencia varchar 10 √ NULL::character varying
cof_conta_digconta varchar 10 √ NULL::character varying
cof_sacado_cidade varchar 60 √ NULL::character varying
cof_cedente_cidade varchar 60 √ NULL::character varying
cof_customnumber varchar 40 √ NULL::character varying
cof_c_bankoccurrence_id numeric 10 √ NULL::numeric
cof_c_bankoccurrence.cof_c_bankoccurrence_id cofcbankoccurrence_coftitulo R
cof_titulo_uu varchar 36 √ NULL::character varying
cof_billtype varchar 2 √ NULL::character varying
cof_cedente_complementocep varchar 3 √ null
cof_sacado_complementocep varchar 3 √ NULL::character varying
isvalid bpchar 1 √ 'Y'::bpchar
lbr_nfestatus varchar 3 √ NULL::character varying
cof_billfoldtype varchar 2 √ NULL::character varying
parameterdefault varchar 255 √ NULL::character varying
cof_requiresparameter bpchar 1 √ 'N'::bpchar
cof_cedente_contabancariadig varchar 3 √ NULL::character varying
cof_emailsent bpchar 1 √ 'N'::bpchar
cof_processing bpchar 1 √ NULL::bpchar
cof_emailsend bpchar 1 √ 'N'::bpchar
cof_titulo_multapercentual numeric 0 √ '0'::numeric
cof_titulo_multadata timestamp 29,6 √ null
cof_titulo_diasmulta numeric 10 √ '0'::numeric

Indexes

Constraint Name Type Sort Column(s)
cof_titulo_key Primary key Asc cof_titulo_id
cof_titulo_c_invoice_id Performance Asc c_invoice_id
cof_titulo_c_invoicepayschedule_id Performance Asc c_invoicepayschedule_id
cof_titulo_uu_idx Must be unique Asc cof_titulo_uu
titulo_nossonumero Must be unique Asc/Asc/Asc cof_titulo_nossonumero + ad_org_id + cof_c_bankintegration_id

Check Constraints

Constraint Name Constraint
cof_titulo_cof_processed_check ((cof_processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_titulo_ispaid_check ((ispaid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_titulo_cof_processed2_check ((cof_processed2 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_titulo_isvalid_check ((isvalid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_titulo_cof_emailsent_check ((cof_emailsent = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_titulo_cof_requiresparameter_check ((cof_requiresparameter = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_titulo_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_titulo_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_titulo_cof_emailsend_check ((cof_emailsend = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation