Table GACCTMPD
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| GACCTMPD | DAT | Accounting entry lines | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DAT0 | TYP+NUM+LIN+LEDTYP | No | |
| DAT1 | ACCNUM | No | |
| DAT2 | CODAUTACE+LEDTYP+CRIMTC+ACCNUM | No | |
| DAT3 | TYP+NUM+IDTLIN+LEDTYP+LIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACC | General accounts | GAC | [GAC]GAC0=COA;ACC | Block | ||||
| ACCDAT | Accounting date | D | ||||||
| ACCNUM | Internal number | L | 8 | |||||
| ACCNUMDOE | Counterpart number | UNQ | KRU | |||||
| ACCNUMORI | Source number | L | 8 | |||||
| AMTCUR | Entry amount | MD1 | ||||||
| AMTFLG | Forced amount | M | 4 | 1 | ||||
| AMTLED | Ledger amount | MD1 | ||||||
| AMTLED1 | Forced amount | MD1 | ||||||
| AMTVAT | Declared tax | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BPR | BP | BPR | [BPR]BPR0=[DAT]BPR | Block | ||||
| BSITRS | Bank statement | A | 30 | BSI | ||||
| CHK | Reconciliation | A | 5 | |||||
| CHKDAT | Reconciliation date | D | ||||||
| CHRNUM | Chronological number | VCR | ||||||
| COA | Chart code | COA | [COA]COA0=[DAT]COA | Delete | ||||
| CODAUTACE | Auto journal code | A | 10 | |||||
| CPY | Company | CPY | [CPY]CPY0=[DAT]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[DAT]CREUSR | Other | ||||
| CRIMTC | Matching criteria | A | 80 | |||||
| CSLBPR | Partner | BPR | [BPR]BPR0=[DAT]CSLBPR | Block | PRCSL | |||
| CSLCOD | Partner | A | 10 | CSL | ||||
| CSLFLO | Flow | ADI | [ADI]CODE=324;CSLFLO | Block | CSL1 | |||
| CUR | Currency | CUR | [TCU]TCU0=[DAT]CUR | Block | ||||
| CURLED | Ledger currency | CUR | [TCU]TCU0=[DAT]CURLED | Block | ||||
| DES | Description | DES | ||||||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Block | ||||
| FCYLIN | Site | FCY | [FCY]FCY0=[DAT]FCYLIN | Block | ||||
| FIY | Fiscal year | C | 2 | |||||
| FLGMTC | Flag | C | 1 | |||||
| FREREF | Free reference | REF | ||||||
| IDTLIN | Identifier | A | 5 | |||||
| INDEDVAT | Non-deductible tax | MD1 | KIT | |||||
| LED | Ledger | LED | [LED]LED0=[DAT]LED | Delete | ||||
| LEDTYP | Ledger type | M | 2644 | |||||
| LIN | Line number | C | 3 | |||||
| MRK | Marking | A | 20 | |||||
| MTC | Matching | A | 5 | |||||
| MTCDAT | Matching date | D | ||||||
| MTCDATMAX | Maximum group date | D | ||||||
| MTCDATMIN | Minimum group date | D | ||||||
| NUM | Document no. | VCR | ||||||
| OFFACC | Offset | A | 15 | |||||
| OLDLIG | Line number | C | 3 | |||||
| PCCCOD | Cost type | PJCC | [PJCC]PCC0=[DAT]PCCCOD | Block | PJM | |||
| PER | Period | C | 2 | |||||
| PJTLIN | Project | PJT | [PIM]PIM0=[DAT]PJTLIN | BSRA | PJM | |||
| QTY | Quantity | QTY | ||||||
| REFINTLIN | Internal reference | A | 25 | |||||
| SAC | Control | SAC | ||||||
| SNS | Sign | C | 2 | |||||
| STT1 | Statistics | ADI | [ADI]CODE=351;STT1 | Block | ||||
| STT2 | Statistics | ADI | [ADI]CODE=352;STT2 | Block | ||||
| STT3 | Statistics | ADI | [ADI]CODE=353;STT3 | Block | ||||
| TAX | Tax | VAT | [TVT]TVT0=TAX;[V]GSUPCLE | Block | ||||
| TAX2 | Tax 2 | VAT | [TVT]TVT0=TAX2;[V]GSUPCLE | Block | KDE | |||
| TAX3 | Tax 3 | VAT | [TVT]TVT0=TAX3;[V]GSUPCLE | Block | KDE | |||
| TRCLIG | Line number | C | 4 | |||||
| TYP | Entry type | GTE | [GTE]GTE0=TYP;[V]GSUPCLE | Block | ||||
| UOM | Nonfinancial unit | UOM | [TUN]TUN0=[DAT]UOM | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[DAT]UPDUSR | Other | ||||
| VATDEDRAT | Deductib pro rata | DCB | 3.6 | |||||
| VATRAT | Applied VAT rate | DCB | 3.6 |