Exact Financials      Data dictionary exactcs - contents - 7.20 # Table Logging table Description 1 admdat y_admdat Company data 2 admnac   Delivery addresses 3 atrsh   Financial entries 4 atrss   entry lines 5 balcen   sub-balance sheet cost centers 6 balcun   sub-balance sheet cost units 7 balsht   balance sheet 8 bdalcch y_bdalcch Budget ccent allocation header 9 bdalccl y_bdalccl Budget ccent allocation line 10 bdalcuh   Budget cunit allocation header 11 bdalcul   Budget cunit allocation line 12 bdalloch   Budget ccent allocation header 13 bdallocl   Budget ccent allocation line 14 bdalph y_bdalph Budget per allocation header 15 bdalpl y_bdalpl Budget per allocation line 16 bdcumdat   Budget cumulative data 17 bdeauth   Budget authority entry header 18 bdeautl   Budget entry line 19 bdenth   Budget entry header 20 bdentl   Budget entry line 21 bdmng y_bdmng Budget manager 22 bdpath   Budget entry path 23 bdtaut   Budget authority transaction 24 bdtautt   Budget auth. trans. notes 25 bdtrs   Budget transaction 26 bdtrst   Budget transaction notes 27 bdvers y_bdvers Budget version 28 bnkacc y_bnkacc Bank accounts 29 bnklnk y_bnklnk Bank links 30 bnktpe y_bnktpe Bank account types 31 boeacc y_boeacc Cheque & B/E accounts 32 boeccb   Creditor cheque & B/E data 33 boecdl y_boecdl B/E creditor data 34 boechb y_boechb Cheque books 35 boecod y_boecod Cheque & B/E codes 36 boecrd   Creditors cheques & B/E's 37 boedbl y_boedbl B/E debtor data 38 boedcb   Debtor cheque & B/E data 39 boedeb   Debtor cheques & B/E's 40 boenom y_boenom Nature of movement 41 boepyt   Payment terms B/E's 42 boercd y_boercd Reason codes 43 boetrc   Creditor cheque & B/E transac 44 boetrd   Debtor cheque & B/E transacti 45 boetrf   Remittances 46 bstats   Bank statements 47 ccent y_ccent Cost centers 48 ccnacc y_ccnacc link cost center account 49 ccnlnk y_ccnlnk linking cost centers 50 ccntrs   Cost center transactions 51 claims   Claims 52 colarr y_colarr Collection arrangements 53 combud   Year budgets 54 comcls y_comcls Classifications 55 comctr y_comctr Contracts 56 comctr_t   Contract notes 57 comel   Commitment entry lines 58 comhl   Commitments 59 comp y_comp sub-classifications 60 comsl   Commitment lines 61 comsl_t   Commitment notes 62 comtrs   Commitment transactions 63 conscc y_conscc Consolidation cost center 64 consco y_consco Consolidation company 65 conscu y_conscu Consolidation cost unit 66 consgg   Consolidation data 67 contab y_contab consolidation table 68 countr y_countr countries 69 crdbal   creditor balances 70 crdcat y_crdcat Creditor categories 71 crdnac   Order addresses 72 crdout   outstanding entries creditors 73 crdrev   revaluation creditors 74 crdtrs   creditor transactions 75 credit y_credit creditors 76 credit_t   creditor notes 77 cstccn y_cstccn Standard distr. cost center 78 cstcun   Standard distr. cost units 79 cunacc y_cunacc link cost unit account 80 cunit y_cunit cost units 81 curren y_curren currencies 82 dbver y_dbver Database versions 83 debbal   debtor balances 84 debcat y_debcat Debtor categories 85 debout   outstanding entries debtors 86 debrev   revaluation debtors 87 debtor y_debtor debtors 88 debtor_t   debtor notes 89 debtrs   debtor transactions 90 delnac y_delnac delivery addresses 91 dpr_cald y_dpr_cald Calendar period 92 dpr_calm y_dpr_calm Depreciation calendar 93 dpr_idxd y_dpr_idxd Depreciation index detail 94 dpr_idxm y_dpr_idxm Depreciation index table 95 dpr_mtab y_dpr_mtab Depreciation table 96 dpr_trns   Depreciation transactions 97 eappl   application 98 earole y_earole Exact roles 99 earolrec y_earolrec Records per role 100 earolusr y_earolusr Roles per user 101 ebabnk y_ebabnk Banks 102 ebabnk_mt940   Bank statement: MT940 codes 103 ebabnk_txcd   Bank statement transaction code 104 ebalnk y_ebalnk Bank links 105 ebasth   Statements 106 ebasts   Statement lines 107 ebauit   Itemizations 108 egroup   group definition 109 elang   languages 110 emenu   menu definition 111 emenutext   menutext 112 eprog   programs 113 eproggroup   program group 114 eproguser   program user 115 faelaf   Link assets fin. entries 116 fas_asmb y_fas_asmb Assembled asset 117 fas_ast y_fas_ast Asset 118 fas_book y_fas_book Asset book 119 fas_depr y_fas_depr Asset depreciation data 120 fas_dept y_fas_dept Department 121 fas_grp y_fas_grp Asset group 122 fas_loc y_fas_loc Location 123 fas_mast y_fas_mast Asset set 124 fas_mnt   Asset maintenance data 125 fas_mthl y_fas_mthl Asset set in book 126 fas_note   Asset note 127 fas_prlnk   Link asset trans to project 128 fas_prmst   Projects per asset 129 fatlaf   Link assets fin. transactions 130 fiecol   Collection advices 131 fielbsf   Link: Bank statement (Historic) to journal entry 132 fielcf   Link collections fin. entries 133 fielfc   Link atrss to comsl 134 fielif   Link intercompany to finance 135 fielpayf   Link: Payment (Historic) to journal entry 136 fielrf   Link recurring entries to fina 137 fihbsh   Bank statements (Historic) 138 fihbsl   Bank statement lines (Historic) 139 fihpayext   Payment extra data (Historic) 140 fihpayfmt   Payment formats (Historic) 141 fihpayord   Payment orders (Historic) 142 fihpayout   Payment outstanding items (Historic) 143 fihpayrun   Payment runs (Historic) 144 fiicomp   Intercompany 145 filda   Link dimensions to G/L account 146 fipcolh y_fipcolh Periodic collection 147 fipcoll y_fipcoll Periodic collection details 148 fireh y_fireh Recurring entry headers 149 firel y_firel Recurring entry lines 150 fitcol   Collection history 151 fitlbsf   Link: Bank statement (Historic) to g/l transaction 152 fitlcf   Link collections fin. entries 153 fitlfc   Link ledtrs to comtrs 154 fitlif   Link intercompany to finance 155 fitlpayf   Link: Payment (Historic) to g/l transaction 156 fitlrf   Link recurring entries to fina 157 fivatcor   VAT correction 158 fprep   posting report per period 159 grpfdc   Layout group flag descriptions 160 horder   Sales order history 161 hordert   Sales order notes 162 horitm   Sales order history lines 163 hortxt   Sales order history text lines 164 iiown y_iiown Invoice owner 165 iireg   Incoming invoices registration 166 invhhl   Invoice history 167 invhhlt   Sales invoice notes 168 invhsl   Invoice history lines 169 invhtl   Invoice history texts 170 isocnt y_isocnt ISO countries 171 isocur y_isocur ISO currencies 172 isolng y_isolng ISO languages 173 journl y_journl journals 174 journl_rule   Bank statement: Matching rules 175 jrlpay y_jrlpay Journal link payments 176 jrlpcr y_jrlpcr Journal link payment valuta 177 jrnlbal   journal-balance 178 lang y_lang languages 179 laydeb y_laydeb Reminder layouts 180 layfdc   Layout flag descriptions 181 layfgr   Layout fields per group 182 layfld   Fields per layout 183 layflg   Flags per layout 184 laygdc   Layout group descriptions 185 laygfl   Flags per layout group 186 laygrf   Layout group flags 187 laygrp   Layout type groups 188 laytfl   Layout type flags 189 ledbal   general ledger balances 190 ledger y_ledger general ledger accounts 191 ledmch   matching transactions 192 ledrev   revaluation general ledger 193 ledtrs   general ledger transactions 194 licdat y_licdat License data 195 llcoc y_llcoc Cost codes 196 llcocd y_llcocd Cost code details 197 llcoct y_llcoct Cost code tables 198 lldesc y_lldesc Extra description codes 199 lldome y_lldome Delivery/Order methods 200 llicnt   Item counters 201 llides y_llides Extra item descriptions 202 lligrp y_lligrp Item groups 203 llinvc y_llinvc Invoice codes 204 llitcr y_llitcr Creditor/item data 205 llitem y_llitem Items 206 llitxt y_llitxt Text items 207 lllgrr   Link recurring to generated 208 lllrr   Link recurring to relation 209 llpdig y_llpdig Price list details per item gr 210 llpdit y_llpdit Price list details per item 211 llplig y_llplig Price lists per item group 212 llplit y_llplit Price lists per item 213 llplst y_llplst Price lists 214 llrech   Recurring headers 215 llrecht   Recurring notes 216 llrecl   Recurring lines 217 llrect   Recurring text lines 218 lltext y_lltext General text codes 219 logfield   Logged fields 220 loghist   Log delete history 221 logrec   Logging of records 222 logsett y_logsett Logging settings 223 logtable   Logged tables 224 lpech   Purchase order counter headers 225 lpecih   Purchase invoice counter head 226 lpecil   Purchase invoice counter lines 227 lpecl   Purchase order counter lines 228 lpecrh   Receipt counter headers 229 lpecrl   Receipt counter lines 230 lpeih   Purchase invoice headers 231 lpeiht   Purchase invoice notes 232 lpeil   Purchase invoice lines 233 lpeit   Purchase invoice text lines 234 lpelic   Link invoices to commitments 235 lpelif   Link purchase invoices to fina 236 lpelio   Link purchase invoices to purc 237 lpelir   Link purchase invoices to rece 238 lpelmf   Link matching to finance 239 lpeloc   Link orders to commitments 240 lpelof   Link purchase orders to financ 241 lpelrf   Link receipts to finance 242 lpelro   Link receipts to purchase orde 243 lpelsp   Link sales to purchase 244 lpemio   Matching purchase invoices/ord 245 lpemro   Matching receipts/purchase ord 246 lpeoh   Purchase order headers 247 lpeoht   Purchase order notes 248 lpeol   Purchase order lines 249 lpeot   Purchase order text lines 250 lperh   Receipt headers 251 lperht   Receipt notes 252 lperl   Receipt lines 253 lpert   Receipt text lines 254 lphch   Purchase order counter history 255 lphcih   Purchase invoice counter head 256 lphcil   Purchase invoice counter line 257 lphcl   Purchase order counter history 258 lphcrh   Receipt counter headers 259 lphcrl   Receipt counter lines 260 lphih   Purchase invoice header histor 261 lphiht   Purchase invoice notes 262 lphil   Purchase invoice line history 263 lphit   Purchase invoice text line his 264 lphlic   Link lphil to comsl 265 lphlif   Link purchase invoices to fina 266 lphlio   Link purchase invoices to purc 267 lphlir   Link purchase invoices to rece 268 lphlmf   Link matching to finance 269 lphloc   Link lphol to comsl 270 lphlof   Link purchase orders to financ 271 lphlrf   Link receipts to finance 272 lphlro   Link receipt history to purcha 273 lphlsp   Link sales to purchase 274 lphmil   Purchase invoice matching line 275 lphmio   Matching purchase invoice/orde 276 lphmoh   Purchase order matching 277 lphmoi   Matching purchase order/invoic 278 lphmol   Purchase order matching lines 279 lphmor   Matching purchase order/receip 280 lphmrl   Receipt matching lines 281 lphmro   Matching receipt/purchase orde 282 lphoh   Purchase order history headers 283 lphoht   Purchase order history notes 284 lphol   Purchase order history lines 285 lphot   Purchase order history text li 286 lphrh   Receipt history headers 287 lphrht   Receipt history notes 288 lphrl   Receipt history lines 289 lphrt   Receipt history text lines 290 lselif   Link sales to finance 291 lselof   Link sales orders to finance 292 lshlof   Link sales orders to finance 293 lsihl   Sales invoice headers 294 lsihlt   Sales invoice notes 295 lsisl   Sales invoice lines 296 lsitl   Sales invoice text lines 297 lsitst y_lsitst Stock changes 298 lsohl   Sales order headers 299 lsohlt   Sales order notes 300 lsosl   Sales order lines 301 lsotl   Sales order text lines 302 lsrep y_lsrep Representatives 303 lsrevs   Revenue statistics 304 lstlif   Link sales to finance 305 mcomp y_mcomp Main classifications 306 mdim1 y_mdim1 multidim 1 307 mdim2 y_mdim2 multidim 2 308 mdim3 y_mdim3 multidim 3 309 mdim4 y_mdim4 multidim 4 310 mdim5 y_mdim5 multidim 5 311 paycon y_paycon payment conditions 312 payext   Payment extra data 313 payfmt   Payment format 314 paymen   payments 315 payord   Payment order 316 payout   Payment outstanding items 317 paysel   Payment selections 318 percls y_percls closed periods 319 perdat y_perdat Period-date table 320 pochl   Payment over companies header 321 pocsl   Payment over companies lines 322 practv   Activities 323 prbudget   Project budget 324 prcajt y_prcajt Cost alloc. per journal. type 325 prcall y_prcall Cost allocation 326 prccat y_prccat Cost category 327 prccma y_prccma Cost center manager 328 prdeb y_prdeb Project debtor 329 prdeh   Direct entry headline 330 prdep y_prdep Department 331 prdes   Direct entry subline 332 prdhrt y_prdhrt Debtor hour category rate 333 prdprt y_prdprt Debtor position rate 334 prdtrs   Direct transaction 335 prelpf   Link project to finance 336 premp y_premp Employee 337 premrt y_premrt Employee rate per project 338 prghrt y_prghrt Project group hour cat. rate 339 prgprt y_prgprt Project group position rate 340 prgrp y_prgrp Project group 341 prhcat y_prhcat Hour category 342 prhcrt y_prhcrt Hour category rate per project 343 prheh   Hour entry headline 344 prhes   Hour entry subline 345 prhrat y_prhrat Employee rate p. hcat. 346 prhrpr y_prhrpr Empl. rate p. hcat p. project 347 prhtrs   Hour transaction 348 prieh   Item entry headline 349 pries   Item entry subline 350 prinam   Amount to be invoiced 351 prinfi   Final invoice 352 prinfi_t   Final invoice text 353 pringc y_pringc Ccat per invoice group line 354 pringh y_pringh Invoice group header 355 pringl y_pringl Invoice group line 356 pringl_t   Invoice group line text 357 prinph   Invoice proposal 358 prinps   Invoice proposal line 359 prinsh y_prinsh Installment header 360 prinss y_prinss Installment line 361 prinss_t   Installment line text 362 printr   Amount to be invoiced transact 363 printr_t   Amounts to be invoiced text 364 pritrs   Item transaction 365 prjamt   Amount to be journalized 366 prjtcc y_prjtcc Journalizing type per ccat 367 prjtgr y_prjtgr Journal. type per proj. grp. 368 prjtyp y_prjtyp Journalizing type 369 prloc y_prloc Location 370 prmach y_prmach Machinery 371 prmeh   Machinery entry headline 372 prmes   Machinery entry subline 373 prmrat y_prmrat Machinery-unit rate 374 prmst y_prmst Project mastercard 375 prmstdeb y_prmstdeb Debtors per project 376 prmst_t   Project mastercard note 377 prmtrs   Machinery transaction 378 prndef y_prndef printer definitions 379 prnfrm y_prnfrm Printerforms 380 prnusr y_prnusr user printers 381 props y_props Properties 382 props_t   Properties texts 383 prphdf y_prphdf Phase list description 384 prphlp y_prphlp Project phase list definition 385 prphse y_prphse Phase 386 prphsn y_prphsn Phase list 387 prpmc y_prpmc Properties multiple choice 388 prpmrt y_prpmrt Machinery rate per project 389 prpmst y_prpmst Sub project 390 prpmur y_prpmur Mach. rate per unit per proj. 391 prpos y_prpos Position 392 prpsrt y_prpsrt Position rate per project 393 prpurt y_prpurt Unit rate per project 394 prpval y_prpval Property values 395 prrate   Project rates 396 prrcca   Result cost category 397 prrcyp   Result ccat per period 398 prreason   Project budget (Change code) 399 prrhca   Result hour category 400 prrhyp   Result hcat per period 401 prritm   Result item 402 prriyp   Result item per period 403 prrmch   Result machinery 404 prrmyp   Result machinery per period 405 prrprj   Result project 406 prrpyp   Result project per period 407 prrtcca   Result cost category 408 prrtcyp   Result ccat per period 409 prrthca   Result hour category 410 prrthyp   Result hcat per period 411 prrtitm   Result item 412 prrtiyp   Result item per period 413 prrtmch   Result machinery 414 prrtmyp   Result machinery per period 415 prrtprj   Result project 416 prrtpyp   Result project per period 417 prrtty y_prrtty Rate type 418 prsccn y_prsccn Sub cost center 419 prsdep y_prsdep Sub department 420 prstat y_prstat Project state 421 prsurc y_prsurc Surcharge code 422 prtlpf   Link project to finance 423 prtrs   Project transactions 424 prtype y_prtype Project type 425 prunit y_prunit Project unit 426 prwiph   Work in progress 427 prwipl   Work in progress (Line) 428 prxes   Project external entry 429 prxlf   Link to finance 430 prxlp   Link purchase 431 prxlsi   Link sales invoice 432 prxlso   Link sales order 433 prxtrs   Project external transaction 434 rplcod   Report layout 435 scencode y_scencode Scenario codes 436 scentry y_scentry scenario entry lines 437 stalog   Action logging 438 stbent y_stbent Base entity 439 stbic y_stbic Bank Identifier Code 440 stblev y_stblev Base level 441 stbrlay   Browse layouts 442 stbrlayf   Browse layout fields 443 stcumdat   Cumulative data 444 stcumdef   Cumulative data definitions 445 stdefchg y_stdefchg Defaults and changeability 446 stdefico   Default icons 447 stestrh   Structure entry header 448 stestrl   Structure entry line 449 stetask   Tasks (current) 450 stexca   External categories 451 stexob   External objects 452 stextend   Table extensions 453 stformula   Formula 454 stgrpico   Icon group 455 sthtask   Tasks (current) 456 sticon   Icons 457 stifex   IFALL external calls 458 stjobh y_stjobh Job 459 stjobl y_stjobl Job parameters 460 stlnglay y_stlnglay Layouts per language 461 stltrm   Link terms to master data 462 stnactype y_stnactype Address type 463 stpostal   Postal codes 464 strecent   Application start 465 strule y_strule Rules 466 struleusr y_struleusr Rule users 467 ststrdet   Structure details 468 ststruc y_ststruc Structure 469 sttask   Task 470 stterm   Terms 471 sttran   Translations 472 sttsklst   Task list 473 sttstr   Structure transaction 474 sttstrt   Structure transaction notes 475 stuiprop   User interface properties 476 stuser y_stuser Users 477 stusgrp   User groups 478 stusrol   Roles per user 479 stusrpwd   User passwords 480 stxlink   XML export / import definition 481 stxlnode   Link node 482 stxsattp   Schema attribute type 483 stxsattr   Schema attribute 484 stxschem   XML Schema 485 stxselem   Schema element 486 stxseltp   Schema element type 487 titles y_titles titles 488 t_tdef y_t_tdef Test type definitions 489 t_tdfd y_t_tdfd Test type descriptions 490 t_tdsc y_t_tdsc Test field descriptions 491 t_test y_t_test Test field values 492 units y_units Units 493 usrlay   Layouts 494 vatbox y_vatbox VAT return boxes 495 vatbox_amt   VAT return box: Amounts 496 vathis   VAT history 497 vatlnb y_vatlnb VAT linked boxes 498 vatlnt   VAT linked total boxes 499 vatrep y_vatrep VAT fiscal representative 500 vattrs y_vattrs VAT codes 501 vouchl   Voucher headers 502 voucsl   Voucher sublines 503 xrates   exchange rates 504 z_findat   financial year data 505 z_link   Restrictions 506 z_sett y_z_sett Settings 507 z_sev   Several data 508 z_text   Text definitions 509 z_uset y_z_uset user settings Startpagina Exact Financials Enterprise 7.20 > Data dictionary exactcs        Main Category: Support Product Know How  Document Type: Online help main  Category: On-line help files  Security  level: All - 0  Sub category: Details  Document ID: 26.936.146  Assortment: Exact Financials  Date: 29-01-2016  Release: 7.20  Attachment:  Disclaimer