|
|
Data dictionary debtrs - debtor transactions
| 1 | adm-nr | integer | >>>>>9 | | | ? | Company | | 2 | seq-nr-deb | decimal | >>>>>>>>>9 | 0 | | 0 | Sequence number | | 3 | fin-yr | integer | 9999 | | | 0 | Financial year | | 4 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | | 5 | date | date | 99/99/9999 | | | | Date | | 6 | period | integer | >>9 | | | 0 | Period | | 7 | entry-nr-type | integer | >>>>>9 | | | 1 | Entry type | | 8 | entry-nr | int64 | >>>>>>>>>>>9 | | | 0 | Entry number | | 9 | journal-nr | integer | >>9 | | | 0 | Journal | | 10 | descr | character | X(60) | | | | Description | | 11 | amt-def-cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC | | 12 | curr-code | character | x(3) | | | | Currency | | 13 | curr-code-extra | character | x(3) | | | | Extra currency | | 14 | exch-rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | | 15 | exch-rate-2 | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | | 16 | exch-rate3 | decimal | >>>>>9.99999 | 6 | | 1 | Exchange rate outstanding items | | 17 | amt-cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | | 18 | entry-nr-fin | int64 | >>>>>>>>>>>9 | | | 0 | Entry number FA | | 19 | posting-nr-journal | integer | ->>>>>>>>>9 | | | 0 | Unique posting number journal | | 20 | posting-nr | decimal | >>>>>>>>>9 | 0 | | 0 | Unique posting number | | 21 | XXXpost-nr-2 | integer | ->>>>>>>>>9 | | | 0 | Unique posting number | | 22 | check-number | integer | ->>>>>>>>>9 | | | 0 | Unique check number | | 23 | closing-transac | logical | yes/no | | | no | Transaction after closing | | 24 | revalue-transact | logical | yes/no | | | no | Revaluation transaction | | 25 | match-inv-type | integer | >>>>>9 | | | 1 | Invoice matching type | | 26 | match-inv | int64 | >>>>>>>>>>>9 | | | 0 | Invoice number matching | | 27 | match-trs | logical | yes/no | | | no | Match transaction | | 28 | rev-entry | logical | yes/no | | | no | Reversal entry | | 29 | seq-nr-ledger | decimal | >>>>>>>>>9 | 0 | | 0 | Sequence number | | 30 | pay-condition | character | X(4) | | | | Payment condition | | 31 | mcode1 | character | X(8) | | | | Mdim 1 | | 32 | mcode2 | character | X(8) | | | | Mdim 2 | | 33 | mcode3 | character | X(8) | | | | Mdim 3 | | 34 | mcode4 | character | X(8) | | | | Mdim 4 | | 35 | mcode5 | character | X(8) | | | | Mdim 5 | | 36 | source-lc | character | x(8) | | | | | | 37 | time-lc | integer | ->,>>>,>>9 | | | 0 | | | 38 | date-lc | date | 99/99/9999 | | | | | | 39 | euserid-lc | character | X(12) | | | | | | 40 | type-lc | character | x(8) | | | | | | 41 | seq-nr-5 | integer | >>>>>>9 | | | 0 | Sequence number | | 42 | line-nr | integer | >>>>>9 | | | 0 | Line | | 43 | bank_acc_nr | character | x(34) | | | | Bank account | | 44 | curr_code_bank_acc_nr | character | x(3) | | | | Currency | | 45 | mandate_ref | character | X(35) | | | | Mandate reference |
Indexesdebtrs01ix - primary - unique| 1 | adm-nr | integer | >>>>>9 | Company | | 2 | seq-nr-deb | decimal | >>>>>>>>>9 | Sequence number |
debtrs02ix| 1 | adm-nr | integer | >>>>>9 | Company | | 2 | fin-yr | integer | 9999 | Financial year | | 3 | debtor | int64 | >>>>>>>>>9 | Debtor | | 4 | date | date | 99/99/9999 | Date |
debtrs03ix| 1 | adm-nr | integer | >>>>>9 | Company | | 2 | fin-yr | integer | 9999 | Financial year | | 3 | debtor | int64 | >>>>>>>>>9 | Debtor | | 4 | entry-nr-type | integer | >>>>>9 | Entry type | | 5 | entry-nr | int64 | >>>>>>>>>>>9 | Entry number | | 6 | period | integer | >>9 | Period |
debtrs04ix| 1 | adm-nr | integer | >>>>>9 | Company | | 2 | fin-yr | integer | 9999 | Financial year | | 3 | debtor | int64 | >>>>>>>>>9 | Debtor | | 4 | period | integer | >>9 | Period | | 5 | date | date | 99/99/9999 | Date |
debtrs05ix| 1 | adm-nr | integer | >>>>>9 | Company | | 2 | posting-nr | decimal | >>>>>>>>>9 | Unique posting number | | 3 | seq-nr-5 | integer | >>>>>>9 | Sequence number | | 4 | line-nr | integer | >>>>>9 | Line |
debtrs06ix| 1 | adm-nr | integer | >>>>>9 | Company | | 2 | debtor | int64 | >>>>>>>>>9 | Debtor | | 3 | entry-nr | int64 | >>>>>>>>>>>9 | Entry number | | 4 | entry-nr-type | integer | >>>>>9 | Entry type |
Contents > debtrs
| 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: |
25.809.206 |
| Assortment: |
Exact Financials
|
Date: |
30-04-2014 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|