View idempiere11.adempiere.rv_c_invoice_prodmonth
Invoice ProdMonth

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 Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
m_product_category_id numeric 10  √  null Category of a Product
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 2024-01-03 13:44 +0100