Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BillingTypeID | Unknown | 0 | null |
|
|
Billing type reference - Reference to the billing type |
||
| FieldID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| FieldName | varchar | 50 | √ | null |
|
|
Field name - Name of the data field |
|
| FieldDesc | varchar | 500 | √ | null |
|
|
Description field - Detailed description or explanation of BillingTypeField information |
|
| FieldType | Unknown | 0 | null |
|
|
Field type - Data type of the field (Text, Number, Date, etc.) |
||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Whether this field is mandatory for this billing type |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__BillingTypeField__1BC821DD | Primary key | Asc | FieldID |