ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.invoice/C InvoiceLine V2
C_InvoiceLine_V2
- Name:InvoiceLineV2
- Classname:InvoiceLineV2
This table contains the following columns:
Name | Nullable | Data Type | Description |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
C_InvoiceLine_ID | N | VARCHAR2(32) | A statement displaying one item or charge in an invoice. |
C_Invoice_ID | N | VARCHAR2(32) | A document listing products, quantities and prices, payment terms, etc. |
SalesRep_ID | Y | VARCHAR2(32) | The person in charge of a document. |
C_BPartner_ID | N | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
C_BP_Group_ID | N | VARCHAR2(32) | A classification of business partners based on defined similarities. |
M_Product_ID | Y | VARCHAR2(32) | An item produced by a process. |
M_Product_Category_ID | Y | VARCHAR2(32) | A classification of items based on similar characteristics or attributes. |
DateInvoiced | N | DATE | The time listed on the invoice. |
DateAcct | N | DATE | The date this transaction is recorded for in the general ledger. |
QtyInvoiced | Y | NUMBER | The total number of a product included in an invoice to a business partner. |
PriceList | N | NUMBER | The official price of a product in a specified currency. |
PriceActual | N | NUMBER | The price that will be paid for a specified item. |
PriceLimit | N | NUMBER | The lowest price a specified item may be sold for. |
Discount | Y | NUMBER | The proportional discount given to an item, without respect to any previously defined discounts. |
Margin | Y | NUMBER | Margin for a product as a percentage |
LineNetAmt | Y | NUMBER | The final amount of a specified line, based only on quantities and prices. |
LineListAmt | Y | NUMBER | null |
LineLimitAmt | Y | NUMBER | null |
LineDiscountAmt | Y | NUMBER | Line Discount Amount |
LineOverLimitAmt | Y | NUMBER | null |
Columns
Client
- Physical column name: AD_Client_ID
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Organization
- Physical column name: AD_Org_ID
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Invoice Line
- Physical column name: C_InvoiceLine_ID
- Reference: Search
- This column is part of the table's identifier
Foreign key column to C_InvoiceLine table, (column: C_InvoiceLine_ID)
Invoice
- Physical column name: C_Invoice_ID
- Reference: Search
Foreign key column to C_Invoice table, (column: C_Invoice_ID)
Sales Representative
- Physical column name: SalesRep_ID
- Reference: Table
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')
Business Partner
- Physical column name: C_BPartner_ID
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Business Partner Category
- Physical column name: C_BP_Group_ID
- Reference: TableDir
Foreign key column to C_BP_Group table, (column: C_BP_Group_ID)
Product
- Physical column name: M_Product_ID
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
Product Category
- Physical column name: M_Product_Category_ID
- Reference: TableDir
Foreign key column to M_Product_Category table, (column: M_Product_Category_ID)
Invoice Date
The Date Invoice indicates the date printed on the invoice.
- Physical column name: DateInvoiced
- Reference: Date
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.
- Physical column name: DateAcct
- Reference: Date
Invoiced Quantity
The Invoiced Quantity indicates the quantity of a product that have been invoiced.
- Physical column name: QtyInvoiced
- Reference: Quantity
List Price
The List Price is the official price stated by the selected pricelist and the currency of the document.
- Physical column name: PriceList
- Reference: Price
Unit Price
The actual price indicates the price for a product in source currency.
- Physical column name: PriceActual
- Reference: Price
Price Limit
The Price Limit indicates the lowest price for a product stated in the Price List Currency.
- Physical column name: PriceLimit
- Reference: Price
Discount %
The Discount indicates the discount applied or taken as a percentage.
- Physical column name: Discount
- Reference: Integer
Margin %
The Margin indicates the margin for this product as a percentage of the limit price and selling price.
- Physical column name: Margin
- Reference: Number
Line Net Amount
Indicates the line net amount based on the quantity and the actual price. Any additional charges or freight are not included.
- Physical column name: LineNetAmt
- Reference: Amount
Line List Amount
- Physical column name: LineListAmt
- Reference: Amount
Line Limit Amount
- Physical column name: LineLimitAmt
- Reference: Amount
Line Discount
Indicates the discount for this line as an amount.
- Physical column name: LineDiscountAmt
- Reference: Amount
Gross Margin
- Physical column name: LineOverLimitAmt
- Reference: Amount