Table 31107 "VAT Ctrl. Report Line CZL" (CZ)
CZ country layer · Microsoft.Finance.VAT.Reporting
Across versions
- BC23-28not present
- BC29-30present
CZ country layer · Microsoft.Finance.VAT.Reporting · captioned “VAT Control Report Line” · BC29-30 · source at ea08af5e · facts from BC29
An object of the CZ localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | VAT Control Report Line |
| LookupPageId | VAT Ctrl. Report Lines CZL |
| DrillDownPageId | VAT Ctrl. Report Lines 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 | VAT Ctrl. Report No. | Code[20] | Control Report No. caption | TableRelation VAT Ctrl. Report Header CZL; DataClassification CustomerContent |
| 2 | Line No. | Integer | — | DataClassification CustomerContent |
| 5 | VAT Ctrl. Report Section Code | Code[20] | VAT Control Report Section Code caption | TableRelation VAT Ctrl. Report Section CZL; DataClassification CustomerContent |
| 11 | Posting Date | Date | — | not editable; DataClassification CustomerContent |
| 12 | VAT Date | Date | — | not editable; DataClassification CustomerContent |
| 13 | Original Document VAT Date | Date | — | DataClassification CustomerContent |
| 15 | Bill-to/Pay-to No. | Code[20] | — | TableRelation if (Type = const(Purchase)) Vendor else if (Type = const(Sale)) Customer; DataClassification CustomerContent |
| 16 | VAT Registration No. | Text[20] | — | DataClassification CustomerContent |
| 17 | Registration No. | Text[20] | — | DataClassification CustomerContent |
| 18 | Tax Registration No. | Text[20] | — | DataClassification CustomerContent |
| 20 | Document No. | Code[20] | — | not editable; DataClassification CustomerContent |
| 21 | External Document No. | Code[35] | — | DataClassification CustomerContent |
| 30 | Type | Option | — | OptionCaption: ,Purchase,Sale; not editable; DataClassification CustomerContent |
| 31 | VAT Bus. Posting Group | Code[20] | — | TableRelation VAT Business Posting Group; not editable; DataClassification CustomerContent |
| 32 | VAT Prod. Posting Group | Code[20] | — | TableRelation VAT Product Posting Group; not editable; DataClassification CustomerContent |
| 35 | Base | Decimal | — | not editable; DataClassification CustomerContent |
| 36 | Amount | Decimal | — | not editable; DataClassification CustomerContent |
| 40 | VAT Rate | Option | — | OptionCaption: ,Base,Reduced,Reduced 2; DataClassification CustomerContent |
| 41 | Commodity Code | Code[10] | — | TableRelation Commodity CZL; DataClassification CustomerContent |
| 42 | Supplies Mode Code | Option | — | OptionCaption: ,par. 89,par. 90; DataClassification CustomerContent |
| 43 | Corrections for Bad Receivable | Enum “VAT Ctrl. Report Corect. CZL” | — | enum VAT Ctrl. Report Corect. CZL; DataClassification CustomerContent |
| 45 | Ratio Use | Boolean | — | DataClassification CustomerContent |
| 46 | Name | Text[50] | — | DataClassification CustomerContent |
| 47 | Birth Date | Date | — | DataClassification CustomerContent |
| 48 | Place of Stay | Text[50] | — | DataClassification CustomerContent |
| 50 | Exclude from Export | Boolean | — | DataClassification CustomerContent |
| 60 | Closed by Document No. | Code[20] | — | not editable; DataClassification CustomerContent |
| 61 | Closed Date | Date | — | not editable; DataClassification CustomerContent |
| 71 | Additional-Currency Base | Decimal | — | not editable; DataClassification CustomerContent |
| 72 | Additional-Currency Amount | Decimal | — | not editable; DataClassification CustomerContent |
Keys
- Key1: VAT Ctrl. Report No., Line No. (clustered)
- Key2: VAT Ctrl. Report No., Posting Date
- Key3: VAT Ctrl. Report No., VAT Date
- Key4: Closed by Document No.
Procedures
ChangeVATControlRepSection()ChangeVATControlRepSectionCode(VATCtrlRptSectionCode: Code[20])
Plus 2 local procedures.
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: "VAT Ctrl. Report Line 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.