ManPageW WebProject

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section


Contents

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

Contributions

Personal tools