ODBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ExpenseTypes

Defines and maintains various expense classifications (for example, travel, lodging), guiding users to select the correct cost category.

Columns

Name Type Description
BusinessUnit String Business unit associated with the expense type, used to categorize and allocate expenses within different organizational segments.
Category String Category to which the expense type belongs, helping to classify the type of expenses within the organization.
CategoryCode String Code that represents the category of the expense type, providing a standardized identifier for classification.
CcReceiptRequiredFlag Bool Flag indicating whether a credit card receipt is required for the expense type, enforcing documentation for credit card expenses.
CcReceiptThreshold Decimal Threshold above which a credit card receipt is required for the expense type, ensuring proper receipt collection for higher value expenses.
CreatedBy String Username of the individual who created the expense type, ensuring accountability for data entry and creation.
CreationDate Datetime Timestamp indicating when the expense type was created, providing a reference for tracking its establishment.
DefaultProjExpendType Long Default project expenditure type associated with the expense type, used to categorize project-related expenses.
Description String Detailed description of the expense type, providing context for its use and the types of expenses it governs.
DescriptionBehaviour String Defines how the description field behaves within the expense type, such as whether it is mandatory or optional.
DescriptionBehaviourCode String Code that defines the behavior of the description field for the expense type, ensuring standardized handling of descriptions.
DispRcptViolationFlag Bool Flag indicating whether a receipt violation should be displayed when receipts are missing or incorrect for the expense type.
EnableProjectsFlag Bool Flag indicating whether project tracking is enabled for the expense type, allowing expenses to be associated with specific projects.
EndDate Date End date when the expense type becomes inactive, marking the expiration of its validity period.
ExpenseTemplateId Long Unique identifier for the expense template associated with the expense type, linking the type to a specific template.
ExpenseTypeId [KEY] Long Unique identifier for the expense type, used to track and categorize individual expense items.
ItemizationBehaviour String Defines how itemization is handled for the expense type, such as whether expenses should be itemized or grouped.
ItemizationBehaviourCode String Code representing the itemization behavior, ensuring standardized handling of itemized expenses.
ItemizationOnlyFlag Bool Flag indicating whether the expense type is restricted to itemized expenses only, disallowing non-itemized entries.
LastUpdateDate Datetime Timestamp indicating the most recent update made to the expense type, helping to track changes over time.
LastUpdateLogin String Session login associated with the user who last updated the expense type, ensuring transparency for updates.
LastUpdatedBy String Username of the individual who last modified the expense type, providing accountability for changes.
LocationBehaviour String Defines how the location field behaves within the expense type, such as whether it is required or optional for expense entries.
LocationBehaviourCode String Code that defines the behavior of the location field for the expense type, ensuring consistent usage across records.
MerchantBehaviour String Defines how the merchant field is handled for the expense type, including whether it is required or optional.
MerchantBehaviourCode String Code representing the behavior of the merchant field, providing standardized rules for merchant-related data.
Name String Name of the expense type, used to identify and categorize it within the system.
NegativeRcptRequiredCode String Code that specifies whether a negative receipt is required for expenses of this type, typically used for refunds or returns.
NumberOfDaysBehaviour String Defines how the number of days field is handled for the expense type, such as whether it is calculated or manually entered.
NumberOfDaysBehaviourCode String Code representing the behavior of the number of days field for the expense type, ensuring consistent handling.
OrgId Long Unique identifier for the organization associated with the expense type, helping to track the expense type by organizational unit.
RcptRequiredProjFlag Bool Flag indicating whether receipts are required for project-related expenses under this expense type, ensuring proper documentation.
ReceiptRequiredFlag Bool Flag indicating whether receipts are required for expenses under this expense type, enforcing proper documentation standards.
ReceiptThreshold Decimal Threshold amount above which a receipt is required for the expense type, helping to enforce documentation rules for larger expenses.
StartDate Date Start date when the expense type becomes valid, marking the beginning of its applicability within the expense template.
TaxClassification String Tax classification associated with the expense type, ensuring proper tax treatment and reporting for related expenses.
TaxClassificationCode String Code representing the tax classification for the expense type, helping to categorize expenses for tax purposes.
DispRcptViolationCode String Code that specifies the violation for missing or incorrect receipts, helping to categorize and address receipt-related violations.
BindDate Date Date when the expense type is bound to a specific record or context, marking its applicability from that point onward.
BindTemplateId Long Unique identifier for the template to which the expense type is bound, ensuring the type is linked to the correct template.
Finder String Search term or identifier used to locate and filter specific expense type records within the system, aiding in efficient data retrieval.

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