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

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.interaction/C POC EMAIL

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.common.interaction


Contents

C_POC_EMAIL

This table contains the following columns:

Name Nullable Data Type Description


AD_Table_ID Yes VARCHAR (32) The Table indicates the table in which a field or fields reside.
Isactive Yes 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.

Address_Bcc Yes VARCHAR (1000)
Address_Cc Yes VARCHAR (1000)
Address_From Yes VARCHAR (200)
Address_To Yes VARCHAR (1000)
Body Yes CLOB As in the subject some tags are available

References will be replaced by values:

   * @cus_ref@: The document reference of the customer
   * @our_ref@: The reference of the document
   * @cus_nam@: The name of the customer
   * @sal_nam@: The name of the sales rep.
   * @bp_nam@: The Business Partner name
   * @doc_date@: The document date
   * @doc_desc@: The document description
   * @doc_nextduedate@: The next due date (if document has associated any payment plan)
   * @doc_lastduedate@: The last due date (if document has associated any payment plan)
C_Bpartner_ID Yes VARCHAR (32) A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
C_Poc_Email_ID No VARCHAR (32)
AD_Client_ID Yes VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
Createdby Yes VARCHAR (32) The Created By field indicates the user who created this record.
Created Yes TIMESTAMP (7) The Created field indicates the date that this record was created.
Dateofemail Yes TIMESTAMP (7)
Document_ID Yes VARCHAR (32) The document id that has sent the email.
Email_Type Yes VARCHAR (32)
AD_Org_ID Yes VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Subject Yes VARCHAR (1000) References will be replaced by values:
   * @cus_ref@: The document reference of the customer
   * @our_ref@: The reference of the document
   * @cus_nam@: The name of the customer
   * @sal_nam@: The name of the sales rep.
   * @bp_nam@: The Business Partner name
   * @doc_date@: The document date
   * @doc_desc@: The document description
   * @doc_nextduedate@: The next due date (if document has associated any payment plan)
   * @doc_lastduedate@: The last due date (if document has associated any payment plan)
Updated Yes TIMESTAMP (7) The Updated field indicates the date that this record was updated.
Updatedby Yes VARCHAR (32) The Updated By field indicates the user who updated this record.

Columns

AD_Table_ID


Foreign key column to AD_Table table, (column: AD_Table_ID)

top


Active



top


Address_Bcc



top


Address_Cc



top


Address_From



top


Address_To



top


Body



top


Business Partner

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

top


C_Poc_Email_ID



top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID) It has a validation "AD_Client Security validation", with the following code

AD_Client.AD_Client_ID in (@#User_Client@)

top


Created By


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

top


Creation Date



top


Dateofemail


top


Document_ID



top


Email_Type



top


Organization


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

(@AD_Client_ID@='0' AND AD_Org.AD_Org_ID='0') OR (@AD_Client_ID@!='0' AND ((AD_Org.AD_Client_ID IN (@#User_Client@) AND AD_Org.AD_Org_ID IN (@#User_Org@)) OR AD_Org.AD_Org_ID='0' AND AD_Org.IsSummary='N'))

top


Subject


top


Updated



top


Updated By


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

top


Other Info

Back button.png   Back to org.openbravo.model.common.interaction

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.common.interaction/C_POC_EMAIL"

This page has been accessed 2,869 times. This page was last modified on 1 November 2021, at 01:53. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.