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