Contracts Export
Export of these records is included as a Standard CSV Export.
Note:
CSV exports for SFTP only include a known issue where the Expires field adds an extra day to the expiry date. This does not affect exports made using the UI.
Contract
| Field Name | Description | Field Type | Required/Unique | Possible Values |
| Record Type | Record Type | No/No | ||
| Contract # | The contract number | string(50) | Yes/No | |
| Contract Name | The name of the contract | string(100) | Yes/No | |
| Content Groups | The content groups that can view this contract | No/No | ||
| Status | The status of the contract | string(50) | Yes/No | |
| Supplier | The supplier ID assocaited with the contract | integer | No/No | |
| Supplier Number | Supplier Number | No/No | ||
| Supplier Account # | The supplier account for the contract | string(255) | No/No | |
| Starts | The date the contract begins | datetime | No/No | |
| Expires | The date the contract expires | datetime | No/No | |
| Owner | The currency ID associated with the contract | integer | No/No | |
| Owner Login | The user login that owns the contract | No/No | ||
| Currency Code | Currency Code | No/No | ||
| Savings % | The % savings created by the contract | decimal(20,2) | No/No | |
| Version | The version number of the contract | integer | No/No | |
| Created By | The user ID that created the contract | No/No | ||
| Created By Login | Created By Login | No/No | ||
| Created Date | The date the contract was created | datetime | No/No | |
| Updated By | The user ID that most recently updated the contract | No/No | ||
| Updated By Login | The user login that most recently updated the contract | No/No | ||
| Updated Date | The date the contract was most recently updated | datetime | No/No | |
| Submitted Date | The date the contract was submitted | datetime | No/No | |
| Submitted By | The user ID of the person that submitted the contract | No/No | ||
| Submitted By Login | Ther user login that submitted the approval | No/No | ||
| Is Default | Is this the detault (Y/N) | boolean | No/No | |
| Default Account ID | The default account ID for the contract | integer | No/No | |
| Default Account Code | The default account code for the contract | No/No | ||
| Linked Projects | List of Project IDs linked to this contract | No/No | ||
| Linked Events | List of Event IDs linked to this contract | No/No |
Contract Term
| Field Name | Description | Field Type | Required/Unique | Possible Values |
| Record Type | Indicates the record type | No/No | ||
| Name | The name of the contract term | string(255) | Yes/No | |
| Type | The type of the contract term | string(255) | No/No | |
| Use Pct Discounts | Whether the contract term uses percentage discounts | boolean | No/No | |
| Tier 1 Upper Bound | Upper bound quantity/amount for tier 1 | decimal(30,4) | Yes/No | |
| Tier 2 Upper Bound | Upper bound quantity/amount for tier 2 | decimal(30,4) | No/No | |
| Tier 3 Upper Bound | Upper bound quantity/amount for tier 3 | decimal(30,4) | No/No | |
| Tier 4 Upper Bound | Upper bound quantity/amount for tier 4 | decimal(30,4) | No/No | |
| Tier 5 Upper Bound | Upper bound quantity/amount for tier 5 | decimal(30,4) | No/No | |
| Tier 6 Upper Bound | Upper bound quantity/amount for tier 6 | decimal(30,4) | No/No | |
| Tier 7 Upper Bound | Upper bound quantity/amount for tier 7 | decimal(30,4) | No/No | |
| Tier 8 Upper Bound | Upper bound quantity/amount for tier 8 | decimal(30,4) | No/No | |
| Tier 9 Upper Bound | Upper bound quantity/amount for tier 9 | decimal(30,4) | No/No | |
| Tier 10 Upper Bound | Upper bound quantity/amount for tier 10 | decimal(30,4) | No/No | |
| Tier 11 Upper Bound | Upper bound quantity/amount for tier 11 | decimal(30,4) | No/No | |
| Tier 12 Upper Bound | Upper bound quantity/amount for tier 12 | decimal(30,4) | No/No | |
| Tier 13 Upper Bound | Upper bound quantity/amount for tier 13 | decimal(30,4) | No/No | |
| Tier 14 Upper Bound | Upper bound quantity/amount for tier 14 | decimal(30,4) | No/No | |
| Tier 15 Upper Bound | Upper bound quantity/amount for tier 15 | decimal(30,4) | No/No | |
| Tier 16 Upper Bound | Upper bound quantity/amount for tier 16 | decimal(30,4) | No/No | |
| Tier 17 Upper Bound | Upper bound quantity/amount for tier 17 | decimal(30,4) | No/No | |
| Tier 18 Upper Bound | Upper bound quantity/amount for tier 18 | decimal(30,4) | No/No | |
| Tier 19 Upper Bound | Upper bound quantity/amount for tier 19 | decimal(30,4) | No/No | |
| Tier 20 Upper Bound | Upper bound quantity/amount for tier 20 | decimal(30,4) | No/No | |
| Tier 1 Discount % | Discount percentage for tier 1 | decimal(30,4) | No/No | |
| Tier 2 Discount % | Discount percentage for tier 2 | decimal(30,4) | No/No | |
| Tier 3 Discount % | Discount percentage for tier 3 | decimal(30,4) | No/No | |
| Tier 4 Discount % | Discount percentage for tier 4 | decimal(30,4) | No/No | |
| Tier 5 Discount % | Discount percentage for tier 5 | decimal(30,4) | No/No | |
| Tier 6 Discount % | Discount percentage for tier 6 | decimal(30,4) | No/No | |
| Tier 7 Discount % | Discount percentage for tier 7 | decimal(30,4) | No/No | |
| Tier 8 Discount % | Discount percentage for tier 8 | decimal(30,4) | No/No | |
| Tier 9 Discount % | Discount percentage for tier 9 | decimal(30,4) | No/No | |
| Tier 10 Discount % | Discount percentage for tier 10 | decimal(30,4) | No/No | |
| Tier 11 Discount % | Discount percentage for tier 11 | decimal(30,4) | No/No | |
| Tier 12 Discount % | Discount percentage for tier 12 | decimal(30,4) | No/No | |
| Tier 13 Discount % | Discount percentage for tier 13 | decimal(30,4) | No/No | |
| Tier 14 Discount % | Discount percentage for tier 14 | decimal(30,4) | No/No | |
| Tier 15 Discount % | Discount percentage for tier 15 | decimal(30,4) | No/No | |
| Tier 16 Discount % | Discount percentage for tier 16 | decimal(30,4) | No/No | |
| Tier 17 Discount % | Discount percentage for tier 17 | decimal(30,4) | No/No | |
| Tier 18 Discount % | Discount percentage for tier 18 | decimal(30,4) | No/No | |
| Tier 19 Discount % | Discount percentage for tier 19 | decimal(30,4) | No/No | |
| Tier 20 Discount % | Discount percentage for tier 20 | decimal(30,4) | No/No |
Per Order Contract Term
| Field Name | Description | Field Type | Required/Unique | Possible Values |
| Record Type | Indicates the record type | No/No | ||
| Name | The name of the contract term | string(255) | Yes/No | |
| Type | The type of the contract term | string(255) | No/No | |
| Use Pct Discounts | Whether the contract term uses percentage discounts | boolean | No/No | |
| Tier 1 Upper Bound | Upper bound quantity/amount for tier 1 | decimal(30,4) | Yes/No | |
| Tier 2 Upper Bound | Upper bound quantity/amount for tier 2 | decimal(30,4) | No/No | |
| Tier 3 Upper Bound | Upper bound quantity/amount for tier 3 | decimal(30,4) | No/No | |
| Tier 4 Upper Bound | Upper bound quantity/amount for tier 4 | decimal(30,4) | No/No | |
| Tier 5 Upper Bound | Upper bound quantity/amount for tier 5 | decimal(30,4) | No/No | |
| Tier 6 Upper Bound | Upper bound quantity/amount for tier 6 | decimal(30,4) | No/No | |
| Tier 7 Upper Bound | Upper bound quantity/amount for tier 7 | decimal(30,4) | No/No | |
| Tier 8 Upper Bound | Upper bound quantity/amount for tier 8 | decimal(30,4) | No/No | |
| Tier 9 Upper Bound | Upper bound quantity/amount for tier 9 | decimal(30,4) | No/No | |
| Tier 10 Upper Bound | Upper bound quantity/amount for tier 10 | decimal(30,4) | No/No | |
| Tier 11 Upper Bound | Upper bound quantity/amount for tier 11 | decimal(30,4) | No/No | |
| Tier 12 Upper Bound | Upper bound quantity/amount for tier 12 | decimal(30,4) | No/No | |
| Tier 13 Upper Bound | Upper bound quantity/amount for tier 13 | decimal(30,4) | No/No | |
| Tier 14 Upper Bound | Upper bound quantity/amount for tier 14 | decimal(30,4) | No/No | |
| Tier 15 Upper Bound | Upper bound quantity/amount for tier 15 | decimal(30,4) | No/No | |
| Tier 16 Upper Bound | Upper bound quantity/amount for tier 16 | decimal(30,4) | No/No | |
| Tier 17 Upper Bound | Upper bound quantity/amount for tier 17 | decimal(30,4) | No/No | |
| Tier 18 Upper Bound | Upper bound quantity/amount for tier 18 | decimal(30,4) | No/No | |
| Tier 19 Upper Bound | Upper bound quantity/amount for tier 19 | decimal(30,4) | No/No | |
| Tier 20 Upper Bound | Upper bound quantity/amount for tier 20 | decimal(30,4) | No/No | |
| Tier 1 Discount % | Discount percentage for tier 1 | decimal(30,4) | No/No | |
| Tier 2 Discount % | Discount percentage for tier 2 | decimal(30,4) | No/No | |
| Tier 3 Discount % | Discount percentage for tier 3 | decimal(30,4) | No/No | |
| Tier 4 Discount % | Discount percentage for tier 4 | decimal(30,4) | No/No | |
| Tier 5 Discount % | Discount percentage for tier 5 | decimal(30,4) | No/No | |
| Tier 6 Discount % | Discount percentage for tier 6 | decimal(30,4) | No/No | |
| Tier 7 Discount % | Discount percentage for tier 7 | decimal(30,4) | No/No | |
| Tier 8 Discount % | Discount percentage for tier 8 | decimal(30,4) | No/No | |
| Tier 9 Discount % | Discount percentage for tier 9 | decimal(30,4) | No/No | |
| Tier 10 Discount % | Discount percentage for tier 10 | decimal(30,4) | No/No | |
| Tier 11 Discount % | Discount percentage for tier 11 | decimal(30,4) | No/No | |
| Tier 12 Discount % | Discount percentage for tier 12 | decimal(30,4) | No/No | |
| Tier 13 Discount % | Discount percentage for tier 13 | decimal(30,4) | No/No | |
| Tier 14 Discount % | Discount percentage for tier 14 | decimal(30,4) | No/No | |
| Tier 15 Discount % | Discount percentage for tier 15 | decimal(30,4) | No/No | |
| Tier 16 Discount % | Discount percentage for tier 16 | decimal(30,4) | No/No | |
| Tier 17 Discount % | Discount percentage for tier 17 | decimal(30,4) | No/No | |
| Tier 18 Discount % | Discount percentage for tier 18 | decimal(30,4) | No/No | |
| Tier 19 Discount % | Discount percentage for tier 19 | decimal(30,4) | No/No | |
| Tier 20 Discount % | Discount percentage for tier 20 | decimal(30,4) | No/No |
Price Range Contract Term
| Field Name | Description | Field Type | Required/Unique | Possible Values |
| Record Type | Indicates the record type | No/No | ||
| Name | The name of the contract term | string(255) | Yes/No | |
| Type | The type of the contract term | string(255) | No/No | |
| Use Pct Discounts | Whether the contract term uses percentage discounts | boolean | No/No | |
| Tier 1 Upper Bound | Upper bound quantity/amount for tier 1 | decimal(30,4) | Yes/No | |
| Tier 2 Upper Bound | Upper bound quantity/amount for tier 2 | decimal(30,4) | No/No | |
| Tier 3 Upper Bound | Upper bound quantity/amount for tier 3 | decimal(30,4) | No/No | |
| Tier 4 Upper Bound | Upper bound quantity/amount for tier 4 | decimal(30,4) | No/No | |
| Tier 5 Upper Bound | Upper bound quantity/amount for tier 5 | decimal(30,4) | No/No | |
| Tier 6 Upper Bound | Upper bound quantity/amount for tier 6 | decimal(30,4) | No/No | |
| Tier 7 Upper Bound | Upper bound quantity/amount for tier 7 | decimal(30,4) | No/No | |
| Tier 8 Upper Bound | Upper bound quantity/amount for tier 8 | decimal(30,4) | No/No | |
| Tier 9 Upper Bound | Upper bound quantity/amount for tier 9 | decimal(30,4) | No/No | |
| Tier 10 Upper Bound | Upper bound quantity/amount for tier 10 | decimal(30,4) | No/No | |
| Tier 11 Upper Bound | Upper bound quantity/amount for tier 11 | decimal(30,4) | No/No | |
| Tier 12 Upper Bound | Upper bound quantity/amount for tier 12 | decimal(30,4) | No/No | |
| Tier 13 Upper Bound | Upper bound quantity/amount for tier 13 | decimal(30,4) | No/No | |
| Tier 14 Upper Bound | Upper bound quantity/amount for tier 14 | decimal(30,4) | No/No | |
| Tier 15 Upper Bound | Upper bound quantity/amount for tier 15 | decimal(30,4) | No/No | |
| Tier 16 Upper Bound | Upper bound quantity/amount for tier 16 | decimal(30,4) | No/No | |
| Tier 17 Upper Bound | Upper bound quantity/amount for tier 17 | decimal(30,4) | No/No | |
| Tier 18 Upper Bound | Upper bound quantity/amount for tier 18 | decimal(30,4) | No/No | |
| Tier 19 Upper Bound | Upper bound quantity/amount for tier 19 | decimal(30,4) | No/No | |
| Tier 20 Upper Bound | Upper bound quantity/amount for tier 20 | decimal(30,4) | No/No | |
| Tier 1 Discount % | Discount percentage for tier 1 | decimal(30,4) | No/No | |
| Tier 2 Discount % | Discount percentage for tier 2 | decimal(30,4) | No/No | |
| Tier 3 Discount % | Discount percentage for tier 3 | decimal(30,4) | No/No | |
| Tier 4 Discount % | Discount percentage for tier 4 | decimal(30,4) | No/No | |
| Tier 5 Discount % | Discount percentage for tier 5 | decimal(30,4) | No/No | |
| Tier 6 Discount % | Discount percentage for tier 6 | decimal(30,4) | No/No | |
| Tier 7 Discount % | Discount percentage for tier 7 | decimal(30,4) | No/No | |
| Tier 8 Discount % | Discount percentage for tier 8 | decimal(30,4) | No/No | |
| Tier 9 Discount % | Discount percentage for tier 9 | decimal(30,4) | No/No | |
| Tier 10 Discount % | Discount percentage for tier 10 | decimal(30,4) | No/No | |
| Tier 11 Discount % | Discount percentage for tier 11 | decimal(30,4) | No/No | |
| Tier 12 Discount % | Discount percentage for tier 12 | decimal(30,4) | No/No | |
| Tier 13 Discount % | Discount percentage for tier 13 | decimal(30,4) | No/No | |
| Tier 14 Discount % | Discount percentage for tier 14 | decimal(30,4) | No/No | |
| Tier 15 Discount % | Discount percentage for tier 15 | decimal(30,4) | No/No | |
| Tier 16 Discount % | Discount percentage for tier 16 | decimal(30,4) | No/No | |
| Tier 17 Discount % | Discount percentage for tier 17 | decimal(30,4) | No/No | |
| Tier 18 Discount % | Discount percentage for tier 18 | decimal(30,4) | No/No | |
| Tier 19 Discount % | Discount percentage for tier 19 | decimal(30,4) | No/No | |
| Tier 20 Discount % | Discount percentage for tier 20 | decimal(30,4) | No/No |