|
|
Data dictionary fas_mast - Asset set - 7.20
| 1 | adm_nr | integer | >>>>>9 | | | ? | Company | | 2 | master_asset_id | character | x(12) | | | ? | Asset set | | 3 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | | 4 | curr_code | character | X(3) | | | | Currency | | 5 | master_asset_type | integer | >>>>>9 | | | 0 | Type of asset set | | 6 | master_asset_long | character | X(20) | | | | Long asset set | | 7 | item_code | character | X(20) | | | | Item | | 8 | profile_id | character | x(12) | | | | Asset group | | 9 | descr | character | X(60) | | | | Description | | 10 | amt_last_purch | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Last purchase price | | 11 | allow_assembled_asset | logical | yes/no | | | no | Link assets | | 12 | asset_card | logical | yes/no | | | no | Keep history | | 13 | tax_perc | decimal | ->>9.99 | 2 | | 0 | Tax burden percentage | | 14 | seq_last_purch | integer | >>>>9 | | | 0 | Last purchase | | 15 | source_lc | character | x(12) | | | | Source last changed | | 16 | time_lc | integer | ->,>>>,>>9 | | | ? | Time last changed | | 17 | date_lc | date | 99/99/9999 | | | | Date | | 18 | euserid_lc | character | X(15) | | | | User | | 19 | type_lc | character | X(8) | | | | Type last changed | | 20 | entity_state | integer | >>>>>9 | | | 0 | State | | 21 | term_id | integer | >>>>>>>9 | | | 0 | Term ID |
Indexesfas_mastix - primary - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | master_asset_id | character | x(12) | Asset set |
fas_mast03ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | entity_state | integer | >>>>>9 | State | | 3 | master_asset_id | character | x(12) | Asset set |
fas_mastix2| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | master_asset_id | character | x(12) | Asset set | | 3 | profile_id | character | x(12) | Asset group |
Contents > fas_mast
| 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.283 |
| Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|