LinesToCorrect
Manages inventory lines flagged for correction, ensuring accuracy in inventory adjustments and records.
Columns
| Name | Type | Description |
| ToOrganizationCode | String | The unique code representing the destination organization for the item in the LinesToCorrect table. |
| ToOrganizationId | Long | The unique identifier for the destination organization associated with the line in the LinesToCorrect table. |
| FromOrganizationCode | String | The unique code representing the originating organization for the item in the LinesToCorrect table. |
| FromOrganizationId | Long | The unique identifier for the originating organization associated with the line in the LinesToCorrect table. |
| ItemNumber | String | The unique item number associated with the line item in the LinesToCorrect table. |
| ItemId | Long | The unique identifier for the item in the LinesToCorrect table. |
| ItemDescription | String | A description of the item associated with the line in the LinesToCorrect table. |
| ItemRevision | String | The revision number of the item in the LinesToCorrect table, indicating any changes or updates. |
| ReceiptNumber | String | The unique receipt number associated with the line in the LinesToCorrect table. |
| LineStatus | String | The current status of the line item in the LinesToCorrect table, indicating its processing state. |
| DocumentType | String | The type of document associated with the line item in the LinesToCorrect table (for example, invoice, order). |
| SourceDocumentCode | String | The unique code identifying the source document for the line item in the LinesToCorrect table. |
| DocumentNumber | String | The unique document number for the document associated with the line item in the LinesToCorrect table. |
| DocumentLineNumber | String | The line number within the document, used to identify the specific line item in the document in the LinesToCorrect table. |
| DocumentScheduleNumber | String | The schedule number from the document related to the line item in the LinesToCorrect table. |
| DocumentDistributionNumber | Decimal | The distribution number for the document associated with the line item, indicating its specific allocation. |
| TransactionDate | Date | The date when the transaction related to the line item in the LinesToCorrect table occurred. |
| VendorName | String | The name of the vendor supplying the item associated with the line in the LinesToCorrect table. |
| VendorId | Long | The unique identifier for the vendor supplying the item in the LinesToCorrect table. |
| VendorSiteCode | String | The code representing the specific site of the vendor for the item in the LinesToCorrect table. |
| VendorSiteId | Long | The unique identifier for the vendor site associated with the line item in the LinesToCorrect table. |
| VendorItemNumber | String | The item number assigned by the vendor for the item in the LinesToCorrect table. |
| TOShipmentNumber | String | The unique shipment number for the transfer order related to the line item in the LinesToCorrect table. |
| ASNNumber | String | The Advanced Shipment Notice (ASN) number for the line item in the LinesToCorrect table. |
| ASNLineNumber | Decimal | The line number within the ASN related to the line item in the LinesToCorrect table. |
| CustomerPartyName | String | The name of the customer party involved in the transaction for the line item in the LinesToCorrect table. |
| CustomerId | Long | The unique identifier for the customer associated with the line item in the LinesToCorrect table. |
| AvailableQuantity | Decimal | The available quantity of the item to be processed in the LinesToCorrect table. |
| UOMCode | String | The code representing the unit of measure (UOM) used for the item in the LinesToCorrect table. |
| UnitOfMeasure | String | The unit of measure describing how the item quantity is tracked in the LinesToCorrect table. |
| SecondaryAvailableQuantity | Decimal | The available quantity of the item in an alternate unit of measure for the line item in the LinesToCorrect table. |
| SecondaryUOMCode | String | The code for the secondary unit of measure used for the item in the LinesToCorrect table. |
| SecondaryUnitOfMeasure | String | The secondary unit of measure used for the item, providing an alternate method for quantity tracking in the LinesToCorrect table. |
| DestinationType | String | The type of destination (for example, warehouse, customer) for the item in the LinesToCorrect table. |
| DestinationTypeCode | String | The specific code representing the type of destination for the line item in the LinesToCorrect table. |
| Location | String | The location where the item is stored or shipped from, as associated with the line item in the LinesToCorrect table. |
| LocationId | Long | The unique identifier for the location associated with the line item in the LinesToCorrect table. |
| Routing | String | The routing or transportation path used for the item to reach its destination in the LinesToCorrect table. |
| RoutingHeaderId | Long | The unique identifier for the routing header associated with the line item in the LinesToCorrect table. |
| POHeaderId | Long | The unique identifier for the purchase order header associated with the line item in the LinesToCorrect table. |
| POLineLocationId | Long | The unique identifier for the location associated with the purchase order line item in the LinesToCorrect table. |
| POLineId | Long | The unique identifier for the purchase order line associated with the line item in the LinesToCorrect table. |
| PODistributionId | Long | The unique identifier for the distribution of the purchase order line item in the LinesToCorrect table. |
| ShipmentHeaderId | Long | The unique identifier for the shipment header related to the line item in the LinesToCorrect table. |
| ShipmentLineId | Long | The unique identifier for the shipment line related to the line item in the LinesToCorrect table. |
| TransferOrderHeaderId | Long | The unique identifier for the transfer order header related to the line item in the LinesToCorrect table. |
| TransferOrderLineId | Long | The unique identifier for the transfer order line associated with the line item in the LinesToCorrect table. |
| TransferOrderDistId | Long | The unique identifier for the transfer order distribution associated with the line item in the LinesToCorrect table. |
| ReceiptAdviceHeaderId | Long | The unique identifier for the receipt advice header related to the line item in the LinesToCorrect table. |
| ReceiptAdviceLineId | Long | The unique identifier for the receipt advice line associated with the line item in the LinesToCorrect table. |
| ReceiptSourceCode | String | The code indicating the source of the receipt related to the line item in the LinesToCorrect table. |
| ConsignedItems | String | Indicates whether the items are consigned, meaning they belong to the supplier but are stored at the buyer's location. |
| BackToBack | String | Indicates whether the transaction is part of a back-to-back order, typically used in procurement or sales scenarios. |
| CategoryName | String | The name of the category to which the item belongs in the LinesToCorrect table. |
| CategoryId | Long | The unique identifier for the category associated with the item in the LinesToCorrect table. |
| CurrencyCode | String | The currency code used for the monetary values related to the line item in the LinesToCorrect table. |
| CurrencyConversionRate | Decimal | The exchange rate used to convert between currencies for the transaction associated with the line item in the LinesToCorrect table. |
| CurrencyConversionDate | Date | The date on which the currency conversion rate was applied for the line item in the LinesToCorrect table. |
| CurrencyConversionType | String | The type of currency conversion applied (for example, spot rate, average rate) for the line item in the LinesToCorrect table. |
| InventoryTransactionTypeId | Long | The unique identifier for the inventory transaction type associated with the line item in the LinesToCorrect table. |
| ParentTransactionType | String | The type of the parent transaction from which the current transaction derives its context. |
| ParentTransactionId [KEY] | Long | The unique identifier for the parent transaction related to the line item in the LinesToCorrect table. |
| GrandParentTransactionId | Long | The unique identifier for the grandparent transaction, indicating an even higher-level parent relationship in the LinesToCorrect table. |
| Reason | String | The reason for the transaction or adjustment made in relation to the line item in the LinesToCorrect table. |
| ReasonId | Long | The unique identifier for the reason associated with the line item adjustment in the LinesToCorrect table. |
| ReceiptException | String | Indicates any exceptions or issues encountered during the receipt process for the line item in the LinesToCorrect table. |
| EmployeeName | String | The name of the employee responsible for or associated with the line item in the LinesToCorrect table. |
| EmployeeId | Long | The unique identifier for the employee associated with the line item in the LinesToCorrect table. |
| Subinventory | String | The specific subinventory within a warehouse where the item is located or managed in the LinesToCorrect table. |
| Locator | String | The exact locator or bin within the subinventory where the item is stored in the LinesToCorrect table. |
| LocatorId | Long | The unique identifier for the locator associated with the line item in the LinesToCorrect table. |
| BindASNLineNumber | Long | The line number of the ASN associated with the line item in the LinesToCorrect table. |
| BindASNNumber | String | The ASN number associated with the line item in the LinesToCorrect table. |
| BindBackToBack | String | Indicates whether the line item is part of a back-to-back order in the LinesToCorrect table. |
| BindConsigned | String | Indicates whether the line item is consigned in the LinesToCorrect table. |
| BindDocumentDistributionNumber | Long | The distribution number of the document related to the line item in the LinesToCorrect table. |
| BindDocumentLineNumber | String | The document line number of the transaction associated with the line item in the LinesToCorrect table. |
| BindDocumentNumber | String | The document number associated with the line item in the LinesToCorrect table. |
| BindDocumentScheduleNumber | String | The document schedule number associated with the line item in the LinesToCorrect table. |
| BindDocumentType | String | The document type associated with the line item in the LinesToCorrect table. |
| BindFromDate | Date | The start date from which the line item data is relevant for filtering in the LinesToCorrect table. |
| BindItemId | Long | The item ID for the line item in the LinesToCorrect table, used for filtering. |
| BindItemNumber | String | The item number for the line item in the LinesToCorrect table, used for filtering. |
| BindOrganizationCode | String | The organization code for the line item in the LinesToCorrect table, used for filtering. |
| BindOrganizationId | Long | The organization ID for the line item in the LinesToCorrect table, used for filtering. |
| BindParentTransactionId | Long | The parent transaction ID associated with the line item in the LinesToCorrect table, used for filtering. |
| BindPODistributionId | Long | The purchase order distribution ID for the line item in the LinesToCorrect table, used for filtering. |
| BindPOHeaderId | Long | The purchase order header ID for the line item in the LinesToCorrect table, used for filtering. |
| BindPOLineId | Long | The purchase order line ID for the line item in the LinesToCorrect table, used for filtering. |
| BindPOLineLocationId | Long | The purchase order line location ID for the line item in the LinesToCorrect table, used for filtering. |
| BindReceiptAdviceHeaderId | Long | The receipt advice header ID for the line item in the LinesToCorrect table, used for filtering. |
| BindReceiptAdviceLineId | Long | The receipt advice line ID for the line item in the LinesToCorrect table, used for filtering. |
| BindReceiptNumber | String | The receipt number for the line item in the LinesToCorrect table, used for filtering. |
| BindShipmentHeaderId | Long | The shipment header ID for the line item in the LinesToCorrect table, used for filtering. |
| BindShipmentLineId | Long | The shipment line ID for the line item in the LinesToCorrect table, used for filtering. |
| BindSourceDocumentCode | String | The source document code for the line item in the LinesToCorrect table, used for filtering. |
| BindToDate | Date | The end date up to which the line item data is relevant for filtering in the LinesToCorrect table. |
| BindTOShipment | String | The transfer order shipment number for the line item in the LinesToCorrect table. |
| BindTransferOrderDistId | Long | The transfer order distribution ID for the line item in the LinesToCorrect table, used for filtering. |
| BindTransferOrderHeaderId | Long | The transfer order header ID for the line item in the LinesToCorrect table, used for filtering. |
| BindTransferOrderLineId | Long | The transfer order line ID for the line item in the LinesToCorrect table, used for filtering. |
| Finder | String | The finder query parameter used to locate line items in the LinesToCorrect table. |