SVC00681 - svcContractHdrCoveragePeriod
Query Builder
| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CONSTS | Contract Record Type |
Integer | 2 | View | |
| CONTNBR | Contract Number |
String | 12 | View | |
| svcCoveragePeriodStart2_1 | svcCoveragePeriodStart2[1] |
Time | 4 | View | |
| svcCoveragePeriodStart2_2 | svcCoveragePeriodStart2[2] |
Time | 4 | View | |
| svcCoveragePeriodStart2_3 | svcCoveragePeriodStart2[3] |
Time | 4 | View | |
| svcCoveragePeriodStart2_4 | svcCoveragePeriodStart2[4] |
Time | 4 | View | |
| svcCoveragePeriodStart2_5 | svcCoveragePeriodStart2[5] |
Time | 4 | View | |
| svcCoveragePeriodStart2_6 | svcCoveragePeriodStart2[6] |
Time | 4 | View | |
| svcCoveragePeriodStart2_7 | svcCoveragePeriodStart2[7] |
Time | 4 | View | |
| svcCoveragePeriodEnd2_1 | svcCoveragePeriodEnd2[1] |
Time | 4 | View | |
| svcCoveragePeriodEnd2_2 | svcCoveragePeriodEnd2[2] |
Time | 4 | View | |
| svcCoveragePeriodEnd2_3 | svcCoveragePeriodEnd2[3] |
Time | 4 | View | |
| svcCoveragePeriodEnd2_4 | svcCoveragePeriodEnd2[4] |
Time | 4 | View | |
| svcCoveragePeriodEnd2_5 | svcCoveragePeriodEnd2[5] |
Time | 4 | View | |
| svcCoveragePeriodEnd2_6 | svcCoveragePeriodEnd2[6] |
Time | 4 | View | |
| svcCoveragePeriodEnd2_7 | svcCoveragePeriodEnd2[7] |
Time | 4 | View | |
| svcCoveragePeriodStart3_1 | svcCoveragePeriodStart3[1] |
Time | 4 | View | |
| svcCoveragePeriodStart3_2 | svcCoveragePeriodStart3[2] |
Time | 4 | View | |
| svcCoveragePeriodStart3_3 | svcCoveragePeriodStart3[3] |
Time | 4 | View | |
| svcCoveragePeriodStart3_4 | svcCoveragePeriodStart3[4] |
Time | 4 | View | |
| svcCoveragePeriodStart3_5 | svcCoveragePeriodStart3[5] |
Time | 4 | View | |
| svcCoveragePeriodStart3_6 | svcCoveragePeriodStart3[6] |
Time | 4 | View | |
| svcCoveragePeriodStart3_7 | svcCoveragePeriodStart3[7] |
Time | 4 | View | |
| svcCoveragePeriodEnd3_1 | svcCoveragePeriodEnd3[1] |
Time | 4 | View | |
| svcCoveragePeriodEnd3_2 | svcCoveragePeriodEnd3[2] |
Time | 4 | View | |
| svcCoveragePeriodEnd3_3 | svcCoveragePeriodEnd3[3] |
Time | 4 | View | |
| svcCoveragePeriodEnd3_4 | svcCoveragePeriodEnd3[4] |
Time | 4 | View | |
| svcCoveragePeriodEnd3_5 | svcCoveragePeriodEnd3[5] |
Time | 4 | View | |
| svcCoveragePeriodEnd3_6 | svcCoveragePeriodEnd3[6] |
Time | 4 | View | |
| svcCoveragePeriodEnd3_7 | svcCoveragePeriodEnd3[7] |
Time | 4 | View | |
| svcCoveragePeriodStart4_1 | svcCoveragePeriodStart4[1] |
Time | 4 | View | |
| svcCoveragePeriodStart4_2 | svcCoveragePeriodStart4[2] |
Time | 4 | View | |
| svcCoveragePeriodStart4_3 | svcCoveragePeriodStart4[3] |
Time | 4 | View | |
| svcCoveragePeriodStart4_4 | svcCoveragePeriodStart4[4] |
Time | 4 | View | |
| svcCoveragePeriodStart4_5 | svcCoveragePeriodStart4[5] |
Time | 4 | View | |
| svcCoveragePeriodStart4_6 | svcCoveragePeriodStart4[6] |
Time | 4 | View | |
| svcCoveragePeriodStart4_7 | svcCoveragePeriodStart4[7] |
Time | 4 | View | |
| svcCoveragePeriodEnd4_1 | svcCoveragePeriodEnd4[1] |
Time | 4 | View | |
| svcCoveragePeriodEnd4_2 | svcCoveragePeriodEnd4[2] |
Time | 4 | View | |
| svcCoveragePeriodEnd4_3 | svcCoveragePeriodEnd4[3] |
Time | 4 | View | |
| svcCoveragePeriodEnd4_4 | svcCoveragePeriodEnd4[4] |
Time | 4 | View | |
| svcCoveragePeriodEnd4_5 | svcCoveragePeriodEnd4[5] |
Time | 4 | View | |
| svcCoveragePeriodEnd4_6 | svcCoveragePeriodEnd4[6] |
Time | 4 | View | |
| svcCoveragePeriodEnd4_7 | svcCoveragePeriodEnd4[7] |
Time | 4 | View |