invoice Table (265)
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table contains invoice entries, normally created when an invoice is sent to a customer, and we want to update the balance.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| time_charged | The amount of time (minutes) charged. From version 2.8 this field is no longer in use | Int | ● |
| price_charged | The amount (money) charged. | Double | ● |
| customer_id | The reference to the customer entry this entry is connected to. NULL or -1 if not connected. | FK person | |
| company_id | The reference to the company entry this entry is connected to. NULL or -1 if not connected. | FK contact | |
| created_at | When the invoice entry was created. | DateTime | ● |
| description | A string describing the invoice entry. | String(255) | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| customer_id | FK | Index |
| company_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| contact | Companies and Organizations. This table features a special record containing information about the contact that owns the database. |
| person | Persons in a company or an organizations. All associates have a corresponding person record |
Replication Flags
- None
Security Flags
- No access control via user's Role.