|
Data dictionary fireh - Recurring entry headers - 7.20
1 | adm_nr | integer | >>>>>9 | | | ? | Company | 2 | journal_nr | integer | >>9 | | | ? | Journal | 3 | entry_code | character | x(12) | | | ? | Code | 4 | descr | character | X(60) | | | | Description | 5 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | 6 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | 7 | pay_condition | character | X(4) | | | | Payment condition | 8 | curr_code | character | x(3) | | | | Currency | 9 | amount_inc_vat | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount | 10 | amount_inc_vat_blocked | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount blocked account | 11 | pay_method | integer | >>>>>9 | | | 0 | Payment method | 12 | pay_reference | character | X(32) | | | | Payment reference | 13 | percentage_1 | decimal | ->>9.99 | 4 | | 0 | Percentage | 14 | amount_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount | 15 | percentage_2 | decimal | ->>9.99 | 4 | | 0 | Percentage | 16 | amount_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount | 17 | percentage_3 | decimal | ->>9.99 | 4 | | 0 | Percentage | 18 | amount_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount | 19 | percentage_4 | decimal | ->>9.99 | 4 | | 0 | Percentage | 20 | amount_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount | 21 | percentage_5 | decimal | ->>9.99 | 4 | | 0 | Percentage | 22 | amount_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount | 23 | reversal_entry | logical | yes/no | | | no | Reversal entry | 24 | euserid_cr | character | X(12) | | | | User creation | 25 | date_cr | date | 99/99/9999 | | | | Date creation | 26 | time_cr | integer | >>>>>9 | | | ? | Time creation | 27 | source_cr | character | x(12) | | | | Source creation | 28 | euserid_lc | character | X(12) | | | | User last changed | 29 | date_lc | date | 99/99/9999 | | | | Date last changed | 30 | time_lc | integer | >>>>>9 | | | ? | Time last changed | 31 | source_lc | character | x(12) | | | | Source last changed |
Indexesfirehix - primary - unique1 | adm_nr | integer | >>>>>9 | Company | 2 | journal_nr | integer | >>9 | Journal | 3 | entry_code | character | x(12) | Code |
fireh02ix1 | adm_nr | integer | >>>>>9 | Company | 2 | entry_code | character | x(12) | Code | 3 | journal_nr | integer | >>9 | Journal |
Contents > fireh
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.311 |
Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
Release: |
|
Attachment: |
|
Disclaimer |
|
|