Material (Asset) Data Fields
Material data can be edited on the Material Grid Window of the Resource Grid or the Material Property Sheet.
To view and edit all material data, use the Property Sheet.
The following describes all the data which can be used to define a material.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Material Data
Database Table Name: ams_material
|
Field Name |
Help Text |
Database Field |
Size |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID |
Unique identifier for the material. |
id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||
|
Type |
Type of the material:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
type |
Text |
40 |
|
0 |
|
|
|
|
|
||||||
|
Description |
Description of the material. |
description |
Text |
100 |
|
0 |
|
|
|
|
|
||||||
|
Unit cost |
Material unit cost. |
unit_cost |
Double |
|
WN_COST |
2 |
|
|
|
|
|
||||||
|
Re-order threshold |
Minimum number of items prompting a re-order. |
reorder_threshold |
Integer |
|
|
0 |
|
0 |
0 |
0 |
0 |
||||||
| Inventory date |
Date at which the inventory was last performed. |
inventory_date |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||
|
Number at inventory |
Number of items accounted for during the inventory. |
number_at_inventory |
Integer |
|
|
0 |
|
|
|
|
|
||||||
| General properties data fields | See Common Data Fields for details of field in the General properties section of the property sheet. | ||||||||||||||||
| User defined properties data fields | See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet. |
Network Data Fields Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.
