Table 27030 "DIOT Concept" (CA)

CA country layer · Microsoft.Finance.VAT.Reporting · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	DIOT Concept
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	Concept No.	Integer	—
2	Column No.	Integer	—
3	Description	Text[250]	—
4	Column Type	Option	—	OptionCaption: None,VAT Base,VAT Amount
5	Non-Deductible	Boolean	—
6	Non-Deductible Pct	Decimal	Non-Deductible percent caption
7	VAT Links Count	Integer	—	FlowField: count(“DIOT Concept Link” where(“DIOT Concept No.” = field(“Concept No.”)))

Keys

PK: Concept No. (clustered)

Procedures

GetColumnNo(ConceptNo: Integer): Integer
CheckLinksForConceptWithTypeNotNone(): Boolean

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

A CA country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.