JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

LinesToReceive

The Lines to Receive resource retrieves expected shipment lines that can be received. These lines can be of different types: purchase order, transfer order, return material authorization, or inventory.

Columns

Name Type Description
ToOrganizationCode String ToOrganizationCode of LinesToReceive
ToOrganizationId Long ToOrganizationId of LinesToReceive
FromOrganizationName String FromOrganizationName of LinesToReceive
FromOrganizationCode String FromOrganizationCode of LinesToReceive
FromOrganizationId Long FromOrganizationId of LinesToReceive
ItemNumber String ItemNumber of LinesToReceive
ItemDescription String ItemDescription of LinesToReceive
ItemId Long ItemId of LinesToReceive
ItemRevision String ItemRevision of LinesToReceive
DocumentType String DocumentType of LinesToReceive
SourceDocumentCode [KEY] String SourceDocumentCode of LinesToReceive
DocumentNumber String DocumentNumber of LinesToReceive
DocumentLineNumber String DocumentLineNumber of LinesToReceive
DocumentScheduleNumber String DocumentScheduleNumber of LinesToReceive
DocumentDistributionNumber Long DocumentDistributionNumber of LinesToReceive
SoldtoLegalEntity String SoldtoLegalEntity of LinesToReceive
SourceSystem String SourceSystem of LinesToReceive
DocumentLineId [KEY] Long DocumentLineId of LinesToReceive
DueDate Date DueDate of LinesToReceive
VendorName String VendorName of LinesToReceive
VendorSiteCode String VendorSiteCode of LinesToReceive
VendorId Long VendorId of LinesToReceive
VendorSiteId Long VendorSiteId of LinesToReceive
VendorItemNumber String VendorItemNumber of LinesToReceive
TOShipmentNumber String TOShipmentNumber of LinesToReceive
ASNNumber String ASNNumber of LinesToReceive
ASNLineNumber Long ASNLineNumber of LinesToReceive
CustomerPartyName String CustomerPartyName of LinesToReceive
CustomerId Long CustomerId of LinesToReceive
AvailableQuantity Decimal AvailableQuantity of LinesToReceive
UOMCode String UOMCode of LinesToReceive
UnitOfMeasure String UnitOfMeasure of LinesToReceive
SecondaryAvailableQuantity Decimal SecondaryAvailableQuantity of LinesToReceive
SecondaryUOMCode String SecondaryUOMCode of LinesToReceive
SecondaryUnitOfMeasure String SecondaryUnitOfMeasure of LinesToReceive
DestinationType String DestinationType of LinesToReceive
DestinationTypeCode String DestinationTypeCode of LinesToReceive
ShipToLocation String ShipToLocation of LinesToReceive
ShipToLocationId Long ShipToLocationId of LinesToReceive
Routing String Routing of LinesToReceive
RoutingHeaderId Long RoutingHeaderId of LinesToReceive
OrderedQuantity Decimal OrderedQuantity of LinesToReceive
OrderedUnitOfMeasure String OrderedUnitOfMeasure of LinesToReceive
POHeaderId Long POHeaderId of LinesToReceive
POLineLocationId Long POLineLocationId of LinesToReceive
POLineId Long POLineId of LinesToReceive
PODistributionId Long PODistributionId of LinesToReceive
PORevisionNumber Long PORevisionNumber of LinesToReceive
ShipmentHeaderId Long ShipmentHeaderId of LinesToReceive
ShipmentLineId Long ShipmentLineId of LinesToReceive
TransferOrderHeaderId Long TransferOrderHeaderId of LinesToReceive
TransferOrderLineId Long TransferOrderLineId of LinesToReceive
TransferOrderDistId Long TransferOrderDistId of LinesToReceive
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId of LinesToReceive
ReceiptAdviceLineId Long ReceiptAdviceLineId of LinesToReceive
ReceiptSourceCode String ReceiptSourceCode of LinesToReceive
ConsignedItems String ConsignedItems of LinesToReceive
BackToBack String BackToBack of LinesToReceive
CategoryName String CategoryName of LinesToReceive
CategoryId Long CategoryId of LinesToReceive
CurrencyCode String CurrencyCode of LinesToReceive
CurrencyConversionRate Decimal CurrencyConversionRate of LinesToReceive
CurrencyConversionDate Date CurrencyConversionDate of LinesToReceive
CurrencyConversionType String CurrencyConversionType of LinesToReceive
InventoryTransactionTypeId Long InventoryTransactionTypeId of LinesToReceive
POUnitPrice Decimal POUnitPrice of LinesToReceive
MatchOption String MatchOption of LinesToReceive
HeaderNoteToReceiver String HeaderNoteToReceiver of LinesToReceive
ScheduleNoteToReceiver String ScheduleNoteToReceiver of LinesToReceive
IntegrationStatus String IntegrationStatus of LinesToReceive
BindASNLineNumber Long BindASNLineNumber of LinesToReceive
BindASNNumber String BindASNNumber of LinesToReceive
BindBackToBack String BindBackToBack of LinesToReceive
BindConsigned String BindConsigned of LinesToReceive
BindDocumentDistributionNumber Long BindDocumentDistributionNumber of LinesToReceive
BindDocumentLineNumber String BindDocumentLineNumber of LinesToReceive
BindDocumentNumber String BindDocumentNumber of LinesToReceive
BindDocumentScheduleNumber String BindDocumentScheduleNumber of LinesToReceive
BindDocumentType String BindDocumentType of LinesToReceive
BindFromDate Date BindFromDate of LinesToReceive
BindItemId Long BindItemId of LinesToReceive
BindItemNumber String BindItemNumber of LinesToReceive
BindOrganizationCode String BindOrganizationCode of LinesToReceive
BindOrganizationId Long BindOrganizationId of LinesToReceive
BindPODistributionId Long BindPODistributionId of LinesToReceive
BindPOLineId Long BindPOLineId of LinesToReceive
BindPOLineLocationId Long BindPOLineLocationId of LinesToReceive
BindReceiptAdviceHeaderId Long BindReceiptAdviceHeaderId of LinesToReceive
BindReceiptAdviceLineId Long BindReceiptAdviceLineId of LinesToReceive
BindShipmentHeaderId Long BindShipmentHeaderId of LinesToReceive
BindShipmentLineId Long BindShipmentLineId of LinesToReceive
BindSourceDocumentCode String BindSourceDocumentCode of LinesToReceive
BindToDate Date BindToDate of LinesToReceive
BindTransferOrderDistId Long BindTransferOrderDistId of LinesToReceive
BindTransferOrderHeaderId Long BindTransferOrderHeaderId of LinesToReceive
BindTransferOrderLineId Long BindTransferOrderLineId of LinesToReceive
Finder String Finder of LinesToReceive

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