| PROJECT_TRAN_ID |
INTEGER |
4 |
10 |
Unique ID Number |
1 |
| AUDIT_TRAIL_ID |
INTEGER |
4 |
10 |
Audit Trail ID |
0 |
| STOCK_TRAIL_ID |
INTEGER |
4 |
10 |
Stock Trail ID |
0 |
| PROJECT_ID |
INTEGER |
4 |
10 |
Project ID |
1 |
| COST_CODE_ID |
INTEGER |
4 |
10 |
Cost Code ID |
7 |
| REVENUE_CODE_ID |
INTEGER |
4 |
10 |
Revenue ID |
0 |
| POP_ITEM_ID |
INTEGER |
4 |
10 |
POP Item ID |
0 |
| STOCK_ALLOCATION_ID |
INTEGER |
4 |
10 |
Stock Allocation ID |
0 |
| DATE |
DATE |
2 |
10 |
Transaction Date |
28/04/2005 00:00:00 |
| RECORD_CREATE_DATE |
|
16 |
0 |
Date and time when the record was created. |
27/04/2010 17:16:58 |
| RECORD_MODIFY_DATE |
|
16 |
0 |
Date and time when the record was modified. |
04/08/2017 14:18:53 |
| RECORD_DELETED |
TINYINT |
2 |
3 |
Flag denoting if the record has been deleted or not. |
0 |