Web Basket
W_Basket
Web Basket
Overview
| Table Name | W_Basket |
|---|---|
| Access Level | Client Only |
| Entity Type | WSTORE |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_Client |
| Wiki | View on iDempiere Wiki |
Columns (45)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AD_Client_ID |
Search(22) | Yes | - | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | - | Organizational entity within tenant |
AD_User_ID |
Table(22) | Yes | - | User within the system - Internal or Business Partner Contact |
Bill_BPartner_ID |
Search(10) | No | - | Business Partner to be invoiced |
Bill_Location_ID |
Search(10) | No | - | Business Partner Location for invoicing |
Bill_User_ID |
Search(10) | No | - | Business Partner Contact for invoicing |
C_BPartner_ID |
Search(22) | No | - | Identifies a Business Partner |
C_BPartner_Location_ID |
Search(10) | No | - | Identifies the (ship to) address for this Business Partner |
C_Currency_ID |
Search(10) | No | - | The Currency for this record |
C_Order_ID |
Search(10) | No | - | Order |
C_PaymentTerm_ID |
Search(10) | No | - | The terms of Payment (timing, discount) |
C_POSTenderType_ID |
Search(10) | No | - | - |
CreatedBy |
Search(22) | Yes | - | User who created this records |
DeliveryViaRule |
List(1) | No | - | How the order will be delivered |
Description |
String(255) | No | - | Optional short description of the record |
DiscountAmt |
Amount(22) | Yes | 0 | Calculated amount of discount |
EMail |
String(60) | No | - | Electronic Mail Address |
FreightAmt |
Amount(10) | Yes | 0 | Freight Amount |
FreightCostRule |
List(1) | No | - | Method for charging Freight |
GrandTotal |
Amount(32) | No | 0 | Total amount of document |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
LinesCount |
Integer(10) | Yes | 0 | Counted Lines in Document |
M_FreightCategory_ID |
Search(10) | No | - | Category of the Freight |
M_PriceList_ID |
Search(22) | No | - | Unique identifier of a Price List |
M_Shipper_ID |
Search(10) | No | - | Method or manner of product delivery |
M_Warehouse_ID |
Search(10) | Yes | @SQL=SELECT M_Warehouse_ID FROM W_Store WHERE W_Store_ID=@W_Store_ID@ | Storage Warehouse and Service Point |
PaymentRule |
List(1) | No | - | How you pay the invoice |
POReference |
String(20) | No | - | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner |
Postal_Location_ID |
Search(10) | No | - | Business Partner Location for Mailing |
Processed |
Yes-No(1) | No | N | The document has been processed |
ProcessedOn |
Number(20) | No | - | The date+time (expressed in decimal format) when the document has been processed |
SalesRep_ID |
Table(10) | No | - | Sales Representative or Company Agent |
TotalLines |
Number(32) | No | 0 | Total of all document lines |
TotalQty |
Quantity(22) | Yes | 0 | Total Quantity |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
UserInstance |
String(36) | No | - | - |
W_BasketExpiredOn |
Date+Time(7) | No | - | - |
WebBasketType |
List(4) | Yes | G | - |
W_Store_Freight_ID |
Table Direct(22) | No | - | - |
W_Store_ID |
Table(10) | Yes | - | A Web Store of the Tenant |
Session_ID |
ID(60) | No | - | - |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
W_Basket_ID |
ID(22) | Yes | - | Web Basket |
W_Basket_UU |
String(36) | No | - | - |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
AD_User_ID |
AD_User.AD_User_ID | User within the system - Internal or Business Partner Contact |
Bill_BPartner_ID |
Bill_BPartner.Bill_BPartner_ID | Business Partner to be invoiced |
Bill_Location_ID |
Bill_Location.Bill_Location_ID | Business Partner Location for invoicing |
Bill_User_ID |
Bill_User.Bill_User_ID | Business Partner Contact for invoicing |
C_BPartner_ID |
C_BPartner.C_BPartner_ID | Identifies a Business Partner |
C_BPartner_Location_ID |
C_BPartner_Location.C_BPartner_Location_ID | Identifies the (ship to) address for this Business Partner |
C_Currency_ID |
C_Currency.C_Currency_ID | The Currency for this record |
C_Order_ID |
C_Order.C_Order_ID | Order |
C_PaymentTerm_ID |
C_PaymentTerm.C_PaymentTerm_ID | The terms of Payment (timing, discount) |
C_POSTenderType_ID |
C_POSTenderType.C_POSTenderType_ID | - |
M_FreightCategory_ID |
M_FreightCategory.M_FreightCategory_ID | Category of the Freight |
M_PriceList_ID |
M_PriceList.M_PriceList_ID | Unique identifier of a Price List |
M_Shipper_ID |
M_Shipper.M_Shipper_ID | Method or manner of product delivery |
M_Warehouse_ID |
M_Warehouse.M_Warehouse_ID | Storage Warehouse and Service Point |
Postal_Location_ID |
Postal_Location.Postal_Location_ID | Business Partner Location for Mailing |
SalesRep_ID |
SalesRep.SalesRep_ID | Sales Representative or Company Agent |
W_Store_Freight_ID |
W_Store_Freight.W_Store_Freight_ID | - |
W_Store_ID |
W_Store.W_Store_ID | A Web Store of the Tenant |
Session_ID |
Session.Session_ID | - |
Generated on 2026-05-03T18:01:44.054183786Z