Table dictionary Module Financials
Table V2023R1 | V9.0 (P12) | V11 (P22) | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|---|---|
BADDTER |
![]() |
![]() |
BAT | Bad debt terms | Financials | BADBT |
BALAGEEOY | BGY | EOFY aged overdue invoice list | Financials | |||
BALANA | BLA | Analytical balance | Financials | |||
BALANCE | BAL | General balance | Financials | |||
BALCONSO | Modification | BLC | Consolidation trial balance | Financials | CSL1 | |
BALDEM | BAM | Double entry balance | Financials | KRU | ||
BALDEMIDT | BAI | Double entry balance index | Financials | KRU | ||
BALPRECSL |
![]() |
BLP | Pre-consolidation balances | Financials | PRCSL | |
BDTTRK |
![]() |
![]() |
BDT | Bad debts | Financials | BADBT |
BLACMM | BLM | Analytical commitment balance | Financials | |||
BLAQTY | BLQ | Analytical quantity balance | Financials | |||
BNKTRSIMP | BTI | Import transfers from Sage treasury | Financials | CASIN | ||
BOX1099 | BX9 | 1099 box | Financials | S1099 | ||
BP1096PRN | B96R | 1096 print table | Financials | S1099 | ||
BP1099BEGBAL | B9B | 1099 beginning balance | Financials | S1099 | ||
BP1099PRN | B9R | 1099 print table | Financials | S1099 | ||
BPS1099GEN | B9G | 1099 generation | Financials | S1099 | ||
BPS1099MNT | B9M | Supplier 1099 maintenance | Financials | S1099 | ||
BPS1099PAY | B9P | Supplier 1099 payments | Financials | S1099 | ||
BSEINQ |
![]() |
BSI | Balance sheet inquiry | Financials | ||
BUD | Modification | BUD | Budget table | Financials | ||
BUDAPP | BOA | Budget approval | Financials | GDD | ||
BUDAPPDET | BAD | Approval detail | Financials | GDD | ||
BUDFORCAL | Modification | BUC | Budget calculation formula | Financials | ||
BUDOD | BDE | Budget misc. operations | Financials | |||
BUDODS | Modification | BDO | Budget misc. operations | Financials | ||
BUDPAR | Modification | BUP | Budget setup | Financials | ||
BUDPURAUD | BUA | Audit | Financials | |||
BUDREV | BRV | Budget review | Financials | GDD | ||
BUDREVDET | BVD | Review detail | Financials | GDD | ||
BUDTYP | BUT | Budget type | Financials | GDD | ||
BUDVARCAL | BVC | Budget calculation variable | Financials | |||
BUDVER | BUV | Budget versions | Financials | |||
BUILOCSPA | BLS | Building location | Financials | KSP | ||
CADISTMP | DTP | Budget weighting codes | Financials | |||
CAPFLOTMP | CWT | Capital flow | Financials | KPO | ||
CASHPAYSPA | Modification | Modification | CPS | Cash payments | Financials | KSP |
CDIADSP | Modification | Modification | DAD | Dimension allocations | Financials | |
CSFPARH | CWH | Header extraction parameters | Financials | CSFLO | ||
CSFPARL | CWL | Line extraction parameters | Financials | CSFLO | ||
CSFRES | CWR | Extraction result | Financials | |||
CSFRESD | CSRD | Cash flow analysis | Financials | CSFLO | ||
CSFRESH | CSRH | Cash flow analysis | Financials | CSFLO | ||
CSFRESL | CSRL | Cash flow analysis | Financials | CSFLO | ||
CSTAXUID |
![]() |
![]() |
CSUID | TaxUID | Financials | DCL |
CSVATDAA |
![]() |
![]() |
CSDAA | Online submission data | Financials | DCL |
CSVATMAP |
![]() |
![]() |
CSMAP | Online submission mapping | Financials | DCL |
CSVATMAPD |
![]() |
![]() |
CSMAPD | Online submission mapping | Financials | DCL |
DADCPY | DCP | DASD company | Financials | DAS | ||
DADFCY | Modification | Modification | DFC | DAS2 site | Financials | DAS |
DATEVBPACC | Modification | Modification | DTB | DATEV BP assignment | Financials | DATEV |
DATEVCHRONO | DTC | Financials | KDE | |||
DATEVGLACC | Modification | Modification | DTA | DATEV general acct. assignment | Financials | DATEV |
DATEVTAX | Modification | Modification | DTT | DATEV tax code assignment | Financials | DATEV |
DCLCUSVATBE | DLCB | Annual customer listing | Financials | KBE | ||
DCLCUSVATBED | DLCBD | Annual customer listing | Financials | KBE | ||
DCLEECVATBE | DLEB | EU VAT statement (header) | Financials | KBE | ||
DCLEECVATBED | DLEBD | EU VAT statement (detail) | Financials | KBE | ||
DCLVAT | Modification | DLV | Tax declaration on the debits | Financials | ||
DCLVATBEL |
![]() |
DLVB | Belgian VAT header | Financials | KBE | |
DCLVATBOXDBD |
![]() |
Modification | DLVBD | VAT detail | Financials | DCL |
DCLVATBOXH |
![]() |
DLVB | VAT header | Financials | DCL | |
DCLVATBOXPYD |
![]() |
Modification | DLVBP | VAT detail | Financials | DCL |
DCLVATITA | DVI | Italian VAT detail declaration | Financials | KIT | ||
DCLVATITA2 | DV2 | Italian VAT total declaration | Financials | KIT | ||
DCLVATITA3 | DV3 | Annual italian VAT declaration | Financials | KIT | ||
DCLVATPAY | DVP | Tax declaration / collection | Financials | |||
DCLVATPORB | Modification | Modification | DVPB | VAT base information | Financials | KPO |
DCLVATPORF | DVPF | VAT declaration fields | Financials | KPO | ||
DCLVATPORH | Modification | Modification | DVPH | VAT declaration | Financials | KPO |
DCLVATPORL | DVPL | VAT declaration lines | Financials | KPO | ||
DCLVATPORP | DVPP | VAT parameters | Financials | KPO | ||
DCLVATPORT | Modification | DVPT | Taxes | Financials | KPO | |
DCLVATSPA | Modification | Modification | DVS | Tax working table (SPA) | Financials | KSP |
DUDLNK | Modification | Modification | DLN | Open item links | Financials | WTHMG |
EDTDADSU | EDU | DADSU file print | Financials | DAS | ||
EDTTDS | ETD | TDS file report | Financials | DAS | ||
ENTITE | ENT | Entity | Financials | GDD | ||
ENVELOPPE | ENV | Envelope | Financials | GDD | ||
ENVFIY | ENF | Distribute envelope/fiscal year | Financials | GDD | ||
ESLSALTYP |
![]() |
![]() |
ESTY | EC sales types | Financials | ESL |
ESLSALTYPD |
![]() |
![]() |
ESTYD | EC sales types | Financials | ESL |
ESLTYPASS |
![]() |
![]() |
ESTA | Assignment by EC sales types | Financials | ESL |
ESLTYPASSD |
![]() |
![]() |
ESTAD | Assignment by EC sales types | Financials | ESL |
EURSRVDCL | ESH | European services declaration | Financials | ESD | ||
EURSRVDCLD | ESD | European services declaration | Financials | ESD | ||
FAEPAR | FAE | ACCENTFIL setup | Financials | KFR | ||
FIFOCONVAR |
![]() |
![]() |
FIFCV | FIFO rate calculation | Financials | FIFRC |
FIFOCONVARD |
![]() |
![]() |
FIFCVD | FIFO rate calculation | Financials | FIFRC |
FILTDS | FTD | File structure DADS-U | Financials | DAS | ||
GACCENTRY | Modification | Modification | HAE | Accounting entries | Financials | |
GACCENTRYA | DAA | Analytical accounting line | Financials | |||
GACCENTRYD | Modification | Modification | DAE | Accounting entry lines | Financials | |
GACCFIX | Modification | Modification | GAF | Recurring entries | Financials | |
GACCFIYENA | FYA | C/fwd. temporary file | Financials | |||
GACCFIYEND | FYD | C/fwd. temporary file | Financials | |||
GACCINTCPY | GIC | Intercompany journal entry | Financials | INTCO | ||
GACCINTCPYA | GIA | Intercompany journal ana lines | Financials | INTCO | ||
GACCINTCPYD | GID | Intercompany journal ent lines | Financials | INTCO | ||
GAJOUSTA | JST | Journals - reports per period | Financials | |||
GAPARDUM | PDM | Account balance transfer | Financials | |||
GBAGSCR | GBS | Aged balance screen | Financials | |||
GCLCACEPAR | CLC | Calculated journal entries | Financials | |||
GCOMMIT | CMM | Commitments | Financials | |||
GCOMMITD | CMD | Commitment details | Financials | |||
GCOMMITX | CMX | Commitments (ref) | Financials | |||
GDIAACC | GDA | Account scheme header | Financials | |||
GDIAACCD | GDC | Account scheme lines | Financials | |||
GDIAENTRY | GDE | Entry transactions | Financials | |||
GDIAENTRYD | GDD | Journal entry transactions | Financials | |||
GENTLOT | LOT | Accounting journal batches | Financials | |||
GENTLOTA | LOA | Analytical batch entry lines | Financials | |||
GENTLOTD | LOD | General batch entry lines | Financials | |||
GENTLOTH | LOH | Batch entry header | Financials | |||
GJOUCOA | JCO | Journals - Chart of accounts | Financials | |||
GJOURNAL | Modification | JOU | Journal codes | Financials | ||
GLCONSO | GLC | Consolidation ledger | Financials | CSL | ||
GRPCUR | GCU | Currency groups | Financials | |||
GRPDSP | GSP | Distribution groups | Financials | |||
GRPSAC | GSC | Control groups | Financials | |||
GSTDTL |
![]() |
GDL | GST detail | Financials | KAU | |
GSTGRP |
![]() |
GSTGH | GST group header | Financials | KAU | |
GSTGRPD |
![]() |
GSTGD | GST group details | Financials | KAU | |
GSTHDR |
![]() |
GHR | GST header | Financials | KAU | |
GSTPER |
![]() |
GSTPH | GST reporting period header | Financials | KAU | |
GSTPERD |
![]() |
GSTPD | GST reporting period details | Financials | KAU | |
GTABACC3 | GTC3 | Balance graph | Financials | |||
GTEGRP |
![]() |
![]() |
GTEGH | Entry type groups | Financials | DCL |
GTEGRPD |
![]() |
![]() |
GTEGD | Entry type groups | Financials | DCL |
GTMPMTC | GMT | Temporary matching table | Financials | |||
HISTAXSPA | HTS | Tax extraction history | Financials | KSP | ||
HISTOAMD | Modification | Modification | HAM | Amendment history | Financials | SDD |
HON281 | Modification | Modification | HHO | 281.5 fees (Belgium) | Financials | BE281 |
HON281D | DHO | 281.5 fees details | Financials | BE281 | ||
HONLIN | HLN | Fee lines | Financials | DAS | ||
HONPRV | Modification | Modification | PRV | Service suppliers | Financials | FEE2 |
IDTCCE |
![]() |
IDTC | Dimension index | Financials | PRCSL | |
IMURANO |
![]() |
IPM | Spanish payroll interface setup | Financials | MURAN | |
IMURANOD |
![]() |
IPMD | Spanish payroll interface setup | Financials | MURAN | |
INVNUMSPA | ISP | Source document | Financials | KSP | ||
KPYIMPDTL | Modification | KPD | Sage 50/Murano payroll detail | Financials | MUIMP | |
KPYIMPDTLA |
![]() |
KPA | Analytical line | Financials | MURAN | |
KPYIMPHDR | Modification | KPH | Sage 50/Murano payroll header | Financials | MUIMP | |
KPYIMPTRAN | Modification | Modification | KPT | Sage 50 import transcribe | Financials | MUIMP |
MATCHCODE | MTC | Match letters to use | Financials | |||
MTCAUTO | MTU | Automatic matching | Financials | |||
MTCBATCH | MTB | Batch matching | Financials | |||
MTCGAUTMP | MGT | Document matching preparation | Financials | |||
NRYPAR | NRY | ENERGY setup | Financials | FAL | ||
PAYVAT | Modification | PYHV | Cash VAT (Portugal) | Financials | KPO | |
PBDCONFIG | PBDCNF | Payment balance configuration | Financials | PBDCL | ||
PBDCONFIGD | PBDCNFD | Payment balance configuration | Financials | PBDCL | ||
PBDECODITM | PBDEIT | Economic reason by product | Financials | PBDCL | ||
PBDGEN | PBDGEN | Payment balance declaration | Financials | PBDCL | ||
PBDGEND | PBDGEND | Payment balance decl details | Financials | PBDCL | ||
PBDUICONF | PBDUIC | Payment balance field settings | Financials | PBDCL | ||
PBDUICONFD | PBDUID | Payment balance field lines | Financials | PBDCL | ||
PRJFAS | PJF | Assets | Financials | GDFAS | ||
PRJLOT | PJL | Lot | Financials | GDD | ||
PRMDADSU | PRM | Extraction parameterization | Financials | DAS | ||
PROJET | PRJ | Project | Financials | GDD | ||
PYHCAS | PCH | Treasury interface | Financials | CASIN | ||
REPLINDEF | RLI | TaxUID management | Financials | KDEAT | ||
REVREC |
![]() |
![]() |
REVREC | Revenue recognition rules | Financials | REVRC |
REVRECD |
![]() |
![]() |
RRCD | Rev. recognition rules detail | Financials | REVRC |
REVRECT |
![]() |
![]() |
RRCT | Revenue recognition | Financials | REVRC |
REVRECV |
![]() |
![]() |
REVRECV | Revenue recognition header | Financials | REVRC |
REVRECVD |
![]() |
![]() |
RRCVD | Revenue recognition details | Financials | REVRC |
SELACC |
![]() |
![]() |
SACC | Selected accounts | Financials | REVRC |
SPAMOD111 |
![]() |
Modification | SPM111 | Spanish form 111 | Financials | KSP |
SPAMOD115 |
![]() |
Modification | SPM115 | Spanish form 115 | Financials | KSP |
SPAMOD123 |
![]() |
Modification | SPM123 | Spanish form 123 | Financials | KSP |
SPAMOD180 |
![]() |
SPM180 | Spanish form 180 | Financials | KSP | |
SPAMOD1801 |
![]() |
Modification | SPM1801 | Spanish form 180 | Financials | KSP |
SPAMOD190 |
![]() |
SPM190 | Spanish form 190 | Financials | KSP | |
SPAMOD1901 |
![]() |
Modification | SPM1901 | Spanish form 190 details | Financials | KSP |
SPAMOD193 |
![]() |
SPM193 | Spanish form 193 | Financials | KSP | |
SPAMOD1931 |
![]() |
Modification | SPM1931 | Spanish form 193_1 | Financials | KSP |
SPAMOD1932 |
![]() |
SPM1932 | Spanish form 193_2 | Financials | KSP | |
SPAMOD216 |
![]() |
Modification | SPM216 | Spanish form 216 | Financials | KSP |
SPAMOD296 |
![]() |
SPM296 | Spanish form 296 | Financials | KSP | |
SPAMOD2961 |
![]() |
Modification | SPM2961 | Spanish form 296_1 | Financials | KSP |
SPAMOD303 |
![]() |
Modification | SPM303 | Spanish form 303 | Financials | KSP |
SPAMOD347 |
![]() |
![]() |
SPM347 | Spanish form 347 | Financials | KSP |
SPAMOD347D |
![]() |
![]() |
SPM347D | Spanish form 347 | Financials | KSP |
SPAMOD349 |
![]() |
SPM349 | Spanish form 349 | Financials | KSP | |
SPAMOD349D |
![]() |
Modification | SPM349D | Spanish 349 form detail | Financials | KSP |
SPAMOD369 |
![]() |
![]() |
SPM369 | Spanish form 369 | Financials | KSP |
SPAMOD3691 |
![]() |
![]() |
SPM3691 | Spanish form 369 | Financials | KSP |
SPAMOD3692 |
![]() |
![]() |
SPM3692 | Spanish form 369 | Financials | KSP |
SPAMOD390 |
![]() |
![]() |
SPM390 | Spanish form 390 | Financials | KSP |
SPAMOD3901 |
![]() |
![]() |
SPM3901 | Spanish form 390 - detail 1 | Financials | KSP |
SPAMOD3902 |
![]() |
![]() |
SPM3902 | Spanish form 390 - detail 2 | Financials | KSP |
SPAMODCPY |
![]() |
Modification | SPMDC | Spanish forms by company | Financials | KSP |
SPAMODDET |
![]() |
![]() |
SPMDET | Spanish forms details | Financials | KSP |
SPAMODELS |
![]() |
SPMOD | Spanish forms | Financials | KSP | |
SPASENDINQ |
![]() |
![]() |
SPSINQ | Sending | Financials | KSP |
SPLIBREG |
![]() |
Modification | SPLREG | Bookkeeping | Financials | KSP |
TABBUDTYP | Modification | TBU | Budget transactions | Financials | ||
TABFILCASH | TFC | Treasury file | Financials | CASIN | ||
TABFILTDS | Modification | TFT | Fee declaration file | Financials | FEE2 | |
TDSPRV | TPR | Fee total/service supplier | Financials | DAS | ||
TMPBLA | Modification | TBL | Temporary print key table | Financials | ||
TMPCNSESL1 |
![]() |
![]() |
TESL1 | EC Sales List | Financials | ESL |
TMPCNSESL2 |
![]() |
![]() |
TESL2 | EC Sales List | Financials | ESL |
TMPCNVECAR | TCE | Exch. rate temporary table | Financials | |||
TMPGACCENTRD |
![]() |
TMPDAE | Accounting entry lines | Financials | ||
TMPGACCENTRY |
![]() |
TMPHAE | Accounting entries | Financials | ||
TXSA | TXS | Financial data extraction parameters | Financials | TDB | ||
TXSAC | TXA | Grid column setup | Financials | TDB | ||
TXSD | TXD | Financial data extraction detail | Financials | TDB | ||
TXSM | TXM | Amounts | Financials | TDB | ||
TXSP | TXP | Value parameters/version | Financials | TDB | ||
TXSV | TXX | Fin data extras variables | Financials | TDB | ||
TXSW | TXW | Versions | Financials | TDB | ||
VATBOX | Modification | Modification | VTB | VAT boxes | Financials | DCL |
VATBOXD | Modification | Modification | VTD | VAT boxes | Financials | DCL |
VATENTFRM | Modification | Modification | VEF | VAT form (definition) | Financials | DCL |
VATENTFRMD | Modification | Modification | VEFD | VAT form detail (definition) | Financials | DCL |
VATFRMENT | Modification | Modification | VFE | VAT form (values) | Financials | DCL |
VATFRMENTA | Modification | Modification | VFEA | VAT form | Financials | DCL |
VATFRMENTC | Modification | Modification | VFEC | VAT form by company | Financials | DCL |
VATFRMENTD | Modification | Modification | VFED | VAT form detail (values) | Financials | DCL |
VATFRMENTI |
![]() |
![]() |
VFEI | VAT return service data | Financials | DCL |
VATFRMENTN | Modification | Modification | VFEN | VAT form queries | Financials | DCL |
VATGRP | Modification | Modification | VATGH | VAT entity header | Financials | DCL |
VATGRPD | Modification | Modification | VATGD | VAT entity details | Financials | DCL |
VDGERRSP | RSP | Recapitulative statem. param. | Financials | KDEAT | ||
VDGERTRP | TRPG | German tax return parameter | Financials | KDEAT | ||
VDSWITRP | Modification | Modification | TRSP | Switzerland | Financials | KSW |
VFEPSTTMP |
![]() |
![]() |
VFEP | VAT posting | Financials | DCL |
WHTDTL |
![]() |
Modification | WDL | WHT detail | Financials | KAU |
WHTHDR |
![]() |
Modification | WHR | WHT header | Financials | KAU |