29.2 Fields

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 General 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.