Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BBSlogID | int identity | 4 | √ | null |
|
|
Primary key - AgencyBBSLog unique identifier for each transmission record |
|
| fkAgencyid | int | 4 | √ | null |
|
|
Agency reference - Reference to the agency that transmitted the file |
|
| fkBillID | int | 4 | √ | null |
|
|
Billing reference - Reference to the billing record associated with this transmission |
|
| DateEntered | datetime | 16,3 | √ | null |
|
|
Entry timestamp - Date and time when the transmission record was created |
|
| agencyName | varchar | 50 | √ | null |
|
|
Agency name - Name of the agency for quick reference |
|
| FileName | varchar | 50 | √ | null |
|
|
File name - Name of the transmitted billing file |
|
| Records | int | 4 | √ | null |
|
|
Record count - Number of billing records in the transmitted file |
|
| FileType | varchar | 30 | √ | null |
|
|
File type - Type of billing file (837, 835, etc.) |
|
| NumOfInvoices | int | 4 | √ | null |
|
|
Invoice count - Number of invoices included in the transmission |
|
| MCN | varchar | 50 | √ | null |
|
|
Media control number - Unique identifier for the transmission batch |
|
| BilledAmount | money | 21,4 | √ | null |
|
|
Billed amount - Total monetary amount billed in this transmission |