| STOCK_ALLOCATION_ID |
INTEGER |
4 |
10 |
Stock Allocation Number |
|
| PROJECT_ID |
INTEGER |
4 |
10 |
Project Number |
|
| COST_CODE_ID |
INTEGER |
4 |
10 |
Cost Code Number |
|
| STOCK_CODE |
VARCHAR |
30 |
30 |
Stock Code |
|
| DETAILS |
VARCHAR |
60 |
60 |
Allocation Details |
|
| REFERENCE |
VARCHAR |
8 |
8 |
Allocation Reference |
|
| DATE |
DATE |
2 |
10 |
Allocation Date |
|
| QTY_ALLOCATED |
DOUBLE |
8 |
15 |
Quantity Allocated |
|
| QTY_ISSUED |
DOUBLE |
8 |
15 |
Quantity Issued |
|
| COST_PRICE |
DOUBLE |
8 |
15 |
Cost Price |
|
| RECORD_CREATE_DATE |
|
16 |
0 |
Date and time when the record was created. |
|
| RECORD_MODIFY_DATE |
|
16 |
0 |
Date and time when the record was modified. |
|
| RECORD_DELETED |
TINYINT |
2 |
3 |
Flag denoting if the record has been deleted or not. |
|