ExpenseTemplatesexpenseTypes

Columns


Name	Type	Description
ExpenseTemplatesExpenseTemplateId [KEY]	Long	ExpenseTemplatesExpenseTemplateId of ExpenseTemplatesexpenseTypes
BusinessUnit	String	Name of a person's business unit.
Category	String	Expense category assigned to an expense item.
CategoryCode	String	Code associated with an expense category.
CcReceiptRequiredFlag	Bool	Indicates whether receipts are required for corporate card expenses above a specified limit.
CcReceiptThreshold	Double	Amount limit, above which a corporate card expense requires a receipt.
CreatedBy	String	User who created an expense type.
CreationDate	Datetime	Date when the expense type was created.
DefaultProjExpendType	Long	Project expenditure type that's assigned to an expense type that hasn't been set up at the project level.
Description	String	Description of the expense type.
DescriptionBehaviour	String	Behavior of the expense item Description field, which is defined at the expense type level.
DescriptionBehaviourCode	String	Code that's associated with the description behavior.
DispRcptViolationFlag	Bool	Indicates whether a missing receipt policy warning is displayed to the user.
EnableProjectsFlag	Bool	Indicates whether an expense type can be used to charge project expenses.
EndDate	Date	Date when the expense template can no longer be used.
ExpenseTemplateId	Long	Value that uniquely identifies an expense template that contains expense types.
ExpenseTypeId [KEY]	Long	Value that uniquely identifies an expense type in an expense template.
ItemizationBehaviour	String	Behavior of an itemized expense type, whether disabled, enabled, or required.
ItemizationBehaviourCode	String	Code that's associated with the itemization behavior.
ItemizationOnlyFlag	Bool	Indicates whether an expense type is only used to itemize.
LastUpdateDate	Datetime	Date when the expense type was last updated.
LastUpdateLogin	String	Session login that's associated with the user who last updated the expense type.
LastUpdatedBy	String	User who last updated the expense type.
LocationBehaviour	String	Behavior of the Expense Location field, which is defined at the expense type level.
LocationBehaviourCode	String	Code that's associated with the expense location behavior.
MerchantBehaviour	String	Behavior of the Merchant field, which is defined at the expense type level.
MerchantBehaviourCode	String	Code that's associated with the merchant behavior.
Name	String	Name of the expense type as appears in the expense report.
NegativeRcptRequiredCode	String	Code that's associated with receipt requirement rules that are applied to negative expense lines.
NumberOfDaysBehaviour	String	Behavior of the Number of Days field, which is defined at the expense type level.
NumberOfDaysBehaviourCode	String	Code that's associated with the number of days behavior.
OrgId	Long	Value that uniquely identifies the business unit associated with the row.
RcptRequiredProjFlag	Bool	Indicates whether a receipt is required for a project-enabled expense type.
ReceiptRequiredFlag	Bool	Indicates whether receipts are required for cash expenses above a specified amount.
ReceiptThreshold	Double	Amount limit, above which a cash expense requires a receipt.
StartDate	Date	Date when the expense template is available for use in expense reports.
TaxClassification	String	Default tax code that's assigned to an expense item.
TaxClassificationCode	String	Code that's associated with a tax classification.
DispRcptViolationCode	String	Indicates whether a missing receipt policy warning is displayed to the user.

Pseudo-Columns

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


Name	Type	Description
BindDate	Date	bindDate
BindOrgId	Long	bindOrgId
Finder	String	finder

ODBC Driver for Oracle Fusion Cloud Financials

ExpenseTemplatesexpenseTypes

Columns

Pseudo-Columns