ExpenseTemplatesexpenseTypesitemizedExpenseTypes

Columns


Name	Type	Description
ExpenseTemplatesExpenseTemplateId [KEY]	Long	ExpenseTemplatesExpenseTemplateId of ExpenseTemplatesexpenseTypesitemizedExpenseTypes
ExpensetypesExpenseTypeId [KEY]	Long	Unique identifier of an expense type in an expense template.
ExpenseTypeParentId [KEY]	Long	Value that uniquely identifies the parent expense type of the itemized expense type.
ExpenseTypeId [KEY]	Long	Value that uniquely identifies the itemized expense type.
CreationDate	Datetime	Date when the itemized expense type was created.
CreatedBy	String	User who created the itemized expense type.
LastUpdateDate	Datetime	Date when the itemized expense type was last updated.
LastUpdatedBy	String	User who last updated the itemized expense type.
LastUpdateLogin	String	Session login that's associated with the user who last updated the itemized expense type.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。