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