OrderFeeLines
Retrieve the fee lines for an order.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns support
only the = comparison, unless stated otherwise. The available column for this table is: OrderId. All other columns are processed client side.
If the 'OrderId' filter is not specified, the 本製品 will fetch a list of all the orders and perform a request for each order in the list.
SELECT * FROM OrderFeeLines WHERE OrderId = 21
Columns
Name | Type | References | Description |
Id [KEY] | Long | Item ID. | |
Name | String | Fee name. | |
TaxClass | String | Tax class of fee. | |
TaxStatus | String | Tax status of fee. Options: taxable and none. | |
Total | String | Line total (after discounts). | |
TotalTax | String | Line total tax (after discounts). | |
Taxes | String | Line taxes. See Order - Taxes properties read-only | |
MetaData | String | Meta data. See Order - Meta data properties | |
OrderId | String |
Orders.Id | Id of the order. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |