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

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


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_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
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.
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.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
Product_Value Yes NVARCHAR (40) A value specified in many forms.
InvoicedAmt No DECIMAL The amount invoiced
InvoicedQty No DECIMAL The Quantity Invoiced
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.
Product_Name Yes NVARCHAR (60) Name of the product
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.
PlannedAmt No DECIMAL The Planned Amount indicates the anticipated amount for this project or project line.
PlannedMarginAmt No DECIMAL The Planned Margin Amount indicates the anticipated margin amount for this project or project line.
PlannedPrice No DECIMAL The Planned Price indicates the anticipated price for this project line.
Plannedpoprice Yes DECIMAL Indicates the planned price for the purchase order
PlannedQty No DECIMAL The Planned Quantity indicates the anticipated quantity for this project or project line
IsPrinted No CHAR (1) The Printed checkbox indicates if this document or line will included when printing.
Processed No CHAR (1) The Processed checkbox indicates that a document has been processed.
M_Product_ID No VARCHAR (32) Identifies an item which is either purchased or sold in this organization.
M_Product_Category_ID Yes VARCHAR (32) Identifies the category which this product belongs to. Product categories are used for pricing.
Product_Description Yes NVARCHAR (2000) Description for the product
C_Project_ID No VARCHAR (32) Identifier of a project defined within the Project & Service Management module.
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_ProjectLine_ID No VARCHAR (32) The Project Line indicates a unique project line.
C_OrderPO_ID Yes VARCHAR (32) Purchase order
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_Tax_ID Yes VARCHAR (32) The Tax indicates the type of tax for this document line.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.

Columns

Active



top


Client


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

top


Contract Amount



top


Contract Quantity



top


Created By


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

top


Creation Date



top


Description



top


Identifier



top


Invoice Amount



top


Invoice Quantity



top


Line No.


top


Name



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


Planned Amount



top


Planned Margin


Callout: SL_Project_Planned

This column has a callout associated.

It is implemented by [1] Java Class.

top


Planned Price


Callout: SL_Project_Planned

This column has a callout associated.

It is implemented by [2] Java Class.

top


Planned Purchase 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


Print



top


Processed



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 [5] Java Class.

top


Product Category


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

top


Product Description



top


Project


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

top


Project Issue


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

top


Project Line



top


Purchase Order


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

top


Sales Order


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

top


Tax


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

top


Updated



top


Updated By


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

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 3,934 times. This page was last modified on 26 July 2021, at 02:00. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.