ExpenseTypes
ExpenseTypes
Columns
| Name | Type | Description |
| BusinessUnit | String | Name of a person's business unit. |
| Category | String | Expense category assigned to an expense item. |
| CategoryCode | String | Code associated with an expense category. |
| CcReceiptRequiredFlag | Bool | Indicates whether receipts are required for corporate card expenses above a specified limit. |
| CcReceiptThreshold | Double | Amount limit, above which a corporate card expense requires a receipt. |
| CreatedBy | String | User who created an expense type. |
| CreationDate | Datetime | Date when the expense type was created. |
| DefaultProjExpendType | Long | Project expenditure type that's assigned to an expense type that hasn't been set up at the project level. |
| Description | String | Description of the expense type. |
| DescriptionBehaviour | String | Behavior of the expense item Description field, which is defined at the expense type level. |
| DescriptionBehaviourCode | String | Code that's associated with the description behavior. |
| DispRcptViolationFlag | Bool | Indicates whether a missing receipt policy warning is displayed to the user. |
| EnableProjectsFlag | Bool | Indicates whether an expense type can be used to charge project expenses. |
| EndDate | Date | Date when the expense template can no longer be used. |
| ExpenseTemplateId | Long | Value that uniquely identifies an expense template that contains expense types. |
| ExpenseTypeId [KEY] | Long | Value that uniquely identifies an expense type in an expense template. |
| ItemizationBehaviour | String | Behavior of an itemized expense type, whether disabled, enabled, or required. |
| ItemizationBehaviourCode | String | Code that's associated with the itemization behavior. |
| ItemizationOnlyFlag | Bool | Indicates whether an expense type is only used to itemize. |
| LastUpdateDate | Datetime | Date when the expense type was last updated. |
| LastUpdateLogin | String | Session login that's associated with the user who last updated the expense type. |
| LastUpdatedBy | String | User who last updated the expense type. |
| LocationBehaviour | String | Behavior of the Expense Location field, which is defined at the expense type level. |
| LocationBehaviourCode | String | Code that's associated with the expense location behavior. |
| MerchantBehaviour | String | Behavior of the Merchant field, which is defined at the expense type level. |
| MerchantBehaviourCode | String | Code that's associated with the merchant behavior. |
| Name | String | Name of the expense type as appears in the expense report. |
| NegativeRcptRequiredCode | String | Code that's associated with receipt requirement rules that are applied to negative expense lines. |
| NumberOfDaysBehaviour | String | Behavior of the Number of Days field, which is defined at the expense type level. |
| NumberOfDaysBehaviourCode | String | Code that's associated with the number of days behavior. |
| OrgId | Long | Value that uniquely identifies the business unit associated with the row. |
| RcptRequiredProjFlag | Bool | Indicates whether a receipt is required for a project-enabled expense type. |
| ReceiptRequiredFlag | Bool | Indicates whether receipts are required for cash expenses above a specified amount. |
| ReceiptThreshold | Double | Amount limit, above which a cash expense requires a receipt. |
| StartDate | Date | Date when the expense template is available for use in expense reports. |
| TaxClassification | String | Default tax code that's assigned to an expense item. |
| TaxClassificationCode | String | Code that's associated with a tax classification. |
| DispRcptViolationCode | String | Indicates whether a missing receipt policy warning is displayed to the user. |
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 |
| BindDate | Date | bindDate |
| BindTemplateId | Long | bindTemplateId |
| Finder | String | finder |