Oracle Fusion Cloud SCM Connector Objects (OrderManagement Schema)

Name	Description
Configurations	Stores configuration details used in order management, defining customizable settings.
ConfigurationsConfigurationLineAttributes	Tracks transactional item attributes for configurations or configuration lines, ensuring accurate configuration management.
ConfigurationsConfigurationLines	Manages individual configuration lines, defining specific details for each line.
ConfigurationsConfigurationMessages	Stores messages related to configurations, facilitating communication and error handling.
ConfigurationsconnectedItems	Tracks connected items linked to a configuration, ensuring comprehensive item management.
ConfigurationsmodelNodes	Manages model nodes for active configurations, defining hierarchical structure.
ConfigurationsmodelNodesmodelNodes	Tracks hierarchical relationships among model nodes for configurations, enabling complex model management.
Finders	Lists finder names and their attributes for specific views, aiding in view management.
FlexFndDffDescriptiveFlexfieldContexts	Provides access to descriptive flexfield contexts through the Oracle REST API, enabling customization and data retrieval.
FlexFndPvsCharacterIdCharacterValues	Manages character value attributes across different flexfields for comprehensive value tracking.
FlexFndPvsCharacterValues	Tracks character-based values for flexfields, enabling flexible attribute management.
FlexFndPvsNumberIdCharacterValues	Tracks numerical values for flexfields, facilitating numerical attribute management.
PricingMatrixClasses	Stores information about pricing matrix classes, supporting dynamic pricing strategies.
SalesOrdersForOrderHub	Enables creation, retrieval, and updating of sales orders, offering comprehensive order management capabilities.
SalesOrdersForOrderHubadditionalInformation	Manages additional details stored in flexfields for sales orders, supporting detailed data tracking.
SalesOrdersForOrderHubattachments	Tracks documents attached to sales orders, ensuring proper documentation for order processing.
SalesOrdersForOrderHubbillToCustomer	Manages billing information associated with customers linked to sales orders, ensuring accurate invoicing.
SalesOrdersForOrderHubcopyOrderReference	Tracks references to original orders used as templates for creating new orders, enabling order duplication.
SalesOrdersForOrderHubholds	Tracks active and released holds on order lines, providing visibility into order processing constraints.
SalesOrdersForOrderHublines	Manages detailed information about sales order lines, including item specifications, quantities, and associated order details.
SalesOrdersForOrderHublinesadditionalInformation	Stores additional, customizable sales order data maintained using flexfields to meet specific business needs.
SalesOrdersForOrderHublinesamendSubscriptionReferences	Tracks references for subscription amendments, facilitating seamless integration with Oracle Subscription Management Cloud for subscription line updates and replacements.
SalesOrdersForOrderHublinesassetTransactionDetails	Captures asset transaction data to support license migrations; currently not actively used in operations.
SalesOrdersForOrderHublinesattachments	Manages documents and files attached to both sales order headers and order lines for better traceability.
SalesOrdersForOrderHublinesbillingPlans	Tracks the billing plans linked to sales orders, including schedule and payment terms.
SalesOrdersForOrderHublinesbillToCustomer	Records billing customer information referenced by sales order headers for invoicing purposes.
SalesOrdersForOrderHublineschannelPrograms	Stores details about channel programs associated with sales order lines for targeted marketing or sales strategies.
SalesOrdersForOrderHublinescharges	Tracks pricing information, including charges and applied costs for sales orders.
SalesOrdersForOrderHublineschargeschargeComponents	Manages detailed breakdowns of pricing components, such as taxes and discounts, at the order line level.
SalesOrdersForOrderHublinescoverageReferences	Stores details about coverage items associated with sales order lines, specifying which items they cover.
SalesOrdersForOrderHublinescoveredProductReferences	Tracks items covered by specific coverage items, ensuring warranty and service consistency.
SalesOrdersForOrderHublinesdropShipPurchaseOrderReference	Tracks purchase orders used in drop shipping scenarios for sales order fulfillment.
SalesOrdersForOrderHublinesdropShipRequisitionReference	Manages requisitions linked to drop-ship orders, coordinating third-party fulfillment processes.
SalesOrdersForOrderHublinesexternalAssetReference	Stores external asset references tied to subscription items, aiding integration with external systems.
SalesOrdersForOrderHublinesexternalFulfillmentSalesOrderReference	Tracks sales orders submitted to external fulfillment systems for processing and delivery.
SalesOrdersForOrderHublinesholds	Manages active and released holds on sales order lines, enabling better control of order processing.
SalesOrdersForOrderHublinesinternalOrderReference	Tracks sales orders that are managed internally within the order management system.
SalesOrdersForOrderHublineslineDetails	Records specific details about shipping and billing for each order line, including carrier and payment terms.
SalesOrdersForOrderHublineslotSerials	Captures lot and serial number details for inventory management, especially for returns or traceable items.
SalesOrdersForOrderHublinesmanualPriceAdjustments	Tracks manual price adjustments made to sales order lines by Order Entry Specialists.
SalesOrdersForOrderHublinesoriginalOrderReference	Tracks the original order linked to return sales orders for reconciliation.
SalesOrdersForOrderHublinespayments	Manages detailed payment records associated with sales orders, including methods and schedules.
SalesOrdersForOrderHublinespriceAdjustments	Manages price changes such as discounts applied to sales orders.
SalesOrdersForOrderHublinespriceValidations	Ensures compliance with pricing rules by tracking validations and resolving pricing violations.
SalesOrdersForOrderHublinesproject	Tracks project-related data associated with sales order lines for cost allocation and tracking.
SalesOrdersForOrderHublinesprojectprojectDetail	Manages detailed project information associated with specific sales order lines.
SalesOrdersForOrderHublinessalesCredits	Tracks sales credit allocations for salespeople involved in the sales order.
SalesOrdersForOrderHublinesshipToCustomer	Records shipping customer details linked to sales orders for accurate delivery.
SalesOrdersForOrderHublinessupplyOrderReference	Manages references to supply orders used to fulfill sales order requirements.
SalesOrdersForOrderHublinestransactionItemAttributes	Tracks transaction-specific attributes for items on each order line, supporting custom requirements.
SalesOrdersForOrderHubpayments	Manages payment-related data for the entire sales order, including totals and payment terms.
SalesOrdersForOrderHubsalesCredits	Tracks salesperson credit distribution for completed sales orders.
SalesOrdersForOrderHubshipToCustomer	Manages customer shipping information for all orders under the sales order hub.
SalesOrdersForOrderHubtotals	Tracks total sales order costs, including subtotals and tax calculations.
SalesOrdersForOrderHubtotalstotalComponents	Breaks down components contributing to total order costs for transparency.
StandardLookupsLOV	Provides a comprehensive list of available lookup values and associated metadata for standard references.

Name	Type	ReadOnly	FilterOnly	Description
ConfigHeaderId [KEY]	Long	False	No	Unique identifier for the configuration header, used to associate and track the overall configuration within the system.
ConfigRevisionId [KEY]	Long	False	No	Identifier for the specific revision of the configuration, allowing for version control and tracking of changes in configuration settings.
ConfigurationId	String	False	No	Unique identifier for the configuration itself, used to reference and manage individual configurations within the system.
Name	String	False	No	The name of the configuration, typically used to identify the configuration in reports or queries.
Description	String	False	No	A detailed description of the configuration, providing additional context about its purpose, scope, or settings.
ValidConfigurationFlag	Bool	False	No	A flag indicating whether the configuration is valid. A value of 'true' means the configuration is considered valid, while 'false' indicates an invalid configuration.
CallingApplicationId	Long	False	No	Identifier for the application that called the configuration service, used to trace the source of the configuration request.
CallingApplicationCode	String	False	No	Code identifying the specific application that initiated the configuration request, used for tracking and logging purposes.
InventoryItemNumber	String	False	No	Identifier for the inventory item associated with the configuration, linking the configuration to a specific product or service.
InventoryOrganizationCode	String	False	No	Code representing the inventory organization in which the configuration is being processed or applied, helping to categorize inventory data.
FinishConfigurationFlag	Bool	False	No	A flag indicating whether the configuration is finalized. A value of 'true' means the configuration is complete and ready for use, while 'false' indicates it is still in progress.
LineQuantity	Int	False	No	The quantity of items or units in the configuration, typically used to specify the number of products being configured.
HeaderAttributes	String	False	No	Attributes related to the configuration header, providing metadata or key-value pairs for the configuration's overall settings.
AdditionalRootLineAttributes	String	False	No	Additional attributes related to the root line of the configuration, often used for supplementary or advanced configuration settings.
CustomParameters	String	False	No	Custom parameters for the configuration, allowing users to define unique settings or rules specific to the configuration's requirements.
ManualPriceAdjustments	String	False	No	Any manual adjustments made to the pricing of the configuration, often used to modify the price after initial calculations.
OutputMode	String	False	No	Specifies the output format or mode for the configuration, such as whether the result is displayed in a report, exported as a file, or used for further processing.
ConfigurationSessionToken	String	False	No	A token that uniquely identifies the configuration session, ensuring that requests and changes are linked to the correct session context.
CreatedBy	String	False	No	The name or identifier of the person or system that created the configuration, used for auditing and tracking purposes.
CreatedOn	Datetime	False	No	The date and time when the configuration was created, useful for tracking the timeline of configuration events.
LastUpdatedBy	String	False	No	The name or identifier of the person or system that last updated the configuration, used to track changes and ensure accountability.
LastUpdatedOn	Datetime	False	No	The date and time when the configuration was last updated, helping to track the most recent changes and maintain version control.
ConfigurationState	String	False	No	Current state of the configuration, indicating whether the configuration is in progress, completed, or in an error state, providing status information.
SessionEffectiveDate	Datetime	False	No	The effective date of the configuration session, indicating when the configuration's changes or settings are to take effect.
Finder	String	False	No	A search or lookup tool used to locate and identify specific configurations, typically used for filtering or finding configurations within the system.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
ConfigurationsConfigHeaderId [KEY]	Long	False	No	Unique identifier for the configuration header associated with the configuration line attributes, linking these attributes to a specific configuration header.
ConfigurationsConfigRevisionId [KEY]	Long	False	No	Identifier for the revision of the configuration header, helping track different versions of configuration line attributes associated with that header.
ConfigHeaderId [KEY]	Long	False	No	Identifier for the configuration header, used to link the configuration line attributes to a specific configuration in the system.
ConfigRevisionId [KEY]	Long	False	No	Identifier for the revision of the configuration, tracking changes to the configuration lines over time and ensuring accurate versioning.
AttributeId	Long	False	No	Unique identifier for the attribute being defined or used within the configuration line, linking each attribute to a specific data set.
VarcharValue	String	False	No	Textual value associated with the configuration line attribute, typically used to store non-numeric data such as descriptions or labels.
NumberValue	Decimal	False	No	Numeric value associated with the configuration line attribute, used to store quantities, prices, or other measurable data relevant to the configuration.
UomCode	String	False	No	Code representing the unit of measure for the number value, ensuring that quantities or measurements are properly interpreted and used in the correct context.
ValueId	Long	False	No	Unique identifier for the specific value of the configuration line attribute, helping to reference pre-defined values that can be associated with the configuration.
ConfigLineAttributeId	Long	False	No	Identifier for the specific configuration line attribute, linking it directly to the line in the configuration where it is applied.
ConfigLineId	Long	False	No	Unique identifier for the configuration line itself, representing a specific part or section of the configuration that these attributes apply to.
InternalName	String	False	No	The internal name used for the configuration line attribute, often used in technical systems for referencing or processing the attribute in the background.
ConfigurationId	String	False	No	Unique identifier for the configuration associated with the configuration line attributes, helping to reference and manage the configuration's settings.
Finder	String	False	No	A search or lookup tool used to locate and identify specific configuration line attributes, typically utilized for filtering or finding the right attributes in the system.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
ConfigurationsConfigHeaderId [KEY]	Long	False	No	Unique identifier for the configuration header associated with the configuration lines, linking the configuration lines to a specific configuration.
ConfigurationsConfigRevisionId [KEY]	Long	False	No	Identifier for the revision of the configuration header, allowing for tracking and versioning of changes to the configuration lines associated with it.
ConfigHeaderId [KEY]	Long	False	No	Identifier for the configuration header, used to associate each configuration line with the correct overall configuration.
ConfigRevisionId [KEY]	Long	False	No	Revision identifier for the configuration, used to track changes to the configuration lines and ensure correct version control.
ConfigLineId	Long	False	No	Unique identifier for a specific configuration line, representing a single line item or section in the configuration.
ParentConfigLineId	Long	False	No	Identifier for the parent configuration line, used to establish hierarchical relationships between configuration lines, if applicable.
InventoryItemId	Long	False	No	Unique identifier for the inventory item associated with the configuration line, linking the line to a specific product or part.
InventoryOrganizationId	Long	False	No	Identifier for the inventory organization to which the inventory item belongs, helping to categorize and organize inventory data for configurations.
UnitQuantity	Decimal	False	No	Quantity of the inventory item in the configuration line, typically used to specify the number of units required for this configuration line.
UomCode	String	False	No	Code representing the unit of measure for the inventory item in the configuration line, ensuring that quantities are interpreted in the correct unit format (for example, pieces or boxes).
ConfiguratorPath	String	False	No	Path that defines the configurator logic or flow followed during the configuration process, helping to track the steps or options chosen.
InventoryItemNumber	String	False	No	Unique identifier for the inventory item within the catalog, providing a reference to the specific product or part being used in the configuration.
InventoryOrganizationCode	String	False	No	Code identifying the inventory organization in which the inventory item is located, providing context for where the item resides within the organization.
InventoryItemType	Decimal	False	No	Type identifier for the inventory item, which helps to classify the item (for example, product, service, part) and associate it with relevant rules or categories.
LineQuantity	Decimal	False	No	Quantity of the configuration lines themselves, often used to specify the number of instances of this particular line within the configuration.
ConfigurationId	String	False	No	Unique identifier for the configuration, linking the configuration lines to the larger configuration setup, ensuring consistency and accuracy in processing.
Finder	String	False	No	A tool or method used to search and locate specific configuration lines, typically used for filtering or identifying particular lines within the larger configuration setup.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
ConfigurationsConfigHeaderId [KEY]	Long	False	No	Unique identifier for the configuration header associated with the configuration messages, linking each message to a specific configuration.
ConfigurationsConfigRevisionId [KEY]	Long	False	No	Identifier for the revision of the configuration header, allowing for tracking of changes and version control related to the configuration messages.
MessageId [KEY]	Long	False	No	Unique identifier for each configuration message, used to track and reference specific messages within the configuration process.
ConfigLineId	Long	False	No	Identifier for the configuration line associated with the message, allowing the system to associate the message with a particular line within the configuration.
ConfigHeaderId [KEY]	Long	False	No	Identifier for the configuration header, linking the message to a particular configuration, providing context for its relevance.
ConfigRevisionId [KEY]	Long	False	No	Revision identifier for the configuration, ensuring that messages are tied to the correct version or revision of the configuration.
MessageType	String	False	No	Type of message being recorded, indicating the nature of the message (for example, error, warning, informational), helping categorize the message.
MessageText	String	False	No	Text content of the configuration message, providing details about the message, such as error descriptions, warnings, or other important information related to the configuration.
DetailedMessageType	String	False	No	More specific categorization of the message, providing a finer level of detail about the message type (for example, 'missing field' or 'out of stock'), offering further context for understanding the issue.
ConfigurationId	String	False	No	Unique identifier for the configuration that the message pertains to, helping to link the message to a specific configuration setup or request.
Finder	String	False	No	Search or lookup tool used to locate and identify specific configuration messages, typically employed for filtering or finding particular messages within the system.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
ConfigurationsConfigHeaderId [KEY]	Long	False	No	Unique identifier for the configuration header associated with the connected items, linking these items to a specific configuration setup.
ConfigurationsConfigRevisionId [KEY]	Long	False	No	Identifier for the revision of the configuration header, ensuring accurate tracking and version control for the connected items within that configuration.
ConfigHeaderId [KEY]	Long	False	No	Identifier for the configuration header, used to associate each connected item with a particular configuration.
ConfigRevisionId [KEY]	Long	False	No	Revision identifier for the configuration, linking the connected items to a specific version or revision of the configuration.
ConnectedItemId [KEY]	Long	False	No	Unique identifier for each connected item, used to track and reference specific items that are linked to the configuration.
ParentConfigLineId	Long	False	No	Identifier for the parent configuration line, helping establish a hierarchical relationship between connected items and their parent lines in the configuration.
InventoryItemId	Long	False	No	Unique identifier for the inventory item associated with the connected item, linking each item to a specific product or part in the inventory system.
InventoryItemNumber	String	False	No	Unique identifier or number for the inventory item, providing a reference to the specific product or part used in the configuration.
InventoryOrganizationId	Long	False	No	Identifier for the inventory organization that owns or manages the connected item, allowing for the categorization and tracking of inventory across different organizational units.
InventoryOrganizationCode	String	False	No	Code representing the inventory organization where the connected item is stored or managed, helping organize and manage items within the system.
UomCode	String	False	No	Code representing the unit of measure for the connected item, ensuring that the quantity is interpreted in the correct unit format (for example, pieces or boxes).
InventoryItemType	Decimal	False	No	Type identifier for the connected inventory item, classifying the item (for example, product, part, service) and determining how it will be treated in the configuration.
Quantity	Decimal	False	No	The quantity of the connected item in the configuration, indicating how many units of this item are needed or associated with the configuration.
ConfigurationId	String	False	No	Unique identifier for the configuration, linking the connected items to the specific configuration setup and ensuring consistency across the configuration.
Finder	String	False	No	A tool or method used to search and locate specific connected items within the configuration, typically employed for filtering or identifying particular items in the system.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
ConfigurationsConfigHeaderId [KEY]	Long	False	No	Unique identifier for the configuration header associated with the model nodes, linking these nodes to a specific configuration.
ConfigurationsConfigRevisionId [KEY]	Long	False	No	Identifier for the revision of the configuration header, ensuring version control and tracking changes to the model nodes in that configuration.
NodeId [KEY]	Int	False	No	Unique identifier for each model node within the configuration, allowing the system to reference and manage specific nodes in the configuration model.
NodeType	String	False	No	Type of the model node (for example, product, attribute, selection), indicating the role of the node in the overall configuration model.
Name	String	False	No	The name of the model node, typically used for identification purposes within the configuration, often representing the node's function or category.
ParentNodeId	Int	False	No	Identifier for the parent node of the current model node, establishing a hierarchical relationship between nodes in the configuration model.
Description	String	False	No	Detailed description of the model node, providing additional context about its purpose, characteristics, or role within the configuration.
DisplayName	String	False	No	Name displayed for the model node, typically used for user interfaces or reports to provide a more human-readable version of the node's name.
DisplayNamePath	String	False	No	Path representing the display name hierarchy for the node, used to show the full context or lineage of the model node in a nested structure.
HasChildrenFlag	Bool	False	No	Flag indicating whether the model node has child nodes. A value of 'true' means the node has one or more child nodes, while 'false' indicates it does not.
HasTransactionalAttributesFlag	Bool	False	No	Flag indicating whether the model node includes transactional attributes. If 'true', the node involves transactions, such as pricing or inventory updates.
InErrorModeFlag	Bool	False	No	Flag indicating whether the model node is currently in an error state. A value of 'true' indicates the node has encountered an issue that needs attention.
InputRequiredFlag	Bool	False	No	Flag indicating whether user input is required for the node. If 'true', the configuration process requires input for this node.
InputRequiredInSubtreeFlag	Bool	False	No	Flag indicating whether input is required for the node within its subtree. If 'true', all child nodes under this node require user input.
IsBoundFlag	Bool	False	No	Flag indicating whether the model node is bound to specific data or constraints, ensuring that the node's value is fixed or tied to other elements.
ProposedFlag	Bool	False	No	Flag indicating whether the model node has been proposed for inclusion in the configuration. If 'true', it is part of a proposed solution but not yet finalized.
ValidFlag	Bool	False	No	Flag indicating whether the model node is valid. A value of 'true' means the node is considered valid and usable within the configuration.
ChangedByAutocompleteFlag	Bool	False	No	Flag indicating whether the model node was changed by an autocomplete process. If 'true', the value was automatically filled in based on previous choices or rules.
DeltaChanges	String	False	No	Details of the changes made to the model node, providing information about any updates, adjustments, or modifications applied to the node during the configuration.
OverrideConflictFlag	Bool	False	No	Flag indicating whether there is a conflict due to an override. If 'true', an override has caused a conflict with existing values or settings in the configuration.
ConfigHeaderId	Long	False	No	Identifier for the configuration header, linking the model node to a specific configuration setup and ensuring consistency across all model nodes.
ConfigRevisionId	Long	False	No	Revision identifier for the configuration, ensuring that the model node is associated with the correct version of the configuration.
ConfigurationId	String	False	No	Unique identifier for the configuration, linking the model nodes to the specific configuration setup to which they belong.
Finder	String	False	No	A tool or method used to search and locate specific model nodes within the configuration, typically used for filtering or identifying particular nodes in the system.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
ConfigurationsConfigHeaderId [KEY]	Long	False	No	Unique identifier for the configuration header associated with the model nodes, linking these model nodes to a specific configuration.
ConfigurationsConfigRevisionId [KEY]	Long	False	No	Identifier for the revision of the configuration header, allowing for tracking of changes and version control for the model nodes in that configuration.
ModelnodesNodeId [KEY]	Int	False	No	Unique identifier for the model node within the configuration, used to track and reference specific model nodes in the system.
NodeId [KEY]	Int	False	No	Unique identifier for the model node, representing an individual element within the model node structure in the configuration.
NodeType	String	False	No	Type of the model node (for example, product, attribute, or selection), indicating the role of the node within the configuration model.
Name	String	False	No	The name of the model node, typically used for identification purposes and describing the node's role or category within the configuration.
ParentNodeId	Int	False	No	Identifier for the parent node of the current model node, establishing a hierarchical relationship between nodes in the configuration model.
Description	String	False	No	Detailed description of the model node, providing further context about its purpose, characteristics, or role within the configuration.
DisplayName	String	False	No	Human-readable name displayed for the model node, often used in user interfaces or reports for easier understanding and identification.
DisplayNamePath	String	False	No	Path representing the display name hierarchy for the node, showing the full context or lineage of the node in a nested structure.
HasChildrenFlag	Bool	False	No	Flag indicating whether the model node has child nodes. A value of 'true' means the node has one or more child nodes, while 'false' indicates it does not.
HasTransactionalAttributesFlag	Bool	False	No	Flag indicating whether the model node includes transactional attributes. If 'true', the node involves transactions such as pricing or inventory updates.
InErrorModeFlag	Bool	False	No	Flag indicating whether the model node is currently in an error state. A value of 'true' means the node has encountered an issue that needs attention.
InputRequiredFlag	Bool	False	No	Flag indicating whether user input is required for the node. If 'true', the configuration process requires input for this particular node.
InputRequiredInSubtreeFlag	Bool	False	No	Flag indicating whether input is required for the node within its entire subtree. If 'true', all child nodes under this node require user input.
IsBoundFlag	Bool	False	No	Flag indicating whether the model node is bound to specific data or constraints. A 'true' value means the node's value is fixed or constrained by external factors.
ProposedFlag	Bool	False	No	Flag indicating whether the model node has been proposed for inclusion in the configuration. If 'true', it is part of a proposed solution but not yet finalized.
ValidFlag	Bool	False	No	Flag indicating whether the model node is considered valid. A 'true' value means the node is valid and usable within the configuration.
ChangedByAutocompleteFlag	Bool	False	No	Flag indicating whether the model node was changed by an autocomplete process. A 'true' value means the node's value was automatically filled in based on previous user selections or system rules.
DeltaChanges	String	False	No	Details of any changes made to the model node, typically providing information about updates, adjustments, or modifications applied to the node during the configuration process.
OverrideConflictFlag	Bool	False	No	Flag indicating whether there is a conflict due to an override. If 'true', an override has caused a conflict with existing values or settings in the configuration.
ConfigHeaderId	Long	False	No	Identifier for the configuration header, linking the model node to the specific configuration setup to which it belongs.
ConfigRevisionId	Long	False	No	Revision identifier for the configuration, ensuring that the model node is associated with the correct version of the configuration.
ConfigurationId	String	False	No	Unique identifier for the configuration, linking the model nodes to the specific configuration setup and ensuring consistency across the configuration.
Finder	String	False	No	A tool or method used to search and locate specific model nodes within the configuration, typically employed for filtering or identifying particular nodes in the system.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
ViewName	String	False	No	The name of the view from which the finder is being queried. This helps identify the specific database view in which the finder functionality is applied.
FinderName	String	False	No	The name of the finder being used or referenced. This typically refers to a specific search or lookup tool associated with the view.
AttributeFinderColumn	String	False	No	The name of the attribute within the finder that is being used to filter or search for specific data. This column is key to identifying what is being searched.
Type	String	False	No	The datatype of the finder attribute, indicating the kind of data (for example, string, integer, date) that the attribute represents. This ensures the proper handling and comparison of data types during searches.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
ApplicationId [KEY]	Long	False	No	The unique identifier for the application associated with the descriptive flexfield (DFF) context. This helps specify which application the flexfield context belongs to.
DescriptiveFlexfieldCode [KEY]	String	False	No	Code identifying the specific DFF, which provides additional attributes or metadata for the application.
ContextCode [KEY]	String	False	No	Code representing the context of the DFF, used to categorize or define the conditions under which the flexfield is applied.
Name	String	False	No	The name of the DFF context, typically used for identification and reference within the system.
Description	String	False	No	Detailed description of the flexfield context, explaining its purpose, usage, or any other important information relevant to users and administrators.
EnabledFlag	String	False	No	Flag indicating whether the flexfield context is enabled. A value of 'true' means the context is active and can be used, while 'false' means it is disabled.
Bind_ApplicationId	Long	False	No	The identifier for the application associated with the bind parameters for the DFF context, linking it to a specific application instance.
Bind_DescriptiveFlexfieldCode	String	False	No	The DFF code for the binding, indicating which specific flexfield is being referenced for the bind operation.
Finder	String	False	No	A tool or method used to search and locate specific flexfield contexts. This is typically employed for filtering or identifying particular contexts in the system.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	Unique identifier for each flexfield character value, used to reference and track individual values within the system.
Value	String	False	No	The actual value of the flexfield character, representing the data stored for a particular field in the system.
Description	String	False	No	A description of the flexfield character value, providing additional context or explanation about what the value represents.
StartDateActive	Date	False	No	The start date when the flexfield character value becomes active, used to track when it starts to be valid or applicable in the system.
EndDateActive	Date	False	No	The end date when the flexfield character value is no longer active, helping to track when it expires or is deactivated.
EnabledFlag	String	False	No	Flag indicating whether the flexfield character value is enabled. A value of 'true' means the value is active and usable, while 'false' means it is disabled.
SummaryFlag	String	False	No	Flag indicating whether the flexfield character value is a summary value. If 'true', the value represents a summarized or aggregated result.
ValueSetCode	String	False	No	Code representing the set of values that the flexfield character value belongs to, helping to categorize and validate the possible values.
Bind_DataSource	String	False	No	The data source from which the flexfield character values are derived or bound, indicating where the values are pulled from.
Bind_FinderContext	String	False	No	The context in which the finder tool is used for selecting flexfield character values, helping to define the scope or conditions for value selection.
Bind_FinderDateFlag	String	False	No	Flag indicating whether the finder context includes a date filter. If 'true', the context is filtered by date values when searching for character values.
Bind_ValidationDate	Date	False	No	The validation date for the flexfield character value, specifying when the value should be validated or used for any date-sensitive operations.
Finder	String	False	No	A tool or method used to search and locate specific flexfield character values, helping users find and select values that match specific criteria.
Flex_vst_bind1	String	False	No	Bind parameter 1 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind10	String	False	No	Bind parameter 10 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind11	String	False	No	Bind parameter 11 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind12	String	False	No	Bind parameter 12 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind13	String	False	No	Bind parameter 13 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind14	String	False	No	Bind parameter 14 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind15	String	False	No	Bind parameter 15 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind16	String	False	No	Bind parameter 16 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind17	String	False	No	Bind parameter 17 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind18	String	False	No	Bind parameter 18 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind19	String	False	No	Bind parameter 19 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind2	String	False	No	Bind parameter 2 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind20	String	False	No	Bind parameter 20 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind3	String	False	No	Bind parameter 3 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind4	String	False	No	Bind parameter 4 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind5	String	False	No	Bind parameter 5 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind6	String	False	No	Bind parameter 6 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind7	String	False	No	Bind parameter 7 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind8	String	False	No	Bind parameter 8 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind9	String	False	No	Bind parameter 9 for the flexfield character value, used for binding specific conditions or values related to the flexfield.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
Value [KEY]	String	False	No	The actual value of the flexfield character, representing the data stored for a particular field in the system.
Description	String	False	No	A description of the flexfield character value, providing additional context or explanation about what the value represents.
StartDateActive	Date	False	No	The start date when the flexfield character value becomes active, used to track when it starts to be valid or applicable in the system.
EndDateActive	Date	False	No	The end date when the flexfield character value is no longer active, helping to track when it expires or is deactivated.
EnabledFlag	String	False	No	Flag indicating whether the flexfield character value is enabled. A value of 'true' means the value is active and usable, while 'false' means it is disabled.
SummaryFlag	String	False	No	Flag indicating whether the flexfield character value is a summary value. If 'true', the value represents a summarized or aggregated result.
ValueSetCode	String	False	No	Code representing the set of values that the flexfield character value belongs to, helping to categorize and validate the possible values.
Bind_AttrMap	String	False	No	Mapping for the flexfield character value attribute, indicating how the value is mapped or associated with other attributes or data fields.
Bind_DataSource	String	False	No	The data source from which the flexfield character values are derived or bound, indicating where the values are pulled from.
Bind_DataSourceDiscr	String	False	No	The discriminator used for the data source, specifying the conditions under which the values are retrieved or categorized within the source.
Bind_FinderContext	String	False	No	The context in which the finder tool is used for selecting flexfield character values, helping to define the scope or conditions for value selection.
Bind_FinderDateFlag	String	False	No	Flag indicating whether the finder context includes a date filter. If 'true', the context is filtered by date values when searching for character values.
Bind_ValidationDate	Date	False	No	The validation date for the flexfield character value, specifying when the value should be validated or used for any date-sensitive operations.
Finder	String	False	No	A tool or method used to search and locate specific flexfield character values, helping users find and select values that match specific criteria.
Flex_vst_bind1	String	False	No	Bind parameter 1 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind10	String	False	No	Bind parameter 10 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind11	String	False	No	Bind parameter 11 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind12	String	False	No	Bind parameter 12 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind13	String	False	No	Bind parameter 13 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind14	String	False	No	Bind parameter 14 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind15	String	False	No	Bind parameter 15 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind16	String	False	No	Bind parameter 16 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind17	String	False	No	Bind parameter 17 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind18	String	False	No	Bind parameter 18 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind19	String	False	No	Bind parameter 19 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind2	String	False	No	Bind parameter 2 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind20	String	False	No	Bind parameter 20 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind3	String	False	No	Bind parameter 3 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind4	String	False	No	Bind parameter 4 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind5	String	False	No	Bind parameter 5 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind6	String	False	No	Bind parameter 6 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind7	String	False	No	Bind parameter 7 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind8	String	False	No	Bind parameter 8 for the flexfield character value, used for binding specific conditions or values related to the flexfield.
Flex_vst_bind9	String	False	No	Bind parameter 9 for the flexfield character value, used for binding specific conditions or values related to the flexfield.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	Decimal	False	No	The unique identifier for each flexfield character value related to a number ID, used to track and reference individual numeric values within the system.
Value	String	False	No	The actual value of the flexfield character, representing the numeric data stored for a particular field in the system.
Description	String	False	No	A description of the flexfield character value, providing additional context or explanation about what the numeric value represents.
StartDateActive	Date	False	No	The start date when the flexfield character value becomes active, used to track when it starts to be valid or applicable for processing.
EndDateActive	Date	False	No	The end date when the flexfield character value is no longer active, helping track when it expires or is deactivated.
EnabledFlag	String	False	No	Flag indicating whether the flexfield character value is enabled. A value of 'true' means the value is active and usable, while 'false' means it is disabled.
SummaryFlag	String	False	No	Flag indicating whether the flexfield character value is a summary value. If 'true', the value represents a summarized or aggregated result.
ValueSetCode	String	False	No	Code representing the set of values that the flexfield character value belongs to, helping to categorize and validate the possible numeric values.
Bind_DataSource	String	False	No	The data source from which the flexfield character values are derived or bound, indicating the origin of the numeric values.
Bind_FinderContext	String	False	No	The context in which the finder tool is used for selecting flexfield character values, helping to define the scope or conditions for searching for numeric values.
Bind_FinderDateFlag	String	False	No	Flag indicating whether the finder context includes a date filter. If 'true', the context is filtered by date values when searching for character values.
Bind_ValidationDate	Date	False	No	The validation date for the flexfield character value, specifying when the numeric value should be validated or used for date-sensitive operations.
Finder	String	False	No	A tool or method used to search and locate specific flexfield character values, helping users find and select numeric values based on search criteria.
Flex_vst_bind1	String	False	No	Bind parameter 1 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind10	String	False	No	Bind parameter 10 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind11	String	False	No	Bind parameter 11 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind12	String	False	No	Bind parameter 12 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind13	String	False	No	Bind parameter 13 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind14	String	False	No	Bind parameter 14 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind15	String	False	No	Bind parameter 15 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind16	String	False	No	Bind parameter 16 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind17	String	False	No	Bind parameter 17 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind18	String	False	No	Bind parameter 18 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind19	String	False	No	Bind parameter 19 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind2	String	False	No	Bind parameter 2 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind20	String	False	No	Bind parameter 20 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind3	String	False	No	Bind parameter 3 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind4	String	False	No	Bind parameter 4 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind5	String	False	No	Bind parameter 5 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind6	String	False	No	Bind parameter 6 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind7	String	False	No	Bind parameter 7 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind8	String	False	No	Bind parameter 8 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.
Flex_vst_bind9	String	False	No	Bind parameter 9 for the flexfield character value, used for binding specific conditions or values related to the flexfield numeric value.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
MatrixClassId [KEY]	Long	False	No	Unique identifier for the pricing matrix class, used to reference and track specific pricing structures within the system.
MatrixClassName	String	False	No	The name of the pricing matrix class, typically used to identify and categorize different pricing structures in the system.
CanAddNewDimensions	String	False	No	Flag indicating whether new dimensions can be added to the pricing matrix class. If 'true', new dimensions (for example, regions, products) can be added to the pricing structure.
DateEffectivityEnabled	String	False	No	Flag indicating whether date-based effectivity is enabled for the pricing matrix class. If 'true', the pricing matrix can have time-bound conditions for when prices are valid.
IsPublic	String	False	No	Flag indicating whether the pricing matrix class is public. A value of 'true' means the class is available to all users, while 'false' limits access to specific users or roles.
ContextConsumer	String	False	No	Identifier for the consumer context of the pricing matrix class, specifying the system or process that is using the pricing matrix.
CreatedBy	String	False	No	The name or identifier of the person or system that created the pricing matrix class, useful for auditing and tracking purposes.
CreationDate	Datetime	False	No	The date and time when the pricing matrix class was created, helping to track the origin of the matrix and its history.
LastUpdateDate	Datetime	False	No	The date and time when the pricing matrix class was last updated, useful for maintaining version control and tracking changes over time.
LastUpdatedBy	String	False	No	The name or identifier of the person or system that last updated the pricing matrix class, providing accountability for modifications.
Finder	String	False	No	A tool or method used to search and locate specific pricing matrix classes, typically employed for filtering or identifying particular matrix classes in the system.

