ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines
ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines
Columns
| Name | Type | Description |
| ExpenseEntertainmentPoliciesEntertainmentPolicyId [KEY] | Long | The unique identifier of the expense entertainment policy record. |
| CreatedBy | String | User who created the row. |
| CreationDate | Datetime | Date and time when the row was created. |
| CurrencyCode | String | Currency code for entertainment expense policies with multiple currencies. |
| EndDate | Date | End date of entertainment expense policy line. |
| EntertainmentPolicyId | Long | The unique identifier of the entertainment expense policy. |
| InvalidCode | String | Indicates why an entertainment expense policy line has the invalid status. |
| 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. |
| PolicyLineId [KEY] | Long | The unique identifier of the entertainment expense policy line. |
| SingleInstanceLimit | Double | Single instance reimbursement limit for entertainment expenses. |
| StartDate | Date | Start date of the entertainment expense policy line. |
| StatusCode | String | Indicates the status of the entertainment expense policy line. Values are from the lookup EXM_POLICY_STATUS. |
| TypeOfAttendeCode | String | Indicates the type of event attendee for this entertainment policy line. Values are from the lookup EXM_ATTENDEE_TYPES. |
| YearlyLimit | Double | Annual reimbursement limit for entertainment expenses. |
| TypeOfAttende | String | Type of event attendee for this entertainment policy line. |
| Status | String | Status of the entertainment expense policy line. Valid values are draft, valid, and invalid. |
| Currency | String | Currency of an entertainment expense policy line. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |