SalesOrdersForOrderHublineschannelPrograms
SalesOrdersForOrderHublineschannelPrograms
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublineschannelPrograms |
| LinesFulfillLineId [KEY] | Long | LinesFulfillLineId of SalesOrdersForOrderHublineschannelPrograms |
| IncentiveEntityTypeCode | String | IncentiveEntityTypeCode of SalesOrdersForOrderHublineschannelPrograms |
| IncentiveEntitySubtypeCode | String | IncentiveEntitySubtypeCode of SalesOrdersForOrderHublineschannelPrograms |
| IncentiveId [KEY] | Long | IncentiveId of SalesOrdersForOrderHublineschannelPrograms |
| SourceIncentiveId | String | SourceIncentiveId of SalesOrdersForOrderHublineschannelPrograms |
| ProgramCode | String | ProgramCode of SalesOrdersForOrderHublineschannelPrograms |
| ProgramId | String | ProgramId of SalesOrdersForOrderHublineschannelPrograms |
| ProgramName | String | ProgramName of SalesOrdersForOrderHublineschannelPrograms |
| ProgramDetails | String | ProgramDetails of SalesOrdersForOrderHublineschannelPrograms |
| ProgramTypeName | String | ProgramTypeName of SalesOrdersForOrderHublineschannelPrograms |
| ProgramLine | String | ProgramLine of SalesOrdersForOrderHublineschannelPrograms |
| ProgramLineId | String | ProgramLineId of SalesOrdersForOrderHublineschannelPrograms |
| ProgramDescription | String | ProgramDescription of SalesOrdersForOrderHublineschannelPrograms |
| ApplyType | String | ApplyType of SalesOrdersForOrderHublineschannelPrograms |
| ManuallyAppliedFlag | Bool | ManuallyAppliedFlag of SalesOrdersForOrderHublineschannelPrograms |
| ItemLevelCode | String | ItemLevelCode of SalesOrdersForOrderHublineschannelPrograms |
| ItemLevel | String | ItemLevel of SalesOrdersForOrderHublineschannelPrograms |
| StatusCode | String | StatusCode of SalesOrdersForOrderHublineschannelPrograms |
| Status | String | Status of SalesOrdersForOrderHublineschannelPrograms |
| DiscountTypeCode | String | DiscountTypeCode of SalesOrdersForOrderHublineschannelPrograms |
| DiscountType | String | DiscountType of SalesOrdersForOrderHublineschannelPrograms |
| DeclinableFlag | Bool | DeclinableFlag of SalesOrdersForOrderHublineschannelPrograms |
| DeclineReasonCode | String | DeclineReasonCode of SalesOrdersForOrderHublineschannelPrograms |
| DeclineReason | String | DeclineReason of SalesOrdersForOrderHublineschannelPrograms |
| DiscountAmount | Long | DiscountAmount of SalesOrdersForOrderHublineschannelPrograms |
| StartDate | Date | StartDate of SalesOrdersForOrderHublineschannelPrograms |
| EndDate | Date | EndDate of SalesOrdersForOrderHublineschannelPrograms |
| Comments | String | Comments of SalesOrdersForOrderHublineschannelPrograms |
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 |