BC Observatoryunofficial, made by waldo
tableAdministration & Setupofficial - Microsoftderived - from the source, no model text

Table 1862 "C5 InvenTable" (DK)

DK country layer · Microsoft.DataMigration.C5

Open in Claude1862-dk.mdSource on GitHub

Across versions

  1. BC23-28not present
  2. BC29-30present

DK country layer · Microsoft.DataMigration.C5 · BC29-30 · source at ea08af5e · facts from BC29

An object of the DK localization, not part of W1.

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 RecId Integer Row number caption
2 LastChanged Date Last changed caption
3 DEL_UserLock Integer Lock caption
4 ItemNumber Code[20] Item number caption
5 ItemName1 Text[40] Item name caption
6 ItemName2 Text[40] Suppl. item name 1 caption
7 ItemName3 Text[40] Suppl. item name 2 caption
8 ItemType Option Item type caption
9 DiscGroup Code[10] Discount group caption
10 CostCurrency Code[3] Cost currency caption
11 CostPrice Decimal Cost price caption
12 Group Code[10] —
13 SalesModel Option Sales model caption
14 CostingMethod Option Inven. model caption
15 PurchSeriesSize Decimal Purch. qty caption
16 PrimaryVendor Code[10] Primary Vendor caption
17 VendItemNumber Text[20] Vendor item no. caption
18 Blocked Option Locked caption
19 Alternative Option —
20 AltItemNumber Code[20] Alt. item caption
21 Decimals_ Integer Decimals caption
22 DEL_SalesDuty Text[10] DELETESalesDuty caption
23 Commission Option —
24 ImageFile Text[250] Image caption
25 NetWeight Decimal Net weight caption
26 Volume Decimal —
27 TariffNumber Code[20] Item CN8 codes caption
28 UnitCode Code[10] Unit caption
29 OneTimeItem Option One-off item caption
30 CostType Text[10] Cost type caption
31 ExtraCost Decimal Misc. charges caption
32 PurchCostModel Option Purch. cost model caption
33 MainLocation Text[10] Main inventory caption
34 InvenLocation Option Location caption
35 PurchVat Code[10] Purch. VAT caption
36 RESERVED2 Text[10] —
37 Inventory Decimal —
38 Delivered Decimal —
39 Reserved Decimal —
40 Received Decimal —
41 Ordered Decimal —
42 InventoryValue Decimal Inventory value in LCY caption
43 DeliveredValue Decimal Value delivered in LCY caption
44 ReceivedValue Decimal Value received in LCY caption
45 Department Code[10] —
46 CostPriceUnit Decimal Cost price unit caption
47 DEL_PurchDuty Text[10] DELETEPurchDuty caption
48 Level Integer —
49 Pulled Decimal —
50 WarnNegativeInventory Option Warning caption
51 NegativeInventory Option Negative caption
52 IgnoreListCode Option -Lst caption
53 PayCType Text[10] Payroll CT caption
54 ItemTracking Option Item tracking caption
55 ItemTrackGroup Text[10] Tracking group caption
56 ProjCostFactor Decimal Proj. factor caption
57 Centre Code[10] Cost centre caption
58 Purpose Code[10] —
59 SupplFactor Decimal Suppl. factor caption
60 SupplementaryUnits Text[13] Supplementary unit caption
61 MarkedPhysical Decimal Mrk. physical caption
62 LastMovementDate Date Latest movement caption
63 VatGroup Code[10] VAT group caption
64 StdItemNumber Option Default caption

Keys

  • PK: RecId (clustered)

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: "C5 InvenTable"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A DK 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