JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

SalesOrdersForOrderHublinesshipToCustomer

The Ship-to Customers resource manages the ship-to customer that the sales order header references.

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.
Finder String Finder of SalesOrdersForOrderHublinesshipToCustomer
FromDate Date FromDate of SalesOrdersForOrderHublinesshipToCustomer
HeaderId Long HeaderId of SalesOrdersForOrderHublinesshipToCustomer
OrderKey String OrderKey of SalesOrdersForOrderHublinesshipToCustomer
OrderNumber String OrderNumber of SalesOrdersForOrderHublinesshipToCustomer
SourceTransactionNumber String SourceTransactionNumber of SalesOrdersForOrderHublinesshipToCustomer
SourceTransactionSystem String SourceTransactionSystem of SalesOrdersForOrderHublinesshipToCustomer
ToDate Date ToDate of SalesOrdersForOrderHublinesshipToCustomer

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060