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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Finder | String | finder |