View idempiere9.adempiere.m_inout_lineconfirm_v
Confirmation Print View

 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
m_inoutlineconfirm_id numeric 10  √  null Material Shipment or Receipt Confirmation Line
m_inoutconfirm_id numeric 10  √  null Material Shipment or Receipt Confirmation
targetqty numeric 0  √  null Target Movement Quantity
confirmedqty numeric 0  √  null Confirmation of a received quantity
differenceqty numeric 0  √  null Difference Quantity
scrappedqty numeric 0  √  null The Quantity scrapped due to QA issues
description varchar 255  √  null Optional short description of the record
processed bpchar 1  √  null The document has been processed
m_inout_id numeric 10  √  null Material Shipment Document
m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
line numeric 10  √  null Unique line for this document
m_product_id numeric 10  √  null
movementqty numeric 0  √  null Quantity of a product moved.
uomsymbol varchar 10  √  null Symbol for a Unit of Measure
qtybackordered numeric 0  √  null Backordered Quantity
name varchar 255  √  null Alphanumeric identifier of the entity
shipdescription varchar 2147483647  √  null Ship Description
documentnote varchar 2000  √  null Additional information for a Document
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
productvalue varchar 40  √  null Key of the Product
m_locator_id numeric 10  √  null Warehouse Locator
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
x varchar 60  √  null X dimension, e.g., Aisle
y varchar 60  √  null Y dimension, e.g., Bin
z varchar 60  √  null Z dimension, e.g., Level
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_attributeset_id numeric 10  √  null Product Attribute Set
serno varchar 40  √  null Product Serial Number
lot varchar 40  √  null Lot number (alphanumeric)
m_lot_id numeric 10  √  null Product Lot Definition
guaranteedate timestamp 29,6  √  null Date when guarantee expires

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