|
|
Data dictionary dpr_trns - Depreciation transactions - 7.20
| 1 | adm_nr | integer | >>>>>9 | | | ? | Company | | 2 | asset_book | character | x(12) | | | ? | Asset book | | 3 | asset_code | character | X(12) | | | ? | Asset | | 4 | date_trans | date | 99/99/9999 | | | | Transaction date | | 5 | trans_nr | integer | ->,>>>,>>9 | | | ? | Transaction number | | 6 | reversed | logical | Yes/No | | | ? | Reversed | | 7 | euserid | character | X(12) | | | | User | | 8 | period_nr | integer | >>9 | | | 0 | Number of depreciated periods | | 9 | parent_master_asset | character | X(20) | | | | Main asset set | | 10 | parent_asset | character | X(12) | | | | Main asset | | 11 | ownership_type | integer | >>>>>9 | | | 0 | Ownership type | | 12 | formula_id | character | X(8) | | | | Depreciation method | | 13 | acc_nr | character | x(12) | | | | Account | | 14 | x_journal_nr | integer | >>9 | | | 0 | Journal | | 15 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | | 16 | sbd_sub | character | x(12) | | | | Sub account | | 17 | project_code | character | x(12) | | | | Project | | 18 | cost_center | character | x(12) | | | | Cost center | | 19 | cost_unit | character | x(12) | | | | Cost unit | | 20 | profile_id | character | x(12) | | | | Asset group | | 21 | descr | character | X(60) | | | | Description | | 22 | trans_code | integer | >>>>>9 | | | 0 | Transaction code | | 23 | trans_type | integer | >>>>>9 | | | 0 | Transaction type | | 24 | department_code | character | x(12) | | | | Department | | 25 | location_code | character | x(12) | | | | Location | | 26 | qty_actual | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Actual quantity | | 27 | invoice_nr | int64 | >>>>>>>>>>>9 | | | 0 | Invoice number | | 28 | invoice_nr_sales | int64 | >>>>>>>>>>>9 | | | 0 | Invoice number sales | | 29 | state | integer | >>>>>9 | | | 0 | Status | | 30 | order_nr | character | x(12) | | | | Order number | | 31 | receipt_nr | character | x(12) | | | | Receipt number | | 32 | rent_nr | character | x(12) | | | | Rent number | | 33 | post_nr | integer | ->,>>>,>>9 | | | 0 | Posting number | | 34 | amt_trans | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Transaction amount | | 35 | curr_code | character | X(3) | | | | Currency | | 36 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | | 37 | amt_trans_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Transaction currency amount | | 38 | fin_yr | integer | 9999 | | | 0 | Financial year | | 39 | period | integer | >>9 | | | 0 | Period | | 40 | lat_mut | logical | yes/no | | | no | Transaction tax latency | | 41 | posted | logical | Yes/No | | | no | Posted | | 42 | source_lc | character | x(12) | | | | Source last changed | | 43 | time_lc | integer | ->,>>>,>>9 | | | ? | Time last changed | | 44 | date_lc | date | 99/99/9999 | | | | Date | | 45 | euserid_lc | character | X(15) | | | | User | | 46 | type_lc | character | X(8) | | | | Type last changed | | 47 | cost_cat_code | character | x(12) | | | | Cost category | | 48 | project_cost_center | character | x(12) | | | | Cost center | | 49 | project_descr | character | X(60) | | | | Description | | 50 | result_type | integer | >>>>>9 | | | 0 | Result type | | 51 | mdim_code_1 | character | x(12) | | | | Dimension 1 | | 52 | mdim_code_2 | character | x(12) | | | | Dimension 2 | | 53 | mdim_code_3 | character | x(12) | | | | Dimension 3 | | 54 | mdim_code_4 | character | x(12) | | | | Dimension 4 | | 55 | mdim_code_5 | character | x(12) | | | | Dimension 5 |
Indexesdpr_trnsix - primary - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | asset_book | character | x(12) | Asset book | | 3 | asset_code | character | X(12) | Asset | | 4 | date_trans | date | 99/99/9999 | Transaction date | | 5 | trans_nr | integer | ->,>>>,>>9 | Transaction number | | 6 | reversed | logical | Yes/No | Reversed |
dpr_trns3ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | asset_book | character | x(12) | Asset book | | 3 | asset_code | character | X(12) | Asset | | 4 | trans_code | integer | >>>>>9 | Transaction code | | 5 | reversed | logical | Yes/No | Reversed | | 6 | period_nr | integer | >>9 | Number of depreciated periods | | 7 | date_trans | date | 99/99/9999 | Transaction date | | 8 | trans_nr | integer | ->,>>>,>>9 | Transaction number |
dpr_trns4ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | asset_code | character | X(12) | Asset | | 3 | reversed | logical | Yes/No | Reversed | | 4 | trans_code | integer | >>>>>9 | Transaction code | | 5 | asset_book | character | x(12) | Asset book | | 6 | period_nr | integer | >>9 | Number of depreciated periods | | 7 | date_trans | date | 99/99/9999 | Transaction date | | 8 | trans_nr | integer | ->,>>>,>>9 | Transaction number |
dpr_trnsix2| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | asset_book | character | x(12) | Asset book | | 3 | asset_code | character | X(12) | Asset | | 4 | fin_yr | integer | 9999 | Financial year | | 5 | period | integer | >>9 | Period | | 6 | trans_nr | integer | ->,>>>,>>9 | Transaction number | | 7 | reversed | logical | Yes/No | Reversed |
Contents > dpr_trns
| 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.252 |
| Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|