Adempiere3.1.2/en/ManPageW WebStore olh
Contents
Window: Web Store
Description : Define Web Store
Help : Define the web store setup.
Tab: Web Store
Description : Define Web Store
Help : Define the web store settings. The web server context must be unique and determines the settings used in the actual transaction. The selected warehouse determines the organization. The email settings are tested with the client email settings.
Table Name : W_Store
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 |
| Default | Default value | The Default Checkbox indicates if this record will be used as a default value. | IsDefault
CHAR(1) YesNo |
| 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) Unknown (40) |
| Web Context | Web Server Context - e.g. /wstore | Unique Web Server Context for this Web Store - will set context-root in application.xml.
The web context usually starts with / and needs to be a valid context name (not checked). |
WebContext
NVARCHAR2(20) String |
| Stylesheet | CSS (Stylesheet) used | Base Stylesheet (.css file) to use - if empty, the default (standard.css) is used. The Style sheet can be a URL. | Stylesheet
NVARCHAR2(60) String |
| Sales Representative | Sales Representative or Company Agent | The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. | SalesRep_ID
NUMBER(10) Search |
| Warehouse | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | M_Warehouse_ID
NUMBER(10) TableDir |
| Price List | Unique identifier of a Price List | Price Lists are used to determine the pricing, margin and cost of items purchased or sold. | M_PriceList_ID
NUMBER(10) TableDir |
| Payment Term | The terms of Payment (timing, discount) | Payment Terms identify the method and timing of payment. | C_PaymentTerm_ID
NUMBER(10) TableDir |
| Web Store Info | Web Store Header Information | Display HTML Info in the Web Store - by default in the header. | WebInfo
NVARCHAR2(2000) Text |
| Web Store EMail | EMail address used as the sender (From) | The EMail address is used to send mails to useres of the web store | WStoreEMail
NVARCHAR2(60) String |
| Web Order EMail | EMail address to receive notifications when web orders were processed | When processig a web order, a confirmation is sent to the EMail addess of the customer from the request EMail address copying this email address when entered. | WebOrderEMail
NVARCHAR2(60) String |
| WebStore User | User ID of the Web Store EMail address | User ID to connect to the Mail Server | WStoreUser
NVARCHAR2(60) String |
| WebStore Password | Password of the Web Store EMail address | Password to connect to the Mail Server | WStoreUserPW
NVARCHAR2(20) String |
| EMail Header | Header added to EMails | The header is added to every email. | EMailHeader
NVARCHAR2(2000) Text |
| EMail Footer | Footer added to EMails | The footer is added to every email. | EMailFooter
NVARCHAR2(2000) Text |
| Menu Orders | Show Menu Orders | IsMenuOrders
CHAR(1) YesNo | |
| Menu Shipments | Show Menu Shipments | IsMenuShipments
CHAR(1) YesNo | |
| Menu Invoices | Show Menu Invoices | IsMenuInvoices
CHAR(1) YesNo | |
| Menu Assets | Show Menu Assets | IsMenuAssets
CHAR(1) YesNo | |
| Menu Payments | Show Menu Payments | IsMenuPayments
CHAR(1) YesNo | |
| Menu RfQs | Show Menu RfQs | IsMenuRfQs
CHAR(1) YesNo | |
| Menu Requests | Show Menu Requests | IsMenuRequests
CHAR(1) YesNo | |
| Menu Registrations | Show Menu Registrations | IsMenuRegistrations
CHAR(1) YesNo | |
| Menu Interests | Show Menu Interests | IsMenuInterests
CHAR(1) YesNo | |
| Menu Contact | Show Menu Contact | IsMenuContact
CHAR(1) YesNo | |
| Web Parameter 1 | Web Site Parameter 1 (default: header image) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam1 - By default, it is positioned on the upper left side with 130 pixel width. | WebParam1
NVARCHAR2(2000) Text |
| Web Parameter 2 | Web Site Parameter 2 (default index page) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam2 - By default, it is positioned after the header on the web store index page. | WebParam2
NVARCHAR2(2000) Text |
| Web Parameter 3 | Web Site Parameter 3 (default left - menu) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam3 - By default, it is positioned at the end in the menu column with 130 pixel width. | WebParam3
NVARCHAR2(2000) Text |
| Web Parameter 4 | Web Site Parameter 4 (default footer left) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam4 - By default, it is positioned on the left side of the footer with 130 pixel width. | WebParam4
NVARCHAR2(2000) Text |
| Web Parameter 5 | Web Site Parameter 5 (default footer center) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam5 - By default, it is positioned in the center of the footer. | WebParam5
NVARCHAR2(2000) Text |
| Web Parameter 6 | Web Site Parameter 6 (default footer right) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam6 - By default, it is positioned on the right side of the footer. | WebParam6
NVARCHAR2(2000) Text |
Tab: Store Translation
Description :
Help :
Table Name : W_Store_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 Store | A Web Store of the Client | W_Store_ID
NUMBER(10) TableDir | |
| Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
| 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 |
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated
CHAR(1) YesNo |
| Web Store Info | Web Store Header Information | Display HTML Info in the Web Store - by default in the header. | WebInfo
NVARCHAR2(2000) Text |
| EMail Header | Header added to EMails | The header is added to every email. | EMailHeader
NVARCHAR2(2000) Text |
| EMail Footer | Footer added to EMails | The footer is added to every email. | EMailFooter
NVARCHAR2(2000) Text |
| Web Parameter 1 | Web Site Parameter 1 (default: header image) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam1 - By default, it is positioned on the upper left side with 130 pixel width. | WebParam1
NVARCHAR2(2000) Text |
| Web Parameter 2 | Web Site Parameter 2 (default index page) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam2 - By default, it is positioned after the header on the web store index page. | WebParam2
NVARCHAR2(2000) Text |
| Web Parameter 3 | Web Site Parameter 3 (default left - menu) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam3 - By default, it is positioned at the end in the menu column with 130 pixel width. | WebParam3
NVARCHAR2(2000) Text |
| Web Parameter 4 | Web Site Parameter 4 (default footer left) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam4 - By default, it is positioned on the left side of the footer with 130 pixel width. | WebParam4
NVARCHAR2(2000) Text |
| Web Parameter 5 | Web Site Parameter 5 (default footer center) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam5 - By default, it is positioned in the center of the footer. | WebParam5
NVARCHAR2(2000) Text |
| Web Parameter 6 | Web Site Parameter 6 (default footer right) | The parameter could be used in the JSP page for variables like logos, passwords, URLs or entire HTML blocks. The access is via ctx.webParam6 - By default, it is positioned on the right side of the footer. | WebParam6
NVARCHAR2(2000) Text |
Tab: Web Store Message
Description : Definine Web Store Messages
Help :
Table Name : W_MailMsg
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 Store | A Web Store of the Client | W_Store_ID
NUMBER(10) TableDir | |
| Message Type | Mail Message Type | MailMsgType
CHAR(2) List | |
| 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 |
| Subject | Email Message Subject | Subject of the EMail | Subject
NVARCHAR2(255) Text |
| Message | EMail Message | Message of the EMail | Message
NVARCHAR2(2000) Text |
| Message 2 | Optional second part of the EMail Message | Message of the EMail | Message2
NVARCHAR2(2000) Text |
| Message 3 | Optional third part of the EMail Message | Message of the EMail | Message3
NVARCHAR2(2000) Text |
Tab: Message Translation
Description :
Help :
Table Name : W_MailMsg_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 |
| Mail Message | Web Store Mail Message Template | W_MailMsg_ID
NUMBER(10) TableDir | |
| Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
| 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 |
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated
CHAR(1) YesNo |
| Subject | Email Message Subject | Subject of the EMail | Subject
NVARCHAR2(255) Text |
| Message | EMail Message | Message of the EMail | Message
NVARCHAR2(2000) Text |
| Message 2 | Optional second part of the EMail Message | Message of the EMail | Message2
NVARCHAR2(2000) Text |
| Message 3 | Optional third part of the EMail Message | Message of the EMail | Message3
NVARCHAR2(2000) Text |
