SSIS Components for Oracle Fusion Cloud Financials

Build 25.0.9434

ExpenseEntertainmentPolicies

Establishes company rules for entertainment-related spending, including meal, event, or other hospitality expenses.

Columns

Name Type Description
AttendeeTypesFlag Bool Indicates whether the policy applies to specific types of attendees within the ExpenseEntertainmentPolicies schema. A true value means the policy includes attendee type differentiation.
CreatedBy String The identifier of the user who created the ExpenseEntertainmentPolicy record. Useful for tracking the origin of the policy in the system.
CreationDate Datetime The date and time when the ExpenseEntertainmentPolicy record was created. This helps track the timeline of policy establishment.
CurrencyCode String The currency code used for the financial transactions associated with the ExpenseEntertainmentPolicy record. Ensures the policy adheres to the appropriate currency standards.
CurrencyOptionCode String Represents the currency option selected for the ExpenseEntertainmentPolicy record. This may define a specific currency handling or exchange strategy.
Description String A detailed explanation or additional notes about the ExpenseEntertainmentPolicy record, providing context or outlining specific terms of the policy.
DispWarningToUserFlag Bool Indicates whether a warning should be displayed to the user during the execution of an operation related to the ExpenseEntertainmentPolicy record. Useful for flagging potential issues.
EmployeeAttendeeAmountCode String A code representing the amount associated with employee attendees in the ExpenseEntertainmentPolicy record. This may refer to limits or calculations specific to employee-related expenses.
EmployeeAttendeeInformationFlag Bool Indicates whether employee attendee information is included in the policy. When true, it signifies that employee details must be considered in policy compliance.
EmployerCreationFlag Bool A flag indicating whether the creation of the ExpenseEntertainmentPolicy record involves the employer's details. This can be used for employer-specific policy rules.
EmployeeRequiredAsAttendeeFlag Bool Specifies whether employees are required to be listed as attendees in certain types of expense entertainment scenarios under this policy.
EmployeeRateDeterminantFlag Bool Indicates whether the employee rate is a determining factor in calculating the allowable expenses for an event under the policy. When true, it impacts expense calculations.
EnabledRateLimitFlag Bool Indicates whether a rate limit is active under this ExpenseEntertainmentPolicy record, limiting the amount that can be spent per attendee or event.
EntertainmentPolicyId [KEY] Long The unique identifier for each ExpenseEntertainmentPolicy record, used to reference and manage policies in the database.
ErrorTolerance Decimal The allowable tolerance level for errors in financial transactions under the ExpenseEntertainmentPolicy record. This ensures that small discrepancies do not cause rejections.
IndividAttendeeAmountFlag Bool Indicates whether the amount allocated for individual attendees is flagged for special handling or review under the policy.
LastUpdateDate Datetime The date and time when the ExpenseEntertainmentPolicy record was last updated. This helps track changes and updates to the policy over time.
LastUpdatedBy String The identifier of the user who last updated the ExpenseEntertainmentPolicy record. This field is useful for auditing and tracking modifications.
LastUpdateLogin String The login identifier used when the ExpenseEntertainmentPolicy record was last updated, providing insight into the access and update history.
NonEmployeeAttendeeAddrsCode String A code representing the address information for non-employee attendees within the ExpenseEntertainmentPolicy, facilitating address-related processing.
NonEmployeeAttendeeAmountCode String A code representing the amount associated with non-employee attendees in the ExpenseEntertainmentPolicy record. Used to calculate or track expenses related to non-employees.
NonEmployeeAttendeeTypeCode String A code categorizing non-employee attendees under the policy, helping to define which attendee types the policy applies to.
NonEmployeeCreationFlag Bool Indicates whether the creation of the ExpenseEntertainmentPolicy record involves non-employee details. This flag allows the policy to account for non-employee participants.
NonEmployeeJobTitleCode String A code used to represent the job title of non-employee attendees, enabling more refined categorization and policy application based on job roles.
NonEmployeeAttendeeInformationFlag Bool Indicates whether non-employee attendee information is required or considered for the policy. This affects how non-employee data is handled during policy processing.
NonEmployeeRateDeterminantFlag Bool Indicates whether the non-employee rate affects the calculations or limitations within the ExpenseEntertainmentPolicy record, ensuring non-employee expenses are treated appropriately.
NonEmployeeRequiredAttendeeFlag Bool Specifies whether non-employees must be listed as attendees in certain types of expense entertainment events under the policy.
PeriodDay Int Represents the specific day of the period associated with the ExpenseEntertainmentPolicy record, often used in reporting and policy enforcement based on day-based periods.
PeriodMonth String Indicates the month of the period related to the ExpenseEntertainmentPolicy record. This helps define time-specific policies or limits for expenses.
PolicyEnforcementCode String A code representing the method or criteria used to enforce the rules of the ExpenseEntertainmentPolicy record. This helps track how the policy is applied in practice.
PolicyName String The name of the ExpenseEntertainmentPolicy record, providing a quick reference to identify the specific policy being used or applied.
PolicyViolationFlag Bool Indicates whether a violation of the policy has occurred during the processing of an expense. A true value signals a breach of the policy conditions.
PreventSubmissionFlag Bool Indicates whether submissions are prevented under the ExpenseEntertainmentPolicies. A true value means submissions are blocked, while false allows submission.
RateLimitTypeCode String Defines the type of rate limit applied to the ExpenseEntertainmentPolicies. This code determines the method of rate limiting, such as by amount or frequency.
SingleInstanceLimitFlag Bool Specifies whether a single limit instance is allowed under the ExpenseEntertainmentPolicies. If true, only one instance of the policy is applicable, otherwise multiple instances may apply.
StatusCode String Indicates the current status of the ExpenseEntertainmentPolicies, such as active, inactive, or pending approval.
WarningTolerance Decimal Defines the tolerance threshold for warnings related to the ExpenseEntertainmentPolicies. It represents the allowable deviation before a warning is triggered.
YearlyLimitFlag Bool Indicates whether a yearly limit is applied under the ExpenseEntertainmentPolicies. If true, the policy includes a cap for annual expenses.
Status String The status of the ExpenseEntertainmentPolicies, which could include values such as 'active', 'inactive', 'pending', or other status indicators.
CurrencyOption String Specifies the currency option used within the ExpenseEntertainmentPolicies, determining how expenses are recorded and reported (for example, USD, EUR).
PolicyEnforcement String Describes the manner in which the ExpenseEntertainmentPolicies are enforced, including potential actions like approval requirements, limits, or other controls.
EmployeeAttendeeAmount String Represents the amount designated for employee attendees under the ExpenseEntertainmentPolicies, typically detailing allowable expense amounts per employee.
NonEmployeeAttendeeType String Defines the type of non-employee attendees that are considered under the ExpenseEntertainmentPolicies, such as contractors or external guests.
NonEmployeeAttendeeAmount String Specifies the expense amount allowed for non-employee attendees under the ExpenseEntertainmentPolicies.
NonEmployeeAttendeeAddrs String Holds the addresses for non-employee attendees under the ExpenseEntertainmentPolicies, potentially useful for reporting or logistical purposes.
NonEmployeeJobTitle String Defines the job title of non-employee attendees included in the ExpenseEntertainmentPolicies, which may affect eligibility or limits.
RateLimitType String Describes the specific rate limit applied within the ExpenseEntertainmentPolicies, such as daily, monthly, or other periodic limits.
NonEmployeeCreation String Indicates the creation process for non-employee attendees within the ExpenseEntertainmentPolicies, such as a manual entry or automated system assignment.
EmployerCreation String Refers to the creation process for employer-related entities under the ExpenseEntertainmentPolicies, such as an employer’s internal tracking or approval.
NonEmployeeRequiredAttendee String Indicates whether a non-employee attendee is required for the policy to apply, providing specific rules for attendee eligibility.
EmployeeRateDeterminant String Defines the determinant for employee rates under the ExpenseEntertainmentPolicies, such as specific conditions or formulas used to calculate allowable expenses.
NonEmployeeRateDeterminant String Specifies the rate determinant for non-employee attendees under the ExpenseEntertainmentPolicies, helping calculate allowable expenses for external participants.
Currency String The primary currency used in the ExpenseEntertainmentPolicies for expense recording and reporting, ensuring consistency across transactions.
NumberOfAttendeesFlag Bool Indicates whether the number of attendees is a significant factor in the ExpenseEntertainmentPolicies, which could influence approval or limits.
NumberOfAttendeesCurrencyCode String Specifies the currency code used for the number of attendees, reflecting the currency applicable to any per-attendee expenses.
NumberOfAttendeesAmount Decimal Represents the total amount allocated based on the number of attendees, potentially used to calculate expenses or apply limits in the ExpenseEntertainmentPolicies.
Finder String Identifies the entity or process responsible for identifying or locating attendees or participants under the ExpenseEntertainmentPolicies.

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