Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| InvoiceId | int | 4 | null |
|
|
Invoice identifier - Unique identifier for each invoice |
||
| PresentID | nvarchar | 40 | √ | null |
|
|
Presentation ID - Display identifier for the invoice |
|
| InvoiceDate | datetime | 16,3 | √ | null |
|
|
Invoice date - Date when the invoice was generated |
|
| Status | int | 4 | √ | null |
|
|
Invoice status - Current status of the invoice (Pending, Paid, Void, etc.) |
|
| StatusCode | varchar | 50 | √ | null |
|
|
Status code - Code representing the invoice status |
|
| Voucher | varchar | 30 | √ | null |
|
|
Voucher number - Voucher or reference number for the invoice |
|
| FkInvoiceby | int | 4 | √ | null |
|
|
Invoiced by user - UserID of the person who created the invoice |
|
| InvoiceByName | varchar | 101 | √ | null |
|
|
Invoiced by name - Name of the person who created the invoice |
|
| InvoiceTotal | money | 21,4 | null |
|
|
Invoice total - Total amount of the invoice |
||
| InvoicePaid | money | 21,4 | null |
|
|
Amount paid - Total amount paid against this invoice |
||
| Outstanding | money | 21,4 | null |
|
|
Outstanding amount - Remaining unpaid amount on the invoice |
||
| VoidAmount | money | 21,4 | √ | null |
|
|
Void amount - Amount that was voided from the invoice |
|
| AmountAdjusted | money | 21,4 | √ | null |
|
|
Adjusted amount - Amount that was adjusted (positive or negative) |
|
| InvoiceSite | varchar | 50 | √ | null |
|
|
Invoice site - Site or location associated with the invoice |
|
| BillId | int | 4 | null |
|
|
Bill identifier - Identifier for the billing record |
||
| FkSourceID | varchar | 50 | √ | null |
|
|
Source identifier - Payment source or payer identifier |
|
| DateBilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date when the invoice was billed or submitted |
|
| FkProgramID | int | 4 | √ | null |
|
|
Program identifier - Program associated with the invoice |
|
| BatchStatus | varchar | 20 | √ | null |
|
|
Batch status - Status of the billing batch containing this invoice |
|
| SourceName | varchar | 145 | √ | null |
|
|
Source name - Name of the payment source or payer |
|
| ProgramName | varchar | 255 | √ | null |
|
|
Program name - Name of the program associated with the invoice |
|
| AppId | int | 4 | √ | null |
|
|
Application identifier - Application or system identifier |
|
| ClaimOutstanding | money | 21,4 | null |
|
|
Claim outstanding - Outstanding amount at the claim level |
Relationships
Close relationships within degrees of separation
