Skip To Main Content
Account
Settings
Logout
  • placeholder
Account
Settings
Logout
Filter:
Submit Search
SageX3

Table dictionary Module Financials

    Table V2023R1 V9.0 (P12) V11 (P22) Abbreviation Description Module Activity code
    BADDTER New table New table 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 New table   BLP Pre-consolidation balances Financials PRCSL
    BDTTRK New table New table 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 New table   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 New table New table CSUID TaxUID Financials DCL
    CSVATDAA New table New table CSDAA Online submission data Financials DCL
    CSVATMAP New table New table CSMAP Online submission mapping Financials DCL
    CSVATMAPD New table New table 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 Deleted table   DLVB Belgian VAT header Financials KBE
    DCLVATBOXDBD New table Modification DLVBD VAT detail Financials DCL
    DCLVATBOXH New table   DLVB VAT header Financials DCL
    DCLVATBOXPYD New table 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 New table New table ESTY EC sales types Financials ESL
    ESLSALTYPD New table New table ESTYD EC sales types Financials ESL
    ESLTYPASS New table New table ESTA Assignment by EC sales types Financials ESL
    ESLTYPASSD New table New table 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 New table New table FIFCV FIFO rate calculation Financials FIFRC
    FIFOCONVARD New table New table 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 New table   GDL GST detail Financials KAU
    GSTGRP New table   GSTGH GST group header Financials KAU
    GSTGRPD New table   GSTGD GST group details Financials KAU
    GSTHDR New table   GHR GST header Financials KAU
    GSTPER New table   GSTPH GST reporting period header Financials KAU
    GSTPERD New table   GSTPD GST reporting period details Financials KAU
    GTABACC3     GTC3 Balance graph Financials  
    GTEGRP New table New table GTEGH Entry type groups Financials DCL
    GTEGRPD New table New table 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 New table   IDTC Dimension index Financials PRCSL
    IMURANO New table   IPM Spanish payroll interface setup Financials MURAN
    IMURANOD New table   IPMD Spanish payroll interface setup Financials MURAN
    INVNUMSPA     ISP Source document Financials KSP
    KPYIMPDTL Modification   KPD Sage 50/Murano payroll detail Financials MUIMP
    KPYIMPDTLA New table   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 New table New table REVREC Revenue recognition rules Financials REVRC
    REVRECD New table New table RRCD Rev. recognition rules detail Financials REVRC
    REVRECT New table New table RRCT Revenue recognition Financials REVRC
    REVRECV New table New table REVRECV Revenue recognition header Financials REVRC
    REVRECVD New table New table RRCVD Revenue recognition details Financials REVRC
    SELACC New table New table SACC Selected accounts Financials REVRC
    SPAMOD111 New table Modification SPM111 Spanish form 111 Financials KSP
    SPAMOD115 New table Modification SPM115 Spanish form 115 Financials KSP
    SPAMOD123 New table Modification SPM123 Spanish form 123 Financials KSP
    SPAMOD180 New table   SPM180 Spanish form 180 Financials KSP
    SPAMOD1801 New table Modification SPM1801 Spanish form 180 Financials KSP
    SPAMOD190 New table   SPM190 Spanish form 190 Financials KSP
    SPAMOD1901 New table Modification SPM1901 Spanish form 190 details Financials KSP
    SPAMOD193 New table   SPM193 Spanish form 193 Financials KSP
    SPAMOD1931 New table Modification SPM1931 Spanish form 193_1 Financials KSP
    SPAMOD1932 New table   SPM1932 Spanish form 193_2 Financials KSP
    SPAMOD216 New table Modification SPM216 Spanish form 216 Financials KSP
    SPAMOD296 New table   SPM296 Spanish form 296 Financials KSP
    SPAMOD2961 New table Modification SPM2961 Spanish form 296_1 Financials KSP
    SPAMOD303 New table Modification SPM303 Spanish form 303 Financials KSP
    SPAMOD347 New table New table SPM347 Spanish form 347 Financials KSP
    SPAMOD347D New table New table SPM347D Spanish form 347 Financials KSP
    SPAMOD349 New table   SPM349 Spanish form 349 Financials KSP
    SPAMOD349D New table Modification SPM349D Spanish 349 form detail Financials KSP
    SPAMOD369 New table New table SPM369 Spanish form 369 Financials KSP
    SPAMOD3691 New table New table SPM3691 Spanish form 369 Financials KSP
    SPAMOD3692 New table New table SPM3692 Spanish form 369 Financials KSP
    SPAMOD390 New table New table SPM390 Spanish form 390 Financials KSP
    SPAMOD3901 New table New table SPM3901 Spanish form 390 - detail 1 Financials KSP
    SPAMOD3902 New table New table SPM3902 Spanish form 390 - detail 2 Financials KSP
    SPAMODCPY New table Modification SPMDC Spanish forms by company Financials KSP
    SPAMODDET New table New table SPMDET Spanish forms details Financials KSP
    SPAMODELS New table   SPMOD Spanish forms Financials KSP
    SPASENDINQ New table New table SPSINQ Sending Financials KSP
    SPLIBREG New table 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 New table New table TESL1 EC Sales List Financials ESL
    TMPCNSESL2 New table New table TESL2 EC Sales List Financials ESL
    TMPCNVECAR     TCE Exch. rate temporary table Financials  
    TMPGACCENTRD New table   TMPDAE Accounting entry lines Financials  
    TMPGACCENTRY New table   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 New table New table 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 New table New table VFEP VAT posting Financials DCL
    WHTDTL New table Modification WDL WHT detail Financials KAU
    WHTHDR New table Modification WHR WHT header Financials KAU

Did you find this helpful?

 

Sorry about that

Why wasn't this helpful? (check all that apply)

Thanks for your feedback.

Want to tell us more?

Send an email to our authors to leave your feedback.

Email our authors

Sorry, but we can't provide technical support from this email address. If you need assistance, then please contact our support team directly.

Great!

Thanks for taking the time to give us some feedback.

  • Table dictionary Module Financials
Site links

Sitemap

Sage links

Sage Support Hub

Product support community

General Data Protection Regulation

Legal information

Page info

Page updated: 22 November 2023

Sage media