Table | Abbreviation | Title | 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 | G/L accounts | GAC | [GAC]GAC0=COA;ACC | Block | ||||
ACCDAT | Accounting date | D | ||||||
ACCNUM | Internal number | L | 8 | |||||
ACCNUMDOE | Counterpart number | C | 4 | KRU | ||||
ACCNUMORI | Source number | L | 8 | |||||
AMTCUR | Amount in currency | MD1 | ||||||
AMTFLG | Forced amount | M | 4 | 1 | ||||
AMTLED | Ledger amount | MD1 | ||||||
AMTLED1 | Forced amount | MD1 | ||||||
AMTVAT | Declared VAT | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BPR | BPs | BPR | ||||||
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 | |||||
CSLCOD | Partners | A | 10 | CSL | ||||
CSLFLO | Flow | A | 10 | CSL | ||||
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 VAT | DCB | 19.8 | 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 | Counterpart account | A | 15 | |||||
OLDLIG | Line number | C | 3 | |||||
PER | Period | C | 2 | |||||
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=[DAT]TAX | BSRA | ||||
TAX2 | Tax | VAT | [TVT]TVT0=[DAT]TAX2 | BSRA | ||||
TAX3 | Tax | VAT | [TVT]TVT0=[DAT]TAX3 | BSRA | ||||
TRCLIG | Line number | C | 4 | |||||
TYP | Entry type | GTE | ||||||
UOM | Non-financial unit | UOM | [TUN]TUN0=[DAT]UOM | Block | ||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[DAT]UPDUSR | Other |