Table 12408 "CD No. Information" (RU)
RU country layer
Across versionsobsolete removed since 28.0
- BC23-28not present
- BC29-30present
RU country layer · BC29-30 · source at ea08af5e · facts from BC29
An object of the RU localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | CD No. Information |
| DataClassification | CustomerContent |
| ObsoleteState | Removed |
| ObsoleteTag | 28.0 |
| ObsoleteReason | Replaced by Package No. Information and FA CD No. Information tables. |
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 | No. | Code[20] | — | TableRelation if (Type = const(Item)) Item else if (Type = const(“Fixed Asset”)) “Fixed Asset”; NotBlank |
| 2 | Variant Code | Code[10] | — | TableRelation “Item Variant”.Code where(“Item No.” = field(“No.”)) |
| 3 | CD No. | Code[50] | Package No. caption | NotBlank |
| 4 | CD Line No. | Integer | — | |
| 5 | Country/Region Code | Code[10] | — | TableRelation Country/Region |
| 6 | Type | Option | — | OptionCaption: Item,Fixed Asset |
| 7 | Quantity | Decimal | — | |
| 9 | CD Header No. | Code[30] | — | obsolete Removed 28.0; #if not CLEANSCHEMA28; TableRelation CD No. Header |
| 10 | Description | Text[100] | — | |
| 11 | Temporary CD No. | Boolean | — | |
| 12 | Certificate Number | Code[20] | — | |
| 13 | Blocked | Boolean | — | |
| 14 | Comment | Boolean | — | FlowField: exist(“Item Tracking Comment” where(Type = const(“Lot No.”), “Item No.” = field(“No.”), “Variant Code” = field(“Variant Code”), “Serial/Lot No.” = field(“CD No.”))); not editable |
| 15 | Stockout Warning | Boolean | — | |
| 21 | Date Filter | Date | — | FlowFilter |
| 22 | Location Filter | Code[10] | — | TableRelation Location; FlowFilter |
| 23 | Bin Filter | Code[20] | — | TableRelation Bin.Code where(“Location Code” = field(“Location Filter”)); FlowFilter |
| 30 | Inventory | Decimal | — | FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“No.”), “Variant Code” = field(“Variant Code”), “Package No.” = field(“CD No.”), “Location Code” = field(“Location Filter”))); not editable |
| 31 | Positive Adjmt. | Decimal | — | FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“No.”), “Variant Code” = field(“Variant Code”), “Package No.” = field(“CD No.”), “Location Code” = field(“Location Filter”), “Entry Type” = const(“Positive Adjmt.”))); not editable |
| 32 | Purchases | Decimal | — | FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“No.”), “Variant Code” = field(“Variant Code”), “Package No.” = field(“CD No.”), “Location Code” = field(“Location Filter”), “Entry Type” = const(Purchase))); not editable |
| 33 | Negative Adjmt. | Decimal | — | FlowField: - sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“No.”), “Variant Code” = field(“Variant Code”), “Package No.” = field(“CD No.”), “Location Code” = field(“Location Filter”), “Entry Type” = const(“Negative Adjmt.”))); not editable |
| 34 | Sales | Decimal | — | FlowField: - sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“No.”), “Variant Code” = field(“Variant Code”), “Package No.” = field(“CD No.”), “Location Code” = field(“Location Filter”), “Entry Type” = const(Sale))); not editable |
| 40 | Current No. | Code[6] | — |
Keys
- Key1: Type, No., Variant Code, CD No. (clustered)
- Key2: CD No.
- Key3: CD Header No., CD No.
Deprecations
- object: Removed 28.0 (#if not CLEANSCHEMA28), “Replaced by Package No. Information and FA CD No. Information tables.”
- field CD Header No.: Removed 28.0 (#if not CLEANSCHEMA28), “CD No. Header has been moved to CD Tracking extension.”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
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: "CD No. Information"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A RU country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.