View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.common.invoice/C Invoice ProdWeek

Contents

C_Invoice_ProdWeek

This table contains the following columns:

Name Nullable Data Type Description
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
M_Product_Category_ID YVARCHAR2(32)A classification of items based on similar characteristics or attributes.
DateInvoiced YDATEThe time listed on the invoice.
LineNetAmt YNUMBERThe final amount of a specified line, based only on quantities and prices.
LineListAmt YNUMBERnull
LineLimitAmt YNUMBERnull
LineDiscountAmt YNUMBERLine Discount Amount
LineDiscount YNUMBERLine Discount as a percentage
LineOverLimitAmt YNUMBERnull
LineOverLimit YNUMBERnull
QtyInvoiced YNUMBERThe total number of a product included in an invoice to a business partner.

Columns

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Product Category

Foreign key column to M_Product_Category table, (column: M_Product_Category_ID)

top

Invoice Date

The Date Invoice indicates the date printed on the invoice.

top

Line Net Amount

Indicates the line net amount based on the quantity and the actual price. Any additional charges or freight are not included.

top

Line List Amount

top

Line Limit Amount

top

Line Discount

Indicates the discount for this line as an amount.

top

Line Discount %

The Line Discount Percent indicates the discount for this line as a percentage.

top

Gross Margin

top

Gross margin %

top

Invoiced Quantity

The Invoiced Quantity indicates the quantity of a product that have been invoiced.

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.common.invoice/C_Invoice_ProdWeek"

This page has been accessed 626 times. This page was last modified on 2 July 2011, at 20:47. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.