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.