SalesOrdersForOrderHubshipToCustomer
Manages customer shipping information for all orders under the sales order hub.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the shipping information to the overall order in the system. |
| AddressId [KEY] | Long | Unique identifier for the ship-to customer address, ensuring the correct shipping address is linked to the order. |
| PartyId | Long | Unique identifier for the party responsible for receiving the shipment, allowing for efficient tracking and fulfillment. |
| PartyName | String | Name of the party receiving the shipment, providing clarity for customer service and delivery purposes. |
| PartyNumber | String | Telephone number of the ship-to party, used for contacting the recipient regarding shipment or delivery details. |
| PersonFirstName | String | First name of the person to contact at the ship-to address, used for addressing the contact directly. |
| PersonMiddleName | String | Middle name of the person to contact at the ship-to address, providing additional identification details. |
| PersonLastName | String | Last name of the person to contact at the ship-to address, ensuring the correct recipient is identified. |
| PersonNameSuffix | String | Suffix (for example, Jr., Sr., III) of the person to contact at the ship-to address, further specifying the identity of the recipient. |
| PersonTitle | String | Title of the person to contact at the ship-to address, such as Mr., Mrs., Dr., used for formal communication. |
| SiteId | Long | Unique identifier for the specific ship-to customer address, ensuring the address is tracked at the site level. |
| Address1 | String | First line of the ship-to customer address, where the street address is recorded. |
| Address2 | String | Second line of the ship-to customer address, typically used for apartment numbers or additional address details. |
| Address3 | String | Third line of the ship-to customer address, often used for additional address information if needed. |
| Address4 | String | Fourth line of the ship-to customer address, utilized for any additional details necessary for precise delivery. |
| City | String | City of the ship-to customer address, helping identify the geographical location for delivery. |
| State | String | State of the ship-to customer address, ensuring the delivery service can route shipments correctly. |
| PostalCode | String | Postal code of the ship-to customer address, critical for accurate and timely deliveries. |
| County | String | County of the ship-to customer address, further detailing the geographical location. |
| Province | String | Province of the ship-to customer address, providing additional detail for international deliveries. |
| Country | String | Country of the ship-to customer address, identifying the nation for international shipping purposes. |
| ContactId | Long | Unique identifier for the contact at the ship-to party site, linking specific contact details to the shipment. |
| ContactName | String | Full name of the person to contact at the ship-to party site, ensuring clear communication with the recipient. |
| ContactNumber | String | Telephone number for contacting the person at the ship-to party site, facilitating communication during the shipping process. |
| ContactFirstName | String | First name of the person to contact at the ship-to party site, aiding in the identification of the recipient. |
| ContactMiddleName | String | Middle name of the person to contact at the ship-to party site, providing further identification. |
| ContactLastName | String | Last name of the person to contact at the ship-to party site, used for formal communication. |
| ContactNameSuffix | String | Suffix (for example, Jr. or Sr.) of the person to contact at the ship-to party site, providing additional identification. |
| ContactTitle | String | Title of the person to contact at the ship-to party site, such as Mr., Mrs., or Dr., used for professional communication. |
| PreferredContactPointId | Long | Unique identifier for the preferred method of communication (such as email) for the person to contact at the ship-to party site. |
| SourceAddressId | String | Unique identifier for the ship-to customer address in the source system, used for mapping and integration purposes. |
| Finder | String | Method or tool used to locate specific shipping details in the system, enabling efficient retrieval and management of data. |
| FromDate | Date | Start date when the ship-to customer details are valid, ensuring accurate tracking from this point onward. |
| HeaderId | Long | Header ID linking the shipping information to the sales order, helping maintain consistency across the order lifecycle. |
| OrderKey | String | Unique key used to reference the sales order associated with the ship-to customer, ensuring all related transactions are tracked. |
| OrderNumber | String | Order number used to identify the sales order, providing an essential reference for sales, shipping, and customer service. |
| SourceTransactionNumber | String | Transaction number from the source system, linking the ship-to customer data to its originating transaction for consistency. |
| SourceTransactionSystem | String | Name of the source system from which the ship-to customer data originated, helping integrate with external systems. |
| ToDate | Date | End date when the ship-to customer details are no longer valid, marking the expiration of the shipping information. |