IBM Contract Management Model

You can use the folders and their associated elements in the IBM Suite Reporting Framework Model to generate custom reports.

For more information, refer Creating Custom Reports by using IBM Suite Reporting Framework Model.
Table 1. Contracts
Folder Elements
Contracts (This Class has all the entities from Contract Domain) Contract Name & Number
  Contract Name
Contract Name Link
Contract Title
Contract Number
Contract Category(Filter)
  Contract Category
Contract Class
  Contract Status(Filter)
Contract Status
Contract Sub Status
Contract Effective Start Date
Contract Effective End Date
Contract Execution Date
Contract Deletion Date
Contract Currency
Contract Total
Contract External Primary Party
Contract External Primary Party Current
Contract External Primary Party Contact
Contract Internal Primary Party
Contract Internal Party Current
Contract Internal Primary Party Contact
  Manager Contract Internal Primary Contact
Owning Organization
  Contracting Organization
  Contract Region
  Contract Origin
Contract Originated From (Provides information on where the contract originated from, Contract Template name if the contract was created from a template, or the name of the contract if the contract was created using Save As functionality.)
Contract From Template (Displays Yes if the contract came from template, otherwise No)
Contract Created By
Contract Created On
Contract Last Modified By
Contract Last Modified On
Is Contract Amended
  Contract Approval Status
Amended Contract Name
Contract Notes
Contract Origin Variant
Contract Converted On
Contract Converted By
Contract Version
Contract Negotiation Status
Contract Execution Type
Contract Termination Date
Contract Termination Reason Code
  Contract Revision
  Contract Nature
  Contract Time Zone
  Number of contracts
Interview Name
  Interview Design Name
Table 2. Login User
Folder Elements
Login User Internal Primary Party Contract
  Contracts Created By
  Contracts Last Modified By
  Contract Task Assigned To
  Contract Task Delegated By User
  Contract Task Initiated By
Table 3. Affiliated Organization
Folder Elements
Affiliated Organization (Displays the Affiliated Organization) Affiliated Organization Name
   
Table 4. Contract Custom Properties
Folder Elements
Contract Custom Properties Custom Property Name
Custom Property Description
  Custom Property Label
  Custom Property Data Type
Custom Property Date Value
  Custom Property String Value
  Custom Property Number Value
  Custom Property Value
Table 5. Contract External Party
Folder Elements
Contract External Party External Party Name
External Party Current Name
External Party Role
External Party Primary Contact
  Number Of External Party Signatories
Table 6. Contract External Party Contact
Folder Elements
Contract External Party Contact External Party Contact Name
External Party Contact Is Primary Address
External Party Contact Address
External Party Contact Street
External Party Contact State or Province
External Party Contact City
External Party Contact County
External Party Contact Country
External Party Contact Postal
External Party Contact Phone Type
External Party Contact Phone Number
External Party Contact Is Primary Phone
Table 7. Contract External Party Address
Folder Elements
Contract External Party Address External Party Address Role
External Party Address Street
External Party Address City
External Party Address County
External Party Address State or Province
External Party Address Postal Code
External Party Address Country
External Party Address Phone
External Party Address Email
Table 8. Contract Internal Party
Folder Elements
Contract Internal Party Internal Party Name
Internal Party Current Name
  Internal Party Role
Internal Party Primary Contact
  Number Of Internal Party Signatories
Table 9. Contract Internal Party Contact
Folder Elements
Contract Internal Party Contact Internal Party Contact Name
Internal Party Contact Is Primary Address
  Internal Party Contact Address
  Internal Party Contact Street
  Internal Party Contact State or Province
Internal Party Contact City
Internal Party Contact County
Internal Party Contact Country
Internal Party Contact Postal
  Internal Party Contact Phone Type
  Internal Party Contact Phone Number
Internal Party Contact Is Primary Phone
Table 10. Contract Internal Party Address
Folder Elements
Contract Internal Party Address Internal Party Address Role
  Internal Party Address Street
  Internal Party Address City
Internal Party Address County
Internal Party Address State or Province
  Internal Party Address Postal Code
Internal Party Address Country
  Internal Party Address Phone
  Internal Party Address Email
Table 11. Contract Clause
Folder Elements
Contract Clause Clause Name
  Clause Sequence
  Clause Template Name
Clause Approval Status
  Clause Title
Clause Body (First revision)
  Clause Body (Final revision)
  Clause Is Mapped
  Clause Is Mapped(Filter)
Clause Is Standard
  Clause Is Standard(Filter)
  Clause Is Modified
  Clause Is Modified(filter)
