ExpenseMiscPolicies

Columns


Name	Type	Description
CreatedBy	String	User who created the row.
CreationDate	Datetime	Date and time when the row was created.
CurrencyCode	String	Currency code for miscellaneous expense policy.
CurrencyOptionCode	String	Miscellaneous expense policy defined for a single currency or for multiple currencies. Values are from the lookup EXM_CURRENCY_OPTION.
DailyLimitFlag	Bool	Indicates whether the daily amount limit of miscellaneous expenses is enforced. Valid values are Yes and No.
DaysBasedItemParentFlag	Bool	Indicates whether eligibility for miscellaneous expense reimbursement is based on number of days specified in parent line during itemization in expense entry.
Description	String	Description of miscellaneous expense policy.
DispWarningToUserFlag	Bool	Indicates whether miscellaneous expense policy warning is displayed to user.
EligibilityDays	Int	Minimum number of days before miscellaneous expense is eligible for reimbursement.
EnabledEligibilityFlag	Bool	Indicates whether a minimum number of days are required for the miscellaneous expense to be eligible for expense reimbursement.
EnabledGenderFlag	Bool	Indicates whether miscellaneous expense policy rates vary based on the gender of an employee.
EnabledLocationFlag	Bool	Indicates whether miscellaneous expense policy rates vary by location.
EnabledRoleFlag	Bool	Indicates whether miscellaneous expense policy rates vary based on employee role.
ErrorTolerance	Double	Percentage added to the miscellaneous expense policy amount limit to obtain the maximum allowable limit for expense report submission.
LastUpdateDate	Datetime	Date and time when the row was last updated
LastUpdatedBy	String	User who last updated the row.
LastUpdateLogin	String	Session login of user who last updated the row.
LocationTypeCode	String	Indicates the location type that determines miscellaneous expense policy rates. Valid values are from the lookup EXM_LOCATION_TYPE.
MiscPolicyId [KEY]	Long	The unique identifier of the miscellaneous expense policy.
PeriodDay	Int	Start date from which miscellaneous expense policy annual rate limit is counted. Values are from the lookup DAY.
PeriodMonth	String	Starting month from which miscellaneous expense policy annual rate limit is counted. Values are from the lookup MONTH.
PolicyEnforcementCode	String	Indicates the type of miscellaneous expense policy enforcement applied. Values are from the lookup EXM_POLICY_ENFORCEMENT.
PolicyName	String	Name of the miscellaneous expense policy.
PolicyRoleCode	String	Indicates the role type that determines the miscellaneous expense policy rate, such as Job, Grade, or Position. Values are from the lookup EXM_POLICY_ROLE.
PolicyViolationFlag	Bool	Indicates whether employees are warned when they submit expenses that exceed the defined miscellaneous expense policy rate limit.
PreventSubmissionFlag	Bool	Indicates whether expense report submission is prevented if a miscellaneous expense policy violation occurs.
RateTypeCode	String	Indicates the policy rate type of the miscellaneous expense policy, such as rate limit, percentage reimbursement, or percentage reimbursement with upper limit. Values are from the lookup EXM_RATE_TYPE.
SingleInstanceLimitFlag	Bool	Indicates whether miscellaneous expense policy limits are enforced by each submitted instance of the miscellaneous expense item.
StatusCode	String	Indicates the status of the miscellaneous expense policy. Values are from the lookup EXM_POLICY_STATUS.
WarningTolerance	Double	Percentage added to miscellaneous expense policy amount limit to obtain the maximum allowable limit for a policy warning violation.
YearlyLimitFlag	Bool	Indicates whether miscellaneous expense policy limits are enforced by maximum permitted annual amount. Valid values are Yes and No.
ZoneTypeCode	String	Indicates the lookup that defines zone types for the miscellaneous expense policy. Values are from the lookup EXM_ZONE_TYPE.
Status	String	Status of the miscellaneous expense policy, Valid values are Draft, Valid, Invalid, and Active.
RateType	String	Policy rate type of the miscellaneous expense policy, such as rate limit, percentage reimbursement, or percentage reimbursement with upper limit.
CurrencyOption	String	Miscellaneous expense policy defined for a single currency or for multiple currencies.
PolicyRole	String	Role type that determines the miscellaneous expense policy rate, such as Job, Grade, or Position.
LocationType	String	The type of location that determines miscellaneous expense policy rates, such as Geographical Location or Zone.
ZoneType	String	Lookup that defines zone types for the miscellaneous expense policy.
Currency	String	Currency of a miscellaneous expense policy when rates are defined in a single currency.
PolicyEnforcement	String	Type of miscellaneous expense policy enforcement applied.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Finder	String	finder

ODBC Driver for Oracle Fusion Cloud Financials

ExpenseMiscPolicies

Columns

Pseudo-Columns