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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
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 |