Table idempiere11.adempiere.c_order
Order

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_order_id numeric 10
b_buyerfunds
b_sellerfunds
c_allocationline
c_invoice
c_opportunity
c_order
c_order
c_order
c_orderlandedcost
c_orderline
c_orderpayschedule
c_ordertax
c_payment
c_paymenttransaction
c_pospayment
c_projectline
c_projectline
c_projectphase
c_recurring
c_recurring_run
c_rfq
c_rfqresponse
dd_order
dd_order
i_order
m_inout
m_rma
m_shippingtransaction
pp_mrp
r_request
r_requestaction
Order
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10
ad_org
Organizational entity within tenant
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
documentno varchar 30 Document sequence number of the document
docstatus bpchar 2 The current status of the document
docaction bpchar 2 The targeted status of the document
processing bpchar 1  √  null Process Now
processed bpchar 1 'N'::bpchar The document has been processed
c_doctype_id numeric 10
c_doctype
Document type or rules
c_doctypetarget_id numeric 10
c_doctype
Target document type for conversing documents
description varchar 255  √  null Optional short description of the record
isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
iscreditapproved bpchar 1 'N'::bpchar Credit has been approved
isdelivered bpchar 1 'N'::bpchar Delivered
isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
isselected bpchar 1 'N'::bpchar Selected
salesrep_id numeric 10  √  null
ad_user
Sales Representative or Company Agent
dateordered timestamp 29,6 Date of Order
datepromised timestamp 29,6  √  null Date Order was promised
dateprinted timestamp 29,6  √  null Date the document was printed.
dateacct timestamp 29,6 Accounting Date
c_bpartner_id numeric 10
c_bpartner
Identifies a Business Partner
c_bpartner_location_id numeric 10
c_bpartner_location
Identifies the (ship to) address for this Business Partner
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_currency_id numeric 10
c_currency
The Currency for this record
paymentrule bpchar 1 How you pay the invoice
c_paymentterm_id numeric 10
c_paymentterm
The terms of Payment (timing, discount)
invoicerule bpchar 1 Frequency and method of invoicing
deliveryrule bpchar 1 Defines the timing of Delivery
freightcostrule bpchar 1 Method for charging Freight
freightamt numeric 0  √  0 Freight Amount
deliveryviarule bpchar 1 How the order will be delivered
m_shipper_id numeric 10  √  null
m_shipper
Method or manner of product delivery
c_charge_id numeric 10  √  null
c_charge
Additional document charges
chargeamt numeric 0  √  0 Charge Amount
priorityrule bpchar 1 Priority of a document
totallines numeric 0 0 Total of all document lines
grandtotal numeric 0 0 Total amount of document
m_warehouse_id numeric 10
m_warehouse
Storage Warehouse and Service Point
m_pricelist_id numeric 10
m_pricelist
Unique identifier of a Price List
istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_campaign_id numeric 10  √  null
c_campaign
Marketing Campaign
c_project_id numeric 10  √  null
c_project
Financial Project
c_activity_id numeric 10  √  null
c_activity
Business Activity
posted bpchar 1 'N'::bpchar Posting status
c_payment_id numeric 10  √  null
c_payment
Payment identifier
c_cashline_id numeric 10  √  null
c_cashline
Cash Journal Line
sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
ad_user_id numeric 10  √  null
ad_user
User within the system - Internal or Business Partner Contact
copyfrom bpchar 1  √  null Copy From Record
isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
ad_orgtrx_id numeric 10  √  null
ad_org
Performing or initiating organization
user1_id numeric 10  √  null
c_elementvalue
User defined list element #1
user2_id numeric 10  √  null
c_elementvalue
User defined list element #2
c_conversiontype_id numeric 10  √  null
c_conversiontype
Currency Conversion Rate Type
bill_bpartner_id numeric 10  √  null
c_bpartner
Business Partner to be invoiced
bill_location_id numeric 10  √  null
c_bpartner_location
Business Partner Location for invoicing
bill_user_id numeric 10  √  null
ad_user
Business Partner Contact for invoicing
pay_bpartner_id numeric 10  √  null
c_bpartner
Business Partner responsible for the payment
pay_location_id numeric 10  √  null
c_bpartner_location
Location of the Business Partner responsible for the payment
ref_order_id numeric 10  √  null
c_order
Reference to corresponding Sales/Purchase Order
isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
volume numeric 0  √  null Volume of a product
weight numeric 0  √  null Weight of a product
ordertype varchar 510  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
c_pos_id numeric 10  √  null
c_pos
Point of Sales Terminal
amounttendered numeric 22,2  √  null Amount Tendered
amountrefunded numeric 22,2  √  null Amount Refunded
link_order_id numeric 10  √  null
c_order
This field links a sales order to the purchase order that is generated from it.
m_freightcategory_id numeric 10  √  NULL::numeric
m_freightcategory
Category of the Freight
dropship_bpartner_id numeric 10  √  null
c_bpartner
Business Partner to ship to
dropship_location_id numeric 10  √  null
c_bpartner_location
Business Partner Location for shipping to
dropship_user_id numeric 10  √  null
ad_user
Business Partner Contact for drop shipment
promotioncode varchar 30  √  null User entered promotion code at sales time
c_ordersource_id numeric 10  √  null
c_ordersource
Order Source
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
c_cashplanline_id numeric 10  √  NULL::numeric
c_cashplanline
Cash Plan Line
c_order_uu varchar 36  √  NULL::character varying C_Order_UU
shippingrateinquiry bpchar 1  √  NULL::bpchar Rate Inquiry
ispriviledgedrate bpchar 1 'N'::bpchar Privileged Rate
c_opportunity_id numeric 10  √  NULL::numeric
c_opportunity
Sales Opportunity
quotationorder_id numeric 10  √  NULL::numeric
c_order
Quotation used for generating this order

Table contained 8 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort
c_order_id Primary key Asc
c_bpartner_id Performance Asc
documentno + c_doctype_id + c_bpartner_id Must be unique Asc/Asc/Asc
processed + ad_client_id Performance Asc/Asc
c_order_uu Must be unique Asc
posted + processed + processedon + ad_client_id Performance Asc/Asc/Asc/Asc


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.