c_charge

266 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_charge_id numeric 10 null
a_asset_addition.c_charge_id ccharge_aassetaddition R
ad_clientinfo.c_chargefreight_id cchargefreight_adclientinfo R
c_allocationline.c_charge_id ccharge_callocationline R
c_bankstatementline.c_charge_id ccharge_cbankstmtlime R
c_banktransfer.from_c_charge_id fromccharge_cbanktransfer R
c_banktransfer.to_c_charge_id toccharge_cbanktransfer R
c_cashline.c_charge_id ccharge_ccashline R
c_cashplanline.c_charge_id ccharge_ccashplanline R
c_charge_acct.c_charge_id cchrage_cchargeacct C
c_charge_trl.c_charge_id ccharge_cchargetrl R
c_commission.c_charge_id ccharge_ccommission R
c_doctype.cof_charge_id cofcharge_cdoctype R
c_dunning_line_v.c_charge_id Implied Constraint R
c_dunning_line_v.c_payment_c_charge_id Implied Constraint R
c_dunning_line_vt.c_charge_id Implied Constraint R
c_dunning_line_vt.c_payment_c_charge_id Implied Constraint R
c_invoice.c_charge_id ccharge_cinvoice R
c_invoice_header_v.c_charge_id Implied Constraint R
c_invoice_header_vt.c_charge_id Implied Constraint R
c_invoice_v.c_charge_id Implied Constraint R
c_invoice_v1.c_charge_id Implied Constraint R
c_invoicebatchline.c_charge_id ccharge_cinvoicebatchline R
c_invoiceline.c_charge_id ccharge_cinvoiceline R
c_order.c_charge_id ccharge_corder R
c_order_header_v.c_charge_id Implied Constraint R
c_order_header_vt.c_charge_id Implied Constraint R
c_orderline.c_charge_id ccharge_corderline R
c_payment.c_charge_id ccharge_cpayment R
c_payment_v.c_charge_id Implied Constraint R
c_paymenttransaction.c_charge_id ccharge_cpaymenttransaction R
c_payselection_check_v.c_payment_c_charge_id Implied Constraint R
c_payselection_check_vt.c_payment_c_charge_id Implied Constraint R
c_payselection_remittance_v.c_charge_id Implied Constraint R
c_payselection_remittance_vt.c_charge_id Implied Constraint R
cof_c_cnabconfig_line.c_charge_id ccharge_cofccnabconfigline R
cof_retentionconfig.c_charge_id ccharge_cofretentionconfig R
cof_rv_docfiscal.c_charge_id Implied Constraint R
cof_rv_itenspago.c_charge_id Implied Constraint R
dd_order.c_charge_id ccharge_ddorder R
dd_order_header_v.c_charge_id Implied Constraint R
dd_order_header_vt.c_charge_id Implied Constraint R
dd_orderline.c_charge_id ccharge_ddorderline R
hr_payroll.c_charge_id ccharge_hrpayroll R
hr_process.c_charge_id ccharge_hrprocess R
i_bankstatement.c_charge_id ccharge_ibankstmt N
i_inventory.c_charge_id ccharge_iinventory R
i_invoice.c_charge_id ccharge_iinvoice R
i_order.c_charge_id ccharge_iorder R
i_payment.c_charge_id ccharge_ipayment N
lbr_docfiscal_line.c_charge_id Implied Constraint R
m_inout.c_charge_id ccharge_minout R
m_inout_header_v.c_charge_id Implied Constraint R
m_inout_header_vt.c_charge_id Implied Constraint R
m_inout_line_v.c_charge_id Implied Constraint R
m_inout_line_vt.c_charge_id Implied Constraint R
m_inoutline.c_charge_id ccharge_minoutline R
m_inventoryline.c_charge_id ccharge_minventoryline R
m_movement.c_charge_id ccharge_mmovement R
m_promotionreward.c_charge_id ccharge_mpromotionreward R
m_requisitionline.c_charge_id ccharge_mrequisitionline R
m_rma_createfrom_v.c_charge_id Implied Constraint R
m_rmaline.c_charge_id ccharge_mrmaline R
rv_allocation.c_charge_id Implied Constraint R
rv_bpartneropen.c_charge_id Implied Constraint R
rv_c_invoice.c_charge_id Implied Constraint R
rv_c_invoiceline.c_charge_id Implied Constraint R
rv_c_invoicetax.c_charge_id Implied Constraint R
rv_cash_detail.c_charge_id Implied Constraint R
rv_commissionrundetail.c_charge_id Implied Constraint R
rv_commissionrundetail.c_invoice_c_charge_id Implied Constraint R
rv_commissionrundetail.c_invoiceline_c_charge_id Implied Constraint R
rv_commissionrundetail.c_orderline_c_charge_id Implied Constraint R
rv_inoutdetails.m_inout_c_charge_id Implied Constraint R
rv_inoutdetails.m_inoutline_c_charge_id Implied Constraint R
rv_m_requisition.c_charge_id Implied Constraint R
rv_openitem.c_charge_id Implied Constraint R
rv_orderdetail.c_order_c_charge_id Implied Constraint R
rv_orderdetail.c_orderline_c_charge_id Implied Constraint R
rv_payment.c_charge_id Implied Constraint R
rv_transaction.m_inoutline_c_charge_id Implied Constraint R
rv_transaction.m_inventoryline_c_charge_id Implied Constraint R
t_cashflow.c_charge_id Implied Constraint R
t_invoicegl_v.c_invoice_c_charge_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
chargeamt numeric 0 0
issametax bpchar 1 'N'::bpchar
issamecurrency bpchar 1 'N'::bpchar
c_taxcategory_id numeric 10 √ null
c_taxcategory.c_taxcategory_id ctaxcategory_ccharge R
istaxincluded bpchar 1 'N'::bpchar
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_ccharge R
c_chargetype_id numeric 10 √ null
c_chargetype.c_chargetype_id cchargetype_ccharge R
c_charge_uu varchar 36 √ NULL::character varying
lbr_productcategory_id numeric 10 √ null
lbr_productcategory.lbr_productcategory_id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
c_charge_pkey Primary key Asc c_charge_id
c_charge_name Must be unique Asc/Asc ad_client_id + name
c_charge_uu_idx Must be unique Asc c_charge_uu

Check Constraints

Constraint Name Constraint
c_charge_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_charge_issametax_check ((issametax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_charge_issamecurrency_check ((issamecurrency = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation