InvoiceTransOptions


Description

Invoice transaction configuration - Configuration table defining invoice transaction types, calculation methods, and processing options. This table stores transaction type definitions, calculation formulas, display settings, SQL queries, and exclusion criteria to support flexible invoice processing, custom billing calculations, and transaction management workflows.

Columns

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

Option primary key - Unique identifier for each invoice transaction option
InvTransType varchar 20 √ null

Transaction type - Type classification of the invoice transaction
InvCalculation varchar 200 √ null

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

Display flag - Controls visibility of this transaction type in user interfaces
InvSQLQuery varchar 3500 √ null

SQL query - Custom SQL query for transaction data retrieval
InvExcludeStatus varchar 500 √ null

Exclusion criteria - Status values to exclude from transaction processing

Indexes

Constraint Name Type Sort Column(s)
PK_InvTransOptions Primary key Asc InvOptID

Relationships

Close relationships within degrees of separation