rv_commissionrundetail

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ null
created timestamp 29,6 √ null
createdby numeric 10 √ null
updated timestamp 29,6 √ null
updatedby numeric 10 √ null
c_commissionrun_id numeric 10 √ null
c_commissionrun.c_commissionrun_id Implied Constraint R
documentno varchar 30 √ null
description varchar 255 √ null
startdate timestamp 29,6 √ null
grandtotal numeric 0 √ null
processed bpchar 1 √ null
c_commission_id numeric 10 √ null
c_commission.c_commission_id Implied Constraint R
commission_bpartner_id numeric 10 √ null
c_commissionamt_id numeric 10 √ null
c_commissionamt.c_commissionamt_id Implied Constraint R
commissionconvertedamt numeric 0 √ null
commissionqty numeric 0 √ null
commissionamt numeric 0 √ null
c_commissiondetail_id numeric 10 √ null
c_commissiondetail.c_commissiondetail_id Implied Constraint R
reference varchar 60 √ null
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id Implied Constraint R
c_invoiceline_id numeric 10 √ null
c_invoiceline.c_invoiceline_id Implied Constraint R
info varchar 60 √ null
c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
actualamt numeric 0 √ null
convertedamt numeric 0 √ null
actualqty numeric 0 √ null
invoicedocumentno varchar 30 √ null
datedoc timestamp 29,6 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id Implied Constraint R
ad_user_id numeric 10 √ null
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id Implied Constraint R
c_commisionrun_processing bpchar 1 √ null
c_commission_ad_org_id numeric 10 √ null
c_commission_c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
c_commission_created timestamp 29,6 √ null
c_commission_createdby numeric 10 √ null
createfrom bpchar 1 √ null
datelastrun timestamp 29,6 √ null
c_commission_description varchar 255 √ null
docbasistype bpchar 1 √ null
frequencytype bpchar 1 √ null
c_commission_isactive bpchar 1 √ null
listdetails bpchar 1 √ null
c_commission_name varchar 60 √ null
c_commission_updated timestamp 29,6 √ null
c_commission_updatedby numeric 10 √ null
c_commissionamt_ad_org_id numeric 10 √ null
c_commissionline_id numeric 10 √ null
c_commissionline.c_commissionline_id Implied Constraint R
c_commmissionamt_created timestamp 29,6 √ null
c_commmissionamt_createdby numeric 10 √ null
c_commmissionamt_isactive bpchar 1 √ null
c_commmissionamt_updated timestamp 29,6 √ null
c_commssionamt_updatedby numeric 10 √ null
c_commissiondetail_ad_org_id numeric 10 √ null
c_commissiondetail_created timestamp 29,6 √ null
c_commissiondetail_createdby numeric 10 √ null
c_commossiondetail_isactive bpchar 1 √ null
c_commissiondetail_updated timestamp 29,6 √ null
c_commissiondetail_updatedby numeric 10 √ null
c_orderline_ad_org_id numeric 10 √ null
c_orderline_ad_orgtrx_id numeric 10 √ null
c_orderline_c_activity_id numeric 10 √ null
c_activity.c_activity_id Implied Constraint R
c_orderline_c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
c_orderline_c_bp_location_id numeric 10 √ null
c_orderline_c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id Implied Constraint R
c_orderline_c_charge_id numeric 10 √ null
c_charge.c_charge_id Implied Constraint R
c_orderline_c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
c_orderline_c_order_id numeric 10 √ null
c_order.c_order_id Implied Constraint R
c_orderline_c_project_id numeric 10 √ null
c_project.c_project_id Implied Constraint R
c_orderline_c_projectphase_id numeric 10 √ null
c_projectphase.c_projectphase_id Implied Constraint R
c_orderline_c_projecttask_id numeric 10 √ null
c_projecttask.c_projecttask_id Implied Constraint R
c_orderline_created timestamp 29,6 √ null
c_orderline_createdby numeric 10 √ null
c_orderline_c_tax_id numeric 10 √ null
c_tax.c_tax_id Implied Constraint R
c_orderline_c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
datedelivered timestamp 29,6 √ null
dateinvoiced timestamp 29,6 √ null
dateordered timestamp 29,6 √ null
datepromised timestamp 29,6 √ null
c_orderline_description varchar 255 √ null
discount numeric 0 √ null
freightamt numeric 0 √ null
c_orderline_isactive bpchar 1 √ null
isdescription bpchar 1 √ null
c_orderline_line numeric 10 √ null
c_orderline_linenetamt numeric 0 √ null
link_orderline_id numeric 10 √ null
c_orderline_m_asi_id numeric 10 √ null
m_promotion_id numeric 10 √ null
m_promotion.m_promotion_id Implied Constraint R
c_orderline_m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id Implied Constraint R
c_orderline_m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
c_orderline_priceactual numeric 0 √ null
pricecost numeric 0 √ null
c_orderline_priceentered numeric 0 √ null
c_orderline_pricelist numeric 0 √ null
c_orderline_processed bpchar 1 √ null
qtydelivered numeric 0 √ null
qtyentered numeric 0 √ null
c_orderline_qtyinvoiced numeric 0 √ null
qtylostsales numeric 0 √ null
qtyordered numeric 0 √ null
qtyreserved numeric 0 √ null
c_orderline_ref_orderline_id numeric 10 √ null
c_orderline_rramt numeric 0 √ null
c_orderline_rrstartsate timestamp 29,6 √ null
c_orderline_s_rassignment_id numeric 10 √ null
c_orderline_updated timestamp 29,6 √ null
c_orderline_updatedby numeric 10 √ null
c_orderline_user1_id numeric 10 √ null
c_orderline_user2_id numeric 10 √ null
c_inviceline_ad_org_id numeric 10 √ null
c_invoiceline_ad_orgtrx_id numeric 10 √ null
a_processed bpchar 1 √ null
c_invoiceline_c_activity_id numeric 10 √ null
c_activity.c_activity_id Implied Constraint R
c_invoiceline_c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id Implied Constraint R
c_invoiceline_c_charge_id numeric 10 √ null
c_charge.c_charge_id Implied Constraint R
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id Implied Constraint R
c_invoiceline_c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id Implied Constraint R
c_invoiceline_c_project_id numeric 10 √ null
c_project.c_project_id Implied Constraint R
c_invoiceline_c_projphase_id numeric 10 √ null
c_invoiceline_c_projecttask_id numeric 10 √ null
c_projecttask.c_projecttask_id Implied Constraint R
c_invoiceline_created timestamp 29,6 √ null
c_invoiceline_createdby numeric 10 √ null
c_invoiceline_c_tax_id numeric 10 √ null
c_tax.c_tax_id Implied Constraint R
c_invoiceline_c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
c_invoiceline_description varchar 255 √ null
c_invoiceline_isactive bpchar 1 √ null
c_invoiceline_isdescription bpchar 1 √ null
isprinted bpchar 1 √ null
c_invoiceline_line numeric 10 √ null
c_invoiceline_linenetamt numeric 0 √ null
c_invoiceline_linetotalamt numeric 0 √ null
c_invoiceline_m_asi_id numeric 10 √ null
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id Implied Constraint R
c_invoiceline_m_rmaline_id numeric 10 √ null
m_rmaline.m_rmaline_id Implied Constraint R
c_invoiceline_priceactual numeric 0 √ null
c_invoiceline_priceentered numeric 0 √ null
c_invoiceline_pricelimit numeric 0 √ null
c_invoiceline_pricelist numeric 0 √ null
c_invoiceline_processed bpchar 1 √ null
c_invoiceline_qtyentered numeric 0 √ null
c_invoiceline_qtyinvoiced numeric 0 √ null
c_invoiceline_ref_invline_id numeric 10 √ null
c_invoiceline_rramt numeric 0 √ null
c_invoiceline_rrstartdate timestamp 29,6 √ null
c_invoiceline_s_rassignment_id numeric 10 √ null
c_invoiceline_taxamt numeric 0 √ null
c_invoiceline_updated timestamp 29,6 √ null
c_invoiceline_updatedby numeric 10 √ null
c_invoiceline_user1_id numeric 10 √ null
c_invoiceline_user2_id numeric 10 √ null
c_order_ad_org_id numeric 10 √ null
c_order_ad_orgtrx_id numeric 10 √ null
c_order_ad_user_id numeric 10 √ null
amountrefunded numeric 22,2 √ null
amounttendered numeric 22,2 √ null
bill_bpartner_id numeric 10 √ null
bill_location_id numeric 10 √ null
bill_user_id numeric 10 √ null
c_activity_id numeric 10 √ null
c_activity.c_activity_id Implied Constraint R
c_order_c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id Implied Constraint R
c_cashline_id numeric 10 √ null
c_cashline.c_cashline_id Implied Constraint R
c_cashplanline_id numeric 10 √ null
c_cashplanline.c_cashplanline_id Implied Constraint R
c_charge_id numeric 10 √ null
c_charge.c_charge_id Implied Constraint R
c_conversiontype_id numeric 10 √ null
c_conversiontype.c_conversiontype_id Implied Constraint R
c_order_c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
c_doctypetarget_id numeric 10 √ null
c_order_chargeamt numeric 0 √ null
c_order_copyfrom bpchar 1 √ null
c_order_c_order_id numeric 10 √ null
c_order.c_order_id Implied Constraint R
c_order_c_payment_id numeric 10 √ null
c_payment.c_payment_id Implied Constraint R
c_order_paymentterm_id numeric 10 √ null
c_pos_id numeric 10 √ null
c_pos.c_pos_id Implied Constraint R
c_order_c_project_id numeric 10 √ null
c_project.c_project_id Implied Constraint R
c_order_created timestamp 29,6 √ null
c_order_createdby numeric 10 √ null
c_order_dateacct timestamp 29,6 √ null
c_order_dateprinted timestamp 29,6 √ null
c_order_datepromised timestamp 29,6 √ null
c_order_deliveryrule bpchar 1 √ null
c_order_deliveryviarule bpchar 1 √ null
c_order_description varchar 500 √ null
c_order_docaction bpchar 2 √ null
c_order_docstatus bpchar 2 √ null
c_order_documentno varchar 30 √ null
dropship_bpartner_id numeric 10 √ null
dropship_location_id numeric 10 √ null
dropship_user_id numeric 10 √ null
c_order_freightamt numeric 0 √ null
c_order_freightcostrule bpchar 1 √ null
c_order_grandtotal numeric 0 √ null
invoicerule bpchar 1 √ null
c_order_isactive bpchar 1 √ null
isapproved bpchar 1 √ null
iscreditapproved bpchar 1 √ null
isdelivered bpchar 1 √ null
isdiscountprinted bpchar 1 √ null
isdropship bpchar 1 √ null
isinvoiced bpchar 1 √ null
ispayschedulevalid bpchar 1 √ null
c_order_isprinted bpchar 1 √ null
c_order_isselected bpchar 1 √ null
c_order_isselfservice bpchar 1 √ null
c_order_issotrx bpchar 1 √ null
c_order_istaxincluded bpchar 1 √ null
istransferred bpchar 1 √ null
link_order_id numeric 10 √ null
m_freightcategory_id numeric 10 √ null
m_freightcategory.m_freightcategory_id Implied Constraint R
m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id Implied Constraint R
c_order_m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id Implied Constraint R
c_order_m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
ordertype varchar 510 √ null
pay_bpartner_id numeric 10 √ null
pay_location_id numeric 10 √ null
paymentrule bpchar 1 √ null
poreference varchar 20 √ null
c_order_posted bpchar 1 √ null
priorityrule bpchar 1 √ null
c_order_processed bpchar 1 √ null
c_order_processedon numeric 0 √ null
promotioncode varchar 30 √ null
c_order_ref_order_id numeric 10 √ null
c_order_sendemail bpchar 1 √ null
c_order_totallines numeric 0 √ null
c_order_user1_id numeric 10 √ null
c_order_user2_id numeric 10 √ null
c_invoice_ad_org_id numeric 10 √ null
c_invoice_ad_orgtrx_id numeric 10 √ null
c_invoice_c_activity_id numeric 10 √ null
c_activity.c_activity_id Implied Constraint R
c_invoice_c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id Implied Constraint R
c_invoice_c_charge_id numeric 10 √ null
c_charge.c_charge_id Implied Constraint R
c_invoice_c_conversiontype_id numeric 10 √ null
c_conversiontype.c_conversiontype_id Implied Constraint R
c_invoice_c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
c_invoice_c_doctypetarget_id numeric 10 √ null
c_dunninglevel_id numeric 10 √ null
c_dunninglevel.c_dunninglevel_id Implied Constraint R
c_invoice_chargeamt numeric 0 √ null
c_invoice_c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id Implied Constraint R
c_invoice_c_order_id numeric 10 √ null
c_order.c_order_id Implied Constraint R
c_invoice_c_payment_id numeric 10 √ null
c_payment.c_payment_id Implied Constraint R
c_invoice_c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id Implied Constraint R
c_invoice_c_project_id numeric 10 √ null
c_project.c_project_id Implied Constraint R
c_invoice_created timestamp 29,6 √ null
c_invoice_createdby numeric 10 √ null
c_invoice_dateacct timestamp 29,6 √ null
c_invoice_dateordered timestamp 29,6 √ null
c_invoice_dateprinted timestamp 29,6 √ null
c_invoice_description varchar 500 √ null
c_invoice_docaction bpchar 2 √ null
c_invoice_docstatus bpchar 2 √ null
c_invoice_dunninggrace timestamp 29,6 √ null
generateto bpchar 1 √ null
c_invoice_grandtotal numeric 0 √ null
invoicecollectiontype bpchar 1 √ null
c_invoice_isactive bpchar 1 √ null
c_invoice_isapproved bpchar 1 √ null
c_invoice_isdiscountprinted bpchar 1 √ null
c_invoice_isindispute bpchar 1 √ null
c_invoice_ispayschedulevalid bpchar 1 √ null
c_invoice_isprinted bpchar 1 √ null
c_invoice_isselfservice bpchar 1 √ null
c_invoice_issotrx bpchar 1 √ null
c_invoice_istaxincluded bpchar 1 √ null
c_invoice_istransferred bpchar 1 √ null
c_invoice_m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id Implied Constraint R
c_invoice_m_rma_id numeric 10 √ null
m_rma.m_rma_id Implied Constraint R
c_invoice_paymentrule bpchar 1 √ null
c_invoice_poreference varchar 20 √ null
c_invoice_posted bpchar 1 √ null
c_invoice_processedon numeric 0 √ null
c_invoice_processing bpchar 1 √ null
ref_invoice_id numeric 10 √ null
reversal_id numeric 10 √ null
c_invoice_salesrep_id numeric 10 √ null
c_invoice_sendemail bpchar 1 √ null
c_invoice_totallines numeric 0 √ null
c_invoice_updated timestamp 29,6 √ null
c_invoice_updatedby numeric 10 √ null
c_invoice_user1_id numeric 10 √ null
c_invoice_user2_id numeric 10 √ null
qtysubtract numeric 0 √ null
qtymultiplier numeric 0 √ null
amtsubtract numeric 0 √ null
amtmultiplier numeric 0 √ null
cof_convertedamtcalc numeric 0 √ null
cof_actualqtycalc numeric 0 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views