tableFinanceofficial - Microsoftderived - from the source, no model text

Table 12117 "Contributions" (IT)

IT country layer · Microsoft.Bank.Payment

Across versions

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

IT country layer · Microsoft.Bank.Payment · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption Contributions
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 Entry No. Integer —
2 Month Integer — not editable
3 Year Integer — not editable
4 Document Date Date —
5 Document No. Code[20] —
6 External Document No. Code[35] —
7 Vendor No. Code[20] — TableRelation Vendor
8 Related Date Date —
9 Payment Date Date —
15 Gross Amount Decimal —
16 Non Taxable Amount Decimal —
17 Contribution Base Decimal —
18 Social Security Code Code[20] — TableRelation “Contribution Code”.Code where(“Contribution Type” = filter(INPS))
25 Social Security % Decimal —
26 Total Social Security Amount Decimal —
27 Free-Lance Amount % Decimal —
28 Free-Lance Amount Decimal —
29 Company Amount Decimal —
50 Reported Boolean — not editable
51 Posting Date Date —
52 INPS Paid Boolean — not editable
55 INAIL Gross Amount Decimal —
56 INAIL Non Taxable Amount Decimal —
57 INAIL Contribution Base Decimal —
58 INAIL Code Code[20] — TableRelation “Contribution Code”.Code where(“Contribution Type” = filter(INAIL))
59 INAIL Per Mil Decimal —
60 INAIL Total Amount Decimal —
61 INAIL Free-Lance % Decimal —
62 INAIL Free-Lance Amount Decimal —
63 INAIL Company Amount Decimal —
64 INAIL Paid Boolean — not editable

Keys

  • Key1: Entry No. (clustered)
  • Key2: Social Security Code, Vendor No.
  • Key3: Vendor No., Social Security Code, Social Security %
  • Key4: Vendor No., Payment Date, Social Security Code
  • Key5: Vendor No., Payment Date, INAIL Code
  • Key6: INAIL Code, Vendor No.
  • Key7: Vendor No., INAIL Code, INAIL Per Mil
  • Key8: Vendor No., Document Date, Document No.

Procedures

  • ValorizzaINPS()
  • Navigate()
  • ValorizzaINAIL()

Triggers

OnDelete, OnInsert, OnModify

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: "Contributions"), 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