Tables
Relationships
Constraints
Anomalies
Columns
View
idempiere11
.
adempiere
.
rv_c_invoice_productmonth
Invoice ProductMonth
Generated by
Quality Systems & Solutions
Related columns
Constraints
Comments
Legend
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_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 2024-01-03 13:44 +0100