Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

Invoices

The payables invoices resource is used to manage details about supplier invoices, that includes header, lines, distributions, installments, descriptive flexfields, global descriptive flexfields, and attachments. Note: You can only update certain attributes and the update applies only to those attributes. Related fields don't automatically get populated. In summary, the cascade defaulting doesn't automatically happen and you must review and update the dependent attributes. For example, when you update the invoice date in the Create or Edit Invoice pages, related fields, such as the terms date or due date, may be autopopulated based on the invoice date you enter. Using REST API, the invoice date is updated, but the related fields aren't autopopulated. Before updating a key attribute, consider the impact on the related attributes.

Columns

Name Type Description
InvoiceId [KEY] Long InvoiceId of Invoices
InvoiceNumber String InvoiceNumber of Invoices
InvoiceCurrency String InvoiceCurrency of Invoices
PaymentCurrency String PaymentCurrency of Invoices
InvoiceAmount Decimal InvoiceAmount of Invoices
InvoiceDate Date InvoiceDate of Invoices
BusinessUnit String BusinessUnit of Invoices
Supplier String Supplier of Invoices
SupplierNumber String SupplierNumber of Invoices
ProcurementBU String ProcurementBU of Invoices
SupplierSite String SupplierSite of Invoices
RequesterId Long RequesterId of Invoices
Requester String Requester of Invoices
InvoiceGroup String InvoiceGroup of Invoices
ConversionRateType String ConversionRateType of Invoices
ConversionDate Date ConversionDate of Invoices
ConversionRate Decimal ConversionRate of Invoices
AccountingDate Date AccountingDate of Invoices
Description String Description of Invoices
DeliveryChannelCode String DeliveryChannelCode of Invoices
DeliveryChannel String DeliveryChannel of Invoices
PayAloneFlag Bool PayAloneFlag of Invoices
InvoiceSourceCode String InvoiceSourceCode of Invoices
InvoiceSource String InvoiceSource of Invoices
InvoiceType String InvoiceType of Invoices
PayGroup String PayGroup of Invoices
InvoiceReceivedDate Date InvoiceReceivedDate of Invoices
PaymentReasonCode String PaymentReasonCode of Invoices
PaymentReason String PaymentReason of Invoices
PaymentReasonComments String PaymentReasonComments of Invoices
RemittanceMessageOne String RemittanceMessageOne of Invoices
RemittanceMessageTwo String RemittanceMessageTwo of Invoices
RemittanceMessageThree String RemittanceMessageThree of Invoices
PaymentTerms String PaymentTerms of Invoices
TermsDate Date TermsDate of Invoices
GoodsReceivedDate Date GoodsReceivedDate of Invoices
PaymentMethodCode String PaymentMethodCode of Invoices
PaymentMethod String PaymentMethod of Invoices
SupplierTaxRegistrationNumber String SupplierTaxRegistrationNumber of Invoices
FirstPartyTaxRegistrationId Long FirstPartyTaxRegistrationId of Invoices
FirstPartyTaxRegistrationNumber String FirstPartyTaxRegistrationNumber of Invoices
LegalEntity String LegalEntity of Invoices
LegalEntityIdentifier String LegalEntityIdentifier of Invoices
LiabilityDistribution String LiabilityDistribution of Invoices
DocumentCategory String DocumentCategory of Invoices
DocumentSequence Long DocumentSequence of Invoices
VoucherNumber String VoucherNumber of Invoices
ValidationStatus String ValidationStatus of Invoices
ApprovalStatus String ApprovalStatus of Invoices
PaidStatus String PaidStatus of Invoices
AccountingStatus String AccountingStatus of Invoices
ApplyAfterDate Date ApplyAfterDate of Invoices
CanceledFlag Bool CanceledFlag of Invoices
AmountPaid Decimal AmountPaid of Invoices
BaseAmount Decimal BaseAmount of Invoices
PurchaseOrderNumber String PurchaseOrderNumber of Invoices
Party String Party of Invoices
PartySite String PartySite of Invoices
ControlAmount Decimal ControlAmount of Invoices
DocumentFiscalClassificationCodePath String DocumentFiscalClassificationCodePath of Invoices
TaxationCountry String TaxationCountry of Invoices
RoutingAttribute1 String RoutingAttribute1 of Invoices
RoutingAttribute2 String RoutingAttribute2 of Invoices
RoutingAttribute3 String RoutingAttribute3 of Invoices
RoutingAttribute4 String RoutingAttribute4 of Invoices
RoutingAttribute5 String RoutingAttribute5 of Invoices
AccountCodingStatus String AccountCodingStatus of Invoices
BudgetDate Date BudgetDate of Invoices
FundsStatus String FundsStatus of Invoices
CanceledDate Date CanceledDate of Invoices
CanceledBy String CanceledBy of Invoices
UniqueRemittanceIdentifier String UniqueRemittanceIdentifier of Invoices
UniqueRemittanceIdentifierCheckDigit String UniqueRemittanceIdentifierCheckDigit of Invoices
CreationDate Datetime CreationDate of Invoices
CreatedBy String CreatedBy of Invoices
LastUpdatedBy String LastUpdatedBy of Invoices
LastUpdateDate Datetime LastUpdateDate of Invoices
LastUpdateLogin String LastUpdateLogin of Invoices
BankAccount String BankAccount of Invoices
SupplierIBAN String SupplierIBAN of Invoices
ExternalBankAccountId Long ExternalBankAccountId of Invoices
BankChargeBearer String BankChargeBearer of Invoices
SettlementPriority String SettlementPriority of Invoices
ReferenceKeyOne String ReferenceKeyOne of Invoices
ReferenceKeyTwo String ReferenceKeyTwo of Invoices
ReferenceKeyThree String ReferenceKeyThree of Invoices
ReferenceKeyFour String ReferenceKeyFour of Invoices
ReferenceKeyFive String ReferenceKeyFive of Invoices
ProductTable String ProductTable of Invoices
ImageDocumentNumber String ImageDocumentNumber of Invoices
Finder String Finder of Invoices

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