ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData ODBC Driver for Oracle Fusion Cloud Financials ビュー
Name | Description |
AccountCombinationsLOV | AccountCombinationsLOV |
AccountCombinationsShorthandAliasesLOV | AccountCombinationsShorthandAliasesLOV |
AccountingCalendarsLOV | AccountingCalendarsLOV |
AccountingPeriodsLOV | AccountingPeriodsLOV |
AccountingPeriodStatusLOV | AccountingPeriodStatusLOV |
BankAccountUserRules | BankAccountUserRules |
BudgetaryControlResults | BudgetaryControlResults |
BudgetaryControlResultsBudgetImpacts | BudgetaryControlResultsBudgetImpacts |
BudgetaryControlResultsBudgetTransactions | BudgetaryControlResultsBudgetTransactions |
ChartOfAccountsLOV | ChartOfAccountsLOV |
CurrencyConversionTypesLOV | CurrencyConversionTypesLOV |
CurrencyRates | CurrencyRates |
DisbursementPaymentMethodsLOV | DisbursementPaymentMethodsLOV |
ErpBusinessEvents | ErpBusinessEvents |
Erpintegrations | This view will return maximum of 500 records. The view is deprecated. |
ExpenseAccommodationsPolicies | ExpenseAccommodationsPolicies |
ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines | ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
ExpenseAirfarePolicies | ExpenseAirfarePolicies |
ExpenseAirfarePoliciesexpenseAirfarePolicyLines | ExpenseAirfarePoliciesexpenseAirfarePolicyLines |
ExpenseCashAdvances | ExpenseCashAdvances |
ExpenseCashAdvancesAttachments | ExpenseCashAdvancesAttachments |
ExpenseCashAdvancesCashAdvanceDff | ExpenseCashAdvancesCashAdvanceDff |
ExpenseConversionRateOptions | ExpenseConversionRateOptions |
ExpenseConversionRateOptionsconversionRateTolerances | ExpenseConversionRateOptionsconversionRateTolerances |
ExpenseCreditCardTransactions | ExpenseCreditCardTransactions |
ExpenseDelegations | ExpenseDelegations |
ExpenseDffContexts | ExpenseDffContexts |
ExpenseDffSegments | ExpenseDffSegments |
ExpenseDistributions | ExpenseDistributions |
ExpenseDistributionsPJCDFF | ExpenseDistributionsPJCDFF |
ExpenseEntertainmentPolicies | ExpenseEntertainmentPolicies |
ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines | ExpenseEntertainmentPoliciesexpenseEntertainmentPolicyLines |
ExpenseLocations | ExpenseLocations |
ExpenseMealsPolicies | ExpenseMealsPolicies |
ExpenseMealsPoliciesexpenseMealsPolicyLines | ExpenseMealsPoliciesexpenseMealsPolicyLines |
ExpenseMileagePolicies | ExpenseMileagePolicies |
ExpenseMileagePoliciesexpenseMileagePolicyLines | ExpenseMileagePoliciesexpenseMileagePolicyLines |
ExpenseMiscPolicies | ExpenseMiscPolicies |
ExpenseMiscPoliciesexpenseMiscPolicyLines | ExpenseMiscPoliciesexpenseMiscPolicyLines |
ExpenseOrganizationSettings | ExpenseOrganizationSettings |
ExpensePerDiemCalculations | ExpensePerDiemCalculations |
ExpensePerDiemPolicies | ExpensePerDiemPolicies |
ExpensePerDiemPoliciesexpensePerDiemPolLines | ExpensePerDiemPoliciesexpensePerDiemPolLines |
ExpensePerDiemPoliciesexpensePerDiemPolValues | ExpensePerDiemPoliciesexpensePerDiemPolValues |
ExpensePersons | ExpensePersons |
ExpensePreferences | ExpensePreferences |
ExpensePreferredTypes | ExpensePreferredTypes |
ExpenseProfileAttributes | ExpenseProfileAttributes |
ExpenseReports | ExpenseReports |
ExpenseReportsAttachments | ExpenseReportsAttachments |
ExpenseReportsExpense | ExpenseReportsExpense |
ExpenseReportsExpenseAttachments | ExpenseReportsExpenseAttachments |
ExpenseReportsExpenseduplicateExpenses | ExpenseReportsExpenseduplicateExpenses |
ExpenseReportsExpenseExpenseAttendee | ExpenseReportsExpenseExpenseAttendee |
ExpenseReportsExpenseExpenseDff | ExpenseReportsExpenseExpenseDff |
ExpenseReportsExpenseExpenseDistribution | ExpenseReportsExpenseExpenseDistribution |
ExpenseReportsExpenseExpenseDistributionPJCDFF | ExpenseReportsExpenseExpenseDistributionPJCDFF |
ExpenseReportsExpenseexpenseErrors | ExpenseReportsExpenseexpenseErrors |
ExpenseReportsExpenseExpenseItemization | ExpenseReportsExpenseExpenseItemization |
ExpenseReportsExpensematchedExpenses | ExpenseReportsExpensematchedExpenses |
ExpenseReportsexpenseNotes | ExpenseReportsexpenseNotes |
ExpenseReportsExpensePayment | ExpenseReportsExpensePayment |
ExpenseReportsExpenseReportDff | ExpenseReportsExpenseReportDff |
ExpenseReportsprocessingDetails | ExpenseReportsprocessingDetails |
Expenses | Expenses |
ExpensesAttachments | ExpensesAttachments |
ExpensesduplicateExpenses | ExpensesduplicateExpenses |
ExpenseSetupOptions | ExpenseSetupOptions |
ExpensesExpenseAttendee | ExpensesExpenseAttendee |
ExpensesExpenseDff | ExpensesExpenseDff |
ExpensesExpenseDistribution | ExpensesExpenseDistribution |
ExpensesExpenseDistributionPJCDFF | ExpensesExpenseDistributionPJCDFF |
ExpensesexpenseErrors | ExpensesexpenseErrors |
ExpensesExpenseItemization | ExpensesExpenseItemization |
ExpensesmatchedExpenses | ExpensesmatchedExpenses |
ExpenseTemplates | ExpenseTemplates |
ExpenseTemplatesexpenseTypes | ExpenseTemplatesexpenseTypes |
ExpenseTemplatesexpenseTypesitemizedExpenseTypes | ExpenseTemplatesexpenseTypesitemizedExpenseTypes |
ExpenseTemplatesexpenseTypespreferredAgencyLists | ExpenseTemplatesexpenseTypespreferredAgencyLists |
ExpenseTemplatesexpenseTypespreferredMerchantLists | ExpenseTemplatesexpenseTypespreferredMerchantLists |
ExpenseTemplatesmobileExpenseTypes | ExpenseTemplatesmobileExpenseTypes |
ExpenseTypes | ExpenseTypes |
ExpenseTypesitemizedExpenseTypes | ExpenseTypesitemizedExpenseTypes |
ExpenseTypespreferredAgencyLists | ExpenseTypespreferredAgencyLists |
ExpenseTypespreferredMerchantLists | ExpenseTypespreferredMerchantLists |
ExternalBankAccounts | ExternalBankAccounts |
ExternalBankAccountsaccountOwners | ExternalBankAccountsaccountOwners |
FinBusinessUnitsLOV | FinBusinessUnitsLOV |
InstrumentAssignments | InstrumentAssignments |
IntercompanyOrganizationsLOV | IntercompanyOrganizationsLOV |
IntercompanyTransactionTypesLOV | IntercompanyTransactionTypesLOV |
InterimDocumentsPayables | InterimDocumentsPayables |
Invoices | Invoices |
InvoicesappliedPrepayments | InvoicesappliedPrepayments |
Invoicesattachments | Invoicesattachments |
InvoicesavailablePrepayments | InvoicesavailablePrepayments |
InvoicesinvoiceDff | InvoicesinvoiceDff |
InvoicesinvoiceGdf | InvoicesinvoiceGdf |
InvoicesinvoiceInstallments | InvoicesinvoiceInstallments |
InvoicesinvoiceInstallmentsinvoiceInstallmentDff | InvoicesinvoiceInstallmentsinvoiceInstallmentDff |
InvoicesinvoiceInstallmentsinvoiceInstallmentGdf | InvoicesinvoiceInstallmentsinvoiceInstallmentGdf |
InvoicesinvoiceLines | InvoicesinvoiceLines |
InvoicesinvoiceLinesinvoiceDistributions | InvoicesinvoiceLinesinvoiceDistributions |
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff |
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf |
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff |
InvoicesinvoiceLinesinvoiceLineDff | InvoicesinvoiceLinesinvoiceLineDff |
InvoicesinvoiceLinesinvoiceLineGdf | InvoicesinvoiceLinesinvoiceLineGdf |
InvoicesinvoiceLinesinvoiceLineProjectDff | InvoicesinvoiceLinesinvoiceLineProjectDff |
LedgersLOV | LedgersLOV |
LegalEntitiesLOV | LegalEntitiesLOV |
LegalJurisdictionsLOV | LegalJurisdictionsLOV |
LegalReportingUnitsLOV | LegalReportingUnitsLOV |
PayablesOptions | PayablesOptions |
PayablesPaymentTerms | PayablesPaymentTerms |
PayablesPaymentTermspayablesPaymentTermsLines | PayablesPaymentTermspayablesPaymentTermsLines |
PayablesPaymentTermspayablesPaymentTermsSets | PayablesPaymentTermspayablesPaymentTermsSets |
PayablesPaymentTermspayablesPaymentTermsTranslations | PayablesPaymentTermspayablesPaymentTermsTranslations |
PayeeBankAccountsLOV | PayeeBankAccountsLOV |
PaymentsExternalPayees | PaymentsExternalPayees |
PaymentsExternalPayeesexternalPartyPaymentMethods | PaymentsExternalPayeesexternalPartyPaymentMethods |
PreferredCurrenciesLOV | PreferredCurrenciesLOV |
ReceivablesBusinessUnitsLOV | ReceivablesBusinessUnitsLOV |
ReceivablesCreditMemos | ReceivablesCreditMemos |
ReceivablesCreditMemosattachments | ReceivablesCreditMemosattachments |
ReceivablesCreditMemosnotes | ReceivablesCreditMemosnotes |
ReceivablesCreditMemosreceivablesCreditMemoDFF | ReceivablesCreditMemosreceivablesCreditMemoDFF |
ReceivablesCreditMemosreceivablesCreditMemoDistributions | ReceivablesCreditMemosreceivablesCreditMemoDistributions |
ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF | ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF |
ReceivablesCreditMemosreceivablesCreditMemoGdf | ReceivablesCreditMemosreceivablesCreditMemoGdf |
ReceivablesCreditMemosreceivablesCreditMemoLines | ReceivablesCreditMemosreceivablesCreditMemoLines |
ReceivablesCreditMemosreceivablesCreditMemoLinesattachments | ReceivablesCreditMemosreceivablesCreditMemoLinesattachments |
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF |
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf |
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines |
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF |
ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF | ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF |
ReceivablesInvoices | ReceivablesInvoices |
ReceivablesInvoicesattachments | ReceivablesInvoicesattachments |
ReceivablesInvoicesnotes | ReceivablesInvoicesnotes |
ReceivablesInvoicesreceivablesInvoiceDFF | ReceivablesInvoicesreceivablesInvoiceDFF |
ReceivablesInvoicesreceivablesInvoiceDistributions | ReceivablesInvoicesreceivablesInvoiceDistributions |
ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF | ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF |
ReceivablesInvoicesreceivablesInvoiceGdf | ReceivablesInvoicesreceivablesInvoiceGdf |
ReceivablesInvoicesreceivablesInvoiceInstallments | ReceivablesInvoicesreceivablesInvoiceInstallments |
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF | ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF |
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes | ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes |
ReceivablesInvoicesreceivablesInvoiceLines | ReceivablesInvoicesreceivablesInvoiceLines |
ReceivablesInvoicesreceivablesInvoiceLinesattachments | ReceivablesInvoicesreceivablesInvoiceLinesattachments |
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF |
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf |
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines |
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF |
ReceivablesInvoicesreceivablesInvoiceTransactionDFF | ReceivablesInvoicesreceivablesInvoiceTransactionDFF |
TaxClassifications | TaxClassifications |
TransactionTaxLines | TransactionTaxLines |
WithholdingTaxLines | WithholdingTaxLines |
WorkflowUsers | WorkflowUsers |