Expense Templates
The Expense Templates view objects contains sets of expense types grouped for specific purposes by business unit, such as education, travel, relocation, and so on.
Data store key : FscmTopModelAM.FinExtractAM.ExmBiccExtractAM.ExpenseTemplateExtractPVO
Primary Keys : ExpenseTemplateId
Initial Extract Date : ExpenseTemplateCreationDate
Incremental Extract Date : ExpenseTemplateLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
ExpenseTemplateAllowRcptMissingFlag | Indicates whether users can mark that receipts are missing when they submit their expense report. |
ExpenseTemplateCashReceiptReqFlag | Indicates whether receipts are required for cash expense lines above a specified amount. |
ExpenseTemplateCashReceiptReqLimit | The amount above which a cash expense requires a receipt. |
ExpenseTemplateCcReceiptReqFlag | Indicates whether receipts are required for corporate card expense lines above a specified limit. |
ExpenseTemplateCcReceiptReqLimit | The amount above which a corporate card expense requires a receipt. |
ExpenseTemplateCreatedBy | The user who created the expense report template. |
ExpenseTemplateCreationDate | The date and time when the expense report template was created. |
ExpenseTemplateDescription | The description of the expense report template. |
ExpenseTemplateDfltCcExpTypeId | The identifier of the expense type assigned to a credit card transaction if the expense type mapping is not defined. |
ExpenseTemplateDispRcptViolationFlag | Indicates whether the receipt missing policy warning is displayed to the user. |
ExpenseTemplateEnableCcMappingFlag | Indicates whether the lookup codes from the charge file are associated with the company's expense types. |
ExpenseTemplateId | The unique identifier of the expense report template. |
ExpenseTemplateInactiveDate | The date from which the expense type can no longer be used. |
ExpenseTemplateLastUpdateDate | The date and time when the expense report template row was last updated. |
ExpenseTemplateLastUpdateLogin | The session login associated with the user who last updated the expense report template. |
ExpenseTemplateLastUpdatedBy | The user who last updated the expense report template row. |
ExpenseTemplateName | The name of the expense report template. |
ExpenseTemplateNegativeRcptReqFlag | Indicates whether receipt requirement rules are applied to negative expense lines. |
ExpenseTemplateObjectVersionNumber | The number of times the expense report template row has been updated. |
ExpenseTemplateOrgId | The identifier of the business unit associated with the expense report template. |
ExpenseTemplateStartDate | The date from which the expense type is available for use in expense reports. |