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 NameDescriptionField TypeRequired/UniquePossible Values
Record TypeRecord TypeNo/No
Contract #The contract numberstring(50)Yes/No
Contract NameThe name of the contractstring(100)Yes/No
Content GroupsThe content groups that can view this contractNo/No
StatusThe status of the contractstring(50)Yes/No
SupplierThe supplier ID assocaited with the contractintegerNo/No
Supplier NumberSupplier NumberNo/No
Supplier Account #The supplier account for the contractstring(255)No/No
StartsThe date the contract beginsdatetimeNo/No
ExpiresThe date the contract expiresdatetimeNo/No
OwnerThe currency ID associated with the contractintegerNo/No
Owner LoginThe user login that owns the contractNo/No
Currency CodeCurrency CodeNo/No
Savings %The % savings created by the contractdecimal(20,2)No/No
VersionThe version number of the contractintegerNo/No
Created ByThe user ID that created the contractNo/No
Created By LoginCreated By LoginNo/No
Created DateThe date the contract was createddatetimeNo/No
Updated ByThe user ID that most recently updated the contractNo/No
Updated By LoginThe user login that most recently updated the contractNo/No
Updated DateThe date the contract was most recently updateddatetimeNo/No
Submitted DateThe date the contract was submitteddatetimeNo/No
Submitted ByThe user ID of the person that submitted the contractNo/No
Submitted By LoginTher user login that submitted the approvalNo/No
Is DefaultIs this the detault (Y/N)booleanNo/No
Default Account IDThe default account ID for the contractintegerNo/No
Default Account CodeThe default account code for the contractNo/No
Linked ProjectsList of Project IDs linked to this contractNo/No
Linked EventsList of Event IDs linked to this contractNo/No

Contract Term

Field NameDescriptionField TypeRequired/UniquePossible Values
Record TypeIndicates the record typeNo/No
NameThe name of the contract termstring(255)Yes/No
TypeThe type of the contract termstring(255)No/No
Use Pct DiscountsWhether the contract term uses percentage discountsbooleanNo/No
Tier 1 Upper BoundUpper bound quantity/amount for tier 1decimal(30,4)Yes/No
Tier 2 Upper BoundUpper bound quantity/amount for tier 2decimal(30,4)No/No
Tier 3 Upper BoundUpper bound quantity/amount for tier 3decimal(30,4)No/No
Tier 4 Upper BoundUpper bound quantity/amount for tier 4decimal(30,4)No/No
Tier 5 Upper BoundUpper bound quantity/amount for tier 5decimal(30,4)No/No
Tier 6 Upper BoundUpper bound quantity/amount for tier 6decimal(30,4)No/No
Tier 7 Upper BoundUpper bound quantity/amount for tier 7decimal(30,4)No/No
Tier 8 Upper BoundUpper bound quantity/amount for tier 8decimal(30,4)No/No
Tier 9 Upper BoundUpper bound quantity/amount for tier 9decimal(30,4)No/No
Tier 10 Upper BoundUpper bound quantity/amount for tier 10decimal(30,4)No/No
Tier 11 Upper BoundUpper bound quantity/amount for tier 11decimal(30,4)No/No
Tier 12 Upper BoundUpper bound quantity/amount for tier 12decimal(30,4)No/No
Tier 13 Upper BoundUpper bound quantity/amount for tier 13decimal(30,4)No/No
Tier 14 Upper BoundUpper bound quantity/amount for tier 14decimal(30,4)No/No
Tier 15 Upper BoundUpper bound quantity/amount for tier 15decimal(30,4)No/No
Tier 16 Upper BoundUpper bound quantity/amount for tier 16decimal(30,4)No/No
Tier 17 Upper BoundUpper bound quantity/amount for tier 17decimal(30,4)No/No
Tier 18 Upper BoundUpper bound quantity/amount for tier 18decimal(30,4)No/No
Tier 19 Upper BoundUpper bound quantity/amount for tier 19decimal(30,4)No/No
Tier 20 Upper BoundUpper bound quantity/amount for tier 20decimal(30,4)No/No
Tier 1 Discount %Discount percentage for tier 1decimal(30,4)No/No
Tier 2 Discount %Discount percentage for tier 2decimal(30,4)No/No
Tier 3 Discount %Discount percentage for tier 3decimal(30,4)No/No
Tier 4 Discount %Discount percentage for tier 4decimal(30,4)No/No
Tier 5 Discount %Discount percentage for tier 5decimal(30,4)No/No
Tier 6 Discount %Discount percentage for tier 6decimal(30,4)No/No
Tier 7 Discount %Discount percentage for tier 7decimal(30,4)No/No
Tier 8 Discount %Discount percentage for tier 8decimal(30,4)No/No
Tier 9 Discount %Discount percentage for tier 9decimal(30,4)No/No
Tier 10 Discount %Discount percentage for tier 10decimal(30,4)No/No
Tier 11 Discount %Discount percentage for tier 11decimal(30,4)No/No
Tier 12 Discount %Discount percentage for tier 12decimal(30,4)No/No
Tier 13 Discount %Discount percentage for tier 13decimal(30,4)No/No
Tier 14 Discount %Discount percentage for tier 14decimal(30,4)No/No
Tier 15 Discount %Discount percentage for tier 15decimal(30,4)No/No
Tier 16 Discount %Discount percentage for tier 16decimal(30,4)No/No
Tier 17 Discount %Discount percentage for tier 17decimal(30,4)No/No
Tier 18 Discount %Discount percentage for tier 18decimal(30,4)No/No
Tier 19 Discount %Discount percentage for tier 19decimal(30,4)No/No
Tier 20 Discount %Discount percentage for tier 20decimal(30,4)No/No

