SalesOrdersForOrderHublineslineDetails
SalesOrdersForOrderHublineslineDetails
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublineslineDetails |
| LinesFulfillLineId [KEY] | Long | LinesFulfillLineId of SalesOrdersForOrderHublineslineDetails |
| ActualDeliveryDate | Datetime | ActualDeliveryDate of SalesOrdersForOrderHublineslineDetails |
| AvailabilityShipDate | Datetime | AvailabilityShipDate of SalesOrdersForOrderHublineslineDetails |
| BillOfLadingNumber | String | BillOfLadingNumber of SalesOrdersForOrderHublineslineDetails |
| BillingTransactionAmount | Double | BillingTransactionAmount of SalesOrdersForOrderHublineslineDetails |
| BillingTransactionDate | Datetime | BillingTransactionDate of SalesOrdersForOrderHublineslineDetails |
| BillingTransactionNumber | String | BillingTransactionNumber of SalesOrdersForOrderHublineslineDetails |
| CustomerTransactionLineId | Long | CustomerTransactionLineId of SalesOrdersForOrderHublineslineDetails |
| DeliveryName | String | DeliveryName of SalesOrdersForOrderHublineslineDetails |
| ExceptionFlag | Bool | ExceptionFlag of SalesOrdersForOrderHublineslineDetails |
| FulfillLineDetailId [KEY] | Long | FulfillLineDetailId of SalesOrdersForOrderHublineslineDetails |
| Quantity | Double | Quantity of SalesOrdersForOrderHublineslineDetails |
| SecondaryQuantity | Double | SecondaryQuantity of SalesOrdersForOrderHublineslineDetails |
| RMAReceiptDate | Date | RMAReceiptDate of SalesOrdersForOrderHublineslineDetails |
| RMAReceiptDateTime | Datetime | RMAReceiptDateTime of SalesOrdersForOrderHublineslineDetails |
| RMAReceiptLineNumber | String | RMAReceiptLineNumber of SalesOrdersForOrderHublineslineDetails |
| RMAReceiptNumber | String | RMAReceiptNumber of SalesOrdersForOrderHublineslineDetails |
| RMAReceiptTransactionId | String | RMAReceiptTransactionId of SalesOrdersForOrderHublineslineDetails |
| StatusCode | String | StatusCode of SalesOrdersForOrderHublineslineDetails |
| Status | String | Status of SalesOrdersForOrderHublineslineDetails |
| StatusAsOfDate | Datetime | StatusAsOfDate of SalesOrdersForOrderHublineslineDetails |
| TaskType | String | TaskType of SalesOrdersForOrderHublineslineDetails |
| TrackingNumber | String | TrackingNumber of SalesOrdersForOrderHublineslineDetails |
| TradeComplianceCode | String | TradeComplianceCode of SalesOrdersForOrderHublineslineDetails |
| TradeComplianceExplanation | String | TradeComplianceExplanation of SalesOrdersForOrderHublineslineDetails |
| TradeComplianceResultCode | String | TradeComplianceResultCode of SalesOrdersForOrderHublineslineDetails |
| TradeComplianceTypeCode | String | TradeComplianceTypeCode of SalesOrdersForOrderHublineslineDetails |
| TradeComplianceType | String | TradeComplianceType of SalesOrdersForOrderHublineslineDetails |
| WaybillNumber | String | WaybillNumber of SalesOrdersForOrderHublineslineDetails |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| FromDate | Date | FromDate |
| HeaderId | String | HeaderId |
| OrderKey | String | OrderKey |
| OrderNumber | String | OrderNumber |
| SourceTransactionNumber | String | SourceTransactionNumber |
| SourceTransactionSystem | String | SourceTransactionSystem |
| ToDate | Date | ToDate |
| Finder | String | finder |