Table 7380 "Phys. Invt. Item Selection"
Base Application · Microsoft.Inventory.Counting.Journal
Across versions
- BC23present
- BC241 fields changed
- BC25-27unchanged
- BC2810 fields changed
- BC29-30unchanged
Neighbourhood 5 connected objects and pages
Base Application · Microsoft.Inventory.Counting.Journal · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Phys. Invt. Item Selection |
| 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 |
|---|---|---|---|---|
| 1 | Item No. Δ BC28 | Code[20] | Specifies the number of the item for which the cycle counting can be performed. | TableRelation Table 27 “Item”; not editable; NotBlank |
| 2 | 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.”))); not editable |
| 3 | Location Code Δ BC28 | Code[10] | Specifies the code of the location where the cycle counting is performed. | TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false))); not editable |
| 4 | Description Δ BC24 Δ BC28 | Text[100] | Specifies the description of the item. | FlowField: lookup(Item.Description where(“No.” = field(“Item No.”))); not editable |
| 5 | Shelf No. Δ BC28 | Code[10] | Specifies the shelf number of the item for informational use. | not editable |
| 6 | Phys Invt Counting Period Code Δ BC28 | Code[10] | Specifies the code of the counting period that indicates how often you want to count the item or stockkeeping unit in a physical inventory. | TableRelation Table 7381 “Phys. Invt. Counting Period” (Phys. Invt. Counting Period); not editable |
| 7 | Last Counting Date Δ BC28 | Date | Specifies the last date when the counting period for the item or stockkeeping unit was updated. | not editable |
| 9 | Count Frequency per Year Δ BC28 | Integer | Specifies the number of times you want the item or stockkeeping unit to be counted each year. | not editable |
| 10 | Selected | Boolean | — | |
| 11 | Phys Invt Counting Period Type | Option | — | OptionCaption: ,Item,SKU |
| 12 | Next Counting Start Date Δ BC28 | Date | Specifies the starting date of the next counting period. | not editable |
| 13 | Next Counting End Date Δ BC28 | Date | Specifies the ending date of the next counting period. | not editable |
Keys
- Key1: Item No., Variant Code, Location Code, Phys Invt Counting Period Code (clustered)
Relations
- Location Code: TableRelation Table 14 “Location”
- Description: CalcFormula Table 27 “Item”
- Item No.: TableRelation Table 27 “Item”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Phys Invt Counting Period Code: TableRelation Table 7381 “Phys. Invt. Counting Period”
Pages and codeunits on this table
- Page 7380 “Phys. Invt. Item Selection” (source table)
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: "Phys. Invt. Item Selection"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.