JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

Invoices

Invoices

Columns

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462