Return to Top

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

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the header of the sales order, linking the additional information to a specific sales order header.
Category	String	False	No	The category of the additional information, which classifies the type or nature of the data (for example, delivery details, payment terms, special requests).
CreatedBy	String	False	No	The name or identifier of the person or system that created the additional information entry for the sales order.
CreationDate	Datetime	False	No	The date and time when the additional information was created, providing a timestamp for when it was added to the system.
HeaderId [KEY]	Long	False	No	The unique identifier for the header of the sales order to which the additional information is related.
LastUpdateDate	Datetime	False	No	The date and time when the additional information was last updated, helping to track any modifications made to the information.
LastUpdateLogin	String	False	No	Identifier for the user or system that performed the last update on the additional information, used for tracking purposes.
LastUpdatedBy	String	False	No	The name or identifier of the person or system that last updated the additional information for the sales order.
ObjectVersionNumber	Int	False	No	Version number of the object (additional information record), helping to track changes or revisions to the data.
SourceTransactionIdentifier	String	False	No	Unique identifier for the source transaction from which the additional information originated, used to trace back to the original source.
SourceTransactionSystem	String	False	No	The system from which the source transaction originated, providing context for where the sales order data is coming from.
Finder	String	False	No	A search tool or method used to locate and retrieve specific pieces of additional information associated with the sales order.
FromDate	Date	False	No	The date when the additional information becomes applicable or valid, used to define the effective start date for the data.
OrderKey	String	False	No	Unique key or reference for the sales order, used to track and manage the order within the system.
OrderNumber	String	False	No	The order number associated with the sales order, used for tracking and reference purposes.
SourceTransactionNumber	String	False	No	The number associated with the source transaction that generated the additional information, helping to link it to the originating transaction.
ToDate	Date	False	No	The date when the additional information becomes invalid or expires, used to define the end date for its applicability.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the attachment to the specific sales order.
AttachedDocumentId [KEY]	Long	False	No	Unique identifier for the attached document, used to reference and track the specific attachment in the system.
LastUpdateDate	Datetime	False	No	The date and time when the attachment details were last updated, providing a timestamp for the most recent modification.
LastUpdatedBy	String	False	No	The name or identifier of the person or system who last updated the attachment details.
DatatypeCode	String	False	No	Code representing the data type of the attachment, helping categorize the file (for example, PDF, image, document).
FileName	String	False	No	The name of the file attached to the sales order, used for identifying the document within the system.
DmFolderPath	String	False	No	The path to the folder where the attachment is stored, typically used in a document management system for file organization.
DmDocumentId	String	False	No	Unique identifier for the attached document in the document management system, ensuring traceability of the document.
DmVersionNumber	String	False	No	Version number of the attached document, used to track revisions or changes made to the document.
Url	String	False	No	The URL (Uniform Resource Locator) pointing to the location where the attachment can be accessed online.
CategoryName	String	False	No	The category under which the attachment is classified, helping to organize and sort attachments (for example, invoice, contract).
UserName	String	False	No	The username of the person who uploaded or is associated with the attachment, used for tracking purposes.
Uri	String	False	No	The URI (Uniform Resource Identifier) that identifies the attachment file, providing a more technical address for locating the file.
FileUrl	String	False	No	URL used to locate the attachment file, typically provided for easy access to the file within a system.
UploadedText	String	False	No	Text content included within the attachment file, which may provide summary information or context about the document.
UploadedFileContentType	String	False	No	The content type of the attached file, describing its format.
UploadedFileLength	Long	False	No	The size of the attachment file in bytes, used for managing file storage and ensuring the file is within allowable size limits.
UploadedFileName	String	False	No	The name of the file as uploaded to the system, which could differ from the original file name if renamed during upload.
ContentRepositoryFileShared	Bool	False	No	Flag indicating whether the attachment file is shared in the content repository. If 'true', the file is accessible to other systems or users.
Title	String	False	No	The title or label of the attachment, providing a more descriptive or readable name for users reviewing the attachment.
Description	String	False	No	A textual description of the attachment, giving further context or information about its content.
ErrorStatusCode	String	False	No	Code representing the error status encountered during the upload process, used for troubleshooting attachment issues.
ErrorStatusMessage	String	False	No	Detailed message explaining the error encountered while uploading the attachment, helpful for resolving issues.
CreatedBy	String	False	No	The name or identifier of the person or system that created the attachment record.
CreationDate	Datetime	False	No	The date and time when the attachment was created, marking the point at which the file was first associated with the sales order.
FileContents	String	False	No	Contents of the attachment file represented as a string, potentially used for storing small files or metadata within the system.
ExpirationDate	Datetime	False	No	The date when the attachment expires, typically used for time-sensitive documents that are no longer needed after a certain period.
LastUpdatedByUserName	String	False	No	The username of the individual who last updated the attachment record, helping to identify the user responsible for recent changes.
CreatedByUserName	String	False	No	The username of the individual who created the attachment record, providing context for who originally added the attachment.
AsyncTrackerId	String	False	No	Identifier used to track the asynchronous upload process of the attachment, ensuring file uploads are monitored and managed properly.
FileWebImage	String	False	No	URL or reference to the image or preview representation of the attachment file, used for web-based display or interaction.
DownloadInfo	String	False	No	JSON object in string format containing information used to programmatically retrieve the attachment file, often used for automated downloads.
PostProcessingAction	String	False	No	The name of the action that can be performed after the attachment has been successfully uploaded, such as processing or validation.
Finder	String	False	No	A search or lookup tool used to locate specific attachments, typically employed for filtering or identifying particular files related to the sales order.
FromDate	Date	False	No	The start date for the period during which the attachment is valid or relevant, used to define when the document becomes applicable.
HeaderId	Long	False	No	Identifier for the sales order header that the attachment is linked to, helping to associate the file with a particular order.
OrderKey	String	False	No	Unique key for the sales order, used to reference and track the order in relation to the attachment.
OrderNumber	String	False	No	Order number associated with the sales order, providing a point of reference for identifying the specific order linked to the attachment.
SourceTransactionNumber	String	False	No	Transaction number from the source system that originated the sales order and is linked to the attachment.
SourceTransactionSystem	String	False	No	The system from which the original transaction for the sales order originated, providing context for the attachment's source.
ToDate	Date	False	No	The end date for the period during which the attachment is valid or relevant, marking when the document is no longer applicable.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the bill-to customer information to the specific sales order.
AddressId [KEY]	Long	False	No	Unique identifier for the bill-to customer address, used to track the specific address associated with the sales order for billing purposes.
CustomerAccountId	Long	False	No	Unique identifier for the account that is legally responsible for payment. This account represents the party with which the deploying company has a selling relationship.
PartyName	String	False	No	The name of the party (individual or organization) that is legally responsible for making payment on the sales order.
AccountNumber	String	False	No	Account number of the customer that is legally responsible for payment, typically used for reference and tracking within the billing system.
PersonFirstName	String	False	No	First name of the individual responsible for payment, applicable when a person (as opposed to an organization) is legally responsible.
PersonLastName	String	False	No	Last name of the individual responsible for payment, used to fully identify the person legally responsible for the sales order.
PersonMiddleName	String	False	No	Middle name of the individual responsible for payment, used to fully identify the person when applicable.
PersonNameSuffix	String	False	No	Suffix (for example, Jr., Sr., III) of the individual responsible for payment, providing additional clarity for identification.
PersonTitle	String	False	No	Title (for example, Mr., Mrs., Dr.) of the individual responsible for payment, used for formal identification.
SiteUseId	Long	False	No	Unique identifier for the account site where the billing responsibilities are associated, ensuring that the correct location is linked to the customer account.
Address1	String	False	No	First line of the bill-to customer’s address, typically used to capture street address or P.O. box information.
Address2	String	False	No	Second line of the bill-to customer’s address, often used for additional address information (for example, apartment or suite number).
Address3	String	False	No	Third line of the bill-to customer’s address, used for further address details when necessary.
Address4	String	False	No	Fourth line of the bill-to customer’s address, used for extra address information if required.
City	String	False	No	City of the bill-to customer’s address, used to identify the local geographic area for the customer’s billing location.
State	String	False	No	State of the bill-to customer’s address, helping to further define the location within a country.
PostalCode	String	False	No	Postal code of the bill-to customer’s address, providing the final part of the address for accurate delivery and identification.
County	String	False	No	County of the bill-to customer’s address, providing additional geographic information to help with location verification.
Province	String	False	No	Province of the bill-to customer’s address, used for regions where applicable, especially in countries like Canada.
Country	String	False	No	Country of the bill-to customer’s address, ensuring the address is complete for international orders.
ContactId	Long	False	No	Unique identifier for the contact associated with the billing account, helping to link the specific contact to the payment responsibilities.
ContactName	String	False	No	Full name of the contact person for the billing account, used for communication and identification purposes.
ContactNumber	String	False	No	Telephone number of the contact person at the bill-to customer site, used for follow-up and inquiries regarding the order.
ContactFirstName	String	False	No	First name of the person to contact for billing-related inquiries, used for direct communication.
ContactMiddleName	String	False	No	Middle name of the person to contact for billing-related inquiries, used for further clarification of the contact's full name.
ContactLastName	String	False	No	Last name of the person to contact for billing-related inquiries, ensuring accurate identification.
ContactNameSuffix	String	False	No	Suffix (for example, Jr., Sr.) of the contact person for the billing account, providing additional clarity for proper addressing.
ContactTitle	String	False	No	Title (for example, Mr., Ms., Dr.) of the person to contact for billing-related inquiries, used for formal communication.
PreferredContactPointId	Long	False	No	Unique identifier for the preferred method of contact for the person responsible for payment, typically an email address or phone number.
SourceAddressId	String	False	No	Value that uniquely identifies the bill-to customer’s address, ensuring that the correct address is used for the billing process. This value is typically set to '1'.
Finder	String	False	No	A tool or method used to search and locate specific billing details or information associated with the sales order.
FromDate	Date	False	No	The start date during which the billing information for the sales order is valid, used for tracking purposes.
HeaderId	Long	False	No	Unique identifier for the header of the sales order, helping to link the bill-to customer information to the specific sales order.
OrderKey	String	False	No	A unique key used to reference and track the sales order across various systems and processes.
OrderNumber	String	False	No	Order number associated with the sales order, helping to reference and track the specific order.
SourceTransactionNumber	String	False	No	The number associated with the source transaction that generated the sales order, helping to link it to the originating event.
SourceTransactionSystem	String	False	No	The system from which the original source transaction originated, providing context about the origin of the sales order.
ToDate	Date	False	No	The end date during which the billing information for the sales order is valid, ensuring the data is up-to-date and applicable for the correct period.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the copy order reference details to the specific sales order.
DocumentSystemReferenceId [KEY]	Long	False	No	Unique identifier for the document system reference, helping track and associate the copied order reference in the document management system.
OriginalOrderNumber	String	False	No	The original order number associated with the sales order, used to reference the originating order from which the current order is copied.
OriginalHeaderId	Long	False	No	Unique identifier for the original order header, used to link the current order to its source order.
OriginalOrderChangeVersionNumber	Long	False	No	Version number of the original order change, helping to track the specific version of the order being referenced in the copy.
Finder	String	False	No	A tool or method used to search and locate the copy order reference information, typically used for filtering or identifying related order references.
FromDate	Date	False	No	The start date during which the copy order reference is valid, used to define the time frame for its applicability.
HeaderId	Long	False	No	Unique identifier for the header of the sales order, used to link the copy order reference to the specific sales order.
OrderKey	String	False	No	A unique key used to track and reference the sales order in the system, helping to identify the order across different systems.
OrderNumber	String	False	No	The order number of the sales order, which is used for tracking and reference purposes, particularly in relation to the copy order reference.
SourceTransactionNumber	String	False	No	The number associated with the source transaction that generated the sales order, helping to track the original transaction linked to the order copy.
SourceTransactionSystem	String	False	No	The system from which the source transaction originated, providing context about where the original transaction was created.
ToDate	Date	False	No	The end date during which the copy order reference is valid, ensuring that the reference data is up-to-date and applicable for the correct period.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the hold details to the specific sales order.
HoldInstanceId [KEY]	Long	False	No	Unique identifier for each instance of the hold applied to the sales order, used for tracking and managing holds.
HoldName	String	False	No	The name assigned to the hold, used to identify the specific type or reason for the hold on the sales order.
HoldCode	String	False	No	Code representing the hold applied to the sales order, used for classification and to quickly identify the type of hold.
HoldComments	String	False	No	Additional comments or notes related to the hold, providing context or explanations for why the hold was applied.
ApplyUser	String	False	No	The name or identifier of the person who applied the hold to the sales order, used for accountability and auditing purposes.
ApplyDate	Datetime	False	No	The date and time when the hold was applied to the sales order, marking when the action was taken.
HoldReleaseComments	String	False	No	Comments or notes explaining the release of the hold, providing context or reason for lifting the hold on the order.
HoldReleaseReasonCode	String	False	No	Code representing the reason for releasing the hold, helping to classify and track the circumstances under which the hold was lifted.
HoldReleaseReason	String	False	No	Description of the reason for releasing the hold, providing further clarification of the action taken.
ReleaseUser	String	False	No	The name or identifier of the person who released the hold, ensuring accountability for the release action.
ReleaseDate	Datetime	False	No	The date and time when the hold was released, marking the point when the sales order was cleared from the hold status.
ApplySystem	String	False	No	The system used to apply the hold to the sales order, providing context for where the action was initiated.
ActiveFlag	Bool	False	No	Flag indicating whether the hold is currently active. A value of 'true' means the hold is still in effect, while 'false' means it has been released.
SourceRequestId	String	False	No	Unique identifier for the request that initiated the hold, used to trace back to the original request or system action.
Finder	String	False	No	A tool or method used to search and locate specific holds on sales orders, typically employed for filtering or identifying holds within the system.
FromDate	Date	False	No	The start date for when the hold is valid or applicable, marking the beginning of the period during which the hold is enforced.
HeaderId	Long	False	No	Unique identifier for the sales order header, ensuring that the hold is linked to the correct sales order.
OrderKey	String	False	No	A unique key used to reference and track the sales order within the system, helping to associate the order with the applied hold.
OrderNumber	String	False	No	The order number associated with the sales order, used for tracking and reference in relation to the applied hold.
SourceTransactionNumber	String	False	No	The number associated with the source transaction that initiated the sales order hold, linking it to the original transaction.
SourceTransactionSystem	String	False	No	The system from which the source transaction originated, providing context about the origin of the hold.
ToDate	Date	False	No	The end date for when the hold is valid or applicable, marking the end of the period during which the hold is in effect.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the order line details to the specific sales order.
HeaderId	Long	False	No	Unique identifier for the sales order header, used to associate the order line with the corresponding header.
LineId	Long	False	No	Unique identifier for each line in the sales order, allowing the order to be broken down into individual items.
FulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the order line, used to track fulfillment statuses for individual lines.
SourceTransactionLineId	String	False	No	Unique identifier for the transaction line in the source application, allowing the order line to be linked to its original transaction.
SourceTransactionLineNumber	String	False	No	Transaction line number from the source application, used to reference and identify specific lines in the source document.
SourceTransactionId	String	False	No	Unique identifier for the source transaction, linking the sales order line to the original source transaction.
SourceTransactionNumber	String	False	No	Transaction number of the source system, used for referencing the originating transaction that created the order line.
SourceTransactionSystem	String	False	No	The system from which the original source transaction originated, providing context for the source of the sales order line.
RequestingBusinessUnitId	Long	False	No	Unique identifier for the business unit requesting the fulfillment of the order line, used for internal tracking and allocation.
RequestingBusinessUnitName	String	False	No	Name of the business unit that requested the fulfillment, helping to categorize and assign responsibility for the order line.
AccountingRuleCode	String	False	No	Abbreviation for the accounting rule applied to the order line, used to manage how the revenue is recognized for the transaction.
AccountingRule	String	False	No	The accounting rule applied to the order line, determining the accounting periods and revenue distribution for the sales order.
ActionTypeCode	String	False	No	Code representing the type of action for the coverage or subscription product on the fulfillment line, such as add, update, renew for coverage or suspend, terminate for subscriptions.
ActionType	String	False	No	Descriptive label for the action type on the fulfillment line, detailing the nature of the change or update to the coverage or subscription.
ActualCompletionDate	Datetime	False	No	The actual date when the fulfillment of the order line was completed, used to track when the order was fully processed.
ActualShipDate	Datetime	False	No	The actual ship date of the sales order line, marking the point at which the item was shipped to the customer.
AppliedPriceListId	Long	False	No	Unique identifier for the price list applied to the order line, allowing tracking of the specific pricing terms used.
AppliedPriceListName	String	False	No	Name of the price list applied to the order line, providing clarity on which pricing rules were used for the line item.
AssessableValue	Decimal	False	No	The price used by tax authorities to calculate taxes for the item, typically based on the value of the goods or services.
AssetGroupNumber	String	False	No	Group identifier for customer assets, used to categorize and manage assets related to the order line.
AssetTrackedFlag	Bool	False	No	Flag indicating whether the fulfillment line is eligible for asset tracking. This attribute is used for items that are tracked in asset management systems.
AssetTrackingCode	String	False	No	Code identifying whether the item is eligible for tracking in the asset management system, providing additional context for managing customer assets.
AssetTracking	String	False	No	Detailed asset tracking status or code, specifying the tracking conditions of the item on the order line.
BillingTransactionTypeId	Long	False	No	Unique identifier for the type of billing transaction associated with the order line, used to categorize the transaction for invoicing and accounting.
BillingTransactionTypeName	String	False	No	The name of the billing transaction type, used to describe the transaction for invoicing and accounting purposes.
BuyerId	Long	False	No	Unique identifier for the buyer associated with the order line, linking to buyer-specific data within the system.
BuyerName	String	False	No	Name of the buyer for the scheduled item, used for identification and tracking within the sales order process.
BuyerFirstName	String	False	No	First name of the buyer associated with the order line, providing clarity for communication and tracking.
BuyerLastName	String	False	No	Last name of the buyer associated with the order line, used for identifying the buyer and managing the order.
BuyerMiddleName	String	False	No	Middle name of the buyer, providing additional clarity for identifying the buyer in the order management system.
CancelReasonCode	String	False	No	Code representing the reason for canceling the order line, providing a reference to predefined reasons for cancellations.
CancelReason	String	False	No	The detailed reason for canceling the order line, providing further context for the action.
CanceledFlag	Bool	False	No	Flag indicating whether the order line has been canceled. If true, the line is marked as canceled; otherwise, it remains active.
CanceledQuantity	Decimal	False	No	The quantity of the order line that was canceled, used to track the amount of items or services no longer being processed.
ShippingCarrierId	Long	False	No	Unique identifier for the carrier responsible for delivering the item, used to track the logistics and shipping process.
ShippingCarrier	String	False	No	Name of the shipping carrier delivering the item, providing clarity on the third-party responsible for transportation.
TransactionCategoryCode	String	False	No	Abbreviation representing the transaction category for the order line, such as RETURN or ORDER, used to classify the line for processing.
Comments	String	False	No	Textual comments for the order line, allowing for additional notes or details to be included for reference during order fulfillment.
ComponentIdPath	String	False	No	Unique identifier for the path from the inventory item to the parent configured item in the order line, used to track configurations.
ConfigCreationDate	Datetime	False	No	The date when the configured item was created, providing a timestamp for when custom configurations were finalized.
ConfigHeaderId	Long	False	No	Unique identifier for the order header associated with the configured item, linking the configuration to the main sales order.
ConfigInventoryItemId	Long	False	No	Inventory item ID for an assemble-to-order or configured item that can be shipped, linking it to the inventory.
ConfigInventoryItemNumber	String	False	No	Unique item number for the configured item, used to identify and track the item in the order line.
ConfigInventoryItemDescription	String	False	No	Description of the configured inventory item, providing further details on what the item represents.
ConfigItemReference	String	False	No	Reference to the finished configured item, used to link the order line to the finished product after configuration.
ConfigRevisionNumber	Long	False	No	Revision number of the configured item, used to track changes or updates to the configuration over time.
ConfigTradeComplianceResultCode	String	False	No	Code representing the trade compliance result for the configured item, used for compliance checks during order processing.
ConfigTradeComplianceResult	String	False	No	Detailed result of the trade compliance check for the configured item, providing context for regulatory compliance.
ConfiguratorPath	String	False	No	Path that identifies the inventory item for the configure option, structured in a format separated by identifiers and brackets.
ContractEndDate	Date	False	No	End date of the contract associated with the order line, used for tracking the duration of contract-based items or services.
ContractStartDate	Date	False	No	Start date of the contract, marking the beginning of the contractual obligations tied to the order line.
CreatedBy	String	False	No	The name or identifier of the person who created the order line, useful for auditing and accountability.
CreationDate	Datetime	False	No	The date and time when the order line was created, providing a timestamp for when the item was added to the order.
CreditCheckAuthExpiryDate	Datetime	False	No	The expiration date for the approved credit authorization, used to track the validity period for credit checks.
CreditCheckAuthorizationNumber	String	False	No	Unique identifier for the approved credit authorization, used for reference in credit management and validation processes.
CustomerProductId	Long	False	No	Unique identifier for the customer’s product associated with the order line, allowing for easy identification of customer-specific items.
CustomerProductNumber	String	False	No	Customer-specific product number, used for reference and tracking of custom or proprietary items.
CustomerProductDescription	String	False	No	Description of the customer’s product, providing details about the item for clarity and order processing.
CustomerPOLineNumber	String	False	No	Unique identifier for the purchase order line associated with the sales order, linking the sales order to the original purchase order.
CustomerPONumber	String	False	No	Number of the customer’s purchase order, used to track and manage the order within the sales process.
CustomerPOScheduleNumber	String	False	No	Number that identifies the schedule for shipment associated with the purchase order, helping to manage delivery times.
DefaultTaxationCountry	String	False	No	Country used by the tax authority to calculate tax, ensuring the correct tax rates are applied based on the customer's location.
DefaultTaxationCountryShortName	String	False	No	Short name of the country used for tax calculations, simplifying the tax processing by using an abbreviated country name.
DemandClassCode	String	False	No	Abbreviation representing the demand class, categorizing the order line for better management and reporting based on customer type or region.
DemandClass	String	False	No	Class of demand representing different customer categories, such as government, commercial, or retail, for tailored order processing.
DestinationLocationId	Long	False	No	Unique identifier for the location where the item is being shipped, helping to track the destination of the fulfillment.
DestinationShippingOrganizationId	Long	False	No	Identifier for the shipping organization responsible for delivering the item, linking the order to a specific fulfillment provider.
DestinationShippingOrganizationCode	String	False	No	Code representing the destination shipping organization, helping to identify the fulfillment partner in the logistics process.
DestinationShippingOrganizationName	String	False	No	Name of the destination shipping organization responsible for the delivery, providing clarity on the carrier handling the shipment.
DocumentSubtype	String	False	No	Tax classification used for tax reporting, determining how the tax on the item is calculated based on the country-specific rules.
DocumentSubtypeName	String	False	No	Name of the tax classification for reporting, specifying the nature of the tax used for the item in compliance with local tax regulations.
EarliestAcceptableShipDate	Datetime	False	No	Earliest date when the customer is willing to receive the shipment, used to define the earliest fulfillment window.
EstimateFulfillmentCost	Decimal	False	No	Estimated cost to fulfill the order line, including both item and shipping costs, helping in cost forecasting and margin calculations.
EstimateMargin	Decimal	False	No	Estimated margin on the order line, calculated by subtracting costs from the sale price to provide insight into profitability.
ExemptionCertificateNumber	String	False	No	Certification number issued by the tax authority for tax exemption, used for customers who qualify for tax-free purchases.
ExtendedAmount	Decimal	False	No	The total monetary amount for the order line, calculated by multiplying the unit price by the quantity of items ordered.
FinalDischargeLocationId	Long	False	No	Unique identifier for the final destination location of the item, helping to track where the purchase will be delivered.
FinalDischargeLocationAddressLine1	String	False	No	First line of the address for the final discharge location, providing a physical address for where the item will be delivered.
FinalDischargeLocationAddressLine2	String	False	No	Second line of the address for the final discharge location, used to provide additional address details (for example, suite, apartment).
FinalDischargeLocationAddressLine3	String	False	No	Third line of the address for the final discharge location, providing further address breakdown if necessary.
FinalDischargeLocationAddressLine4	String	False	No	Fourth line of the address for the final discharge location, capturing additional address information for the delivery.
FinalDischargeLocationAddressCity	String	False	No	City of the final discharge location, indicating the city where the item will be delivered.
FinalDischargeLocationAddressPostalCode	String	False	No	Postal code of the final discharge location, helping to identify the specific region for the shipment.
FinalDischargeLocationAddressState	String	False	No	State of the final discharge location, helping to further specify the region for accurate delivery.
FinalDischargeLocationAddressProvince	String	False	No	Province of the final discharge location, used for countries like Canada, where provinces are used instead of states.
FinalDischargeLocationAddressCounty	String	False	No	County of the final discharge location, providing additional geographic context for the delivery.
FinalDischargeLocationAddressCountry	String	False	No	Country of the final discharge location, ensuring that the shipment reaches the correct country.
FirstPartyTaxRegistration	Long	False	No	Registration number for the supplier or the first party in the transaction, used for tax purposes in international transactions.
FirstPartyTaxRegistrationNumber	String	False	No	Unique number assigned to the supplier or first party for tax registration, ensuring that tax obligations are properly managed.
FOBPointCode	String	False	No	Abbreviation representing the FOB (Free on Board) point, identifying where ownership of goods transfers between buyer and seller.
FOBPoint	String	False	No	Describes the FOB point, where the responsibility for the goods shifts from the seller to the buyer during transit.
FreightTermsCode	String	False	No	Code representing the terms under which freight charges are handled, such as prepaid or collect.
FreightTerms	String	False	No	Description of the freight terms, indicating whether the seller or buyer is responsible for shipping costs.
FulfillInstanceId	Long	False	No	Unique identifier for the fulfillment instance, used to track the fulfillment process for each line of the sales order.
FulfillLineNumber	String	False	No	Line number of the fulfillment, which is linked to the order line for the fulfillment tracking process.
RequestedFulfillmentOrganizationId	Long	False	No	Unique identifier for the organization responsible for fulfilling the order, ensuring the correct team or warehouse handles the fulfillment.
RequestedFulfillmentOrganizationCode	String	False	No	Code representing the organization responsible for fulfillment, helping to identify the location or warehouse handling the order.
RequestedFulfillmentOrganizationName	String	False	No	Name of the organization responsible for fulfilling the order, providing clarity on which business unit or team is tasked with the fulfillment.
RequestedFulfillmentOrganizationAddress1	String	False	No	Address line 1 of the fulfillment organization, helping to pinpoint the physical location of the warehouse or fulfillment center.
RequestedFulfillmentOrganizationAddress2	String	False	No	Address line 2 of the fulfillment organization, used to provide additional location details for accurate delivery.
RequestedFulfillmentOrganizationAddress3	String	False	No	Address line 3 of the fulfillment organization, providing further details when necessary.
RequestedFulfillmentOrganizationAddress4	String	False	No	Address line 4 of the fulfillment organization, used to capture extra address information for the fulfillment center.
RequestedFulfillmentOrganizationCity	String	False	No	City where the fulfillment organization is located, helping to identify the geographic location of the fulfillment center.
RequestedFulfillmentOrganizationState	String	False	No	State or region where the fulfillment organization is located, adding further context to the fulfillment location.
RequestedFulfillmentOrganizationPostalCode	String	False	No	Postal code of the fulfillment organization, aiding in the identification of the specific delivery area.
RequestedFulfillmentOrganizationCounty	String	False	No	County of the fulfillment organization, providing additional geographic context for the delivery.
RequestedFulfillmentOrganizationProvince	String	False	No	Province of the fulfillment organization, used for countries like Canada, where provinces are the administrative divisions.
RequestedFulfillmentOrganizationCountry	String	False	No	Country of the fulfillment organization, ensuring the shipment is being processed from the correct nation.
OverFulfillmentTolerance	Decimal	False	No	Tolerance for over-fulfillment, indicating the maximum allowed overage for an order line before it becomes a problem.
UnderFulfillmentTolerance	Decimal	False	No	Tolerance for under-fulfillment, specifying the maximum allowed shortfall for an order line before an issue arises.
FulfilledQuantity	Decimal	False	No	Quantity of the order line that has been fulfilled or shipped, used to track how much of the order has been processed.
SecondaryFulfilledQuantity	Decimal	False	No	Quantity of the order line that has been fulfilled in a secondary unit of measure, used when multiple units of measure are involved.
FulfillmentDate	Datetime	False	No	Date on which the order line was fulfilled, providing a timestamp for the completion of the fulfillment process.
FulfillmentMode	String	False	No	Mode used for fulfilling the order line, such as pick, pack, and ship, or other fulfillment methods.
FulfillmentSplitReferenceId	Long	False	No	Identifier used for splitting fulfillment lines, helping to manage partial fulfillments or multiple fulfillment attempts.
GopReferenceId	String	False	No	Reference ID used to link the order line to global order promising processes, ensuring availability and fulfillment are managed properly.
GopRequestRegion	String	False	No	Region associated with the global order promising request, providing regional context for the fulfillment process.
IntendedUseClassificationId	Long	False	No	Identifier for the intended use classification, used for tax and compliance purposes to define how the item will be used by the customer.
IntendedUseClassificationName	String	False	No	Name of the intended use classification, providing clarity on the intended purpose of the item for tax or regulatory purposes.
ProductId	Long	False	No	Unique identifier for the product associated with the order line, used to track the specific inventory item being ordered.
ProductNumber	String	False	No	Product number for the inventory item on the order line, helping to identify and manage the product within the system.
ProductDescription	String	False	No	Description of the product being ordered, providing detailed information about the item for the customer and system users.
InventoryOrganizationId	Long	False	No	Identifier for the inventory organization responsible for the product on the order line, ensuring the item is sourced from the correct warehouse.
InventoryOrganizationCode	String	False	No	Code representing the inventory organization, used for tracking inventory management across multiple locations.
InventoryOrganizationName	String	False	No	Name of the inventory organization, clarifying which specific warehouse or inventory management system is handling the product.
InvoiceEnabledFlag	Bool	False	No	Flag indicating whether invoicing is enabled for the order line, ensuring that the line will be processed for invoicing.
InvoiceInterfacedFlag	Bool	False	No	Flag indicating whether the order line has been interfaced with the invoicing system, allowing the line to be included in the billing process.
InvoiceableItemFlag	Bool	False	No	Flag indicating whether the item is invoiceable, ensuring that only eligible items are included in the invoice.
InvoicingRuleCode	String	False	No	Code for the invoicing rule applied to the order line, defining when and how invoicing will occur.
InvoicingRule	String	False	No	Description of the invoicing rule for the order line, outlining the specific conditions under which the item will be invoiced.
ItemSubTypeCode	String	False	No	Code representing the subcategory of the item, used to categorize items for internal processing and reporting.
ItemSubType	String	False	No	Name or description of the item subcategory, providing additional classification to help manage product types.
ItemTypeCode	String	False	No	Code representing the type of item, such as product, service, or memo line, to differentiate the nature of the line item.
LastUpdateDate	Datetime	False	No	Date and time when the order line was last updated, helping to track changes made to the line item.
LastUpdateLogin	String	False	No	User login associated with the last update to the order line, ensuring accountability for changes.
LastUpdatedBy	String	False	No	Name or identifier of the person who last updated the order line, providing traceability for modifications.
LatestAcceptableArrivalDate	Datetime	False	No	The latest date by which the customer is willing to receive the item, helping to define the time frame for delivery.
LatestAcceptableShipDate	Datetime	False	No	The latest date by which the item should be shipped, marking the end of the allowable shipping window for the customer.
TransactionLineTypeCode	String	False	No	Code representing the type of transaction line, such as purchase, return, or adjustment, used for categorizing the order line.
TransactionLineType	String	False	No	Description of the transaction line type, providing context for the nature of the order line and its processing requirements.
OnHoldFlag	Bool	False	No	Flag indicating whether the order line is on hold, used to prevent further processing until certain conditions are met.
OpenFlag	Bool	False	No	Flag indicating whether the order line is open, meaning it is still active and not completed or canceled.
OrderedQuantity	Decimal	False	No	The quantity of the item ordered, used to track the amount of product or service the customer requested.
SecondaryOrderedQuantity	Decimal	False	No	Quantity of the item ordered in a secondary unit of measure, used when multiple units of measure are involved.
OrderedUOMCode	String	False	No	Code representing the unit of measure for the ordered quantity, ensuring the correct measurement system is used.
OrderedUOM	String	False	No	Unit of measure for the ordered quantity, such as pieces, kilograms, or liters, providing clarity on how the item is quantified.
SecondaryUOMCode	String	False	No	Code for the secondary unit of measure, used for tracking items that require multiple units of measure.
SecondaryUOM	String	False	No	Secondary unit of measure used to track the order quantity, providing additional context when measuring items in multiple units.
BusinessUnitId	Long	False	No	Identifier for the business unit associated with the order line, helping to organize and track sales across different organizational units.
BusinessUnitName	String	False	No	Name of the business unit associated with the order line, providing clarity on which unit is handling the order.
OrigSystemDocumentLineReference	String	False	No	Reference from the source application linking the order line to the original document line, ensuring traceability.
OrigSystemDocumentReference	String	False	No	Reference number of the original system document, linking the order line to the originating transaction or document.
OriginalProductId	Long	False	No	Unique identifier for the product on the order line, used to track the original product before any substitutions or changes.
OriginalProductNumber	String	False	No	Original product number on the order line, used to reference the initial product before any substitutions were made.
OriginalProductDescription	String	False	No	Description of the original product on the order line, providing further context before any modifications or substitutions.
OverrideScheduleDateFlag	Bool	False	No	Flag indicating whether the user has overridden the scheduled date for shipment or fulfillment, ensuring manual changes are tracked.
OwnerId	Long	False	No	User ID of the person responsible for the order line, used for accountability and tracking of who owns or manages the line.
PackingInstructions	String	False	No	Instructions for how the order line should be packed for shipment, ensuring the correct handling and packaging of items.
ParentFulfillLineId	Long	False	No	Identifier for the parent fulfillment line, used to link child lines to the main line in cases of item bundling or configuration.
PartialShipAllowedFlag	Bool	False	No	Flag indicating whether partial shipment of the order line is allowed, defining whether the order line can be shipped in parts.
PaymentTermsCode	Long	False	No	Code representing the payment terms for the order line, defining the conditions under which payment for the line is due.
PaymentTerms	String	False	No	Description of the payment terms for the order line, outlining the agreed conditions for payment, such as net 30 days.
POStatusCode	String	False	No	Abbreviation representing the status of the purchase order associated with the sales order line, helping to track its processing state.
PricedOn	Datetime	False	No	Date when the order line was priced, marking the point at which the item’s price was finalized.
ProcessNumber	String	False	No	Unique identifier for the process that handles the order line, helping to track the flow of the order through various stages.
ProductFiscalCategoryId	Long	False	No	Identifier for the fiscal category of the product, used for tax classification and reporting.
ProductFiscalCategory	String	False	No	Name of the fiscal category assigned to the product for tax purposes, helping to manage tax rates applied to the item.
ProductCategory	String	False	No	Category used to classify the product for taxation and reporting purposes.
ProductCategoryName	String	False	No	Name of the product category for tax classification, used to specify how tax is applied to the product.
ProductType	String	False	No	Type of item, such as product, service, or memo, used to define how the item is processed and billed.
ProductTypeName	String	False	No	Descriptive name for the product type, providing more context on the nature of the item.
PromiseArrivalDate	Datetime	False	No	Date when the global order promising system promises the item will arrive at the customer location.
PromiseShipDate	Datetime	False	No	Date when the global order promising system promises the item will ship, giving customers a clear expectation of the shipment.
PurchasingEnabledFlag	Bool	False	No	Flag indicating whether the item can be included on a purchase order, ensuring that only eligible items are processed for procurement.
PurchasingUOMCode	String	False	No	Unit of measure used in purchasing for the item, helping to ensure that procurement matches the correct measurement system.
PurchasingUOM	String	False	No	Description of the unit of measure for purchasing, such as boxes, kilograms, or liters, to match supplier requirements.
QuantityForEachModel	Decimal	False	No	Quantity for each model in a configured product, used for items that involve configurable options.
ReceivablesOrgId	Long	False	No	Identifier for the receivables organization associated with the order line, used to manage financial transactions.
ReceivablesOrgName	String	False	No	Name of the receivables organization, providing clarity on which business unit handles the financial aspects of the order line.
RemnantFlag	Bool	False	No	Flag indicating whether the order line is a remnant item, which may refer to leftover or surplus stock from a previous order.
RequestedArrivalDate	Datetime	False	No	Original date requested by the customer for when the item should arrive, used to manage delivery expectations.
RequestedCancelDate	Datetime	False	No	Date when the customer requested to cancel the order line, used for processing cancellations and managing customer expectations.
RequestedShipDate	Datetime	False	No	Original date requested by the customer for when the item should ship, helping to define shipping deadlines.
RequiredFulfillmentDate	Datetime	False	No	Date by which the customer requires the order line to be fulfilled, ensuring the fulfillment process meets customer needs.
RequisitionBusinessUnitId	Long	False	No	Identifier for the business unit that generated the requisition, linking the order line to the requisition process.
RequisitionBusinessUnitName	String	False	No	Name of the business unit that generated the requisition, providing clarity on which unit is responsible for the requisition.
RequisitionInventoryOrganizationId	Long	False	No	Identifier for the inventory organization handling the requisition, helping to manage stock and supply chain logistics.
RequisitionInventoryOrganizationCode	String	False	No	Code representing the inventory organization responsible for the requisition, ensuring proper coordination in supply.
RequisitionInventoryOrganizationName	String	False	No	Name of the inventory organization handling the requisition, providing context for where the item is being sourced from.
ReservableFlag	Bool	False	No	Flag indicating whether the item can be reserved for fulfillment, ensuring that inventory is available for order processing.
ReservationId	Long	False	No	Identifier for the reservation associated with the order line, used to track the inventory allocated for the order.
ReservedQuantity	Decimal	False	No	Quantity of the order line that has been reserved, ensuring that sufficient stock is available for fulfillment.
ReturnReasonCode	String	False	No	Code identifying the reason for returning an item, helping to categorize and process return requests.
ReturnReason	String	False	No	Description of the reason for returning the item, providing context for the customer’s return request.
ReturnableFlag	Bool	False	No	Flag indicating whether the order line item is eligible for return, ensuring that only returnable items are processed.
RMADeliveredQuantity	Decimal	False	No	Quantity of the item delivered under the Return Material Authorization (RMA) process, helping to track returns and exchanges.
SecondaryRMADeliveredQuantity	Decimal	False	No	Secondary quantity of the item delivered under the RMA process, used when multiple units of measure are involved.
RootParentFulfillLineId	Long	False	No	Identifier for the root parent fulfillment line, used to track the primary line when there are sublines or configurations involved.
SalesProductTypeCode	String	False	No	Code representing the type of product being sold, such as physical product, service, or subscription.
SalesProductType	String	False	No	Descriptive name for the sales product type, clarifying whether the item is a physical product, service, or other type of offering.
SalespersonId	Long	False	No	Unique identifier for the salesperson associated with the order line, linking the line to the individual responsible for the sale.
Salesperson	String	False	No	Name of the salesperson responsible for the order line, providing accountability and contact information for the sales team.
ScheduleArrivalDate	Datetime	False	No	Scheduled date for the arrival of the item, helping to manage delivery expectations and inventory planning.
ScheduleShipDate	Datetime	False	No	Scheduled date for the shipment of the order line, marking when the item is expected to leave the warehouse.
SchedulingReason	String	False	No	Reason for the scheduled shipment or arrival of the item, providing context for the fulfillment timeline.
SchedulingReasonCode	String	False	No	Code representing the reason for the scheduled shipment or arrival, helping to categorize scheduling actions.
ServiceDuration	Decimal	False	No	Duration of service coverage or subscription for the order line, indicating the length of the service or subscription period.
ServiceDurationPeriodCode	String	False	No	Code representing the unit of measure for the service duration, such as months, days, or years.
ServiceDurationPeriodName	String	False	No	Name of the unit of measure for the service duration, clarifying how the coverage or subscription period is defined.
ShippingServiceLevelCode	String	False	No	Code representing the shipping service level used for the order line, such as standard or expedited shipping.
ShippingServiceLevel	String	False	No	Descriptive name for the shipping service level, providing clarity on the level of service provided for shipping.
ShippingModeCode	String	False	No	Code representing the mode of transport for shipping the order line, such as ground, air, or sea.
ShippingMode	String	False	No	Name of the mode of transport for shipping, helping to identify how the item will be delivered to the customer.
ShipSetName	String	False	No	Name of the group of order lines that must ship together from one location to one destination, often used for grouped shipments.
ShipmentPriorityCode	String	False	No	Code representing the priority level for the shipment, such as high, medium, or low priority.
ShipmentPriority	String	False	No	Descriptive name for the shipment priority level, clarifying the urgency or importance of the shipment.
ShippableFlag	Bool	False	No	Flag indicating whether the item is eligible to be shipped, ensuring that only shippable items are processed.
ShippedQuantity	Decimal	False	No	Quantity of the order line that has been shipped to the customer, used to track fulfillment progress.
SecondaryShippedQuantity	Decimal	False	No	Secondary quantity of the item shipped, used when tracking multiple units of measure for the order line.
ShippedUOMCode	String	False	No	Code representing the unit of measure for the shipped quantity, ensuring that the right unit is used for the fulfillment.
ShippedUOM	String	False	No	Unit of measure for the shipped quantity, such as boxes, pallets, or units, to ensure the correct measure is used.
ShippingInstructions	String	False	No	Special instructions for shipping the order line, detailing any specific handling, packaging, or delivery requirements.
ShowInSales	Int	False	No	Flag determining whether a configured item should be displayed in sales views, such as on the sales summary or configurator pages.
SourceTransactionRevisionNumber	Long	False	No	Revision number of the transaction in the source system, used to track different versions of the same transaction.
SourceTransactionScheduleId	String	False	No	Unique identifier for the schedule or subline in the source application, used to track the timing and details of the original transaction.
SourceScheduleNumber	String	False	No	Schedule number assigned by the source system, used for tracking and referencing shipment or order schedules.
SplitFromFlineId	Long	False	No	Identifier for the original fulfillment line from which this line was split, helping to manage partial fulfillments or modifications.
StatusCode	String	False	No	Code representing the status of the order line, such as open, shipped, or canceled, to track the progress of the line.
Status	String	False	No	Descriptive name for the status of the order line, providing clarity on its current state in the fulfillment process.
SubinventoryCode	String	False	No	Code for the subinventory where the item is stored, used to track the location of the product within the warehouse or inventory system.
Subinventory	String	False	No	Descriptive name for the subinventory location, helping to identify where the item is stored or sourced from within the warehouse.
SubstitutionAllowedFlag	Bool	False	No	Flag indicating whether the item on the order line is allowed to be substituted with another product, typically due to stock issues.
SubstitutionReasonCode	String	False	No	Code representing the reason for substituting the item on the order line, such as out of stock or customer preference.
SubstitutionReason	String	False	No	Descriptive reason for why a substitution is being made for the order line item, providing context for the action.
SupplierId	Long	False	No	Unique identifier for the supplier providing the item on the order line, helping to track procurement details.
SupplierName	String	False	No	Name of the supplier providing the item on the order line, used for reference and accountability.
SupplierSiteId	Long	False	No	Unique identifier for the supplier site associated with the order line, used to track which location is fulfilling the order.
SupplierSiteName	String	False	No	Name of the supplier site, helping to identify the specific location fulfilling the order.
SupplyStatusCode	String	False	No	Code representing the status of the supply for the fulfillment line, helping to track whether the supply is on schedule or delayed.
TaxClassificationCode	String	False	No	Code representing the tax classification for the item, used to apply appropriate tax rules to the order line.
TaxClassification	String	False	No	Name or description of the tax classification for the item, helping to ensure proper tax treatment based on product type.
TaxExemptFlag	Bool	False	No	Flag indicating whether the item on the order line is tax-exempt, ensuring the correct tax rates are applied.
TaxExemptCode	String	False	No	Code indicating whether the item is exempt from tax, used for proper tax reporting and processing.
TaxExempt	String	False	No	Tax exemption status of the order line, providing clarity on whether the item qualifies for tax exemption.
TaxExemptReasonCode	String	False	No	Code representing the reason for tax exemption, used to categorize and process exemptions in tax reporting.
TaxExemptReason	String	False	No	Description of the reason why the item is tax-exempt, helping to provide context for the exemption.
TaxInvoiceDate	Date	False	No	Date of the tax invoice, used for tax reporting based on the requirements of different countries.
TaxInvoiceNumber	String	False	No	Invoice number used for tax reporting purposes, ensuring proper identification of tax-related transactions.
ThirdPartyTaxRegistration	Long	False	No	Registration number provided by the third party, used for tax compliance and reporting purposes.
ThirdPartyTaxRegistrationNumber	String	False	No	Unique number assigned to the third party for tax registration, used for tracking tax obligations.
TotalContractAmount	Decimal	False	No	Total amount for the contract duration, representing the full value of the contract over its term.
TotalContractQuantity	Decimal	False	No	Total quantity for the contract duration, accounting for all quantities over the term of the contract.
TradeComplianceDate	Datetime	False	No	Date when the trade compliance check was performed on the order line, ensuring compliance with export and import regulations.
TradeComplianceResultCode	String	False	No	Code representing the result of the trade compliance check, used for categorizing compliance statuses.
TradeComplianceResult	String	False	No	Description of the trade compliance result, helping to provide context for the outcome of the compliance check.
TransportationPlannedFlag	Bool	False	No	Flag indicating whether transportation planning has been performed for the fulfillment line, ensuring logistical planning is complete.
TransportationPlannedStatusCode	String	False	No	Code representing the status of the transportation planning for the fulfillment line, indicating whether the shipment is scheduled.
TransactionBusinessCategory	String	False	No	Tax classification required by the tax authority for reporting and tax calculation.
TransactionBusinessCategoryName	String	False	No	Name of the tax classification required by the tax authority for transaction reporting.
UnitListPrice	Decimal	False	No	Selling price for each unit of the item, before discounts are applied, representing the base price of the item.
UnitQuantity	Decimal	False	No	Quantity of units for the item in the order line, used to calculate the total quantity ordered.
UnitSellingPrice	Decimal	False	No	Price the customer pays for one unit of the item, after any applicable discounts or adjustments.
UserDefinedFiscalClass	String	False	No	Tax classification defined by the user for custom tax handling.
UserDefinedFiscalClassName	String	False	No	Name of the user-defined fiscal class, allowing custom tax classifications to be applied based on user input.
ValidConfigurationFlag	Bool	False	No	Flag indicating whether the configured item is valid, used to ensure that only valid configurations are processed.
LineNumber	Int	False	No	The line number of the order line, used to track the sequence and position of the line in the sales order.
DisplayLineNumber	String	False	No	Display number of the order line, used for presenting the line in a user-friendly format.
ParentSourceTransactionLineId	String	False	No	Unique identifier for the parent transaction line in the source application, used to track hierarchical relationships for configured items.
TransformFromLineId	Long	False	No	Identifier for the original fulfillment line from which the order line was transformed, tracking the changes in the order process.
UnreferencedReturnFlag	Bool	False	No	Flag indicating whether the order line is marked for unreferenced return, used to track return items that are not associated with the original order.
ServiceCancelDate	Datetime	False	No	Date when the customer canceled a service-related item, used to manage the cancellation of subscriptions or coverage services.
CoveredProductId	Long	False	No	Unique identifier for the product covered by the coverage item, used to link the coverage to the specific product.
CoveredProductNumber	String	False	No	Product number for the product covered by the coverage item, ensuring the coverage applies to the correct product.
CoveredProductDescription	String	False	No	Description of the product covered by the coverage item, providing further context for the relationship between the product and its coverage.
CoveredCustomerProductId	Long	False	No	Unique identifier for the customer’s product covered by the coverage item, linking the coverage to the customer’s inventory.
CoveredCustomerProductNumber	String	False	No	Product number for the customer’s product covered by the coverage item, ensuring correct matching of coverage to customer product.
CoveredCustomerProductDescription	String	False	No	Description of the customer’s product covered by the coverage item, providing clarity on the customer’s covered item.
JeopardyPriorityCode	String	False	No	Code representing the jeopardy priority for the order line, indicating the urgency of processing based on certain conditions.
JeopardyPriority	String	False	No	Descriptive priority of the order line, representing how urgent the line is in terms of fulfillment and delivery.
AgreementHeaderId	Long	False	No	Unique identifier for the agreement header associated with the order line, used to link the line to a sales agreement.
AgreementLineId	Long	False	No	Line identifier for the agreement, used to link the order line to a specific line item in the sales agreement.
AgreementLineNumber	String	False	No	Line number in the agreement, helping to reference the specific item in a sales agreement associated with the order line.
AgreementVersionNumber	Long	False	No	Version number of the agreement, used to track revisions and updates made to the original agreement.
AgreementNumber	String	False	No	Number identifying the agreement, used to link the order line to the corresponding agreement for fulfillment.
SellingProfitCenterBusinessUnitId	Long	False	No	Unique identifier for the business unit responsible for the profit center associated with the sale, helping to track profitability.
SellingProfitCenterBusinessUnitName	String	False	No	Name of the business unit handling the profit center, providing clarity on the profit responsibility for the order line.
TransportationPlanningOrder	String	False	No	Unique identifier for the transportation planning order, used for managing transportation and shipping schedules for the fulfillment.
ContractEndDateTime	Datetime	False	No	End date and time for the contract, determining the final date when the contract is valid and services are provided.
ContractStartDateTime	Datetime	False	No	Start date and time for the contract, marking the beginning of the contractual obligations and services.
SubscriptionProfileId	Long	False	No	Unique identifier for the subscription profile, used to link the order line to a specific subscription offering.
SubscriptionProfileName	String	False	No	Name of the subscription profile associated with the order line, helping to identify the type of subscription.
ExternalPriceBookName	String	False	No	Name of the external price book used for pricing the order line, linking to the pricing rules in an external pricing system.
EndReasonCode	String	False	No	Code representing the reason for ending or closing the subscription, used to track why a subscription was terminated.
EndReason	String	False	No	Detailed reason for ending or closing the subscription, providing context for the termination of services.
EndCreditMethodCode	String	False	No	Code representing the credit method used for ending or closing the subscription, ensuring correct processing of credits or refunds.
EndCreditMethod	String	False	No	Description of the credit method used for ending or closing the subscription, providing further context for the termination process.
EndDate	Datetime	False	No	Date when the subscription or service ends, marking the end of the contract or coverage.
InventoryTransactionFlag	Bool	False	No	Flag indicating whether an inventory transaction is triggered by fulfilling the order line, ensuring inventory adjustments are processed.
InventoryInterfacedFlag	Bool	False	No	Flag indicating whether the order line has been interfaced with the inventory system for tracking and management.
PriceUsingSecondaryUOMFlag	Bool	False	No	Flag indicating whether the price for the item is based on a secondary unit of measure, used for cases where multiple units of measure are involved.
SubscriptionInterfacedFlag	Bool	False	No	Flag indicating whether the subscription details for the order line have been interfaced with a subscription management system.
SupplierAddress1	String	False	No	First address line for the supplier, used to identify the supplier’s location for shipping or invoicing purposes.
SupplierAddress2	String	False	No	Second address line for the supplier, providing additional address details for accurate identification.
SupplierAddress3	String	False	No	Third address line for the supplier, used for further specifying the supplier’s delivery or billing address.
SupplierAddress4	String	False	No	Fourth address line for the supplier, capturing any extra address details needed for the supplier’s location.
SupplierCity	String	False	No	City of the supplier, helping to identify the geographic location for shipment or invoicing purposes.
SupplierState	String	False	No	State of the supplier, used to identify the region of the supplier’s address for shipping and delivery.
SupplierPostalCode	String	False	No	Postal code of the supplier, used for precise identification of the location for shipping and invoicing.
SupplierProvince	String	False	No	Province of the supplier, relevant for countries like Canada, where provinces are used instead of states.
SupplierCounty	String	False	No	County of the supplier, providing additional geographical context for shipping or invoicing.
SupplierCountry	String	False	No	Country of the supplier, used for identifying the supplier’s country of operation and for international shipping.
RatePlanId	Long	False	No	Unique identifier for the rate plan applied to the order line, linking the order to a specific pricing model or scheme.
RatePlanNumber	String	False	No	Rate plan number used to identify the specific rate plan applied to the order line for pricing purposes.
RatePlanName	String	False	No	Name of the rate plan applied to the order line, providing a descriptive title for the pricing model.
RequestedRatePlanId	Long	False	No	Identifier for the rate plan requested by the user, linking to the external pricing system for the order line.
RequestedRatePlanNumber	String	False	No	Number identifying the rate plan requested by the user, used to reference external pricing details.
RequestedRatePlanName	String	False	No	Name of the rate plan requested by the user, providing clarity on the pricing model the customer selected.
RatePlanDocumentId	Long	False	No	Unique identifier for the rate plan document, used to reference the associated documentation in JSON format for the pricing model.
RatePlanDocument	String	False	No	Document in JSON format containing the details of the rate plan, encoded using Base64, to capture all pricing information.
OrchestrationProcessName	String	False	No	Name of the orchestration process assigned to the order line, ensuring that the order is handled through the correct workflow.
IntegrateSubscriptionFlag	Bool	False	No	Flag indicating whether the order line is integrated with a subscription management system for processing.
DemandSourceLineReference	String	False	No	Reference that uniquely identifies the demand for the item, such as the order line in a shopping cart on a web store.
DemandSourceScheduledFlag	Bool	False	No	Flag indicating whether the demand has been scheduled in the order management system, ensuring demand is processed accordingly.
CancelBackordersFlag	Bool	False	No	Flag indicating whether backorders should be canceled if they cannot be fulfilled during the shipping process.
EnforceSingleShipmentFlag	Bool	False	No	Flag indicating whether multiple shipments for the same order line should be allowed. If set to true, only one shipment is allowed.
Finder	String	False	No	A tool or method used to search and locate specific order lines within the system
FromDate	Date	False	No	Start date for the order line, defining the period when the order line is valid and should be processed.
OrderKey	String	False	No	Key used to uniquely identify the order line within the system, ensuring it can be tracked throughout the fulfillment process.
OrderNumber	String	False	No	Order number assigned to the sales order, providing a unique identifier for tracking and managing the order.
ToDate	Date	False	No	End date for the order line, marking when the order line is no longer valid or when the fulfillment process should end.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the header of the sales order, used to link the order line to the parent order for processing and tracking.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the order line, used to track the fulfillment process for specific items in the order.
Category	String	False	No	Category to which the additional information for the order line belongs, used to classify and manage the data associated with the line.
FulfillLineId [KEY]	Long	False	No	Identifier for the specific fulfillment line, used to track the logistics and shipping details for the order line.
HeaderId	Long	False	No	Unique identifier for the order header, helping to manage and track the order across various stages of the sales and fulfillment process.
SourceTransactionLineIdentifier	String	False	No	Unique identifier from the source system for the transaction line, used to track and reference the original data from the external system.
SourceTransactionSystem	String	False	No	The name of the source system from which the transaction originated, providing context for the origin of the order line data.
SourceTransactionScheduleIdentifier	String	False	No	Unique identifier for the transaction schedule from the source system, linking the order line to the schedule in the original transaction.
Finder	String	False	No	Tool or method used to search and locate the order line in the system, typically for filtering or identifying specific order lines based on given parameters.
FromDate	Date	False	No	Start date for the additional information on the order line, marking the period during which the information is valid or applicable.
OrderKey	String	False	No	Unique key identifying the order line within the system, ensuring it can be tracked and referenced across processes.
OrderNumber	String	False	No	Order number assigned to the sales order, used for tracking and managing the order throughout its lifecycle.
SourceTransactionNumber	String	False	No	Number assigned to the transaction in the source system, used to trace the order line back to the originating transaction in an external system.
ToDate	Date	False	No	End date for the additional information on the order line, marking the period when the information is no longer valid or applicable.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the order header in the sales order, used to link the line to the parent order and track its lifecycle.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line related to the order line, used to track and manage the fulfillment process for the item.
ExternalAssetKey	String	False	No	Unique value identifying the asset key for the subscription or coverage item in an external system, used to integrate with third-party applications.
ExternalParentAssetKey	String	False	No	Unique value identifying the parent asset key for the subscription or coverage item in an external system, helping to establish hierarchical relationships between assets.
ExternalRootParentAssetKey	String	False	No	Unique value identifying the root parent asset key for the subscription or coverage item in an external system, used to track the ultimate parent in asset management.
SubscriptionProductPuid	String	False	No	Unique identifier for the subscription product in Oracle Subscription Management Cloud, ensuring the correct product is linked to the order line.
Finder	String	False	No	Tool or method used to search and locate the subscription reference within the system, facilitating efficient querying and retrieval of specific records.
FromDate	Date	False	No	Start date for the amendment or subscription reference, marking the period during which the changes or references are applicable.
HeaderId	Long	False	No	Identifier for the order header associated with the amendment or subscription reference, ensuring that the line is connected to the correct order.
OrderKey	String	False	No	Unique key for identifying the order line, used to track the line throughout the sales order process and provide a reference for external systems.
OrderNumber	String	False	No	Order number assigned to the sales order, used for tracking and managing the order across various stages in the fulfillment process.
SourceTransactionNumber	String	False	No	Number assigned to the transaction in the source system, used to trace the order line back to the originating transaction.
SourceTransactionSystem	String	False	No	Name of the system from which the transaction originated, providing context for the origin of the data related to the order line.
ToDate	Date	False	No	End date for the amendment or subscription reference, marking the period when the changes or references are no longer valid.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the order header, linking the asset transaction details to the parent sales order and enabling cross-referencing of order-related information.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the asset transaction details, helping to track the specific order line involved in the transaction.
AssetTransactionDetailId [KEY]	Long	False	No	Unique value identifying the asset transaction detail for a specific order line, enabling precise tracking of each asset's transaction.
FulfillLineId	Long	False	No	Identifier for the specific fulfillment line that contains the asset transaction details, used to tie the asset data to the correct line in the order.
SourceAssetTransactionDetailId	String	False	No	Unique identifier for the asset transaction detail assigned by the source application, used to trace the transaction back to its origin.
AssetId	Long	False	No	Unique identifier for the asset being transacted, used to link the asset to the order line and track its history.
AssetNumber	String	False	No	Number assigned to the asset, helping to identify and track the specific asset involved in the transaction.
Quantity	Decimal	False	No	Quantity of the asset transacted, tracking the number of units affected by the asset transaction within the installed base.
AssetUOMCode	String	False	No	Code representing the unit of measure for the asset quantity, used to define how the asset quantity is measured (for example, pieces, meters).
AssetUOM	String	False	No	Unit of measure for the asset quantity, ensuring that the quantity is properly recorded in the correct measurement system.
StatusId	Long	False	No	Unique identifier for the status of the asset after the transaction is performed, tracking the asset's current state within the system.
StatusCode	String	False	No	Abbreviation representing the status of the asset after the transaction, used to categorize the asset’s condition post-transaction.
Status	String	False	No	Description of the asset’s status after the transaction, providing additional context for the asset’s condition or processing state.
AssetTransactionActionCode	String	False	No	Code identifying the type of transaction performed on the asset, categorizing actions such as installation, transfer, or return.
AssetTransactionAction	String	False	No	Name of the transaction performed on the asset, describing the action taken, such as 'installation' or 'deactivation'.
CustomerAssetEndDate	Datetime	False	No	Date and time when the asset's lifecycle ends within the installed base, marking the point when the asset is no longer active or available for use.
CreatedBy	String	False	No	Identifier for the user who created the asset transaction details, providing traceability and accountability for the creation process.
CreationDate	Datetime	False	No	Date and time when the asset transaction details were created, ensuring proper record-keeping for asset management and order processing.
LastUpdatedBy	String	False	No	Identifier for the user who last updated the asset transaction details, ensuring traceability of modifications made to the record.
LastUpdateDate	Datetime	False	No	Date and time when the asset transaction details were last updated, providing an audit trail for changes made to the asset's transaction information.
LastUpdateLogin	String	False	No	Login identifier for the user who last updated the asset transaction details, helping to trace changes to the asset record.
Finder	String	False	No	Tool or method used to search and locate specific asset transaction details, helping to filter and retrieve relevant asset records efficiently.
FromDate	Date	False	No	Start date for the asset transaction details, marking the beginning of the period during which the transaction details are valid.
HeaderId	Long	False	No	Unique identifier for the asset transaction header, linking the transaction details to the broader asset management process.
OrderKey	String	False	No	Unique key identifying the order line associated with the asset transaction details, ensuring accurate tracking of the transaction within the sales order.
OrderNumber	String	False	No	Order number assigned to the sales order, used to reference and track the order line within the broader order processing system.
SourceTransactionNumber	String	False	No	Transaction number assigned by the source system, linking the asset transaction details to the originating system for tracking purposes.
SourceTransactionSystem	String	False	No	Name of the source transaction system, providing context for where the asset transaction originated and how it is integrated with other systems.
ToDate	Date	False	No	End date for the asset transaction details, marking the point at which the transaction details are no longer valid or applicable.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the attachment to the parent order and enabling cross-referencing between order lines and attachments.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the order, used to track the specific line for which the attachment is provided.
AttachedDocumentId [KEY]	Long	False	No	Unique identifier for the attached document, ensuring that each attachment can be distinctly referenced in the system.
LastUpdateDate	Datetime	False	No	Date and time when the attachment was last updated, providing a timestamp for when the last changes were made to the attachment record.
LastUpdatedBy	String	False	No	Username of the person who last updated the attachment details, enabling traceability for changes made to the attachment record.
DatatypeCode	String	False	No	Abbreviation that identifies the data type of the attachment, used to categorize the attachment based on its content type (for example, PDF, image).
FileName	String	False	No	Name of the attachment file, helping to identify the file in the system and allowing users to locate or download the attachment.
DmFolderPath	String	False	No	Path to the folder where the attachment is stored, used to locate the directory containing the file within the document management system.
DmDocumentId	String	False	No	Unique identifier for the document in the document management system, ensuring that the attachment is accurately linked to its corresponding document.
DmVersionNumber	String	False	No	Version number of the attached document, used to track and differentiate between different versions of the same document.
Url	String	False	No	URL (Uniform Resource Locator) that links directly to the attachment file, allowing users to access or download the attachment via the web.
CategoryName	String	False	No	Name of the category assigned to the attachment, used to classify attachments and facilitate searches or filtering by category.
UserName	String	False	No	Username of the person who uploaded the attachment, providing accountability and traceability for who added the file.
Uri	String	False	No	URI (Uniform Resource Identifier) that uniquely identifies the attachment file, offering a standard reference for the attachment within the system.
FileUrl	String	False	No	URL that locates the attachment file, ensuring users can access the file directly via the provided link.
UploadedText	String	False	No	Text or content that the attachment contains, offering a brief summary or description of the attachment’s contents.
UploadedFileContentType	String	False	No	Content type of the uploaded attachment file, describing its format.
UploadedFileLength	Long	False	No	Length of the attachment file, in bytes, providing information on the size of the file for storage and transfer considerations.
UploadedFileName	String	False	No	Name of the file that was uploaded, which may include the document title, extension, or any user-defined name.
ContentRepositoryFileShared	Bool	False	No	Flag indicating whether the attachment file is shared in the content repository. If true, the file is shared; if false, it is not.
Title	String	False	No	Title of the attachment, used for identifying and describing the content of the file when it is displayed in user interfaces.
Description	String	False	No	Detailed description of the attachment, providing context or additional information about the file’s contents or purpose.
ErrorStatusCode	String	False	No	Code representing the status of the attachment upload process, used to identify any issues encountered during the upload.
ErrorStatusMessage	String	False	No	Message describing any error that occurred during the attachment upload, helping to troubleshoot and resolve issues.
CreatedBy	String	False	No	Username of the person who created the attachment record, ensuring accountability and traceability for the attachment’s initial creation.
CreationDate	Datetime	False	No	Date and time when the attachment was created in the system, providing a record of when the attachment was first added.
FileContents	String	False	No	Raw content of the attachment file, stored as a string, typically for text-based attachments or metadata extraction.
ExpirationDate	Datetime	False	No	Date and time when the attachment is set to expire, helping to manage and track the lifecycle of temporary or time-sensitive files.
LastUpdatedByUserName	String	False	No	Username of the person who last updated the attachment, providing traceability for any modifications made to the attachment record.
CreatedByUserName	String	False	No	Username of the person who initially created the attachment, ensuring accountability for the upload process.
AsyncTrackerId	String	False	No	Identifier used for tracking the progress of file uploads in asynchronous processes, enabling monitoring of file status during uploads.
FileWebImage	String	False	No	Path or identifier for a web image version of the attachment, used to display a thumbnail or preview of the file on user interfaces.
DownloadInfo	String	False	No	JSON object containing metadata and information used to retrieve the attachment file programmatically, facilitating automation and file management.
PostProcessingAction	String	False	No	Name of the action that can be performed after the attachment is uploaded, providing users with options for processing the file further (for example, indexing, categorization).
Finder	String	False	No	Method or tool used to search for and locate specific attachment records, helping to filter and identify relevant attachments in the system.
FromDate	Date	False	No	Start date from which the attachment is valid, indicating when the attachment information should start being considered.
HeaderId	Long	False	No	Identifier for the header of the order line, linking the attachment to the overall order and ensuring it is associated with the correct order line.
OrderKey	String	False	No	Key used to uniquely identify the order line associated with the attachment, ensuring the attachment is tied to the correct transaction.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used for tracking the order throughout its lifecycle.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the attachment to its original transaction in external systems.
SourceTransactionSystem	String	False	No	Name of the system from which the transaction originated, providing context for the attachment’s origin and data flow.
ToDate	Date	False	No	End date after which the attachment is no longer valid or relevant, marking the end of the period during which the attachment should be considered.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the billing plan to the parent order and enabling tracking of the billing details across all order lines.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line related to the order, helping to associate the billing plan with the specific line item being billed.
BillingNumberOfPeriods	Int	False	No	Number of billing periods in a recurring invoice, representing how many timeframes the billing plan spans across for the recurring charges.
BillingPeriodEndDate	Date	False	No	End date of the billing period, marking the conclusion of the billing timeframe. The application sets this to the contract's end date for the first period, adjusting it for subsequent periods if necessary.
BillingPeriodNumber	Int	False	No	Timeframe number representing a specific billing period, helping to track and sequence billing timeframes in a recurring billing cycle.
BillingPeriodStartDate	Date	False	No	Start date of the billing period, marking the beginning of the billing timeframe. For the first period, this is set to the contract's start date, and adjusted for subsequent periods if applicable.
BillingPlanId [KEY]	Long	False	No	Unique identifier for the billing plan, used to associate a sales order line with a specific recurring billing or milestone plan.
BillingPlanTypeCode	String	False	No	Code that identifies the type of billing plan, such as periodic (for recurring billing) or milestone-based (for specific payment events tied to the contract).
BillingPlanType	String	False	No	Name describing the type of billing plan, providing context for how the billing is structured (for example, monthly, milestone-based).
BillingTransactionDate	Date	False	No	Date when the first invoice for the billing plan occurs, used to mark the start of the recurring billing cycle or identify the date for the next invoice.
CancellationEffectiveDate	Date	False	No	Date when recurring billing is canceled, marking when no further billing occurs for the plan, and indicating the end of the customer’s commitment.
NetBillingAmountForEachPeriod	Decimal	False	No	Net amount billed for each billing period, representing the charge for the specific timeframe in the billing plan.
OverridePeriod	Int	False	No	Billing period that includes an override amount, typically used to adjust the amount or quantity for a particular billing period.
OverridePeriodAmount	Decimal	False	No	Amount applied as an override for a specific billing period, used to adjust or modify the normal billing amount for that period.
OverridePeriodQuantity	Decimal	False	No	Quantity to apply for calculating the recurring billing or credit for the overridden period, affecting the total billable amount.
PeriodicityCode	String	False	No	Code representing the frequency of the recurring billing, such as Day, Week, Month, Quarter, or Year.
Periodicity	String	False	No	Name of the frequency of the recurring invoice, providing a clearer description of how often the billing occurs (for example, monthly, annually).
SourceBillingPlanId	String	False	No	Unique identifier for the billing plan assigned by the source application, linking the sales order line to an external billing system for tracking.
Finder	String	False	No	Tool or method used to search and locate the billing plan details within the system, facilitating easy retrieval and management of billing information.
FromDate	Date	False	No	Start date from which the billing plan is valid, marking the beginning of the billing cycle or period for the order line.
HeaderId	Long	False	No	Unique identifier for the order header related to the billing plan, helping to associate the billing plan with the parent order.
OrderKey	String	False	No	Key used to uniquely identify the order line associated with the billing plan, ensuring accurate tracking of billing details for specific items.
OrderNumber	String	False	No	Order number assigned to the sales order, used to track and manage the order across various stages in the fulfillment and billing process.
SourceTransactionNumber	String	False	No	Transaction number from the source system, used to link the billing plan to its originating transaction in the external system.
SourceTransactionSystem	String	False	No	Name of the source transaction system, providing context for where the billing plan originated and ensuring proper integration with external systems.
ToDate	Date	False	No	End date until which the billing plan is valid, marking when the billing plan ends or when the final recurring charge is applied.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the bill-to customer details to the parent order for tracking and reference.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the order, helping to connect the bill-to customer details with the specific order line.
AddressId [KEY]	Long	False	No	Unique identifier for the bill-to customer address, ensuring accurate billing information is associated with the correct location.
CustomerAccountId	Long	False	No	Unique identifier for the account that is legally responsible for payment, representing the relationship between the deploying company and the customer.
PartyName	String	False	No	Name of the party (either an individual or organization) responsible for making payments for the order, linked to the customer account.
AccountDescription	String	False	No	Description of the customer account responsible for payment, providing context about the account, such as type or purpose.
AccountNumber	String	False	No	Account number for the customer responsible for payment, used for referencing the customer's payment account in the billing system.
PersonFirstName	String	False	No	First name of the person responsible for payment, if the payer is an individual, ensuring proper identification for personal accounts.
PersonLastName	String	False	No	Last name of the person responsible for payment, included if the payer is an individual, helping to identify the responsible person.
PersonMiddleName	String	False	No	Middle name of the individual responsible for payment, helping to provide complete identification for personal accounts.
PersonNameSuffix	String	False	No	Suffix of the individual’s name responsible for payment (for example, Jr., Sr., III), helping to fully identify the individual responsible for payment.
PersonTitle	String	False	No	Title (for example, Mr., Mrs., Dr.) of the person responsible for payment, adding a formal layer of identification.
SiteUseId	Long	False	No	Unique identifier for the billing site associated with the account, used to specify which address is linked to the billing process.
Address1	String	False	No	First line of the bill-to customer address, typically used for the street address, ensuring accuracy in billing information.
Address2	String	False	No	Second line of the bill-to customer address, used for additional address details (for example, apartment or suite number), ensuring full address accuracy.
Address3	String	False	No	Third line of the bill-to customer address, used when more address detail is needed to fully specify the billing location.
Address4	String	False	No	Fourth line of the bill-to customer address, for any extra address details that are required for accurate billing or delivery.
City	String	False	No	City of the bill-to customer address, identifying the city for proper address formatting and delivery.
State	String	False	No	State of the bill-to customer address, helping to determine the region for tax and shipping purposes.
PostalCode	String	False	No	Postal code of the bill-to customer address, ensuring proper routing and delivery of bills or invoices.
County	String	False	No	County of the bill-to customer address, used for specific regional or jurisdictional tax purposes and identifying the area within the state.
Province	String	False	No	Province of the bill-to customer address, used when applicable (for example, Canada) for addressing purposes and regional tax assessments.
Country	String	False	No	Country of the bill-to customer address, helping to identify the country for international shipping and tax purposes.
ContactId	Long	False	No	Unique identifier for the contact person associated with the billing account, enabling reference to specific individuals for communications.
ContactName	String	False	No	Full name of the person to contact at the bill-to customer site, helping to identify the responsible individual for payment inquiries.
ContactNumber	String	False	No	Phone number of the person to contact at the bill-to customer site, ensuring easy communication for billing matters.
ContactFirstName	String	False	No	First name of the person to contact at the bill-to customer site, useful for addressing the individual in communications.
ContactMiddleName	String	False	No	Middle name of the contact person at the bill-to customer site, providing further details for identifying the individual.
ContactLastName	String	False	No	Last name of the contact person at the bill-to customer site, used for formal correspondence and identification.
ContactNameSuffix	String	False	No	Suffix for the contact person’s name at the bill-to customer site (for example, Jr., Sr.), helping to distinguish between similarly named individuals.
ContactTitle	String	False	No	Title (for example, Mr., Mrs., Dr.) of the contact person at the bill-to customer site, adding formality to communications.
PreferredContactPointId	Long	False	No	Unique identifier for the preferred contact method (for example, email) for the billing account contact person, ensuring smooth communication.
SourceAddressId	String	False	No	Unique identifier for the bill-to customer address, typically set to '1' for standard address referencing, linking to the primary billing address.
Finder	String	False	No	Tool or method used to search and locate specific billing records, helping users to filter and identify relevant information.
FromDate	Date	False	No	Start date for the validity of the billing information, marking the period when the billing details become applicable.
HeaderId	Long	False	No	Unique identifier for the order header, linking the bill-to customer details to the larger order structure.
OrderKey	String	False	No	Key used to uniquely identify the order line, helping track the specific order line details tied to the bill-to customer.
OrderNumber	String	False	No	Order number assigned to the sales order, used for tracking the order throughout its lifecycle and for referencing the bill-to customer details.
SourceTransactionNumber	String	False	No	Transaction number assigned by the source system, linking the bill-to customer details to its originating transaction in an external system.
SourceTransactionSystem	String	False	No	Name of the source transaction system, providing context for where the bill-to customer information originated and ensuring system integration.
ToDate	Date	False	No	End date after which the billing information is no longer valid, marking the point at which the customer’s billing responsibilities change or cease.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the channel program details to the parent order and enabling tracking of program-based discounts or incentives.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the order, helping to connect the channel program details to specific order lines being fulfilled.
IncentiveEntityTypeCode	String	False	No	Code representing the type of incentive entity, such as distributor or partner, that the channel program applies to.
IncentiveEntitySubtypeCode	String	False	No	Code representing the subtype of the incentive entity, further specifying the type of relationship or classification within the broader incentive entity.
IncentiveId [KEY]	Long	False	No	Unique identifier for the incentive, linking the sales order to a specific incentive offered through the channel program.
SourceIncentiveId	String	False	No	Unique identifier assigned by the source system for the incentive, providing a reference for the originating application or platform.
ProgramCode	String	False	No	Code identifying the specific channel program under which the incentive or discount applies, used to group incentives by program.
ProgramId	String	False	No	Unique identifier for the program, linking the sales order line to a specific channel program offering incentives or discounts.
ProgramName	String	False	No	Name of the channel program, providing a more readable description for the program offering the incentive or discount.
ProgramDetails	String	False	No	Description of the channel program, outlining the specifics of how it operates and what it offers (for example, rebate details, special offers).
ProgramTypeName	String	False	No	Name of the program type, categorizing the channel program (for example, volume-based discounts, loyalty programs).
ProgramLine	String	False	No	Line within the channel program, used to specify details for a particular offer or incentive within a program.
ProgramLineId	String	False	No	Unique identifier for the specific program line, used to link the sales order to a distinct line item in the program.
ProgramDescription	String	False	No	Description of the specific program line, providing context on the type of incentive or discount available in that program line.
ApplyType	String	False	No	Code describing how the incentive or discount is applied (for example, on total order, per item), defining the structure of the discount.
ManuallyAppliedFlag	Bool	False	No	Flag indicating whether the incentive or discount was manually applied by a user (true) or automatically applied by the system (false).
ItemLevelCode	String	False	No	Code indicating if the incentive or discount is applied at the item level, order level, or another defined level within the sales order.
ItemLevel	String	False	No	Description of the level at which the incentive or discount is applied, such as 'per item' or 'per order', to clarify the scope of the discount.
StatusCode	String	False	No	Code representing the status of the channel program, indicating whether the incentive is active, expired, or pending.
Status	String	False	No	Description of the channel program's current status, providing clarity on whether the incentive or discount is in effect or inactive.
DiscountTypeCode	String	False	No	Code identifying the type of discount (for example, percentage off, fixed amount off), helping to categorize the discount.
DiscountType	String	False	No	Description of the type of discount, providing more detail on how the discount is structured (for example, 'percentage off' or 'fixed amount off').
DeclinableFlag	Bool	False	No	Flag indicating whether the customer can decline the incentive or discount (true) or if it is automatically applied (false).
DeclineReasonCode	String	False	No	Code identifying the reason for declining the incentive or discount, used to track why a discount was not accepted by the customer.
DeclineReason	String	False	No	Description of the reason for declining the incentive or discount, helping to provide additional context for customer decisions.
DiscountAmount	Long	False	No	Amount of the discount or incentive applied to the order, specifying the value of the discount offered.
StartDate	Date	False	No	Start date of the channel program or discount validity period, marking when the incentive or discount becomes available.
EndDate	Date	False	No	End date of the channel program or discount validity period, marking when the incentive or discount expires.
Comments	String	False	No	Any additional comments or notes related to the channel program or discount, providing further context or special instructions.
Finder	String	False	No	Tool or method used to search and locate specific channel program records, helping to filter and retrieve relevant program data.
FromDate	Date	False	No	Start date from which the channel program details are valid, marking the beginning of the eligibility period for the incentive.
HeaderId	Long	False	No	Unique identifier for the order header associated with the channel program, linking the program to the broader sales order.
OrderKey	String	False	No	Key used to uniquely identify the order line associated with the channel program, ensuring that the discount or incentive is applied to the correct line.
OrderNumber	String	False	No	Order number assigned to the sales order, providing a reference for tracking the order throughout its lifecycle.
SourceTransactionNumber	String	False	No	Transaction number assigned by the source system, linking the channel program details to its originating transaction in the external system.
SourceTransactionSystem	String	False	No	Name of the source system from which the channel program data originated, providing context for integration with external systems.
ToDate	Date	False	No	End date after which the channel program details are no longer valid, marking the end of the incentive or discount period.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the charge details to the parent order in Oracle Fusion Order Management. This helps track and reference charges applied to the entire order within the system.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the charge, linking the charge to specific order lines in Oracle Fusion Order Management and tracking fulfillment against customer orders.
OrderChargeId [KEY]	Long	False	No	Unique identifier for the charge applied to the order, used to track and reference charges within the Oracle Fusion Order Management system for billing and invoicing purposes.
SourceChargeId	String	False	No	Unique identifier for the charge assigned by the source system (for example, external pricing system or legacy ERP), allowing integration with Oracle Fusion Order Management and external systems.
PriceTypeCode	String	False	No	Abbreviation that identifies the price type, such as one-time or recurring. Used in Oracle Fusion Pricing to categorize the charge based on its nature, ensuring proper application of pricing strategies.
PriceType	String	False	No	Description of the price type applied, such as one-time charge or recurring fee. This helps determine how the charge is calculated in Oracle Fusion Pricing for pricing models and forecasting.
ChargeTypeCode	String	False	No	Abbreviation identifying the charge type, such as item sale, service fee, or shipping. This categorizes the charge in Oracle Fusion Order Management and Oracle Fusion Cost Management for correct handling in financial reporting.
ChargeType	String	False	No	Description of the charge type, categorizing it as an item sale, service, shipping, or another type of charge. Helps Oracle Fusion identify the nature of the charge for tax calculations and revenue recognition.
ChargeDefinitionCode	String	False	No	Abbreviation for the charge definition, which is defined in Oracle Fusion Pricing. It links the charge to a specific pricing rule or structure within the system, such as discounts, tax calculations, or surcharge rules.
ChargeDefinition	String	False	No	Description of the charge definition, detailing how the charge is calculated and applied. Used in Oracle Fusion Order Management to determine the charge’s impact on the total order value.
ChargeSubtypeCode	String	False	No	Abbreviation identifying the charge subtype, such as late fee, penalty, or promotional discount. Helps define the specific nature of the charge for reporting and customer agreements in Oracle Fusion.
ChargeSubType	String	False	No	Description of the charge subtype, providing further classification for charge types like restocking fees, penalty charges, or service fees, relevant for Oracle Fusion’s billing and reconciliation systems.
PricedQuantity	Decimal	False	No	Quantity associated with the charge, specifying how much of the item or service the charge applies to. For example, in Oracle Fusion, it helps calculate unit-based charges for inventory items.
ChargeCurrencyCode	String	False	No	Abbreviation identifying the currency used for the charge. In Oracle Fusion, this currency setting ensures that the charge is applied in the correct currency for international sales or multi-currency transactions.
ChargeCurrency	String	False	No	Currency used for the charge. This aligns with the currency in Oracle Fusion Financials, ensuring proper accounting entries are made when applying charges to orders in multiple currencies.
PricedQuantityUOMCode	String	False	No	Abbreviation identifying the unit of measure for the priced quantity, such as Ton. Oracle Fusion Product Lifecycle Management or Oracle Order Management Cloud provides this value to standardize how charges are measured.
PricedQuantityUOM	String	False	No	Unit of measure for the priced quantity, such as Ton, defined in Oracle Fusion Supply Chain Management or Order Management to track how units are billed and processed.
PricePeriodicityCode	String	False	No	Abbreviation identifying the periodicity of the charge (for example, monthly, annually). Used in Oracle Fusion Pricing to configure recurring charges and ensure proper scheduling of future charges.
PricePeriodicity	String	False	No	Description of the periodicity of the charge, specifying how often the charge recurs (for example, monthly, quarterly). This is crucial for managing subscription models or recurring billing in Oracle Fusion Subscriptions.
SequenceNumber	Int	False	No	Sequence number that orders the charges in the system, ensuring they are applied in the correct order. Useful in Oracle Fusion Order Management to apply charges in sequence, particularly when multiple charges are involved.
PrimaryFlag	Bool	False	No	Flag indicating whether the charge is the primary charge (true) or a secondary charge (false). Oracle Fusion Financials uses this to determine which charge is principal when calculating invoice amounts.
RollupFlag	Bool	False	No	Flag indicating whether the charge is a rollup charge (true), meaning it combines multiple charges into one. In Oracle Fusion, this affects how the charges are grouped for invoicing and reporting purposes.
AverageUnitSellingPrice	Decimal	False	No	The weighted average price per unit, calculated from total revenue divided by total units sold. In Oracle Fusion, this metric helps in analyzing the overall profitability of sales transactions.
CanAdjustFlag	Bool	False	No	Flag indicating whether the charge is eligible for adjustment (true) or not (false). In Oracle Fusion Order Management, this impacts whether changes can be made to charges post-sale based on discounts or disputes.
GSAUnitPrice	Decimal	False	No	Price per unit determined by the price list in Oracle Fusion Pricing, providing a reference for calculating the cost and revenue generated from each unit sold.
ApplyToCode	String	False	No	Abbreviation identifying where the charge is applied (for example, item, shipping, or return). In Oracle Fusion, this code ensures that the charge is appropriately allocated to the correct part of the order for correct invoicing.
ApplyTo	String	False	No	Description of where the charge applies, such as for the item, shipping, or return. Oracle Fusion uses this to determine how the charge impacts order totals and taxes.
TieredFlag	Bool	False	No	Flag indicating whether the charge uses a tiered pricing structure (true), commonly applied for volume-based discounts. Oracle Fusion Pricing uses this to apply graduated discount schemes or fees based on quantity.
TierAppliesToCode	String	False	No	Abbreviation identifying whether the tier applies to all tiers or just the highest tier. Oracle Fusion Pricing uses this to apply tiered pricing logic for large-volume purchases or high-value contracts.
TierAppliesTo	String	False	No	Description of whether the tiered pricing applies to all tiers or only the highest tier. This setting in Oracle Fusion ensures that discounts or charges are applied according to predefined tier rules.
UsagePriceLockFlag	Bool	False	No	Flag indicating whether the usage price is locked (true) or not (false), used to lock pricing for subscription-based models. This flag is managed within Oracle Fusion Subscriptions and Pricing.
BlockAllowance	Decimal	False	No	Block allowance for a non-tiered consumption charge, specifying the threshold of usage before additional charges apply. Oracle Fusion Subscriptions uses this to calculate usage-based billing for subscription models.
BlockSize	Decimal	False	No	Size of the block for charge calculation in tiered pricing, helping Oracle Fusion Pricing to calculate charges based on predefined usage blocks.
UsageUOMCode	String	False	No	Code identifying the unit of measure for usage, such as hours or units, used by Oracle Fusion Subscriptions or Oracle Cloud Inventory for tracking consumption.
ChargePeriodCode	String	False	No	Code identifying the charge period, such as monthly or annually. This setting ensures charges align with the periodicity of the subscription or usage model in Oracle Fusion Subscriptions.
UsageUOM	String	False	No	Unit of measure for usage-based charges, such as hours or units. Oracle Fusion Subscriptions uses this to track how usage is measured and billed to the customer.
ChargePeriod	String	False	No	Description of the period for which the charge applies, helping Oracle Fusion determine how frequently the charge is assessed (for example, monthly, yearly).
Finder	String	False	No	Method or tool used to locate specific charge records, enabling users to filter and retrieve relevant charge information from Oracle Fusion Order Management.
FromDate	Date	False	No	Start date when the charge is applicable, marking the beginning of the charge’s validity period in Oracle Fusion Order Management.
HeaderId	Long	False	No	Unique identifier for the order header related to the charges, associating the charge with the broader order context in Oracle Fusion.
OrderKey	String	False	No	Key used to uniquely identify the order line associated with the charge, ensuring the correct charge is applied to the appropriate order line in Oracle Fusion.
OrderNumber	String	False	No	Order number assigned to the sales order, used to track the order in Oracle Fusion Order Management and link it to the charges applied.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the charge details to its originating transaction in external systems integrated with Oracle Fusion.
SourceTransactionSystem	String	False	No	Source system name from which the charge data originated, providing context for integration with external systems and ensuring consistency across platforms.
ToDate	Date	False	No	End date after which the charge is no longer valid, marking the expiration of the charge period in Oracle Fusion.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, used to track and associate the charge components with the specific sales order in the system.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line within the sales order that corresponds to the charge component, ensuring the charge is applied to the correct item or service.
ChargesOrderChargeId [KEY]	Long	False	No	Unique identifier for the order charge within the sales order, linking the charge component to the main order charge.
OrderChargeComponentId [KEY]	Long	False	No	Unique identifier for the specific charge component within the order charge, used to track adjustments and detailed charge breakdowns.
SourceChargeComponentId	String	False	No	Value assigned by the source application to uniquely identify the charge component, facilitating integration between systems.
ChargeCurrencyUnitPrice	Decimal	False	No	Price or adjustment for each unit of the charge component, displayed in the currency selected for the order line.
ChargeCurrencyExtendedAmount	Decimal	False	No	The extended amount calculated by multiplying the unit price by the quantity of the item or service, expressed in the charge currency.
ChargeCurrencyDurationExtendedAmount	Decimal	False	No	The extended amount for the duration of the charge component, calculated similarly to the standard extended amount but reflecting a time-based calculation.
ChargeCurrencyCode	String	False	No	Abbreviation representing the currency code used for the charge component, such as USD.
ChargeCurrency	String	False	No	Full name of the currency used for the charge component, such as USD or EUR.
PriceElementCode	String	False	No	Abbreviation identifying the specific price element for the charge component, such as list price or net price.
PriceElement	String	False	No	Name of the price element, which could refer to the type of price applied, such as 'list price', 'discounted price', or 'net price'.
PriceElementUsageCode	String	False	No	Abbreviation identifying the charge component's usage, such as whether it is applied for shipping or as part of a specific discount.
PriceElementUsage	String	False	No	Detailed description of the charge component's usage, clarifying how the price element is applied in the context of the order.
SequenceNumber	Int	False	No	The sequence number indicating the order in which charge components are applied, helping to organize and prioritize the charges.
RollupFlag	Bool	False	No	Flag indicating whether the charge is a rollup value (true) for the charge component. For Oracle Fusion application priced orders, the default value is set based on the pricing setup. For pre-priced orders, the default value is false.
Explanation	String	False	No	Textual explanation that clarifies the charge component, offering transparency for billing or auditing purposes.
ExplanationMessageName	String	False	No	Message name for the explanation text displayed in the pricing breakdown dialog, assisting users in understanding the charge details.
HeaderCurrencyUnitPrice	Decimal	False	No	Price or adjustment for each unit of the item in the sales order, displayed in the currency used for the order header.
HeaderCurrencyExtendedAmount	Decimal	False	No	Extended amount in the currency of the order header, calculated by multiplying the unit price by the quantity of the items in the order.
HeaderCurrencyDurationExtendedAmount	Decimal	False	No	Extended amount for the duration of the charge, displayed in the currency of the order header.
HeaderCurrencyCode	String	False	No	Currency code used for the order header, such as USD, ensuring consistency across all charges related to the header.
HeaderCurrency	String	False	No	Name of the currency used for the order header, such as USD or EUR.
PercentOfComparisonElement	Decimal	False	No	Percentage representing the portion of the charge relative to a comparison element, such as the percent of the list price or net price.
PricingSourceId	String	False	No	Identifier for the pricing source that defines the lowest-level pricing applied, such as a line item price or tier rule.
PricingSourceTypeCode	String	False	No	Type of the pricing source, such as a segment price list or charge, providing context for the pricing logic applied.
PricingSourceType	String	False	No	Detailed name describing the type of pricing source, helping to clarify the origin of the pricing, such as 'price list' or 'tier rule'.
SourceMpaId	String	False	No	Identifier for the source of a manual price adjustment, linking the charge component to any manual modifications applied to the pricing.
TaxIncludedFlag	Bool	False	No	Indicates whether tax is included in the price of the charge component (true) or not (false). For Oracle Fusion application priced orders, this is set based on pricing setup.
TotalComponents	String	False	No	Total components associated with the charge component, often used for reporting or breakdown purposes to track all parts of a specific charge.
Finder	String	False	No	Tool or method used to locate specific charge components within the order system, allowing efficient retrieval of charge details for review or reporting.
FromDate	Date	False	No	Start date indicating when the charge component becomes applicable, helping to track the timing of charges in relation to the order's lifecycle.
HeaderId	Long	False	No	Unique identifier for the order header, linking charge components to the overall order in the system for proper tracking and processing.
OrderKey	String	False	No	Unique key assigned to the order for referencing the charge component, facilitating seamless processing and tracking across the system.
OrderNumber	String	False	No	Number that identifies the order in the system, used for managing and referencing the order, including all associated charge components.
SourceTransactionNumber	String	False	No	Transaction number from the source system, allowing the charge component to be linked to its originating transaction in external systems.
SourceTransactionSystem	String	False	No	System name from the source application, providing context for integration between the source transaction system and Oracle Fusion Order Management.
ToDate	Date	False	No	End date for the applicability of the charge component, marking the date when the charge is no longer valid or should be replaced.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the coverage references to the parent order and ensuring proper tracking across the order lifecycle.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the coverage reference, enabling proper tracking of coverage details at the line level within the sales order.
OrderNumber	String	False	No	Unique number assigned to the sales order, used for referencing the order throughout various processes like invoicing, fulfillment, and reporting.
SourceOrderNumber	String	False	No	Order number from the source system, providing the originating reference for the order and ensuring integration with external systems for consistent order tracking.
SourceLineNumber	String	False	No	Line number from the source system corresponding to the coverage reference, enabling proper linkage between the source system and the sales order in external systems.
DisplayLineNumber	String	False	No	User-friendly version of the order line number, used in interfaces to display the line item in a readable format, especially for customer-facing reports.
CoverageItemNumber	String	False	No	Unique identifier for the coverage item associated with the order line, helping to track which items are covered under the sales order, such as for warranties or service contracts.
CoverageFulfillLineId	Long	False	No	Fulfillment line ID for the coverage item, linking it to a specific fulfillment line, and aiding in the tracking of fulfillment for coverage under the order.
HeaderId	Long	False	No	Unique ID for the order header, ensuring that coverage references are linked to the correct sales order and maintaining consistency throughout the order’s lifecycle.
Finder	String	False	No	Method or tool used to locate coverage reference records within the sales order, allowing for efficient retrieval and management of coverage data.
FromDate	Date	False	No	Start date of the coverage reference, determining the period during which coverage is valid. Ensures accurate tracking of coverage within the specified time frame.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the coverage reference, ensuring that all related transactions are accurately tracked under the correct order.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the coverage reference to its originating transaction, and providing traceability when integrating with external systems.
SourceTransactionSystem	String	False	No	Name of the source system from which the coverage reference data originated, providing context for system integration and ensuring consistency across platforms.
ToDate	Date	False	No	End date when the coverage reference is no longer valid, marking the expiration of coverage and ensuring accurate coverage periods within the sales order.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the covered product references to the parent order and ensuring proper tracking across the order lifecycle.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the covered product reference, enabling tracking of product coverage at the line level within the order.
SourceOrderId	String	False	No	Unique identifier for the source order from the order capture system, helping to link the covered product reference to the original source order.
SourceOrderNumber	String	False	No	Order number from the source system that contains the covered item, ensuring proper integration between systems for accurate order tracking.
SourceOrderSystem	String	False	No	The source system from which the order originated, providing context for integration with external systems and ensuring consistency across platforms.
OrderNumber	String	False	No	Unique number assigned to the sales order that contains the covered item, used for referencing the order in reports, invoicing, and fulfillment.
DisplayLineNumber	String	False	No	Line number in a readable format for the order line, used for customer-facing reports and user interfaces to identify the item or service covered under the sales order.
SourceLineId	String	False	No	Unique identifier for the order line in the source system, ensuring accurate tracking of the covered product in both the source system and sales order.
SourceLineNumber	String	False	No	Line number in the source application that refers to the transaction containing the covered item, ensuring proper linkage between external systems and the order line.
CoveredItemNumber	String	False	No	Identifier for the covered item within the sales order, helping to track which items are covered under the order, such as for warranties or service contracts.
CoveredFulfillLineId	Long	False	No	Fulfillment line ID for the covered item, linking the coverage to a specific fulfillment line, and aiding in tracking the fulfillment of the covered item.
HeaderId	Long	False	No	Unique ID for the order header, linking the covered product references to the overall sales order and ensuring consistency throughout the order lifecycle.
Finder	String	False	No	Method or tool used to locate specific coverage reference records in the system, allowing for efficient retrieval and management of coverage data.
FromDate	Date	False	No	Start date when the coverage reference is valid. Used to determine the period during which the coverage applies, particularly for warranties and service contracts.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the coverage reference, ensuring that all related transactions are tracked under the correct order.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the covered product reference to its originating transaction, and ensuring consistency when integrating with external systems.
SourceTransactionSystem	String	False	No	Source system name from which the covered product reference data originated, providing context for integration with external systems and ensuring consistency across platforms.
ToDate	Date	False	No	End date when the coverage reference is no longer valid, marking the expiration of the coverage and ensuring accurate coverage periods within the sales order.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the drop-ship purchase order references to the parent sales order and ensuring proper tracking of the order.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the drop-ship purchase order reference, enabling tracking of drop-shipped items within the order.
POHeaderId	String	False	No	Unique identifier for the purchase order header, linking the sales order to the corresponding purchase order in the source system.
PONumber	String	False	No	Purchase order number from the source system, used for referencing the drop-ship purchase order in related documents, such as invoices and reports.
POLineId	String	False	No	Unique identifier for the purchase order line within the source system, linking the sales order to the specific line of the drop-ship purchase order.
POLineLocationId	String	False	No	Location identifier for the purchase order line, used to track where the goods are being shipped from or to in relation to the drop-ship purchase order.
DocumentSystemReferenceId [KEY]	Long	False	No	Unique identifier for the document system reference, linking the drop-ship purchase order to its associated documents in the source system.
Finder	String	False	No	Method or tool used to locate specific drop-ship purchase order reference records in the system, enabling efficient retrieval and management.
FromDate	Date	False	No	Start date of the drop-ship purchase order reference, used to track the validity period of the reference and ensure timely processing of related orders.
HeaderId	Long	False	No	Unique identifier for the order header, linking the drop-ship purchase order reference to the overall sales order.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the drop-ship purchase order reference, ensuring that all related transactions are tracked under the correct order.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used for referencing and tracking the order throughout the fulfillment and invoicing process.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the drop-ship purchase order reference to its originating transaction, ensuring consistency across systems.
SourceTransactionSystem	String	False	No	Source system name from which the drop-ship purchase order reference originated, providing context for integration with external systems.
ToDate	Date	False	No	End date when the drop-ship purchase order reference is no longer valid, marking the expiration of the reference and ensuring that coverage is time-bound and accurate.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the drop-ship requisition references to the parent sales order and ensuring proper tracking of the order.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the drop-ship requisition reference, enabling tracking of requisitioned items within the sales order.
RequisitionHeaderId	String	False	No	Unique identifier for the requisition header, linking the sales order to the corresponding requisition in the source system.
RequisitionNumber	String	False	No	Requisition number from the source system, used for referencing the requisition associated with the sales order in related documents, such as invoices and reports.
RequisitionLineId	String	False	No	Unique identifier for the requisition line, linking the sales order to the specific line item of the requisition.
RequisitionLineNumber	String	False	No	Line number from the requisition, helping to match the correct item in the requisition to the corresponding line item in the sales order.
DocumentSystemReferenceId [KEY]	Long	False	No	Unique identifier for the document system reference, linking the drop-ship requisition reference to its associated documents in the source system.
Finder	String	False	No	Method or tool used to locate specific drop-ship requisition reference records, enabling efficient retrieval and management in the system.
FromDate	Date	False	No	Start date of the drop-ship requisition reference, marking the beginning of the validity period of the reference.
HeaderId	Long	False	No	Unique identifier for the order header, used to link the requisition reference to the overall sales order in the system.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the drop-ship requisition reference, ensuring all related transactions are correctly tracked.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used for referencing the order across different platforms and processes.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the requisition reference to its originating transaction, ensuring consistency across systems.
SourceTransactionSystem	String	False	No	Source system name from which the requisition reference originated, ensuring proper integration and traceability with external systems.
ToDate	Date	False	No	End date when the drop-ship requisition reference is no longer valid, marking the expiration of the reference and ensuring it is time-bound.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the external asset reference to the parent sales order, ensuring proper tracking of asset references within the order.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the external asset reference, enabling tracking of assets at the line level within the sales order.
ExternalAssetKey	String	False	No	Unique value that identifies the asset key for the subscription or coverage item in an external application, helping to integrate external asset management systems with Oracle systems.
ExternalParentAssetKey	String	False	No	Unique value that identifies the parent asset key for the subscription or coverage item in an external application, providing a hierarchical reference for asset relationships.
ExternalRootParentAssetKey	String	False	No	Unique value that identifies the root parent asset key for the subscription or coverage item in an external application, establishing the top-level asset relationship in external systems.
SubscriptionProductPuid	String	False	No	Unique identifier for the product within the subscription in Oracle Subscription Management Cloud, allowing accurate tracking of subscription-based products.
Finder	String	False	No	Method or tool used to locate specific external asset reference records, enabling efficient retrieval of asset data associated with the sales order.
FromDate	Date	False	No	Start date when the external asset reference is valid, marking the beginning of its applicability period.
HeaderId	Long	False	No	Unique identifier for the order header, used to link external asset references to the overall sales order in the system.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the external asset reference, ensuring that all related transactions are properly tracked under the correct order.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used for referencing the order across different platforms and processes.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the external asset reference to its originating transaction, ensuring consistency across platforms.
SourceTransactionSystem	String	False	No	Source system name from which the external asset reference originated, providing context for integration and traceability with external systems.
ToDate	Date	False	No	End date when the external asset reference is no longer valid, marking the expiration of the asset reference and ensuring the reference period is time-bound.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the external fulfillment sales order reference to the parent order in Oracle Fusion Order Management, ensuring accurate tracking of fulfillment sales orders.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the external fulfillment sales order reference, providing granularity for tracking sales order fulfillment at the line level.
DocumentNumber	String	False	No	Unique identifier for the document associated with the external fulfillment sales order reference, used to track and cross-reference documents within external systems.
DocumentId	String	False	No	Unique identifier for the external document related to the fulfillment sales order, ensuring proper tracking and association with the sales order in external systems.
DocumentLineNumber	String	False	No	Line number within the external document, providing a reference to the specific item or action related to the fulfillment sales order.
DocumentSystemReferenceId [KEY]	Long	False	No	Unique identifier assigned to the document by the external system, enabling seamless integration between Oracle systems and external document management systems.
Finder	String	False	No	Method or tool used to locate specific external fulfillment sales order reference records in Oracle Fusion Order Management, enabling efficient retrieval of related data.
FromDate	Date	False	No	Start date when the external fulfillment sales order reference becomes valid, marking the beginning of its applicability period within the order.
HeaderId	Long	False	No	Unique identifier for the order header, used to link the external fulfillment sales order reference to the overall sales order in Oracle Fusion Order Management.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the external fulfillment sales order reference, ensuring consistency across all related transactions.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used for referencing and tracking the order in reports, invoicing, and fulfillment.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the external fulfillment sales order reference to its originating transaction, ensuring proper integration with external systems.
SourceTransactionSystem	String	False	No	Source system name from which the external fulfillment sales order reference data originated, providing context for integration and traceability across platforms.
ToDate	Date	False	No	End date when the external fulfillment sales order reference is no longer valid, marking the expiration of the reference period and ensuring accurate, time-bound data.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the hold information to the parent order in Oracle Fusion Order Management, ensuring accurate tracking of holds at the order level.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the hold, allowing detailed tracking of holds on specific lines within the order.
HoldInstanceId [KEY]	Long	False	No	Unique identifier for the specific hold instance, allowing for individual tracking of each hold applied to the sales order.
HoldName	String	False	No	Name or description of the hold applied to the sales order, providing context for the reason behind the hold (for example, payment issues, inventory issues).
HoldCode	String	False	No	Code representing the type or category of the hold, used to categorize different types of holds in Oracle Fusion Order Management.
HoldComments	String	False	No	Additional comments or notes related to the hold, providing further details about the reason for the hold or any special instructions.
ApplyUser	String	False	No	User who applied the hold to the sales order, enabling audit tracking and accountability for hold actions.
ApplyDate	Datetime	False	No	Date and time when the hold was applied to the sales order, ensuring that the timeline of the order and holds is accurately tracked.
HoldReleaseComments	String	False	No	Comments related to the release of the hold, providing details about why and how the hold was removed from the order.
HoldReleaseReasonCode	String	False	No	Code representing the reason for releasing the hold, helping to categorize why the hold was lifted.
HoldReleaseReason	String	False	No	Description of the reason why the hold was released, explaining the actions taken to resolve the issue that caused the hold.
ReleaseUser	String	False	No	User who released the hold, enabling traceability of hold release actions in Oracle Fusion Order Management.
ReleaseDate	Datetime	False	No	Date and time when the hold was released from the sales order, ensuring accurate tracking of hold lifecycles.
ApplySystem	String	False	No	System from which the hold was applied, providing insight into the origin of the hold in cases of integration with external systems.
ActiveFlag	Bool	False	No	Indicates whether the hold is currently active. If true, the hold is still in place. If false, the hold has been released.
SourceRequestId	String	False	No	Identifier from the source system that links to the request that initiated the hold, helping to maintain data consistency across systems.
Finder	String	False	No	Method or tool used to search for specific hold records, enabling efficient retrieval of hold information in Oracle Fusion Order Management.
FromDate	Date	False	No	Start date when the hold is applicable, marking the beginning of the hold period for the sales order.
HeaderId	Long	False	No	Unique identifier for the order header, used to link the hold details to the overall sales order, ensuring consistency in order processing.
OrderKey	String	False	No	Unique key for referencing the sales order associated with the hold, providing an essential linkage for all related transactions.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used for referencing the order in reporting, invoicing, and fulfillment processes.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the hold information to its originating transaction and ensuring consistency during integration.
SourceTransactionSystem	String	False	No	Source system from which the transaction originated, providing context for integration with external platforms.
ToDate	Date	False	No	End date when the hold is no longer applicable, marking the expiration of the hold period and ensuring time-bound data management.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking internal order reference details to the parent order. This ensures accurate tracking of internal orders associated with the sales order.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the internal order reference, allowing tracking of internal orders at the line level.
DocumentSystemReferenceId [KEY]	Long	False	No	Unique identifier for the reference document in the external or internal document system, ensuring seamless integration and traceability of the internal order with associated documents.
InternalOrderDocumentType	String	False	No	Type of the internal order document (for example, purchase order, requisition) that relates to the sales order, helping categorize and track different internal order document types.
Finder	String	False	No	Search method or tool used to locate specific internal order reference records, facilitating the retrieval of internal order data related to the sales order.
FromDate	Date	False	No	Start date when the internal order reference is valid, providing the time period for which the internal order applies.
HeaderId	Long	False	No	Unique identifier for the header of the internal order reference, ensuring that the reference is properly linked to the sales order at the header level.
OrderKey	String	False	No	Unique key that references the sales order related to the internal order, ensuring all transactions related to the order are appropriately tracked.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used for tracking and referencing the order in reporting, invoicing, and fulfillment processes.
SourceTransactionNumber	String	False	No	Transaction number from the source system that links to the internal order reference, ensuring that all related transactions are accurately integrated between systems.
SourceTransactionSystem	String	False	No	Name of the source system where the transaction originated, providing insight into the external system from which the internal order reference data is sourced.
ToDate	Date	False	No	End date when the internal order reference is no longer applicable, marking the expiration of the internal order's validity period and ensuring time-bound data management.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking line details to the overall order. This ensures that all line-level information is correctly associated with the sales order.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the order line, allowing tracking of order fulfillment at the line level.
ActualDeliveryDate	Datetime	False	No	Actual date the item was delivered, used for accurate delivery tracking and reporting in systems like Oracle Fusion Order Management.
AvailabilityShipDate	Datetime	False	No	The planned or actual date when the item is available for shipment, used to monitor the readiness of goods for delivery.
BillOfLadingNumber	String	False	No	Unique identifier for the bill of lading document, which provides information about the shipment of goods, often required for logistics and fulfillment tracking.
BillingTransactionAmount	Decimal	False	No	Amount billed for the specific order line, captured during the billing process. This value is crucial for invoicing and financial reporting.
BillingTransactionDate	Datetime	False	No	Date when the billing transaction occurred, typically used for accounting and revenue recognition.
BillingTransactionNumber	String	False	No	Unique identifier for the billing transaction associated with the order line, enabling the linking of financial records and supporting payment processing.
CustomerTransactionLineId	Long	False	No	Unique identifier for the customer's transaction line, used for reference and tracking in the customer account system.
DeliveryName	String	False	No	The name of the recipient or customer for the delivery, used for shipping documentation and fulfillment tracking.
ExceptionFlag	Bool	False	No	Flag indicating whether an exception occurred during the fulfillment process, helping identify and address issues such as delays or missing items.
FulfillLineDetailId [KEY]	Long	False	No	Unique identifier for the specific detail of the fulfillment line, aiding in precise tracking of the fulfillment process.
Quantity	Decimal	False	No	Quantity of the item for the order line, ensuring correct stock levels and fulfillment quantities.
SecondaryQuantity	Decimal	False	No	Secondary unit of measure for the quantity, used when different units of measure (like weight or volume) are involved in the transaction.
RMAReceiptDate	Date	False	No	Date when the returned goods were received, used for processing returns and managing reverse logistics.
RMAReceiptDateTime	Datetime	False	No	Timestamp for the return receipt, providing exact timing for returns processing.
RMAReceiptLineNumber	String	False	No	Unique line number for the RMA receipt, used to identify the specific line of returned goods in the system.
RMAReceiptNumber	String	False	No	Unique identifier for the RMA receipt, helping to track and manage returned goods within the returns process.
RMAReceiptTransactionId	String	False	No	Transaction ID for the RMA receipt, enabling seamless integration with returns and inventory systems.
StatusCode	String	False	No	Code representing the status of the order line (for example, shipped, pending), useful for tracking fulfillment stages and managing customer expectations.
Status	String	False	No	Description of the current status of the order line, providing detailed information on its fulfillment or processing stage.
StatusAsOfDate	Datetime	False	No	Date when the status of the order line was last updated, used for tracking progress and ensuring up-to-date reporting.
TaskType	String	False	No	Type of task or action associated with the order line (for example, fulfillment, shipping), used for workflow and task management in systems like Oracle Fusion.
TrackingNumber	String	False	No	Tracking number for the shipment, allowing customers and service teams to trace the delivery status in real-time.
TradeComplianceCode	String	False	No	Code representing the trade compliance classification for the order line, helping ensure the goods meet legal and regulatory standards.
TradeComplianceExplanation	String	False	No	Description of the trade compliance status or issues related to the order line, helping to clarify any compliance-related concerns.
TradeComplianceResultCode	String	False	No	Result code indicating the outcome of the trade compliance check for the order line, used for regulatory reporting and managing compliance risks.
TradeComplianceTypeCode	String	False	No	Code that categorizes the type of trade compliance check performed (for example, export, tariff), supporting legal and regulatory compliance.
TradeComplianceType	String	False	No	Description of the trade compliance check type, used for tracking the different compliance processes applied to the order.
WaybillNumber	String	False	No	Number assigned to the waybill, used for tracking shipments and ensuring proper delivery documentation.
Finder	String	False	No	Method or tool used to locate the specific line details, ensuring easy retrieval of data for reporting and customer service.
FromDate	Date	False	No	Start date indicating when the order line details become applicable or valid.
HeaderId	Long	False	No	Unique identifier for the order header, linking the line details to the overall order.
OrderKey	String	False	No	Unique key referencing the order for better identification and linkage within the system.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used in reporting, invoicing, and fulfillment tracking.
SourceTransactionNumber	String	False	No	Transaction number from the source system that links the order line to its originating transaction, ensuring proper integration and traceability.
SourceTransactionSystem	String	False	No	Name of the source system from which the transaction data originated, providing context for integration with external platforms.
ToDate	Date	False	No	End date when the order line details are no longer valid, ensuring accurate and time-bound tracking of fulfillment processes.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking lot and serial information to the parent order. This ensures proper tracking of item serials and lots within the order lifecycle.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the order, enabling tracking of serials and lots at the line level for accurate inventory management and fulfillment.
ItemRevisionNumber	String	False	No	Version or revision number of the item, used to track different versions of an item for inventory and quality control purposes.
ItemSerialNumberFrom	String	False	No	Starting serial number in a range, used for identifying the first serial number of a batch or set of items within an order.
ItemSerialNumberTo	String	False	No	Ending serial number in a range, used for identifying the last serial number of a batch or set of items within an order.
LocatorId	Long	False	No	Unique identifier for the locator (location in warehouse or storage area) where the item is shipped from or received into. This helps in tracking item movement within Oracle Fusion Inventory Management.
LotNumber	String	False	No	Identifies the lot to which the item belongs, used for batch tracking and managing inventory in Oracle Fusion or other inventory management systems.
LotSerialId [KEY]	Long	False	No	Unique identifier for the lot and serial combination, used to track and manage specific items and their movement in the supply chain.
SourceLotSerialId	String	False	No	Identifier for the lot and serial combination from the source system, ensuring consistent integration and traceability between Oracle Fusion and external systems.
Quantity	Decimal	False	No	Number of lots and serials associated with the order line. Used for inventory tracking and order fulfillment.
SecondaryQuantity	Decimal	False	No	Secondary unit of measure for quantity, used when different units of measure (like weight or volume) are involved in the transaction or fulfillment.
Locator	String	False	No	Concatenated segments representing the locator flexfields, indicating where the item is shipped from or received into, enabling precise location tracking in Oracle Fusion Inventory Management.
DeletedFlag	Bool	False	No	Indicates whether the lot and serial lines are deleted during a patch or upsert operation. This is a transient attribute used only in orders with inventory transactions. Default value is not set.
Finder	String	False	No	Method or tool used to locate specific lot and serial records in Oracle Fusion or other inventory systems, facilitating efficient data retrieval for reporting and operational tasks.
FromDate	Date	False	No	Start date indicating when the lot and serial data is valid or applicable. This ensures accurate time-based tracking and validation for order fulfillment.
HeaderId	Long	False	No	Unique identifier for the order header, linking the lot and serial information to the overall sales order, ensuring consistency across the order.
OrderKey	String	False	No	Unique key used to reference the sales order for managing the lot and serial data, ensuring all related transactions are tracked under the correct order.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used for tracking, invoicing, and fulfillment processes.
SourceTransactionNumber	String	False	No	Transaction number from the source system that links the lot and serial data to its originating transaction, ensuring proper integration and traceability.
SourceTransactionSystem	String	False	No	Name of the source system from which the lot and serial data originated, providing context for integration with external platforms and ensuring consistency across systems.
ToDate	Date	False	No	End date marking when the lot and serial data is no longer valid or applicable, ensuring accurate, time-bound tracking and management.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the manual price adjustment to the parent order, ensuring proper tracking of adjustments within the order lifecycle.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the manual price adjustment, allowing tracking of adjustments at the line level for accurate pricing and order fulfillment.
ManualPriceAdjustmentId [KEY]	Long	False	No	Unique identifier for the manual price adjustment applied to the order, used for tracking and managing price adjustments throughout the order lifecycle.
AdjustmentAmount	Decimal	False	No	The amount of the manual price adjustment, either as a fixed amount or a percentage, applied to a charge or the total amount in the order.
AdjustmentElementBasis	String	False	No	Basis used for calculating the manual price adjustment, such as total price, list price, or net price, providing context for how the adjustment is applied.
AdjustmentElementBasisName	String	False	No	Name describing the basis used for the price adjustment, helping clarify the method of calculation for transparency in pricing.
AdjustmentTypeCode	String	False	No	Abbreviation identifying the type of manual price adjustment, such as discount, surcharge, or promotional offer, providing a quick reference for the adjustment type.
AdjustmentType	String	False	No	The method used to calculate the manual price adjustment, such as a percentage discount, a fixed amount reduction, or other pricing models.
ChargeDefinitionCode	String	False	No	Abbreviation identifying the charge definition for the manual price adjustment, helping to categorize and track charge types for price adjustments.
ChargeDefinition	String	False	No	Description of the charge definition applied for the price adjustment, clarifying the specific charges affected by the adjustment.
ChargeRollupFlag	Bool	False	No	Indicates whether pricing should roll up the charge for the adjustment (true) or not (false). For Oracle Fusion priced orders, this default value is based on pricing setup. For pre-priced orders, no default is set.
Comments	String	False	No	Additional comments or notes describing the rationale or details of the manual price adjustment, providing context for review or auditing.
ParentEntityId	Long	False	No	Identifier for the parent entity (such as a promotion or contract) associated with the manual price adjustment, linking it to larger pricing strategies.
PricePeriodicityCode	String	False	No	Abbreviation identifying the price periodicity for the charge affected by the price adjustment, such as monthly, yearly, or quarterly.
PricePeriodicity	String	False	No	Description of the price periodicity for the charge adjustment, helping to define the frequency at which the adjustment is applied.
ReasonCode	String	False	No	Abbreviation identifying the reason for the price adjustment, such as promotional discount or contractual obligation.
Reason	String	False	No	Description of the reason for the price adjustment, providing context for why the adjustment was applied.
SequenceNumber	Int	False	No	Order of the manual price adjustment in relation to other adjustments, used for prioritization when multiple adjustments are applied to the same order line.
SourceManualPriceAdjustmentId	String	False	No	Unique identifier assigned by the source application for the manual price adjustment, ensuring consistency and integration with external systems.
ValidationStatusCode	String	False	No	Validation status code indicating whether the manual price adjustment has been validated or requires further review, ensuring proper application of adjustments.
EffectivityTypeCode	String	False	No	Abbreviation that identifies the type of effectivity to use for the price adjustment. Defines when the adjustment is applicable, such as immediate, scheduled, or based on certain conditions. Accepted values are defined in ORA_OSS_PRICE_ADJ_EFFECTIVITY. Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features.
EffectivityType	String	False	No	Description of the effectivity type for the price adjustment, helping to clarify when the adjustment will be applied (for example, on order submission or based on specific criteria). Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features.
EffectivePeriodFrom	Decimal	False	No	The period number from which the price adjustment starts, used for determining the validity of the adjustment over a series of time periods. Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features.
EffectivePeriodUntil	Decimal	False	No	The period number until which the price adjustment is valid, ensuring that the adjustment is only applied within a specific time frame. Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features.
EffectiveNumberOfPeriods	Decimal	False	No	The number of periods for which the price adjustment will be applied, defining the duration of the adjustment's effect. Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features.
Finder	String	False	No	Method or tool used to locate specific manual price adjustment records, facilitating efficient retrieval and management of pricing data.
FromDate	Date	False	No	Start date of the manual price adjustment, marking when the adjustment becomes valid or effective.
HeaderId	Long	False	No	Unique identifier for the header of the price adjustment record, linking the adjustment to the overall sales order or pricing entity.
OrderKey	String	False	No	Key used to reference the sales order associated with the manual price adjustment, ensuring that the adjustment is tracked under the correct order.
OrderNumber	String	False	No	Unique order number for the sales order, used for tracking the adjustment and ensuring consistency in reporting and fulfillment.
SourceTransactionNumber	String	False	No	Transaction number from the source system that links the manual price adjustment to its originating transaction.
SourceTransactionSystem	String	False	No	Source system name that provided the data for the manual price adjustment, helping ensure consistency and accurate integration between systems.
ToDate	Date	False	No	End date for the manual price adjustment, marking when the adjustment is no longer valid or applicable to the order.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the original order reference to the parent order. This ensures proper tracking of the order's origin and relationship to subsequent changes or updates.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the original order reference, helping to track the fulfillment details for specific items on the order.
OriginalOrderNumber	String	False	No	Original order number, referencing the first order in a sequence or as the initial order in a series of linked transactions. This provides context for tracing the order's origin and any changes made.
OriginalSourceOrderNumber	String	False	No	Source order number from the external or originating system, ensuring the integration and consistency between Oracle Fusion and external order management systems.
OriginalSourceLineNumber	String	False	No	Line number from the source system that identifies a specific line item in the original order, enabling cross-system integration and accurate tracking of item details.
OriginalFulfillLineId	Long	False	No	Unique identifier for the fulfillment line from the original order, used for associating fulfillment activities with the original order's items.
OriginalHeaderId	Long	False	No	Header ID from the original order, linking it to the overall sales order and providing a connection between the original and subsequent orders or changes.
OriginalItemNumber	String	False	No	Original item number from the first order, used to reference the specific item being tracked across order modifications, returns, or other changes.
OriginalSourceOrderId	String	False	No	Unique identifier for the source order from the originating system, ensuring consistency and tracking when the original order comes from an external application.
OriginalSourceLineId	String	False	No	Line ID from the source system for the original order, enabling specific line-level reference for order integration and updates across systems.
OriginalSourceOrderSystem	String	False	No	Name of the source system from which the original order was placed, providing the context of the external system where the order was initiated.
OriginalItemLineNumber	String	False	No	Line number for the item in the original order, aiding in linking specific items to their corresponding orders and facilitating cross-system consistency.
Finder	String	False	No	Method or tool used to locate specific records in the order management system, allowing for efficient tracking and retrieval of related order reference data.
FromDate	Date	False	No	Start date when the original order reference becomes valid or applicable. This is useful for tracking the period when the order information is active or in effect.
HeaderId	Long	False	No	Unique identifier for the header of the order reference, linking the original order details to the overall sales order.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the original order reference, ensuring all related transactions are tracked under the correct order.
OrderNumber	String	False	No	Unique sales order number that helps in tracking and referencing the order details, ensuring proper integration and consistency in the system.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the original order reference to its originating transaction and ensuring traceability across systems.
SourceTransactionSystem	String	False	No	Source system name that provided the data for the original order reference, ensuring that external system integrations are properly tracked and consistent.
ToDate	Date	False	No	End date when the original order reference is no longer valid, marking the expiration or closure of the reference, ensuring timely updates in Oracle Fusion.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking payment details to the parent order. This is crucial for maintaining order integrity and tracking payment-related activities across orders.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the payment, enabling tracking of payments at the line level within the sales order.
PaymentTransactionId [KEY]	Long	False	No	Unique identifier for the payment transaction, helping to link the payment activity with its associated sales order line for reconciliation and audit.
Amount	Decimal	False	No	Amount authorized for the payment, representing the total funds approved for the transaction.
AuthorizationStatusCode	String	False	No	Code representing the status of the payment authorization. Possible values include 'Pass' or 'Fail' to indicate whether the payment was successfully authorized.
AuthorizationStatus	String	False	No	Text description of the authorization status, reflecting whether the payment transaction passed or failed authorization.
AuthorizedInSourceFlag	Bool	False	No	Flag indicating whether the payment was authorized in the source system. This field is used to track the payment status across different systems.
AuthorizedOn	Datetime	False	No	Date and time when the payment authorization was processed, marking the approval or rejection time for the transaction.
InstrumentAssignmentId	Long	False	No	Unique identifier for the instrument assignment, used to track the payment instrument assigned to the transaction.
OriginalSystemPaymentReference	String	False	No	Reference number from the source system that identifies the original payment transaction, ensuring consistency and proper tracking across systems.
PaymentTypeCode	String	False	No	Abbreviation identifying the payment type, such as credit card or bank transfer.
PaymentType	String	False	No	Name of the payment method used for the transaction, indicating whether it was made via credit card, bank transfer, or another payment method.
PaymentSetId	Long	False	No	Identifier for the group of payments associated with a prepaid sales order. This is important for tracking all payments related to prepayments and their reference to billing.
PaymentMethod	String	False	No	Name of the payment method used for billing the transaction (for example, card payments or ACH).
TransactionExtensionId	Long	False	No	Identifier for the extension of the payment transaction in the payment system, used for additional transaction details beyond the basic payment authorization.
UniquePaymentReference	String	False	No	A unique identifier for the payment, ensuring that each payment transaction is tracked and referenced distinctly.
PaymentMethodCode	Long	False	No	Abbreviation for the payment method used, referenced for billing purposes in Oracle Fusion Order Management, ensuring payments are properly allocated.
CardTokenNumber	String	False	No	Token number provided by the tokenization service, used to replace sensitive card information with a secure token, protecting cardholder data.
CardFirstName	String	False	No	First name of the cardholder associated with the payment card.
CardLastName	String	False	No	Last name of the cardholder associated with the payment card.
CardExpirationDate	String	False	No	Expiration date of the payment card in YYYY/MM/DD format, indicating when the card is no longer valid for transactions.
CardIssuerCode	String	False	No	Code representing the issuer of the payment card, such as 'Visa' or 'MasterCard'.
MaskedCardNumber	String	False	No	Partially masked card number for security purposes, showing only the last four digits and replacing others with 'X'. This protects sensitive payment information while allowing reference. The length of the masked card number should match the actual length of the number provided by the card issuer. For example, the masked card number for a Visa is XXXXXXXXXXXX2345.
AuthorizationRequestId	String	False	No	Identifier for the authorization request sent to the tokenization service, used to track the request made to authorize the card. To import a card authorization other than the Card Token Number, provide the Card Authorization Request Identifier or the Card Voice Authorization Code. If both are provided, the Card Authorization Request Identifier takes precedence.
VoiceAuthorizationCode	String	False	No	Authorization code provided for voice-based authorization, used when a card authorization is conducted via a phone call or manually through a service. To import a card authorization other than the Card Token Number, provide the Card Authorization Request Identifier or the Card Voice Authorization Code. If both are provided, the Card Authorization Request Identifier takes precedence.
PaymentServerOrderNumber	String	False	No	Order number assigned by Oracle Payments Cloud, identifying the payment transaction in the Oracle payments system.
AuthorizedAmount	Decimal	False	No	Amount authorized by the tokenization service provider, confirming the amount approved for the transaction.
Finder	String	False	No	Method or tool used to locate specific payment records in Oracle Fusion Order Management, facilitating quick retrieval of payment data.
FromDate	Date	False	No	Start date when the payment details become valid or applicable, used to track the payment period.
HeaderId	Long	False	No	Header ID for the order, used to link the payment details with the overall sales order in Oracle Fusion Order Management.
OrderKey	String	False	No	Key used to uniquely reference the order associated with the payment, ensuring that all related transactions are grouped correctly.
OrderNumber	String	False	No	Sales order number used for referencing the order and associated payment activities in reports, invoicing, and fulfillment.
SourceTransactionNumber	String	False	No	Source transaction number from the originating system, linking the payment to its source transaction and ensuring consistency during system integration.
SourceTransactionSystem	String	False	No	Source system name where the original payment data was generated, providing insight into external system integration and context.
ToDate	Date	False	No	End date when the payment details are no longer valid, marking the conclusion of the payment period.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the price adjustments to the parent order. This helps track and associate price adjustments at the order level within Oracle Fusion Order Management.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the price adjustment, enabling tracking of price adjustments at the line level within Oracle Fusion Order Management.
PriceAdjustmentId [KEY]	Long	False	No	Unique identifier for the price adjustment applied to the order line. This helps track and reconcile price adjustments made during the order lifecycle, ensuring proper application and reporting.
AdjustmentName	String	False	No	Name or description of the price adjustment, providing additional context to the specific adjustment applied, such as a discount, surcharge, or price override.
Amount	Decimal	False	No	The amount of the price adjustment applied to the order line, either as a positive or negative value depending on whether the price is being increased or decreased.
AdjustmentTypeCode	String	False	No	Abbreviation or code that identifies the type of price adjustment applied to the order line, such as a discount, markup, or surcharge.
AdjustmentType	String	False	No	The type of adjustment applied, which could be a discount, surcharge, or other price modification. This helps classify the nature of the adjustment.
InvoicedFlag	Bool	False	No	Flag indicating whether the price adjustment has been invoiced. A value of true means the adjustment has been included in the invoice, while false means it has not yet been invoiced.
OrigSystemAdjustmentReference	String	False	No	Original reference from the source system that identifies the price adjustment, used to maintain consistency across systems and ensure accurate integration.
Finder	String	False	No	Method or tool used to locate specific price adjustment records in Oracle Fusion Order Management, allowing for efficient retrieval and analysis of price adjustments.
FromDate	Date	False	No	The start date when the price adjustment becomes effective. This date marks the period during which the adjustment applies to the order.
HeaderId	Long	False	No	Unique identifier for the header of the price adjustment record, linking it to the overall sales order header in Oracle Fusion Order Management.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the price adjustment. This ensures that all related transactions and adjustments are tracked under the correct order.
OrderNumber	String	False	No	Unique order number assigned to the sales order, providing a reference for reporting, invoicing, and tracking within Oracle Fusion Order Management.
SourceTransactionNumber	String	False	No	Transaction number from the source system that identifies the original transaction linked to the price adjustment, ensuring consistency in cross-system integration.
SourceTransactionSystem	String	False	No	Name of the source system that provided the original transaction data. This helps maintain data integrity during system integrations and transactions.
ToDate	Date	False	No	The end date when the price adjustment is no longer valid. This date marks the expiration of the adjustment period, ensuring that the adjustment only applies within the specified timeframe.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the price validations to the parent order. This ensures proper tracking and management of price validation at the order level within Oracle Fusion Order Management.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the price validation, enabling tracking and application of price validations at the line level within Oracle Fusion Order Management.
ChargeDefinitionCode	String	False	No	Code representing the definition of the charge subject to validation, used to categorize and identify the specific charge within the system for validation purposes.
ChargeDefinition	String	False	No	Name or description of the charge subject to validation, such as a discount, surcharge, or standard price, providing clarity on what charge is being validated.
ChargeId	Long	False	No	Unique identifier for the charge associated with the price validation, helping link the validation directly to the specific charge within the order.
ConstrainingValue	Decimal	False	No	The value that constrains the price validation, such as a maximum or minimum allowable price, used to enforce rules and restrictions during pricing.
ConstrainingValueTypeCode	String	False	No	Code representing the type of constraining value used in the price validation, such as a percentage or fixed amount, which determines how the validation is applied.
ConstrainingValueTypeName	String	False	No	Name describing the constraining value type, helping clarify how the validation applies based on the constraining factor, such as percent-based or amount-based.
Explanation	String	False	No	Detailed explanation of the price validation, providing context or reasoning for why the validation is being applied to the charge or order.
ExplanationMessageName	String	False	No	Name of the message displayed to explain the validation, often shown to users in Oracle Fusion Order Management when the price validation fails or triggers.
HeaderCurrencyConstrainingAmount	Decimal	False	No	Constraining amount for the validation, expressed in the currency of the order header, representing the threshold or limit for the price validation in that currency.
HeaderCurrencyCode	String	False	No	Currency code used for the order header, indicating the currency type for the constraining amount and helping ensure proper currency conversion and validation.
HeaderCurrencyName	String	False	No	Name of the currency used in the order header, providing clear identification of the currency for the price validation and the corresponding constraining amount.
ManualPriceAdjustmentId	Long	False	No	Unique identifier for the manual price adjustment applied to the order line, linking the price validation to any manual adjustments made to the pricing.
PricePeriodicityCode	String	False	No	Code identifying the periodicity of the price validation, indicating the frequency at which the validation applies, such as monthly or quarterly.
PricePeriodicity	String	False	No	Description of the price periodicity, providing further context to the time-based nature of the validation, such as monthly or quarterly.
PriceValidationId [KEY]	Long	False	No	Unique identifier for the price validation, allowing tracking and reporting of individual validation instances within the order processing system.
RollupFlag	Bool	False	No	Flag indicating whether the price validation applies to the rollup charge, which aggregates multiple charges. If true, the validation is applied to the rollup; if false, it is applied to individual charges.
ValidationComponentEntityType	String	False	No	Entity type to which the price validation applies, such as a product, service, or contract, helping to specify which part of the order is being validated.
ValidationComponentCode	String	False	No	Code representing the specific validation component, which helps identify the element or criteria being validated within the pricing rules.
ValidationComponent	String	False	No	Description of the validation component, such as product price, service fee, or shipping cost, providing clear identification of what the validation pertains to.
ValidationComponentEntityId	Long	False	No	Unique identifier for the entity being validated, such as the product ID or service code, linking the validation to a specific entity within the order.
ValidationSourceRuleId	Long	False	No	Unique identifier for the source rule applied to the price validation, helping to trace the origin of the validation rule that was triggered.
ValidationSourceTypeCode	String	False	No	Code representing the source type of the validation, such as a price list, discount rule, or contract, defining the source that initiated the validation.
ValidationSourceType	String	False	No	Description of the source type, providing a clearer context for the validation source, such as 'price list,' 'contract,' or 'discount.'
ValidationStatus	String	False	No	Status of the price validation, such as 'Passed,' 'Failed,' or 'Pending,' indicating whether the validation was successful or if corrective action is required.
ViolationTypeCode	String	False	No	Code identifying the type of violation triggered by the validation, such as exceeding the maximum price or failing to apply a required discount.
ViolationTypeName	String	False	No	Name describing the violation type, offering a more detailed explanation of why the validation failed or was violated, such as 'Price Exceeds Limit' or 'Invalid Discount.'
Finder	String	False	No	Method or tool used to locate specific price validation records in Oracle Fusion Order Management, allowing efficient retrieval and analysis of validation data.
FromDate	Date	False	No	Start date when the price validation becomes effective. This date marks the period during which the validation applies to the order or line.
HeaderId	Long	False	No	Unique identifier for the header of the price validation record, linking it to the overall sales order or charge in Oracle Fusion Order Management.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the price validation, ensuring that the validation is applied to the correct order.
OrderNumber	String	False	No	Unique order number assigned to the sales order, providing a reference for tracking and reporting within Oracle Fusion Order Management.
SourceTransactionNumber	String	False	No	Transaction number from the source system that identifies the original transaction linked to the price validation, ensuring consistency in cross-system integration.
SourceTransactionSystem	String	False	No	Name of the source system from which the transaction data originated, maintaining data integrity and traceability during system integrations.
ToDate	Date	False	No	End date when the price validation is no longer valid. This date marks the expiration of the validation period, ensuring that the validation is applied only within the specified timeframe.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the project details to the overall order in Oracle Fusion Order Management. This helps track the project's association with the order throughout its lifecycle.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the specific fulfillment line related to the project. This allows tracking of the project’s application at the line level within Oracle Fusion Order Management, ensuring that project data is associated with the correct order line.
DooOrderPrjId [KEY]	Long	False	No	Unique identifier for the project associated with an order line, used to distinguish the project for tracking purposes and enabling integration with project management and accounting systems in Oracle.
Finder	String	False	No	Method or tool used to locate specific project records within Oracle Fusion Order Management, enabling efficient retrieval of project-related data and allowing for better reporting and analysis.
FromDate	Date	False	No	Start date when the project becomes effective for the order line, helping to track the period during which the project is associated with the order in Oracle Fusion.
HeaderId	Long	False	No	Unique identifier for the header of the project record, linking it to the sales order header and ensuring that the project data is correctly associated with the overall order in Oracle Fusion.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the project, ensuring that all related transactions are properly tracked and linked to the correct order.
OrderNumber	String	False	No	Unique number assigned to the sales order, providing a reference for tracking the order's details and the associated project within Oracle Fusion Order Management.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the project reference to its originating transaction. This ensures consistency and traceability across systems when integrating data from external sources.
SourceTransactionSystem	String	False	No	Name of the source system from which the project data originated. This helps ensure consistency and proper integration with other systems and Oracle Fusion.
ToDate	Date	False	No	End date when the project reference is no longer valid for the order line. This date marks the expiration of the project association with the order, ensuring that project data is time-bound and accurate.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the project details to the overall order. This ensures that the project is properly associated with the order for tracking and reporting.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the specific fulfillment line related to the project. This enables tracking of project details at the line level within the sales order.
ProjectDooOrderPrjId [KEY]	Long	False	No	Unique identifier for the project associated with the sales order line, used to distinguish the project and link it to the order. It helps integrate the order with project management systems.
Finder	String	False	No	Method or tool used to locate specific project details within the system, making it easier to search and retrieve project-related records.
FromDate	Date	False	No	Start date when the project details become effective for the order line, helping to determine the period during which the project is active.
HeaderId	Long	False	No	Unique identifier for the project header, linking the project details to the sales order header. This ensures proper association and consistency across all project-related data.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the project. It ensures that all related transactions and project details are properly tracked under the correct order.
OrderNumber	String	False	No	Unique order number assigned to the sales order, providing a reference for tracking both the order and the associated project.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the project details to its originating transaction. This ensures proper integration and consistency when data is exchanged between systems.
SourceTransactionSystem	String	False	No	Name of the source system where the project details originated. This is important for ensuring consistency across different platforms and systems, especially when integrating with external applications.
ToDate	Date	False	No	End date when the project details are no longer valid for the order line. This helps track the expiration of the project association with the order.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the sales credits to the overall order. This ensures that sales credits are properly tracked and associated with the correct order.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the sales credit. This allows the sales credit to be tracked at the line level within the order.
SalesCreditId [KEY]	Long	False	No	Unique identifier for the sales credit, helping to distinguish and track individual sales credit entries within the system.
SalespersonId	Long	False	No	Unique identifier for the salesperson who is credited with the sale, allowing for accurate attribution of sales credit.
Salesperson	String	False	No	Name of the salesperson who is credited with the sale. This helps identify the individual responsible for the transaction and links the credit to their sales performance.
Percent	Decimal	False	No	The percentage value of the sales credit allocated to the salesperson, typically based on commission structures or predefined sales targets.
SalesCreditTypeId	Long	False	No	Unique identifier for the sales credit type, helping to classify different types of sales credits based on business rules or agreement terms.
SalesCreditType	String	False	No	The name of the sales credit type, which helps distinguish between different categories of credits, such as bonuses, commission-based credits, or discounts.
SourceTransactionSalesCreditIdentifier	String	False	No	Value that uniquely identifies the sales credit in the source system, ensuring consistency and traceability during integration with other platforms or systems.
Finder	String	False	No	Method or tool used to locate specific sales credit records in the system, enabling efficient retrieval of sales credit data associated with the sales order.
FromDate	Date	False	No	The start date when the sales credit becomes valid, helping to track the period during which the credit applies.
HeaderId	Long	False	No	Unique identifier for the sales credit header, linking the sales credit to the sales order header and ensuring proper organization of credit information.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the sales credit, ensuring that all related transactions are tracked under the correct order.
OrderNumber	String	False	No	Unique number assigned to the sales order, providing a reference for tracking both the order and the associated sales credit.
SourceTransactionNumber	String	False	No	Transaction number from the source system that links the sales credit to its originating transaction, ensuring integration between systems.
SourceTransactionSystem	String	False	No	Source system from which the sales credit originated, ensuring consistency and integration with external systems or applications.
ToDate	Date	False	No	The end date when the sales credit is no longer valid, marking the expiration of the credit.

