One moment please...
 
 
Exact Financials   
 

Data dictionary journl - journals - 7.20

#Field nameData typeFormatDecExtentDefaultLabel
1adm_nrinteger>>>>>9 ?Company
2journal_nrinteger>>9 ?Journal
3descriptioncharacterX(60) Description
4abbreviationcharacterx(4) Abbreviation
5type_journalinteger>>>>>9 0Type of journal
6type_vat_handlinginteger>>>>>9 0VAT handling
7bank_acc_nrcharacterx(34) Bank account
8curr_code_bank_acc_nrcharacterx(3) Currency code of bank account number
9postbank_acc_nrcharacterx(34) Postbank
10is_blocked_entry_nrlogicalTRUE/FALSE FALSEBlock entry number
11is_checked_balancelogicalTRUE/FALSE FALSECheck CloseBal/Diff
12is_blocked_entry_datelogicalTRUE/FALSE FALSEBlock entry date
13acc_nrcharacterx(12) Account
14xxxacc_nr_defcharacterx(9) Account number
15acc_nr_paymentscharacterx(12) Payments in transit
16acc_nr_collectionscharacterx(12) Collections in transit
17curr_codecharacterx(3) Currency
18is_variable_exchange_ratelogicalTRUE/FALSE FALSEVariable exchange rate
19is_variable_currencylogicalTRUE/FALSE FALSEVariable currency
20journal_nr_period_allocinteger>>9 0Period allocation journal
21xxxposting_nr_journalinteger>>>>>>>>>9 0Next posting
22xxxscenario_code_defaultcharacterx(8) Default scenario
23is_scenariologicalTRUE/FALSE FALSEScenario via action bar
24xxxis_credit_notelogicalyes/no noCredit note
25type_settlement_journalinteger>>>>>9 0Subsidiary ledger
26is_blockedlogicalTRUE/FALSE FALSEBlock
27descr_mlcharacterX(60) 5 ML description
28source_lccharacterx(12)
29time_lcinteger->,>>>,>>9 ?
30date_lcdate99/99/9999
31euserid_lccharacterX(12)
32type_lccharacterx(8)
33seqnr_reconciliationinteger>>>>9 0Reconciliation status sequence number
34date_reconciliationdate99/99/9999 Date of reconciliation
35balance_jc_reconciliationdecimal->>>,>>>,>>>,>>>,>>9.994 0Balance of reconciliation
36type_bank_journalinteger>>>>>9 0Transit subtype
37ifall_blocklogicalyes/no noBlock for changes
38entity_stateinteger>>>>>9 0State
39term_idinteger>>>>>>>9 0Term ID
40is_commitment_mandatorylogicalTRUE/FALSE FALSECommitment use mandatory
41is_auto_commitmentlogicalTRUE/FALSE FALSECreate commitment
42commitment_amount_fcdecimal->>>,>>>,>>>,>>>,>>9.992 0Max commitment amount
43block_fin_entrieslogicalTRUE/FALSE FALSEBlock: Financial entries
44exceed_commitment_typeinteger>>>>>9 0Exceed commitment
45classificationcharacterx(2) Classification (Commitment)
46exceed_commit_amount_fcdecimal->>>,>>>,>>>,>>>,>>9.994 0Exceed commtiment: Amount FC
47exceed_commit_percentagedecimal>>9.994 0Exceed commitment: Percentage
48unique_entry_nrinteger>>>>>9 0Unique: Entry number
49use_statement_nrlogicaltrue/false FALSEImport: Use statement number

Indexes

journlix - primary - unique

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2journal_nrinteger>>9Journal

journl03ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2entity_stateinteger>>>>>9State
3journal_nrinteger>>9Journal

journl2ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2acc_nrcharacterx(12)Account
3type_journalinteger>>>>>9Type of journal
4journal_nrinteger>>9Journal

Contents > journl

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 26.936.337
 Assortment:  Date: 27-01-2016
 Release:  Attachment:
 Disclaimer