Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for the deleted invoice record |
|
| InvoiceID | int | 4 | null |
|
|
Invoice identifier - Original invoice ID that was deleted |
||
| InvoiceDate | datetime | 16,3 | √ | null |
|
|
Invoice date - Date when the original invoice was created |
|
| InvoiceDateCycle | datetime | 16,3 | √ | null |
|
|
Invoice cycle date - Billing cycle date for the deleted invoice |
|
| InvoiceTotal | money | 21,4 | √ | null |
|
|
Invoice total - Total amount of the deleted invoice |
|
| Status | int | 4 | √ | null |
|
|
Invoice status - Status of the invoice at the time of deletion |
|
| PatientID | int | 4 | √ | null |
|
|
Patient foreign key - Links to the patient associated with the deleted invoice |
|
| PresentID | nvarchar | 40 | √ | null |
|
|
Presentation identifier - External reference ID for the invoice |
|
| VOUCHER | varchar | 30 | √ | null |
|
|
Voucher number - Voucher or reference number for the invoice |
|
| fkInvoiceby | int | 4 | √ | null |
|
|
Invoiced by user - Foreign key to user who created the original invoice |
|
| ProgramID | int | 4 | √ | null |
|
|
Program foreign key - Links to the program type for the deleted invoice |
|
| Checkamount | money | 21,4 | √ | null |
|
|
Check amount - Amount paid by check for this invoice |
|
| VoidAmount | money | 21,4 | √ | null |
|
|
Void amount - Amount that was voided from the invoice |
|
| DateFileGenerated | datetime | 16,3 | √ | null |
|
|
File generation date - Date when billing file was generated for this invoice |
|
| FiledBy | int | 4 | √ | null |
|
|
Filed by user - User who filed or submitted the invoice |
|
| fkBillID | int | 4 | √ | null |
|
|
Billing batch foreign key - Links to the billing batch that contained this invoice |
|
| DateAction | datetime | 16,3 | √ | null |
|
|
Action date - Date when action was taken on the invoice |
|
| ActionBy | int | 4 | √ | null |
|
|
Action by user - User who took action on the invoice |
|
| INVOICEPAID | money | 21,4 | √ | null |
|
|
Invoice paid amount - Total amount paid for this invoice |
|
| importid | int | 4 | √ | null |
|
|
Import identifier - Foreign key linking to import batch if invoice was imported |
|
| source | varchar | 20 | √ | null |
|
|
Invoice source - Source system or method that created the invoice |
|
| fksiteID | int | 4 | √ | null |
|
|
Site foreign key - Links to the agency site for this invoice |
|
| AmountAdjusted | money | 21,4 | √ | null |
|
|
Adjustment amount - Total amount of adjustments applied to the invoice |
|
| InvComments | text | 2147483647 | √ | null |
|
|
Invoice comments - Additional notes or comments about the deleted invoice |
|
| fkRateTypeID | int | 4 | √ | null |
|
|
Rate type foreign key - Links to the rate type used for this invoice |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the invoice was deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - User ID of the person who deleted the invoice |
Relationships
Close relationships within degrees of separation