Per Order Contract Term

Field NameDescriptionField TypeRequired/UniquePossible Values
Record TypeIndicates the record typeNo/No
NameThe name of the contract termstring(255)Yes/No
TypeThe type of the contract termstring(255)No/No
Use Pct DiscountsWhether the contract term uses percentage discountsbooleanNo/No
Tier 1 Upper BoundUpper bound quantity/amount for tier 1decimal(30,4)Yes/No
Tier 2 Upper BoundUpper bound quantity/amount for tier 2decimal(30,4)No/No
Tier 3 Upper BoundUpper bound quantity/amount for tier 3decimal(30,4)No/No
Tier 4 Upper BoundUpper bound quantity/amount for tier 4decimal(30,4)No/No
Tier 5 Upper BoundUpper bound quantity/amount for tier 5decimal(30,4)No/No
Tier 6 Upper BoundUpper bound quantity/amount for tier 6decimal(30,4)No/No
Tier 7 Upper BoundUpper bound quantity/amount for tier 7decimal(30,4)No/No
Tier 8 Upper BoundUpper bound quantity/amount for tier 8decimal(30,4)No/No
Tier 9 Upper BoundUpper bound quantity/amount for tier 9decimal(30,4)No/No
Tier 10 Upper BoundUpper bound quantity/amount for tier 10decimal(30,4)No/No
Tier 11 Upper BoundUpper bound quantity/amount for tier 11decimal(30,4)No/No
Tier 12 Upper BoundUpper bound quantity/amount for tier 12decimal(30,4)No/No
Tier 13 Upper BoundUpper bound quantity/amount for tier 13decimal(30,4)No/No
Tier 14 Upper BoundUpper bound quantity/amount for tier 14decimal(30,4)No/No
Tier 15 Upper BoundUpper bound quantity/amount for tier 15decimal(30,4)No/No
Tier 16 Upper BoundUpper bound quantity/amount for tier 16decimal(30,4)No/No
Tier 17 Upper BoundUpper bound quantity/amount for tier 17decimal(30,4)No/No
Tier 18 Upper BoundUpper bound quantity/amount for tier 18decimal(30,4)No/No
Tier 19 Upper BoundUpper bound quantity/amount for tier 19decimal(30,4)No/No
Tier 20 Upper BoundUpper bound quantity/amount for tier 20decimal(30,4)No/No
Tier 1 Discount %Discount percentage for tier 1decimal(30,4)No/No
Tier 2 Discount %Discount percentage for tier 2decimal(30,4)No/No
Tier 3 Discount %Discount percentage for tier 3decimal(30,4)No/No
Tier 4 Discount %Discount percentage for tier 4decimal(30,4)No/No
Tier 5 Discount %Discount percentage for tier 5decimal(30,4)No/No
Tier 6 Discount %Discount percentage for tier 6decimal(30,4)No/No
Tier 7 Discount %Discount percentage for tier 7decimal(30,4)No/No
Tier 8 Discount %Discount percentage for tier 8decimal(30,4)No/No
Tier 9 Discount %Discount percentage for tier 9decimal(30,4)No/No
Tier 10 Discount %Discount percentage for tier 10decimal(30,4)No/No
Tier 11 Discount %Discount percentage for tier 11decimal(30,4)No/No
Tier 12 Discount %Discount percentage for tier 12decimal(30,4)No/No
Tier 13 Discount %Discount percentage for tier 13decimal(30,4)No/No
Tier 14 Discount %Discount percentage for tier 14decimal(30,4)No/No
Tier 15 Discount %Discount percentage for tier 15decimal(30,4)No/No
Tier 16 Discount %Discount percentage for tier 16decimal(30,4)No/No
Tier 17 Discount %Discount percentage for tier 17decimal(30,4)No/No
Tier 18 Discount %Discount percentage for tier 18decimal(30,4)No/No
Tier 19 Discount %Discount percentage for tier 19decimal(30,4)No/No
Tier 20 Discount %Discount percentage for tier 20decimal(30,4)No/No

