ReceivingReturnslines
ReceivingReturnslines
Columns
| Name | Type | 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 | Primary key identifier for the return header record |