LinesToInspect
Handles management of received lines flagged for inspection, ensuring quality and compliance in received goods.
Columns
| Name | Type | Description |
| ToOrganizationCode | String | The unique identifier for the destination organization related to this transaction in the LinesToInspect table. |
| ToOrganizationId | Long | The numerical ID of the destination organization involved in this transaction within the LinesToInspect table. |
| FromOrganizationName | String | The name of the organization from which the item is being transferred, as recorded in the LinesToInspect table. |
| FromOrganizationCode | String | The unique identifier code of the originating organization for this transaction in the LinesToInspect table. |
| FromOrganizationId | Long | The numerical ID of the originating organization involved in this transaction within the LinesToInspect table. |
| ItemNumber | String | The identifier for the item being inspected, as referenced in the LinesToInspect table. |
| ItemDescription | String | A detailed description of the item associated with this transaction, as stored in the LinesToInspect table. |
| ItemId | Long | A unique numerical ID for the item, used to reference it across different systems or transactions in the LinesToInspect table. |
| ItemRevision | String | The revision number or identifier for the version of the item being inspected, as per the LinesToInspect table. |
| ReceiptNumber | String | The receipt number associated with the transaction in the LinesToInspect table, used for tracking the received goods. |
| LineStatus | String | The current status of the transaction line, indicating whether it is open, closed, or pending in the LinesToInspect table. |
| DocumentType | String | The type of document associated with the transaction, such as a purchase order or receipt, as recorded in the LinesToInspect table. |
| SourceDocumentCode | String | The identifier for the original document that initiated this transaction, as tracked in the LinesToInspect table. |
| DocumentNumber | String | The number assigned to the document, such as a purchase order or receipt, which is related to this transaction. |
| DocumentLineNumber | String | The line number within the document, used to uniquely identify this transaction line in relation to the original document. |
| DocumentScheduleNumber | String | The number that identifies the schedule within the document, which is used to manage the timeline of the transaction. |
| TransactionDate | Date | The date when the transaction occurred, as recorded in the LinesToInspect table, used for financial and logistical tracking. |
| VendorName | String | The name of the vendor from whom the item is being purchased or transferred, as stored in the LinesToInspect table. |
| VendorId | Long | A unique numerical identifier for the vendor involved in the transaction, used for reference in the LinesToInspect table. |
| VendorSiteCode | String | The unique code for the vendor's site, representing the specific location from which the item is being sourced. |
| VendorSiteId | Long | A numerical identifier for the vendor site, used to link the transaction to a specific site within the vendor's network. |
| VendorItemNumber | String | The identifier for the item as used by the vendor, used for reference in transactions involving the vendor. |
| TOShipmentNumber | String | The shipment number associated with a transfer order, used to track the movement of goods. |
| ASNType | String | The type of Advanced Shipping Notice (ASN) related to the item, used for shipment tracking and verification. |
| ASNNumber | String | The unique identifier for the ASN, which provides information about a shipment, including contents and expected arrival. |
| ASNLineNumber | Long | The specific line number within the ASN, which helps identify the exact details of an item in a shipment. |
| CustomerPartyName | String | The name of the customer receiving the goods, as recorded in the LinesToInspect table. |
| CustomerId | Long | The numerical identifier for the customer, used to link the transaction to the specific customer involved. |
| AvailableQuantity | Decimal | The quantity of the item available for inspection or transaction, as stored in the LinesToInspect table. |
| UOMCode | String | The code that represents the unit of measure for the item, such as 'EA' for each or 'LB' for pounds. |
| UnitOfMeasure | String | The full name of the unit of measure for the item, providing a more readable form of the UOM code. |
| SecondaryAvailableQuantity | Decimal | The secondary quantity available, measured in a different unit of measure, often used for different packaging or measuring systems. |
| SecondaryUOMCode | String | The code for the secondary unit of measure, used to describe the alternate measurement system for the item. |
| SecondaryUnitOfMeasure | String | The full name of the secondary unit of measure, providing more detail about the alternate measurement unit used. |
| DestinationType | String | The type of destination for the goods, such as a warehouse, store, or customer location. |
| DestinationTypeCode | String | A code representing the specific type of destination, used for logistics and inventory tracking. |
| Location | String | The physical location within the organization where the item is stored or where it is being sent. |
| LocationId | Long | A unique identifier for the location within the organization where the item is stored or processed. |
| Routing | String | The routing information indicating the path the item should take during transportation or movement within the organization. |
| RoutingHeaderId | Long | A unique identifier for the routing header, used to link routing instructions to a specific transaction. |
| POHeaderId | Long | The identifier for the purchase order header, linking this transaction to the related purchase order. |
| POLineLocationId | Long | The identifier for the location of a specific purchase order line item, used to track its position. |
| POLineId | Long | The numerical ID for the purchase order line item, linking the item to a specific line in the purchase order. |
| PORevisionNumber | Long | The revision number for the purchase order, used to track changes or updates to the original purchase order. |
| ShipmentHeaderId | Long | The unique identifier for the shipment header, used to link the shipment details to this transaction. |
| ShipmentLineId | Long | The unique identifier for the shipment line, linking the specific transaction line to the overall shipment. |
| TransferOrderHeaderId | Long | The unique identifier for the transfer order header, used to associate the transaction with a specific transfer order. |
| TransferOrderLineId | Long | The unique identifier for the line item within the transfer order, linking it to a specific item in the transfer process. |
| TransferOrderDistId | Long | The unique identifier for the distribution line within the transfer order, used for detailed tracking. |
| ReceiptAdviceHeaderId | Long | The identifier for the receipt advice header, linking the receipt advice document to this transaction. |
| ReceiptAdviceLineId | Long | The line item ID for the receipt advice, used to link the transaction to a specific line in the receipt advice. |
| ReceiptSourceCode | String | The code identifying the source of the receipt, such as the shipping method or supplier. |
| ConsignedItems | String | A flag or indicator showing whether the items are consigned, meaning they are provided for inspection or use without an immediate transfer of ownership. |
| BackToBack | String | An indicator of whether this transaction is part of a back-to-back arrangement, often used in supply chain contexts. |
| CategoryName | String | The name of the category under which the item is classified, such as electronics, apparel, or furniture. |
| CategoryId | Long | The unique identifier for the item category, used to group similar items for reporting and analysis. |
| CurrencyCode | String | The currency code used for pricing and transaction amounts, such as 'USD' for U.S. dollars or 'EUR' for euros. |
| CurrencyConversionRate | Decimal | The rate used to convert amounts from one currency to another, ensuring accurate financial transactions across different currencies. |
| CurrencyConversionDate | Date | The date when the currency conversion rate was applied, relevant for financial reporting and historical transactions. |
| CurrencyConversionType | String | The type of currency conversion method used, such as spot rates or average rates. |
| ParentTransactionType | String | The type of the parent transaction, used to identify the broader context in which this transaction occurs. |
| ParentTransactionId [KEY] | Long | The unique ID of the parent transaction, linking this transaction to its larger context or related transactions. |
| InspectionStatus | String | The current status of the inspection for the item, such as 'pending', 'completed', or 'failed'. |
| InspectionStatusCode | String | A code representing the status of the inspection, used for quick reference and reporting. |
| PrimaryUOMCode | String | The code for the primary unit of measure, typically the most commonly used unit for the item in this transaction. |
| Reason | String | The reason for the transaction or action, such as a return, exchange, or discrepancy. |
| ReasonId | Long | A unique identifier for the reason, used for categorizing and analyzing different types of transactions or actions. |
| ReceiptException | String | An indicator of any exceptions or issues encountered during the receipt of the goods, such as discrepancies or damages. |
| EmployeeName | String | The name of the employee associated with the transaction, used for audit and tracking purposes. |
| EmployeeId | Long | A unique identifier for the employee involved in the transaction, used for payroll or operational tracking. |
| Comments | String | Any additional comments or notes regarding the transaction, providing context or further details for future reference. |
| Subinventory | String | The specific subinventory or warehouse location where the item is stored or being inspected. |
| Locator | String | The specific locator or shelf location within the subinventory or warehouse where the item is kept. |
| LocatorId | Long | A unique identifier for the locator or shelf where the item is stored within the warehouse. |
| BindASNLineNumber | Long | The line number associated with the ASN (Advanced Shipping Notice) in the bound data, used to identify the item in the shipment. |
| BindASNNumber | String | The ASN number bound to this transaction, used for shipment tracking and inventory reconciliation. |
| BindBackToBack | String | An indicator showing whether the transaction is linked to a back-to-back order, typically for supply chain or vendor-managed inventory. |
| BindConsigned | String | Indicates whether the transaction involves consigned inventory, meaning the items are provided for use but remain owned by the supplier. |
| BindDocumentLineNumber | String | The line number of the bound document, used to track specific line items in the original document related to this transaction. |
| BindDocumentNumber | String | The number of the document bound to the transaction, providing a reference for the original source document. |
| BindDocumentScheduleNumber | String | The schedule number of the document bound to the transaction, which helps with timing and planning. |
| BindDocumentType | String | The type of document bound to the transaction, such as a purchase order, sales order, or shipping notice. |
| BindFromDate | Date | The start date for the bound transaction range, indicating the period of relevance for the transaction. |
| BindItemId | Long | The unique identifier for the item being bound to this transaction, linking it to inventory or purchase orders. |
| BindItemNumber | String | The item number being bound to the transaction, used for tracking and referencing the item in various systems. |
| BindOrganizationCode | String | The organization code associated with the bound data, used to identify the source or destination organization for the transaction. |
| BindOrganizationId | Long | The organization ID associated with the bound data, providing a unique reference for the organization. |
| BindParentTransactionId | Long | The parent transaction ID bound to this transaction, linking it to the overarching process or transaction. |
| BindPOHeaderId | Long | The purchase order header ID bound to this transaction, linking it to the purchase order details. |
| BindPOLineId | Long | The purchase order line ID bound to this transaction, linking it to specific items in the purchase order. |
| BindPOLineLocationId | Long | The location ID of the purchase order line bound to this transaction, used for inventory and logistics purposes. |
| BindReceiptAdviceHeaderId | Long | The receipt advice header ID bound to this transaction, linking it to the receipt advice document for verification. |
| BindReceiptAdviceLineId | Long | The line ID of the receipt advice bound to this transaction, identifying specific items within the receipt advice. |
| BindReceiptNumber | String | The receipt number bound to this transaction, used for tracking the receipt of goods or services. |
| BindShipmentHeaderId | Long | The shipment header ID bound to this transaction, linking it to the related shipment document. |
| BindShipmentLineId | Long | The shipment line ID bound to this transaction, linking the transaction to specific items within the shipment. |
| BindSourceDocumentCode | String | The source document code bound to this transaction, identifying the origin of the transaction in another system. |
| BindToDate | Date | The end date for the bound transaction range, indicating when the transaction was finalized or concluded. |
| BindTransferOrderHeaderId | Long | The transfer order header ID bound to this transaction, linking it to a specific transfer order. |
| BindTransferOrderLineId | Long | The transfer order line ID bound to this transaction, linking it to a specific item in a transfer order. |
| Finder | String | The unique identifier used to search or filter for specific records in the LinesToInspect table. |