Table 12117 "Contributions" (IT)
IT country layer · Microsoft.Bank.Payment
Across versions
- BC23-28not present
- 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()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.