ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Projectproposal V
Contents |
C_Projectproposal_V
- Name:ActiveProposalV
- Classname:ActiveProposal
This table contains the following columns:
Name | Nullable | Data Type | Description |
Fromdatesend | Y | DATE | null |
Todatesend | Y | DATE | x not implemented |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
AD_User_ID | Y | VARCHAR2(32) | An acquaintance to reach for information related to the business partner. |
C_BPartner_ID | Y | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
C_BPartner_Location_ID | Y | VARCHAR2(32) | The location of the selected business partner. |
C_Project_ID | N | VARCHAR2(32) | Identifier of a project defined within the Project & Service Management module. |
C_Projectproposal_ID | N | VARCHAR2(32) | null |
IsSOTrx | Y | CHAR(1) | An indication that a transfer of goods and money between business partners is occurring. |
Firstname | Y | NVARCHAR2(60) | Name of the contact |
Lastname | Y | NVARCHAR2(60) | Last name of the contact |
Datesend | Y | DATE | null |
Columns
From
- Physical column name: Fromdatesend
- Property Name: from
- Reference: Date
Until
- Physical column name: Todatesend
- Property Name: until
- Reference: Date
Client
- Physical column name: AD_Client_ID
- Property Name: client
- 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
- Property Name: organization
- Reference: TableDir
- Default value: @AD_ORG_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
User/Contact
- Physical column name: AD_User_ID
- Property Name: userContact
- Reference: TableDir
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@
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Partner Address
- Physical column name: C_BPartner_Location_ID
- Property Name: partnerAddress
- Reference: TableDir
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@
Project
- Physical column name: C_Project_ID
- Property Name: project
- Reference: TableDir
- This column is part of the table's identifier
Foreign key column to C_Project table, (column: C_Project_ID)
Project Proposal
The ID identifies a unique proposal for the project
- Physical column name: C_Projectproposal_ID
- Property Name: id
- Reference: ID
Sales Transaction
The Sales Transaction checkbox indicates if this item is a Sales Transaction.
- Physical column name: IsSOTrx
- Property Name: salesTransaction
- Reference: YesNo
First Name
First Name of the contact
- Physical column name: Firstname
- Property Name: firstName
- Reference: String
- This column is part of the table's identifier
Last Name
Last name of the contact
- Physical column name: Lastname
- Property Name: lastName
- Reference: String
- This column is part of the table's identifier
Date Sent
The date of the proposal was sent
- Physical column name: Datesend
- Property Name: dateSent
- Reference: Date