View idempiere9.adempiere.rv_pp_order_transactions
View Manufacturing Order Transactions

 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
updatedby numeric 10  √  null User who updated this records
updated timestamp 29,6  √  null Date this record was updated
documentno varchar 60  √  null Document sequence number of the document
m_product_id numeric 10  √  null Product, Service, Item
m_locator_id numeric 10  √  null Warehouse Locator
movementdate timestamp 29,6  √  null Date a product was moved in or out of inventory
pp_order_id numeric 10  √  null Manufacturing Order
qtydelivered numeric 0  √  null Delivered Quantity
qtyscrap numeric 0  √  null Scrap % Quantity for this componet
qtydeliveredline numeric 0  √  null Qty Delivered Line
qtyissueshouldbe numeric 0  √  null Qty Issue Should Be
qtyscrapline numeric 0  √  null Qty Scrap Line
qtyissuescrapshouldbe numeric 0  √  null Qty Issue Scrap Should Be
createdbyissue numeric 10  √  null
updatedbyissue numeric 10  √  null
qtytodeliver numeric 0  √  null Qty to deliver
differenceqty numeric 0  √  null Difference Quantity
issotrx bpchar 1  √  null
dateordered timestamp 29,6  √  null

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