ReceivingReceiptRequests
Handles receipt requests and advance shipment notices, supporting integration with Oracle Fusion applications.
Columns
| Name | Type | Description |
| HeaderInterfaceId [KEY] | Long | Unique identifier for the receipt request header used for tracking and reference purposes in the system. |
| ASNType | String | Indicates the type of receiving request. Possible values include ASN (Advanced Shipment Notice), ASBN (Advanced Shipment Billing Notice), and STD (Standard Receipt Requests). The default value is STD. |
| CreatedBy | String | The individual or process that created the receiving receipt request. |
| CreationDate | Datetime | The timestamp indicating when the receiving receipt request was created. |
| LastUpdateDate | Datetime | The timestamp when the last update was made to the receiving receipt request. |
| LastUpdatedBy | String | The individual or process that last updated the receiving receipt request. |
| ReceiptSourceCode | String | Identifies the origin of the receipt request. Common values include SUPPLIER (for purchase orders), CUSTOMER (for returns), INVENTORY (for in-transit shipments), and TRANSFER ORDER (for transfer order receipts). This is a mandatory field. |
| TransactionDate | Date | The date on which the receipt request is submitted into the system. By default, this will be set to the current date. |
| ShipmentNumber | String | The number assigned to the shipment by the source entity, which could correspond to ASN, in-transit shipments, or transfer order shipments. |
| ReceiptNumber | String | Unique identifier for the receipt of items at the warehouse. If receipt generation is automatic, this value will be blank. |
| ReceiptHeaderId | Long | Unique ID for the receipt or shipment in the system. This is required when adding lines to a receipt, for example, for purchase orders or return material authorizations (RMAs). |
| VendorName | String | The name of the vendor or supplier associated with the receipt request. It helps derive the vendor identifier. |
| VendorNumber | String | The number that uniquely identifies the supplier in the system. This is required along with other identifiers to create ASN or purchase order receipts. |
| VendorId | Long | Unique identifier for the supplier in the system. Used to create ASN or purchase order receipts. |
| VendorSiteCode | String | The abbreviation identifying the supplier site related to the receipt request, ensuring alignment with purchase orders or ASNs. |
| VendorSiteId | Long | Unique identifier for the supplier site in the system, used to reference specific supplier locations. |
| BusinessUnitId | Long | Unique identifier for the business unit, linking the receipt request to the procurement unit for purchase orders or to the RMA unit for RMAs. |
| BusinessUnit | String | The name of the business unit, which is used to derive the business unit identifier and the supplier site code. |
| OrganizationCode | String | Abbreviation identifying the receiving organization for the receipt request or ASN. It must match the corresponding organization code or identifier for valid receipt creation. |
| OrganizationId | Long | Unique identifier for the receiving organization, required for processing receipt requests or ASNs. |
| ShippedDate | Datetime | The date when the shipment was dispatched by the supplier according to the ASN. |
| ExpectedReceiptDate | Datetime | The anticipated date of arrival for the shipment associated with the ASN. |
| FreightTerms | String | The terms governing the payment responsibility for shipping costs, which could be assigned to the buyer or seller. |
| FreightCarrierId | Long | Unique identifier for the freight carrier handling the shipment. |
| FreightCarrierName | String | The name of the freight carrier associated with the shipment, used to derive the carrier’s identifier. |
| NumberOfPackingUnits | Long | Indicates how many containers or packing units are included in the shipment. |
| BillOfLading | String | The bill of lading number identifying the shipment, which provides details of the cargo's transportation. |
| WaybillAirbillNumber | String | The unique number identifying the waybill or airbill for the shipment or receipt. |
| PackingSlip | String | The number identifying the packing slip associated with the container in the shipment or receipt. |
| PackagingCode | String | The packaging code that identifies the type of material being transported, based on international guidelines for hazardous goods. |
| SpecialHandlingCode | String | The code representing any special handling requirements for the transported goods. |
| TarWeight | Decimal | The tare weight of the vehicle or container, used for calculating the net weight of the goods by subtracting from the gross weight. |
| TarWeightUOMCode | String | Abbreviation for the unit of measure (UOM) used for the tare weight of the shipment. |
| TarWeightUnitOfMeasure | String | The full description of the unit of measure used for the tare weight of the shipment. |
| NetWeight | Decimal | The weight of the goods in the shipment, excluding the packaging. |
| NetWeightUOMCode | String | Abbreviation for the unit of measure (UOM) used for the net weight of the shipment. |
| NetWeightUnitOfMeasure | String | The full description of the unit of measure used for the net weight of the shipment. |
| Comments | String | Optional notes or additional information provided for the receipt request or ASN. |
| CustomerPartyName | String | The customer’s name, used to derive the customer identifier for RMA receipt requests. |
| CustomerPartyNumber | String | The customer’s number, used alongside the customer name to derive the customer identifier for RMA receipts. |
| CustomerId | Long | Unique identifier for the customer in the RMA receipt process. |
| EmployeeName | String | The name of the employee creating the receipt, which helps to derive their employee or contingent worker identifier. |
| EmployeeId | Long | Unique identifier for the employee or contingent worker processing the receipt. |
| FromOrganizationCode | String | Abbreviation identifying the source organization for in-transit shipments or transfer orders. |
| FromOrganizationId | Long | Unique identifier for the source organization from which the in-transit shipment or transfer order originates. |
| RMASourceSystemId | Long | Unique identifier for the source application from which the RMA is generated. |
| RMASourceSystemName | String | The name of the source application used to generate the RMA receipt. |
| GroupId | Long | Unique identifier for the group of interface records submitted together for processing. |
| ProcessingStatusCode | String | Indicates the current processing status of the receipt request. Possible values include PENDING, ERROR, or SUCCESS. Records with a status of PENDING are eligible for processing. |
| GLDate | Date | The date the receipt request is recorded in the general ledger. |
| InvoiceDate | Date | The due date for the invoice associated with the shipment or billing notice, including any ASN with billing information. |
| InvoiceNumber | String | The number assigned to the invoice related to the shipment or billing notice. |
| TotalInvoiceAmount | Decimal | The total amount invoiced for the shipment or billing notice, including any ASN with billing information. |
| FreightAmount | Decimal | The amount charged for the delivery of goods, determined by various factors like transport mode, weight, and distance. |
| TaxAmount | Decimal | The tax amount applied to the shipment or billing notice, based on applicable tax rates. |
| PaymentTermsId | Long | Unique identifier for the payment terms associated with an ASN or ASBN. |
| PaymentTermsName | String | The name of the payment terms, which defines the schedule for payments and any associated discounts. |
| CurrencyCode | String | The currency code used for the invoice amount in the associated billing notice. |
| InsertAndProcessFlag | Bool | A flag indicating whether the data should be processed immediately or just inserted into interface tables for later processing. |
| ReturnStatus | String | Indicates the status of the application call sent to the client. For synchronous processing, values include SUCCESS or ERROR; for asynchronous processing, values include SUBMITTED or QUEUED. |
| SaveAndSubmitFlag | Bool | A flag indicating whether the interface data should be resubmitted after being patched or just updated in interface tables. |
| ExternalSystemTransactionReference | String | Reference identifier for the transaction in an external system. |
| ReturnMessage | String | Message returned to the caller when the input payload is processed asynchronously, indicating success, error, or other processing information. |
| DocumentNumber | String | Document number associated with the receiving receipt request. |
| Finder | String | Search criteria or reference for finding specific receiving receipt requests. |
| FromDate | Datetime | The starting date for the receiving receipt request processing range. |
| ItemId | Long | Unique identifier for the item associated with the receipt request. |
| ItemNumber | String | The item number associated with the receipt request. |
| POHeaderId | Long | Unique identifier for the purchase order header linked to the receipt request. |
| ReceiptAdviceHeaderId | Long | Unique identifier for the receipt advice header associated with the receipt. |
| RMANumber | String | The number associated with the RMA linked to the receipt. |
| ShipmentHeaderId | Long | Unique identifier for the shipment header in the receiving receipt request. |
| SourceDocumentCode | String | Code identifying the source document related to the receiving receipt request. |
| ToDate | Datetime | The end date for the receiving receipt request processing range. |
| TransactionStatusCode | String | Status code for the transaction, such as PENDING, ERROR, or SUCCESS. |
| TransactionType | String | Type of transaction being processed, such as receipt, ASN, or RMA. |
| TransferOrderHeaderId | Long | Unique identifier for the transfer order header related to the receipt request. |