View idempiere9.adempiere.rv_c_invoice_productmonth
Invoice ProductMonth

 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
m_product_id numeric 10  √  null Product, Service, Item
dateinvoiced date 13  √  null Date printed on Invoice
linenetamt numeric 0  √  null Line Extended Amount (Quantity * Actual Price) without Freight and Charges
linelistamt numeric 0  √  null Line List Amount
linelimitamt numeric 0  √  null Line Limit Amount
linediscountamt numeric 0  √  null Line Discount Amount
linediscount numeric 0  √  null Line Discount as a percentage
lineoverlimitamt numeric 0  √  null Gross Margin
lineoverlimit numeric 0  √  null Gross margin %
qtyinvoiced numeric 0  √  null Invoiced Quantity
issotrx bpchar 1  √  null This is a Sales Transaction

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