Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
Index | int | 4 | √ | null |
|
|
||||
FacilityId | int | 4 | √ | null |
|
|
||||
FacilityCode | int | 4 | √ | null |
|
|
||||
Facility | varchar | 100 | √ | null |
|
|
||||
ClientName | varchar | 200 | √ | null |
|
|
||||
PayerCode | varchar | 50 | √ | null |
|
|
||||
Opening | float | 8 | √ | null |
|
|
||||
Current | float | 8 | √ | null |
|
|
||||
Past | float | 8 | √ | null |
|
|
||||
Cash | float | 8 | √ | null |
|
|
||||
Closing | float | 8 | √ | null |
|
|
||||
ReportMonth | varchar | 2147483647 | √ | null |
|
|
||||
ReportDate | varchar | 2147483647 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
csv_ix_1 | Performance | Asc | ClientName |