View idempiere11.adempiere.c_invoice_createfrom_v
C_Invoice_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
creditqty numeric 0  √  null Credit Quantity
qty numeric 0  √  null Quantity
multiplier numeric 0  √  null Type Multiplier (Credit = -1)
c_uom_id numeric 10  √  null Unit of Measure
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
m_inoutline_id numeric 0  √  null Line on Shipment or Receipt document
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
m_inout_id numeric 0  √  null Material Shipment Document
m_rma_id numeric 0  √  null Return Material Authorization
c_invoice_createfrom_v_id numeric 10  √  null C_Invoice_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
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