Return to Top

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

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the supply order reference to the overall sales order. This ensures that the supply details are properly associated with the correct order.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the supply order reference, enabling tracking of the supply at the line level within the order.
SupplyOrderNumber	String	False	No	Unique identifier for the supply order. This number links the sales order to its corresponding supply order in the system, helping to track fulfillment and inventory movements.
DocumentSystemReferenceId [KEY]	Long	False	No	Unique identifier for the document system reference, linking the supply order to the corresponding document in the source system, ensuring integration between external and internal systems.
Finder	String	False	No	Method or tool used to locate specific supply order reference records in the system, facilitating efficient retrieval of supply-related data associated with the sales order.
FromDate	Date	False	No	Start date when the supply order reference becomes valid for use in processing the sales order, indicating when the supply order is effective.
HeaderId	Long	False	No	Unique identifier for the header of the supply order reference, ensuring proper linkage of supply order details to the overall sales order.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the supply order, ensuring that all related supply transactions are tracked under the correct order.
OrderNumber	String	False	No	Unique number assigned to the sales order, used for referencing the order and its associated supply order details.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the supply order reference to its originating transaction, ensuring data consistency during integration with external systems.
SourceTransactionSystem	String	False	No	Source system name from which the supply order reference data originated, providing context for integration with external platforms and ensuring consistent transaction flow.
ToDate	Date	False	No	End date when the supply order reference is no longer valid for use, marking the expiration of the supply order reference in the order processing cycle.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the transaction item attributes to the overall order. This ensures proper tracking and association of item attributes at the order level.
LinesFulfillLineId [KEY]	Long	False	No	Identifier for the fulfillment line associated with the transaction item attribute, enabling tracking of attributes at the line level within the order.
CharacterAttributeValue	String	False	No	Character-based value for the transaction item attribute (TIA), used to store non-numeric data such as descriptions or identifiers specific to the item on the order line.
DateAttributeValue	Date	False	No	Date-based value for the TIA, used for attributes that store specific date-related information, such as expiry dates or delivery schedules.
NumberAttributeValue	Decimal	False	No	Numeric value for the TIA, used to store quantitative information such as quantity or price relevant to the item on the order line.
SourceTransactionLineAttributeId	String	False	No	Unique identifier for the transaction item attribute on the fulfillment line, assigned by the source application, linking the attribute to its original data source.
TimestampAttributeValue	Datetime	False	No	Timestamp-based value for the TIA, used to capture precise date and time values for time-sensitive data associated with the item on the order line.
TransactionAttributeId [KEY]	Long	False	No	Unique identifier for the transaction item attribute, linking it to the overall sales order and helping manage item-level attributes during processing.
TransactionAttributeName	String	False	No	Name of the transaction item attribute, providing a descriptive label to identify the attribute and its purpose within the order processing system.
TransactionAttributeMetadataid	Long	False	No	Unique identifier for the TIA metadata, which stores the structure and properties of the attribute for reference within the system.
TransactionItemAttributeId	Long	False	No	Unique identifier for the TIA, enabling linkage of specific attributes to individual items on the sales order.
Finder	String	False	No	Method or tool used to locate transaction item attribute records in the system, allowing efficient retrieval of attributes associated with the sales order and fulfillment line.
FromDate	Date	False	No	Start date when the transaction item attribute becomes valid, ensuring the attribute is applied correctly during the specified time period.
HeaderId	Long	False	No	Unique identifier for the header of the transaction item attribute record, linking the attribute to the overall order in the system.
OrderKey	String	False	No	Unique key for referencing the sales order associated with the transaction item attribute, ensuring that all related item attributes are tracked under the correct order.
OrderNumber	String	False	No	Unique order number assigned to the sales order, used to reference the order in reports, invoicing, and fulfillment.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the transaction item attribute to its originating transaction, ensuring consistency when integrating with external systems.
SourceTransactionSystem	String	False	No	Source system name from which the transaction item attribute data originated, providing context for integration with external systems and ensuring consistency across platforms.
ToDate	Date	False	No	End date when the transaction item attribute is no longer valid, marking the expiration of the attribute in the system. This ensures that attributes are applied correctly within a defined timeframe.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the payment transaction to the overall order. This ensures proper tracking and association of payments at the order level.
PaymentTransactionId [KEY]	Long	False	No	Unique identifier for the payment transaction, used to track the payment in the system and link it to specific order or invoice transactions.
Amount	Decimal	False	No	Amount authorized for the payment, representing the monetary value that has been approved for the transaction.
AuthorizationStatusCode	String	False	No	Status code of the payment authorization. Possible values include 'Pass' or 'Fail', indicating whether the payment was successfully authorized.
AuthorizationStatus	String	False	No	Text description of the authorization status of the payment transaction. Values include 'Pass' or 'Fail', providing a more detailed status of the authorization process.
AuthorizedInSourceFlag	Bool	False	No	Flag indicating whether the payment has been authorized in the source system. If true, the payment is authorized; if false, it has not been authorized.
AuthorizedOn	Datetime	False	No	Date and time when the payment was authorized, indicating when the authorization was processed by the system.
InstrumentAssignmentId	Long	False	No	Unique identifier for the payment instrument assignment, linking the payment to a specific instrument, such as a credit card or bank account, in the system.
OriginalSystemPaymentReference	String	False	No	Value that uniquely identifies the payment details from the source application, allowing for integration and tracking of the payment in external systems.
PaymentTypeCode	String	False	No	Abbreviation that identifies the payment type, such as credit card or bank transfer, used to categorize the payment method.
PaymentType	String	False	No	Name of the payment method used for the transaction, such as 'Credit Card' or 'Bank Transfer', describing how the payment was made.
PaymentSetId	Long	False	No	Unique identifier for the group of payments associated with a prepayment on a sales order. This attribute references billing for grouped payments related to prepaid orders.
PaymentMethod	String	False	No	Name of the billing payment method, such as 'Credit Card', 'Direct Debit', used for collecting the open balance on the invoice.
TransactionExtensionId	Long	False	No	Identifier for the extension of the payment transaction in the payment system, used for tracking additional payment-related details.
UniquePaymentReference	String	False	No	Unique reference assigned to the payment for tracking and reconciliation purposes.
PaymentMethodCode	Long	False	No	Abbreviation that identifies the payment method, used by the application to collect the payment on the invoice and manage payment processing.
CardTokenNumber	String	False	No	Token number issued by the tokenization service provider corresponding to the card number. This is required for card token and authorization imports.
CardFirstName	String	False	No	First name of the cardholder, as it appears on the card used for the payment.
CardLastName	String	False	No	Last name of the cardholder, as it appears on the card used for the payment.
CardExpirationDate	String	False	No	Expiration date of the card used for the payment, formatted as YYYY/MM/DD, indicating when the card is no longer valid.
CardIssuerCode	String	False	No	Issuer code of the card, identifying the card network (for example, Visa, MasterCard) or the issuing bank.
MaskedCardNumber	String	False	No	Masked version of the card number, showing only the last four digits for security purposes. All other digits are replaced with 'X'. The length of the masked card number must match the actual length of the number provided by the card issuer. For example, the masked card number for a Visa is XXXXXXXXXXXX2345.
AuthorizationRequestId	String	False	No	Unique identifier for the authorization request received from the tokenization service provider, used for tracking authorization attempts and statuses. To import a card authorization other than the Card Token Number, provide either the Card Authorization Request Identifier or the Card Voice Authorization Code. If both are provided, the Card Authorization Request Identifier takes precedence.
VoiceAuthorizationCode	String	False	No	Code identifying the card authorization. If both the Card Authorization Request Identifier and the Voice Authorization Code are provided, the former takes precedence.
PaymentServerOrderNumber	String	False	No	Number that identifies the card payment authorized by Oracle Payments Cloud, linking the payment to the specific transaction within Oracle Payments.
AuthorizedAmount	Decimal	False	No	Amount authorized for the transaction, as received from the tokenization service provider. This value must be provided if the authorization request identifier is included.
Finder	String	False	No	Method or tool used to locate payment records in the system, allowing efficient retrieval of payments associated with a particular order or transaction.
FromDate	Date	False	No	Start date when the payment transaction becomes valid, used for tracking the transaction's time period.
HeaderId	Long	False	No	Unique identifier for the header record of the payment transaction, linking it to the overall sales order or billing record.
OrderKey	String	False	No	Key used to reference the sales order associated with the payment transaction, ensuring all related payments are tracked under the correct order.
OrderNumber	String	False	No	Unique number assigned to the sales order, used to reference the order in reports, invoicing, and fulfillment.
SourceTransactionNumber	String	False	No	Transaction number from the source system, linking the payment transaction to its originating transaction and ensuring consistency in integration.
SourceTransactionSystem	String	False	No	Source system name from which the payment transaction data originated, providing context for integration with external systems.
ToDate	Date	False	No	End date when the payment transaction is no longer valid, marking the expiration of the payment in the system and ensuring correct tracking of payment validity.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the sales credit to the overall order. This helps in tracking sales credits at the order level.
SalesCreditId [KEY]	Long	False	No	Unique identifier for the sales credit, used to track and reference the specific credit associated with a sales order.
SalespersonId	Long	False	No	Identifier for the salesperson responsible for the sale, enabling tracking and commission calculation for sales personnel.
Salesperson	String	False	No	Name of the salesperson who was credited for the sale, providing a reference to the individual responsible for the transaction.
Percent	Decimal	False	No	Percentage of the sale attributed as the salesperson's credit, used for calculating the salesperson's commission or reward.
SalesCreditTypeId	Long	False	No	Unique identifier for the sales credit type, which helps in categorizing different types of sales credits (for example, standard, promotional).
SalesCreditType	String	False	No	Name of the sales credit type, providing a description of the kind of credit applied (for example, 'Standard', 'Promotional').
SourceTransactionSalesCreditIdentifier	String	False	No	Unique identifier for the sales credit from the source system, allowing integration with external systems for tracking purposes.
Finder	String	False	No	Method or tool used to locate specific sales credit records within the system, enabling efficient retrieval and management of sales credit data.
FromDate	Date	False	No	Start date when the sales credit is valid, marking the beginning of the time period during which the credit applies.
HeaderId	Long	False	No	Unique header ID linking the sales credit to the overall sales order header, ensuring consistency across related transactions.
OrderKey	String	False	No	Key used to reference the sales order associated with the sales credit, ensuring all related transactions are tracked under the correct order.
OrderNumber	String	False	No	Unique identifier for the sales order, used for referencing the order in reports, invoicing, and fulfillment.
SourceTransactionNumber	String	False	No	Transaction number from the source system, used to link the sales credit to its originating transaction for tracking and reconciliation.
SourceTransactionSystem	String	False	No	Name of the source system from which the sales credit data originated, providing context for integration with external systems and ensuring consistency.
ToDate	Date	False	No	End date when the sales credit expires or is no longer valid, marking the end of the time period during which the credit applies.

