Item Entry Relation Table
Relates item ledger entries to the associated posted document line when carrying item tracking.
An "ordinary" posted line not carrying item tracking will always be related to only one item ledger entry, and this relation is managed by registering the entry number in a field on the posted line, for example the Item Shpt. Entry No. field on a posted sales shipment line.
However, from one posted document line carrying four serial numbers, there will be four item ledger entries and, therefore, the Item Entry Relation table is needed to manage the one-to-many relation during posting and lookup.
The "ordinary" relation field on the line will be empty if the document line carries item tracking.
List of Fields in the Table
To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.
| Field | Location |
|---|---|
| Source Batch Name Field, Item Entry Relation Table | Inventory |
| Source Subtype Field, Item Entry Relation Table | Inventory |
| Source Type Field, Item Entry Relation Table | Inventory |
| Source Prod. Order Line Field, Item Entry Relation Table | Inventory |
| Source ID Field, Item Entry Relation Table | Inventory |
| Source Ref. No. Field, Item Entry Relation Table | Inventory |
| Order No. Field, Item Entry Relation Table | Inventory |
| Order Line No. Field, Item Entry Relation Table | Inventory |
| Lot No. Field, Item Entry Relation Table | Inventory |
| Item Entry No. Field, Item Entry Relation Table | Inventory |
| Serial No. Field, Item Entry Relation Table | Inventory |