Table 7345 "Registered Invt. Movement Line"
Base Application · Microsoft.Warehouse.InventoryDocument
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC261 fields changed
- BC27unchanged
- BC2830 fields changed
- BC29-30unchanged
Neighbourhood 17 connected objects and pages
Base Application · Microsoft.Warehouse.InventoryDocument · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 7387 “Reg. Invt. Movement Lines” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Registered Invt. Movement Line |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 2 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | |
| 3 | Line No. Δ BC28 | Integer | Specifies the number of the related inventory movement line. | |
| 4 | Source Type Δ BC28 | Integer | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | |
| 5 | Source Subtype Δ BC28 | Option | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | OptionCaption: 0,1,2,3,4,5,6,7,8,9,10 |
| 6 | Source No. Δ BC28 | Code[20] | Specifies the number of the source document that the entry originates from. | |
| 7 | Source Line No. Δ BC28 | Integer | Specifies the line number of the source document that the entry originates from. | |
| 8 | Source Subline No. Δ BC28 | Integer | Specifies the number of the subline on the related inventory movement. | |
| 9 | Source Document Δ BC28 | Enum “Warehouse Activity Source Document” | Specifies the type of document that the line relates to. | enum Enum 5768 “Warehouse Activity Source Document” |
| 11 | Location Code Δ BC28 | Code[10] | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | TableRelation Table 14 “Location” |
| 12 | Shelf No. Δ BC28 | Code[10] | Specifies the shelf number of the item for informational use. | |
| 13 | Sorting Sequence No. | Integer | — | |
| 14 | Item No. Δ BC28 | Code[20] | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | TableRelation Table 27 “Item” |
| 15 | Variant Code Δ BC28 | Code[10] | Specifies the variant of the item on the line. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))) |
| 16 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))) |
| 17 | Qty. per Unit of Measure Δ BC28 | Decimal | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | |
| 18 | Description Δ BC28 | Text[100] | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | |
| 19 | Description 2 Δ BC28 | Text[50] | Specifies the second description of the item. | |
| 20 | Quantity Δ BC28 | Decimal | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | |
| 21 | Qty. (Base) Δ BC28 | Decimal | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. via Page 7387 “Reg. Invt. Movement Lines” | |
| 31 | Shipping Advice Δ BC28 | Enum “Sales Header Shipping Advice” | Specifies the shipping advice for the registered inventory movement line. | enum Enum 3657 “Sales Header Shipping Advice” |
| 34 | Due Date Δ BC28 | Date | Specifies the date when the warehouse activity must be completed. | |
| 39 | Destination Type Δ BC28 | enum “Warehouse Destination Type” | Specifies the type of destination that is associated with the registered inventory movement line. | enum Enum 7310 “Warehouse Destination Type” |
| 40 | Destination No. Δ BC26 Δ BC28 | Code[20] | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | TableRelation Table 14 “Location”, Table 18 “Customer”, Table 23 “Vendor” (if (“Destination Type” = const(Vendor)) Vendor else if (“Destination Type” = const(Customer)) Customer else if (“Destination Type” = const(Location)) Location else if (“Destination Type” = const(Item)) Item else if (“Destination Type” = const(“Sales Order”)) “Sales Header”.“No.” where(“Document Type…) |
| 41 | Whse. Activity No. | Code[20] | — | |
| 42 | Shipping Agent Code | Code[10] | — | TableRelation Table 291 “Shipping Agent” (Shipping Agent) |
| 43 | Shipping Agent Service Code | Code[10] | — | TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”))) |
| 44 | Shipment Method Code | Code[10] | — | TableRelation Table 10 “Shipment Method” (Shipment Method) |
| 6500 | Serial No. Δ BC28 | Code[50] | Specifies the serial number of the item that was moved. | |
| 6501 | Lot No. Δ BC28 | Code[50] | Specifies the lot number of the item that was moved. | |
| 6502 | Warranty Date | Date | — | |
| 6503 | Expiration Date Δ BC28 | Date | Specifies the expiration date of the serial number or lot number that was moved. | |
| 6515 | Package No. Δ BC28 | Code[50] | Specifies the package number of the item that was moved. | |
| 7300 | Bin Code Δ BC28 | Code[20] | Specifies the bin where the items are picked or put away. | TableRelation Table 7354 “Bin” (if (“Action Type” = filter(<> Take)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“Zone Code”)) else if (“Action Type” = filter(<> Take), “Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“Action Type” = const(Take)) “Bin Cont…) |
| 7301 | Zone Code Δ BC28 | Code[10] | Specifies the zone code where the bin on the registered inventory movement is located. | TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”))) |
| 7305 | Action Type Δ BC28 | Enum “Warehouse Action Type” | Specifies the action type for the inventory movement line. | enum Enum 5774 “Warehouse Action Type”; not editable |
| 7312 | Special Equipment Code Δ BC28 | Code[10] | Specifies the same as the field with the same name in the Registered Whse. Activity Line table. | TableRelation Table 7305 “Special Equipment” (Special Equipment) |
Keys
- Key1: No., Line No. (clustered)
- Key2: No., Sorting Sequence No.
- Key3: Source Type, Source Subtype, Source No., Source Line No., Source Subline No.
- Key4: Lot No.
- Key5: Serial No.
Relations
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- Destination No.: TableRelation Table 14 “Location” (conditional)
- Location Code: TableRelation Table 14 “Location”
- Destination No.: TableRelation Table 18 “Customer” (conditional)
- Destination No.: TableRelation Table 23 “Vendor” (conditional)
- Destination No.: TableRelation Table 27 “Item” (conditional)
- Item No.: TableRelation Table 27 “Item”
- Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
- Destination No.: TableRelation Table 36 “Sales Header” (conditional)
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
- Zone Code: TableRelation Table 7300 “Zone”
- Special Equipment Code: TableRelation Table 7305 “Special Equipment”
- Bin Code: TableRelation Table 7354 “Bin” (conditional)
Pages and codeunits on this table
- Page 7385 “Reg. Invt. Movement Subform” (source table)
- Page 7387 “Reg. Invt. Movement Lines” (source table)
Extended by
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Registered Invt. Movement Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.