Table idempiere9.adempiere.c_order

Generated by
Quality Systems & Solutions
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
c_order_id numeric 10
c_invoice.c_order_id corder_cinvoice R
c_order.link_order_id linkorder_corder R
c_order.quotationorder_id quotationorder_corder R
c_order.ref_order_id corder_ref R
c_payment.c_order_id corder_cpayment R
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
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 Document type or rules
c_doctypetarget_id numeric 10 Target document type for conversing documents
description varchar 255  √  null Optional short description of the record
isapproved bpchar 1 'Y'::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 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 Identifies a Business Partner
c_bpartner_location_id numeric 10 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.c_currency_id ccurrency_corder R
The Currency for this record
paymentrule bpchar 1 How you pay the invoice
c_paymentterm_id numeric 10 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 Method or manner of product delivery
c_charge_id numeric 10  √  null 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 Storage Warehouse and Service Point
m_pricelist_id numeric 10 Unique identifier of a Price List
istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
posted bpchar 1 'N'::bpchar Posting status
c_payment_id numeric 10  √  null
c_payment.c_payment_id cpayment_corder R
Payment identifier
c_cashline_id numeric 10  √  null Cash Journal Line
sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
ad_user_id numeric 10  √  null 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 Performing or initiating organization
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
c_conversiontype_id numeric 10  √  null
c_conversiontype.c_conversiontype_id cconversiontype_corder R
Currency Conversion Rate Type
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
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
ref_order_id numeric 10  √  null
c_order.c_order_id corder_ref R
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 Point of Sales Terminal
amounttendered numeric 22,2  √  null AmountTendered
amountrefunded numeric 22,2  √  null AmountRefunded
link_order_id numeric 10  √  null
c_order.c_order_id linkorder_corder R
This field links a sales order to the purchase order that is generated from it.
m_freightcategory_id numeric 10  √  NULL::numeric Category of the Freight
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
promotioncode varchar 30  √  null User entered promotion code at sales time
c_ordersource_id numeric 10  √  null 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 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 Priviledged Rate
c_opportunity_id numeric 10  √  NULL::numeric Sales Opportunity
quotationorder_id numeric 10  √  NULL::numeric
c_order.c_order_id quotationorder_corder R
Quotation used for generating this order

Table contained 8 rows at 2021-12-25 14:47 +0100

Column(s) Type Sort Constraint Name
c_order_id Primary key Asc c_order_pkey
c_bpartner_id Performance Asc c_order_bpartner
documentno + c_doctype_id + c_bpartner_id Must be unique Asc/Asc/Asc c_order_documentno
processed + ad_client_id Performance Asc/Asc c_order_processed
c_order_uu Must be unique Asc c_order_uu_idx
posted + processed + processedon + ad_client_id Performance Asc/Asc/Asc/Asc idxc_order_proc_on

Close relationships  within of separation: