Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DeleteReason | Unknown | 0 | null |
|
|
Deletion reason - Reason provided for deleting the invoice |
||
| pkId | int identity | 4 | √ | null |
|
|
Primary key - Primary key identifier for deleted invoice record |
|
| InvoiceID | int | 4 | null |
|
|
Invoice identifier - Primary identifier for the invoice |
||
| InvoiceDate | datetime | 16,3 | √ | null |
|
|
Invoice date - Date of the deleted invoice |
|
| InvoiceDateCycle | datetime | 16,3 | √ | null |
|
|
Invoice date cycle - Billing cycle date for the invoice |
|
| InvoiceTotal | money | 21,4 | √ | null |
|
|
Invoice total amount - Total amount of the invoice |
|
| Status | int | 4 | √ | null |
|
|
Invoice status - Status of the invoice when it was deleted |
|
| PatientID | int | 4 | √ | null |
|
|
Patient identifier - Reference to patient associated with invoice |
|
| PresentID | nvarchar | 40 | √ | null |
|
|
Present identifier - Reference to present record |
|
| VOUCHER | varchar | 30 | √ | null |
|
|
Voucher number - Voucher number for the invoice |
|
| fkInvoiceby | int | 4 | √ | null |
|
|
Invoice creator reference - Foreign key to user who created invoice |
|
| ProgramID | int | 4 | √ | null |
|
|
Program identifier - Reference to program associated with invoice |
|
| Checkamount | money | 21,4 | √ | null |
|
|
Check amount - Amount of check payment for the invoice |
|
| VoidAmount | money | 21,4 | √ | null |
|
|
Void amount - Amount that was voided on the invoice |
|
| DateFileGenerated | datetime | 16,3 | √ | null |
|
|
File generation date - Date when invoice file was generated |
|
| FiledBy | int | 4 | √ | null |
|
|
Filing user - User who filed the invoice |
|
| fkBillID | int | 4 | √ | null |
|
|
Bill reference - Foreign key to bill associated with invoice |
|
| DateAction | datetime | 16,3 | √ | null |
|
|
Action date - Date when action was performed on the invoice |
|
| ActionBy | int | 4 | √ | null |
|
|
Action user - User who performed the action on the invoice |
|
| INVOICEPAID | money | 21,4 | √ | null |
|
|
Invoice paid flag - Boolean indicating if invoice was paid |
|
| importid | int | 4 | √ | null |
|
|
Import identifier - Reference to import operation that created invoice |
|
| source | varchar | 20 | √ | null |
|
|
Invoice source - Source system or process that generated the invoice |
|
| fksiteID | int | 4 | √ | null |
|
|
Site reference - Foreign key to site where invoice was generated |
|
| AmountAdjusted | money | 21,4 | √ | null |
|
|
Adjusted amount - Amount that was adjusted on the invoice |
|
| InvComments | text | 2147483647 | √ | null |
|
|
Invoice comments - Comments associated with the invoice |
|
| fkRateTypeID | int | 4 | √ | null |
|
|
Rate type reference - Foreign key to rate type for invoice |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When the invoice was deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user - User who deleted the invoice |
|
| TotalAmount | Unknown | 0 | null |
|
|
Invoice total - Total amount of the deleted invoice |