View idempiere9.adempiere.rv_pp_order_workflow
View Order Workflow

 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
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
isactive bpchar 1  √  null The record is active in the system
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
pp_order_workflow_id numeric 10  √  null Manufacturing Order Workflow
name varchar 60  √  null Alphanumeric identifier of the entity
pp_order_id numeric 10  √  null Manufacturing Order
docstatus bpchar 2  √  null The current status of the document
value varchar 40  √  null Search key for the record in the format required - must be unique
s_resource_id numeric 10  √  null Resource
durationrequiered numeric 10  √  null Duration Requiered
durationreal numeric 10  √  null Duration Real
duration numeric 0  √  null Normal Duration in Duration Unit
movingtime numeric 10  √  null Moving Time
waitingtime numeric 10  √  null Workflow Simulation Waiting time
setuptime numeric 10  √  null Setup time before starting Production
queuingtime numeric 10  √  null Queue time is the time a job waits at a work center before begin handled.
qtydelivered numeric 0  √  null Delivered Quantity
qtyreject numeric 0  √  null Qty Reject
qtyscrap numeric 0  √  null Scrap % Quantity for this componet
datestartschedule timestamp 29,6  √  null Scheduled start date for this Order
datefinishschedule timestamp 29,6  √  null Scheduled Finish date for this Order
c_bpartner_id numeric 10  √  null Identifies a Business Partner
description varchar 255  √  null Optional short description of the record
ismilestone bpchar 1  √  null Is Milestone
issubcontracting bpchar 1  √  null Is Subcontracting

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