ReceivingReturnslines
ReceivingReturnslines
Columns
| Name | Type | SupportedFinders | Description |
| ReceivingReturnsReturnHeaderId [KEY] | Long | Value that uniquely identifies the receiving return header in Oracle SCM | |
| ReturnLineId [KEY] | Long | Value that uniquely identifies the return line | |
| ReturnLineNumber | Long | Number that identifies the return line | |
| CreationDate | Datetime | Date when the record was created | |
| CreatedBy | String | The user who created the record | |
| LastUpdateDate | Datetime | Date when the record was last updated | |
| LastUpdatedBy | String | The user who last updated the record | |
| OrganizationId | Long | Value that uniquely identifies the organization | |
| OrganizationCode | String | Code that identifies the organization | |
| ItemId | Long | Value that uniquely identifies the inventory item in Oracle SCM | |
| ItemNumber | String | Number that identifies the inventory item | |
| ItemDescription | String | Description of the inventory item | |
| ItemRevision | String | Revision of the inventory item | |
| LineStatusCode | String | Code that identifies the status of the return line | |
| LineStatus | String | Status of the return line | |
| Subinventory | String | Code that identifies the subinventory location | |
| LocatorId | Long | Value that uniquely identifies the locator (bin) in Oracle SCM | |
| Locator | String | Code that identifies the locator (bin) | |
| PhysicalMaterialReturnRequiredFlag | Bool | Indicates whether physical material return is required for the line | |
| RequestedQuantity | Decimal | Quantity requested for return on this line | |
| FulfilledQuantity | Decimal | Quantity fulfilled for this return line | |
| CanceledQuantity | Decimal | Quantity canceled for this return line | |
| UOMCode | String | Code that identifies the unit of measure | |
| UnitOfMeasure | String | Name of the unit of measure | |
| UOMClass | String | Class of the unit of measure | |
| PrimaryRequestedQuantity | Decimal | Primary quantity requested for return on this line | |
| PrimaryUOMCode | String | Code that identifies the primary unit of measure | |
| PrimaryUnitOfMeasure | String | Name of the primary unit of measure | |
| RequestedDate | Datetime | Date when the return is requested | |
| ReturnedById | Long | Value that uniquely identifies the user who returned the item | |
| ReturnedByName | String | Name of the user who returned the item | |
| AccountId | Long | Value that uniquely identifies the account in Oracle SCM | |
| Account | String | Code that identifies the account | |
| LotNumber | String | Number that identifies the lot | |
| SecondaryRequestedQuantity | Decimal | Secondary quantity requested for return on this line | |
| SecondaryFulfilledQuantity | Decimal | Secondary quantity fulfilled for this return line | |
| SecondaryCanceledQuantity | Decimal | Secondary quantity canceled for this return line | |
| SecondaryUOMCode | String | Code that identifies the secondary unit of measure | |
| SecondaryUnitOfMeasure | String | Name of the secondary unit of measure | |
| SupplierLotNumber | String | Number that identifies the supplier lot | |
| SupplierItemNumber | String | Number that identifies the supplier item | |
| SupplierRMANumber | String | Number that identifies the supplier RMA | |
| RecallHeaderId | Long | Value that uniquely identifies the recall header in Oracle SCM | |
| RecallNoticeNumber | String | Number that identifies the recall notice | |
| RecallLineId | Long | Value that uniquely identifies the recall line in Oracle SCM | |
| RecallNoticeLineNumber | Long | Number that identifies the recall notice line | |
| ReasonId | Long | Value that uniquely identifies the return reason in Oracle SCM | |
| Reason | String | Description of the return reason | |
| Comments | String | Comments for the return line | |
| ErrorMessageName | String | Name of the error message | |
| ErrorMessage | String | Text of the error message | |
| TransactionId | Long | Value that uniquely identifies the transaction in Oracle SCM | |
| ParentTransactionId | Long | Value that uniquely identifies the parent transaction in Oracle SCM | |
| ParentTransactionTypeCode | String | Code that identifies the parent transaction type | |
| POHeaderId | Long | Value that uniquely identifies the purchase order header in Oracle SCM | |
| PONumber | String | Number that identifies the purchase order | |
| POLineId | Long | Value that uniquely identifies the purchase order line in Oracle SCM | |
| POLineNumber | Decimal | Number that identifies the purchase order line | |
| POLineLocationId | Long | Value that uniquely identifies the purchase order line location in Oracle SCM | |
| POScheduleNumber | Decimal | Number that identifies the purchase order schedule | |
| PODistributionId | Long | Value that uniquely identifies the purchase order distribution in Oracle SCM | |
| TransferOrderHeaderId | Long | Value that uniquely identifies the transfer order header in Oracle SCM | |
| TransferOrderNumber | String | Number that identifies the transfer order | |
| TransferOrderLineId | Long | Value that uniquely identifies the transfer order line in Oracle SCM | |
| TransferOrderLineNumber | Int | Number that identifies the transfer order line | |
| TransferOrderDistributionId | Long | Value that uniquely identifies the transfer order distribution in Oracle SCM | |
| ReceiptAdviceHeaderId | Long | Value that uniquely identifies the receipt advice header in Oracle SCM | |
| RMANumber | String | Number that identifies the RMA | |
| ReceiptAdviceLineId | Long | Value that uniquely identifies the receipt advice line in Oracle SCM | |
| RMALineNumber | String | Number that identifies the RMA line | |
| ShipmentHeaderId | Long | Value that uniquely identifies the shipment header in Oracle SCM | |
| ReceiptNumber | String | Number that identifies the receipt | |
| ShipmentNumber | String | Number that identifies the shipment | |
| ShipmentLineId | Long | Value that uniquely identifies the shipment line in Oracle SCM | |
| CreateDebitMemoFlag | Bool | Indicates whether a debit memo should be created | |
| InterfaceSourceCode | String | Code that identifies the interface source | |
| FirstPartyTaxRegistrationId | Long | Value that uniquely identifies the first party tax registration | |
| ThirdPartyTaxRegistrationId | Long | Value that uniquely identifies the third party tax registration | |
| DefaultTaxationCountryCode | String | Code that identifies the default taxation country | |
| DocumentFiscalClassificationCode | String | Code that identifies the document fiscal classification | |
| TransactionBusinessCategoryCode | String | Code that identifies the transaction business category | |
| TaxInvoiceNumber | String | Number that identifies the tax invoice | |
| TaxInvoiceDate | Date | Date of the tax invoice | |
| ShipFromLocationId | Long | Value that uniquely identifies the ship from location in Oracle SCM | |
| UserDefinedFiscalClassificationCode | String | Code that identifies the user defined fiscal classification | |
| TaxClassificationCode | String | Code that identifies the tax classification | |
| ProductFiscalClassificationId | Long | Value that uniquely identifies the product fiscal classification | |
| IntendedUseClassificationId | Long | Value that uniquely identifies the intended use classification | |
| ProductTypeCode | String | Code that identifies the product type | |
| ProductCategoryCode | String | Code that identifies the product category | |
| AssessableValue | Decimal | Value that is assessable for tax calculation purposes | |
| FinalDischargeLocationId | Long | Value that uniquely identifies the final discharge location | |
| ItemLotControlCode | Decimal | Code that identifies the item lot control | |
| ItemSerialNumberControlCode | Decimal | Code that identifies the item serial number control | |
| ItemRevisionControlCode | Decimal | Code that identifies the item revision control | |
| ItemLotStatusEnabledFlag | Bool | Indicates whether lot status is enabled for the item | |
| ItemSerialStatusEnabledFlag | Bool | Indicates whether serial status is enabled for the item | |
| ItemTrackingQuantityIndicator | String | Indicator that specifies the item tracking quantity | |
| ItemSecondaryDefaultIndicator | String | Indicator that specifies the item secondary default | |
| ItemDualUOMDeviationLow | Decimal | Low deviation value for dual unit of measure | |
| ItemDualUOMDeviationHigh | Decimal | High deviation value for dual unit of measure | |
| ItemLocatorControlCode | Decimal | Code that identifies the item locator control | |
| DirectTransferOrderFlag | Bool | Indicates whether this is a direct transfer order | |
| ConsignedItemFlag | Bool | Indicates whether the item is consigned | |
| SubinventoryQuantityTrackedCode | Int | Code that identifies the subinventory quantity tracking | |
| ParentLineStatus | String | Status of the parent line | |
| DestinationTypeCode | String | Code that identifies the destination type | |
| DestinationType | String | Type of the destination | |
| ConsumedQuantity | Decimal | Quantity consumed for this return line | |
| ReturnForCreditFlag | Bool | Indicates whether the return is for credit | |
| POReturnTypeCode | String | Code that identifies the purchase order return type | |
| LPNId | Long | Value that uniquely identifies the license plate number in Oracle SCM | |
| TransferLPNId | Long | Value that uniquely identifies the transfer license plate number in Oracle SCM | |
| LicensePlateNumber | String | Number that identifies the license plate | |
| TransferLicensePlateNumber | String | Number that identifies the transfer license plate | |
| ReceivedLotsCount | Long | Count of lots received for this return line | |
| ReceivedSerialsCount | Long | Count of serial numbers received for this return line | |
| Finder | String | Finder method identifier for querying receiving returns with specific filter criteria | |
| ReturnHeaderId | Long | PrimaryKey | Primary key identifier for the return header record |