View idempiere11.adempiere.pp_order_bom_header_v
Manufacturing Order BOM Head *** Templete ***

 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 Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
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 Before
line numeric 10  √  null Unique line for this document
lot varchar 20  √  null Lot number (alphanumeric)
serno varchar 20  √  null Product Serial Number
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 Batch
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 component
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
bomtype bpchar 1  √  null Type of BOM
bomuse bpchar 1  √  null The use of the Bill of Material
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_product_id numeric 10  √  null Product, Service, Item
name varchar 60  √  null Alphanumeric identifier of the entity
revision varchar 10  √  null Revision
validfrom timestamp 29,6  √  null Valid from including this date (first day)
validto timestamp 29,6  √  null Valid to including this date (last day)
logo_id numeric 10  √  null Logo

Analyzed at 2024-01-03 13:44 +0100