Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHubsalesCredits

Tracks salesperson credit distribution for completed sales orders.

Columns

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

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