contracts_v1
Contract is an agreement which results in an invoice being generated on a regular basis for a single sum. Stock/Equipment/Jobs can be allocated against a contract for tracking purposes.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the contract. |
| reference | VARCHAR(80) | The reference of the contract that is inputted as free text. |
| contact_name | VARCHAR(256) | The name of the contact associated with the contract. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the contract creation. |
| planned_end_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the contract planned end. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the contract was deleted. |
| description | VARCHAR(4000) | The contract description that is inputted as free text. |
| number_of_jobs | NUMBER(38,0) | The number of jobs linked to the contract. |
| initial_payment_currency | VARCHAR(3) | The currency of the payment made upfront on the contract. |
| initial_payment | NUMBER(10,2) | The amount paid upfront on the contract. |
| _contact_id | NUMBER(38,0) | The identifier of the contact associated with the contract. |
| _customer_id | NUMBER(38,0) | The identifier of BigChange customer (tenant) that the contract record belongs to. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the contract record was last refreshed. |