tableAL Developmentofficial - Microsoftderived - from the source, no model textobsolete - removed

Table 12408 "CD No. Information" (RU)

RU country layer

Across versionsobsolete removed since 28.0

  1. BC23-28not present
  2. 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.

Evidence 1 sources