# Rptplanningsopencapacityresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptplanningsopencapacityresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Availability` | `decimal` | Availability | ☑ | | | `D1` | `decimal` | Day 1 | ☐ | | | `D10` | `decimal` | Day 10 | ☐ | | | `D11` | `decimal` | Day 11 | ☐ | | | `D12` | `decimal` | Day 12 | ☐ | | | `D13` | `decimal` | Day 13 | ☐ | | | `D14` | `decimal` | Day 14 | ☐ | | | `D15` | `decimal` | Day 15 | ☐ | | | `D16` | `decimal` | Day 16 | ☐ | | | `D17` | `decimal` | Day 17 | ☐ | | | `D18` | `decimal` | Day 18 | ☐ | | | `D19` | `decimal` | Day 19 | ☐ | | | `D2` | `decimal` | Day 2 | ☐ | | | `D20` | `decimal` | Day 20 | ☐ | | | `D21` | `decimal` | Day 21 | ☐ | | | `D22` | `decimal` | Day 22 | ☐ | | | `D23` | `decimal` | Day 23 | ☐ | | | `D24` | `decimal` | Day 24 | ☐ | | | `D25` | `decimal` | Day 25 | ☐ | | | `D26` | `decimal` | Day 26 | ☐ | | | `D27` | `decimal` | Day 27 | ☐ | | | `D28` | `decimal` | Day 28 | ☐ | | | `D29` | `decimal` | Day 29 | ☐ | | | `D3` | `decimal` | Day 3 | ☐ | | | `D30` | `decimal` | Day 30 | ☐ | | | `D31` | `decimal` | Day 31 | ☐ | | | `D4` | `decimal` | Day 4 | ☐ | | | `D5` | `decimal` | Day 5 | ☐ | | | `D6` | `decimal` | Day 6 | ☐ | | | `D7` | `decimal` | Day 7 | ☐ | | | `D8` | `decimal` | Day 8 | ☐ | | | `D9` | `decimal` | Day 9 | ☐ | | | `Department` | `string` | Department | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `FunctionName` | `string` | Function Name | ☐ | | | `Id` | `int32` | ID | ☑ | | | `LocationId` | `int32` | Location ID | ☐ | | | `LocationName` | `string` | Location Name | ☐ | | | `M1` | `decimal` | Month 1 | ☐ | | | `M10` | `decimal` | Month 10 | ☐ | | | `M11` | `decimal` | Month 11 | ☐ | | | `M12` | `decimal` | Month 12 | ☐ | | | `M2` | `decimal` | Month 2 | ☐ | | | `M3` | `decimal` | Month 3 | ☐ | | | `M4` | `decimal` | Month 4 | ☐ | | | `M5` | `decimal` | Month 5 | ☐ | | | `M6` | `decimal` | Month 6 | ☐ | | | `M7` | `decimal` | Month 7 | ☐ | | | `M8` | `decimal` | Month 8 | ☐ | | | `M9` | `decimal` | Month 9 | ☐ | | | `Resource` | `string` | Resource | ☐ | | | `ResourceExternalCode` | `string` | Resource External Code | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `ResourceType` | `string` | Resource Type | ☐ | | | `ResourceTypeId` | `int32` | Resource Type ID | ☐ | | | `Skill` | `string` | Skill | ☐ | | | `SkillId` | `int32` | Skill ID | ☐ | | | `W1` | `decimal` | Week 1 | ☐ | | | `W10` | `decimal` | Week 10 | ☐ | | | `W11` | `decimal` | Week 11 | ☐ | | | `W12` | `decimal` | Week 12 | ☐ | | | `W13` | `decimal` | Week 13 | ☐ | | | `W14` | `decimal` | Week 14 | ☐ | | | `W15` | `decimal` | Week 15 | ☐ | | | `W16` | `decimal` | Week 16 | ☐ | | | `W17` | `decimal` | Week 17 | ☐ | | | `W18` | `decimal` | Week 18 | ☐ | | | `W19` | `decimal` | Week 19 | ☐ | | | `W2` | `decimal` | Week 2 | ☐ | | | `W20` | `decimal` | Week 20 | ☐ | | | `W21` | `decimal` | Week 21 | ☐ | | | `W22` | `decimal` | Week 22 | ☐ | | | `W23` | `decimal` | Week 23 | ☐ | | | `W24` | `decimal` | Week 24 | ☐ | | | `W25` | `decimal` | Week 25 | ☐ | | | `W26` | `decimal` | Week 26 | ☐ | | | `W3` | `decimal` | Week 3 | ☐ | | | `W4` | `decimal` | Week 4 | ☐ | | | `W5` | `decimal` | Week 5 | ☐ | | | `W6` | `decimal` | Week 6 | ☐ | | | `W7` | `decimal` | Week 7 | ☐ | | | `W8` | `decimal` | Week 8 | ☐ | | | `W9` | `decimal` | Week 9 | ☐ | | | `Weight` | `decimal` | Weight | ☑ | |