SalesOrdersForOrderHublinesshipToCustomer
Records shipping customer details linked to sales orders for accurate delivery.
Columns
Name | Type | Description |
SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the ship-to customer details to the overall order. This ensures that the shipping information is properly tracked and associated with the correct order. |
LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the ship-to customer details, enabling tracking of shipping at the line level within the order. |
AddressId [KEY] | Long | Unique identifier for the ship-to customer address, helping to pinpoint the location where the goods will be shipped. |
PartyId | Long | Unique identifier for the party receiving the goods, ensuring that shipping details are correctly attributed to the recipient. |
PartyName | String | Name of the party receiving the shipment. This is the entity or individual to whom the items are being shipped. |
PartyNumber | String | Telephone number of the ship-to party, used for contact purposes related to shipping. |
PersonFirstName | String | First name of the person to contact at the ship-to customer site, used for personalized communication during the delivery process. |
PersonMiddleName | String | Middle name of the person to contact at the ship-to customer site, used for identification purposes. |
PersonLastName | String | Last name of the person to contact at the ship-to customer site, used for identification and communication. |
PersonNameSuffix | String | Suffix of the person to contact at the ship-to customer site (for example, Jr., Sr., III), used for formal address in communication. |
PersonTitle | String | Title of the person to contact at the ship-to customer site (for example, Mr., Mrs., Dr.), used for formal address in communications. |
SiteId | Long | Unique identifier for the ship-to customer address site, used for associating address details with the corresponding order. |
Address1 | String | First line of the ship-to customer address, typically the street address or P.O. box. |
Address2 | String | Second line of the ship-to customer address, typically used for additional address details such as apartment or suite numbers. |
Address3 | String | Third line of the ship-to customer address, typically used for additional address details, if needed. |
Address4 | String | Fourth line of the ship-to customer address, used for extended address details in some cases. |
City | String | City of the ship-to customer address, essential for delivering goods to the correct location. |
State | String | State of the ship-to customer address, required for accurate delivery and proper addressing. |
PostalCode | String | Postal code of the ship-to customer address, assisting in the accurate delivery of goods. |
County | String | County of the ship-to customer address, helping to further specify the delivery area. |
Province | String | Province of the ship-to customer address, important for geographical and regional delivery routing. |
Country | String | Country of the ship-to customer address, crucial for international shipments and customs clearance. |
ContactId | Long | Unique identifier for the contact person at the ship-to party site, ensuring that communication is directed to the correct person. |
ContactName | String | Full name of the person to contact at the ship-to party site, used for personalized contact information. |
ContactNumber | String | Telephone number of the contact person at the ship-to party site, enabling direct communication regarding shipment. |
ContactFirstName | String | First name of the contact person at the ship-to party site, used for addressing the person directly. |
ContactMiddleName | String | Middle name of the contact person at the ship-to party site, if available, for better identification. |
ContactLastName | String | Last name of the contact person at the ship-to party site, for formal identification. |
ContactNameSuffix | String | Suffix of the contact person at the ship-to party site (for example, Jr., Sr., III), used for formal communication. |
ContactTitle | String | Title of the contact person at the ship-to party site (for example, Mr., Mrs., Dr.), used in addressing the person formally. |
PreferredContactPointId | Long | Unique identifier for the preferred method of contact (for example, email, phone) for the contact person at the ship-to party site. |
SourceAddressId | String | Unique identifier for the ship-to customer address, with a default value of 1 to help with address integration from source systems. |
Finder | String | Method or tool used to locate specific ship-to customer records in the system, enabling efficient retrieval of shipping information. |
FromDate | Date | The start date when the ship-to customer address becomes valid for use in the order fulfillment process. |
HeaderId | Long | Unique identifier for the header of the ship-to customer details, ensuring proper linkage to the overall sales order. |
OrderKey | String | Unique key used to reference the sales order associated with the ship-to customer details, ensuring proper tracking of related transactions. |
OrderNumber | String | Unique number assigned to the sales order, used for referencing the order and the associated shipping details. |
SourceTransactionNumber | String | Transaction number from the source system, linking the ship-to customer details to the originating transaction, ensuring consistency when integrating with external systems. |
SourceTransactionSystem | String | Source system name from which the ship-to customer data originated, helping ensure integration with external platforms. |
ToDate | Date | End date when the ship-to customer address is no longer valid for use, marking the expiration of the address in the order fulfillment process. |