View idempiere9.adempiere.rv_c_invoice_vendormonth
Invoice VendorMonth

 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
c_bpartner_id numeric 10  √  null Identifies a Business Partner
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

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