View idempiere11.adempiere.m_inout_createfrom_v
M_InOut_CreateFrom_v

 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
qty numeric 0  √  null Quantity
multiplier numeric 0  √  null Type Multiplier (Credit = -1)
c_uom_id numeric 10  √  null Unit of Measure
m_locator_id numeric 0  √  null Warehouse Locator
m_product_id numeric 0  √  null Product, Service, Item
c_charge_id numeric 0  √  null Additional document charges
vendorproductno varchar 2147483647  √  null Product Key of the Business Partner
line numeric 10  √  null Unique line for this document
c_orderline_id numeric 0  √  null Sales Order Line
c_invoiceline_id numeric 0  √  null Invoice Detail Line
m_rmaline_id numeric 0  √  null Return Material Authorization Line
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_order_id numeric 0  √  null Order
c_invoice_id numeric 0  √  null Invoice Identifier
m_rma_id numeric 0  √  null Return Material Authorization
m_inout_createfrom_v_id numeric 10  √  null M_InOut_CreateFrom_v
ad_client_id numeric 10  √  null Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
isactive bpchar 1  √  null The record is active in the system
upc varchar 2147483647  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_warehouse_id numeric 0  √  null Storage Warehouse and Service Point
issotrx bpchar 1  √  null This is a Sales Transaction
ad_table_id int4 10  √  null Database Table information

Analyzed at 2024-01-03 13:44 +0100