|
|
Data dictionary claims - Claims - 7.20
| 1 | adm_nr | integer | >>>>>9 | | | ? | Company | | 2 | entry_nr | int64 | >>>>>>>>>>>9 | | | ? | Entry number | | 3 | policy | character | X(20) | | | | Policy number | | 4 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | | 5 | coll_date | date | 99/99/9999 | | | | Collection date | | 6 | grpclmnr | int64 | >>>>>>>>>>>9 | | | 0 | Group claim number | | 7 | grpdebnr | int64 | >>>>>>>>>9 | | | 0 | Group debtor number | | 8 | paymethod | integer | 9 | | | 0 | Method of payment | | 9 | acc_nr | character | X(34) | | | | Account | | 10 | acc_nr_type | integer | >>>>>9 | | | 0 | Account type | | 11 | claim_amt | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Amount claim | | 12 | collected | logical | Yes/No | | | no | Collected | | 13 | nrrecrej | integer | >9 | | | 0 | Recovered from rejection | | 14 | reas_rej | character | X(32) | | | | Reason rejection | | 15 | sigcdrej | character | X(4) | | | | Signal code rejection | | 16 | nrrecrev | integer | >9 | | | 0 | Nr recovered reversals | | 17 | reason_rev | character | X(32) | | | | Reason reversal | | 18 | sigcdrev | character | X(4) | | | | Signal code reversal | | 19 | entry_nr_type | integer | >>>>>9 | | | 0 | Entry type | | 20 | date | date | 99/99/9999 | | | | Date | | 21 | journal_nr | integer | >>9 | | | 0 | Journal | | 22 | descr | character | X(25) | | | | Description | | 23 | amt_after_entry | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Amount after entry | | 24 | amt_after_posting | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Amount after posting | | 25 | curr_code | character | X(3) | | | | Currency | | 26 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | | 27 | amt_curr_after_entry | decimal | ->>,>>>,>>>,>>9.99 | 4 | | 0 | FC amount after entry | | 28 | amt_curr_after_posting | decimal | ->>,>>>,>>>,>>9.99 | 4 | | 0 | FC amount after posting | | 29 | amt_original | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Original amount | | 30 | due_date_surch | date | 99/99/9999 | | | | Due date PayCh/Disc | | 31 | due_date_surch_2 | date | 99/99/9999 | | | | Due date PayCh/Disc 2 | | 32 | due_date_invoice | date | 99/99/9999 | | | | Due date invoice | | 33 | surch_disc | integer | >>>>>9 | | | 0 | Payment charge/discount | | 34 | amt_credit_surch | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Amount PayCh/Disc | | 35 | amt_credit_surch_2 | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Amount PayCh/Disc 2 | | 36 | block | logical | Yes/No | | | No | Block | | 37 | last_entry_date | date | 99/99/9999 | | | | Last entry date | | 38 | nr_reminders | integer | ->9 | | | 0 | Reminders | | 39 | date_last_reminder | date | 99/99/9999 | | | | Last reminder | | 40 | layoutcode | character | X(25) | | | | Layout | | 41 | week_nr | integer | >9 | | | 0 | Week | | 42 | fin_yr | integer | 9999 | | | 0 | Financial Year | | 43 | prepayment | logical | Yes/No | | | no | Prepayment | | 44 | acc_nr_sub_adm | character | x(12) | | | | Account subsidiary ledger | | 45 | deliv_ext_bureau | integer | >>>>>9 | | | 0 | Supplied to external bureau | | 46 | date_deliv | date | 99/99/9999 | | | | Date delivered external bureau | | 47 | amt_cur | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Amount | | 48 | amt_def_cur | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC | | 49 | pay_condition | character | X(4) | | | | Payment condition | | 50 | pay_ref | character | X(32) | | | | Payment reference | | 51 | pay_ref_2 | character | X(20) | | | | Payment reference | | 52 | struct_m | logical | Yes/No | | | no | Structured announcement | | 53 | OLA_created | logical | Yes/No | | | no | OLA created | | 54 | source_lc | character | X(40) | | | | Source last changed | | 55 | time_lc | integer | >>>>>9 | | | ? | Time last changed | | 56 | date_lc | date | 99/99/9999 | | | | Last changed | | 57 | euserid_lc | character | X(12) | | | | User last changed | | 58 | type_lc | character | X(8) | | | | Type last changed |
Indexesclaimsix - primary - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
claims2ix| 1 | journal_nr | integer | >>9 | Journal |
claims3ix| 1 | entry_nr_type | integer | >>>>>9 | Entry type |
claims4ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | debtor | int64 | >>>>>>>>>9 | Debtor |
claims5ix| 1 | policy | character | X(20) | Policy number |
Contents > claims
| 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.206 |
| Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|