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 Week

Contents

C_Invoice_Week

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
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
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

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

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

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

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

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