Marketing Budget

The marketing budget contains details pertaining to monetary incentives for partners to execute marketing activities.

QName: {http://xmlns.oracle.com/oracle/apps/marketing/commonMarketing/budgets/budgetPublicService/}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

Marketing Budget Translation

Handled by

Marketing Budget Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

ActivatedBy

string

The user 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.

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 budget to go negative upon approval.

BudgetCode

string

The code used to uniquely identify the marketing budget.

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.

BudgetTranslation

Marketing Budget Translation

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

BudgetType

string

The type of budget such as internal only or partner.

CategoryCode

string

The attribute used to enter and categorize marketing budgets.

ConversionCurrencyCode

string

The currency code of the currency being converted to.

ConversionExchangeRate

decimal

The exchange rate of the currency being converted to.

ConversionRateType

string

The currency conversion rate type that is used to derive the exchange rate for converting the user-entered currency to CRM Corporate currency.

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 budgeted funds are reserved or accounted.

InactivatedBy

string

The user who inactivated the 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 budget check book that factors in fund requests, claims, and budget entries.

LastUpdateDate

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

The date when the record was last updated.

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.

OrgId

long

The internal marketing organization that utilizes the budgeted funds.

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.

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.

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 budget amount available for fund requests and claims.

TotalBudgetAmount

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

The total budget amount based on the initial 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 budget accounting entries of type credit.

TotalDebitAmount

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

The total amount from all 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.