Web Store
W_Store
A Web Store of the Client
Overview
| Table Name | W_Store |
|---|---|
| Access Level | System + Client |
| Entity Type | WSTORE |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_OrgTrx |
| Wiki | View on iDempiere Wiki |
Columns (71)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AD_OrgTrx_ID |
Table(22) | No | - | Performing or initiating organization |
AvailabilityRule |
List(4) | No | D | - |
C_DocTypeStandardOrder_ID |
Table(10) | No | - | Document type used for Standard Sales Orders |
CM_WebProject_ID |
Table Direct(10) | No | - | A web project is the main data container for Containers, URLs, Ads, Media etc. |
C_OrderSource_ID |
Table Direct(10) | No | - | - |
C_Vocabulary_ID |
Table Direct(22) | No | - | Define Top level (root) for Classifications |
DeliveryViaRule |
List(1) | Yes | S | How the order will be delivered |
IsInDispute_Default |
List(1) | Yes | N | Default Value for Document Is In Dispute |
IsShowStock |
Yes-No(1) | No | N | Defines if Business Partner can see Stock |
IsSummary |
Yes-No(1) | No | N | This is a summary entity |
MaintainProductAssign |
List(2) | Yes | N | Maintain Product - Web Store assignment |
M_PriceList_Version_ID |
Search(10) | No | - | Identifies a unique instance of a Price List |
M_Shipper_ID |
Search(10) | No | - | Method or manner of product delivery |
Parent_ID |
Table(10) | No | - | Parent of Entity |
PaymentRule |
List(1) | Yes | P | How you pay the invoice |
Phone |
String(40) | No | - | Identifies a telephone number |
Stylesheet |
String(60) | No | - | CSS (Stylesheet) used |
Type |
List(2) | No | - | Type of Validation (SQL, Java Script, Java Language) |
URL_Facebook |
URL(250) | No | - | URL |
URL_LinkedIn |
URL(250) | No | - | URL |
URL_Twitter |
URL(250) | No | - | URL |
Value |
String(40) | No | - | Search key for the record in the format required - must be unique |
W_BasketExpireInHours |
Integer(10) | No | - | - |
W_PublishRule_ID |
Table Direct(22) | No | - | Rules for publishing on Web Store |
W_StoreBasketMaxCount |
Integer(10) | No | - | - |
Wstore_Default_Child_ID |
Table(10) | No | - | Default Child of a WebStore |
WStoreDeployment |
String(40) | No | - | Webstore Deployment Identifier |
W_Store_Freight_ID |
Table Direct(22) | No | - | - |
WStorePlatfom |
List(5) | No | - | Define Web store is internal or external integration based |
Name |
String(60) | Yes | - | Alphanumeric identifier of the entity |
AD_Client_ID |
Table Direct(10) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(10) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
C_PaymentTerm_ID |
Table Direct(10) | No | - | The terms of Payment (timing, discount) |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(10) | Yes | - | User who created this records |
Description |
String(255) | No | - | Optional short description of the record |
EMailFooter |
Text(2000) | No | - | Footer added to EMails |
EMailHeader |
Text(2000) | No | - | Header added to EMails |
Help |
Text(2000) | No | - | Comment or Hint |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsDefault |
Yes-No(1) | Yes | - | Default value |
IsMenuAssets |
Yes-No(1) | Yes | Y | Show Menu Assets |
IsMenuContact |
Yes-No(1) | Yes | Y | Show Menu Contact |
IsMenuInterests |
Yes-No(1) | Yes | Y | Show Menu Interests |
IsMenuInvoices |
Yes-No(1) | Yes | Y | Show Menu Invoices |
IsMenuOrders |
Yes-No(1) | Yes | Y | Show Menu Orders |
IsMenuPayments |
Yes-No(1) | Yes | Y | Show Menu Payments |
IsMenuRegistrations |
Yes-No(1) | Yes | Y | Show Menu Registrations |
IsMenuRequests |
Yes-No(1) | Yes | Y | Show Menu Requests |
IsMenuRfQs |
Yes-No(1) | Yes | Y | Show Menu RfQs |
IsMenuShipments |
Yes-No(1) | Yes | Y | Show Menu Shipments |
M_PriceList_ID |
Search(10) | No | - | Unique identifier of a Price List |
M_Warehouse_ID |
Table Direct(10) | No | - | Storage Warehouse and Service Point |
SalesRep_ID |
Search(10) | Yes | - | Sales Representative or Company Agent |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(10) | Yes | - | User who updated this records |
URL |
URL(120) | No | - | URL |
WebContext |
String(20) | Yes | - | Web Server Context - e.g. /wstore |
WebInfo |
Text(2000) | No | - | Web Store Header Information |
WebOrderEMail |
String(60) | No | - | EMail address to receive notifications when web orders were processed |
WebParam1 |
Text(2000) | No | - | Web Site Parameter 1 (default: header image) |
WebParam2 |
Text(2000) | No | - | Web Site Parameter 2 (default index page) |
WebParam3 |
Text(2000) | No | - | Web Site Parameter 3 (default left - menu) |
WebParam4 |
Text(2000) | No | - | Web Site Parameter 4 (default footer left) |
WebParam5 |
Text(2000) | No | - | Web Site Parameter 5 (default footer center) |
WebParam6 |
Text(2000) | No | - | Web Site Parameter 6 (default footer right) |
WStoreEMail |
String(60) | No | - | EMail address used as the sender (From) |
W_Store_ID |
ID(10) | Yes | - | A Web Store of the Tenant |
WStoreUser |
String(60) | No | - | User ID of the Web Store EMail address |
WStoreUserPW |
String(20) | No | - | Password of the Web Store EMail address |
W_Store_UU |
String(36) | No | - | - |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_OrgTrx_ID |
AD_OrgTrx.AD_OrgTrx_ID | Performing or initiating organization |
C_DocTypeStandardOrder_ID |
C_DocTypeStandardOrder.C_DocTypeStandardOrder_ID | Document type used for Standard Sales Orders |
CM_WebProject_ID |
CM_WebProject.CM_WebProject_ID | A web project is the main data container for Containers, URLs, Ads, Media etc. |
C_OrderSource_ID |
C_OrderSource.C_OrderSource_ID | - |
C_Vocabulary_ID |
C_Vocabulary.C_Vocabulary_ID | Define Top level (root) for Classifications |
M_PriceList_Version_ID |
M_PriceList_Version.M_PriceList_Version_ID | Identifies a unique instance of a Price List |
M_Shipper_ID |
M_Shipper.M_Shipper_ID | Method or manner of product delivery |
Parent_ID |
Parent.Parent_ID | Parent of Entity |
W_PublishRule_ID |
W_PublishRule.W_PublishRule_ID | Rules for publishing on Web Store |
Wstore_Default_Child_ID |
Wstore_Default_Child.Wstore_Default_Child_ID | Default Child of a WebStore |
W_Store_Freight_ID |
W_Store_Freight.W_Store_Freight_ID | - |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
C_PaymentTerm_ID |
C_PaymentTerm.C_PaymentTerm_ID | The terms of Payment (timing, discount) |
M_PriceList_ID |
M_PriceList.M_PriceList_ID | Unique identifier of a Price List |
M_Warehouse_ID |
M_Warehouse.M_Warehouse_ID | Storage Warehouse and Service Point |
SalesRep_ID |
SalesRep.SalesRep_ID | Sales Representative or Company Agent |
Generated on 2026-05-03T16:37:15.142047710Z