Sage 50 UK PROJECT_COST_CODE Columns
| Name | Type | Length | Precision | Notes | Example |
|---|---|---|---|---|---|
| COST_CODE_ID | INTEGER | 4 | 10 | Unique ID Number | 15 |
| REFERENCE | VARCHAR | 8 | 8 | Project Cost Code Reference | ACOM |
| DESCRIPTION | VARCHAR | 60 | 60 | Project Cost Code Description | Accommodation Costs |
| COST_TYPE_ID | INTEGER | 4 | 10 | Cost Type ID | 3 |
| 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 |