Clause Is Deleted
  Clause Is Deleted(FIlter)
  Clause Is Added
  Clause Is Added(Filter)
Clause Is Alternate
  Clause Is Alternate(Filter)
Clause Status
  Clause Status(Filter)
Clause Last Approved By
  Clause Has Approvals
Number of Clause Modifications
  Clause Last Modified By
Clause Last Modified On
Table 12.
Folder Elements
Contract Term Contract Term Label
Contract Term Name
Contract Term Type
Contract Term Value
Contract Term String Value
Contract Term Date Value
  Contract Term Number Value
Contract Term Is Currency
Contract Term Appears in Language
  Contract Term Mandatory
Contract Term System Term
Contract Term Currency Symbol
Table 13. Contract Line
Folder Elements
Contract Line Line Number
Is Active
Price List Name
  Product Name
  Product Number
Quantity
Pricing Scheme
  Percentage Factor
Unit List Price
  Total List Price
  Discount Percent
Discount Amount
Total Net Price
Term Start Date
  Term End Date
Actual Delivery Date
Promised Delivery Date
Actual Acceptance Date
Is Quote Generated
  Source Contract Name
Source Product Name
  Notes
Sourcing Category
Source Category Id
Sourcing Item Bid Id
  Sourcing Item Charge
Sourcing Item Description
  Sourcing Item Id
  Sourcing Item Revision
Sourcing Item Specification
Sourcing Item Spec URL
Sourcing Unit of Measure
  Days Lead Time
  Contract Line Internal Party ID
  Contract Line Internal Party Name
  Contract Line Internal Party Number
  Contract Internal Address Add ID
  Contract Line Internal Party Address ID
  Contract Line Internal Party Address Role
  Contract Line Internal Party Address
  Contract Line Original Contract Number
  Contract Line Sales Price List Entered
  Contract Line Original Product Name
  Contract Line Clause Template ID
  Contract Line Clause Template Name
  Contract Line Clause Template Text
  Contract Line External Company Individual ID
  Contract Line External Company Individual Name
  Contract Line External Company Individual Number
  Contract Line External Company Individual Address ID
  Contract Line External Company Individual Address Role
  Contract Line External Company Individual Address Add ID
  Contract Line External Company Individual Address
Table 14. Contract Line Definition Items
Folder Elements
Contract Line Definition Items Line Definition ID
  Data Definition ID
  Line Definition Name
  Line Definition Label
  Data Definition Column Order
  Data Definition Name
  Data Definition Label
Table 15. Attachments
Folder Elements
Attachments Contract Attachment File Name
  Contract Attachment Created By
  Contract Attachment Created On
Table 16. Activity
Folder Elements
Activity Contract Activity Date
  Contract Activity Name
  Contract Activity Name(Filter)
Contract Activity Clause Name
  Contract Activity Initiator
Contract Activity Individual Recipient
Contract Activity User Group Recipient
Contract Activity Comments
  Contract Activity Approval Completed
  Number of Activities
  Activity Id
Table 17. Workflow
Folder Elements
Workflow Draft Duration (Days)
Approval Duration (Days)
Clause Approval Durations (Days)
Contract Approval Duration (Days)
Internal Party Negotiation Duration (Days)
External Party Negotiation Duration (Days)
Creation to Execution Duration (Days)
  Number of Contract Approval Processes
Number of Clause Approval Processes
  Number of Negotiations with External Party
Table 18. Relationship
Folder Elements
Relationship Contract Relationship Name
  Contract Relationship Related Contract Name
Contract Relationship Created On
Contract Relationship Created By
Table 19. Contract Events
Folder Elements
Contract Events Contract Event Name
Contract Event Date
  Contract Event Type (Filter)
Contract Event Type
  Contract Is Recurring (Filter)
Contract Event Is Recurring
  Contract Event Offset Type (Filter)
Contract Event Offset Type
  Contract Event Offset Unit (Filter)
Contract Event Offset Unit
  Contract Event Property Date Name
Contract Event Line Name
Contract Event Line Date Name
Contract Event Term Date Name
  Contract Event Is Notification Enabled
Contract Event Notification Recurrence
  Contract Event Notification Offset Unit
  Contract Event Notification Offset Type
Contract Event Notification Date
Contract Event Recurrence
Contract Event Notification Send Date
  Contract Event Recurrence Pattern Unit
  Contract Event Is Recurrence Enabled
Contract Event Recurrence End Offset
  Contract Event Recurrence End Offset Unit
  Contract Event Recurrence End Date
  Contract Event Request Review Enabled
