JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

PayablesPayments

PayablesPayments

Columns

Name Type Description
CheckId [KEY] String CheckId
PaymentId String PaymentId
PaymentReference String PaymentReference
PaperDocumentNumber String PaperDocumentNumber
PaymentNumber String PaymentNumber
PaymentFileReference String PaymentFileReference
PaymentProcessRequest String PaymentProcessRequest
PaymentAmount String PaymentAmount
PaymentDate Date PaymentDate
AccountingDate Date AccountingDate
PaymentDescription String PaymentDescription
ConversionRate String ConversionRate
ConversionDate Date ConversionDate
ConversionRateType String ConversionRateType
ClearingDate Date ClearingDate
ClearingAmount String ClearingAmount
ClearingLedgerAmount String ClearingLedgerAmount
ClearingConversionRate String ClearingConversionRate
ClearingConversionDate Date ClearingConversionDate
ClearingConversionRateType String ClearingConversionRateType
CrossCurrencyRateType String CrossCurrencyRateType
MaturityDate Date MaturityDate
MaturityConversionRateType String MaturityConversionRateType
MaturityConversionDate Date MaturityConversionDate
MaturityConversionRate String MaturityConversionRate
AnticipatedValueDate Date AnticipatedValueDate
ClearingValueDate Date ClearingValueDate
StopDate Date StopDate
VoidDate Date VoidDate
VoidAccountingDate Date VoidAccountingDate
PaymentStatus String PaymentStatus
SeparateRemittanceAdviceCreated String SeparateRemittanceAdviceCreated
AccountingStatus String AccountingStatus
ReconciledFlag Bool ReconciledFlag
PaymentType String PaymentType
PaymentCurrency String PaymentCurrency
WithheldAmount String WithheldAmount
BankChargeAmount String BankChargeAmount
LegalEntity String LegalEntity
BusinessUnit String BusinessUnit
PaymentFunction String PaymentFunction
Payee String Payee
PartyId String PartyId
ProcurementBU String ProcurementBU
PayeeSite String PayeeSite
EmployeeAddress String EmployeeAddress
SupplierNumber String SupplierNumber
ThirdPartySupplier String ThirdPartySupplier
ThirdPartyAddressName String ThirdPartyAddressName
ExternalBankAccountId String ExternalBankAccountId
RemitToAccountNumber String RemitToAccountNumber
DisbursementBankAccountNumber String DisbursementBankAccountNumber
DisbursementBankAccountName String DisbursementBankAccountName
PaymentMethodCode String PaymentMethodCode
PaymentMethod String PaymentMethod
PaymentDocument String PaymentDocument
PaymentProcessProfileCode String PaymentProcessProfileCode
PaymentProcessProfile String PaymentProcessProfile
DocumentCategory String DocumentCategory
DocumentSequence String DocumentSequence
VoucherNumber String VoucherNumber
PaymentBaseAmount String PaymentBaseAmount
PaymentBaseCurrency String PaymentBaseCurrency
AddressLine1 String AddressLine1
AddressLine2 String AddressLine2
AddressLine3 String AddressLine3
AddressLine4 String AddressLine4
City String City
County String County
Province String Province
State String State
Country String Country
Zip String Zip
CreatedBy String CreatedBy
CreationDate Datetime CreationDate
LastUpdatedBy String LastUpdatedBy
LastUpdateDate Datetime LastUpdateDate
LastUpdateLogin String LastUpdateLogin

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