|
Data dictionary y_scentry - scenario entry lines - 7.20
1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | 2 | adm_nr | integer | >>>>>9 | | | ? | Company | 3 | journal_nr | integer | >>9 | | | 0 | Journal | 4 | scenario_code | character | x(12) | | | | Scenario | 5 | line_nr | integer | >>>>>9 | | | 0 | Line | 6 | linenr_scentry_user | integer | >>>9 | | | 0 | Line number (User) | 7 | change_line_nr | logical | yes/no | | | yes | Change line | 8 | acc_nr | character | x(12) | | | | Account | 9 | change_acc_nr | logical | yes/no | | | yes | Change account | 10 | descr | character | X(60) | | | | Description | 11 | change_descr | logical | yes/no | | | yes | Change description | 12 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | 13 | change_debtor | logical | yes/no | | | yes | Change debtor | 14 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | 15 | change_creditor | logical | yes/no | | | yes | Change creditor | 16 | vat_code | character | x(3) | | | 0 | VAT code | 17 | change_vat_code | logical | yes/no | | | yes | Change VAT code | 18 | curr_code | character | x(3) | | | | Currency | 19 | change_curr_code | logical | yes/no | | | yes | Change currency | 20 | amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Currency amount | 21 | perc_amt_curr | decimal | ->>9.99 | 2 | | 0 | Percentage header currency amount | 22 | change_amt_curr | logical | yes/no | | | yes | Change Currency amount | 23 | vat_amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Currency VAT amount | 24 | change_vat_amt_curr | logical | yes/no | | | yes | Change currency VAT amount | 25 | cost_center | character | x(12) | | | | Cost center | 26 | change_cost_center | logical | yes/no | | | yes | Change Cost center | 27 | cost_unit | character | x(12) | | | | Cost unit | 28 | change_cost_unit | logical | yes/no | | | yes | Change cost unit | 29 | qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | 30 | change_qty | logical | yes/no | | | yes | Change quantity | 31 | rev_entry | logical | yes/no | | | yes | Reversal entry | 32 | change_rev_entry | logical | yes/no | | | yes | Change reversal entry | 33 | del_acq | integer | >>>>>9 | | | 0 | Supply/acquisition | 34 | change_del_acq | logical | yes/no | | | yes | Change Supply/acquisition | 35 | mcode1 | character | x(12) | | | | Mdim 1 | 36 | change_mcode1 | logical | yes/no | | | yes | Change mdim 1 | 37 | mcode2 | character | x(12) | | | | Mdim 2 | 38 | change_mcode2 | logical | yes/no | | | yes | Change | 39 | mcode3 | character | x(12) | | | | Mdim 3 | 40 | change_mcode3 | logical | yes/no | | | yes | Change | 41 | mcode4 | character | x(12) | | | | Mdim 4 | 42 | change_mcode4 | logical | yes/no | | | yes | Change | 43 | mcode5 | character | x(12) | | | | Mdim 5 | 44 | change_mcode5 | logical | yes/no | | | yes | Change | 45 | invoice_nr_type | integer | >>>>>9 | | | 1 | Invoice type | 46 | change_invoice_nr_type | logical | yes/no | | | yes | Change | 47 | ca_acc_nr | character | x(12) | | | | Account | 48 | change_ca_acc_nr | logical | yes/no | | | yes | Change | 49 | ca_cost_center | character | x(12) | | | | Cost center | 50 | change_ca_cost_center | logical | yes/no | | | yes | Change | 51 | ca_cost_unit | character | x(12) | | | | intercompany cost unit | 52 | change_ca_cost_unit | logical | yes/no | | | yes | Change | 53 | ca_qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | 54 | change_ca_qty | logical | yes/no | | | yes | Change | 55 | ca_debtor | int64 | >>>>>>>>>9 | | | 0 | IC debtor | 56 | change_ca_debtor | logical | yes/no | | | yes | Change | 57 | ca_credit | int64 | >>>>>>>>>9 | | | 0 | IC creditor | 58 | change_ca_credit | logical | yes/no | | | yes | Change IC creditor | 59 | ca_invoice_nr_type | integer | >>>>>9 | | | 1 | IC invoice type | 60 | change_ca_invoice_nr_type | logical | yes/no | | | yes | Change IC invoice type | 61 | time_lc | integer | ->,>>>,>>9 | | | ? | | 62 | date_lc | date | 99/99/9999 | | | | | 63 | euserid_lc | character | X(12) | | | | | 64 | type_lc | character | x(8) | | | | | 65 | source_lc | character | x(12) | | | | | 66 | project_code | character | x(12) | | | | Project | 67 | project_description | character | X(60) | | | | Project description | 68 | project_cost_center | character | x(12) | | | | Project cost center | 69 | project_cost_cat_code | character | x(12) | | | | Project cost category | 70 | result_type | integer | >>>>>9 | | | 1 | Result type | 71 | change_project_code | logical | yes/no | | | yes | Change | 72 | change_pro_cost_cat_code | logical | yes/no | | | yes | Change | 73 | change_project_cost_center | logical | yes/no | | | yes | Change | 74 | change_project_description | logical | yes/no | | | yes | Change | 75 | change_result_type | logical | yes/no | | | yes | Change | 76 | change_ic_acc_nr | logical | yes/no | | | yes | Change | 77 | change_ic_cost_center | logical | yes/no | | | yes | Change | 78 | change_ic_cost_unit | logical | yes/no | | | yes | Change | 79 | change_ic_mdim_code_1 | logical | yes/no | | | yes | Change | 80 | change_ic_mdim_code_2 | logical | yes/no | | | yes | Change | 81 | change_ic_mdim_code_3 | logical | yes/no | | | yes | Change | 82 | change_ic_mdim_code_4 | logical | yes/no | | | yes | Change | 83 | change_ic_mdim_code_5 | logical | yes/no | | | yes | Change | 84 | change_ic_project_code | logical | yes/no | | | yes | Change | 85 | change_ic_cost_cat_code | logical | yes/no | | | yes | Change | 86 | change_ic_pro_cost_center | logical | yes/no | | | yes | Change | 87 | change_ic_project_descr | logical | yes/no | | | yes | Change | 88 | change_ic_result_type | logical | yes/no | | | yes | Change | 89 | change_ic_qty | logical | yes/no | | | yes | Change | 90 | nr_periods_allocation | integer | >>9 | | | 0 | Number of periods | 91 | change_nr_periods_allocat | logical | yes/no | | | yes | Change |
Indexesy_scentryix - primary - unique1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_scentry1ix - unique1 | adm_nr | integer | >>>>>9 | Company | 2 | journal_nr | integer | >>9 | Journal | 3 | scenario_code | character | x(12) | Scenario | 4 | line_nr | integer | >>>>>9 | Line | 5 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_scentry
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.872 |
Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
Release: |
|
Attachment: |
|
Disclaimer |
|
|