|
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 - unique1 | 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_trns3ix1 | 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_trns4ix1 | 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_trnsix21 | 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 |
|
|