JDBC Driver for Oracle SCM

Build 22.0.8462

LinesToReturn

The Lines to Return resource manages the received lines that are available to return.

Columns

Name Type Description
ToOrganizationCode String ToOrganizationCode of LinesToReturn
ToOrganizationId String ToOrganizationId of LinesToReturn
FromOrganizationCode String FromOrganizationCode of LinesToReturn
FromOrganizationId String FromOrganizationId of LinesToReturn
ItemNumber String ItemNumber of LinesToReturn
ItemId String ItemId of LinesToReturn
ItemDescription String ItemDescription of LinesToReturn
ItemRevision String ItemRevision of LinesToReturn
ReceiptNumber String ReceiptNumber of LinesToReturn
LineStatus String LineStatus of LinesToReturn
DocumentType String DocumentType of LinesToReturn
SourceDocumentCode String SourceDocumentCode of LinesToReturn
DocumentNumber String DocumentNumber of LinesToReturn
DocumentLineNumber String DocumentLineNumber of LinesToReturn
DocumentScheduleNumber String DocumentScheduleNumber of LinesToReturn
DocumentDistributionNumber String DocumentDistributionNumber of LinesToReturn
TransactionDate Date TransactionDate of LinesToReturn
VendorName String VendorName of LinesToReturn
VendorId String VendorId of LinesToReturn
VendorSiteCode String VendorSiteCode of LinesToReturn
VendorSiteId String VendorSiteId of LinesToReturn
VendorItemNumber String VendorItemNumber of LinesToReturn
TOShipmentNumber String TOShipmentNumber of LinesToReturn
ASNNumber String ASNNumber of LinesToReturn
ASNLineNumber String ASNLineNumber of LinesToReturn
CustomerPartyName String CustomerPartyName of LinesToReturn
CustomerId String CustomerId of LinesToReturn
AvailableQuantity String AvailableQuantity of LinesToReturn
UnitOfMeasure String UnitOfMeasure of LinesToReturn
UOMCode String UOMCode of LinesToReturn
SecondaryAvailableQuantity String SecondaryAvailableQuantity of LinesToReturn
SecondaryUnitOfMeasure String SecondaryUnitOfMeasure of LinesToReturn
SecondaryUOMCode String SecondaryUOMCode of LinesToReturn
DestinationType String DestinationType of LinesToReturn
DestinationTypeCode String DestinationTypeCode of LinesToReturn
Location String Location of LinesToReturn
LocationId String LocationId of LinesToReturn
Routing String Routing of LinesToReturn
RoutingHeaderId String RoutingHeaderId of LinesToReturn
POHeaderId String POHeaderId of LinesToReturn
POLineLocationId String POLineLocationId of LinesToReturn
POLineId String POLineId of LinesToReturn
PODistributionId String PODistributionId of LinesToReturn
PORevisionNumber String PORevisionNumber of LinesToReturn
ShipmentHeaderId String ShipmentHeaderId of LinesToReturn
ShipmentLineId String ShipmentLineId of LinesToReturn
TransferOrderHeaderId String TransferOrderHeaderId of LinesToReturn
TransferOrderLineId String TransferOrderLineId of LinesToReturn
TransferOrderDistId String TransferOrderDistId of LinesToReturn
ReceiptAdviceHeaderId String ReceiptAdviceHeaderId of LinesToReturn
ReceiptAdviceLineId String ReceiptAdviceLineId of LinesToReturn
ReceiptSourceCode String ReceiptSourceCode of LinesToReturn
ConsignedItems String ConsignedItems of LinesToReturn
BackToBack String BackToBack of LinesToReturn
CategoryName String CategoryName of LinesToReturn
CategoryId String CategoryId of LinesToReturn
CurrencyCode String CurrencyCode of LinesToReturn
CurrencyConversionRate String CurrencyConversionRate of LinesToReturn
CurrencyConversionDate Date CurrencyConversionDate of LinesToReturn
CurrencyConversionType String CurrencyConversionType of LinesToReturn
InventoryTransactionTypeId String InventoryTransactionTypeId of LinesToReturn
ParentTransactionType String ParentTransactionType of LinesToReturn
ParentTransactionId [KEY] String ParentTransactionId of LinesToReturn
GrandParentTransactionId String GrandParentTransactionId of LinesToReturn
Reason String Reason of LinesToReturn
ReasonId String ReasonId of LinesToReturn
ReceiptException String ReceiptException of LinesToReturn
EmployeeName String EmployeeName of LinesToReturn
EmployeeId String EmployeeId of LinesToReturn
Subinventory String Subinventory of LinesToReturn
Locator String Locator of LinesToReturn
LocatorId String LocatorId of LinesToReturn

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