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

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

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

Index

Contents

C_InvoiceLine_V2

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_InvoiceLine_ID NVARCHAR2(32)A statement displaying one item or charge in an invoice.
C_Invoice_ID NVARCHAR2(32)A document listing products, quantities and prices, payment terms, etc.
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
C_BPartner_ID NVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
C_BP_Group_ID NVARCHAR2(32)A classification of business partners based on defined similarities.
M_Product_ID YVARCHAR2(32)An item produced by a process.
M_Product_Category_ID YVARCHAR2(32)A classification of items based on similar characteristics or attributes.
DateInvoiced NDATEThe time listed on the invoice.
DateAcct NDATEThe date this transaction is recorded for in the general ledger.
QtyInvoiced YNUMBERThe total number of a product included in an invoice to a business partner.
PriceList NNUMBERThe official price of a product in a specified currency.
PriceActual NNUMBERThe price that will be paid for a specified item.
PriceLimit NNUMBERThe lowest price a specified item may be sold for.
Discount YNUMBERThe proportional discount given to an item, without respect to any previously defined discounts.
Margin YNUMBERMargin for a product as a percentage
LineNetAmt YNUMBERThe final amount of a specified line, based only on quantities and prices.
LineListAmt YNUMBERnull
LineLimitAmt YNUMBERnull
LineDiscountAmt YNUMBERLine Discount Amount
LineOverLimitAmt YNUMBERnull

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

Invoice Line

Foreign key column to C_InvoiceLine table, (column: C_InvoiceLine_ID)

top

Invoice

Foreign key column to C_Invoice table, (column: C_Invoice_ID)

top

Sales Representative

Foreign key column to AD_User table, (column: AD_User_ID)


Reference Table AD_User SalesRep With the following where clause:

 
EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND bp.IsSalesRep='Y')


top

Business Partner

Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top

Business Partner Category

Foreign key column to C_BP_Group table, (column: C_BP_Group_ID)

top

Product

Foreign key column to M_Product table, (column: M_Product_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

Accounting Date

The date this transaction is recorded on in the general ledger. This date also indicates which accounting period within the fiscal year this transaction will be part of.

top

Invoiced Quantity

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

top

List Price

The List Price is the official price stated by the selected pricelist and the currency of the document.

top

Unit Price

The actual price indicates the price for a product in source currency.

top

Price Limit

The Price Limit indicates the lowest price for a product stated in the Price List Currency.

top

Discount %

The Discount indicates the discount applied or taken as a percentage.

top

Margin %

The Margin indicates the margin for this product as a percentage of the limit price and selling price.

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

Gross Margin

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.common.invoice/C_InvoiceLine_V2"

This page has been accessed 2,275 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.