ReceivingReceiptRequestslines
Manages line-level details for receipt and advance shipment notice (ASN) requests, ensuring accurate and efficient transaction processing.
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | The unique identifier for the header interface of the receipt line request. |
| InterfaceTransactionId [KEY] | Long | A value that uniquely identifies the transaction associated with the receipt line request. |
| HeaderInterfaceId | Long | A value that uniquely identifies the header request associated with this specific receipt line. |
| CreatedBy | String | The username or system identifier of the person or process that created this receipt line request. |
| CreationDate | Datetime | The date and time when the receipt line request was created. |
| LastUpdateDate | Datetime | The date and time when the receipt line request was last updated. |
| LastUpdatedBy | String | The username or system identifier of the person or process that last updated this receipt line request. |
| TransactionType | String | The type of transaction being processed for the receipt line. It can be either 'RECEIVE' or 'SHIP' depending on the context (receiving or shipment of goods). |
| AutoTransactCode | String | An abbreviation that specifies the automatic processing behavior for subsequent transactions. The valid values are 'SHIP', 'RECEIVE', or 'DELIVER'. It controls the behavior for receiving and delivering materials automatically. |
| TransactionDate | Datetime | The date the receipt transaction took place. Used for receipt accounting and related operations, with the default set to the current date and time. |
| OrganizationCode | String | The code that identifies the receiving organization. This is used to derive the organization identifier for receipt processing. |
| OrganizationId | Long | A unique identifier for the receiving organization, either from the organization code or the organization identifier itself. |
| ItemDescription | String | A description of the item in the receipt request. This should match the description on the corresponding purchase order line when applicable. |
| ItemId | Long | The unique identifier of the item in the inventory. Required for ASN or receipt creation. |
| ItemNumber | String | The item number used to identify the item in the inventory system. This is needed for creating ASN or receipts. |
| ItemRevision | String | The revision number for an item, required when the item is revision-controlled in the system. |
| ReceiptSourceCode | String | Identifies the source of the receipt or ASN. Valid values include 'VENDOR', 'INVENTORY', 'TRANSFER ORDER', or 'CUSTOMER'. |
| SourceDocumentCode | String | An abbreviation that specifies the type of source document for the transaction. Examples include 'PO' for purchase orders or 'INVENTORY' for in-transit shipments. |
| DocumentNumber | String | A unique document number that identifies the source document for this transaction, such as a purchase order number or transfer order shipment number. |
| DocumentLineNumber | Long | The line number of the source document associated with the receipt or ASN. |
| DocumentShipmentLineNumber | Long | The schedule line number from the document used to identify when the receipt transaction occurs. |
| DocumentDistributionNumber | Long | The distribution number in case of multiple distributions in a document, typically relevant for purchase orders with multiple distribution lines. |
| PODistributionId | Long | The unique identifier for a specific purchase order distribution, used when receiving a purchase order or ASN. |
| POHeaderId | Long | The identifier for the purchase order header, relevant when processing ASN or receipts for purchase orders. |
| POLineId | Long | The identifier for the purchase order line, relevant when receiving or creating ASN for purchase orders. |
| POLineLocationId | Long | The identifier for the purchase order schedule line, relevant when processing an ASN or receipt. |
| ShipmentHeaderId | Long | A unique identifier for the receipt or shipment header in cases of ASN, in-transit shipments, or transfer orders. |
| ShipmentLineId | Long | The unique identifier for a specific shipment line in cases of ASN, in-transit shipments, or transfer orders. |
| ShipmentNumber | String | The shipment number assigned by the source, corresponding to an ASN, in-transit shipment, or transfer order. |
| ASNLineNumber | Long | The line number on the ASN. It is required alongside ShipmentLineId for ASN receipt. |
| TransferOrderHeaderId | Long | A unique identifier for a transfer order header, used when processing receipts for transfer orders. |
| TransferOrderLineId | Long | A unique identifier for a specific line in a transfer order, used during receipt processing for transfer orders. |
| TransferOrderDistributionId | Long | A unique identifier for a transfer order distribution. Used in cases of multiple distributions and direct routing. |
| SoldtoLegalEntity | String | The name of the legal entity that is the sold-to party for a transaction. It is used to derive the SoldtoLegalEntityId. |
| SoldtoLegalEntityId | Long | A unique identifier for the sold-to legal entity. This is used to determine the purchase order header. |
| DestinationTypeCode | String | Identifies the destination type of the receiving transaction, such as blank, 'RECEIVING', or 'INVENTORY'. |
| Subinventory | String | The destination subinventory for the received items. It must be specified when required by document routing or transaction type. |
| Locator | String | The destination locator for storing received items, derived from predefined controls or transaction defaults. |
| LocatorId | Long | The unique identifier for the destination locator. Required for transactions involving inventory and specific locator control. |
| Quantity | Decimal | The quantity of items being received, expressed in the unit of measure defined for the transaction. |
| UnitOfMeasure | String | The unit of measure for the transaction's quantity, which is used to derive the corresponding UOMCode. |
| UOMCode | String | An abbreviation that identifies the unit of measure for the current receipt or ASN line. |
| PrimaryQuantity | Decimal | The quantity in the primary unit of measure for the item being received. |
| PrimaryUOMCode | String | An abbreviation that identifies the primary unit of measure used by the item in the receiving organization. |
| PrimaryUnitOfMeasure | String | The primary unit of measure used for the item in the receiving organization, derived from system defaults. |
| ProcessingStatusCode | String | The status of the receipt or ASN line request, indicating whether it is 'PENDING', 'RUNNING', or 'COMPLETED'. |
| SecondaryUOMCode | String | The abbreviation for the secondary unit of measure used for the item in the receiving organization. |
| SecondaryUnitOfMeasure | String | The secondary unit of measure for the item, if applicable, in the receiving organization. |
| SecondaryQuantity | Decimal | The transaction quantity in the secondary unit of measure. |
| EmployeeId | Long | The unique identifier of the employee who processed the receiving transaction. |
| EmployeeName | String | The name of the employee who handled the receiving transaction. |
| ParentTransactionId | Long | A unique identifier for the parent transaction of a receiving transaction. This should be left blank for ASN or receipt creation. |
| SourceTransactionNumber | String | A reference number for the source transaction originating the receiving transaction. |
| ParentSourceTransactionNumber | String | The source transaction reference number for the parent of this receiving transaction. |
| InterfaceSourceCode | String | An abbreviation identifying the source system that interfaced the receiving transaction. |
| InterfaceSourceLineId | Long | A unique identifier for the source line in the interfacing system. |
| ShipToLocationCode | String | The receiving location code used to derive the ShipToLocationId. |
| ShipToLocationId | Long | A unique identifier for the receiving location, automatically derived during a POST operation when left blank. |
| DeliverToLocationCode | String | The deliver-to location code, used to derive the DeliverToLocationId. |
| DeliverToLocationId | Long | The unique identifier for the deliver-to location, automatically derived from document distributions. |
| DeliverToPersonId | Long | The unique identifier for the person receiving the goods. Defaults to the person specified in the purchase order distribution. |
| DeliverToPersonName | String | The name of the person receiving the goods. |
| RoutingCode | String | Indicates the receiving routing process, with values defined in the RCV_ROUTING_HEADERS lookup. |
| RoutingHeaderId | Long | The unique identifier for the receiving routing, indicating the process (for example, standard receipt, inspection required, direct delivery). |
| InspectionQualityCode | String | The code identifying the inspection quality, applicable in some receipt or ASN line requests. |
| Exception | String | Flags whether the transaction has an exception. Use 'Y' to mark it as an exception. |
| RMAReference | String | A reference number for the return material authorization provided by the supplier. Currently not in use. |
| RMANumber | String | The RMA number used to identify a return material authorization against which a receipt is created. |
| RMALineNumber | String | The RMA line number associated with the receipt being created. This is mandatory for RMA-related receipts. |
| RMAScheduleNumber | String | The schedule number for the RMA, linked to the receipt being created. |
| ReceiptAdviceHeaderId | Long | The unique identifier for the receipt advice header, linking to the corresponding advice. |
| ReceiptAdviceLineId | Long | The unique identifier for the receipt advice line, linking to the corresponding advice line. |
| CustomerId | Long | The unique identifier for the customer, often derived from the header data. |
| CustomerPartyName | String | The name of the customer, typically derived from the header data. |
| CustomerPartyNumber | String | A customer number identifying the customer party, derived from the header. |
| CustomerItemNumber | String | The item number used by the customer to identify the item. |
| CustomerItemId | Long | The unique identifier used by the customer to track the item. |
| Amount | Decimal | The total receipt amount in the currency used for the purchase order. |
| CountryOfOriginCode | String | The country code identifying where the item was manufactured. |
| CurrencyCode | String | The currency code used for the transaction. Defaults to the document's currency if left blank. |
| CurrencyConversionDate | Date | The date of currency conversion for the receipt, applicable for purchases involving foreign currencies. |
| CurrencyConversionRate | Decimal | The rate at which currency conversion occurred for the receipt, used for foreign transactions. |
| FromOrganizationCode | String | The organization code for the source organization in interorganization transfers, applicable for in-transit shipments. |
| FromOrganizationId | Long | The unique identifier for the source organization in interorganization transfers. |
| ContainerNumber | String | The container number for the ASN line request, relevant for logistics and shipment tracking. |
| SubstituteItemNumber | String | The substitute item number for the item in the receipt line, typically for purchase order receipts. |
| SubstituteItemId | Long | The unique identifier for the substitute item in the receipt line, used for purchase orders. |
| SubstituteUnorderedCode | String | Flags whether the transaction is for a substitute item, indicated as 'SUBSTITUTE'. |
| VendorName | String | The name of the supplier. It can be left blank if not applicable. |
| VendorId | Long | The unique identifier for the supplier, which can be left blank. |
| VendorNumber | String | The number used by the supplier to identify the business. Can be left blank. |
| VendorSiteCode | String | The code identifying the supplier's site. Used to derive the SupplierSiteId. |
| VendorSiteId | Long | The unique identifier for the supplier site. Can be left blank. |
| VendorItemNumber | String | The number used by the supplier to identify the item. Should match the item number on the purchase order. |
| BusinessUnit | String | The business unit associated with the receipt. For purchase orders, this refers to the supplier's procurement business unit. |
| BusinessUnitId | Long | The unique identifier for the business unit, linked to the supplier's business unit for receipts. |
| ConsignedLine | String | Indicates whether the receipt transaction is for consigned material. Left blank for non-consigned items. |
| ReasonId | Long | The unique identifier for the reason associated with an inventory transaction for the receiving process. |
| ReasonName | String | The name of the reason for the inventory transaction, linked to ReasonId. |
| PackingSlip | String | The packing slip number for the container, required for ASN line requests. |
| Comments | String | User-provided text for comments when receiving the item. |
| FromSubinventory | String | The source subinventory for the receiving transaction, not currently in use. |
| FromLocator | String | The source locator for the receiving transaction, not currently in use. |
| FromLocatorId | Long | The unique identifier for the source locator, not currently in use. |
| TransactionStatusCode | String | The status of the ASN or receipt transaction request, with possible values 'PENDING', 'RUNNING', or 'ERROR'. |
| GroupId | Long | The identifier for a group of interface records that are submitted for processing together. |
| ExternalSystemPackingUnit | String | The license plate number from the external warehouse management system. |
| DefaultTaxationCountry | String | The default country code for taxation purposes. |
| DocumentFiscalClassification | String | The fiscal classification of the document for tax reporting. |
| FirstPartyRegistrationId | Long | The unique identifier for the first party registration related to the transaction. |
| ThirdPartyRegistrationId | Long | The unique identifier for the third-party registration in the transaction. |
| TransactionBusinessCategory | String | The business category associated with the transaction. |
| TaxInvoiceNumber | String | The invoice number for taxation purposes. |
| TaxInvoiceDate | Date | The date the tax invoice was created. |
| EwayBillNumber | Long | The electronic waybill number for shipments to India, relevant for goods and services tax calculations. |
| EwayBillDate | Date | The date the electronic waybill was generated. |
| UserDefinedFiscalClassification | String | The fiscal classification defined by the user for the transaction. |
| ProductFiscalClassificationId | Long | The unique identifier for the product fiscal classification. |
| TaxClassificationCode | String | The tax classification code used for the transaction. |
| IntendedUseClassificationId | Long | The unique identifier for the intended use classification. |
| IntendedUse | String | The intended use for the product, affecting taxation or regulatory processes. |
| ProductCategory | String | The category under which the product is classified. |
| AssessableValue | Decimal | The assessable value for taxation purposes in the transaction. |
| FinalDischargeLocationId | Long | The unique identifier for the final discharge location. |
| ProductType | String | The product type used for taxation purposes. |
| FirstPartyRegistrationNumber | String | The registration number for the first party, used to derive the FirstPartyRegistrationId. |
| ThirdPartyRegistrationNumber | String | The registration number for the third party, used to derive the ThirdPartyRegistrationId. |
| ProductFiscalClassName | String | The name associated with the product fiscal classification, used to derive the ProductFiscalClassificationId. |
| FinalDischargeLocationCode | String | The discharge location code, derived from FinalDischargeLocationId. |
| BarcodeLabel | String | The barcode label used for the product in the ASN line request. |
| TruckNumber | String | The truck number used for ASN line requests in shipment tracking. |
| InsertAndProcessFlag | Bool | Determines whether the Manage Receiving Transactions API should process the posted interface data automatically. |
| ReturnStatus | String | The status of the application call processing, including values like 'SUCCESS', 'ERROR', 'SUBMITTED', or 'QUEUED'. |
| LPNId | Long | The identifier for the license plate number in the external system for ASN line requests. |
| LicensePlateNumber | String | The license plate number for the source ASN line request. |
| SaveAndSubmitFlag | Bool | Indicates whether the Manage Receiving Transactions API should automatically resubmit updated data. |
| CreateDebitMemoFlag | Bool | Indicates whether a debit memo should be created for the transaction. Not currently used. |
| PhysicalMaterialReturnRequiredFlag | Bool | Indicates whether physical return is required for a transfer order. Not currently in use. |
| RecallHeaderId | Long | The unique identifier for the recall notice number, used only for RETURN TO VENDOR transactions. |
| RecallLineId | Long | The unique identifier for the recall line number in RETURN TO VENDOR transactions. |
| RecallLineNumber | Long | The line number for the recall notice, used in RETURN TO VENDOR transactions. |
| RecallNoticeNumber | String | The number of the recall notice in RETURN TO VENDOR transactions. |
| ExternalSystemTransactionReference | String | A reference for transactions in external applications, particularly in receiving or return processes. |
| DefaultLotsAndSerialNumbersFromASNFlag | Bool | Indicates whether lots and serial numbers from an ASN should be automatically defaulted in receipts or put away. |
| DefaultLotsAndSerialNumbersFromTransferOrderFlag | Bool | Indicates whether lots and serial numbers from a transfer order should be automatically defaulted in receipts or put away. |
| ReturnMessage | String | Contains the message returned to the caller after processing the input payload asynchronously. |
| Finder | String | The finder method used for retrieving receiving receipt request lines. |
| FromDate | Datetime | The start date for filtering receiving receipt request lines. |
| ToDate | Datetime | The end date for filtering receiving receipt request lines. |