SalesOrdersForOrderHublinestransactionItemAttributes
SalesOrdersForOrderHublinestransactionItemAttributes
Columns
Name | Type | Description |
SalesOrdersForOrderHubHeaderId [KEY] | Long | SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinestransactionItemAttributes |
LinesFulfillLineId [KEY] | Long | LinesFulfillLineId of SalesOrdersForOrderHublinestransactionItemAttributes |
CharacterAttributeValue | String | Character value for the transaction item attribute (TIA). |
DateAttributeValue | Date | Date value for the transaction item attribute (TIA). |
NumberAttributeValue | Double | Number value for the transaction item attribute (TIA). |
SourceTransactionLineAttributeId | String | Value that uniquely identifies the transaction item attribute on the fulfillment line. The source application assigns this value. |
TimestampAttributeValue | Datetime | Time value for the transaction item attribute (TIA). |
TransactionAttributeId [KEY] | Long | TransactionAttributeId of SalesOrdersForOrderHublinestransactionItemAttributes |
TransactionAttributeName | String | Name of the transaction item attribute. |
TransactionAttributeMetadataid | Long | Value that identifies the transaction item attribute (TIA) that stores the metadata. |
TransactionItemAttributeId | Long | Value that identifies the transaction item attribute (TIA). |
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 |