ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines
Specifies line-level detail within entertainment policies, defining allowable amounts, categories, and exclusions.
Columns
| Name | Type | Description |
| ExpenseEntertainmentPoliciesEntertainmentPolicyId [KEY] | Long | The unique identifier for each entertainment policy in the expense entertainment policy lines, linking this record to the broader policy. |
| CreatedBy | String | The user or system that created this record in the ExpenseEntertainmentPolicies table, providing traceability for the record's creation. |
| CreationDate | Datetime | The timestamp when this record was created in the ExpenseEntertainmentPolicies table, aiding in tracking the creation timeline. |
| CurrencyCode | String | The code representing the currency used for the associated expense policy, allowing identification of the currency for policy calculations. |
| EndDate | Date | The date when the policy expires, marking the end of its validity period and the last possible date for its application. |
| EntertainmentPolicyId | Long | The unique identifier for the entertainment policy associated with this line, connecting the line to a specific policy in the system. |
| InvalidCode | String | A flag or identifier used to mark whether the expense policy line has been invalidated or contains errors. |
| LastUpdateDate | Datetime | The timestamp of the most recent update to this policy line, providing visibility into when the record was last modified. |
| LastUpdatedBy | String | The user or system that last updated this policy line, ensuring traceability of modifications made to the policy. |
| LastUpdateLogin | String | The login session identifier from which the last update was made, useful for tracking the source of changes. |
| PolicyLineId [KEY] | Long | A unique identifier for the specific line within the entertainment policy, distinguishing individual policy lines in the table. |
| SingleInstanceLimit | Decimal | The maximum allowable amount for a single instance of an expense under this entertainment policy line, typically used for per-event spending. |
| StartDate | Date | The date when the policy line becomes effective, marking the start of the period during which the policy is valid. |
| StatusCode | String | A code indicating the current status of the policy line (for example, active, expired, pending), useful for filtering and status tracking. |
| TypeOfAttendeCode | String | A code identifying the type of attendee for whom the policy applies, such as employee, guest, or other categories relevant to the policy. |
| YearlyLimit | Decimal | The maximum allowable annual amount for expenses under this policy line, typically used to enforce overall spending limits. |
| TypeOfAttende | String | A description of the type of attendee associated with the policy line, providing clarity on the eligible parties for expense reimbursement. |
| Status | String | The current status of the expense policy line (for example, active, inactive, expired), indicating whether the policy is currently in force. |
| Currency | String | The currency associated with the policy line, defining the financial unit used for all expense calculations and reimbursements. |
| Finder | String | A descriptive field that helps identify or search for specific policy lines in the system, often used for categorization or querying. |