Excel Add-In for Oracle Fusion Cloud Financials

Build 25.0.9434

ExpenseTemplatesmobileExpenseTypes

Manages expense types specifically enabled for mobile entry, supporting on-the-go expense capture and policy adherence.

Columns

Name Type Description
ExpenseTemplatesExpenseTemplateId [KEY] Long Unique identifier for the expense template in the ExpenseTemplatesmobileExpenseTypes table, linking the mobile expense types to specific templates.
PersonId Long Unique identifier for the person associated with the mobile expense type, linking the expense type to a specific individual.
BUId Long Business unit identifier associated with the mobile expense type, used to categorize expenses within different organizational units.
ExpenseTemplateId Long Unique identifier for the expense template applied to the mobile expense type, helping to associate the expense type with its template.
ExpenseTypeId [KEY] Long Unique identifier for the expense type within the mobile expense type template, used to categorize and track specific types of expenses.
ExpenseTypeName String Name of the expense type within the mobile expense template, providing a label for the category of expenses.
StartDate Date Start date when the mobile expense type becomes valid, marking the beginning of its applicability within the expense template.
EndDate Date End date when the mobile expense type becomes inactive, signifying the end of its validity.
ExpenseCategoryCode String Code representing the category of the mobile expense type, used to classify and manage different expense categories.
ExpenseCategory String Description of the category to which the mobile expense type belongs, helping to categorize expenses for reporting and analysis.
ReceiptRequiredCode String Code indicating whether a receipt is required for the mobile expense type, used to enforce documentation rules.
ReceiptRequiredFlag Bool Flag indicating whether receipts are mandatory for expenses under this template, ensuring proper documentation.
ProjectReceiptRequiredFlag Bool Flag indicating whether receipts are required for project-related expenses under this template, ensuring compliance with project documentation policies.
JustificationAmount Decimal Amount that requires justification within the mobile expense type, typically used for expenses that exceed certain thresholds or need additional approval.
ReceiptThresholdAmount Decimal Amount above which a receipt is required for the mobile expense type, used to enforce limits for reimbursable expenses.
CurrencyCode String Currency code for the mobile expense type, specifying the currency used for the expense amounts.
Currency String Currency used for the mobile expense type, providing context for the expenses and ensuring proper exchange rates are applied if needed.
EnableProjectsFlag Bool Flag indicating whether project tracking is enabled for the mobile expense type, allowing expenses to be linked to specific projects.
CodeCombinationId Long Unique identifier for the accounting code combination associated with the mobile expense type, used for financial categorization.
ItemizationOnlyFlag Bool Flag indicating whether the expense type can only be used for itemized expenses, restricting the template to only allow itemized entries.
ItemizationBehaviourCode String Code specifying the behavior of itemization for the mobile expense type, such as whether itemization is mandatory or optional.
ItemizationBehaviour String Description of how itemization should be handled within the mobile expense type, providing guidelines for users to follow when itemizing expenses.
TopLevelExpenseTypeFlag Bool Flag indicating whether the expense type is a top-level category, typically used for categorizing major expense types.
TaxClassificationCode String Code representing the tax classification that applies to the mobile expense type, ensuring proper tax treatment for the expenses.
TaxClassification String Description of the tax classification associated with the mobile expense type, used for compliance with tax regulations.
BindDate Date Date when the mobile expense type is bound to a specific record or context, ensuring it is applied from that point onward.
BindOrgId Long Unique identifier for the organization associated with the mobile expense type, ensuring the expense type is tied to the correct organizational unit.
Finder String Search term or identifier used to locate and filter specific mobile expense type records within the system, aiding in efficient data retrieval.

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