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.