View idempiere9.adempiere.pp_order_workflow_header_v
Manufacturing Order Workflow Header

 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
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
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
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
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
name varchar 60  √  null Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
author varchar 20  √  null Author/Creator of the Entity
cost numeric 0  √  null Cost information
documentno varchar 32  √  null Document sequence number of the document
duration numeric 10  √  null Normal Duration in Duration Unit
durationunit bpchar 1  √  null Unit of Duration
version numeric 10  √  null Version of the table definition
validfrom timestamp 29,6  √  null Valid from including this date (first day)
validto timestamp 29,6  √  null Valid to including this date (last day)
movingtime numeric 10  √  null Moving Time
overlapunits numeric 0  √  null Overlap Units are number of units that must be completed before they are moved the next activity
publishstatus bpchar 1  √  null Status of Publication
queuingtime numeric 10  √  null Queue time is the time a job waits at a work center before begin handled.
setuptime numeric 10  √  null Setup time before starting Production
unitscycles numeric 0  √  null The Units by Cycles are defined for process type Flow Repetitive Dedicated and indicated the product to be manufactured on a production line for duration unit.
waitingtime numeric 10  √  null Workflow Simulation Waiting time
workflowtype bpchar 1  √  null Type of Workflow
workingtime numeric 10  √  null Workflow Simulation Execution Time
yield numeric 10  √  null The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
logo_id numeric 10  √  null Logo

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