The table shown below lists the fields used in a contract import file. The number in parentheses indicates the maximum character limit allowed.
|
Header |
UI Field the Header Maps To |
|
|---|---|---|
|
1 |
Admincontractid (64) |
Contract IDThis is a mandatory column. Select the tab to locate the field. |
|
2 |
Contractname (64) |
NameThis is a mandatory column. |
|
3 |
Description (255) |
Description |
|
4 |
Contracttype (32) |
Contract Type |
|
5 |
Contractstatus (32) |
Status |
|
6 |
Programname (255) |
Program Name |
|
7 |
Totalcost (Number ) |
Total Cost |
|
8 |
Internalcontactname (64) |
Internal Contact |
|
9 |
Internalcontactphone (16) |
Internal Phone Number |
|
10 |
parentcontract |
Parent Contract |
|
11 |
Internalcontactemail (64) |
Internal E-mail Address |
|
12 |
Keyterms (255) |
Terms and Conditions |
|
13 |
Startdate (date) |
Original Start Date |
|
14 |
Enddate (date) |
Current End Date |
|
15 |
Noticedescription (255) |
Notice Description |
|
16 |
Noticedate (date) |
Notice Date |
|
17 |
renewaloption |
Renewal Option |
|
18 |
Renewalprovision (255) |
Renewal Provision |
|
19 |
IVendorname (64) |
Vendor Name |
|
20 |
Adminvendorid (64) |
Vendor ID |
|
21 |
Accountnumber(64) |
Account Number |
|
22 |
Pricontactname (64) |
Primary Vendor Contact |
|
23 |
Pricontactphone (32) |
PhoneNumber |
|
24 |
Pricontactemail (32) |
E-mail Address |
|
25 |
Seccontactname (64) |
Secondary Vendor Contact |
|
26 |
Seccontactemail (32) |
Phone Number |
|
27 |
Seccontactphone (32) |
E-mail Address |
|
28 |
Definedservicelevel (128) |
Service Level Metric This is a mandatory column if SLA information is imported. |
|
29 |
Actualservicelevel (128) |
Actual Service Level |
|
30 |
Servicestartdate (date) |
Start Date |
|
31 |
Serviceenddate (date) |
End Date |
|
32 |
Site (32) |
Site |
|
33 |
Department (32) |
Department |
|
34 |
Costcenter (32) |
Cost center |
|
35 |
Userdocid |
Document ID |
|
36 |
Deliveryprocedures (255) |
Delivery Procedures |
|
37 |
Returnobligations (255) |
Return Obligations |
|
38 |
Rightstorelocate (255) |
Rights to Relocate, Alter, Sub-lease |
|
39 |
Defaultsandremedies (255) |
Defaults and Remedies |
|
40 |
Insuranceprovisions (255) |
Insurance Provisions |
|
41 |
Insuranceamount (Number) |
Insurance Cost |
|
42 |
Modificationprovisions (255) |
Equipment Modification Provisions |
|
43 |
Purchaseoption (255) |
Purchase Option |
|
44 |
Endofleaseprovisions (255) |
End-of-Lease Provisions |
|
45 |
Prevailinglaw (255) |
Prevailing Law |
|
46 |
Dateordered (date) |
Order Date |
|
47 |
Dateshipped (date) |
Ship Date |
|
48 |
Datedelivered (date) |
Delivery Date |
|
49 |
Datesignedfor(date) |
Signature Date |
|
50 |
Dateinspected (date) |
Inspection Date |
|
51 |
Dateaccepted (date) |
Acceptance Date |
|
52 |
Folder |
Folder to which the contract will be imported. For example, test/test1 means import in to the test1 folder, which is inside the test folder. |
|
53 |
Adf0-adf19 |
Import the administrator-defined fields for the contract. |