JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

InvoicesinvoiceLinesinvoiceDistributions

InvoicesinvoiceLinesinvoiceDistributions

Columns

Name Type Description
InvoicesInvoiceId String InvoicesInvoiceId
InvoicelinesLineNumber Long InvoicelinesLineNumber
InvoiceDistributionId String InvoiceDistributionId
DistributionLineNumber String DistributionLineNumber
DistributionLineType String DistributionLineType
IncomeTaxType String IncomeTaxType
AccountingStatus String AccountingStatus
MatchedStatus String MatchedStatus
ValidationStatus String ValidationStatus
AccountingDate Date AccountingDate
DistributionAmount String DistributionAmount
AssetBook String AssetBook
DistributionCombination String DistributionCombination
TrackAsAssetFlag Bool TrackAsAssetFlag
BaseAmount String BaseAmount
CanceledFlag Bool CanceledFlag
Description String Description
IncomeTaxRegion String IncomeTaxRegion
ReversedFlag Bool ReversedFlag
InvoicedQuantity String InvoicedQuantity
UOM String UOM
UnitPrice String UnitPrice
PurchaseOrderDistributionLineNumber String PurchaseOrderDistributionLineNumber
PurchaseOrderNumber String PurchaseOrderNumber
PurchaseOrderLineNumber String PurchaseOrderLineNumber
PurchaseOrderScheduleLineNumber String PurchaseOrderScheduleLineNumber
ReceiptNumber String ReceiptNumber
ReceiptLineNumber String ReceiptLineNumber
ConsumptionAdviceNumber String ConsumptionAdviceNumber
ConsumptionAdviceLineNumber String ConsumptionAdviceLineNumber
AssociatedItemDistributionLineNumber String AssociatedItemDistributionLineNumber
FinalMatchFlag Bool FinalMatchFlag
MultiperiodAccountingStartDate Date MultiperiodAccountingStartDate
MultiperiodAccountingEndDate Date MultiperiodAccountingEndDate
MultiperiodAccountingAccrualAccount String MultiperiodAccountingAccrualAccount
TaxRegimeName String TaxRegimeName
TaxName String TaxName
TaxRecoverable String TaxRecoverable
TaxRate String TaxRate
TaxRateName String TaxRateName
TaxType String TaxType
IntendedUse String IntendedUse
IntendedUseCode String IntendedUseCode
CreatedBy String CreatedBy
CreationDate Datetime CreationDate
LastUpdatedBy String LastUpdatedBy
LastUpdateDate Datetime LastUpdateDate
LastUpdateLogin String LastUpdateLogin
PrepaymentNumber String PrepaymentNumber
PrepaymentLineNumber String PrepaymentLineNumber
PrepaymentDistributionLineNumber String PrepaymentDistributionLineNumber
PrepaymentAvailableAmount String PrepaymentAvailableAmount
ChargeApplicableToDistId String ChargeApplicableToDistId
AllocationLineNumber Long AllocationLineNumber
AllocationDistributionLineNumber String AllocationDistributionLineNumber

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