ADO.NET Provider for Oracle Fusion Cloud SCM

Build 23.0.8839

ReceivingReceiptRequestslines

ReceivingReceiptRequestslines

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslines
InterfaceTransactionId [KEY] Long Value that uniquely identifies the interfaced receipt line request.
HeaderInterfaceId Long Value that uniquely identifies the header request to which this line belongs to.
CreatedBy String CreatedBy of ReceivingReceiptRequestslines
CreationDate Datetime CreationDate of ReceivingReceiptRequestslines
LastUpdateDate Datetime LastUpdateDate of ReceivingReceiptRequestslines
LastUpdatedBy String LastUpdatedBy of ReceivingReceiptRequestslines
TransactionType String Type if transaction for the line request. Valid values include RECEIVE or SHIP. When creating an advanced shipment notice (ASN) line, transaction type should be set to SHIP. When creating a receipt line request, transaction type should be set to RECEIVE.
AutoTransactCode String Abbreviation that determines how to finish subsequent transactions automatically, if needed. Valid values include SHIP, RECEIVE, and DELIVER. If you receive a document line (transaction type is RECEIVE) where the document routing is direct delivery, then set auto-transact code to DELIVER. This will receive and also deliver the material or services automatically. If you receive a document with standard or inspection required routing, set auto-transact code to RECEIVE, so that only the receipt is created and the material resides in the receiving bay. When you create an advanced shipment notice (ASN) line (transaction type is SHIP) and set the auto-transact code to RECEIVE, then the advanced shipment notice (ASN) will be created and a receipt is automatically created. If you set auto-transact code to DELIVER, then along with creation of an advanced shipment notice (ASN), receive and deliver take place automatically.
TransactionDate Datetime Receipt date for the current line. This attribute is used for receipt accounting, invoicing, and other related processes. The default value is the current date and time. If the time zone is not provided, the value stored is the time zone of the database. This value cannot be a future date.
OrganizationCode String Abbreviation that identifies the receiving organization. This attribute is used to derive the organization identifier. For every receipt line request or advanced shipment notice (ASN) line request, either organization code or organization identifier must be populated. If the values are not provided, the request will fail.
OrganizationId Long Value that uniquely identifies the receiving organization. For every receipt line request or advanced shipment notice (ASN) line request, either organization code or organization identifier must be populated. If the values are not provided, the request will fail.
ItemDescription String Description of the item corresponding to the receipt line request or advanced shipment notice (ASN) line request. When you create an ASN or a receipt for a purchase order, it should match the item description of the corresponding purchase order line. For receipts against In-transit shipment, transfer order and return material authorization (RMA), this attribute should match the description of the inventory item. When creating an ASN or a receipt, one of the following must be provided: item identifier, item number, or item description.
ItemId Long Value that uniquely identifies the inventory item. When creating an advanced shipment notice (ASN) or a receipt, one of the following must be provided: item identifier, item number, or item description.
ItemNumber String Number that identifies the item. Used to derive the attribute ItemId. When creating an advanced shipment notice (ASN) or a receipt, one of the following must be provided: item identifier, item number, or item description.
ItemRevision String Number that identifies the revision of the item. This attribute is mandatory when creating receipt lines for an item that is revision controlled.
ReceiptSourceCode String Value that identifies the source of the advanced shipment notice (ASN) or the receipt. Valid values include VENDOR when creating an ASN, receiving a purchase order, or receiving an ASN, INVENTORY when receiving an in-transit shipment, TRANSFER ORDER when receiving a transfer order, CUSTOMER when receiving a return material authorization (RMA). This attribute is mandatory.
SourceDocumentCode String Abbreviation that identifies the type of source document. Valid values include PO to create an advanced shipment notice (ASN), receive a purchase order, or an ASN, INVENTORY to receive an in-transit shipment, TRANSFER ORDER to receive a transfer order, RMA to receive a transfer order. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. This attribute is mandatory.
DocumentNumber String Number that identifies the document for the receipt line request or advanced shipment notice (ASN) line request. When the source document code is PO (create an ASN, receive a purchase order or an ASN), this attribute is the purchase order number. When the source document code is INVENTORY, this attribute is the in-transit shipment number. When the source document code is TRANSFER ORDER, this attribute is the transfer order shipment number. When the source document code is RMA, this attribute is the return material authorization (RMA) number. This attribute is mandatory.
DocumentLineNumber Long Number that identifies the document line number for the receipt line request or advanced shipment notice (ASN) line request. When the source document code is PO (create an ASN, receive a purchase order, or receive an ASN), this attribute is the purchase order line number. When the source document code is INVENTORY, this attribute is the in-transit shipment line number. When the source document code is TRANSFER ORDER, this attribute is the transfer order shipment line number. When the source document code is RMA, this attribute is the return material authorization (RMA) line number. This attribute is mandatory.
DocumentShipmentLineNumber Long Number that identifies the document schedule for the receiving transaction. When the source document code is PO (create an advanced shipment notice (ASN), receive a purchase order, or receive an ASN), this attribute is the purchase order schedule number. When receiving a purchase order or creating an ASN line, this attribute is mandatory.
DocumentDistributionNumber Long Number that identifies the document distribution for the receiving transaction. When receiving a purchase order that has multiple distributions, this attribute is the respective purchase order distribution number. When receiving a purchase order with multiple distributions, this attribute is mandatory.
PODistributionId Long Value that uniquely identifies the purchase order distribution. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN.
POHeaderId Long Value that uniquely identifies the purchase order header. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN.
POLineId Long Value that uniquely identifies the purchase order line. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN.
POLineLocationId Long Value that uniquely identifies the purchase order schedule. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN.
ShipmentHeaderId Long Value that uniquely identifies the receiving shipment or receipt header. This attribute is applicable when receiving an advanced shipment notice (ASN), a in-transit shipment, or a transfer order.
ShipmentLineId Long Value that uniquely identifies the shipment line. This attribute is applicable when receiving an advanced shipment notice (ASN), a in-transit shipment, or a transfer order.
ShipmentNumber String Number that indicates the shipment that the shipment source assigns. This number corresponds to the number that identifies one of the following objects: advance shipment notice, in-transit shipment, or transfer-order shipment.
ASNLineNumber Long Number that identifies the line on the advance shipment notice. Either this attribute or ShipmentLineId must be provided when receiving an advanced shipment notice (ASN).
TransferOrderHeaderId Long Value that uniquely identifies the transfer order header. This attribute is applicable when receiving a transfer order.
TransferOrderLineId Long Value that uniquely identifies the transfer order line. This attribute is applicable receiving a transfer order.
TransferOrderDistributionId Long Value that uniquely identifies the transfer order distribution. This attribute is applicable when receiving a transfer order with multiple distributions and direct routing.
SoldtoLegalEntity String Name of the sold-to legal entity. Populate this attribute with the sold-to legal entity associated to the purchase order. This is used to derive SoldtoLegalEntityId.
SoldtoLegalEntityId Long Value that uniquely identifies the sold-to legal entity. The combination of DocumentNumber and SoldtoLegalEntityId is needed to derive POHeaderId, which identifies the purchase order header for a purchase order-based transaction.
DestinationTypeCode String Abbreviation that identifies the destination type for the receiving transaction. Contains one of the following values: blank, RECEIVING, value stored in destination type, or INVENTORY. When you set to blank, the application will default the appropriate value based on the document type and auto-transact code. This is recommended. When set to RECEIVING, the document routing is standard or inspection required. Set to the value stored in destination type for the corresponding purchase order schedule or transfer order line. When set to INVENTORY, receive in-transit shipment or return material authorization (RMA) and the document routing is direct delivery.
Subinventory String Name of the destination subinventory for the receiving transaction. This attribute is mandatory when: the document routing is direct delivery or auto-transact code is DELIVER, destination type of the document schedule or document line is Inventory, subinventory is not specified on the document distribution or line (if provided in the document line, the default value is used), or no item transaction default exists (if item transaction default exists, it will be derived).
Locator String Name of the destination locator for the receiving transaction. This is used to derive LocatorId. This attribute or LocatorId is mandatory when: the document routing is direct delivery or auto-transact code is DELIVER, destination type of the document schedule or document line is Inventory, locator control is predefined or dynamic and item transaction defaults or not entered (if item transaction default exists, it will be derived).
LocatorId Long Value that uniquely identifies the destination locator for the receiving transaction. This attribute or Locator is mandatory when: the document routing is direct delivery or auto-transact code is DELIVER, destination type of the document schedule or document line is Inventory, locator control is predefined or dynamic and item transaction defaults or not entered (if item transaction default exists, it will be derived).
Quantity Double Transaction quantity in the unit of measure that the receipt line request or advanced shipment notice (ASN) request uses.
UnitOfMeasure String Unit of measure for the receipt line or ASN line request. This attribute is used to derive UOMCode.
UOMCode String Abbreviation that identifies the unit of measure that the receipt line or advanced shipment notice (ASN) line uses.
PrimaryQuantity Double Transaction quantity in the primary unit of measure that the item uses.
PrimaryUOMCode String Abbreviation that identifies the primary unit of measure that the item in the receiving organization uses.
PrimaryUnitOfMeasure String Primary unit of measure that the item in the receiving organization uses. This attribute is used to derive PrimaryUOMCode.
ProcessingStatusCode String Value that indicates the processing status for the line request. Valid values include PENDING, RUNNING, COMPLETED. The default value is PENDING. Only the interface records with value PENDING will be picked for processing. If there is an error in the derive, default, and validate cycle, the status moves to ERROR. This attribute should be blank during POST operation so that the default value of PENDING is picked.
SecondaryUOMCode String Abbreviation that identifies the secondary unit of measure that the item in the receiving organization uses.
SecondaryUnitOfMeasure String Secondary unit of measure that the item in the receiving organization uses.
SecondaryQuantity Double Transaction quantity in the secondary unit of measure that the item uses.
EmployeeId Long Value that uniquely identifies the employee who performed the receiving transaction. If this attribute is blank during POST or PATCH operation, the value from the header request is used.
EmployeeName String Name of the employee who performed the receiving transaction. This attribute is used to derive the EmployeeId. If this attribute is blank during POST or PATCH operation, the value from the header request is used.
ParentTransactionId Long Value that uniquely identifies the parent receiving transaction. This attribute should not be populated when creating an advanced shipment notice (ASN) or creating a receipt. Since this attribute is applicable only for post receipt transactions, leave this blank.
SourceTransactionNumber String Number that identifies the unique transaction identifier in the source system. This is not applicable when creating an advanced shipment notice (ASN). This attribute should be unique across the application. There can be only one record in receiving transactions for a source transaction number.
ParentSourceTransactionNumber String Number that identifies the source transaction of the parent receiving transaction. This attribute should not be populated when creating a receipt or creating an advanced shipment notice (ASN).
InterfaceSourceCode String Abbreviation that identifies the source that interfaced the receiving transaction. It can be populated with the source application name.
InterfaceSourceLineId Long Value that uniquely identifies the interfaced source line. This can be populated with the identifier of the line in the source application that initiated the receipt.
ShipToLocationCode String Abbreviation that identifies the receiving location. This is used to derive ShipTolocationId. When creating a receipt against in-transit shipment, either ShipToLocationCode or ShipToLocationId must be provided.
ShipToLocationId Long Value that uniquely identifies the receiving location. If this attribute is blank during a POST operation, this is derived from the ShipToLocationId of the source document. When creating a receipt against in-transit shipment, either ShipToLocationCode or ShipToLocationId must be provided.
DeliverToLocationCode String Abbreviation that identifies the deliver-to location. This is used to derive DeliverTolocationId.
DeliverToLocationId Long Value that uniquely identifies the deliver-to location. If this attribute is blank during a POST operation, this is derived from the DeliverToLocationId of the document distribution: purchase order distribution or transfer order distribution. DeliverToLocationId is mandatory when receiving a purchase order or transfer order with expense destination and the receipt routing is direct delivery.
DeliverToPersonId Long Value that uniquely identifies the deliver-to person or requester. If this attribute is blank, this will default to the requester specified on the purchase order distribution or transfer order distribution.
DeliverToPersonName String Name of the deliver-to person or requester. This attribute is used to derive DeliverToPersonId.
RoutingCode String Value that indicates the receiving routing. A list of accepted values is defined in the lookup type RCV_ROUTING_HEADERS.
RoutingHeaderId Long Value that uniquely identifies the receiving routing. Valid values include: 1 for standard receipt, 2 for inspection required, 3 for direct delivery. If this attribute is blank, the value is derived from the document line or schedule.
InspectionQualityCode String Abbreviation that identifies the inspection quality. This attribute is not applicable for a receipt line request or an advanced shipment notice (ASN) line request.
Exception String Value that indicates whether or not the receive transaction being created has an exception. If you want to flag the receiving transaction as an exception, populate this attribute with Y. Else, leave it blank.
RMAReference String Number that identifies the return material authorization that the supplier provides when returning goods to the supplier. This attribute is not currently used.
RMANumber String Number of the return material authorization (RMA) against which the receipt is being created. This attribute along with RMASourceSystemName of the header is used to derive ReceiptAdviceHeaderId. This attribute is mandatory when creating a receipt for RMA.
RMALineNumber String Line number of the return material authorization (RMA) against which the receipt is being created. This attribute is used to derive ReceiptAdviceLineId. This attribute is mandatory when creating a receipt for RMA.
RMAScheduleNumber String Schedule number of the return material authorization against which receipt is being created.
ReceiptAdviceHeaderId Long Value that uniquely identifies the receipt advice header.
ReceiptAdviceLineId Long Value that uniquely identifies the receipt advice line.
CustomerId Long Value that uniquely identifies the customer. This attribute can be blank and the value is derived from the header.
CustomerPartyName String Name of the customer. This attribute can be blank and the value is derived from the header.
CustomerPartyNumber String Number that uniquely identifies the customer. This attribute can be blank and the value is derived from the header.
CustomerItemNumber String Number that the customer uses to identify the item.
CustomerItemId Long Value that the customer uses to uniquely identify the item.
Amount Double Receipt amount in the purchase order currency. This attribute is mandatory when creating a receipt for a fixed price service purchase order line.
CountryOfOriginCode String Abbreviation that identifies the country of manufacture for this item.
CurrencyCode String Abbreviation that identifies the currency that the receiving transaction uses. If you leave this attribute blank, the value from the document is used.
CurrencyConversionDate Date Date when the currency conversion occurred for the receipt. Use this attribute only for a purchase order receipt where the option on the purchase order schedule is Receipt and the order currency is different from the ledger currency of the receiving organization.
CurrencyConversionRate Double Currency conversion rate for the receipt. Use this attribute only for a purchase order receipt where the option on the purchase order schedule is Receipt, the order currency is different from the ledger currency of the receiving organization, and the rate type on the purchase order is User.
FromOrganizationCode String Abbreviation that identifies the source organization for an interorganization transfer. This is applicable for receipts against in-transit shipment or transfer order shipment.
FromOrganizationId Long Value that uniquely identifies the source organization for an in-transit shipment.
ContainerNumber String Container number for the advanced shipment notice (ASN) line request.
SubstituteItemNumber String Substitute item number for the item on the receipt line. This attribute is used to derive SubstituteItemId. This is applicable for purchase order receipts.
SubstituteItemId Long Value that uniquely identifies the substitute item. This is applicable for purchase order receipts.
SubstituteUnorderedCode String Value that indicates whether the transaction is for a substitute item. Enter the value as SUBSTITUTE if you are creating a receipt for a substitute item.
VendorName String Name of the supplier. You can leave this attribute blank.
VendorId Long Value that uniquely identifies the supplier. You can leave this attribute blank.
VendorNumber String Number that identifies the supplier. You can leave this attribute blank.
VendorSiteCode String Abbreviation that identifies the supplier site for a business unit. This attribute is used to derive SupplierSiteId. It is applicable to creating an advanced shipment notice (ASN), receiving an ASN, or receiving a purchase order. You can leave this attribute blank.
VendorSiteId Long Value that uniquely identifies the supplier site. It is applicable to creating an advanced shipment notice (ASN), receiving an ASN, or receiving a purchase order. You can leave this attribute blank.
VendorItemNumber String Number that the supplier uses to identify the item. If a value is entered for this attribute, It must match the supplier item on the purchase order line.
BusinessUnit String Name of the business unit. For a purchase order receipt, this attribute references the procurement business unit of the supplier site. For a receipt that includes a return material authorization, this attribute references the business unit that the return material authorization contains.
BusinessUnitId Long Value that uniquely identifies the business unit. For a purchase order receipt, this attribute references the procurement business unit of the supplier site. For a receipt that includes a return material authorization, this attribute references the business unit that the return material authorization contains. You can leave this attribute blank.
ConsignedLine String Value that indicates whether or not the receiving transaction is for consigned material. If blank for a receipt line request, the value from the document is used.
ReasonId Long Value that uniquely identifies the inventory transaction reason for the receiving transaction.
ReasonName String Name of the inventory transaction reason for the receiving transaction. This attribute is used to derive ReasonId.
PackingSlip String Packing slip number for the container that contains this item. This attribute is applicable when creating an advanced shipment notice (ASN) line request.
Comments String Text that the used entered when receiving the item.
FromSubinventory String Name of the source subinventory for the receiving transaction. This attribute is not currently used.
FromLocator String Name of the source locator for the receiving transaction. This attribute is not currently used.
FromLocatorId Long Value that uniquely identifies the source locator for the receiving transaction. This attribute is not currently used.
TransactionStatusCode String Value that indicates the status of the advanced shipment notice (ASN) line request or receipt transaction request. Valid values include PENDING, RUNNING or ERROR. The default value is PENDING. Only the interface records with value PENDING are picked for processing. If there is an error in running the transaction, the status changes to ERROR. This attribute should be blank during POST operations so that the default value of PENDING is used.
GroupId Long Value that uniquely identifies the group of interface records submitted together for processing.
ExternalSystemPackingUnit String License plate number of the external warehouse management application.
DefaultTaxationCountry String Value that indicates the default taxation country.
DocumentFiscalClassification String Fiscal classification for the document.
FirstPartyRegistrationId Long Value that uniquely identifies the first party registration.
ThirdPartyRegistrationId Long Value that uniquely identifies the third party registration.
TransactionBusinessCategory String Business category of the transaction.
TaxInvoiceNumber String Number of the tax invoice.
TaxInvoiceDate Date Date when the tax invoice is created.
EwayBillNumber Long Number that identifies the electronic waybill provided by supplier for shipment of goods. This value is used to calculate the goods and services tax for India.
EwayBillDate Date Date when the electronic waybill was generated. This value is used to calculate the goods and services tax for India.
UserDefinedFiscalClassification String Value that indicates the fiscal classification defined by the user.
ProductFiscalClassificationId Long Value that uniquely identifies the product fiscal classification.
TaxClassificationCode String Value that indicates the tax classification.
IntendedUseClassificationId Long Value that uniquely identifies the intended use classification.
IntendedUse String Value that indicates the intended use.
ProductCategory String Value that indicates the product category.
AssessableValue Double Assessable value of the transaction for taxation purposes.
FinalDischargeLocationId Long Value that uniquely identifies the final discharge location.
ProductType String Value that indicates the product type for taxation purposes.
FirstPartyRegistrationNumber String Number that is used for the first party registration. This attribute is used to derive FirstPartyRegistrationId.
ThirdPartyRegistrationNumber String Number that is used for the third party registration. This attribute is used to derive ThirdPartyRegistrationId.
ProductFiscalClassName String Name used to indicate the product fiscal classification. This attribute is used to derive ProductFiscalClassificationId.
FinalDischargeLocationCode String Value that indicates the final discharge location. This attribute is used to derive FinalDischargeLocationId.
BarcodeLabel String Label of the barcode on the product. This attribute is applicable only for advanced shipment notice (ASN) line request.
TruckNumber String Number of the truck. This attribute is applicable only for advanced shipment notice (ASN) line request.
InsertAndProcessFlag Bool Contains one of the following values: true or false. If true, then the Manage Receiving Transactions API processes the posted interface data automatically and immediately returns the response. If false, then the records are created in interface tables but no processing is done. These interface records can subsequently processed by the Manage Receiving Transactions scheduled process. The default value is true.
ReturnStatus String Value that indicates the status of the application call that is sent to the client. Values include SUCCESS or ERROR.
LPNId Long Value that uniquely identifies the source license plate number. This attribute should be populated only for an advanced shipment notice (ASN) line request.
LicensePlateNumber String Source license plate number of the advanced shipment notice (ASN) request line. This attribute should be populated only for an advanced shipment notice (ASN) line request.
SaveAndSubmitFlag Bool Contains one of the following values: true or false. If true, then the Manage Receiving Transactions API resubmits the patched interface data automatically and immediately returns the response. If false, then the records are updated in interface tables but not resubmitted. The default value is false.
CreateDebitMemoFlag Bool Contains one of the following values: true or false. If true, then create the debit memo. If false, then do not create the debit memo. The default value is false. This attribute is not currently used.
PhysicalMaterialReturnRequiredFlag Bool Contains one of the following values: true or false. If true, then return against a transfer order requires a physical return of the item. If false, then return against a transfer order does not require a physical return of the item. The default value is false. This attribute is not currently used.
RecallHeaderId Long Value that uniquely identifies the recall notice number. This attribute should only be used for the RETURN TO VENDOR transaction type.
RecallLineId Long Value that uniquely identifies the line corresponding to the recall notice number. This attribute should only be used for the RETURN TO VENDOR transaction type.
RecallLineNumber Long Number that identifies the recall notice line. This attribute should only be used for the RETURN TO VENDOR transaction type.
RecallNoticeNumber String Number that identifies the recall notice. This attribute should only be used for the RETURN TO VENDOR transaction type.
ExternalSystemTransactionReference String Value that contains reference information for the corresponding transaction in external applications. Do not enter this value at line level for RECEIVE or SHIP transactions, the value given at header is copied to lines. This value is entered at line level for other receiving transactions like inspection, put away, correct, and return.
DefaultLotsAndSerialNumbersFromASNFlag Bool Contains one of the following values: true or false. If true, then the lots and serial numbers from an advance shipment notice (ASN) or an advance shipment billing notice (ASBN) will be are defaulted when executing a receipt or a put away transaction. If false, then the lots and serial numbers from an advance shipment notice (ASN) or an advance shipment billing notice (ASBN) will not be defaulted when executing a receipt or a put away transaction. The default value is false.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
FromDate Datetime FromDate
ToDate Datetime ToDate
Finder String finder

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