Sage 50 UK PROJECT_COST_TYPE Columns
| Name | Type | Length | Precision | Notes | Example |
|---|---|---|---|---|---|
| COST_TYPE_ID | INTEGER | 4 | 10 | Unique ID Number | 1 |
| NAME | VARCHAR | 30 | 30 | Project Cost Type Name | LABOUR |
| IS_DEFAULT | SMALLINT | 61 | 5 | Is the Default Cost Type | 0 |
| 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. | 255 |