Table VATFRMENT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| VATFRMENT | VFE | VAT form (values) | Financials | DCL |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| VFE0 | VATENTNUM | No | |
| VFE1 | VATENTNUM+VATFNC+LEG+CODVATGRP | No | |
| VFE3 | CODVATGRP+VATFNC-DCLSTRDAT+VATENTNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| ALLCPYSIM | All companies | M | 4 | 1 | ||||
| ALLFCYSIM | All sites | M | 4 | 1 | ||||
| AMTVATCUR | Currency | CUR | [TCU]TCU0=[VFE]AMTVATCUR | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CODVATGRP | VAT entity | VATGRP | [VATGH]VATGH0=[VFE]CODVATGRP | Block | ||||
| CPY | Company | CPY | [CPY]CPY0=[VFE]CPY | Other | ||||
| CPYSIM | Company | CPY | [CPY]CPY0=[VFE]CPYSIM | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[VFE]CREUSR | Other | ||||
| DATPCE | Due date until | D | ||||||
| DCLENDDAT | Validity end date | D4 | ||||||
| DCLSTRDAT | Validity start date | D4 | ||||||
| DEC | Decimals | C | 4 | |||||
| DEFDES | Default description | DES | ||||||
| DESTRA | Long title | AXX | ||||||
| DETDCL | Off declaration detail | M | 4 | 1 | ||||
| DUEDAT | Due date | D | ||||||
| ECRAUX | Auxilliary postings only | M | 4 | 1 | ||||
| ENDDAT | Declaration end date | D | ||||||
| ENDDAT2 | Matching end date | D | ||||||
| EXTSTRDAT | Starting from | D | ||||||
| FCYSIM | Site | FCY | [FCY]FCY0=[VFE]FCYSIM | Other | ||||
| FILEXPNAM | Export file name | A | 250 | |||||
| GRPCPY | Company group | AGF | [AGF]AGF0=[VFE]GRPCPY | Other | ||||
| INCUNXENT | Inc unextrac entries | M | 4 | 1 | ||||
| LASEXPDAT | Last export date | ADATIM | ||||||
| LASSBM | Last submission | ADATIM | ||||||
| LEG | Legislation | ADI | [ADI]CODE=909;LEG | Block | ||||
| PERKEY | Period | A | 10 | |||||
| PSTSTA | Posting status | M | 15 | 3742 | ||||
| PVWFLG | Simulation | M | 4 | 1 | ||||
| RESULT | Result | AC0 | 3 | |||||
| STA | Status | M | 15 | 880 | ||||
| STRDAT | Declaration start date | D | ||||||
| STRDAT2 | Matching start date | D | ||||||
| SUBDAT | D | |||||||
| TRCFLG | Log | M | 4 | 1 | ||||
| TYPGEN | Generation | M | 20 | 2601 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[VFE]UPDUSR | Other | ||||
| VAT | Launch VAT on debit | M | 4 | 1 | ||||
| VATBOX | VAT boxes | A | 5 | |||||
| VATDCLYEA | Year | C | 4 | |||||
| VATENTNUM | Declaration number | VCR | ||||||
| VATFNC | Function code | AFC | [AFC]CODINT=[VFE]VATFNC | Block | ||||
| VATFRM | VAT form | A | 15 | |||||
| VATPAY | Launch VAT on payment | M | 4 | 1 | ||||
| VATRTNTYP | VAT declaration type | M | 15 | 883 | ||||
| VERSION | Version | C | 3 |