View idempiere9.adempiere.pp_order_header_v
PP_Order_Header_v

 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
ad_language varchar 6  √  null Language for this entity
pp_order_id numeric 10  √  null Manufacturing Order
documentno varchar 60  √  null Document sequence number of the document
docstatus bpchar 2  √  null The current status of the document
c_doctype_id numeric 10  √  null Document type or rules
org_location_id numeric 10  √  null Organization Location/Address
taxid varchar 20  √  null Tax Identification
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
warehouse_location_id numeric 10  √  null Warehouse Location/Address
documenttype varchar 60  √  null Document Type
documenttypenote varchar 2000  √  null Optional note of a document type
planner_id numeric 10  √  null Planner
salesrep_name varchar 60  √  null Sales Representative
datestart timestamp 29,6  √  null Date Start for this Order
datestartschedule timestamp 29,6  √  null Scheduled start date for this Order
floatafter numeric 0  √  null Float After
floatbefored numeric 0  √  null Float Befored
line numeric 10  √  null Unique line for this document
lot varchar 20  √  null Lot number (alphanumeric)
serno varchar 20  √  null Product Serial Number
description varchar 510  √  null Optional short description of the record
m_product_id numeric 10  √  null Product, Service, Item
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
c_uom_id numeric 10  √  null Unit of Measure
s_resource_id numeric 10  √  null Resource
pp_product_bom_id numeric 10  √  null BOM & Formula
ad_workflow_id numeric 10  √  null Workflow or combination of tasks
assay numeric 0  √  null Indicated the Quantity Assay to use into Quality Order
c_orderline_id numeric 10  √  null Sales Order Line
priorityrule bpchar 1  √  null Priority of a document
qtybatchsize numeric 0  √  null Qty Batch Size
qtybatchs numeric 0  √  null Qty Batchs
qtydelivered numeric 0  √  null Delivered Quantity
qtyentered numeric 0  √  null The Quantity Entered is based on the selected UoM
qtyordered numeric 0  √  null Ordered Quantity
dateconfirm timestamp 29,6  √  null Date Confirm of this Order
datedelivered timestamp 29,6  √  null Date when the product was delivered
datefinish timestamp 29,6  √  null Finish or (planned) completion date
datefinishschedule timestamp 29,6  √  null Scheduled Finish date for this Order
dateordered timestamp 29,6  √  null Date of Order
datepromised timestamp 29,6  √  null Date Order was promised
qtyreject numeric 0  √  null Qty Reject
qtyreserved numeric 0  √  null Reserved Quantity
qtyscrap numeric 0  √  null Scrap % Quantity for this componet
yield numeric 0  √  null The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_doctypetarget_id numeric 10  √  null Target document type for conversing documents
scheduletype varchar 1  √  null Type of schedule
isapproved bpchar 1  √  null Indicates if this document requires approval
docaction bpchar 2  √  null The targeted status of the document
posted bpchar 1  √  null Posting status
isprinted bpchar 1  √  null Indicates if this document / line is printed
ordertype varchar 1  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
logo_id numeric 10  √  null Logo

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