Return to Top

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

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the totals to the overall order in the system.
OrderTotalId [KEY]	Long	False	No	Unique identifier for the order total, allowing tracking and management of the total values for the order.
TotalName	String	False	No	Name assigned to the total, used to specify the type of total (for example, subtotal, taxes, shipping) in the order.
TotalCode	String	False	No	Code assigned to the total for identification and categorization of the total (for example, TAX, SHIPPING).
TotalAmount	Decimal	False	No	Total amount for the order, calculated based on various factors like items, discounts, and taxes.
CurrencyName	String	False	No	Name of the currency used for the total, ensuring proper financial tracking across different regions (for example, USD, EUR).
CurrencyCode	String	False	No	Code of the currency used for the total, adhering to standard currency abbreviations (for example, USD).
TotalGroup	String	False	No	Group name to categorize the total (for example, charges, discounts, taxes) for easier reporting and analysis.
PrimaryFlag	Bool	False	No	Indicates whether the total is the primary total for the order (true) or not (false), typically used for financial reporting.
EstimatedFlag	Bool	False	No	Flag indicating whether the total is estimated (true) or actual (false), useful for provisional amounts in Oracle Fusion Order Management.
DisplayName	String	False	No	Display name for the total, often used in user interfaces or reports for easy reference by the customer or sales representative.
Finder	String	False	No	Method or tool used to locate specific total records in the system, enhancing data retrieval and search functionality.
FromDate	Date	False	No	Start date from which the total information is valid, used for ensuring accurate financial reporting from that point onward.
HeaderId	Long	False	No	Unique identifier for the header linking the total information to the sales order header in the system, ensuring data consistency.
OrderKey	String	False	No	Unique key used to reference the sales order associated with the total, helping ensure the correct data is tied to the appropriate order.
OrderNumber	String	False	No	Unique order number used to identify the sales order, a key reference point for reporting, invoicing, and shipping.
SourceTransactionNumber	String	False	No	Transaction number from the source system, used to link the total data to its originating transaction for consistency.
SourceTransactionSystem	String	False	No	Source system name from which the total data originated, providing context for integration with external systems.
ToDate	Date	False	No	End date when the total information is no longer valid, ensuring that the total amounts remain accurate for the defined time frame.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
SalesOrdersForOrderHubHeaderId [KEY]	Long	False	No	Unique identifier for the sales order header, linking the total components to the overall order. Ensures consistency and proper tracking across systems.
TotalsOrderTotalId [KEY]	Long	False	No	Unique identifier for the order total, which aggregates all the total components related to the order. This ID helps group totals for reporting.
OrderTotalId	Long	False	No	Unique identifier for the specific order total within the overall order. It tracks the financials at a finer level, especially for invoices and charges.
OrderTotalComponentId [KEY]	Long	False	No	Unique identifier for the specific component of the order total. Used for detailed financial tracking and categorization of the total components.
OrderChargeComponentId	Long	False	No	Unique identifier for the charge component associated with the total. Helps distinguish between different charge types and their impact on the order total.
HeaderCurrencyCode	String	False	No	Currency code used for the header's financial transactions, such as USD, EUR, or GBP. It ensures proper currency tracking for the entire order.
HeaderCurrencyName	String	False	No	Currency name used for the header's financial transactions, such as USD, EUR, or GBP. This helps clarify the currency in reports.
HeaderCurrencyExtendedAmount	Decimal	False	No	The total amount for the header in the specified currency, including all charges, taxes, and other components, to provide an accurate financial total.
PriceElementCode	String	False	No	Code identifying the type of price element, such as list price, discount, tax, or shipping, for each component of the total.
PriceElement	String	False	No	Description or name of the price element (such as list price, discounted price, or tax amount), used to break down the total cost.
PriceElementUsageCode	String	False	No	Code that identifies the usage type of the price element (for example, one-time, recurring). This helps categorize how the price element is applied.
PriceElementUsage	String	False	No	Description of the usage for the price element, such as whether it is applied once or recurring, helping with proper financial tracking and reporting.
Finder	String	False	No	Method or tool used to search for specific total component records in the system, aiding in efficient data retrieval for analysis and reporting.
FromDate	Date	False	No	Start date from which the total component is valid. Ensures that the total components are tracked and applied from the correct date.
HeaderId	Long	False	No	Unique identifier for the header, linking the total component to the specific sales order, ensuring consistency and data integrity.
OrderKey	String	False	No	Unique key used to identify the order associated with the total component, ensuring all components are correctly linked to their respective orders.
OrderNumber	String	False	No	Unique number identifying the sales order. This is used in reports, invoicing, and fulfillment processes to track the order.
SourceTransactionNumber	String	False	No	Transaction number from the source system, used to link the total component to its originating transaction and ensure integration with external systems.
SourceTransactionSystem	String	False	No	Source system name from which the total component data originated, helping with integration and providing context for transaction handling.
ToDate	Date	False	No	End date when the total component is no longer valid, ensuring accurate financial data for reporting, with an accurate cutoff for each total component.

