Table 31109 "VAT Ctrl. Report Buffer CZL" (CZ)

CZ country layer · Microsoft.Finance.VAT.Reporting · captioned “VAT Control Report Buffer” · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	VAT Control Report Buffer

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
2	Line No.	Integer	—	DataClassification SystemMetadata
5	VAT Ctrl. Report Section Code	Code[20]	VAT Control Report Section Code caption	TableRelation VAT Ctrl. Report Section CZL; DataClassification SystemMetadata
11	Posting Date	Date	—	not editable; DataClassification SystemMetadata
12	VAT Date	Date	—	not editable; DataClassification SystemMetadata
13	Original Document VAT Date	Date	—	DataClassification SystemMetadata
15	Bill-to/Pay-to No.	Code[20]	—	TableRelation if (Type = const(Purchase)) Vendor else if (Type = const(Sale)) Customer; DataClassification SystemMetadata
16	VAT Registration No.	Text[20]	—	DataClassification SystemMetadata
17	Registration No.	Text[20]	—	DataClassification SystemMetadata
18	Tax Registration No.	Text[20]	—	DataClassification SystemMetadata
20	Document No.	Code[35]	—	not editable; DataClassification SystemMetadata
21	External Document No.	Code[35]	—	not editable; DataClassification SystemMetadata
30	Type	Option	—	OptionCaption: ,Purchase,Sale; not editable; DataClassification SystemMetadata
31	VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group; not editable; DataClassification SystemMetadata
32	VAT Prod. Posting Group	Code[20]	—	TableRelation VAT Product Posting Group; not editable; DataClassification SystemMetadata
35	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; not editable; DataClassification SystemMetadata
40	VAT Rate	Option	—	OptionCaption: ,Base,Reduced,Reduced 2; DataClassification SystemMetadata
41	Commodity Code	Code[10]	—	TableRelation Commodity CZL; DataClassification SystemMetadata
42	Supplies Mode Code	Option	—	OptionCaption: 0,1,2; DataClassification SystemMetadata
43	Corrections for Bad Receivable	Enum “VAT Ctrl. Report Corect. CZL”	—	enum VAT Ctrl. Report Corect. CZL; DataClassification SystemMetadata
45	Ratio Use	Boolean	—	DataClassification SystemMetadata
46	Name	Text[50]	—	DataClassification SystemMetadata
47	Birth Date	Date	—	DataClassification SystemMetadata
48	Place of Stay	Text[50]	—	DataClassification SystemMetadata
60	Base 1	Decimal	Base (base) caption	DataClassification SystemMetadata
61	Amount 1	Decimal	Amount (base) caption	DataClassification SystemMetadata
62	Base 2	Decimal	Base (reduced) caption	DataClassification SystemMetadata
63	Amount 2	Decimal	Amount (reduced) caption	DataClassification SystemMetadata
64	Base 3	Decimal	Base (2.reduced) caption	DataClassification SystemMetadata
65	Amount 3	Decimal	Amount (2.reduced) caption	DataClassification SystemMetadata
70	Total Base	Decimal	—	DataClassification SystemMetadata
71	Total Amount	Decimal	—	DataClassification SystemMetadata
80	Add.-Currency Base 1	Decimal	Add.-Currency Base (base) caption	DataClassification SystemMetadata
81	Add.-Currency Amount 1	Decimal	Add.-Currency Amount (base) caption	DataClassification SystemMetadata
82	Add.-Currency Base 2	Decimal	Add.-Currency Base (reduced) caption	DataClassification SystemMetadata
83	Add.-Currency Amount 2	Decimal	Add.-Currency Amount (reduced) caption	DataClassification SystemMetadata
84	Add.-Currency Base 3	Decimal	Add.-Currency Base (2.reduced) caption	DataClassification SystemMetadata
85	Add.-Currency Amount 3	Decimal	Add.-Currency Amount (2.reduced) caption	DataClassification SystemMetadata
86	Add.-Currency Total Base	Decimal	—	DataClassification SystemMetadata
87	Add.-Currency Total Amount	Decimal	—	DataClassification SystemMetadata
100	VAT Control Rep. Section Desc.	Text[50]	VAT Control Report Section Description caption	FlowField: lookup(“VAT Ctrl. Report Section CZL”.Description where(Code = field(“VAT Ctrl. Report Section Code”))); not editable

Keys

Key1: VAT Ctrl. Report Section Code, Line No. (clustered)
Key2: Document No., Bill-to/Pay-to No., Posting Date
Key3: Document No., Bill-to/Pay-to No., VAT Date

Procedures

1 local procedures, no public ones.

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: "VAT Ctrl. Report Buffer CZL"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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