Contract Event Create Contract Enabled
  Contract Event Status
Contract Event Description
  Contract Event Review Clause
Contract Event Assign To
Contract Event Request Review Comments
  Contract Event Contract Name
Contract Event Template Name
Contract Event Relationship
  Contract Event Related Contract Task Comments
Table 20. SubStatus
Folder Elements
SubStatus Substatus Date
Substatus Initiator
  Substatus Name
Substatus Notes Category
Substatus Notes
  Duration of Substatus
Prior Substatus
  Next Substatus
Table 21. Comments
Folder Elements
Comments Contract Comments
  Contract Comment By
Contract Comment On
  Contract Comments Visible to All
Table 22. Contract Task
Folder Elements
Contract Task Contract Task User ID
  Contract Task ID
  Contract Task Age in Days
  Contract Task Assigned To User
  Contract Task Assigned to User Group
Contract Task Owner
Contract Task Initiator
Contract Delegated by
Contract Task Assigned Date
  Contract Task Clause
  Contract Task
  Manager for Assigned to User
  Number of Tasks
Table 23. Folders
Folder Elements
Folders Folder Name
  Parent Folder Name
Folder Created On
  Folder Created By
  Folder Modified On
  Folder Modified By
Table 24. Security
Folder Elements
Security User
  Is User
User Group Name
  Is User Group
Assigned Permission
  Group Access
Table 25. Contract Signatories
Folder Elements
Contract Signatories Contract Signatories Title
  Contract Signatories Name
  Contract Signatories Date
  Signatory Party Type
Table 26. Contract Template
Folder Elements
Contract Template Contract Template Name
  Contract Template Category
  Contract Template Class
  Contract Template Title
  Contract Template Guidelines
  Contract Template Reference URL
Contract Template Effective Start Date
  Contract Template Effective End Date
  Contract Template Notes
  Default Negotiability
  Created By
  Created On
  Last Modified By
  Last Modified On
Organization
  Applicability
  Suitability
  Offset Contract Deletion Unit
  Offset Contract Deletion Value
  Language
  Status
Table 27. Contract Template Clause
Folder Elements
Contract Template Clause Contract Template Clause Name
Table 28. Contract Template Folder
Folder Elements
Contract Template Folder Contract Template Folder Name
  Contract Template Parent Folder Name
Table 29. Contract Template Terms
Folder Elements
Contract Template Terms Mandatory
  System Term
  Appears in Language
  Term Group Name
  Term Definitions
Table 30. Contract Template Lines
Folder Elements
Contract Template Lines Line Definition
Line Definition Label
  Line Definition Order
Data Definition Name
  Data Definition Label
  Data Definition Order
Is Sourcing Line
Table 31. Contract Template Line Clauses
Folder Elements
Contract Template Line Clauses Line Clause Name
Line Type Name
  Line Type Label
Table 32. Contract Template Approvals
Folder Elements
Contract Template Approvals Approval Sequence
  UserName
  UserGroup Name
Table 33. Contract Template Event
Folder Elements
Contract Template Event Template Event Name
Template Event Description
  Template Event Date Type
  Template Event Date
  Template Event Offset
Template Event Date Offset Type
Template Event Date Offset Unit
  Is Notification Enabled
Notification Offset
Notification Offset Unit
  Notification Offset Type
Notification Send Date
Recurrence Pattern
  Pattern Offset Unit
  Recurrence End Offset
Recurrence End Offset Unit
  Recurrence End Date
Is Recurrence Enabled
  Request Review Enabled
Create Contract Enabled
Table 34. Contract Template Security
Folder Elements
Contract Template Security Security/User/Group Name
  Contract Template Permission/Permission Group
Table 35. Clause Template
Folder Elements
Clause Template Clause Template Name
  Clause Template Alternate Clause Title
  Clause Template Clause Type
  Clause Template Guidelines
  Clause Template Reference URL
Clause Template Title
  Title Style
Body Style
Effective Start Date
Effective End Date
  Created By
Created On
  Last Modified By
  Last Modified On
  Notes
  Clause Template Body
Is Clause Filter Defined
Filter on Contract Classes
Filter on Contract Region
Organizations
  Defined Alternatives
Required Approval for Alternates
Table 36. Clause Template Approvals
Folder Elements
Clause Template Approvals Clause Template Approval Sequence
  Clause Template User Group Id
  Clause Template User Id
Clause Template User/Group Name
  Approval Clause Name
Table 37. User Defined Properties
Folder Elements
User Defined Properties Property
  Property Type
  User Defined Value
