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/3.0/Developers Guide/Database Model/org.openbravo.model.common.invoice/C Invoice CustomerVendQtr

Contents

C_Invoice_CustomerVendQtr

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.
Vendor_ID NVARCHAR2(32)A business partner who sells products or services.
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

Vendor

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


Reference Table C_BPartner Vendors With the following where clause:

 
C_BPartner.IsVendor='Y'


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/3.0/Developers_Guide/Database_Model/org.openbravo.model.common.invoice/C_Invoice_CustomerVendQtr"

This page has been accessed 1,307 times. This page was last modified on 15 April 2011, at 21:34. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.