View source | Discuss this page | Page history | Printable version   

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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.invoice

Index

Contents

C_Invoice_CustomerProdQtr

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
C_BPartner_ID NVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
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

Business Partner

Foreign key column to C_BPartner table, (column: C_BPartner_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_CustomerProdQtr"

This page has been accessed 1,829 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.