BC Observatoryunofficial, made by waldo
tableFinanceofficial - Microsoftderived - from the source, no model text

Table 31075 "VIES Declaration Header CZL" (CZ)

CZ country layer · Microsoft.Finance.VAT.Reporting

Open in Claude31075-cz.mdSource on GitHub

Across versions

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

CZ country layer · Microsoft.Finance.VAT.Reporting · captioned “VIES Declaration Header” · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption VIES Declaration Header
LookupPageId VIES Declarations CZL
DrillDownPageId VIES Declarations CZL

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] — DataClassification CustomerContent
2 VAT Registration No. Text[20] — NotBlank; DataClassification CustomerContent
3 Trade Type Option — OptionCaption: Purchase,Sales,Both; DataClassification CustomerContent
4 Period No. Integer — DataClassification CustomerContent
5 Year Integer — DataClassification CustomerContent
6 Start Date Date — not editable; DataClassification CustomerContent
7 End Date Date — not editable; DataClassification CustomerContent
8 Name Text[100] — DataClassification CustomerContent
9 Name 2 Text[50] — DataClassification CustomerContent
10 Country/Region Name Text[50] — DataClassification CustomerContent
11 County Text[30] — DataClassification CustomerContent
12 Municipality No. Text[30] — DataClassification CustomerContent
13 Street Text[50] — DataClassification CustomerContent
14 House No. Text[30] — DataClassification CustomerContent
15 Apartment No. Text[30] — DataClassification CustomerContent
16 City Text[30] — TableRelation “Post Code”.City; DataClassification CustomerContent
17 Post Code Code[20] — TableRelation Post Code; DataClassification CustomerContent
18 Tax Office Number Code[20] — DataClassification CustomerContent
19 Declaration Period Option — OptionCaption: Quarter,Month; DataClassification CustomerContent
20 Declaration Type Option — OptionCaption: Normal,Corrective,Corrective-Supplementary; DataClassification CustomerContent
21 Corrected Declaration No. Code[20] — TableRelation “VIES Declaration Header CZL” where(“Corrected Declaration No.” = filter(‘’), Status = const(Released)); DataClassification CustomerContent
24 Document Date Date — DataClassification CustomerContent
25 Number of Pages Integer — FlowField: max(“VIES Declaration Line CZL”.“Report Page Number” where(“VIES Declaration No.” = field(“No.”))); not editable
26 Number of Lines Integer — FlowField: count(“VIES Declaration Line CZL” where(“VIES Declaration No.” = field(“No.”))); not editable
27 Sign-off Place Text[30] — DataClassification CustomerContent
28 Sign-off Date Date — DataClassification CustomerContent
29 EU Goods/Services Option — OptionCaption: Both,Goods,Services; DataClassification CustomerContent
30 Purchase Amount (LCY) Decimal — FlowField: sum(“VIES Declaration Line CZL”.“Amount (LCY)” where(“VIES Declaration No.” = field(“No.”), “Trade Type” = const(Purchase))); not editable
31 Sales Amount (LCY) Decimal — FlowField: sum(“VIES Declaration Line CZL”.“Amount (LCY)” where(“VIES Declaration No.” = field(“No.”), “Trade Type” = const(Sales))); not editable
32 Amount (LCY) Decimal — FlowField: sum(“VIES Declaration Line CZL”.“Amount (LCY)” where(“VIES Declaration No.” = field(“No.”))); not editable
33 Number of Supplies Decimal — FlowField: sum(“VIES Declaration Line CZL”.“Number of Supplies” where(“VIES Declaration No.” = field(“No.”))); not editable
50 Status Option — OptionCaption: Open,Released; DataClassification CustomerContent
51 No. Series Code[20] — TableRelation No. Series; DataClassification CustomerContent
70 Authorized Employee No. Code[20] — TableRelation Company Official CZL; DataClassification CustomerContent
71 Filled by Employee No. Code[20] — TableRelation Company Official CZL; DataClassification CustomerContent
90 Individual First Name Text[30] — DataClassification CustomerContent
91 Individual Surname Text[30] — DataClassification CustomerContent
92 Individual Title Text[30] — DataClassification CustomerContent
93 Company Type Option — OptionCaption: ,Individual,Corporate; DataClassification CustomerContent
95 Individual Employee No. Code[20] — TableRelation Employee; DataClassification CustomerContent
96 Company Trade Name Appendix Text[11] — DataClassification CustomerContent
100 Tax Office Region Number Code[20] — DataClassification CustomerContent
111 Purchase Add.-Currency Amount Decimal Purchase Additional-Currency Amount caption FlowField: sum(“VIES Declaration Line CZL”.“Additional-Currency Amount” where(“VIES Declaration No.” = field(“No.”), “Trade Type” = const(Purchase))); not editable
112 Sales Add.-Currency Amount Decimal Sales Additional-Currency Amount caption FlowField: sum(“VIES Declaration Line CZL”.“Additional-Currency Amount” where(“VIES Declaration No.” = field(“No.”), “Trade Type” = const(Sales))); not editable
113 Additional-Currency Amount Decimal — FlowField: sum(“VIES Declaration Line CZL”.“Additional-Currency Amount” where(“VIES Declaration No.” = field(“No.”))); not editable
120 Export Amt.inAdd.-CurrencyAmt. Boolean Export Amounts in Add. Reporting Currency caption DataClassification CustomerContent

Keys

  • Key1: No. (clustered)
  • Key2: Start Date, End Date

Events published

  • OnCheckPeriodOnAfterSetFilters(VIESDeclarationHeaderCZL: Record "VIES Declaration Header CZL"; var FilteredVIESDeclarationHeaderCZL: Record "VIES Declaration Header CZL") (integration)
  • OnBeforeCheckDeclarationType(VIESDeclarationHeaderCZL: Record "VIES Declaration Header CZL"; var IsHandled: Boolean) (integration)
  • OnBeforePrint(var VIESDeclarationHeaderCZL: Record "VIES Declaration Header CZL"; var IsHandled: Boolean) (integration)

Procedures

  • InitRecord()
  • AssistEdit(OldVIESDeclarationHeaderCZL: Record "VIES Declaration Header CZL"): Boolean
  • GetVATRegNo(): Code[20]
  • PrintTestReport()
  • Print()
  • Export()
  • PrintToDocumentAttachment()
  • GetCurrencyCode(): Code[10]: Returns the additional reporting currency code from General Ledger Setup. Used for additional currency amount formatting in flowfields.

Plus 7 local procedures.

Triggers

OnDelete, OnInsert, OnRename

Recent changes

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: "VIES Declaration Header 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.

Evidence 1 sources