View idempiere9.adempiere.pp_order_node_v
Manufacturing Order Node

 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
name varchar 60  √  null Alphanumeric identifier of the entity
c_bpartner_id numeric 10  √  null Identifies a Business Partner
cost numeric 0  √  null Cost information
datefinish timestamp 29,6  √  null Finish or (planned) completion date
datefinishschedule timestamp 29,6  √  null Scheduled Finish date for this Order
datestart timestamp 29,6  √  null Date Start for this Order
datestartschedule timestamp 29,6  √  null Scheduled start date for this Order
description varchar 255  √  null Optional short description of the record
docaction bpchar 2  √  null The targeted status of the document
docstatus bpchar 2  √  null The current status of the document
duration numeric 10  √  null Normal Duration in Duration Unit
durationreal numeric 10  √  null Duration Real
durationrequiered numeric 10  √  null Duration Requiered
help varchar 2000  √  null Comment or Hint
ismilestone bpchar 1  √  null Is Milestone
issubcontracting bpchar 1  √  null Is Subcontracting
movingtime numeric 10  √  null Moving Time
overlapunits numeric 10  √  null Overlap Units are number of units that must be completed before they are moved the next activity
pp_order_id numeric 10  √  null Manufacturing Order
pp_order_workflow_id numeric 10  √  null Manufacturing Order Workflow
pp_order_node_id numeric 10  √  null Workflow Node (activity), step or process
priority numeric 10  √  null Indicates if this request is of a high, medium or low priority.
qtydelivered numeric 0  √  null Delivered Quantity
qtyrequiered numeric 0  √  null Qty Requiered
qtyscrap numeric 0  √  null Scrap % Quantity for this componet
queuingtime numeric 10  √  null Queue time is the time a job waits at a work center before begin handled.
s_resource_id numeric 10  √  null Resource
setuptime numeric 10  √  null Setup time before starting Production
setuptimereal numeric 10  √  null Setup Time Real
unitscycles numeric 10  √  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.
validfrom timestamp 29,6  √  null Valid from including this date (first day)
validto timestamp 29,6  √  null Valid to including this date (last day)
value varchar 40  √  null Search key for the record in the format required - must be unique
waitingtime numeric 10  √  null Workflow Simulation Waiting time
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

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