Description: The Financial Class table defines and maintains various financial classes
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
| 1 |
LKREGFINANCIALCLASSID |
INT |
|
|
Description: Primary Key
|
|
Name |
Type |
|
| 2 |
ORGANIZATIONID |
INT |
|
|
Description: OrganizationId is a foreign key to the Organization table
|
|
Name |
Type |
|
| 3 |
CODE |
NVARCHAR |
|
|
Description: The code used to Identify the financial class
|
|
Name |
Type |
|
| 4 |
DESCLONG |
NVARCHAR |
|
|
Description: The full description used to identify the financial class
|
|
Name |
Type |
|
| 5 |
DESCSHORT |
NVARCHAR |
|
|
Description: The abbreviated description used to identify the financial class
|
|
Name |
Type |
|
| 6 |
EFFECTIVEDATE |
DATETIME2 |
|
|
Description: The calendar date indicating when this financial class becomes effective for use in the system
|
|
Name |
Type |
|
| 7 |
DISCONTINUEDATE |
DATETIME2 |
|
|
Description: The calendar date indicating when this financial class is no longer available for use in the system
|