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

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.project/C Projectproposal V

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.project

Index

Contents

C_Projectproposal_V

This table contains the following columns:

Name Nullable Data Type Description
Fromdatesend YDATEnull
Todatesend YDATEx not implemented
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
AD_User_ID YVARCHAR2(32)An acquaintance to reach for information related to the business partner.
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
C_BPartner_Location_ID YVARCHAR2(32)The location of the selected business partner.
C_Project_ID NVARCHAR2(32)Identifier of a project defined within the Project & Service Management module.
C_Projectproposal_ID NVARCHAR2(32)null
IsSOTrx YCHAR(1)An indication that a transfer of goods and money between business partners is occurring.
Firstname YNVARCHAR2(60)Name of the contact
Lastname YNVARCHAR2(60)Last name of the contact
Datesend YDATEnull

Columns

From

top

Until

top

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

User/Contact

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


Validation Rule AD_User C_BPartner User/Contacts: null. With the following code:

 
AD_User.C_BPartner_ID=@C_BPartner_ID@

top

Business Partner

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

top

Partner Address

Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)


Validation Rule C_BPartner Location: null. With the following code:

 
C_BPartner_Location.C_BPartner_ID=@C_BPartner_ID@

top

Project

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

top

Project Proposal

The ID identifies a unique proposal for the project

top

Sales Transaction

The Sales Transaction checkbox indicates if this item is a Sales Transaction.

top

First Name

First Name of the contact

top

Last Name

Last name of the contact

top

Date Sent

The date of the proposal was sent

top

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

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