AccountCodes


Description

Account code lookup table for financial categorization and billing code management. This lookup table provides standardized account codes used for financial reporting, billing categorization, and accounting integration to support proper revenue recognition and financial analysis.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkCodeID int identity 4 √ null
ClaimServiceRate.fkCodeID FK_ClaimServiceRate_AccountCodes R

Primary key - Unique identifier for each account code
Code varchar 50 √ null

Account code - Standardized code used for financial categorization and billing purposes
Description varchar 200 √ null

Code description - Human-readable description explaining the purpose and usage of the account code
deleted bit 1 √ null

Deletion flag - Boolean indicator for soft deletion to maintain referential integrity while hiding inactive codes

Indexes

Constraint Name Type Sort Column(s)
PK_AccountCodes Primary key Asc pkCodeID

Relationships

Close relationships within degrees of separation