Table 38. Approval Rule Set
Folder Elements
Approval Rule Set Approval Rule Set Name
  Approval Rule Set Content
  Rule Name
  Level
  Approver Name(s)
  Approver Group Name
Contract Conditions (all conditions apply)
  Contract Conditions
Term Value
  Term Name
Operator Type
  Approver Sequence
Combined Conditions(Rule Level)
Combined Conditions(Rule Set Level)
Table 39. Individual
Folder Elements
Individual Individual Name
  Company Type
  Company Name
Title
  Manager
External Id
  External Name
  Email
Effective Start Date
Effective End Date
Created By
  Last Modified By
  Created On
  Last Modified On
User Name
Login Status
  Login Status(Filter)
  Last Successful Login
  Last Unsuccessful Login
Account Start Date
  Account End Date
Delegation Start Date
Delegation End Date
  Individual Phones
  Module Visibility
User Group Name
User Group Description
  Is Active
  Number of Individuals
Table 40. Individual Phones
Folder Elements
Individual Phones Individual Phone Type
  Individual Phone Number
Individual Phone Is Primary
Table 41. Individual Address
Folder Elements
Individual Address Individual Address Is Primary Address
  Individual Address Is Primary(Filter)
  Individual Address Role
Individual Street
  Individual State or Province
Individual City
  Individual County
  Individual Country
Individual Postal Code
Table 42. External Company
Folder Elements
External Company External Company Name
  External Company Number
External Company Type
External Company Status
  External Company Organization Level
External Company External Id
  External Company Name
  External Company Email
External Company Duns Number
External Company NAICS/SIC code
  External Company Website
External Company Federal Tax Id
External Company Organizational Spend Id
  SSO_ID
  SSM_INTERNAL_ID
  VSM_ID
  PARENT_VSM_ID
  DATA_SOURCE
  DATA_SOURCE_ID
  SSM_UUID
  DISPLAY_NAME
  ALTERNATE_EMAIL_ADDRESS
External Company Notes
  External Company Effective Start Date
  External Company Effective End Date
  External Company Created By
  External Company Created On
  External Company Last Modified By
External Company Last Modified On
External Company Relationship Type
External Company Related Organization
Table 43. External Company Contacts
Folder Elements
External Company Contacts Contact Name
Is Primary Contact(Filter)
  Is Primary Contact
Email
  Contact Phone
Table 44. External Company Custom Properties
Folder Elements
External Company Custom Properties Custom Property Description
  Custom Property Label
Data Type
String Value
  Date Value
Number Value
  Custom Property Value
Table 45. External Company Address
Folder Elements
External Company Address Address Name
  Is Primary Address
Address Role
Street
  State or Province
City
  County
  Country
  Postal Code
Table 46. External Company Phones
Folder Elements
External Company Phones Phone Type
  Phone Number
  Is Primary Phone
Table 47. External Company Alias
Folder Elements
External Company Alias Alias Name
  Alias Is Primary
Table 48. My Company Organization
Folder Elements
My Company Organization My Company Organization Name
  My Company Organization Number
  Organization Level
External Id
  External Name
  Notes
  Effective Start Date
Effective End Date
Created By
Created On
Last Modified By
Last Modified On
Table 49. My Company Organization Alias
Folder Elements
My Company Organization Alias My Company Alias Name
Table 50. My Company Organization Phone
Folder Elements
My Company Organization Phone Phone Type
Phone Number
Is Primary Phone
Table 51. My Company Organization Address
Folder Elements
My Company Organization Address Is Primary Address
  Address Role
  Street
  State or Province
  City
  County
  Country
  Postal Code
Table 52. My Company Organization Contact
Folder Elements
My Company Organization Contact Is Primary Contact
  Contact Name
Table 53. Product
Folder Elements
Product Product Number
External Source
  External Id
  Product Name
  Product Type(Filter)
  Product Type
  Product Version
Product Class Name
Product Subclass
  Product Family
Product Effective Start Date
  Product Effective End Date
  Term Quantity
  Entitlement Quantity
  Product Term Unit(Filter)
  Product Term Unit Local
  Product Is Renewable
  Replacement Product Name
  Product Entitlement Unit Name
Product Created By
Product Created On
  Product Last Modified By
  Product Last Modified On
Table 54. Product Custom Properties
Folder Elements
Product Custom Properties Custom Property Name
  Custom Property Label
  Data Type
  String Value
  Date Value
  Number Value
  Product Custom Property Value
Table 55. ETL Status
Folder Elements
ETL Status ETL Start Time
  ETL End Time
  Elapsed Time
  Status
Parent topic: Custom Reports