|
|
Data dictionary curren - currencies - 7.20
| 1 | adm_nr | integer | >>>>>9 | | | ? | Company | | 2 | curr_code | character | x(3) | | | ? | Currency | | 3 | descr | character | X(60) | | | | Description | | 4 | abbrev | character | x(5) | | | | Abbreviation | | 5 | iso_cur_code | character | x(3) | | | | ISO currency | | 6 | conv_factor | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Conversion factor | | 7 | acc_nr_xrate_loss_purchase | character | x(12) | | | | Foreign exchange loss purchase | | 8 | acc_nr_xrate_gain_purchase | character | x(12) | | | | Foreign exchange gain purchase | | 9 | acc_nr_xrate_loss_sales | character | x(12) | | | | Foreign exchange loss sales | | 10 | acc_nr_xrate_gain_sales | character | x(12) | | | | Foreign exchange gain sales | | 11 | acc_nr_revalue | character | x(12) | | | | Unfavorable revaluations | | 12 | acc_nr_revalue_revenue | character | x(12) | | | | Favorable revaluations | | 13 | vat_low_sales | character | x(3) | | | | VAT percentage low sales | | 14 | vat_high_sales | character | x(3) | | | | VAT percentage high sales | | 15 | vat_low_purch | character | x(3) | | | | VAT percentage low purchase | | 16 | vat_high_purch | character | x(3) | | | | VAT percentage high purchase | | 17 | current_rate | logical | yes/no | | | no | Variable exchange rate | | 18 | blocked | logical | yes/no | | | FALSE | Blocked | | 19 | post_curr_sales | logical | yes/no | | | yes | Post in currency sales | | 20 | revenue_code | integer | >>>>>9 | | | 0 | Revenue code | | 21 | entry_curr_purch | logical | yes/no | | | yes | Enter purchases in FC | | 22 | entry_curr_sales | logical | yes/no | | | yes | Enter sales orders/invoices in FC | | 23 | price_prec | integer | 9 | | | 0 | Precision for prices | | 24 | amt_prec | integer | 9 | | | 0 | Precision for amounts | | 25 | curr_abbrev | character | x(1) | | | | Currency character | | 26 | res_1 | decimal | ->>>9 | 0 | | 0 | Reserve 1 | | 27 | res_2 | decimal | ->>>9 | 0 | | 0 | Reserve 2 | | 28 | rate_prec | integer | >9 | | | 6 | Exchange rate precision | | 29 | res_4 | integer | ->>>9 | | | 0 | Reserve 4 | | 30 | descr_ml | character | X(60) | | 5 | | ML description | | 31 | source_lc | character | x(12) | | | | | | 32 | time_lc | integer | ->,>>>,>>9 | | | ? | | | 33 | date_lc | date | 99/99/9999 | | | | | | 34 | euserid_lc | character | X(12) | | | | | | 35 | type_lc | character | x(8) | | | | | | 36 | curr_format | character | X(23) | | | | | | 37 | price_format | character | X(23) | | | | | | 38 | emu_curr | logical | yes/no | | | no | EMU member | | 39 | emu_date | date | 99/99/9999 | | | 01/01/1999 | Date member of EMU | | 40 | entry_format | character | X(23) | | | | | | 41 | entity_state | integer | >>>>>9 | | | 0 | State | | 42 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | | 43 | write_off_using_oi_xrate | logical | true/false | | | FALSE | Use: Exchange rate (Outstanding item) |
Indexescurrenix - primary - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | curr_code | character | x(3) | Currency |
curren03ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | entity_state | integer | >>>>>9 | State | | 3 | curr_code | character | x(3) | Currency |
curren2ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | descr | character | X(60) | Description | | 3 | curr_code | character | x(3) | Currency |
Contents > curren
| 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.237 |
| Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|