ManPageW WebProject
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
- 1 Window: Web Project
- 1.1 Tab: Project
- 1.2 Tab: Container
- 1.3 Tab: Container Translation
- 1.4 Tab: Container Element
- 1.5 Tab: Container Element Translation
- 1.6 Tab: Container T.Table
- 1.7 Tab: Stage
- 1.8 Tab: Stage Translation
- 1.9 Tab: Stage Element
- 1.10 Tab: Stage Element Translation
- 1.11 Tab: Stage T.Table
- 1.12 Tab: Template
- 1.13 Tab: Template Table
- 1.14 Tab: Template Ad Category
- 1.15 Tab: Media
- 1.16 Tab: Domain
- 1.17 Tab: Media Server
- 2 Contributions
Window: Web Project
Description : Maintain Web Project (Content Management)
Help : At the level of the web project you define the project itself, it's domains and media servers. Each project needs to have at least one domain and one media server.
Tab: Project
Description : A web project is the main datacontainer for Containers, URLs, Ads, Media etc.
Help : A web project is the meta definition which will contain later on all data within the Web Content Management Project.
Table Name : CM_WebProject
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Meta Author | Author of the content | Author of the content for the Containers Meta Data | Meta_Author
NVARCHAR2(2000) String |
Meta Content Type | Defines the type of content i.e. "text/html; charset=UTF-8" | With this tag you can overwrite the type of content and how search engines will interpret it. You should keep in mind that this will not influence how the Server and Client interpret the content. | Meta_Content
NVARCHAR2(2000) String |
Meta Copyright | Contains Copyright information for the content | This Tag contains detailed information about the content's copyright situation, how holds it for which timeframe etc. | Meta_Copyright
NVARCHAR2(2000) String |
Meta Publisher | Meta Publisher defines the publisher of the content | As author and publisher must not be the same person this tag saves the responsible publisher for the content | Meta_Publisher
NVARCHAR2(2000) String |
Meta RobotsTag | RobotsTag defines how search robots should handle this content | The Meta Robots Tag define on how a search engines robot should handle this page and the following ones. It defines two keywords: (NO)INDEX which defines whether or not to index this content and (NO)FOLLOW which defines whether or not to folow links. The most common combination is INDEX,FOLLOW which will force a search robot to index the content and follow links and images. | Meta_RobotsTag
NVARCHAR2(2000) String |
Container Tree | Container Tree | Container Tree | AD_TreeCMC_ID
NUMBER(10) Table |
Stage Tree | Stage Tree | Stage Tree | AD_TreeCMS_ID
NUMBER(10) Table |
Template Tree | Template Tree | Template Tree | AD_TreeCMT_ID
NUMBER(10) Table |
Media Tree | Media Tree | Media Tree | AD_TreeCMM_ID
NUMBER(10) Table |
Tab: Container
Description : View Web Container
Help : View deployed Web Container Information.
Table Name : CM_Container
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Project | A web project is the main data container for Containers, URLs, Ads, Media etc. | A web project is the meta definition which will contain later on all data within the Web Content Management Project. | CM_WebProject_ID
NUMBER(10) TableDir |
Template | Template defines how content is displayed | A template describes how content should get displayed, it contains layout and maybe also scripts on how to handle the content | CM_Template_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Title | Name this entity is referred to as | The Title indicates the name that an entity is referred to as. | Title
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(2000) Text |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Summary Level | This is a summary entity | A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. | IsSummary
CHAR(1) YesNo |
Web Container Type | Web Container Type | This parameter defines the type of content for this container. | ContainerType
CHAR(1) List |
External Link (URL) | External Link (IRL) for the Container | External URL for the Container | ContainerLinkURL
NVARCHAR2(60) Unknown (40) |
Container Link | Link to another Container in the Web Project | Internal Link | CM_ContainerLink_ID
NUMBER(10) Table |
Relative URL | Contains the relative URL for the container | The relative URL is used together with the webproject domain to display the content | RelativeURL
NVARCHAR2(120) String |
Indexed | Index the document for the internal search engine | For cross document search, the document can be indexed for faster search (Container, Document Type, Request Type) | IsIndexed
CHAR(1) YesNo |
Secure content | Defines whether content needs to get encrypted | If you select this parameter this container will only get delivered over a secure connection i.e. SSL etc. if no encryption can be found no content will be delivered | IsSecure
CHAR(1) YesNo |
Meta Author | Author of the content | Author of the content for the Containers Meta Data | Meta_Author
NVARCHAR2(2000) String |
Meta Content Type | Defines the type of content i.e. "text/html; charset=UTF-8" | With this tag you can overwrite the type of content and how search engines will interpret it. You should keep in mind that this will not influence how the Server and Client interpret the content. | Meta_Content
NVARCHAR2(2000) String |
Meta Language | Language HTML Meta Tag | Meta_Language
CHAR(2) String | |
Meta Copyright | Contains Copyright information for the content | This Tag contains detailed information about the content's copyright situation, how holds it for which timeframe etc. | Meta_Copyright
NVARCHAR2(2000) String |
Meta Description | Meta info describing the contents of the page | The Meta Description tag should contain a short description on the page content | Meta_Description
NVARCHAR2(2000) Text |
Meta Keywords | Contains the keywords for the content | Contains keyword info on the main search words this content is relevant to | Meta_Keywords
NVARCHAR2(2000) Text |
Meta Publisher | Meta Publisher defines the publisher of the content | As author and publisher must not be the same person this tag saves the responsible publisher for the content | Meta_Publisher
NVARCHAR2(2000) String |
Meta RobotsTag | RobotsTag defines how search robots should handle this content | The Meta Robots Tag define on how a search engines robot should handle this page and the following ones. It defines two keywords: (NO)INDEX which defines whether or not to index this content and (NO)FOLLOW which defines whether or not to folow links. The most common combination is INDEX,FOLLOW which will force a search robot to index the content and follow links and images. | Meta_RobotsTag
NVARCHAR2(2000) String |
Notice | Contains last write notice | Contains info on what changed with the last write | Notice
NVARCHAR2(2000) Text |
Priority | Indicates if this request is of a high, medium or low priority. | The Priority indicates the importance of this request. | Priority
NUMBER(10) Integer |
Tab: Container Translation
Description : View Container Translation
Help : View deployed Web Container Translations
Table Name : CM_Container_Trl
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Container | Web Container contains content like images, text etc. | A Container defines the abstract level around the content, it defines how the content get's displayed, indexed and stored. | CM_Container_ID
NUMBER(10) TableDir |
Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
Translated | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated
CHAR(1) YesNo |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Title | Name this entity is referred to as | The Title indicates the name that an entity is referred to as. | Title
NVARCHAR2(60) String |
Meta Description | Meta info describing the contents of the page | The Meta Description tag should contain a short description on the page content | Meta_Description
NVARCHAR2(2000) Text |
Meta Keywords | Contains the keywords for the content | Contains keyword info on the main search words this content is relevant to | Meta_Keywords
NVARCHAR2(2000) Text |
Tab: Container Element
Description : View Web Container Element
Help : View deployed Web Container Element
Table Name : CM_Container_Element
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Container | Web Container contains content like images, text etc. | A Container defines the abstract level around the content, it defines how the content get's displayed, indexed and stored. | CM_Container_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Content HTML | Contains the content itself | Contains the content itself as HTML code. Should normally only use basic tags, no real layouting | ContentHTML
CLOB TextLong |
Tab: Container Element Translation
Description : View Web Container Element Translation
Help : View deployed Web Container Element Translation
Table Name : CM_Container_Element_Trl
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Container Element | Container element i.e. Headline, Content, Footer etc. | A container element defines the smalles definition of content, i.e. the headline, the content etc. | CM_Container_Element_ID
NUMBER(10) TableDir |
Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
Translated | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated
CHAR(1) YesNo |
Content HTML | Contains the content itself | Contains the content itself as HTML code. Should normally only use basic tags, no real layouting | ContentHTML
CLOB TextLong |
Tab: Container T.Table
Description : View Container Template Table
Help : Link to individual Record
Table Name : CM_ContainerTTable
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Container | Web Container contains content like images, text etc. | A Container defines the abstract level around the content, it defines how the content get's displayed, indexed and stored. | CM_Container_ID
NUMBER(10) TableDir |
Template Table | CM Template Table Link | Link a Template with a Table | CM_TemplateTable_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Record ID | Direct internal record ID | The Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known. | Record_ID
NUMBER(10) Button |
Sql WHERE | Fully qualified SQL WHERE clause | The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname". | WhereClause
NVARCHAR2(2000) Text |
Other SQL Clause | Other SQL Clause | Any other complete clause like GROUP BY, HAVING, ORDER BY, etc. after WHERE clause. | OtherClause
NVARCHAR2(2000) Text |
Tab: Stage
Description : Maintain Container Stage
Help : Maintain Container Stage information.
Table Name : CM_CStage
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Project | A web project is the main data container for Containers, URLs, Ads, Media etc. | A web project is the meta definition which will contain later on all data within the Web Content Management Project. | CM_WebProject_ID
NUMBER(10) TableDir |
Template | Template defines how content is displayed | A template describes how content should get displayed, it contains layout and maybe also scripts on how to handle the content | CM_Template_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Title | Name this entity is referred to as | The Title indicates the name that an entity is referred to as. | Title
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(2000) Text |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Summary Level | This is a summary entity | A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. | IsSummary
CHAR(1) YesNo |
Web Container Type | Web Container Type | This parameter defines the type of content for this container. | ContainerType
CHAR(1) List |
External Link (URL) | External Link (IRL) for the Container | External URL for the Container | ContainerLinkURL
NVARCHAR2(60) Unknown (40) |
Container Link | Stage Link to another Container in the Web Project | Internal Link | CM_CStageLink_ID
NUMBER(10) Table |
Relative URL | Contains the relative URL for the container | The relative URL is used together with the webproject domain to display the content | RelativeURL
NVARCHAR2(120) String |
Indexed | Index the document for the internal search engine | For cross document search, the document can be indexed for faster search (Container, Document Type, Request Type) | IsIndexed
CHAR(1) YesNo |
Secure content | Defines whether content needs to get encrypted | If you select this parameter this container will only get delivered over a secure connection i.e. SSL etc. if no encryption can be found no content will be delivered | IsSecure
CHAR(1) YesNo |
Meta Author | Author of the content | Author of the content for the Containers Meta Data | Meta_Author
NVARCHAR2(2000) String |
Meta Content Type | Defines the type of content i.e. "text/html; charset=UTF-8" | With this tag you can overwrite the type of content and how search engines will interpret it. You should keep in mind that this will not influence how the Server and Client interpret the content. | Meta_Content
NVARCHAR2(2000) String |
Meta Language | Language HTML Meta Tag | Meta_Language
CHAR(2) String | |
Meta Copyright | Contains Copyright information for the content | This Tag contains detailed information about the content's copyright situation, how holds it for which timeframe etc. | Meta_Copyright
NVARCHAR2(2000) String |
Meta Description | Meta info describing the contents of the page | The Meta Description tag should contain a short description on the page content | Meta_Description
NVARCHAR2(2000) Text |
Meta Keywords | Contains the keywords for the content | Contains keyword info on the main search words this content is relevant to | Meta_Keywords
NVARCHAR2(2000) Text |
Meta Publisher | Meta Publisher defines the publisher of the content | As author and publisher must not be the same person this tag saves the responsible publisher for the content | Meta_Publisher
NVARCHAR2(2000) String |
Meta RobotsTag | RobotsTag defines how search robots should handle this content | The Meta Robots Tag define on how a search engines robot should handle this page and the following ones. It defines two keywords: (NO)INDEX which defines whether or not to index this content and (NO)FOLLOW which defines whether or not to folow links. The most common combination is INDEX,FOLLOW which will force a search robot to index the content and follow links and images. | Meta_RobotsTag
NVARCHAR2(2000) String |
Priority | Indicates if this request is of a high, medium or low priority. | The Priority indicates the importance of this request. | Priority
NUMBER(10) Integer |
Notice | Contains last write notice | Contains info on what changed with the last write | Notice
NVARCHAR2(2000) Text |
Modified | The record is modified | Indication that the record is modified | IsModified
CHAR(1) YesNo |
Validate | Validate Staging Area | Processing
CHAR(1) Button |
Tab: Stage Translation
Description : Maintain Container Stage Translation
Help :
Table Name : CM_CStage_Trl
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Container Stage | Web Container Stage contains the staging content like images, text etc. | A Container defines the abstract level around the content, it defines how the content get's displayed, indexed and stored.
The ID is related 1 to 1 to the container ID |
CM_CStage_ID
NUMBER(10) TableDir |
Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
Translated | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated
CHAR(1) YesNo |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Title | Name this entity is referred to as | The Title indicates the name that an entity is referred to as. | Title
NVARCHAR2(60) String |
Meta Description | Meta info describing the contents of the page | The Meta Description tag should contain a short description on the page content | Meta_Description
NVARCHAR2(2000) Text |
Meta Keywords | Contains the keywords for the content | Contains keyword info on the main search words this content is relevant to | Meta_Keywords
NVARCHAR2(2000) Text |
Tab: Stage Element
Description : Container Stage Element
Help :
Table Name : CM_CStage_Element
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Container Stage | Web Container Stage contains the staging content like images, text etc. | A Container defines the abstract level around the content, it defines how the content get's displayed, indexed and stored.
The ID is related 1 to 1 to the container ID |
CM_CStage_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Content HTML | Contains the content itself | Contains the content itself as HTML code. Should normally only use basic tags, no real layouting | ContentHTML
CLOB TextLong |
Tab: Stage Element Translation
Description : Container Stage Element Translation
Help :
Table Name : CM_CStage_Element_Trl
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Container Stage Element | Container element i.e. Headline, Content, Footer etc. | A container element defines the smalles definition of content, i.e. the headline, the content etc. | CM_CStage_Element_ID
NUMBER(10) TableDir |
Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
Translated | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated
CHAR(1) YesNo |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Content HTML | Contains the content itself | Contains the content itself as HTML code. Should normally only use basic tags, no real layouting | ContentHTML
CLOB TextLong |
Tab: Stage T.Table
Description : Maintain Container Stage Template Table
Help : Link to individual Record
Table Name : CM_CStageTTable
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Container Stage | Web Container Stage contains the staging content like images, text etc. | A Container defines the abstract level around the content, it defines how the content get's displayed, indexed and stored.
The ID is related 1 to 1 to the container ID |
CM_CStage_ID
NUMBER(10) TableDir |
Template Table | CM Template Table Link | Link a Template with a Table | CM_TemplateTable_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Record ID | Direct internal record ID | The Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known. | Record_ID
NUMBER(10) Button |
Sql WHERE | Fully qualified SQL WHERE clause | The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname". | WhereClause
NVARCHAR2(2000) Text |
Other SQL Clause | Other SQL Clause | Any other complete clause like GROUP BY, HAVING, ORDER BY, etc. after WHERE clause. | OtherClause
NVARCHAR2(2000) Text |
Tab: Template
Description : Web Project Template
Help : CM Project Template
Table Name : CM_Template
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Project | A web project is the main data container for Containers, URLs, Ads, Media etc. | A web project is the meta definition which will contain later on all data within the Web Content Management Project. | CM_WebProject_ID
NUMBER(10) TableDir |
Search Key | Search key for the record in the format required - must be unique | A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
Value
NVARCHAR2(40) String |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Summary Level | This is a summary entity | A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. | IsSummary
CHAR(1) YesNo |
Use Ad | Whether or not this templates uses Ad's | This describe whether or not this Template will use Ad's | IsUseAd
CHAR(1) YesNo |
Uses News | Template or container uses news channels | This content (container or template) uses news channels | IsNews
CHAR(1) YesNo |
Elements | Contains list of elements seperated by CR | Contains a list of elements this template uses seperated by a Carriage Return. Last line should be empty | Elements
NVARCHAR2(2000) Text |
Included | Defines whether this content / template is included into another one | Templates can be independent or included. Included Templates are also called subtemplates | IsInclude
CHAR(1) YesNo |
TemplateXST | Contains the template code itself | Here we include the template code itself | TemplateXST
CLOB TextLong |
Valid | Element is valid | The element passed the validation check | IsValid
CHAR(1) YesNo |
Validate | Validate Template | Processing
CHAR(1) Button |
Tab: Template Table
Description : Maintain Template Tables
Help : Link a Template with a Table
Table Name : CM_TemplateTable
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Template | Template defines how content is displayed | A template describes how content should get displayed, it contains layout and maybe also scripts on how to handle the content | CM_Template_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Table | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID
NUMBER(10) TableDir |
Sql WHERE | Fully qualified SQL WHERE clause | The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname". | WhereClause
NVARCHAR2(2000) Text |
Other SQL Clause | Other SQL Clause | Any other complete clause like GROUP BY, HAVING, ORDER BY, etc. after WHERE clause. | OtherClause
NVARCHAR2(2000) Text |
Tab: Template Ad Category
Description : Maintain Template Advertisement Category
Help : Link a Template with an Advertisement Category
Table Name : CM_Template_Ad_Cat
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Template | Template defines how content is displayed | A template describes how content should get displayed, it contains layout and maybe also scripts on how to handle the content | CM_Template_ID
NUMBER(10) TableDir |
Advertisement Category | Advertisement Category like Banner Homepage | The advertisement category defines a container for ad's like for example all banners used on the homepage in rotation are stored in a category "Banner Homepage" etc. | CM_Ad_Cat_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Tab: Media
Description : Media Elements
Help :
Table Name : CM_Media
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Project | A web project is the main data container for Containers, URLs, Ads, Media etc. | A web project is the meta definition which will contain later on all data within the Web Content Management Project. | CM_WebProject_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Summary Level | This is a summary entity | A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. | IsSummary
CHAR(1) YesNo |
Media Type | Defines the media type for the browser | The browser and the media server need info on the type of content | MediaType
CHAR(3) List |
Image | Image or Icon | Images and Icon can be used to display supported graphic formats (gif, jpg, png).
You can either load the image (in the database) or point to a graphic via a URI (i.e. it can point to a resource, http address) |
AD_Image_ID
NUMBER(10) Image |
Content | ContentText
CLOB TextLong | ||
Media Direct Deploy | DirectDeploy
CHAR(1) Button |
Tab: Domain
Description : Maintain Web Project Domains
Help : Link between the Web Project and the public URLs (Domains)
Table Name : CM_WebProject_Domain
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Project | A web project is the main data container for Containers, URLs, Ads, Media etc. | A web project is the meta definition which will contain later on all data within the Web Content Management Project. | CM_WebProject_ID
NUMBER(10) TableDir |
Web Container | Web Container contains content like images, text etc. | A Container defines the abstract level around the content, it defines how the content get's displayed, indexed and stored. | CM_Container_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Fully Qualified Domain Name | Fully Qualified Domain Name i.e. www.comdivision.com | This field contains the so called fully qualified domain name including host and domain, but not anything protocol specific like http or the document path. | FQDN
NVARCHAR2(120) String |
Tab: Media Server
Description : Web Project Media Server
Help : Media Server for the web project
Table Name : CM_Media_Server
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Project | A web project is the main data container for Containers, URLs, Ads, Media etc. | A web project is the meta definition which will contain later on all data within the Web Content Management Project. | CM_WebProject_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
IP Address | Defines the IP address to transfer data to | Contains info on the IP address to which we will transfer data | IP_Address
VARCHAR2 String |
Transfer passive | FTP passive transfer | Should the transfer be run in passive mode? | IsPassive
CHAR(1) YesNo |
UserName | UserName / Login to use for login | UserName / Login to use for the login
Email of the responsible person for the system (registered in WebStore) |
UserName
VARCHAR2 String |
Password | Password of any length (case sensitive) | The Password for this User. Passwords are required to identify authorized users. For Adempiere Users, you can change the password via the Process "Reset Password". | Password
VARCHAR2 String |
Folder | A folder on a local or remote system to store data into | We store files in folders, especially media files. | Folder
VARCHAR2 String |
URL | Full URL address - e.g. http://www.adempiere.org | The URL defines an fully qualified web address like http://www.adempiere.org | URL
NVARCHAR2(120) String |