Price Range Contract Term

Field NameDescriptionField TypeRequired/UniquePossible Values
Record TypeIndicates the record typeNo/No
NameThe name of the contract termstring(255)Yes/No
TypeThe type of the contract termstring(255)No/No
Use Pct DiscountsWhether the contract term uses percentage discountsbooleanNo/No
Tier 1 Upper BoundUpper bound quantity/amount for tier 1decimal(30,4)Yes/No
Tier 2 Upper BoundUpper bound quantity/amount for tier 2decimal(30,4)No/No
Tier 3 Upper BoundUpper bound quantity/amount for tier 3decimal(30,4)No/No
Tier 4 Upper BoundUpper bound quantity/amount for tier 4decimal(30,4)No/No
Tier 5 Upper BoundUpper bound quantity/amount for tier 5decimal(30,4)No/No
Tier 6 Upper BoundUpper bound quantity/amount for tier 6decimal(30,4)No/No
Tier 7 Upper BoundUpper bound quantity/amount for tier 7decimal(30,4)No/No
Tier 8 Upper BoundUpper bound quantity/amount for tier 8decimal(30,4)No/No
Tier 9 Upper BoundUpper bound quantity/amount for tier 9decimal(30,4)No/No
Tier 10 Upper BoundUpper bound quantity/amount for tier 10decimal(30,4)No/No
Tier 11 Upper BoundUpper bound quantity/amount for tier 11decimal(30,4)No/No
Tier 12 Upper BoundUpper bound quantity/amount for tier 12decimal(30,4)No/No
Tier 13 Upper BoundUpper bound quantity/amount for tier 13decimal(30,4)No/No
Tier 14 Upper BoundUpper bound quantity/amount for tier 14decimal(30,4)No/No
Tier 15 Upper BoundUpper bound quantity/amount for tier 15decimal(30,4)No/No
Tier 16 Upper BoundUpper bound quantity/amount for tier 16decimal(30,4)No/No
Tier 17 Upper BoundUpper bound quantity/amount for tier 17decimal(30,4)No/No
Tier 18 Upper BoundUpper bound quantity/amount for tier 18decimal(30,4)No/No
Tier 19 Upper BoundUpper bound quantity/amount for tier 19decimal(30,4)No/No
Tier 20 Upper BoundUpper bound quantity/amount for tier 20decimal(30,4)No/No
Tier 1 Discount %Discount percentage for tier 1decimal(30,4)No/No
Tier 2 Discount %Discount percentage for tier 2decimal(30,4)No/No
Tier 3 Discount %Discount percentage for tier 3decimal(30,4)No/No
Tier 4 Discount %Discount percentage for tier 4decimal(30,4)No/No
Tier 5 Discount %Discount percentage for tier 5decimal(30,4)No/No
Tier 6 Discount %Discount percentage for tier 6decimal(30,4)No/No
Tier 7 Discount %Discount percentage for tier 7decimal(30,4)No/No
Tier 8 Discount %Discount percentage for tier 8decimal(30,4)No/No
Tier 9 Discount %Discount percentage for tier 9decimal(30,4)No/No
Tier 10 Discount %Discount percentage for tier 10decimal(30,4)No/No
Tier 11 Discount %Discount percentage for tier 11decimal(30,4)No/No
Tier 12 Discount %Discount percentage for tier 12decimal(30,4)No/No
Tier 13 Discount %Discount percentage for tier 13decimal(30,4)No/No
Tier 14 Discount %Discount percentage for tier 14decimal(30,4)No/No
Tier 15 Discount %Discount percentage for tier 15decimal(30,4)No/No
Tier 16 Discount %Discount percentage for tier 16decimal(30,4)No/No
Tier 17 Discount %Discount percentage for tier 17decimal(30,4)No/No
Tier 18 Discount %Discount percentage for tier 18decimal(30,4)No/No
Tier 19 Discount %Discount percentage for tier 19decimal(30,4)No/No
Tier 20 Discount %Discount percentage for tier 20decimal(30,4)No/No