View idempiere9.adempiere.rv_pp_operation_activity
View Operation_Activity

 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_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
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

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