TransOptions


Description

Transaction option configurations managing calculation options and display settings for financial transactions and billing processes. This table defines transaction types, calculation methods, and display controls to support flexible transaction processing, billing calculations, and financial workflow customization for healthcare billing and payment management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
OptID int identity 4 √ null

Primary key - Unique identifier for each transaction option configuration
TransType varchar 20 √ null

Transaction type - Type of transaction this option applies to
Calculation varchar 200 √ null

Calculation method - Formula or method used for calculating transaction amounts
Show int 4 √ null

Display flag - Numeric indicator controlling whether this option is displayed to users

Indexes

Constraint Name Type Sort Column(s)
PK_TransOptions Primary key Asc OptID

Relationships

Close relationships within degrees of separation