invoice_entry Table (360)
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table contain all invoices, connected to a message
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | Primary key | PK | |
| message_id | The message.id this invoice entry is connected to. | FK ej_message | |
| description | A description of the invoice entry | String(255) | ● |
| type | The type of this invoice entry | FK invoice_type | |
| quantity | Number of units | Double | |
| price_pr_unit | Price per unit. This is copied from the invoice_type when created so that changes to the price in the future does not affect this one. | Int | |
| discount | Discount for this invoice entry | Int | |
| date_invoiced | The date for the invoice entry | DateTime | |
| discount_money | Discount for this invoice entry in money | Int | |
| ie_sum | The sum of the invoice entry | Int |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| message_id | FK | Index |
| type | FK | Index |
| date_invoiced | DateTime | Index |
Relationships
| Table | Description |
|---|---|
| ej_message | This table contains the messages listed under tickets. |
| invoice_type | A invoiceable item category (a product or service) that provides default invoice line values |
Replication Flags
- None
Security Flags
- No access control via user's Role.