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.project/C ProjectLine

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.project


Contents

C_ProjectLine

This table contains the following columns:

Name Nullable Data Type Description


UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Processed No CHAR (1) The Processed checkbox indicates that a document has been processed.
M_Product_Category_ID Yes VARCHAR (32) Identifies the category which this product belongs to. Product categories are used for pricing.
M_Product_ID No VARCHAR (32) Identifies an item which is either purchased or sold in this organization.
CommittedAmt Yes DECIMAL The commitment amount is independent from the planned amount. You would use the planned amount for your realistic estimation, which might be higher or lower than the commitment amount.
PlannedMarginAmt No DECIMAL The Planned Margin Amount indicates the anticipated margin amount for this project or project line.
PlannedAmt No DECIMAL The Planned Amount indicates the anticipated amount for this project or project line.
PlannedPrice No DECIMAL The Planned Price indicates the anticipated price for this project line.
PlannedQty No DECIMAL The Planned Quantity indicates the anticipated quantity for this project or project line
Description Yes NVARCHAR (255) A description is limited to 255 characters.
IsActive No CHAR (1) There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:

(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
C_ProjectLine_ID No VARCHAR (32) The Project Line indicates a unique project line.
IsPrinted No CHAR (1) The Printed checkbox indicates if this document or line will included when printing.
C_ProjectIssue_ID Yes VARCHAR (32) Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock.
C_Order_ID Yes VARCHAR (32) Unique identifier and a reference to a Sales Order originating from the document sequence defined for this document type.
C_OrderPO_ID Yes VARCHAR (32) Purchase order
DoPricing Yes CHAR (1)
InvoicedAmt No DECIMAL The amount invoiced
CommittedQty Yes DECIMAL The commitment amount is independent from the planned amount. You would use the planned amount for your realistic estimation, which might be higher or lower than the commitment amount.
InvoicedQty No DECIMAL The Quantity Invoiced
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
C_Project_ID No VARCHAR (32) Identifier of a project defined within the Project & Service Management module.
Line No DECIMAL (10,0) Indicates the unique line for a document. It will also control the display order of the lines within a document.
Plannedpoprice Yes DECIMAL Indicates the planned price for the purchase order
C_Tax_ID Yes VARCHAR (32) The Tax indicates the type of tax for this document line.
Product_Value Yes NVARCHAR (40) A value specified in many forms.
Product_Name Yes NVARCHAR (60) Name of the product
Product_Description Yes NVARCHAR (2000) Description for the product

Columns

Updated By


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

top


Created By


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

top


Processed



top


Product Category


Foreign key column to M_Product_Category table, (column: M_Product_Category_ID)

top


Product


Foreign key column to M_Product table, (column: M_Product_ID)

Callout: SE_ProjectLine_Value

This column has a callout associated.

It is implemented by [1] Java Class.

top


Contract Amount



top


Planned Margin


Callout: SL_Project_Planned

This column has a callout associated.

It is implemented by [2] Java Class.

top


Planned Amount



top


Planned Price


Callout: SL_Project_Planned

This column has a callout associated.

It is implemented by [3] Java Class.

top


Planned Quantity


Callout: SL_Project_Planned

This column has a callout associated.

It is implemented by [4] Java Class.

top


Description



top


Active



top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID) It has a validation "AD_Org Trx Security validation", with the following code

AD_Org.AD_Org_ID<> '0' AND AD_Org.IsReady='Y'

top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID)

top


Creation Date



top


Project Line



top


Print



top


Project Issue


Foreign key column to C_ProjectIssue table, (column: C_ProjectIssue_ID)

top


Sales Order


Foreign key column to C_Order table, (column: C_Order_ID)

top


Purchase Order


Foreign key column to C_Order table, (column: C_Order_ID)

top


Pricing



top


Invoice Amount



top


Contract Quantity



top


Invoice Quantity



top


Updated



top


Project


Foreign key column to C_Project table, (column: C_Project_ID)

top


Line No.


top


Planned Purchase Price



Callout: SL_Project_Planned

This column has a callout associated.

It is implemented by [5] Java Class.

top


Tax


Foreign key column to C_Tax table, (column: C_Tax_ID)

top


Identifier



top


Name



top


Product Description



top


Other Info

Indices

These are the indices for this table (for each index there is a list of all the columns included within it):

top

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.project

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.project/C_ProjectLine"

This page has been accessed 1,060 times. This page was last modified on 1 September 2016, at 02:31. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.