Expense Types

The Expense Types view object contains information of expense types that are defined for an expense report template and the associated corporate policies.

Data store key : FscmTopModelAM.FinExtractAM.ExmBiccExtractAM.ExpenseTypeExtractPVO

Primary Keys : ExpenseTypeId

Initial Extract Date : ExpenseTypeCreationDate

Incremental Extract Date : ExpenseTypeLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ExpenseTypeCategoryCode	The code that identifies the expense category assigned to the expense item.
ExpenseTypeCcReceiptRequiredFlag	Indicates whether receipts are required for corporate card expense lines above a specified limit.
ExpenseTypeCcReceiptThreshold	The amount above which a corporate card expense requires a receipt.
ExpenseTypeCodeCombinationId	The identifier of the general ledger account that accounts for the expense type.
ExpenseTypeCreatedBy	The user who created the expense type row.
ExpenseTypeCreationDate	The date and time when the expense type was created.
ExpenseTypeDefaultProjExpendType	The project expenditure type assigned to an expense type that is not set up at the project level.
ExpenseTypeDescription	Indicates whether the receipt missing policy warning is displayed to the user.
ExpenseTypeDispRcptViolationFlag	Indicates whether the receipt missing policy warning is displayed to the user.
ExpenseTypeEnableProjectsFlag	Indicates whether the expense type can be used to charge project expenses.
ExpenseTypeEndDate	The date from which the expense template can no longer be used.
ExpenseTypeId	The unique identifier of the expense type in an expense template.
ExpenseTypeItemizationBehaviourCode	The code that identifies whether itemization is disabled, enabled, or required for the expense type.
ExpenseTypeItemizationOnlyFlag	Indicates whether the expense type is used only in itemization.
ExpenseTypeLastUpdateDate	The date and time when the expense type row was last updated.
ExpenseTypeLastUpdateLogin	The session login associated with the user who last updated the expense type.
ExpenseTypeLastUpdatedBy	The user who last updated the expense type row.
ExpenseTypeName	The name of the expense type as it appears in the expense report.
ExpenseTypeNegativeRcptReqCode	The code that identifies whether receipt requirement rules are applied to negative expense lines.
ExpenseTypeObjectVersionNumber	The number of times the expense type row has been updated.
ExpenseTypeOrgId	The identifier of the business unit associated with the expense type.
ExpenseTypeRcptRequiredProjFlag	Indicates whether a receipt is required for the project-enabled expense type.
ExpenseTypeReceiptRequiredFlag	Indicates whether receipts are required for cash expense lines above a specified amount.
ExpenseTypeReceiptThreshold	The amount above which a cash expense requires a receipt.
ExpenseTypeSegment1	A segment for the Expense Type key flexfield.
ExpenseTypeSegment10	A segment for the Expense Type key flexfield.
ExpenseTypeSegment11	A segment for the Expense Type key flexfield.
ExpenseTypeSegment12	A segment for the Expense Type key flexfield.
ExpenseTypeSegment13	A segment for the Expense Type key flexfield.
ExpenseTypeSegment14	A segment for the Expense Type key flexfield.
ExpenseTypeSegment15	A segment for the Expense Type key flexfield.
ExpenseTypeSegment16	A segment for the Expense Type key flexfield.
ExpenseTypeSegment17	A segment for the Expense Type key flexfield.
ExpenseTypeSegment18	A segment for the Expense Type key flexfield.
ExpenseTypeSegment19	A segment for the Expense Type key flexfield.
ExpenseTypeSegment2	A segment for the Expense Type key flexfield.
ExpenseTypeSegment20	A segment for the Expense Type key flexfield.
ExpenseTypeSegment21	A segment for the Expense Type key flexfield.
ExpenseTypeSegment22	A segment for the Expense Type key flexfield.
ExpenseTypeSegment23	A segment for the Expense Type key flexfield.
ExpenseTypeSegment24	A segment for the Expense Type key flexfield.
ExpenseTypeSegment25	A segment for the Expense Type key flexfield.
ExpenseTypeSegment26	A segment for the Expense Type key flexfield.
ExpenseTypeSegment27	A segment for the Expense Type key flexfield.
ExpenseTypeSegment28	A segment for the Expense Type key flexfield.
ExpenseTypeSegment29	A segment for the Expense Type key flexfield.
ExpenseTypeSegment3	A segment for the Expense Type key flexfield.
ExpenseTypeSegment30	A segment for the Expense Type key flexfield.
ExpenseTypeSegment4	A segment for the Expense Type key flexfield.
ExpenseTypeSegment5	A segment for the Expense Type key flexfield.
ExpenseTypeSegment6	A segment for the Expense Type key flexfield.
ExpenseTypeSegment7	A segment for the Expense Type key flexfield.
ExpenseTypeSegment8	A segment for the Expense Type key flexfield.
ExpenseTypeSegment9	A segment for the Expense Type key flexfield.
ExpenseTypeStartDate	The date from which the expense template is available for use in expense reports.
ExpenseTypeTaxClassificationCode	The code that identifies the default tax assigned to the expense item.
ExpenseTypeTemplateId	The identifier of the expense template that contains the expense type.