ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHub

Enables creation, retrieval, and updating of sales orders, offering comprehensive order management capabilities.

Columns

Name Type Description
HeaderId [KEY] Long Unique identifier for the sales order header, used to reference and track the overall sales order in the system.
OrderNumber String The order number associated with the sales order, which is used for tracking and reference purposes.
SourceTransactionNumber String The number associated with the original source transaction from which this sales order was created.
SourceTransactionSystem String The system from which the original source transaction was initiated, providing context for the origin of the order.
SourceTransactionId String Unique identifier for the source transaction, helping to trace the sales order back to its origin.
BusinessUnitId Long The ID of the business unit associated with the sales order, helping to categorize and assign the order to the appropriate organizational unit.
BusinessUnitName String The name of the business unit responsible for managing the sales order, used for reporting and organizational purposes.
TransactionOn Datetime Timestamp for when the sales order transaction was created or processed.
BuyingPartyId Long The ID of the buying party (customer or organization) associated with the sales order.
BuyingPartyName String The name of the buying party involved in the sales order transaction.
BuyingPartyNumber String Unique identifier or number assigned to the buying party, used for tracking and reference.
BuyingPartyPersonFirstName String The first name of the individual representing the buying party in the transaction.
BuyingPartyPersonLastName String The last name of the individual representing the buying party in the transaction.
BuyingPartyPersonMiddleName String The middle name of the individual representing the buying party in the transaction.
BuyingPartyPersonNameSuffix String Suffix (for example, Jr., Sr.) of the individual representing the buying party in the transaction.
BuyingPartyPersonTitle String The title (for example, Mr., Ms., Dr.) of the individual representing the buying party in the transaction.
BuyingPartyContactId Long Unique identifier for the contact person associated with the buying party.
BuyingPartyContactName String Name of the contact person associated with the buying party.
BuyingPartyContactNumber String Contact number for the individual representing the buying party.
BuyingPartyContactFirstName String First name of the contact person associated with the buying party.
BuyingPartyContactLastName String Last name of the contact person associated with the buying party.
BuyingPartyContactMiddleName String Middle name of the contact person associated with the buying party.
BuyingPartyContactNameSuffix String Suffix (for example, Jr., Sr.) of the contact person representing the buying party.
BuyingPartyContactTitle String Title (for example, Mr., Ms., Dr.) of the contact person representing the buying party.
PreferredSoldToContactPointId Long The unique ID for the preferred contact point of the sold-to party, helping identify the main contact for the sales order.
CustomerPONumber String The customer's purchase order number associated with the sales order, used for tracking and reference.
TransactionTypeCode String Code representing the type of transaction for the sales order, helping categorize the transaction (for example, standard order, return).
TransactionType String The type of transaction (for example, order, return, credit) associated with the sales order.
SubstituteAllowedFlag Bool Flag indicating whether substitutes are allowed for the items in the sales order. If 'true', substitutes can be offered if needed.
PackingInstructions String Instructions related to the packing of the items in the sales order, often including special handling or packaging requests.
ShippingInstructions String Instructions for shipping, detailing how the items should be shipped or delivered.
ShipsetFlag Bool Flag indicating whether the sales order involves a shipset, where items are grouped together for shipping as a single unit.
PartialShipAllowedFlag Bool Flag indicating whether partial shipments are allowed for the sales order. If 'true', partial shipments are permitted.
RequestedShipDate Datetime The date on which the buyer has requested the items to be shipped.
RequestedArrivalDate Datetime The requested date for the items to arrive at the destination.
LatestAcceptableShipDate Datetime The latest date by which the order should be shipped, after which the order is considered late.
LatestAcceptableArrivalDate Datetime The latest date by which the items should arrive at the destination.
EarliestAcceptableShipDate Datetime The earliest date on which the items can be shipped, typically to ensure timely delivery.
ShipmentPriorityCode String Code indicating the priority level of the shipment, used to categorize orders based on urgency.
ShipmentPriority String The priority level for shipping the order, which can influence the shipping method and timing.
ShippingCarrierId Long The unique ID for the shipping carrier used for delivering the sales order items.
ShippingCarrier String The name of the shipping carrier responsible for delivering the order, such as FedEx, UPS, or DHL.
ShippingServiceLevelCode String Code representing the service level for shipping, such as ground or expedited shipping.
ShippingServiceLevel String Description of the service level for shipping, indicating the type of service (for example, next-day delivery, two-day shipping).
ShippingModeCode String Code representing the shipping mode, which determines the method of delivery (for example, air, sea, land).
ShippingMode String The shipping mode used for delivering the sales order items, such as air freight or ground transport.
FOBPointCode String Code representing the Free On Board (FOB) point for the shipment, indicating the location where ownership of the goods transfers.
FOBPoint String The Free On Board (FOB) point for the shipment, indicating the location where the buyer assumes responsibility for the goods.
DemandClassCode String Code used to categorize the demand class for the order, helping prioritize and allocate inventory.
DemandClass String The demand class for the sales order, typically used to define the type of demand (for example, regular, emergency).
FreightTermsCode String Code representing the terms of freight for the sales order, such as prepaid or collect.
FreightTerms String The freight terms for the sales order, indicating who is responsible for the shipping costs (for example, seller, buyer).
RequestedFulfillmentOrganizationId Long Unique identifier for the fulfillment organization that is requested to handle the sales order.
RequestedFulfillmentOrganizationCode String Code representing the requested fulfillment organization for the sales order.
RequestedFulfillmentOrganizationName String Name of the requested fulfillment organization for the sales order.
SupplierId Long Unique identifier for the supplier handling the order, used for tracking the supplier's involvement in the sales order.
SupplierName String The name of the supplier providing the goods or services for the sales order.
SupplierSiteId Long Unique identifier for the supplier site from which the goods or services for the sales order will be shipped.
PaymentTermsCode Long Code representing the payment terms for the sales order, indicating when and how payment should be made.
PaymentTerms String Description of the payment terms for the sales order, specifying the conditions for payment (for example, Net 30, COD).
SalespersonId Long Unique identifier for the salesperson associated with the sales order, used to track the sales representative handling the order.
Salesperson String Name of the salesperson associated with the sales order, used for sales tracking and commission purposes.
PricedOn Datetime The date and time when the sales order was priced, used for historical reference and pricing accuracy.
TransactionalCurrencyCode String Currency code used for the transaction, specifying the currency in which the sales order is priced.
TransactionalCurrencyName String The name of the currency used for the transaction (for example, USD for US dollars).
AppliedCurrencyCode String Currency code used for applied pricing or charges, potentially different from the transactional currency.
CurrencyConversionDate Datetime The date on which currency conversion rates were applied to the sales order.
CurrencyConversionRate Decimal The conversion rate applied when converting between currencies for the sales order.
CurrencyConversionType String The type of currency conversion used for the sales order, such as daily rates or fixed conversion rates.
PricingSegmentCode String Code representing the pricing segment associated with the sales order, used to define different pricing strategies or categories.
PricingSegment String Description of the pricing segment associated with the sales order, categorizing the pricing approach or rules applied.
PricingStrategyId Long Unique identifier for the pricing strategy used for the sales order, helping to determine how the order's price is calculated.
PricingStrategyName String The name of the pricing strategy applied to the sales order, used for tracking the pricing model used for this order.
AllowCurrencyOverrideFlag Bool Flag indicating whether currency overrides are allowed for the sales order. If 'true', the currency can be manually adjusted.
SegmentExplanationMessageName String Name of the explanation message for the pricing segment, providing additional context or details about the pricing strategy.
PricingSegmentExplanation String Explanation of the pricing segment used for the sales order, helping to clarify the rationale behind the pricing.
StrategyExplanationMessageName String Name of the explanation message for the pricing strategy, providing more details or instructions related to the applied strategy.
PricingStrategyExplanation String Explanation of the pricing strategy applied to the sales order, giving context to the pricing decisions and methodology.
SalesChannelCode String Code representing the sales channel through which the sales order was placed (for example, direct sales, online).
SalesChannel String Description of the sales channel used for the sales order, indicating how the order was placed or processed (for example, retail, wholesale).
Comments String Any additional comments or notes related to the sales order, used for reference or special instructions.
StatusCode String Code representing the current status of the sales order, used for categorizing the order's processing state (for example, pending, completed).
Status String The status description of the sales order, providing more details on whether the order is active, processed, or closed.
OnHoldFlag Bool Flag indicating whether the sales order is on hold. If 'true', the order is temporarily suspended or delayed.
CanceledFlag Bool Flag indicating whether the sales order has been canceled. If 'true', the order is marked as canceled.
CancelReasonCode String Code representing the reason for canceling the sales order, used to categorize the cancellation (for example, customer request, stock issues).
CancelReason String Description of the reason for canceling the sales order, providing additional context about why the order was canceled.
RequestedCancelDate Datetime The date on which the cancellation of the sales order was requested.
RequestingBusinessUnitId Long Unique identifier for the business unit that is requesting the sales order, used to track which unit initiated the request.
RequestingBusinessUnitName String The name of the business unit that is requesting the sales order, useful for organizational tracking and categorization.
RequestingLegalEntityId Long Unique identifier for the legal entity that is requesting the sales order, used for compliance and regulatory purposes.
RequestingLegalEntity String The name of the legal entity responsible for requesting the sales order, which may be different from the business unit.
FreezePriceFlag Bool Flag indicating whether the pricing for the sales order is frozen. If 'true', no price changes are allowed after this flag is set.
FreezeShippingChargeFlag Bool Flag indicating whether the shipping charge for the sales order is frozen. If 'true', no changes to shipping charges can occur.
FreezeTaxFlag Bool Flag indicating whether the tax amount for the sales order is frozen. If 'true', no adjustments to tax charges are allowed.
SubmittedFlag Bool Flag indicating whether the sales order has been submitted. If 'true', the order has been finalized and submitted for processing.
SubmittedBy String Name or identifier of the person who submitted the sales order, used for tracking who finalized the order.
SubmittedDate Datetime The date and time when the sales order was submitted for processing.
TransactionDocumentTypeCode String Code representing the document type associated with the transaction, such as invoice, order confirmation, or credit memo.
PreCreditCheckedFlag Bool Flag indicating whether the sales order has undergone a pre-credit check. If 'true', creditworthiness was verified before order acceptance.
RevisionSourceSystem String The source system from which the order revision originated, used for tracking revisions and system interactions.
SourceTransactionRevisionNumber Long Revision number for the source transaction, used to track versions of the original order or transaction.
TradeComplianceResultCode String Code representing the result of the trade compliance check for the sales order, indicating whether it passed or failed compliance rules.
TradeComplianceResult String The result of the trade compliance check for the sales order, providing details about whether the order complies with trade regulations.
LastUpdatedBy String Name or identifier of the person who last updated the sales order, ensuring accountability for changes.
LastUpdateDate Datetime The date and time when the sales order was last updated, providing a record of when modifications were made.
CreatedBy String Name or identifier of the person who originally created the sales order, providing tracking information for the order's creation.
CreationDate Datetime The date and time when the sales order was created, serving as a timestamp for when the order entered the system.
OpenFlag Bool Flag indicating whether the sales order is still open. If 'true', the order has not been completed or closed.
OrigSystemDocumentReference String Reference number for the original system document, linking the sales order to its originating document or record.
OrderKey String A unique key or reference for the sales order, used to track the order within the system and across other related systems.
AppliedCurrencyName String The name of the currency applied to the sales order, which may differ from the transactional currency used for the order.
SupplierSiteName String The name of the supplier site handling the sales order, indicating the location from which the goods or services are being provided.
MessageText String Any additional message or note associated with the sales order, used to communicate special instructions or important details.
AgreementHeaderId Long Unique identifier for the agreement header associated with the sales order, linking the order to a specific agreement or contract.
AgreementNumber String The number of the agreement linked to the sales order, helping to reference the terms and conditions governing the order.
AgreementVersionNumber Long The version number of the agreement, indicating the specific version of the contract or agreement associated with the order.
Finder String A search tool or method used to locate and identify specific sales orders, typically employed for filtering or finding particular orders in the system.
FromDate Date The start date for the sales order’s validity or applicable period, helping to track the order’s active range.
ToDate Date The end date for the sales order’s validity or applicable period, used to define when the order is no longer valid or relevant.

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