SalesOrdersForOrderHublinesshipToCustomer
SalesOrdersForOrderHublinesshipToCustomer
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinesshipToCustomer |
| LinesFulfillLineId [KEY] | Long | LinesFulfillLineId of SalesOrdersForOrderHublinesshipToCustomer |
| AddressId [KEY] | Long | Value that uniquely identifies the ship-to customer address. |
| PartyId | Long | Value that uniquely identifies the ship-to party. |
| PartyName | String | Name of the ship-to party. |
| PartyNumber | String | Telephone number of the ship-to party. |
| PersonFirstName | String | First name of the person to contact at the ship-to customer site. |
| PersonMiddleName | String | Middle name of the person to contact at the ship-to customer site. |
| PersonLastName | String | Last name of the person to contact at the ship-to customer site. |
| PersonNameSuffix | String | Name suffix of the person to contact at the ship-to customer site. |
| PersonTitle | String | Title of the person to contact at the ship-to customer site. |
| SiteId | Long | Value that uniquely identifies the ship-to customer address. |
| Address1 | String | First line of the ship-to customer address. |
| Address2 | String | Second line of the ship-to customer address. |
| Address3 | String | Third line of the ship-to customer address. |
| Address4 | String | Fourth line of the ship-to customer address. |
| City | String | City of the ship-to customer address. |
| State | String | State of the ship-to customer address. |
| PostalCode | String | City of the ship-to customer address. |
| County | String | County of the ship-to customer address. |
| Province | String | Province of the ship-to customer address. |
| Country | String | Country of the ship-to customer address. |
| ContactId | Long | Value that uniquely identifies the contact at the ship-to party site. |
| ContactName | String | Name of the person to contact at the ship-to party site. |
| ContactNumber | String | Telephone number of the person to contact at the ship-to party site. |
| ContactFirstName | String | First name of the person to contact at the ship-to party site. |
| ContactMiddleName | String | Middle name of the person to contact at the ship-to party site. |
| ContactLastName | String | Title name of the person to contact at the ship-to party site. |
| ContactNameSuffix | String | Name suffix of the person to contact at the ship-to party site. |
| ContactTitle | String | Title of the person to contact at the ship-to party site. |
| PreferredContactPointId | Long | Value that uniquely identifies the email for the preferred person to contact at the ship-to party site. |
| SourceAddressId | String | Value that uniquely identifies the ship-to customer address. Value is 1. |
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 |