Table idempiere11.adempiere.dd_orderline
Distribution Order Line

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
line numeric 10 Unique line for this document
qtyintransit numeric 0  √  null Qty In Transit
qtyordered numeric 0 Ordered Quantity
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_ddorderline R
Product, Service, Item
dd_order_id numeric 10
dd_order.dd_order_id ddorder_ddorderline R
Distribution Order
c_charge_id numeric 10  √  null
c_charge.c_charge_id ccharge_ddorderline R
Additional document charges
c_project_id numeric 10  √  null
c_project.c_project_id cproject_ddorderline R
Financial Project
c_uom_id numeric 10
c_uom.c_uom_id cuom_ddorderline R
Unit of Measure
confirmedqty numeric 0  √  null Confirmation of a received quantity
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
dd_orderline_id numeric 10
m_movementline.dd_orderline_id ddorderline_mmovementline R
pp_mrp.dd_orderline_id ddorderline_ppmrp R
Distribution Order Line
datedelivered timestamp 29,6  √  null Date when the product was delivered
dateordered timestamp 29,6  √  null Date of Order
datepromised timestamp 29,6  √  null Date Order was promised
description varchar 255  √  null Optional short description of the record
freightamt numeric 0  √  null Freight Amount
isactive bpchar 1 'Y'::bpchar The record is active in the system
isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
isinvoiced bpchar 1 Is this invoiced?
linenetamt numeric 0  √  null Line Extended Amount (Quantity * Actual Price) without Freight and Charges
m_attributesetinstanceto_id numeric 10  √  null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstanceto_ddorde R
Target Product Attribute Set Instance
m_attributesetinstance_id numeric 10  √  null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_ddorderl R
Product Attribute Set Instance
m_locatorto_id numeric 10
m_locator.m_locator_id mlocatorto_ddorderline R
Location inventory is moved to
m_locator_id numeric 10
m_locator.m_locator_id mlocator_ddorderline R
Warehouse Locator
pickedqty numeric 0  √  null Picked Quantity
processed bpchar 1 The document has been processed
qtydelivered numeric 0  √  null Delivered Quantity
qtyentered numeric 0 The Quantity Entered is based on the selected UoM
qtyreserved numeric 0  √  null Reserved Quantity
scrappedqty numeric 0  √  (0)::numeric The Quantity scrapped due to QA issues
targetqty numeric 0  √  null Target Movement Quantity
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
user1_id numeric 10  √  null
c_elementvalue.c_elementvalue_id user1_ddorderline R
User defined list element #1
ad_client_id numeric 10 Tenant for this installation.
user2_id numeric 10  √  null
c_elementvalue.c_elementvalue_id user2_ddorderline R
User defined list element #2
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_ddorderline R
Performing or initiating organization
ad_org_id numeric 10 Organizational entity within tenant
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_ddorderline R
Business Activity
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_ddorderline R
Marketing Campaign
m_shipper_id numeric 10  √  NULL::numeric
m_shipper.m_shipper_id mshipper_ddorderline R
Method or manner of product delivery
dd_orderline_uu varchar 36  √  NULL::character varying DD_OrderLine_UU

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

Indexes:
Column(s) Type Sort Constraint Name
dd_orderline_id Primary key Asc dd_orderline_key
dd_orderline_uu Must be unique Asc dd_orderline_uu_idx


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.