|
|
Data dictionary debbal - debtor balances - 7.20
| 1 | adm_nr | integer | >>>>>9 | | | ? | Company | | 2 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | | 3 | fin_yr | integer | 9999 | | | ? | Financial year | | 4 | period | integer | >>9 | | | ? | Period | | 5 | open_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Opening balance | | 6 | revenue_excl | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Revenue excluding VAT | | 7 | revenue_incl | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Revenue including VAT | | 8 | amt_total | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Total paid | | 9 | conversie | logical | yes/no | | | no | Originating from conversion | | 10 | source_lc | character | x(12) | | | | | | 11 | time_lc | integer | ->,>>>,>>9 | | | ? | | | 12 | date_lc | date | 99/99/9999 | | | | | | 13 | euserid_lc | character | X(12) | | | | | | 14 | type_lc | character | x(8) | | | | |
Indexesdebbalix - primary - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | debtor | int64 | >>>>>>>>>9 | Debtor | | 3 | fin_yr | integer | 9999 | Financial year | | 4 | period | integer | >>9 | Period |
Contents > debbal
| 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.239 |
| Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|