|
|
Data dictionary journl - journals - 7.20
| 1 | adm_nr | integer | >>>>>9 | | | ? | Company | | 2 | journal_nr | integer | >>9 | | | ? | Journal | | 3 | description | character | X(60) | | | | Description | | 4 | abbreviation | character | x(4) | | | | Abbreviation | | 5 | type_journal | integer | >>>>>9 | | | 0 | Type of journal | | 6 | type_vat_handling | integer | >>>>>9 | | | 0 | VAT handling | | 7 | bank_acc_nr | character | x(34) | | | | Bank account | | 8 | curr_code_bank_acc_nr | character | x(3) | | | | Currency code of bank account number | | 9 | postbank_acc_nr | character | x(34) | | | | Postbank | | 10 | is_blocked_entry_nr | logical | TRUE/FALSE | | | FALSE | Block entry number | | 11 | is_checked_balance | logical | TRUE/FALSE | | | FALSE | Check CloseBal/Diff | | 12 | is_blocked_entry_date | logical | TRUE/FALSE | | | FALSE | Block entry date | | 13 | acc_nr | character | x(12) | | | | Account | | 14 | xxxacc_nr_def | character | x(9) | | | | Account number | | 15 | acc_nr_payments | character | x(12) | | | | Payments in transit | | 16 | acc_nr_collections | character | x(12) | | | | Collections in transit | | 17 | curr_code | character | x(3) | | | | Currency | | 18 | is_variable_exchange_rate | logical | TRUE/FALSE | | | FALSE | Variable exchange rate | | 19 | is_variable_currency | logical | TRUE/FALSE | | | FALSE | Variable currency | | 20 | journal_nr_period_alloc | integer | >>9 | | | 0 | Period allocation journal | | 21 | xxxposting_nr_journal | integer | >>>>>>>>>9 | | | 0 | Next posting | | 22 | xxxscenario_code_default | character | x(8) | | | | Default scenario | | 23 | is_scenario | logical | TRUE/FALSE | | | FALSE | Scenario via action bar | | 24 | xxxis_credit_note | logical | yes/no | | | no | Credit note | | 25 | type_settlement_journal | integer | >>>>>9 | | | 0 | Subsidiary ledger | | 26 | is_blocked | logical | TRUE/FALSE | | | FALSE | Block | | 27 | descr_ml | character | X(60) | | 5 | | ML description | | 28 | source_lc | character | x(12) | | | | | | 29 | time_lc | integer | ->,>>>,>>9 | | | ? | | | 30 | date_lc | date | 99/99/9999 | | | | | | 31 | euserid_lc | character | X(12) | | | | | | 32 | type_lc | character | x(8) | | | | | | 33 | seqnr_reconciliation | integer | >>>>9 | | | 0 | Reconciliation status sequence number | | 34 | date_reconciliation | date | 99/99/9999 | | | | Date of reconciliation | | 35 | balance_jc_reconciliation | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Balance of reconciliation | | 36 | type_bank_journal | integer | >>>>>9 | | | 0 | Transit subtype | | 37 | ifall_block | logical | yes/no | | | no | Block for changes | | 38 | entity_state | integer | >>>>>9 | | | 0 | State | | 39 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | | 40 | is_commitment_mandatory | logical | TRUE/FALSE | | | FALSE | Commitment use mandatory | | 41 | is_auto_commitment | logical | TRUE/FALSE | | | FALSE | Create commitment | | 42 | commitment_amount_fc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 2 | | 0 | Max commitment amount | | 43 | block_fin_entries | logical | TRUE/FALSE | | | FALSE | Block: Financial entries | | 44 | exceed_commitment_type | integer | >>>>>9 | | | 0 | Exceed commitment | | 45 | classification | character | x(2) | | | | Classification (Commitment) | | 46 | exceed_commit_amount_fc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Exceed commtiment: Amount FC | | 47 | exceed_commit_percentage | decimal | >>9.99 | 4 | | 0 | Exceed commitment: Percentage | | 48 | unique_entry_nr | integer | >>>>>9 | | | 0 | Unique: Entry number | | 49 | use_statement_nr | logical | true/false | | | FALSE | Import: Use statement number |
Indexesjournlix - primary - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | journal_nr | integer | >>9 | Journal |
journl03ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | entity_state | integer | >>>>>9 | State | | 3 | journal_nr | integer | >>9 | Journal |
journl2ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | acc_nr | character | x(12) | Account | | 3 | type_journal | integer | >>>>>9 | Type of journal | | 4 | journal_nr | integer | >>9 | Journal |
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: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|