ExpenseMiscPoliciesexpenseMiscPolicyLines
ExpenseMiscPoliciesexpenseMiscPolicyLines
Columns
| Name | Type | Description |
| ExpenseMiscPoliciesMiscPolicyId [KEY] | Long | The unique identifier of the expense miscellaneous policy record. |
| CreatedBy | String | User who created the row. |
| CreationDate | Datetime | Date and time when the row was created. |
| CurrencyCode | String | Currency code of a miscellaneous expense policy line. |
| DailyLimit | Double | Daily reimbursement limit for miscellaneous expenses. |
| EndDate | Date | Date from which the miscellaneous expense policy rate is no longer applicable. |
| GenderCode | String | Gender code for the miscellaneous expense policy. |
| GeographyId | Long | The unique identifier of the geography for which the miscellaneous expense policy rate is applicable. |
| GeolocName | String | Geographical location for which the miscellaneous expense policy rate is applicable. |
| InvalidCode | String | Indicates why the miscellaneous 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. |
| MiscPolicyId | Long | The unique identifier of the miscellaneous expense policy. |
| PolicyLineId [KEY] | Long | The unique identifier of the miscellaneous expense policy line. |
| RawCity | String | City for which the miscellaneous expense policy rate is applicable. |
| RawCountry | String | Country for which the miscellaneous expense policy rate is applicable. |
| RawCounty | String | County for which the miscellaneous expense policy rate is applicable. |
| RawState | String | State for which the miscellaneous expense policy rate is applicable. |
| ReimbursementPercentage | Double | Percentage of the expense amount that's reimbursed when the submitted expense amount exceeds the limit and the rate type is percentage reimbursement or percentage reimbursement with upper limit. |
| RoleId | Long | The unique identifier of the role for which the miscellaneous expense policy rate is applicable. |
| RoleName | String | Role name for which the miscellaneous expense policy rate is applicable, such as Director or Engineer. |
| SingleInstanceLimit | Double | Indicates whether miscellaneous expense policy limits are enforced by each submitted instance of a miscellaneous expense item. |
| StartDate | Date | Date from which the miscellaneous expense policy rate is applicable. |
| StatusCode | String | Indicates the status of the miscellaneous expense policy line. Values are from the lookup EXM_POLICY_STATUS. |
| TypeOfRateCode | String | Type of rate line, such as base miscellaneous rate or catch all. |
| YearlyLimit | Double | Annual reimbursement limit for miscellaneous expenses. |
| ZoneCode | String | Zone code for which the miscellaneous expense policy rate is applicable, such as geographical locations or zones. |
| Status | String | Status of the miscellaneous expense policy line. Valid values are Draft, Valid, Invalid, and Active. |
| Currency | String | Currency of a miscellaneous expense policy line. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |