c_paymenttransaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_city varchar 60 √ NULL::character varying
a_country varchar 40 √ NULL::character varying
a_email varchar 60 √ NULL::character varying
a_ident_dl varchar 20 √ NULL::character varying
a_ident_ssn varchar 20 √ NULL::character varying
a_name varchar 60 √ NULL::character varying
a_state varchar 40 √ NULL::character varying
a_street varchar 60 √ NULL::character varying
a_zip varchar 20 √ NULL::character varying
accountno varchar 20 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_orgtrx_id numeric 10 √ NULL::numeric
ad_org.ad_org_id adorgtrx_cpaymenttransaction R
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_cpaymenttransaction R
c_bankaccount_id numeric 10 √ NULL::numeric
c_bankaccount.c_bankaccount_id cbankaccount_cpaymenttransacti R
c_bp_bankaccount_id numeric 10 √ NULL::numeric
c_bp_bankaccount.c_bp_bankaccount_id cbpbankaccount_cpaymenttransac R
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_cpaymenttransaction R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_cpaymenttransaction R
c_cashbook_id numeric 10 √ NULL::numeric
c_cashbook.c_cashbook_id ccashbook_cpaymenttransaction R
c_charge_id numeric 10 √ NULL::numeric
c_charge.c_charge_id ccharge_cpaymenttransaction R
c_conversiontype_id numeric 10 √ NULL::numeric
c_conversiontype.c_conversiontype_id cconversiontype_cpaymenttransa R
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_cpaymenttransaction R
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id Implied Constraint R
c_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id cinvoice_cpaymenttransaction R
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_cpaymenttransaction R
c_payment_id numeric 10 √ NULL::numeric
c_payment.c_payment_id cpayment_cpaymenttransaction R
c_paymentbatch_id numeric 10 √ NULL::numeric
c_paymentbatch.c_paymentbatch_id cpaymentbatch_cpaymenttransact R
c_paymentprocessor_id numeric 10 √ NULL::numeric
c_paymentprocessor.c_paymentprocessor_id cpaymentprocessor_cpaymenttran R
c_paymenttransaction_id numeric 10 null
c_paymenttransaction.ref_paymenttransaction_id refpaymenttransaction_cpayment R
c_paymenttransaction_uu varchar 36 √ NULL::character varying
c_postendertype_id numeric 10 √ NULL::numeric
c_postendertype.c_postendertype_id cpostendertype_cpaymenttransac R
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id cproject_cpaymenttransaction R
checkno varchar 20 √ NULL::character varying
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
creditcardexpmm numeric 10 √ 1
creditcardexpyy numeric 10 √ 3
creditcardnumber varchar 20 √ NULL::character varying
creditcardtype bpchar 1 √ 'M'::bpchar
creditcardvv varchar 4 √ NULL::character varying
customeraddressid varchar 60 √ NULL::character varying
customerpaymentprofileid varchar 60 √ NULL::character varying
customerprofileid varchar 60 √ NULL::character varying
datetrx timestamp 29,6 null
description varchar 255 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
isapproved bpchar 1 'N'::bpchar
isdelayedcapture bpchar 1 null
isonline bpchar 1 null
isreceipt bpchar 1 null
isselfservice bpchar 1 null
isvoided bpchar 1 'N'::bpchar
micr varchar 20 √ NULL::character varying
orig_trxid varchar 20 √ NULL::character varying
payamt numeric 0 0
ponum varchar 60 √ NULL::character varying
r_authcode varchar 20 √ NULL::character varying
r_avsaddr bpchar 1 √ NULL::bpchar
r_avszip bpchar 1 √ NULL::bpchar
r_cvv2match bpchar 1 √ NULL::bpchar
r_info varchar 2000 √ NULL::character varying
r_pnref varchar 20 √ NULL::character varying
r_respmsg varchar 60 √ NULL::character varying
r_result varchar 20 √ NULL::character varying
r_voidmsg varchar 255 √ NULL::character varying
ref_paymenttransaction_id numeric 10 √ NULL::numeric
c_paymenttransaction.c_paymenttransaction_id refpaymenttransaction_cpayment R
routingno varchar 20 √ NULL::character varying
taxamt numeric 0 √ null
tendertype bpchar 1 'K'::bpchar
trxtype bpchar 1 'S'::bpchar
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_cpaymenttransaction R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_cpaymenttransaction R
voiceauthcode varchar 20 √ NULL::character varying
voidit bpchar 1 √ NULL::bpchar
processed bpchar 1 'N'::bpchar
iban varchar 40 √ NULL::character varying
swiftcode varchar 20 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_paymenttransaction_key Primary key Asc c_paymenttransaction_id
c_paymenttransaction_uu_idx Must be unique Asc c_paymenttransaction_uu

Check Constraints

Constraint Name Constraint
c_paymenttransaction_isreceipt_check ((isreceipt = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymenttransaction_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymenttransaction_isonline_check ((isonline = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymenttransaction_r_cvv2match_check ((r_cvv2match = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymenttransaction_isdelayedcapture_check ((isdelayedcapture = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymenttransaction_isvoided_check ((isvoided = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymenttransaction_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymenttransaction_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymenttransaction_isselfservice_check ((isselfservice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation