| Column Name | Ordinal Position |
|---|
| Column Name | Ordinal Position | Referenced Table |
|---|
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | BILLTYPEID | INT | ||||||||
|
Description: Primary key of the BillType table
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | BILLTYPE | NVARCHAR | ||||||||
|
Description: The Bill Type Value
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 3 | STARTDATE | DATETIME2 | ||||||||
|
Description: The Start Date of the Bill Type
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | ENDDATE | DATETIME2 | ||||||||
|
Description: The End date of the Bill Type
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 6 | CREATED | DATETIME2 | ||||||||
|
Description: Record created time
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 7 | CREATEDTIMEZONEOFFSET | INT | ||||||||
|
Description: Created Time Zone Offset
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 9 | LASTMODIFIED | DATETIME2 | ||||||||
|
Description: Record Last Modified time
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 10 | LASTMODIFIEDTIMEZONEOFFSET | INT | ||||||||
|
Description: Last Modified Time Zone Offset
|
||||||||||