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 |