View idempiere9.adempiere.rv_commissionrundetail
Commission Run Detail

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
c_commissionrun_id numeric 10  √  null Commission Run or Process
documentno varchar 30  √  null Document sequence number of the document
description varchar 255  √  null Optional short description of the record
startdate timestamp 29,6  √  null First effective day (inclusive)
grandtotal numeric 0  √  null Total amount of document
processed bpchar 1  √  null The document has been processed
c_commission_id numeric 10  √  null Commission
commission_bpartner_id numeric 10  √  null Business Partner receiving the Commission
c_commissionamt_id numeric 10  √  null Generated Commission Amount
commissionconvertedamt numeric 0  √  null Commission calculation basis Converted Amount
commissionqty numeric 0  √  null Commission calculation basis Quantity
commissionamt numeric 0  √  null Commission Amount
c_commissiondetail_id numeric 10  √  null Supporting information for Commission Amounts
reference varchar 60  √  null Reference for this record
c_orderline_id numeric 10  √  null Sales Order Line
c_invoiceline_id numeric 10  √  null Invoice Detail Line
info varchar 60  √  null Information
c_currency_id numeric 10  √  null The Currency for this record
actualamt numeric 0  √  null The actual amount
convertedamt numeric 0  √  null Converted Amount
actualqty numeric 0  √  null The actual quantity
invoicedocumentno varchar 30  √  null Document Number of the Invoice
datedoc timestamp 29,6  √  null Date of the Document
m_product_id numeric 10  √  null Product, Service, Item
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_doctype_id numeric 10  √  null Document type or rules
c_commisionrun_processing bpchar 1  √  null c_commisionrun_processing
c_commission_ad_org_id numeric 10  √  null c_commission_ad_org_id
c_commission_c_currency_id numeric 10  √  null c_commission_c_currency_id
c_commission_created timestamp 29,6  √  null c_commission_created
c_commission_createdby numeric 10  √  null c_commission_createdby
createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
datelastrun timestamp 29,6  √  null Date the process was last run.
c_commission_description varchar 255  √  null c_commission_description
docbasistype bpchar 1  √  null Basis for the calculation the commission
frequencytype bpchar 1  √  null Frequency of event
c_commission_isactive bpchar 1  √  null c_commission_isactive
listdetails bpchar 1  √  null List document details
c_commission_name varchar 60  √  null c_commission_name
c_commission_updated timestamp 29,6  √  null c_commission_updated
c_commission_updatedby numeric 10  √  null c_commission_updatedby
c_commissionamt_ad_org_id numeric 10  √  null c_commissionamt_ad_org_id
c_commissionline_id numeric 10  √  null Commission Line
c_commmissionamt_created timestamp 29,6  √  null c_commmissionamt_created
c_commmissionamt_createdby numeric 10  √  null c_commmissionamt_createdby
c_commmissionamt_isactive bpchar 1  √  null c_commmissionamt_isactive
c_commmissionamt_updated timestamp 29,6  √  null c_commmissionamt_updated
c_commssionamt_updatedby numeric 10  √  null c_commssionamt_updatedby
c_commissiondetail_ad_org_id numeric 10  √  null c_commissiondetail_ad_org_id
c_commissiondetail_created timestamp 29,6  √  null c_commissiondetail_created
c_commissiondetail_createdby numeric 10  √  null c_commissiondetail_createdby
c_commossiondetail_isactive bpchar 1  √  null c_commossiondetail_isactive
c_commissiondetail_updated timestamp 29,6  √  null c_commissiondetail_updated
c_commissiondetail_updatedby numeric 10  √  null c_commissiondetail_updatedby
c_orderline_ad_org_id numeric 10  √  null c_orderline_ad_org_id
c_orderline_ad_orgtrx_id numeric 10  √  null c_orderline_ad_orgtrx_id
c_orderline_c_activity_id numeric 10  √  null c_orderline_c_activity_id
c_orderline_c_bpartner_id numeric 10  √  null c_orderline_c_bpartner_id
c_orderline_c_bp_location_id numeric 10  √  null C_OrderLine_C_BP_Location_ID
c_orderline_c_campaign_id numeric 10  √  null c_orderline_c_campaign_id
c_orderline_c_charge_id numeric 10  √  null c_orderline_c_charge_id
c_orderline_c_currency_id numeric 10  √  null c_orderline_c_currency_id
c_orderline_c_order_id numeric 10  √  null c_orderline_c_order_id
c_orderline_c_project_id numeric 10  √  null c_orderline_c_project_id
c_orderline_c_projectphase_id numeric 10  √  null c_orderline_c_projectphase_id
c_orderline_c_projecttask_id numeric 10  √  null c_orderline_c_projecttask_id
c_orderline_created timestamp 29,6  √  null c_orderline_created
c_orderline_createdby numeric 10  √  null c_orderline_createdby
c_orderline_c_tax_id numeric 10  √  null c_orderline_c_tax_id
c_orderline_c_uom_id numeric 10  √  null c_orderline_c_uom_id
datedelivered timestamp 29,6  √  null Date when the product was delivered
dateinvoiced timestamp 29,6  √  null Date printed on Invoice
dateordered timestamp 29,6  √  null Date of Order
datepromised timestamp 29,6  √  null Date Order was promised
c_orderline_description varchar 255  √  null c_orderline_description
discount numeric 0  √  null Discount in percent
freightamt numeric 0  √  null Freight Amount
c_orderline_isactive bpchar 1  √  null c_orderline_isactive
isdescription bpchar 1  √  null if true, the line is just description and no transaction
c_orderline_line numeric 10  √  null c_orderline_line
c_orderline_linenetamt numeric 0  √  null c_orderline_linenetamt
link_orderline_id numeric 10  √  null This field links a sales order line to the purchase order line that is generated from it.
c_orderline_m_asi_id numeric 10  √  null C_OrderLine_M_ASI_ID
m_promotion_id numeric 10  √  null Promotion
c_orderline_m_shipper_id numeric 10  √  null c_orderline_m_shipper_id
c_orderline_m_warehouse_id numeric 10  √  null c_orderline_m_warehouse_id
c_orderline_priceactual numeric 0  √  null c_orderline_priceactual
pricecost numeric 0  √  null Price per Unit of Measure including all indirect costs (Freight, etc.)
c_orderline_priceentered numeric 0  √  null c_orderline_priceentered
c_orderline_pricelist numeric 0  √  null c_orderline_pricelist
c_orderline_processed bpchar 1  √  null c_orderline_processed
qtydelivered numeric 0  √  null Delivered Quantity
qtyentered numeric 0  √  null The Quantity Entered is based on the selected UoM
c_orderline_qtyinvoiced numeric 0  √  null c_orderline_qtyinvoiced
qtylostsales numeric 0  √  null Quantity of potential sales
qtyordered numeric 0  √  null Ordered Quantity
qtyreserved numeric 0  √  null Reserved Quantity
c_orderline_ref_orderline_id numeric 10  √  null c_orderline_ref_orderline_id
c_orderline_rramt numeric 0  √  null c_orderline_rramt
c_orderline_rrstartsate timestamp 29,6  √  null c_orderline_rrstartsate
c_orderline_s_rassignment_id numeric 10  √  null C_OrderLine_S_RAssignment_ID
c_orderline_updated timestamp 29,6  √  null c_orderline_updated
c_orderline_updatedby numeric 10  √  null c_orderline_updatedby
c_orderline_user1_id numeric 10  √  null c_orderline_user1_id
c_orderline_user2_id numeric 10  √  null c_orderline_user2_id
c_inviceline_ad_org_id numeric 10  √  null c_inviceline_ad_org_id
c_invoiceline_ad_orgtrx_id numeric 10  √  null c_invoiceline_ad_orgtrx_id
a_processed bpchar 1  √  null Processed
c_invoiceline_c_activity_id numeric 10  √  null c_invoiceline_c_activity_id
c_invoiceline_c_campaign_id numeric 10  √  null c_invoiceline_c_campaign_id
c_invoiceline_c_charge_id numeric 10  √  null c_invoiceline_c_charge_id
c_invoice_id numeric 10  √  null Invoice Identifier
c_invoiceline_c_orderline_id numeric 10  √  null c_invoiceline_c_orderline_id
c_invoiceline_c_project_id numeric 10  √  null c_invoiceline_c_project_id
c_invoiceline_c_projphase_id numeric 10  √  null C_InvoiceLine_C_ProjPhase_ID
c_invoiceline_c_projecttask_id numeric 10  √  null c_invoiceline_c_projecttask_id
c_invoiceline_created timestamp 29,6  √  null c_invoiceline_created
c_invoiceline_createdby numeric 10  √  null c_invoiceline_createdby
c_invoiceline_c_tax_id numeric 10  √  null c_invoiceline_c_tax_id
c_invoiceline_c_uom_id numeric 10  √  null c_invoiceline_c_uom_id
c_invoiceline_description varchar 255  √  null c_invoiceline_description
c_invoiceline_isactive bpchar 1  √  null c_invoiceline_isactive
c_invoiceline_isdescription bpchar 1  √  null c_invoiceline_isdescription
isprinted bpchar 1  √  null Indicates if this document / line is printed
c_invoiceline_line numeric 10  √  null c_invoiceline_line
c_invoiceline_linenetamt numeric 0  √  null c_invoiceline_linenetamt
c_invoiceline_linetotalamt numeric 0  √  null c_invoiceline_linetotalamt
c_invoiceline_m_asi_id numeric 10  √  null C_InvoiceLine_M_ASI_ID
m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_invoiceline_m_rmaline_id numeric 10  √  null c_invoiceline_m_rmaline_id
c_invoiceline_priceactual numeric 0  √  null c_invoiceline_priceactual
c_invoiceline_priceentered numeric 0  √  null c_invoiceline_priceentered
c_invoiceline_pricelimit numeric 0  √  null c_invoiceline_pricelimit
c_invoiceline_pricelist numeric 0  √  null c_invoiceline_pricelist
c_invoiceline_processed bpchar 1  √  null c_invoiceline_processed
c_invoiceline_qtyentered numeric 0  √  null c_invoiceline_qtyentered
c_invoiceline_qtyinvoiced numeric 0  √  null c_invoiceline_qtyinvoiced
c_invoiceline_ref_invline_id numeric 10  √  null C_InvoiceLine_Ref_InvLine_ID
c_invoiceline_rramt numeric 0  √  null c_invoiceline_rramt
c_invoiceline_rrstartdate timestamp 29,6  √  null c_invoiceline_rrstartdate
c_invoiceline_s_rassignment_id numeric 10  √  null C_InvoiceLine_S_RAssignment_ID
c_invoiceline_taxamt numeric 0  √  null c_invoiceline_taxamt
c_invoiceline_updated timestamp 29,6  √  null c_invoiceline_updated
c_invoiceline_updatedby numeric 10  √  null c_invoiceline_updatedby
c_invoiceline_user1_id numeric 10  √  null c_invoiceline_user1_id
c_invoiceline_user2_id numeric 10  √  null c_invoiceline_user2_id
c_order_ad_org_id numeric 10  √  null c_order_ad_org_id
c_order_ad_orgtrx_id numeric 10  √  null c_order_ad_orgtrx_id
c_order_ad_user_id numeric 10  √  null c_order_ad_user_id
amountrefunded numeric 22,2  √  null AmountRefunded
amounttendered numeric 22,2  √  null AmountTendered
bill_bpartner_id numeric 10  √  null Business Partner to be invoiced
bill_location_id numeric 10  √  null Business Partner Location for invoicing
bill_user_id numeric 10  √  null Business Partner Contact for invoicing
c_activity_id numeric 10  √  null Business Activity
c_order_c_campaign_id numeric 10  √  null c_order_c_campaign_id
c_cashline_id numeric 10  √  null Cash Journal Line
c_cashplanline_id numeric 10  √  null Cash Plan Line
c_charge_id numeric 10  √  null Additional document charges
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_order_c_currency_id numeric 10  √  null c_order_c_currency_id
c_doctypetarget_id numeric 10  √  null Target document type for conversing documents
c_order_chargeamt numeric 0  √  null c_order_chargeamt
c_order_copyfrom bpchar 1  √  null c_order_copyfrom
c_order_c_order_id numeric 10  √  null c_order_c_order_id
c_order_c_payment_id numeric 10  √  null c_order_c_payment_id
c_order_paymentterm_id numeric 10  √  null c_order_paymentterm_id
c_pos_id numeric 10  √  null Point of Sales Terminal
c_order_c_project_id numeric 10  √  null c_order_c_project_id
c_order_created timestamp 29,6  √  null c_order_created
c_order_createdby numeric 10  √  null c_order_createdby
c_order_dateacct timestamp 29,6  √  null c_order_dateacct
c_order_dateprinted timestamp 29,6  √  null c_order_dateprinted
c_order_datepromised timestamp 29,6  √  null c_order_datepromised
c_order_deliveryrule bpchar 1  √  null c_order_deliveryrule
c_order_deliveryviarule bpchar 1  √  null c_order_deliveryviarule
c_order_description varchar 255  √  null c_order_description
c_order_docaction bpchar 2  √  null c_order_docaction
c_order_docstatus bpchar 2  √  null c_order_docstatus
c_order_documentno varchar 30  √  null c_order_documentno
dropship_bpartner_id numeric 10  √  null Business Partner to ship to
dropship_location_id numeric 10  √  null Business Partner Location for shipping to
dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
c_order_freightamt numeric 0  √  null c_order_freightamt
c_order_freightcostrule bpchar 1  √  null c_order_freightcostrule
c_order_grandtotal numeric 0  √  null c_order_grandtotal
invoicerule bpchar 1  √  null Frequency and method of invoicing
c_order_isactive bpchar 1  √  null c_order_isactive
isapproved bpchar 1  √  null Indicates if this document requires approval
iscreditapproved bpchar 1  √  null Credit has been approved
isdelivered bpchar 1  √  null Delivered
isdiscountprinted bpchar 1  √  null Print Discount on Invoice and Order
isdropship bpchar 1  √  null Drop Shipments are sent directly to the Drop Shipment Location
isinvoiced bpchar 1  √  null Is this invoiced?
ispayschedulevalid bpchar 1  √  null Is the Payment Schedule is valid
c_order_isprinted bpchar 1  √  null c_order_isprinted
c_order_isselected bpchar 1  √  null c_order_isselected
c_order_isselfservice bpchar 1  √  null c_order_isselfservice
c_order_issotrx bpchar 1  √  null c_order_issotrx
c_order_istaxincluded bpchar 1  √  null c_order_istaxincluded
istransferred bpchar 1  √  null Transferred to General Ledger (i.e. accounted)
link_order_id numeric 10  √  null This field links a sales order to the purchase order that is generated from it.
m_freightcategory_id numeric 10  √  null Category of the Freight
m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_order_m_shipper_id numeric 10  √  null c_order_m_shipper_id
c_order_m_warehouse_id numeric 10  √  null c_order_m_warehouse_id
ordertype varchar 510  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
pay_bpartner_id numeric 10  √  null Business Partner responsible for the payment
pay_location_id numeric 10  √  null Location of the Business Partner responsible for the payment
paymentrule bpchar 1  √  null How you pay the invoice
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order_posted bpchar 1  √  null c_order_posted
priorityrule bpchar 1  √  null Priority of a document
c_order_processed bpchar 1  √  null c_order_processed
c_order_processedon numeric 0  √  null c_order_processedon
promotioncode varchar 30  √  null User entered promotion code at sales time
c_order_ref_order_id numeric 10  √  null c_order_ref_order_id
c_order_sendemail bpchar 1  √  null c_order_sendemail
c_order_totallines numeric 0  √  null c_order_totallines
c_order_user1_id numeric 10  √  null c_order_user1_id
c_order_user2_id numeric 10  √  null c_order_user2_id
c_invoice_ad_org_id numeric 10  √  null C_Invoice_AD_Org_ID
c_invoice_ad_orgtrx_id numeric 10  √  null c_invoice_ad_orgtrx_id
c_invoice_c_activity_id numeric 10  √  null c_invoice_c_activity_id
c_invoice_c_campaign_id numeric 10  √  null c_invoice_c_campaign_id
c_invoice_c_charge_id numeric 10  √  null c_invoice_c_charge_id
c_invoice_c_conversiontype_id numeric 10  √  null c_invoice_c_conversiontype_id
c_invoice_c_currency_id numeric 10  √  null c_invoice_c_currency_id
c_invoice_c_doctypetarget_id numeric 10  √  null c_invoice_c_doctypetarget_id
c_dunninglevel_id numeric 10  √  null Dunning Level
c_invoice_chargeamt numeric 0  √  null c_invoice_chargeamt
c_invoice_c_invoice_id numeric 10  √  null c_invoice_c_invoice_id
c_invoice_c_order_id numeric 10  √  null c_invoice_c_order_id
c_invoice_c_payment_id numeric 10  √  null c_invoice_c_payment_id
c_invoice_c_paymentterm_id numeric 10  √  null c_invoice_c_paymentterm_id
c_invoice_c_project_id numeric 10  √  null c_invoice_c_project_id
c_invoice_created timestamp 29,6  √  null c_invoice_created
c_invoice_createdby numeric 10  √  null c_invoice_createdby
c_invoice_dateacct timestamp 29,6  √  null c_invoice_dateacct
c_invoice_dateordered timestamp 29,6  √  null c_invoice_dateordered
c_invoice_dateprinted timestamp 29,6  √  null c_invoice_dateprinted
c_invoice_description varchar 255  √  null c_invoice_description
c_invoice_docaction bpchar 2  √  null c_invoice_docaction
c_invoice_docstatus bpchar 2  √  null c_invoice_docstatus
c_invoice_dunninggrace timestamp 29,6  √  null c_invoice_dunninggrace
generateto bpchar 1  √  null Generate To
c_invoice_grandtotal numeric 0  √  null c_invoice_grandtotal
invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_invoice_isactive bpchar 1  √  null c_invoice_isactive
c_invoice_isapproved bpchar 1  √  null c_invoice_isapproved
c_invoice_isdiscountprinted bpchar 1  √  null c_invoice_isdiscountprinted
c_invoice_isindispute bpchar 1  √  null c_invoice_isindispute
c_invoice_ispayschedulevalid bpchar 1  √  null c_invoice_ispayschedulevalid
c_invoice_isprinted bpchar 1  √  null c_invoice_isprinted
c_invoice_isselfservice bpchar 1  √  null c_invoice_isselfservice
c_invoice_issotrx bpchar 1  √  null c_invoice_issotrx
c_invoice_istaxincluded bpchar 1  √  null c_invoice_istaxincluded
c_invoice_istransferred bpchar 1  √  null c_invoice_istransferred
c_invoice_m_pricelist_id numeric 10  √  null c_invoice_m_pricelist_id
c_invoice_m_rma_id numeric 10  √  null c_invoice_m_rma_id
c_invoice_paymentrule bpchar 1  √  null c_invoice_paymentrule
c_invoice_poreference varchar 20  √  null c_invoice_poreference
c_invoice_posted bpchar 1  √  null c_invoice_posted
c_invoice_processedon numeric 0  √  null c_invoice_processedon
c_invoice_processing bpchar 1  √  null c_invoice_processing
ref_invoice_id numeric 10  √  null Referenced Invoice
reversal_id numeric 10  √  null ID of document reversal
c_invoice_salesrep_id numeric 10  √  null c_invoice_salesrep_id
c_invoice_sendemail bpchar 1  √  null c_invoice_sendemail
c_invoice_totallines numeric 0  √  null c_invoice_totallines
c_invoice_updated timestamp 29,6  √  null c_invoice_updated
c_invoice_updatedby numeric 10  √  null c_invoice_updatedby
c_invoice_user1_id numeric 10  √  null c_invoice_user1_id
c_invoice_user2_id numeric 10  √  null c_invoice_user2_id

Analyzed at 2021-12-25 14:43 +0100