ExpenseEntertainmentPolicies
ExpenseEntertainmentPolicies
Columns
| Name | Type | Description |
| AttendeeTypesFlag | Bool | Indicates whether attendee type is used to determine expense policy rates. Valid values are Yes and No. |
| CreatedBy | String | User who created the row. |
| CreationDate | Datetime | Date and time when the row was created. |
| CurrencyCode | String | Currency code for an entertainment expense policy when rates are defined in a single currency. |
| CurrencyOptionCode | String | Indicates the entertainment expense policy defined for a single currency or for multiple currencies. Values are from the lookup EXM_CURRENCY_OPTION. |
| Description | String | Description of the entertainment expense policy. |
| DispWarningToUserFlag | Bool | Indicates whether an entertainment expense policy warning is displayed to the user. |
| EmployeeAttendeeAmountCode | String | Code that indicates whether employee attendee amount is required, optional, or hidden. Values are from the look up EXM_FIELD_BEHAVIOUR. |
| EmployeeAttendeeInformationFlag | Bool | Indicates whether employee attendee-related fields display during entertainment expense entry. Employee attendee-related fields include Employee Name and Title. |
| EmployerCreationFlag | Bool | Indicates whether user can create nonemployee employer. Values are from the lookup EXM_YES_NO. |
| EmployeeRequiredAsAttendeeFlag | Bool | Indicates whether user needs to enter at least one employee name as attendee while creating an attendee in expense entry. |
| EmployeeRateDeterminantFlag | Bool | Indicates whether employee is used as the entertainment policy rate determinant. Values are from the lookup EXM_YES_NO. |
| EnabledRateLimitFlag | Bool | Indicates whether entertainment expense policy rate limits are enforced. |
| EntertainmentPolicyId [KEY] | Long | The unique identifier of the entertainment expense policy. |
| ErrorTolerance | Double | Percentage added to the entertainment expense policy amount limit to obtain the maximum allowable limit for expense report submission. |
| IndividAttendeeAmountFlag | Bool | Indicates whether the employee is required to enter the amount for individual event attendees. |
| 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. |
| NonEmployeeAttendeeAddrsCode | String | Code that indicates whether nonemployee employer address is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR. |
| NonEmployeeAttendeeAmountCode | String | Code that indicates whether nonemployee attendee amount is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR. |
| NonEmployeeAttendeeTypeCode | String | Code that indicates whether nonemployee attendee type is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR. |
| NonEmployeeCreationFlag | Bool | Indicates whether the user can create a nonemployee. Values are from the lookup EXM_YES_NO. |
| NonEmployeeJobTitleCode | String | Code that indicates whether nonemployee job title is required, optional, or hidden. Values are from the lookup EXM_FIELD_BEHAVIOUR. |
| NonEmployeeAttendeeInformationFlag | Bool | Indicates whether nonemployee attendee-related fields display during entertainment expense entry. Nonemployee attendee-related fields include Name, Employer, and Address. |
| NonEmployeeRateDeterminantFlag | Bool | Indicates whether nonemployee is used to determine the entertainment policy rate. Values are from the lookup EXM_YES_NO. |
| NonEmployeeRequiredAttendeeFlag | Bool | Indicates whether the user is required to enter at least one nonemployee as attendee. Values are from the lookup EXM_YES_NO. |
| PeriodDay | Int | Start date from which entertainment expense policy annual rate limit is counted. Values are from the lookup DAY. |
| PeriodMonth | String | Starting month from which entertainment expense policy annual rate limit is counted. Values are from the lookup MONTH. |
| PolicyEnforcementCode | String | Indicates the type of entertainment expense policy enforcement applied. Values are from the lookup ORA_EXM_ENTERT_POL_ENFORCEM. |
| PolicyName | String | Name of the entertainment expense policy. |
| PolicyViolationFlag | Bool | Indicates whether employees are warned when they submit expenses that exceed the defined entertainment expense policy rate limit. |
| PreventSubmissionFlag | Bool | Indicates whether expense report submission is prevented if an entertainment expense policy violation occurs. |
| RateLimitTypeCode | String | Code that indicates whether policy rate limit is defined per expense type or per attendee. Values are from the lookup ORA_EXM_LIMIT_TYPE. |
| SingleInstanceLimitFlag | Bool | Indicates whether entertainment expense policy limits are enforced by each submitted instance of an entertainment expense item. |
| StatusCode | String | Indicates the status of entertainment expense policy. Values are from lookup EXM_POLICY_STATUS. |
| WarningTolerance | Double | Percentage added to entertainment expense policy amount limit to obtain the maximum allowable limit for a policy warning violation. |
| YearlyLimitFlag | Bool | Indicates whether entertainment expense policy limits are enforced by maximum permitted annual amount. Valid values are Yes and No. |
| Status | String | Status of entertainment expense policy. Valid values are Draft, Valid, Invalid, and Active. |
| CurrencyOption | String | Entertainment expense policy defined for a single currency or for multiple currencies. |
| PolicyEnforcement | String | Type of entertainment expense policy enforcement applied. |
| EmployeeAttendeeAmount | String | Indicates whether employee attendee amount is required, optional, or hidden. |
| NonEmployeeAttendeeType | String | Indicates whether nonemployee attendee type is required, optional, or hidden. |
| NonEmployeeAttendeeAmount | String | Indicates whether nonemployee attendee amount is required, optional, or hidden. |
| NonEmployeeAttendeeAddrs | String | Indicates whether nonemployee employer address is required, optional, or hidden. |
| NonEmployeeJobTitle | String | Indicates whether nonemployee job title is required, optional, or hidden. |
| RateLimitType | String | Indicates whether policy rate limit is defined per expense type or per attendee. |
| NonEmployeeCreation | String | Indicates whether the user can create a nonemployee. |
| EmployerCreation | String | Indicates whether user can create nonemployee employer. |
| NonEmployeeRequiredAttendee | String | Indicates whether the user is required to enter at least one nonemployee as attendee. |
| EmployeeRateDeterminant | String | Indicates whether employee is used as the entertainment policy rate determinant. |
| NonEmployeeRateDeterminant | String | Indicates whether nonemployee is used as the entertainment policy rate determinant. |
| Currency | String | Currency of an entertainment expense policy when rates are defined in a single currency. |
| NumberOfAttendeesFlag | Bool | Indicates whether capturing the number of attendees is mandatory. |
| NumberOfAttendeesCurrencyCode | String | Currency code for the amount above which capturing the number of attendees is mandatory. |
| NumberOfAttendeesAmount | Double | Amount above which capturing the number of attendees is mandatory. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |