c_payment

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_payment_id numeric 10 null
b_buyerfunds.c_payment_id cpayment_bbuyerfunds R
b_sellerfunds.c_payment_id cpayment_bsellerfunds R
c_allocationline.c_payment_id cpayment_callocationline R
c_bankstatementline.c_payment_id cpayment_cbankstmtline R
c_cashline.c_payment_id cpayment_ccashline R
c_depositbatchline.c_payment_id cpayment_cdepositbatchline R
c_dunning_line_v.c_invoice_c_payment_id Implied Constraint R
c_dunning_line_v.c_payment_id Implied Constraint R
c_dunning_line_vt.c_invoice_c_payment_id Implied Constraint R
c_dunning_line_vt.c_payment_id Implied Constraint R
c_dunningrunline.c_payment_id cpayment_cdunningrunline N
c_invoice.c_payment_id cpayment_cinvoice R
c_invoice_header_v.c_payment_id Implied Constraint R
c_invoice_header_vt.c_payment_id Implied Constraint R
c_invoice_v.c_payment_id Implied Constraint R
c_invoicepayschedule.c_payment_id Implied Constraint R
c_order.c_payment_id cpayment_corder R
c_order_header_v.c_payment_id Implied Constraint R
c_order_header_vt.c_payment_id Implied Constraint R
c_payment.cof_payment_id cofpayment_cpayment R
c_payment.ref_payment_id refpayment_cpayment R
c_payment.reversal_id reversal_cpayment R
c_payment_v.c_payment_id Implied Constraint R
c_paymentallocate.c_payment_id cpayment_cpaymentallocate C
c_paymenttransaction.c_payment_id cpayment_cpaymenttransaction R
c_payselection_check_v.c_payment_id Implied Constraint R
c_payselection_check_vt.c_payment_id Implied Constraint R
c_payselection_remittance_v.c_payment_id Implied Constraint R
c_payselection_remittance_vt.c_payment_id Implied Constraint R
c_payselectioncheck.c_payment_id cpayment_cpayselectioncheck R
c_pospayment.c_payment_id cpayment_cpospayment R
c_recurring.c_payment_id cpayment_crecurring R
c_recurring_run.c_payment_id cpayment_crecurringrun R
cof_c_controlcheck.c_payment_id cpayment_cofccontrolcheck R
cof_c_controlcheck.cof_payment_id cofpayment_cofccontrolcheck R
cof_rv_checkallocate.c_payment_id Implied Constraint R
cof_rv_controlcheck.c_payment_id Implied Constraint R
cof_rv_itenspago.c_payment_id Implied Constraint R
cof_rv_mapa_pedido.c_payment_id Implied Constraint R
cof_rv_requestpartner.c_payment_id Implied Constraint R
i_bankstatement.c_payment_id cpayment_ibankstatement N
i_payment.c_payment_id cpayment_ipayment N
r_request.c_payment_id cpayment_rrequest R
r_request_v.c_payment_id Implied Constraint R
r_requestaction.c_payment_id cpayment_rrequestaction R
rv_allocation.c_payment_id Implied Constraint R
rv_bpartneropen.c_payment_id Implied Constraint R
rv_c_invoice.c_payment_id Implied Constraint R
rv_c_invoicetax.c_payment_id Implied Constraint R
rv_commissionrundetail.c_invoice_c_payment_id Implied Constraint R
rv_commissionrundetail.c_order_c_payment_id Implied Constraint R
rv_openitem.c_payment_id Implied Constraint R
rv_orderdetail.c_payment_id Implied Constraint R
rv_payment.c_payment_id Implied Constraint R
t_invoicegl_v.c_payment_id Implied Constraint R
test.c_payment_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cpayment R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
documentno varchar 30 null
datetrx timestamp 29,6 null
isreceipt bpchar 1 'Y'::bpchar
c_doctype_id numeric 10 null
c_doctype.c_doctype_id cdoctype_cpayment R
trxtype bpchar 1 null
c_bankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id cbankaccount_cpayment R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_cpayment R
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_cpayment R
c_bp_bankaccount_id numeric 10 √ null
c_bp_bankaccount.c_bp_bankaccount_id cbpbankacct_cpayment N
c_paymentbatch_id numeric 10 √ null
c_paymentbatch.c_paymentbatch_id cpaymentbatch_cpayment R
tendertype bpchar 1 null
creditcardtype bpchar 1 √ null
creditcardnumber varchar 20 √ null
creditcardvv varchar 4 √ null
creditcardexpmm numeric 10 √ null
creditcardexpyy numeric 10 √ null
micr varchar 20 √ null
routingno varchar 20 √ null
accountno varchar 20 √ null
checkno varchar 20 √ null
a_name varchar 60 √ null
a_street varchar 60 √ null
a_city varchar 60 √ null
a_state varchar 40 √ null
a_zip varchar 20 √ null
a_ident_dl varchar 20 √ null
a_ident_ssn varchar 20 √ null
a_email varchar 60 √ null
voiceauthcode varchar 20 √ null
orig_trxid varchar 20 √ null
ponum varchar 60 √ null
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_cpayment R
payamt numeric 0 0
discountamt numeric 0 √ 0
writeoffamt numeric 0 √ 0
taxamt numeric 0 √ 0
isapproved bpchar 1 'N'::bpchar
r_pnref varchar 20 √ null
r_result varchar 20 √ null
r_respmsg varchar 60 √ null
r_authcode varchar 20 √ null
r_avsaddr bpchar 1 √ null
r_avszip bpchar 1 √ null
r_info varchar 2000 √ null
processing bpchar 1 √ null
oprocessing bpchar 1 √ null
docstatus bpchar 2 null
docaction bpchar 2 null
isreconciled bpchar 1 'N'::bpchar
isallocated bpchar 1 'N'::bpchar
isonline bpchar 1 'N'::bpchar
processed bpchar 1 'N'::bpchar
posted bpchar 1 'N'::bpchar
isoverunderpayment bpchar 1 'Y'::bpchar
overunderamt numeric 0 √ 0
a_country varchar 40 √ null
c_project_id numeric 10 √ null
c_project.c_project_id cproject_cpayment R
isselfservice bpchar 1 'N'::bpchar
chargeamt numeric 0 √ 0
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_cpayment R
isdelayedcapture bpchar 1 'N'::bpchar
r_authcode_dc varchar 20 √ null
r_cvv2match bpchar 1 √ null
r_pnref_dc varchar 20 √ null
swipe varchar 80 √ null
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_cpayment R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_cpayment R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_cpayment R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser1_cpayment R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser2_cpayment R
c_conversiontype_id numeric 10 √ null
c_conversiontype.c_conversiontype_id cconversiontype_cpayment R
description varchar 255 √ null
dateacct timestamp 29,6 null
c_order_id numeric 10 √ null
c_order.c_order_id corder_cpayment R
isprepayment bpchar 1 'N'::bpchar
ref_payment_id numeric 10 √ null
c_payment.c_payment_id refpayment_cpayment R
reversal_id numeric 10 √ null
c_payment.c_payment_id reversal_cpayment R
c_cashbook_id numeric 10 √ null
c_cashbook.c_cashbook_id c_payment__c_cashbo_c_cashbook R
processedon numeric 0 √ null
c_payment_uu varchar 36 √ NULL::character varying
c_postendertype_id numeric 10 √ NULL::numeric
c_postendertype.c_postendertype_id cpostendertype_cpayment R
c_paymentprocessor_id numeric 10 √ NULL::numeric
c_paymentprocessor.c_paymentprocessor_id cpaymentprocessor_cpayment R
customerpaymentprofileid varchar 60 √ NULL::character varying
customerprofileid varchar 60 √ NULL::character varying
customeraddressid varchar 60 √ NULL::character varying
isvoided bpchar 1 'N'::bpchar
r_voidmsg varchar 255 √ NULL::character varying
c_depositbatch_id numeric 10 √ NULL::numeric
c_depositbatch.c_depositbatch_id cdepositbatch_cpayment R
c_invoicepayschedule_id numeric 10 √ null
c_invoicepayschedule.c_invoicepayschedule_id cinvoicepayschedule_cpayment R
cof_interestamt numeric 0 √ (0)::numeric
cof_penaltyamt numeric 0 √ (0)::numeric
cof_c_controlcheck_id numeric 10 √ null
cof_c_controlcheck.cof_c_controlcheck_id cofccontrolcheck_cpayment R
cof_creditdate timestamp 29,6 √ null
cof_cardtype varchar 2 √ 'CR'::character varying
cof_c_cardnetwork_id numeric 10 √ NULL::numeric
cof_c_cardnetwork.cof_c_cardnetwork_id cofccardnetwork_cpayment R
iban varchar 40 √ NULL::character varying
swiftcode varchar 20 √ NULL::character varying
cof_c_checkcustody_id numeric 10 √ NULL::numeric
cof_c_checkcustody.cof_c_checkcustody_id cofccheckcustody_cpayment R
cof_c_planofinanceiro_id numeric 10 √ NULL::numeric
cof_c_planofinanceiro.cof_c_planofinanceiro_id cofcplanofinanceiro_cpayment R
cof_processing3 bpchar 1 √ NULL::bpchar
cof_payment_id numeric 10 √ NULL::numeric
c_payment.c_payment_id cofpayment_cpayment R
currencyrate numeric 0 √ null
convertedamt numeric 0 √ null
isoverridecurrencyrate bpchar 1 'N'::bpchar
cof_tarifaboleto numeric 0 √ '0'::numeric
c_banktransfer_id numeric 10 √ NULL::numeric
c_banktransfer.c_banktransfer_id cbanktransfer_cpayment R

Indexes

Constraint Name Type Sort Column(s)
c_payment_pkey Primary key Asc c_payment_id
c_payment_bankaccount Performance Asc c_bankaccount_id
c_payment_bpartner Performance Asc c_bpartner_id
c_payment_uu_idx Must be unique Asc c_payment_uu
idxc_payment_proc_on Performance Asc/Asc/Asc/Asc posted + processed + processedon + ad_client_id

Check Constraints

Constraint Name Constraint
c_payment_isreconciled_check ((isreconciled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_payment_isreceipt_check ((isreceipt = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_payment_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_payment_isonline_check ((isonline = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_payment_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_payment_isvoided_check ((isvoided = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_payment_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_payment_isallocated_check ((isallocated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_payment_isoverridecurrencyrate_check ((isoverridecurrencyrate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation