Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9062

DraftPurchaseOrderslines

The Lines resource manages purchasing details, such as the item to purchase, quantity, unit of measure, and price.

Columns

Name Type Description
DraftPurchaseOrdersPOHeaderId [KEY] Long DraftPurchaseOrdersPOHeaderId of DraftPurchaseOrderslines
POLineId [KEY] Long POLineId of DraftPurchaseOrderslines
LineNumber Decimal LineNumber of DraftPurchaseOrderslines
POHeaderId Long POHeaderId of DraftPurchaseOrderslines
OrderNumber String OrderNumber of DraftPurchaseOrderslines
LineTypeId Long LineTypeId of DraftPurchaseOrderslines
LineType String LineType of DraftPurchaseOrderslines
ItemId Long ItemId of DraftPurchaseOrderslines
Item String Item of DraftPurchaseOrderslines
ItemRevision String ItemRevision of DraftPurchaseOrderslines
CategoryId Long CategoryId of DraftPurchaseOrderslines
CategoryCode String CategoryCode of DraftPurchaseOrderslines
Category String Category of DraftPurchaseOrderslines
Description String Description of DraftPurchaseOrderslines
Amount Decimal Amount of DraftPurchaseOrderslines
Quantity Decimal Quantity of DraftPurchaseOrderslines
BasePrice Decimal BasePrice of DraftPurchaseOrderslines
DiscountType String DiscountType of DraftPurchaseOrderslines
Discount Decimal Discount of DraftPurchaseOrderslines
DiscountReason String DiscountReason of DraftPurchaseOrderslines
Price Decimal Price of DraftPurchaseOrderslines
UOMCode String UOMCode of DraftPurchaseOrderslines
UOM String UOM of DraftPurchaseOrderslines
PricingUOMCode String PricingUOMCode of DraftPurchaseOrderslines
PricingUOM String PricingUOM of DraftPurchaseOrderslines
CurrencyCode String CurrencyCode of DraftPurchaseOrderslines
Currency String Currency of DraftPurchaseOrderslines
BaseModelId Long BaseModelId of DraftPurchaseOrderslines
BaseModel String BaseModel of DraftPurchaseOrderslines
BaseModelPrice Decimal BaseModelPrice of DraftPurchaseOrderslines
CancelDate Date CancelDate of DraftPurchaseOrderslines
CancelFlag Bool CancelFlag of DraftPurchaseOrderslines
CancelReason String CancelReason of DraftPurchaseOrderslines
CancelledBy Long CancelledBy of DraftPurchaseOrderslines
ChangeAcceptedFlag Bool ChangeAcceptedFlag of DraftPurchaseOrderslines
ConfiguredItemFlag Bool ConfiguredItemFlag of DraftPurchaseOrderslines
ConsignmentLineFlag Bool ConsignmentLineFlag of DraftPurchaseOrderslines
SourceAgreementId Long SourceAgreementId of DraftPurchaseOrderslines
SourceAgreementNumber String SourceAgreementNumber of DraftPurchaseOrderslines
SourceAgreementLineId Long SourceAgreementLineId of DraftPurchaseOrderslines
SourceAgreementLine Decimal SourceAgreementLine of DraftPurchaseOrderslines
SourceAgreementTypeCode String SourceAgreementTypeCode of DraftPurchaseOrderslines
SourceAgreementType String SourceAgreementType of DraftPurchaseOrderslines
SourceAgreementProcurementBUId Long SourceAgreementProcurementBUId of DraftPurchaseOrderslines
SourceAgreementProcurementBU String SourceAgreementProcurementBU of DraftPurchaseOrderslines
ResponseLine Decimal ResponseLine of DraftPurchaseOrderslines
Response Decimal Response of DraftPurchaseOrderslines
NegotiationId Long NegotiationId of DraftPurchaseOrderslines
Negotiation String Negotiation of DraftPurchaseOrderslines
NegotiationLine Decimal NegotiationLine of DraftPurchaseOrderslines
FundsStatusCode String FundsStatusCode of DraftPurchaseOrderslines
FundsStatus String FundsStatus of DraftPurchaseOrderslines
ManualPriceChangeFlag Bool ManualPriceChangeFlag of DraftPurchaseOrderslines
NegotiatedFlag Bool NegotiatedFlag of DraftPurchaseOrderslines
NoteToSupplier String NoteToSupplier of DraftPurchaseOrderslines
ReasonForChange String ReasonForChange of DraftPurchaseOrderslines
SupplierConfigurationId String SupplierConfigurationId of DraftPurchaseOrderslines
SupplierItem String SupplierItem of DraftPurchaseOrderslines
OptionsPrice Decimal OptionsPrice of DraftPurchaseOrderslines
UNNumberCode String UNNumberCode of DraftPurchaseOrderslines
UNNumberId Long UNNumberId of DraftPurchaseOrderslines
UNNumber String UNNumber of DraftPurchaseOrderslines
UNNumberDescription String UNNumberDescription of DraftPurchaseOrderslines
HazardClassCode String HazardClassCode of DraftPurchaseOrderslines
HazardClassId Long HazardClassId of DraftPurchaseOrderslines
HazardClass String HazardClass of DraftPurchaseOrderslines
WorkOrderProduct String WorkOrderProduct of DraftPurchaseOrderslines
TaxableFlag Bool TaxableFlag of DraftPurchaseOrderslines
ReferenceNumber String ReferenceNumber of DraftPurchaseOrderslines
CancelUnfulfilledDemandFlag Bool CancelUnfulfilledDemandFlag of DraftPurchaseOrderslines
CreationDate Datetime CreationDate of DraftPurchaseOrderslines
CreatedBy String CreatedBy of DraftPurchaseOrderslines
LastUpdateDate Datetime LastUpdateDate of DraftPurchaseOrderslines
LastUpdatedBy String LastUpdatedBy of DraftPurchaseOrderslines
MaximumRetainageAmount Decimal MaximumRetainageAmount of DraftPurchaseOrderslines
Manufacturer String Manufacturer of DraftPurchaseOrderslines
ManufacturerPartNumber String ManufacturerPartNumber of DraftPurchaseOrderslines
CreditFlag Bool CreditFlag of DraftPurchaseOrderslines
Finder String Finder of DraftPurchaseOrderslines
Intent String Intent of DraftPurchaseOrderslines
SysEffectiveDate String SysEffectiveDate of DraftPurchaseOrderslines

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