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
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 |