Table TAXLINK
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
TAXLINK | TLK | Tax calc. basis calculation (link) | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
DLK0 | CLE | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACCCOD | Accounting code | CAC | [CAC]CAC0=1;ACCCOD;[V]GSUPCLE | Other | ||||
AGTPCPBPR | Collection agent | M | 4 | 1 | ||||
AGTPCPCPY | Collection agent | M | 4 | 1 | ||||
AGTSATTAX | Collection agent | M | 4 | 1 | ||||
AMTBAS | Calculated basis | MD5 | ||||||
AMTBAS1 | Calculated basis | MD5 | ||||||
AMTBAS2 | Calculated basis | MD5 | ||||||
AMTNOT | Amount - tax | MD1 | ||||||
AMTNOTLIN | Line amount - tax | MD1 | ||||||
AMTTAX1 | Tax amount 1 | MD1 | ||||||
AMTTAXLIN1 | Tax amount 1 | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BPRNUM | BP | BPR | [BPR]BPR0=[TLK]BPRNUM | Other | ||||
CLE | Key | A | 3 | |||||
CPY | Company | CPY | [CPY]CPY0=[TLK]CPY | Other | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[TLK]CREUSR | Other | ||||
CUR | Currency | CUR | [TCU]TCU0=[TLK]CUR | Other | ||||
DAT | Date | D | ||||||
DLKFIL | A | 50 | ||||||
FCY | Site | FCY | [FCY]FCY0=[TLK]FCY | Other | ||||
FLGSATTAX | Collection agent | 25 | M | 4 | 1 | |||
GRP | Group | 99 | AGF | [AGF]AGF0=[TLK]GRP | Delete | |||
ITMREF | Product | ITM | [ITM]ITM0=[TLK]ITMREF | Delete | ||||
ITMWEI | Item weight | WEI | ||||||
LEG | Legislation | ADI | [ADI]CODE=909;LEG | Other | ||||
MODULE | Module | M | 15 | 14 | ||||
NBGRP | Number of groups | C | 4 | |||||
NETPRI | Net price | MD8 | ||||||
PURFCY | Purchase site | FCY | [FCY]FCY0=[TLK]PURFCY | Other | ||||
QTY | Quantity | DCB | 9.6 | |||||
QTYSTU | STK quantity | DCB | 9.6 | |||||
RATRPT | Reporting rate | RCU | ||||||
SALFCY | Sales site | FCY | [FCY]FCY0=[TLK]SALFCY | Other | ||||
SATFLG | Indicator | C | 4 | |||||
SATISS | Issue | SAT | PTX | |||||
SATRCP | Receipt | SAT | PTX | |||||
SATTAX | BP regions | 25 | A | 3 | ||||
TCLCOD | Product category | ITG | [ITG]ITG0="";TCLCOD | Other | ||||
TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Other | STI | |||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[TLK]UPDUSR | Other | ||||
VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Block | ||||
VACITM | Tax level | TVI | [TVI]TVI0=VACITM;[V]GSUPCLE | Block | ||||
VATTYP | Tax type | M | 15 | 232 |