SalesOrdersForOrderHublinespriceAdjustments
SalesOrdersForOrderHublinespriceAdjustments
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinespriceAdjustments |
| LinesFulfillLineId [KEY] | Long | LinesFulfillLineId of SalesOrdersForOrderHublinespriceAdjustments |
| PriceAdjustmentId [KEY] | Long | PriceAdjustmentId of SalesOrdersForOrderHublinespriceAdjustments |
| AdjustmentName | String | AdjustmentName of SalesOrdersForOrderHublinespriceAdjustments |
| Amount | Double | Amount of SalesOrdersForOrderHublinespriceAdjustments |
| AdjustmentTypeCode | String | AdjustmentTypeCode of SalesOrdersForOrderHublinespriceAdjustments |
| AdjustmentType | String | AdjustmentType of SalesOrdersForOrderHublinespriceAdjustments |
| InvoicedFlag | Bool | InvoicedFlag of SalesOrdersForOrderHublinespriceAdjustments |
| OrigSystemAdjustmentReference | String | OrigSystemAdjustmentReference of SalesOrdersForOrderHublinespriceAdjustments |
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 |