Return to Top

Name	Type	ReadOnly	FilterOnly	Description
LookupType [KEY]	String	False	No	Type of the lookup value in the system. Defines the category or classification for the lookup.
LookupCode [KEY]	String	False	No	Unique identifier or code representing a specific lookup entry within the system.
Meaning	String	False	No	Human-readable description or meaning associated with the lookup code, providing context for users to understand the code.
Description	String	False	No	Detailed explanation or additional information about the lookup entry, often used to clarify its use and purpose.
Tag	String	False	No	A keyword or label used to categorize the lookup value, allowing for easier identification and filtering.
ActiveDate	Date	False	No	The date when the lookup value became active and available for use in the system.
Bind_ParentLookupCode	String	False	No	Code of the parent lookup value, used to establish hierarchical relationships between lookups.
Bind_ParentSetidDetermType	String	False	No	Type of the set identifier determination for the parent lookup, indicating how the parent lookup is determined.
Bind_ParentSetidDetermValue	String	False	No	Value used in determining the parent set ID for the lookup, providing context for the relationship.
Bind_RelationshipId	Long	False	No	Unique identifier for the relationship between the lookup and its associated set or parent.
BindActiveDate	Date	False	No	The date when the binding relationship for the lookup becomes active, indicating when the lookup relationship can be used.
BindLookupCode	String	False	No	Code for the lookup that is being bound to a parent or set, defining its connection in the system.
BindLookupType	String	False	No	Type of the lookup being bound, defining its classification in relation to the parent lookup.
BindTag	String	False	No	A keyword or tag used to categorize the binding relationship, providing additional context to the lookup.
Finder	String	False	No	Method or tool used to locate and retrieve specific lookup values in the system, facilitating easy access and query of data.
NewLookupCode1	String	False	No	An additional code for a new lookup entry, used for expanding or adding values to the lookup set.
NewLookupCode2	String	False	No	Second additional code for a new lookup entry, used for expanding or adding values to the lookup set.
NewLookupCode3	String	False	No	Third additional code for a new lookup entry, used for expanding or adding values to the lookup set.
NewLookupCode4	String	False	No	Fourth additional code for a new lookup entry, used for expanding or adding values to the lookup set.
NewLookupCode5	String	False	No	Fifth additional code for a new lookup entry, used for expanding or adding values to the lookup set.

Return to Top