ExpensePerDiemPoliciesexpensePerDiemPolValues
ExpensePerDiemPoliciesexpensePerDiemPolValues
Columns
| Name | Type | Description |
| ExpensePerDiemPoliciesPerDiemPolicyId [KEY] | Long | The unique identifier of the expense per diem policy record. |
| CreatedBy | String | User who created the row. |
| CreationDate | Datetime | Date and time when the row was last updated. |
| DeterminantCode | String | Code that indicates the value used for this determinant. Valid values are DAILY, ACCOM_DEDUCTION, LAST_DAY, FIRST_DAY, and so on. |
| DeterminantValue | Int | Value used for this determinant in percentage. |
| LastUpdateDate | Datetime | Date and time when the row was last updated. |
| LastUpdateLogin | String | Session login associated to the user who last updated the row. |
| LastUpdatedBy | String | Indicates the user who last updated the row. |
| LineHours | Int | Time threshold hours of a per diem rate. |
| LineMinutes | Int | Time threshold minutes of a per diem rate. |
| LineValue | Double | Percentage for role-based or time-based allowances. |
| LowerDeterminantValue | Int | Low end of the determinant threshold range. |
| LowerLineHours | Int | Lower end of the time threshold hours of a per diem rate. |
| LowerLineMinutes | Int | Lower end of the time threshold minutes of a per diem rate. |
| ObjectVersionNumber | Int | Number used to implement optimistic locking for an expense miscellaneous policy line. The number increments every time the row is updated. The value of the object version number at the start and end of a transaction are compared to detect whether another session has updated the row since it was queried. |
| PerDiemPolicyId | Long | Unique identifier of the per diem policy of this line. |
| PolicyValueId [KEY] | Long | Unique identifier of a per diem policy value line. |
| TypeOfLineCode | String | Code that identifies the type of policy rules or rates such as ROLEBASED, WEEKEND_HOLIDAY, or TIME_MODEL_STANDARD. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |