| Previous: project_item | Unanet Data Model | Next: project_location |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | project_item_uom_rate_key | decimal(15) | |||
| 2. | project_key | decimal(15) | project_item | fk_project_item_uom_rate1 | ||
| 3. | item_key | decimal(15) | project_item | fk_project_item_uom_rate2, fk_project_item_uom_rate1 | ||
| 4. | uom_key | decimal(15) | item_uom | fk_project_item_uom_rate2 | ||
| 5. | begin_date | datetime | ||||
| 6. | end_date | datetime | ||||
| 7. | bill_rate | decimal(15,5) | ((0)) | |||
| 8. | bill_markup | decimal(5,2) | ((0)) | |||
| 9. | cost_rate | decimal(15,5) | ((0)) | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| item_key | item_uom | item_key | fk_project_item_uom_rate2 |
| uom_key | uom_key | ||
| project_key | project_item | project_key | fk_project_item_uom_rate1 |
| item_key | item_key | ||
| Name | Definition |
| cc_proj_itm_uom_rate_begin_dt | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_proj_itm_uom_rate_end_dt | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_project_item_uom_rate | true | project_item_uom_rate_key | Asc |
| idx_project_item_uom_rate1 | true | project_key | Asc |
| item_key | |||
| uom_key | |||
| begin_date | |||
| idx_project_item_uom_rate2 | false | item_key | Asc |
| uom_key |