JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

InvoicesinvoiceLines

InvoicesinvoiceLines

Columns

Name Type Description
InvoicesInvoiceId String InvoicesInvoiceId
LineNumber Long LineNumber
LineAmount String LineAmount
AccountingDate Date AccountingDate
UOM String UOM
TaxRateName String TaxRateName
LineType String LineType
AssetBook String AssetBook
TrackAsAssetFlag Bool TrackAsAssetFlag
BaseAmount String BaseAmount
Description String Description
IncomeTaxRegion String IncomeTaxRegion
Item String Item
ItemDescription String ItemDescription
LineSource String LineSource
Quantity String Quantity
DistributionCombination String DistributionCombination
AssetCategory String AssetCategory
UnitPrice String UnitPrice
ProrateAcrossAllItemsFlag Bool ProrateAcrossAllItemsFlag
LandedCostEnabled String LandedCostEnabled
DiscardedFlag Bool DiscardedFlag
CanceledFlag Bool CanceledFlag
IncomeTaxType String IncomeTaxType
TaxRateCode String TaxRateCode
TaxRate String TaxRate
TaxClassification String TaxClassification
GenerateDistributions String GenerateDistributions
BudgetDate Date BudgetDate
FundsStatus String FundsStatus
ApprovalStatus String ApprovalStatus
DistributionSet String DistributionSet
Withholding String Withholding
ShipToLocationCode String ShipToLocationCode
ShipToLocation String ShipToLocation
ShipToCustomerLocation String ShipToCustomerLocation
TaxControlAmount String TaxControlAmount
AssessableValue String AssessableValue
ProductType String ProductType
ProductCategory String ProductCategory
ProductCategoryCodePath String ProductCategoryCodePath
UserDefinedFiscalClassification String UserDefinedFiscalClassification
UserDefinedFiscalClassificationCode String UserDefinedFiscalClassificationCode
IntendedUse String IntendedUse
IntendedUseCode String IntendedUseCode
ProductFiscalClassification String ProductFiscalClassification
ProductFiscalClassificationCode String ProductFiscalClassificationCode
ProductFiscalClassificationType String ProductFiscalClassificationType
TransactionBusinessCategory String TransactionBusinessCategory
TransactionBusinessCategoryCodePath String TransactionBusinessCategoryCodePath
Requester String Requester
PurchasingCategory String PurchasingCategory
MatchType String MatchType
MatchOption String MatchOption
MatchBasis String MatchBasis
PurchaseOrderNumber String PurchaseOrderNumber
PurchaseOrderLineNumber String PurchaseOrderLineNumber
PurchaseOrderScheduleLineNumber String PurchaseOrderScheduleLineNumber
ReceiptNumber String ReceiptNumber
ReceiptLineNumber String ReceiptLineNumber
ConsumptionAdviceNumber String ConsumptionAdviceNumber
ConsumptionAdviceLineNumber String ConsumptionAdviceLineNumber
FinalMatchFlag Bool FinalMatchFlag
MultiperiodAccountingStartDate Date MultiperiodAccountingStartDate
MultiperiodAccountingEndDate Date MultiperiodAccountingEndDate
MultiperiodAccountingAccrualAccount String MultiperiodAccountingAccrualAccount
CreatedBy String CreatedBy
CreationDate Datetime CreationDate
LastUpdateDate Datetime LastUpdateDate
LastUpdatedBy String LastUpdatedBy
LastUpdateLogin String LastUpdateLogin
RequesterId String RequesterId
PrepaymentNumber String PrepaymentNumber
PrepaymentLineNumber Long PrepaymentLineNumber
PrepaymentIncludedonInvoiceFlag Bool PrepaymentIncludedonInvoiceFlag
ReferenceKeyTwo String ReferenceKeyTwo
ProductTable String ProductTable

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