cof_conciliacaocartao

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_conciliacaocartao_id numeric 10 null
cof_conciliacaocartao_uu varchar 36 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
documentno varchar 30 √ null
cof_operadorascartao_id numeric 10 √ NULL::numeric
cof_operadorascartao.cof_operadorascartao_id cofoperadorascartao_cofconcili R
cof_dataimportacao timestamp 29,6 null
isreconciled bpchar 1 'N'::bpchar
c_payment_id numeric 10 √ null
c_payment.c_payment_id cpayment_cofconciliacaocartao R
cof_foundpayments varchar 60 √ NULL::character varying
c_bankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id cbankaccount_cofconciliacaocar R
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id cdoctype_cofconciliacaocartao R
datetrx timestamp 29,6 null
dateacct timestamp 29,6 null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_cofconciliacaocartao R
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_cofconciliacaocartao R
c_order_id numeric 10 √ null
c_order.c_order_id corder_cofconciliacaocartao R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_cofconciliacaocartao R
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_cofconciliacaocartao R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_cofconciliacaocartao R
c_invoicepayschedule_id numeric 10 √ null
c_invoicepayschedule.c_invoicepayschedule_id cinvoicepayschedule_cofconcili R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_cofconciliacaocartao R
cof_c_planofinanceiro_id numeric 10 √ null
cof_c_planofinanceiro.cof_c_planofinanceiro_id cofcplanofinanceiro_cofconcili R
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_cofconciliacaocartao R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_cofconciliacaocartao R
payamt numeric 0 √ null
c_currency_id numeric 10 √ NULL::numeric
c_currency.c_currency_id ccurrency_cofconciliacaocartao R
tendertype bpchar 1 NULL::bpchar
cof_codigoautorizacao varchar 60 √ NULL::character varying
cof_repasse varchar 60 √ NULL::character varying
cof_gravame varchar 60 √ NULL::character varying
cof_cnpjinstituicao varchar 60 √ NULL::character varying
cof_nomeinstituicao varchar 60 √ NULL::character varying
cof_estabelecimento varchar 60 √ NULL::character varying
cof_datapagamento timestamp 29,6 √ null
cof_datalancamento timestamp 29,6 √ null
cof_dataautorizacaovenda timestamp 29,6 √ null
cof_formapagamento varchar 60 √ NULL::character varying
cof_numeroparcela varchar 60 √ NULL::character varying
cof_quantidadeparcela varchar 60 √ NULL::character varying
cof_numerocartao varchar 60 √ NULL::character varying
cof_nsu varchar 60 √ NULL::character varying
cof_tid varchar 60 √ NULL::character varying
cof_valorbruto numeric 0 √ null
cof_valordescontado numeric 0 √ null
cof_valorliquido numeric 0 √ '0'::numeric
cof_valorcobrado numeric 0 √ null
cof_valorpendente numeric 0 √ null
cof_recebimentoautomatico varchar 60 √ NULL::character varying
cof_canalvenda varchar 60 √ NULL::character varying
cof_tipocaptura varchar 60 √ NULL::character varying
cof_resumooperacao varchar 60 √ NULL::character varying
cof_taxas numeric 0 √ null
cof_tarifa numeric 0 √ null
cof_codigovenda varchar 60 √ NULL::character varying
cof_numeromaquina varchar 60 √ NULL::character varying
cof_status varchar 60 √ NULL::character varying
cof_produto varchar 60 √ NULL::character varying
cof_bandeira varchar 60 √ NULL::character varying
cof_desconto numeric 0 √ null
cof_tipolancamento varchar 60 √ NULL::character varying
cof_descricao varchar 250 √ NULL::character varying
cof_banco varchar 60 √ NULL::character varying
cof_agencia varchar 60 √ NULL::character varying
cof_conta varchar 60 √ NULL::character varying
cof_tipotransacao bpchar 1 √ NULL::bpchar
cof_tarifapagamento_id numeric 10 √ NULL::numeric
c_payment.c_payment_id coftarifapagamento_cofconcilia R
cof_creditdate timestamp 29,6 √ null
cof_isconciliando bpchar 1 'N'::bpchar
cof_isvendaconciliada bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_conciliacaocartao_key Primary key Asc cof_conciliacaocartao_id
cof_conciliacaocartao_c_invoice_id_idx Performance Asc c_invoice_id
cof_conciliacaocartao_c_order_id_idx Performance Asc c_order_id
cof_conciliacaocartao_uu_idx Must be unique Asc cof_conciliacaocartao_uu

Check Constraints

Constraint Name Constraint
cof_conciliacaocartao_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_conciliacaocartao_isreconciled_check ((isreconciled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_conciliacaocartao_cof_isvendaconciliada_check ((cof_isvendaconciliada = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_conciliacaocartao_cof_isconciliando_check ((cof_isconciliando = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation