tableFinanceofficial - Microsoftderived - from the source, no model text

Table 12136 "Periodic VAT Settlement Entry" (IT)

IT country layer · Microsoft.Finance.VAT.Reporting

Across versions

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

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

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

Properties

Property Value
Caption Periodic VAT Settlement Entry
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 Activity Code Code[6] —
2 VAT Period Code[10] — NotBlank
3 VAT Settlement Decimal —
4 Add-Curr. VAT Settlement Decimal —
5 Prior Period Input VAT Decimal —
6 Prior Period Output VAT Decimal —
7 Add Curr. Prior Per. Inp. VAT Decimal —
8 Add Curr. Prior Per. Out VAT Decimal Add-Curr. Prior Per. Out VAT caption
10 Paid Amount Decimal —
11 Advanced Amount Decimal —
12 Add-Curr. Paid. Amount Decimal —
13 Add-Curr. Advanced Amount Decimal —
20 Bank Code Code[20] — TableRelation Bank Account
21 Paid Date Date —
22 Description Text[30] —
40 VAT Period Closed Boolean —
50 Prior Year Input VAT Decimal —
51 Prior Year Output VAT Decimal —
52 Add Curr.Prior Year Inp. VAT Decimal —
53 Add Curr.Prior Year Out. VAT Decimal —
60 Payable VAT Variation Decimal —
61 Deductible VAT Variation Decimal —
62 Tax Debit Variation Decimal —
63 Tax Credit Variation Decimal —
64 Unpaid VAT Previous Periods Decimal —
65 Tax Debit Variation Interest Decimal —
66 Omit VAT Payable Interest Decimal —
70 Credit VAT Compensation Decimal —
71 Special Credit Decimal —

Keys

  • Key1: VAT Period, Activity Code (clustered)
  • Key2: VAT Period Closed

Procedures

1 local procedures, no public ones.

Triggers

OnInsert

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: "Periodic VAT Settlement Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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