View idempiere9.adempiere.rv_dd_orderdetail
Distribution Order & Line View

 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
dd_order_id numeric 10  √  null Distribution Order
c_order_id numeric 10  √  null Order
docstatus bpchar 2  √  null The current status of the document
docaction bpchar 2  √  null The targeted status of the document
c_doctype_id numeric 10  √  null Document type or rules
isapproved bpchar 1  √  null Indicates if this document requires approval
salesrep_id numeric 10  √  null Sales Representative or Company Agent
isdropship bpchar 1  √  null Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bp_group_id numeric 10  √  null Business Partner Group
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
issotrx bpchar 1  √  null This is a Sales Transaction
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
dd_orderline_id numeric 10  √  null Distribution Order Line
dateordered timestamp 29,6  √  null Date of Order
datepromised timestamp 29,6  √  null Date Order was promised
m_product_id numeric 10  √  null Product, Service, Item
m_locator_id numeric 10  √  null Warehouse Locator
m_locatorto_id numeric 10  √  null Location inventory is moved to
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
productattribute varchar 2147483647  √  null Product Attribute Instance Description
m_attributesetinstanceto_id numeric 10  √  null Target Product Attribute Set Instance
productattributeto varchar 2147483647  √  null Product Attribute Instance Description
m_attributeset_id numeric 10  √  null Product Attribute Set
m_lot_id numeric 10  √  null Product Lot Definition
guaranteedate timestamp 29,6  √  null Date when guarantee expires
lot varchar 40  √  null Lot number (alphanumeric)
serno varchar 40  √  null Product Serial Number
c_uom_id numeric 10  √  null Unit of Measure
qtyentered numeric 0  √  null The Quantity Entered is based on the selected UoM
qtyordered numeric 0  √  null Ordered Quantity
qtyreserved numeric 0  √  null Reserved Quantity
qtydelivered numeric 0  √  null Delivered Quantity
confirmedqty numeric 0  √  null Confirmation of a received quantity
qtyintransit numeric 0  √  null Qty In Transit
targetqty numeric 0  √  null Target Movement Quantity
qtytodeliver numeric 0  √  null Qty to deliver
description varchar 255  √  null Optional short description of the record

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