JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

ExpenseTemplates

The expense templates resource is used to group sets of expense types by business unit for purposes such as Education, Travel, and Relocation.

Columns

Name Type Description
ExpenseTemplateId [KEY] Long ExpenseTemplateId of ExpenseTemplates
OrgId Long OrgId of ExpenseTemplates
BusinessUnit String BusinessUnit of ExpenseTemplates
Name String Name of ExpenseTemplates
Description String Description of ExpenseTemplates
StartDate Date StartDate of ExpenseTemplates
InactiveDate Date InactiveDate of ExpenseTemplates
DfltCcExpTypeId Long DfltCcExpTypeId of ExpenseTemplates
EnableCcMappingFlag Bool EnableCcMappingFlag of ExpenseTemplates
CreationDate Datetime CreationDate of ExpenseTemplates
CreatedBy String CreatedBy of ExpenseTemplates
LastUpdateDate Datetime LastUpdateDate of ExpenseTemplates
LastUpdatedBy String LastUpdatedBy of ExpenseTemplates
LastUpdateLogin String LastUpdateLogin of ExpenseTemplates
CashReceiptRequiredFlag Bool CashReceiptRequiredFlag of ExpenseTemplates
CashReceiptRequiredLimit Decimal CashReceiptRequiredLimit of ExpenseTemplates
CcReceiptRequiredFlag Bool CcReceiptRequiredFlag of ExpenseTemplates
CcReceiptRequiredLimit Decimal CcReceiptRequiredLimit of ExpenseTemplates
NegativeRcptRequiredFlag Bool NegativeRcptRequiredFlag of ExpenseTemplates
AllowRcptMissingFlag Bool AllowRcptMissingFlag of ExpenseTemplates
DispRcptViolationFlag Bool DispRcptViolationFlag of ExpenseTemplates
DescriptionBehaviourCode String DescriptionBehaviourCode of ExpenseTemplates
DescriptionBehaviour String DescriptionBehaviour of ExpenseTemplates
LocationBehaviourCode String LocationBehaviourCode of ExpenseTemplates
LocationBehaviour String LocationBehaviour of ExpenseTemplates
NumberOfDaysBehaviourCode String NumberOfDaysBehaviourCode of ExpenseTemplates
NumberOfDaysBehaviour String NumberOfDaysBehaviour of ExpenseTemplates
MerchantBehaviourCode String MerchantBehaviourCode of ExpenseTemplates
MerchantBehaviour String MerchantBehaviour of ExpenseTemplates
BindDate Date BindDate of ExpenseTemplates
BindOrgId Long BindOrgId of ExpenseTemplates
Finder String Finder of ExpenseTemplates

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062