Order (Distribution) Data Fields
Order data can be edited on the Order Grid Window of the Resource Grid or the Order Property Sheet.
To view and edit all order data, use the Property Sheet.
The following describes all the data which can be used to define an order.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Order Data
Database Table Name: wams_order
|
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 order. |
id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
|
Description |
Order description. |
description |
Text |
100 |
|
0 |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
|
Expected date |
Order expected delivery date. |
expected_date | Date / Time |
0 |
|||||||||||||||||||||||||||||||||||||||||||
|
Delivery date |
Order actual delivery date. |
delivery_date | Date / Time |
0 |
|||||||||||||||||||||||||||||||||||||||||||
| Order details |
Click the Database Table Name: wams_order_details
|
||||||||||||||||||||||||||||||||||||||||||||||
|
Quantity ordered |
Number of items of the material present in the order. |
quantity_ordered | Integer |
0 |
0 | ||||||||||||||||||||||||||||||||||||||||||
| General properties fields | See Common Data Fields for details of field in the General properties section of the property sheet. | ||||||||||||||||||||||||||||||||||||||||||||||
| User defined properties fields | See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet. |
button to display the order details grid.Network Data Fields Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.
