Table 10744 "340 Declaration Line" (ES)
ES country layer · Microsoft.Finance.VAT.Reporting
Across versions
- BC23-28not present
- BC29-30present
ES country layer · Microsoft.Finance.VAT.Reporting · BC29-30 · source at ea08af5e · facts from BC29
An object of the ES localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | 340 Declaration Line |
| 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 | Key | Integer | — | |
| 3 | Fiscal Year | Text[8] | — | |
| 4 | VAT Registration No. | Text[9] | — | |
| 5 | VAT Number | Text[9] | — | |
| 7 | Customer/Vendor No. | Text[20] | — | |
| 8 | Customer/Vendor Name | Text[100] | — | |
| 9 | Country Code | Text[10] | — | |
| 10 | Resident ID | Text[1] | — | |
| 11 | International VAT No. | Text[20] | — | |
| 12 | Book Type Code | Text[1] | — | |
| 13 | Operation Code | Code[1] | — | TableRelation Operation Code |
| 14 | Document Date | Date | — | |
| 15 | Operation Date | Text[8] | — | |
| 16 | VAT % | Decimal | — | |
| 17 | Base | Decimal | — | |
| 21 | Document No. | Text[40] | — | |
| 22 | Document Type | Text[30] | — | |
| 23 | VAT Document No. | Text[18] | — | |
| 24 | Buffer Value 18 | Text[18] | — | |
| 25 | No. of Registers | Text[2] | — | |
| 27 | Buffer Value 40 | Text[40] | — | |
| 28 | Property Location | Option | — | OptionCaption: ,Property in Spain,Property in Basque / Navarra,Property W/o Tax number,Property outside Spain |
| 29 | Property Tax Account No. | Text[25] | — | |
| 30 | EC % | Decimal | — | |
| 31 | EC Amount | Decimal | — | |
| 32 | VAT Amount | Decimal | — | |
| 33 | VAT Amount / EC Amount | Decimal | — | |
| 34 | Amount Including VAT / EC | Decimal | — | |
| 35 | Type | Enum “General Posting Type” | — | enum Enum 57 “General Posting Type” |
| 36 | Unrealized VAT Entry No. | Integer | — | |
| 37 | Bank Account Ledger Entry No. | Integer | — | TableRelation Bank Account Ledger Entry |
| 38 | Posting Date | Date | — | |
| 10705 | VAT Cash Regime | Boolean | — | |
| 10706 | Collection Amount | Decimal | — |
Keys
- Key1: Key (clustered)
Procedures
RemoveDuplicateAmounts()
Triggers
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: "340 Declaration Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A ES country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.