ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175