|
|
Data dictionary y_fas_ast - Asset - 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 | asset_code | character | X(12) | | | | Asset | | 5 | euserid | character | X(12) | | | | User | | 6 | curr_code | character | X(3) | | | | Currency | | 7 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | | 8 | seq_nr_purch | integer | >>>>9 | | | 0 | Purchase seqnr | | 9 | seq_nr_in_purch | integer | >>>>9 | | | 0 | Seqnr in purchase | | 10 | units_of_prod | integer | ->,>>>,>>9 | | | 0 | Units of production | | 11 | sbd_sub | character | x(12) | | | | Sub account | | 12 | project_code | character | x(12) | | | | Project | | 13 | cost_center | character | x(12) | | | | Cost center | | 14 | cost_unit | character | x(12) | | | | Cost unit | | 15 | descr | character | X(60) | | | | Description | | 16 | amt_purchase | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Purchase price | | 17 | amt_curr_purchase | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Purchase price FC | | 18 | qty_received | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Quantity received | | 19 | qty_org_in_purch | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Org. qty. in purch. | | 20 | qty_actual | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Actual quantity | | 21 | allocate | logical | yes/no | | | no | Allocate | | 22 | qty_in_seq_purch | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Qty. in purchase seq. | | 23 | previous_state | integer | >>>>>9 | | | 0 | Previous status | | 24 | state | integer | >>>>>9 | | | 0 | Status | | 25 | department_code | character | x(12) | | | | Department | | 26 | ass_mst_replaced | character | x(12) | | | | Replaced asset set | | 27 | ass_code_replaced | character | X(12) | | | | Replaced asset | | 28 | asset_type | integer | >>>>>9 | | | 0 | Type of asset | | 29 | fin_yr_purchase | integer | 9999 | | | 0 | Fin. year Purch. | | 30 | period_purchase | integer | >>9 | | | 0 | Period purchase | | 31 | date_purchase | date | 99/99/9999 | | | | Date of purchase | | 32 | receipt_nr | character | x(12) | | | | Receipt number | | 33 | insured_value | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Insured value | | 34 | insurance_cat | character | X(18) | | | | Insurance category | | 35 | amt_subsidy | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Subsidy amount | | 36 | date_next_maintenance | date | 99/99/9999 | | | | Date next maint. | | 37 | ownership_type | integer | >>>>>9 | | | 0 | Ownership type | | 38 | location_code | character | x(12) | | | | Location | | 39 | date_service | date | 99/99/9999 | | | | Date placed in service | | 40 | susp_from | date | 99/99/9999 | | | | Suspended from | | 41 | susp_thru | date | 99/99/9999 | | | | Suspended thru | | 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 | perc_annuity | decimal | >>9.9999 | 2 | | 0 | Percentage annuity | | 48 | exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Exchange rate | | 49 | cost_cat_code | character | x(12) | | | | Cost category | | 50 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | | 51 | project_cost_center | character | x(12) | | | | Cost center | | 52 | project_descr | character | X(30) | | | | Description | | 53 | result_type | integer | >>>>>9 | | | 0 | Result type | | 54 | entity_state | integer | >>>>>9 | | | 0 | State | | 55 | mdim_code_1 | character | x(12) | | | | Dimension 1 | | 56 | mdim_code_2 | character | x(12) | | | | Dimension 2 | | 57 | mdim_code_3 | character | x(12) | | | | Dimension 3 | | 58 | mdim_code_4 | character | x(12) | | | | Dimension 4 | | 59 | mdim_code_5 | character | x(12) | | | | Dimension 5 |
Indexesy_fas_astix - primary - unique| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_fas_ast1ix - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | asset_code | character | X(12) | Asset | | 3 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_fas_ast
| 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.752 |
| Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|