MDF Budget

The budget, and its details, of monetary incentives for partners to execute marketing activities.

QName: {http://xmlns.oracle.com/apps/marketing/commonMarketing/budgets/publicModel/}Budget

Logical Business Objects

  • CRM : Marketing : Marketing Budget

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

MDF Budget Team

Contains

Marketing Budget Translation Version 2

Handled by

MDF Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

ActivatedBy

string

The user who activated the marketing budget.

ActivatedById

long

The ID of the person who activated the marketing budget.

ActivationDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The marketing budget activation date.

AdditionalReferenceId

long

The additional reference identifier associated to the marketing budget, that identifies a particular partner program or marketing source.

AdditionalReferenceSourceCode

string

Display label for two attributes, reference type and reference value. It provides a secondary reference in addition to the primary reference. When the additional reference type is marketing source code, the reference value containing the source code is stored in this attribute.

AdditionalReferenceType

string

The type of the additional reference associated to the marketing budget, that is, partner program or marketing source.

AllowNegativeBalanceFlag

boolean

The check box that enables fund requests and claims submission which may cause the marketing budget to go negative upon approval.

BudgetCode

string

The user-defined, unique marketing budget label.

BudgetId

long

The unique identifier for the marketing budget.
  • Primary Key

BudgetName

string

The display name for the marketing budget.

BudgetSource

string

The parent budget that is the source of the marketing budget.

BudgetTeam

MDF Budget Team

The Resources/Team associated to the Budget.

BudgetTranslation

Marketing Budget Translation Version 2

The reference to the budget translation service data object with translation information.

BudgetType

string

The type of marketing budget such as internal only or partner.

CategoryCode

string

The attribute used to enter and categorize marketing budgets.

Country

string

The name of the country.

CreatedBy

string

The user who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

Description

string

The free text description of the record.

EndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this.

ExchangeRate

decimal

The conversion rate of a marketing budget.

FundingToleranceAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total marketing budget amount multiplied by the funding tolerance percent.

GeneralLedgerAccount

string

The reference to the general ledger account where marketing budgeted funds are reserved or accounted.

InactivatedBy

string

The user who inactivated the marketing budget.

InactivatedById

long

The ID of the person who inactivated the marketing budget.

InactivationDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the marketing budget was inactivated.

InitialBudgetAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The original or starting marketing budget amount.

LastCalculatedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The last calculation date of the marketing budget check book that factors in fund requests, claims, and marketing budget entries.

LastUpdatedBy

string

The user who last updated the record.

NumberClaimsPendingApproval

decimal

The number of claims pending approval.

NumberFundRequestPendingApproval

decimal

The number of fund requests pending approval.

OverdraftThreshold

decimal

The amount in percentage that a fund request can exceed above the available marketing budget amount. By default, the value is 10%.

OwnerId

long

The internal resource responsible for the management of the marketing budget.

OwnerPartyNumber

string

Public Unique Identifier for the Resource.

PartnerCompanyNumber

string

Public Unique Identifier for the Partner.

PartnerId

long

The unique identifier of the partner.

PrimaryReferenceId

long

The primary reference is a display label for two attributes placed side by side that include a reference type and reference value. An additional string provides a hidden label for the second 'value' field.

PrimaryReferenceSourceCode

string

The primary reference for a marketing budget is a display label for two attributes placed side by side that include a reference type and reference value. When the primary reference type is marketing source code, the reference value containing the source code is stored in this attribute.

PrimaryReferenceType

string

The primary reference is a display label for two attributes placed side by side that include a reference type and reference value. An additional string provides a hidden label for the second 'value' field.

Region

string

The regions used to categorize marketing budgets by geographical area.

StartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this.

StatusCode

string

The pre-defined code used to indicate the status.

SubmitClaimsBy

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The last date a marketing budget claim is accepted for reimbursement.

SubmitFundRequestBy

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The last date a marketing budget fund request is accepted.

TotalApprovedClaimAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of approved claims for expense reimbursements against the marketing budget.

TotalApprovedRequestAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total approved fund requests for a marketing budget.

TotalAvailableBudgetAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The marketing budget amount available for fund requests and claims.

TotalBudgetAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total marketing budget amount based on the initial marketing budget plus any adjustments.

TotalClaimAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of marketing budget claims for reimbursement that are submitted, pending approval, approved, or rejected.

TotalClaimSettledAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of marketing budget claims for reimbursement that are financially settled.

TotalCreditAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount from all marketing budget accounting entries of type credit.

TotalDebitAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount from all marketing budget accounting entries of type debit.

TotalOutstandingClaimLiabilityAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of marketing budget claims for reimbursement that are approved but not settled.

TotalPendingClaimAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of claims that are submitted or pending approval.

TotalPendingFundRequestAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of fund requests that are submitted or pending approval.

TotalRejectedClaimAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of claims for reimbursement that are rejected.

TotalRejectedFundRequestAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of fund requests that are rejected.

TotalRequestedAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount from all fund requests that are submitted, pending approval, approved, or rejected.

TotalUnclaimedFundRequestAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total approved fund requests less the total approved claims.