Skip to main content
Mitratech Success Center

eCube Data Dictionary for TeamConnect Essentials

This page is a data dictionary for TeamConnect Essentials BI reporting tool.

What is a Data Dictionary?

This data dictionary defines the data types, friendly field names for the Tables and Columns in the eCube, and field hints. These fields are used to pull information from the system to create and manage reports. 

As mentioned above, users can use the fields and definitions listed below to build and run specific reports. The table below is meant to help you understand the data and identify which data fields to pull. For example, if you want to run a report that yields a list of invoices that shows which matter they are attached to, you will need to pull data from the Matter Name and Invoice table.

Essentials 6.0.2 BI eCube Data Definitions

The tables listed below define Data Types, Table Names, Column Names and Field hints for TeamConnect Essentials. Please note, the Database Table names and column names are not listed on this page but we have the information available. Please reach out to support or your account manager for access to that information.

Account System Object

Data Type

Friendly Table Name in eCube

Friendly Column Name in eCube

Field Hint

NUMBER

Account

Account Budget Available

Account balance, which results from the following equation: allocated - used = available

NVARCHAR2(100)

Account

Account Default Category

The default category for the account.

NVARCHAR2(4000)

Account

Account Default Category Full

The full name of the default account category including the parent's name (for example, Account:Vendor:eBilling).

NVARCHAR2(500)

Account

Account Name

Name used to describe the account.

VARCHAR2(4000)

Account

Account Note

Links to the table that contains the text entered into the Notes field of the record.

DATE

Account

Account Period End On

Specifies the date after which transactions cannot be posted to the account.

DATE

Account

Account Period Start On

Specifies the start date from which transactions can be posted to the account.

NUMBER

Account

Account Primary Key

The unique ID of the account record.

NUMBER

Account

Account Total Accrual

Total amount of accrual invoices that have been posted to this account, to date. Takes into account voids of accrual invoices.

NUMBER

Account

Account Total Allocated

Total amount of money allocated to the account through deposits or automatic transfers.

NUMBER

Account

Account Total Used

Total amount of money used through transfers, withdrawals, and posted transactions.

NVARCHAR2(706)

Account

Account Vendor

Contact specified as the posting criterion for the account. The company associated with the contact, if the contact is a person.

NVARCHAR2(706)

Account Budget And Spend

Account Created By

User who created the account. Links to specific information about the user account.

DATE

Account Budget And Spend

Account Created On

Date and time the account was created.

NVARCHAR2(706)

Account Budget And Spend

Account Created On Behalf Of

When not null, it indicates that the record was created through an e-billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

VARCHAR2(2)

Account Budget And Spend

Account Fiscal Start Month

First month of the Fiscal Year assocaited with the Account

NUMBER

Account Budget And Spend

Account Fiscal Year

The Fiscal Year associated with the Account

NVARCHAR2(706)

Account Budget And Spend

Account Modified By

User who most recently modified the account. Links to specific information about the user account.

DATE

Account Budget And Spend

Account Modified On

Date and time the account was most recently modified.

NUMBER

Account Budget And Spend

Account Month Num

The numeric month for the account

NVARCHAR2(500)

Account Budget And Spend

Account Name

Name used to describe the account.

DATE

Account Budget And Spend

Budget End Yearmonth

The last month for the Budget this Account is associated with

NUMBER

Account Budget And Spend

Budget Months

The month for the account

DATE

Account Budget And Spend

Budget Start Yearmonth

The first month for the Budget this Account is associated with

NUMBER

Account Budget And Spend

Spend

The total amount of all invoices posted to this Account

DATE

Account Budget And Spend

Startdate

Date which the account starts on

NUMBER

Account Budget And Spend

Totalbudget

The total budget on this account

DATE

Account Month Number

Account Month Num Fiscal Month

Enables user to plot month numbers 1-12 on a graph

NUMBER

Account Month Number

Account Month Num Start Year

Plot by year on a graph - ie, 2016, 2017, 2018, etc.

NUMBER

Account Month Number

Spend

Spend for a particular month number

 

Contact System Object

Data Type

Friendly Table Name in eCube

Friendly Column Name in eCube

Field Hint

DATE

Contact

Contact Birth Date

The birth date of the contact. Time-zone- independent.

NVARCHAR2(500)

Contact

Contact Company Name

The name of the contact, if the contact is a company.

NVARCHAR2(706)

Contact

Contact Created By

The user who created the contact record. The username assigned to this user account.

DATE

Contact

Contact Created On

Date the contact record was created.

NVARCHAR2(706)

Contact

Contact Created On Behalf Of

When not null, it indicates that the record was created through an e-billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

NVARCHAR2(6)

Contact

Contact Currency Code

The selected currency for the contact, which applies to the contact's rates. The universal 3-digit code of the currency item.

NVARCHAR2(100)

Contact

Contact Currency Name

The name of the currency item.

NVARCHAR2(6)

Contact

Contact Currency Symbol

The ISO symbol of the currency item.

NVARCHAR2(100)

Contact

Contact Default Address City

The city in the primary contact address.

NVARCHAR2(100)

Contact

Contact Default Address Country

The country in the primary contact address.

NVARCHAR2(100)

Contact

Contact Default Address County

The county of the primary contact address.

DATE

Contact

Contact Default Address Current As Of

The last known date the primary address was current. Time- zone- independent.

VARCHAR2(3)

Contact

Contact Default Address Is Current

Indicates whether the primary address is current. 0 = Not Current; 1 = Current

NVARCHAR2(100)

Contact

Contact Default Address Postal Code

The zip code in the primary contact address.

NVARCHAR2(100)

Contact

Contact Default Address Reference Number

The reference number for the primary contact address.

NVARCHAR2(100)

Contact

Contact Default Address State

The US state in the primary contact address.

NVARCHAR2(500)

Contact

Contact Default Address Street

The street address in the primary contact address.

NVARCHAR2(100)

Contact

Contact Default Address Type

The type of the primary contact address (such as Home or Business)

NVARCHAR2(100)

Contact

Contact Default Category

The default category for the contact.

NVARCHAR2(4000)

Contact

Contact Default Category Full

The full name of the default contact category including the parent's name (for example, Contact:Subsidiaries:Officers).

NVARCHAR2(500)

Contact

Contact Default Email

The selected default email address for the contact.

NVARCHAR2(100)

Contact

Contact Default Email Type

The type of the email address (such as Home or Business)

NVARCHAR2(100)

Contact

Contact Default Fax

The selected default fax number for the contact.

NVARCHAR2(100)

Contact

Contact Default Fax Type

The name of the phone type.

NVARCHAR2(500)

Contact

Contact Default Inet Address

The selected default internet address for the contact. The actual internet address.

NVARCHAR2(100)

Contact

Contact Default Inet Address Type

The type of the internet address.

NVARCHAR2(100)

Contact

Contact Default Phone

The selected default phone number for the contact.

NVARCHAR2(100)

Contact

Contact Default Phone Type

The name of the phone type.

NVARCHAR2(100)

Contact

Contact First Name

The first name of the contact.

NVARCHAR2(706)

Contact

Contact Full Name

Derived field containing the first and last names of the contact.

VARCHAR2(7)

Contact

Contact Is Person Or Company

The type of the contact. P - Person (PERSON) or C - Company (COMPANY)

NVARCHAR2(500)

Contact

Contact Job Title

The job title of the contact.

NVARCHAR2(100)

Contact

Contact Middle Name

The middle name of the contact.

NVARCHAR2(706)

Contact

Contact Modified By

The user who last modified the contact record. The username assigned to this user account.

DATE

Contact

Contact Modified On

Date the contact was last modified.

NVARCHAR2(500)

Contact

Contact Name

The last name of the contact, if the contact is a person. The name of the contact, if the contact is a company.

VARCHAR2(4000)

Contact

Contact Note

Links to the table that contains the text entered into the Notes field of the record.

NVARCHAR2(100)

Contact

Contact Number

Alphanumeric text that identifies this contact as per your company's standards.

NVARCHAR2(100)

Contact

Contact Prefix

The prefix of the contact's name (such as Mr. or Mrs.).

NUMBER

Contact

Contact Primary Key

The unique ID of the contact record.

NVARCHAR2(100)

Contact

Contact SSN or Tax Number

The Social Security number of the contact, if the contact is a person. The Tax ID of the contact, if the contact is a company.

NVARCHAR2(100)

Contact

Contact Salutation

Salutation will not appear in TeamConnect; this field remains for users upgrading from 2.x versions of TeamConnect and should be ignored by all 4.x users.

VARCHAR2(7)

Contact

Contact Security

The security of the record.

NVARCHAR2(100)

Contact

Contact Suffix

The suffix of the contact's name (such as Jr., Sr., or II)

NVARCHAR2(100)

Contact Addresses

Contact Address City

The city in the contact address.

NVARCHAR2(100)

Contact Addresses

Contact Address Country

The country in the contact address.

NVARCHAR2(100)

Contact Addresses

Contact Address County

The county of the contact address.

DATE

Contact Addresses

Contact Address Current As Of

The last known date the address was current. Time- zone- independent.

VARCHAR2(3)

Contact Addresses

Contact Address Is Current

Indicates whether the address is current. 0 = Not Current; 1 = Current

VARCHAR2(3)

Contact Addresses

Contact Address Is Default

Indicates whether the address is default. 0 = Not Default; 1 = Current

NVARCHAR2(100)

Contact Addresses

Contact Address Postal Code

The zip code in the contact address.

NVARCHAR2(100)

Contact Addresses

Contact Address Reference Number

The reference number for the contact address.

NVARCHAR2(100)

Contact Addresses

Contact Address State

The US state in the contact address.

NVARCHAR2(500)

Contact Addresses

Contact Address Street

The street address in the contact address.

NVARCHAR2(100)

Contact Addresses

Contact Address Type

The type of the contact address (such as Home or Business)

NVARCHAR2(100)

Contact Categories

Contact Category

Each category for the contact.

NVARCHAR2(4000)

Contact Categories

Contact Category Full

The full name of each contact category including the parent's name (for example, Contact:Subsidiaries:Officers).

NVARCHAR2(500)

Contact E-Mails

Contact Email

The actual email address.

VARCHAR2(3)

Contact E-Mails

Contact Email Is Default

Is Email the default method of contacting the contact?

NVARCHAR2(100)

Contact E-Mails

Contact Email Type

The type of the email address (such as Home or Business)

NVARCHAR2(100)

Contact Faxes

Contact Fax

The actual fax number.

VARCHAR2(3)

Contact Faxes

Contact Fax Is Default

Is Fax the default method of contacting the contact?

NVARCHAR2(100)

Contact Faxes

Contact Fax Type

The type of the fax number (such as Home or Business)

NVARCHAR2(500)

Contact Internet Addresses

Contact Inet Address

The actual internet address.

VARCHAR2(3)

Contact Internet Addresses

Contact Inet Address Is Default

Is Internet the default method of contacting the contact?

NVARCHAR2(100)

Contact Internet Addresses

Contact Inet Address Type

The type of the internet address.

NVARCHAR2(706)

Contact Left Relation

Contact Left Relation Full Name

Derived field containing the first and last names of the contact.

NVARCHAR2(100)

Contact Left Relation

Contact Left Relation Type

This information includes the contact on the left and right sides of the relationship and the type of relationship between the two contacts (such as "Attorney for" or "Employee of").

NVARCHAR2(100)

Contact Phones

Contact Phone

The actual phone number.

VARCHAR2(3)

Contact Phones

Contact Phone Is Default

Is Phone the default method of contacting the contact?

NVARCHAR2(100)

Contact Phones

Contact Phone Type

The type of this phone number (such as Home or Business)

NUMBER

Contact Rate Current

Contact Current Rate

The default rate value for the contact. If this value links to a category assigned to the Task object type, then the rate appeasr in the Rates block. If instead TASK_CATEGORY links to a category from the Task Categories lookup table in the Invoice Line Item object type, then the rate appears in the Invoice Task Rates block.

DATE

Contact Rate Current

Contact Current Rate Effective From

The date and time when the rate will begin to apply to the associated task. Time-zone- independent.

DATE

Contact Rate Current

Contact Current Rate Effective To

The date and time when the rate will cease applying to the associated task. Time-zone- independent.

NUMBER

Contact Rate History

Contact Rate

The default rate value for the contact. If this value links to a category assigned to the Task object type, then the rate appeasr in the Rates block. If instead TASK_CATEGORY links to a category from the Task Categories lookup table in the Invoice Line Item object type, then the rate appears in the Invoice Task Rates block.

DATE

Contact Rate History

Contact Rate Effective From

The date and time when the rate will begin to apply to the associated task. Time-zone- independent.

DATE

Contact Rate History

Contact Rate Effective To

The date and time when the rate will cease applying to the associated task. Time-zone- independent.

NVARCHAR2(706)

Contact Right Relation

Contact Right Relation Full Name

Derived field containing the first and last names of the contact.

NVARCHAR2(100)

Contact Right Relation

Contact Right Relation Type

This information includes the contact on the left and right sides of the relationship and the type of relationship between the two contacts (such as "Attorney for" or "Employee of").

NVARCHAR2(100)

Contact Skills

Contact Skill

The name of the skill type.

NUMBER

Contact Skills

Contact Skill Level

The skill level assigned to the contact for the skill type.

NVARCHAR2(4000)

Contact Task Rate Current

Contact Current Task Category

The task category that belongs to the rate.

NUMBER

Contact Task Rate Current

Contact Current Task Rate

The task rate value for the contact. If this value links to a category assigned to the Task object type, then the rate appeasr in the Rates block. If instead TASK_CATEGORY links to a category from the Task Categories lookup table in the Invoice Line Item object type, then the rate appears in the Invoice Task Rates block.

DATE

Contact Task Rate Current

Contact Current Task Rate Effective From

The date and time when the rate will begin to apply to the associated task. Time-zone- independent.

DATE

Contact Task Rate Current

Contact Current Task Rate Effective To

The date and time when the rate will cease applying to the associated task. Time-zone- independent.

NUMBER

Contact Task Rate History

Contact Task Rate

The default task rate value for the contact. If this value links to a category assigned to the Task object type, then the rate appeasr in the Rates block. If instead TASK_CATEGORY links to a category from the Task Categories lookup table in the Invoice Line Item object type, then the rate appears in the Invoice Task Rates block.

NVARCHAR2(4000)

Contact Task Rate History

Contact Task Rate Category

The task category that belongs to the rate.

DATE

Contact Task Rate History

Contact Task Rate Effective From

The date and time when the rate will begin to apply to the associated task. Time-zone- independent.

DATE

Contact Task Rate History

Contact Task Rate Effective To

The date and time when the rate will cease applying to the associated task. Time-zone- independent.

NVARCHAR2(100)

Contact Territories

Contact Territory

The name of the territory type.

 

 

Invoice System Object

Data Type

Friendly Table Name in eCube

Friendly Column Name in eCube

Field Hint

NUMBER

Invoice

Invoice Adjustment Total

(Fee adjustments total) + (Expense adjustments total)

NVARCHAR2(500)

Invoice

Invoice Batch Number

Not used

NVARCHAR2(500)

Invoice

Invoice Batch Short Description

Not used

DATE

Invoice

Invoice Billing End Date

The end date of the invoice period (time zone dependent)

DATE

Invoice

Invoice Billing Start Date

The start date of the invoice period (time zone dependent)

NVARCHAR2(4000)

Invoice

Invoice Comments

The comments intended to appear on the invoice for the vendor.

NVARCHAR2(706)

Invoice

Invoice Created By

The user who created the invoice record. Links to specific information about the user account.

DATE

Invoice

Invoice Created On

Date the invoice was created.

NVARCHAR2(706)

Invoice

Invoice Created On Behalf Of

When not null, it indicates that the record was created through an e-billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

NVARCHAR2(100)

Invoice

Invoice Currency Name

The name of the currency item.

NVARCHAR2(6)

Invoice

Invoice Currency Symbol

The ISO symbol of the currency item.

DATE

Invoice

Invoice Date

The date when the invoice was issued. (time zone dependent)

NVARCHAR2(100)

Invoice

Invoice Default Category

The default category associated with the invoice.

NVARCHAR2(4000)

Invoice

Invoice Default Category Full

The full name of the default invoice category including the parent's name (for example, Invoice:Contracts:Research).

NUMBER

Invoice

Invoice Discount Total

(Fee discounts total) + (Expense discounts total)

NUMBER

Invoice

Invoice Exchange Rate

The exchange rate of the invoice.

NUMBER

Invoice

Invoice Expense Adj Total

Sum of line item expense adjustments

NUMBER

Invoice

Invoice Expense Discount Total

Sum of line item expense original discounts

NUMBER

Invoice

Invoice Expense Tax Total

(Taxable line item expense net total)*(Invoice tax rate)

NUMBER

Invoice

Invoice Fee Adjustment Total

Line item fee adjustments total.

NUMBER

Invoice

Invoice Fee Discount Total

Line item fee original discounts total.

NUMBER

Invoice

Invoice Fee Tax Total

(Taxable line item fee net total)*(Invoice tax rate)

VARCHAR2(3)

Invoice

Invoice Has Non US Tax

If any line items have non-US tax codes entered in them, this value is TRUE, else it is FALSE.

VARCHAR2(3)

Invoice

Invoice Has Non Us Tax Rate

Is this Invoice using Non-US Tax Rates?

NUMBER

Invoice

Invoice Has Percentage Discount

An invoice discount in percent form.

VARCHAR2(3)

Invoice

Invoice Is Current Version

Is this Invoice the current version

NUMBER

Invoice

Invoice Is Electronic

If TRUE, indicates that the invoice originated from an e-billing application such as Collaborati.

VARCHAR2(3)

Invoice

Invoice Is Non US Tax Summary Level

Is the Non-US Tax Rate set to Summary Level?

NUMBER

Invoice

Invoice Line Item Number

Display the next availalbe line item number. For example, If there are 10 lineitems in the invoice, the next available number could be 11.

NUMBER

Invoice

Invoice Manual Amount

The total amount of the invoice as entered manually by the user.

NVARCHAR2(706)

Invoice

Invoice Modified By

The user who last modified the invoice record. Links to specific information about the user account.

DATE

Invoice

Invoice Modified On

Date the invoice was last modified.

NUMBER

Invoice

Invoice Net Expense Total

(Line item expenses total) + (Expense taxes total)

NUMBER

Invoice

Invoice Net Fee Total

(Line item fees net total) + (Fees taxes total)

NUMBER

Invoice

Invoice Net Total

(Net fees total) + (Net expenses total)

VARCHAR2(4000)

Invoice

Invoice Note

Links to the table that contains the text entered into the Notes field of the record.

NVARCHAR2(100)

Invoice

Invoice Number

Any alphanumeric text that describes the invoice record.

NUMBER

Invoice

Invoice Original Expense Total

(Line item expenses Original total) + (Line item expenses Original discounts total)

NUMBER

Invoice

Invoice Original Fee Total

(Line item fees Original total) + (Line item fees Original discounts total)

NUMBER

Invoice

Invoice Original Invoice Total

(Original fees total) + (Original expenses total)

VARCHAR2(10)

Invoice

Invoice Posting Status

The posting status of the invoice. 1 = Not Submitted; 2 = Posted; 3 = Not Posted; 5 = Rejected

NUMBER

Invoice

Invoice Primary Key

The unique ID of the invoice record.

DATE

Invoice

Invoice Received Date

The date the invoice was received (time zone dependent)

NVARCHAR2(100)

Invoice

Invoice Reference Number

If this invoice is of type Credit Note, then reference Number matches the numberString value of the original standard invoice for which this credit is intended.

VARCHAR2(7)

Invoice

Invoice Security

The security of the record.

NVARCHAR2(6)

Invoice

Invoice Submitted Currency Code

The currency selected for the invoice.

NUMBER

Invoice

Invoice Tax Total

(Fee taxes total) + (Expense taxes total)

VARCHAR2(6)

Invoice

Invoice Tax Type

Tax Type for this Invoice (US vs Non-US)

VARCHAR2(14)

Invoice

Invoice Type

The general type of the invoice. 0 = Standard (STANDARD); 1 = Accrual (ACCRUAL); 2 = Credit Note (CREDIT_NOTE); 3 = Shadow Invoice (SHADOW)

NVARCHAR2(706)

Invoice

Invoice Vendor

The contact record of the vendor associated with the invoice.

CHAR

Invoice

Invoice Warning

Warning message for the invoice captured by TeamConne ct that is generated by another application that processes invoices.

DATE

Invoice Adjustment

Invoice Adjusted On

Defaults to current date/time.

NVARCHAR2(706)

Invoice Adjustment

Invoice Adjustment Adjusted By

The user who made the adjustment. Links to specific information about the user account.

NVARCHAR2(500)

Invoice Adjustment

Invoice Adjustment Comments To Vendor

Comments about the adjustment that will be visible to vendors outside your company.

NVARCHAR2(500)

Invoice Adjustment

Invoice Adjustment In House Comments

Comments that are private, not transmitted to vendors or other outside sources.

NUMBER

Invoice Adjustment

Invoice Adjustment Previous Net Total

The net total of the entire invoice immediately before the current adjustment was applied.

NVARCHAR2(100)

Invoice Adjustment

Invoice Adjustment Reason

The selected reason for the adjustment.

VARCHAR2(14)

Invoice Adjustment

Invoice Adjustment Target

The target area to be impacted by the adjustment. One of these choices: 1 = Total Fees; 2 = Total Expenses; 3 = Total Invoice

NUMBER

Invoice Adjustment

Invoice Adjustment Total Expense

Adjustment amount to be applied only to the expense portion of the invoice. Calculation is done as specified by attribute adjustment TypeIID.

NUMBER

Invoice Adjustment

Invoice Adjustment Total Fee

Adjustment to be applied only to the fee portion of the invoice. Calculation is done as specified by attribute adjustment TypeIID.

NUMBER

Invoice Adjustment

Invoice Adjustment Total Invoice

Adjustment to be applied to the entire amount of the invoice. Calculation is done as specified by attribute adjustment TypeIID.

VARCHAR2(10)

Invoice Adjustment

Invoice Adjustment Type

Adjustment type. One of these choices: 1 = By Amount; 2 = By Percentage; 3 = To Amount

NVARCHAR2(100)

Invoice Categories

Invoice Category

Each category associated with the invoice.

NVARCHAR2(4000)

Invoice Categories

Invoice Category Full

The full name of each invoice category including the parent's name (for example, Invoice:Contracts:Research).

NUMBER

Invoice Category Adjustment

Invoice Category Adjusted Amount

Adjustment amount for Invoice Adjustment

NVARCHAR2(706)

Invoice Category Adjustment

Invoice Category Adjusted By

Who submitted the Adjustment

DATE

Invoice Category Adjustment

Invoice Category Adjusted On

When the adjustment was submitted

VARCHAR2(10)

Invoice Category Adjustment

Invoice Category Adjusted Type

Type of adjustment: By Percent, By Amount, or To Amount

NVARCHAR2(100)

Invoice Category Adjustment

Invoice Category Adjustment Category Name

Invoice category adjustment category name.

NVARCHAR2(500)

Invoice Category Adjustment

Invoice Category Adjustment Comments To Vendor

Comments to Requester for Adjustments made to Invoice

NVARCHAR2(500)

Invoice Category Adjustment

Invoice Category Adjustment In House Comments

In House comments for Adjustments made to Invoice

NUMBER

Invoice Category Adjustment

Invoice Category Adjustment Previous Net Total

Invoice total prior to Adjustments

NVARCHAR2(100)

Invoice Category Adjustment

Invoice Category Adjustment Reason

Reason for Adjustment to Invoice

NVARCHAR2(100)

Invoice Line Item

Invoice Line Item Activity Item

The activity item associated with the line item of type task. Links to the definition information for the task activity item.

NUMBER

Invoice Line Item

Invoice Line Item Adjusted Discount

The net discount of the line item.

NUMBER

Invoice Line Item

Invoice Line Item Adjusted Quantity

The net quantity of the line item.

NUMBER

Invoice Line Item

Invoice Line Item Adjusted Rate

The net rate of the line item.

VARCHAR2(6)

Invoice Line Item

Invoice Line Item Adjustment Source

Source of adjustment. One of two choices: 1 = Manual; 2 = Automatic

NVARCHAR2(706)

Invoice Line Item

Invoice Line Item Created By

The user who created the invoice record. Links to specific information about the user account.

DATE

Invoice Line Item

Invoice Line Item Created On

Date the invoice was created.

NVARCHAR2(100)

Invoice Line Item

Invoice Line Item Currency Item

Name of currency.

NVARCHAR2(100)

Invoice Line Item

Invoice Line Item Default Category

The default category associated with the line item.

NVARCHAR2(4000)

Invoice Line Item

Invoice Line Item Default Category Full

The full name of the default line item category including the parent's name (for example, LineItem:Research:L101).

NUMBER

Invoice Line Item

Invoice Line Item Default Current Discount

The net discount of the line item in the system's default currency.

NUMBER

Invoice Line Item

Invoice Line Item Default Current Rate

The net rate of the line item in the system's default currency

NUMBER

Invoice Line Item

Invoice Line Item Default Current Total

The net total of the line item in the system's default currency

NVARCHAR2(4000)

Invoice Line Item

Invoice Line Item Description

The description of the line item.

NVARCHAR2(100)

Invoice Line Item

Invoice Line Item Expense Type

The expense category of the line item, if the line item is an expense.

NVARCHAR2(4000)

Invoice Line Item

Invoice Line Item Expense Type Full

The full expense category of the line item, if the line item is an expense.

VARCHAR2(3)

Invoice Line Item

Invoice Line Item Has Adjustments

Have any adjustments been applied to this Line Item?

VARCHAR2(3)

Invoice Line Item

Invoice Line Item Has Warnings

Indicates whether warning conditions have been noted for this line item.

NVARCHAR2(4000)

Invoice Line Item

Invoice Line Item Internal Comments

In House comments on a Line Item

VARCHAR2(3)

Invoice Line Item

Invoice Line Item Is Appealed

Has this Line Item been appealed?

VARCHAR2(3)

Invoice Line Item

Invoice Line Item Is Taxable

Currently not used.

NVARCHAR2(706)

Invoice Line Item

Invoice Line Item Modified By

The user who last modified the line item. Links to specific information about the user account

DATE

Invoice Line Item

Invoice Line Item Modified On

The date that the line item was modified.

NUMBER

Invoice Line Item

Invoice Line Item Net Total

The net total of the line item.

NUMBER

Invoice Line Item

Invoice Line Item Number

The number assigned to the line item at the time it was created.Invo ice item numbers begin at 1 and increment as high as necessary to accommodate the invoice's line item.If a line item is deleted, its item number is not reused for any existing or future line item.

NUMBER

Invoice Line Item

Invoice Line Item Original Discount

The original discount of the line item.

NUMBER

Invoice Line Item

Invoice Line Item Original Quantity

The original quantity of line item.

NUMBER

Invoice Line Item

Invoice Line Item Original Rate

The original rate of the line item.

NUMBER

Invoice Line Item

Invoice Line Item Original Total

The original total of the line item.

NUMBER

Invoice Line Item

Invoice Line Item Primary Key

The unique ID of the line item.

NUMBER

Invoice Line Item

Invoice Line Item Quantity

The current quantity of the line item.

VARCHAR2(7)

Invoice Line Item

Invoice Line Item Security

The security of the record.

DATE

Invoice Line Item

Invoice Line Item Service Date

The date when the service to which the line item refers was rendered. Time-zone- independent .

NVARCHAR2(100)

Invoice Line Item

Invoice Line Item Task Category

The category to which this detail belongs. Links to a category to which the line item belongs.

NVARCHAR2(4000)

Invoice Line Item

Invoice Line Item Task Category Full

The full category to which this detail belongs. Links to a category to which the line item belongs. Note that most line items belong to multiple categories - a specific category, plus any parent category, grandparent category, etc.

VARCHAR2(7)

Invoice Line Item

Invoice Line Item Task Or Expense

Defines line item type as Fee or Expense.

NVARCHAR2(706)

Invoice Line Item

Invoice Line Item Timekeeper

The contact who performed the service or provided the goods. Links to the specific information about the contact object.

NUMBER

Invoice Line Item

Invoice Line Item Total Adjustment

The total amount of all adjustments made to the line item.

NVARCHAR2(4000)

Invoice Line Item

Invoice Line Item Warnings

Collected text of warning messages related to this line item.

NVARCHAR2(706)

Invoice Line Item Adjustments

Invoice Line Item Adjusted By

The user who made the adjustment. Links to specific information about the user account.

DATE

Invoice Line Item Adjustments

Invoice Line Item Adjusted On

Defaults to current date/ time.

NUMBER

Invoice Line Item Adjustments

Invoice Line Item Adjustment Amount

Adjustment to be applied to the line item. Calculation is done as specified by adjustment TypeIID.

NVARCHAR2(4000)

Invoice Line Item Adjustments

Invoice Line Item Adjustment Comment To Vendor

Comments about the adjustment that will be visible to vendors outside your company.

NVARCHAR2(500)

Invoice Line Item Adjustments

Invoice Line Item Adjustment In House Comment

Comments that are private, not transmitted to vendors or other outside sources.

NUMBER

Invoice Line Item Adjustments

Invoice Line Item Adjustment Previous Net Total

The net total of the line item immediately before the current adjustment was applied.

NUMBER

Invoice Line Item Adjustments

Invoice Line Item Adjustment Quantity

Current Unit", updated Unit value after Adjustment
SI$_LNI$_ADJUSTMENTS LNI$_ADJUSTMENT_RATE NUMBER Invoice Line Item Adjustments Invoice Line Item Adjustment Rate "Current Rate", updated Rate value after Adjustment
SI$_LNI$_ADJUSTMENTS LNI$_ADJUSTMENT_REASON NVARCHAR2(100) Invoice Line Item Adjustments Invoice Line Item Adjustment Reason The selected reason for the adjustment.
SI$_LNI$_ADJUSTMENTS LNI$_ADJUSTMENT_TARGET VARCHAR2(8) Invoice Line Item Adjustments Invoice Line Item Adjustment Target The target area to be impacted by the adjustment. One of these choices: 1 = Total Fees; 2 = Total Expenses; 3 = Total Invoice
SI$_LNI$_ADJUSTMENTS LNI$_ADJUSTMENT_TYPE VARCHAR2(10) Invoice Line Item Adjustments Invoice Line Item Adjustment Type Adjustment type. One of these choices: 1 = By Amount; 2 = By Percentage; 3 = To Amount
SI$_LNI$_NONUS_TAX_CODES LNI$_NON_US_TAX_CODE NVARCHAR2(100) Invoice Line Item Non US Tax Codes Invoice Line Item Non Us Tax Code Non-US Tax Code being applied to this Line Item
SI$_LNI$_TMK$_DEF_RATE TMK$_CURRENT_RATE NUMBER Invoice Line Item Timekeeper Default Rate Timekeeper Current Rate Invoice Line Item Timekeeper Default Current Rate
SI$_LNI$_TMK$_DEF_RATE TMK$_CURRENT_RATE_EFF_FROM DATE Invoice Line Item Timekeeper Default Rate Timekeeper Current Rate Effective From "Invoice Line Item Timekeeper Default Rate Effective From

NUMBER

Invoice Non US Tax

Invoice Dcurr Tax Amount

The tax amount in the invoice's default currency.

NUMBER

Invoice Non US Tax

Invoice Non US Tax Amount

The tax amount in original, local currency.

NVARCHAR2(100)

Invoice Non US Tax

Invoice Non US Tax Code

The unique 20- character alphanumeric code that the solution developer specifies when entering a new tax code.

NVARCHAR2(100)

Invoice Non US Tax Rates

Invoice Non US Tax Code

The unique 20- character alphanumeric code that the solution developer specifies when entering a new tax code.

NUMBER

Invoice Non US Tax Rates

Invoice Non US Tax Rate

Rate associated with each tax code?

 

 

Project Security

Data Type

Friendly Table Name in eCube

Friendly Column Name in eCube

Field Hint

NVARCHAR2(200)

Project Row Security

Username

Project Row Security Username

 

 

Timekeeper Rate Object

Data Type

Friendly Table Name in eCube

Friendly Column Name in eCube

Field Hint

NUMBER

Invoice Line Item Timekeeper Default Rate

Timekeeper Current Rate

Invoice Line Item Timekeeper Default Current Rate

DATE

Invoice Line Item Timekeeper Default Rate

Timekeeper Current Rate Effective From

Invoice Line Item Timekeeper Default Rate Effective From

DATE

Invoice Line Item Timekeeper Default Rate

Timekeeper Current Rate Effective To

Invoice Line Item Timekeeper Default Rate Effective To

NUMBER

Invoice Line Item Timekeeper Default Rate History

Timekeeper Rate

Invoice Line Item Timekeeper Default History Rate

DATE

Invoice Line Item Timekeeper Default Rate History

Timekeeper Rate Effective From

Invoice Line Item Timekeeper Default Rate History Effective From

DATE

Invoice Line Item Timekeeper Default Rate History

Timekeeper Rate Effective To

Invoice Line Item Timekeeper Default Rate History Effective To

NUMBER

Invoice Line Item Timekeeper Task Rate

Timekeeper Current Task Rate

Invoice Line Item Timekeeper Current Task Rate

DATE

Invoice Line Item Timekeeper Task Rate

Timekeeper Current Task Rate Effective From

Invoice Line Item Timekeeper Current Task Rate Effective From

DATE

Invoice Line Item Timekeeper Task Rate

Timekeeper Current Task Rate Effective To

Invoice Line Item Timekeeper Current Task Rate Effective To

NUMBER

Invoice Line Item Timekeeper Task Rate History

Timekeeper Task Rate

Invoice Line Item Timekeeper Task Rate History

DATE

Invoice Line Item Timekeeper Task Rate History

Timekeeper Task Rate Effective From

Invoice Line Item Timekeeper Task Rate History Effective From

DATE

Invoice Line Item Timekeeper Task Rate History

Timekeeper Task Rate Effective To

Invoice Line Item Timekeeper Task Rate History Effective To

 

 

Matter Project Object

Data Type

Friendly Table Name in eCube

Friendly Column Name in eCube

Field Hint

DATE

Matter

Matter Closed On

Date the project status was changed to closed.

NVARCHAR2(706)

Matter

Matter Created By

User who created the project.

DATE

Matter

Matter Created On

Date the project record was created.

NVARCHAR2(706)

Matter

Matter Created On Behalf Of

When not null, it indicates that the record was created through an e- billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

NVARCHAR2(500)

Matter

Matter Current Phase

The current phase of the project.

NVARCHAR2(100)

Matter

Matter Default Category

The default category associated with the project.

NVARCHAR2(4000)

Matter

Matter Default Category Full

The full name of the default matter category including the parent's name (for example, Project:Litigation:Contract).

DATE

Matter

Matter Main Assignee Assign On

Date primary assignee was assigned to the matter

NVARCHAR2(706)

Matter

Matter Main Assignee Name

Primary assignee's name.

NVARCHAR2(100)

Matter

Matter Main Assignee Role

Primary assignee's role.

NVARCHAR2(706)

Matter

Matter Modified By

User who last modified the project.

DATE

Matter

Matter Modified On

Date the record was last modified.

NVARCHAR2(500)

Matter

Matter Name

The name of the record.

NVARCHAR2(100)

Matter

Matter Number

The record number.

DATE

Matter

Matter Opened On

Date the project was opened.

NUMBER

Matter

Matter Primary Key

The unique ID of the project record.

VARCHAR2(7)

Matter

Matter Security

The security of the record.

NVARCHAR2(706)

Matter Assignees

Matter Assignee Name

Name of any assignee on that matter.

NVARCHAR2(100)

Matter Assignees

Matter Assignee Role

Role of a given matter assignee.

NVARCHAR2(100)

Matter Categories

Matter Category

Each category associated with the project.

NVARCHAR2(4000)

Matter Categories

Matter Category Full

The full name of each matter category including the parent's name (for example, Project:Litigation:Contract).

NUMBER

Matter Phase History

Matter Phase Duration

The duration of the phase.

NVARCHAR2(500)

Matter Phase History

Matter Phase Name

The name of the phase.

NVARCHAR2(706)

Matter Phase History

Matter Phase Transition By

The user who changed the project o this phase.

DATE

Matter Phase History

Matter Phase Transitioned On

The date on which the phase was selected for the project (or, the date that the phase was changed).

 

 

Matter Involved Object

Data Type

Friendly Table Name in eCube

Friendly Column Name in eCube

Field Hint

DATE

Matter|Involved Party

Involved Party Active Date

The date on which the involved party became active.

NVARCHAR2(706)

Matter|Involved Party

Involved Party Contact Full Name

The contact who is selected as the involved party for this involved record. Links to specific information about the contact record.

NVARCHAR2(706)

Matter|Involved Party

Involved Party Created By

User who created the involved record. Links to specific information about the user account.

DATE

Matter|Involved Party

Involved Party Created On

Date the involved record was created.

NVARCHAR2(100)

Matter|Involved Party

Involved Party Default Category

The default category associated with the involved party.

NVARCHAR2(4000)

Matter|Involved Party

Involved Party Default Category Full

The full name of the default involved party category including the parent's name (for example, Involved:Opposing:Plaintiff).

DATE

Matter|Involved Party

Involved Party Inactive Date

The date on which the involved party became inactive.

NVARCHAR2(706)

Matter|Involved Party

Involved Party Modified By

The user who last modified the record. Links to specific information about the user account.

DATE

Matter|Involved Party

Involved Party Modified On

The date on which the record was last modified.

VARCHAR2(4000)

Matter|Involved Party

Involved Party Note

The notes entered for the record. Links to the table that contains the text entered into the Notes field of the record.

NVARCHAR2(706)

Matter|Involved Party

Involved Party On Behalf Full Name

When not null, it indicates that the record was created through an e-billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

NUMBER

Matter|Involved Party

Involved Party Primary Key

The unique ID of the involved record.

VARCHAR2(7)

Matter|Involved Party

Involved Party Security

The security of the record.

VARCHAR2(8)

Matter|Involved Party

Involved Party Status

1 = Involved party is active; 0 = Involved party is inactive.

NVARCHAR2(100)

Matter|Involved Party Categories

Involved Party Category

Each category associated with the involved party.

NVARCHAR2(4000)

Matter|Involved Party Categories

Involved Party Category Full

The full name of each involved party category including the parent's name (for example, Involved:Opposing:Plaintiff).

 

 

Additional Custom Fields 

Data Type

Friendly Table Name in eCube

Friendly Column Name in eCube

Field Hint

NUMBER

Account Details

Last Total Accrual Value

Custom Field under Category Account Details. The location in the cube is within Account Details table/block called [Last Total Accrual Value]

NVARCHAR2(100)

Contact Details

Contact Type

Custom Field under Category Contact Details. The location in the cube is within Contact Details table/block called [Contact Type]

NVARCHAR2(4000)

Contact Details

Converted Number

Custom Field under Category Contact Details. The location in the cube is within Contact Details table/block called [Converted Number]

NVARCHAR2(100)

Contact Details

External Category

Custom Field under Category Contact Details. The location in the cube is within Contact Details table/block called [External Category]

NVARCHAR2(100)

Contact Details

Internal Category

Custom Field under Category Contact Details. The location in the cube is within Contact Details table/block called [Internal Category]

NVARCHAR2(100)

Contact Details

Internal Category *2

Custom Field under Category Contact Details. The location in the cube is within Contact Details table/block called [Internal Category *2]

VARCHAR2(9)

Contact:External:Law Firm Details

Minority Owned Firm

Custom Field under Category Contact:External:Law Firm Details. The location in the cube is within Contact:External:Law Firm Details table/block called [Minority Owned Firm]

NUMBER

Contact:External:Law Firm Details

Overall Performance

Custom Field under Category Contact:External:Law Firm Details. The location in the cube is within Contact:External:Law Firm Details table/block called [Overall Performance]

NVARCHAR2(100)

Contact:External:Law Firm Details

Preferred Vendor

Custom Field under Category Contact:External:Law Firm Details. The location in the cube is within Contact:External:Law Firm Details table/block called [Preferred Vendor]

VARCHAR2(9)

Contact:External:Law Firm Details

Woman Owned Firm

Custom Field under Category Contact:External:Law Firm Details. The location in the cube is within Contact:External:Law Firm Details table/block called [Woman Owned Firm]

NVARCHAR2(4000)

Invoice Details

Check #

Custom Field under Category Invoice Details. The location in the cube is within Invoice Details table/block called [Check #]

DATE

Invoice Details

Check Date

Custom Field under Category Invoice Details. The location in the cube is within Invoice Details table/block called [Check Date]

NVARCHAR2(4000)

Invoice Details

PO Number

Custom Field under Category Invoice Details. The location in the cube is within Invoice Details table/block called [PO Number]

DATE

Invoice Details

Posted Date

Custom Field under Category Invoice Details. The location in the cube is within Invoice Details table/block called [Posted Date]

NUMBER

Invoice Details

Total Amount on Check

Custom Field under Category Invoice Details. The location in the cube is within Invoice Details table/block called [Total Amount on Check]

VARCHAR2(9)

Matter Details

Add Invoice Handler

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Add Invoice Handler]

VARCHAR2(9)

Matter Details

Additional Stops?

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Additional Stops?]

DATE

Matter Details

Archive Retention Date

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Archive Retention Date]

NVARCHAR2(100)

Matter Details

Canadian Provice

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Canadian Provice]

NVARCHAR2(4000)

Matter Details

City

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [City]

DATE

Matter Details

Closed On

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Closed On]

NVARCHAR2(100)

Matter Details

Country

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Country]

NVARCHAR2(100)

Matter Details

Jurisdiction

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Jurisdiction]

VARCHAR2(4000)

Matter Details

Matter Description

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Matter Description]

NVARCHAR2(4000)

Matter Details

Matter Sub-Type

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Matter Sub-Type]

NVARCHAR2(4000)

Matter Details

Matter Type

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Matter Type]

DATE

Matter Details

Opened On

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Opened On]

NVARCHAR2(100)

Matter Details

Priority

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Priority]

NVARCHAR2(100)

Matter Details

Region

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Region]

DATE

Matter Details

Reopened Date

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Reopened Date]

NVARCHAR2(4000)

Matter Details

Short Name

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Short Name]

NVARCHAR2(100)

Matter Details

Significant?

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Significant?]

NVARCHAR2(100)

Matter Details

State

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [State]

VARCHAR2(9)

Matter Details

Use Custom Template?

Custom Field under Category Matter Details. The location in the cube is within Matter Details table/block called [Use Custom Template?]

NVARCHAR2(100)

Matter:Administrative Details

Matter Sub-Type

Custom Field under Category Matter:Administrative Details. The location in the cube is within Matter:Administrative Details table/block called [Matter Sub-Type *9]

NVARCHAR2(4000)

Matter:Compliance/Regulatory Details

Agency Charge Number

Custom Field under Category Matter:Compliance/Regulatory Details. The location in the cube is within Matter:Compliance/Regulatory Details table/block called [Agency Charge Number]

VARCHAR2(4000)

Matter:Compliance/Regulatory Details

Corrective Action

Custom Field under Category Matter:Compliance/Regulatory Details. The location in the cube is within Matter:Compliance/Regulatory Details table/block called [Corrective Action]

DATE

Matter:Compliance/Regulatory Details

Incident Date

Custom Field under Category Matter:Compliance/Regulatory Details. The location in the cube is within Matter:Compliance/Regulatory Details table/block called [Incident Date *2]

NVARCHAR2(100)

Matter:Compliance/Regulatory Details

Matter Sub-Type

Custom Field under Category Matter:Compliance/Regulatory Details. The location in the cube is within Matter:Compliance/Regulatory Details table/block called [Matter Sub-Type0]

VARCHAR2(9)

Matter:Contract/Agreement Details

Check Box01

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Check Box01]

VARCHAR2(9)

Matter:Contract/Agreement Details

Check Box02

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Check Box02]

NVARCHAR2(100)

Matter:Contract/Agreement Details

Contract Phase

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Contract Phase]

DATE

Matter:Contract/Agreement Details

Date Signed

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Date Signed]

DATE

Matter:Contract/Agreement Details

Date01

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Date01]

DATE

Matter:Contract/Agreement Details

Date02

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Date02]

DATE

Matter:Contract/Agreement Details

Date03

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Date03]

DATE

Matter:Contract/Agreement Details

Date04

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Date04]

DATE

Matter:Contract/Agreement Details

Effective Date

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Effective Date]

NUMBER

Matter:Contract/Agreement Details

Estimated Value

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Estimated Value]

DATE

Matter:Contract/Agreement Details

Expiration Date

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Expiration Date]

NVARCHAR2(100)

Matter:Contract/Agreement Details

Matter Sub-Type

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Matter Sub-Type *2]

VARCHAR2(4000)

Matter:Contract/Agreement Details

Memo Text01

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Memo Text01]

NUMBER

Matter:Contract/Agreement Details

Number01

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Number01]

NUMBER

Matter:Contract/Agreement Details

Number02

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Number02]

NUMBER

Matter:Contract/Agreement Details

Number03

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Number03]

NUMBER

Matter:Contract/Agreement Details

Number04

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Number04]

NVARCHAR2(100)

Matter:Contract/Agreement Details

Outcome

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Outcome]

VARCHAR2(4000)

Matter:Contract/Agreement Details

Outcome Notes

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Outcome Notes]

DATE

Matter:Contract/Agreement Details

Renewal Date

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Renewal Date]

VARCHAR2(9)

Matter:Contract/Agreement Details

Statement of Work?

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Statement of Work?]

DATE

Matter:Contract/Agreement Details

Termination Date

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Termination Date]

NVARCHAR2(4000)

Matter:Contract/Agreement Details

Text01

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Text01]

NVARCHAR2(4000)

Matter:Contract/Agreement Details

Text02

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Text02]

NVARCHAR2(4000)

Matter:Contract/Agreement Details

Text03

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Text03]

NVARCHAR2(4000)

Matter:Contract/Agreement Details

Text04

Custom Field under Category Matter:Contract/Agreement Details. The location in the cube is within Matter:Contract/Agreement Details table/block called [Text04]

VARCHAR2(9)

Matter:Corporate Details

Check Box01

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Check Box01 *4]

VARCHAR2(9)

Matter:Corporate Details

Check Box02

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Check Box02 *4]

DATE

Matter:Corporate Details

Date01

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Date01 *4]

DATE

Matter:Corporate Details

Date02

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Date02 *4]

DATE

Matter:Corporate Details

Date03

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Date03 *4]

DATE

Matter:Corporate Details

Date04

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Date04 *4]

NVARCHAR2(100)

Matter:Corporate Details

Matter Sub-Type

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Matter Sub-Type *5]

VARCHAR2(4000)

Matter:Corporate Details

Memo Text01

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Memo Text01 *4]

NUMBER

Matter:Corporate Details

Number01

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Number01 *4]

NUMBER

Matter:Corporate Details

Number02

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Number02 *4]

NUMBER

Matter:Corporate Details

Number03

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Number03 *4]

NUMBER

Matter:Corporate Details

Number04

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Number04 *4]

NVARCHAR2(4000)

Matter:Corporate Details

Physical MailingAddress

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Physical MailingAddress]

NVARCHAR2(4000)

Matter:Corporate Details

Registered Address

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Registered Address]

NVARCHAR2(100)

Matter:Corporate Details

State of Incorporation

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [State of Incorporation]

NVARCHAR2(4000)

Matter:Corporate Details

Text01

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Text01 *4]

NVARCHAR2(4000)

Matter:Corporate Details

Text02

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Text02 *4]

NVARCHAR2(4000)

Matter:Corporate Details

Text03

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Text03 *4]

NVARCHAR2(4000)

Matter:Corporate Details

Text04

Custom Field under Category Matter:Corporate Details. The location in the cube is within Matter:Corporate Details table/block called [Text04 *4]

NVARCHAR2(4000)

Matter:Employment/Labor Details

Agency Charge Number

Custom Field under Category Matter:Employment/Labor Details. The location in the cube is within Matter:Employment/Labor Details table/block called [Agency Charge Number *2]

VARCHAR2(4000)

Matter:Employment/Labor Details

Claim Type

Custom Field under Category Matter:Employment/Labor Details. The location in the cube is within Matter:Employment/Labor Details table/block called [Claim Type]

DATE

Matter:Employment/Labor Details

Incident Date

Custom Field under Category Matter:Employment/Labor Details. The location in the cube is within Matter:Employment/Labor Details table/block called [Incident Date *3]

NVARCHAR2(100)

Matter:Employment/Labor Details

Matter Sub-Type

Custom Field under Category Matter:Employment/Labor Details. The location in the cube is within Matter:Employment/Labor Details table/block called [Matter Sub-Type2]

VARCHAR2(4000)

Matter:Employment/Labor Details

Outcome

Custom Field under Category Matter:Employment/Labor Details. The location in the cube is within Matter:Employment/Labor Details table/block called [Outcome *5]

DATE

Matter:Environmental Health and Safety Details

Audit Date

Custom Field under Category Matter:Environmental Health and Safety Details. The location in the cube is within Matter:Environmental Health and Safety Details table/block called [Audit Date]

VARCHAR2(4000)

Matter:Environmental Health and Safety Details

Incident Facts

Custom Field under Category Matter:Environmental Health and Safety Details. The location in the cube is within Matter:Environmental Health and Safety Details table/block called [Incident Facts]

NVARCHAR2(4000)

Matter:Environmental Health and Safety Details

Incident Location

Custom Field under Category Matter:Environmental Health and Safety Details. The location in the cube is within Matter:Environmental Health and Safety Details table/block called [Incident Location]

NVARCHAR2(100)

Matter:Environmental Health and Safety Details

Matter Sub-Type

Custom Field under Category Matter:Environmental Health and Safety Details. The location in the cube is within Matter:Environmental Health and Safety Details table/block called [Matter Sub-Type3]

NVARCHAR2(100)

Matter:General Legal Details

Matter Sub-Type

Custom Field under Category Matter:General Legal Details. The location in the cube is within Matter:General Legal Details table/block called [Matter Sub-Type *7]

VARCHAR2(9)

Matter:General Liability/Claim Details

Check Box01

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Check Box01 *2]

VARCHAR2(9)

Matter:General Liability/Claim Details

Check Box02

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Check Box02 *2]

NVARCHAR2(4000)

Matter:General Liability/Claim Details

Claim Number

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Claim Number]

DATE

Matter:General Liability/Claim Details

Date01

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Date01 *2]

DATE

Matter:General Liability/Claim Details

Date02

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Date02 *2]

DATE

Matter:General Liability/Claim Details

Date03

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Date03 *2]

DATE

Matter:General Liability/Claim Details

Date04

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Date04 *2]

DATE

Matter:General Liability/Claim Details

Incident Date

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Incident Date]

NVARCHAR2(100)

Matter:General Liability/Claim Details

Matter Sub-Type

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Matter Sub-Type *3]

VARCHAR2(4000)

Matter:General Liability/Claim Details

Memo Text01

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Memo Text01 *2]

NUMBER

Matter:General Liability/Claim Details

Number01

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Number01 *2]

NUMBER

Matter:General Liability/Claim Details

Number02

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Number02 *2]

NUMBER

Matter:General Liability/Claim Details

Number03

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Number03 *2]

NUMBER

Matter:General Liability/Claim Details

Number04

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Number04 *2]

NVARCHAR2(100)

Matter:General Liability/Claim Details

Outcome

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Outcome *2]

VARCHAR2(4000)

Matter:General Liability/Claim Details

Outcome Notes

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Outcome Notes *2]

NUMBER

Matter:General Liability/Claim Details

Payment Amount

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Payment Amount]

NUMBER

Matter:General Liability/Claim Details

Recovery Amount

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Recovery Amount]

NVARCHAR2(100)

Matter:General Liability/Claim Details

Recovery/Payment

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Recovery/Payment]

NVARCHAR2(4000)

Matter:General Liability/Claim Details

Text01

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Text01 *2]

NVARCHAR2(4000)

Matter:General Liability/Claim Details

Text02

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Text02 *2]

NVARCHAR2(4000)

Matter:General Liability/Claim Details

Text03

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Text03 *2]

NVARCHAR2(4000)

Matter:General Liability/Claim Details

Text04

Custom Field under Category Matter:General Liability/Claim Details. The location in the cube is within Matter:General Liability/Claim Details table/block called [Text04 *2]

DATE

Matter:Intellectual Property Details

Application Date

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Application Date]

NVARCHAR2(4000)

Matter:Intellectual Property Details

Application/Serial No.

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Application/Serial No.]

VARCHAR2(9)

Matter:Intellectual Property Details

Check Box01

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Check Box01 *3]

VARCHAR2(9)

Matter:Intellectual Property Details

Check Box02

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Check Box02 *3]

NVARCHAR2(100)

Matter:Intellectual Property Details

Country

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Country *2]

DATE

Matter:Intellectual Property Details

Date01

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Date01 *3]

DATE

Matter:Intellectual Property Details

Date02

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Date02 *3]

DATE

Matter:Intellectual Property Details

Date03

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Date03 *3]

DATE

Matter:Intellectual Property Details

Date04

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Date04 *3]

NVARCHAR2(100)

Matter:Intellectual Property Details

Direction

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Direction]

DATE

Matter:Intellectual Property Details

Expiration Date

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Expiration Date *2]

VARCHAR2(9)

Matter:Intellectual Property Details

Infringement?

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Infringement?]

NVARCHAR2(100)

Matter:Intellectual Property Details

Matter Sub-Type

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Matter Sub-Type *4]

VARCHAR2(4000)

Matter:Intellectual Property Details

Memo Text01

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Memo Text01 *3]

DATE

Matter:Intellectual Property Details

Next Renewal

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Next Renewal]

NUMBER

Matter:Intellectual Property Details

Number01

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Number01 *3]

NUMBER

Matter:Intellectual Property Details

Number02

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Number02 *3]

NUMBER

Matter:Intellectual Property Details

Number03

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Number03 *3]

NUMBER

Matter:Intellectual Property Details

Number04

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Number04 *3]

VARCHAR2(4000)

Matter:Intellectual Property Details

Outcome

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Outcome *3]

NVARCHAR2(4000)

Matter:Intellectual Property Details

Patent/Registration No.

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Patent/Registration No.]

DATE

Matter:Intellectual Property Details

Registration Date

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Registration Date]

NVARCHAR2(4000)

Matter:Intellectual Property Details

Text01

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Text01 *3]

NVARCHAR2(4000)

Matter:Intellectual Property Details

Text02

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Text02 *3]

NVARCHAR2(4000)

Matter:Intellectual Property Details

Text03

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Text03 *3]

NVARCHAR2(4000)

Matter:Intellectual Property Details

Text04

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Text04 *3]

NVARCHAR2(4000)

Matter:Intellectual Property Details

Title/Mark Name

Custom Field under Category Matter:Intellectual Property Details. The location in the cube is within Matter:Intellectual Property Details table/block called [Title/Mark Name]

DATE

Matter:Litigation/Claims Details

Answer Due

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Answer Due]

DATE

Matter:Litigation/Claims Details

Answered

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Answered]

VARCHAR2(9)

Matter:Litigation/Claims Details

Appealed?

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Appealed?]

NVARCHAR2(100)

Matter:Litigation/Claims Details

Appellate Outcome

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Appellate Outcome]

VARCHAR2(4000)

Matter:Litigation/Claims Details

Appellate Outcome Notes

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Appellate Outcome Notes]

VARCHAR2(4000)

Matter:Litigation/Claims Details

Case Caption

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Case Caption]

VARCHAR2(9)

Matter:Litigation/Claims Details

Check Box01

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Check Box01 *5]

VARCHAR2(9)

Matter:Litigation/Claims Details

Check Box02

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Check Box02 *5]

VARCHAR2(9)

Matter:Litigation/Claims Details

Class Action?

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Class Action?]

VARCHAR2(9)

Matter:Litigation/Claims Details

Class Certified?

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Class Certified?]

DATE

Matter:Litigation/Claims Details

Class Date From

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Class Date From]

DATE

Matter:Litigation/Claims Details

Class Date to

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Class Date to]

DATE

Matter:Litigation/Claims Details

Date Served

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Date Served]

DATE

Matter:Litigation/Claims Details

Date01

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Date01 *5]

DATE

Matter:Litigation/Claims Details

Date02

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Date02 *5]

DATE

Matter:Litigation/Claims Details

Date03

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Date03 *5]

DATE

Matter:Litigation/Claims Details

Date04

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Date04 *5]

DATE

Matter:Litigation/Claims Details

Discovery Due

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Discovery Due]

DATE

Matter:Litigation/Claims Details

Dispositive Motion Date

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Dispositive Motion Date]

NVARCHAR2(4000)

Matter:Litigation/Claims Details

Docket Number

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Docket Number]

DATE

Matter:Litigation/Claims Details

Filing Due

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Filing Due]

DATE

Matter:Litigation/Claims Details

Hearing Date

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Hearing Date]

NVARCHAR2(100)

Matter:Litigation/Claims Details

Litigation Phase

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Litigation Phase]

DATE

Matter:Litigation/Claims Details

Loss Date

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Loss Date]

NVARCHAR2(100)

Matter:Litigation/Claims Details

Matter Sub-Type

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Matter Sub-Type *6]

VARCHAR2(4000)

Matter:Litigation/Claims Details

Memo Text01

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Memo Text01 *5]

NUMBER

Matter:Litigation/Claims Details

Number01

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Number01 *5]

NUMBER

Matter:Litigation/Claims Details

Number02

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Number02 *5]

NUMBER

Matter:Litigation/Claims Details

Number03

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Number03 *5]

NUMBER

Matter:Litigation/Claims Details

Number04

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Number04 *5]

NVARCHAR2(4000)

Matter:Litigation/Claims Details

Originating Matter Type

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Originating Matter Type]

NVARCHAR2(4000)

Matter:Litigation/Claims Details

Originating Sub Matter Type

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Originating Sub Matter Type]

NVARCHAR2(100)

Matter:Litigation/Claims Details

Our Role

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Our Role]

NVARCHAR2(100)

Matter:Litigation/Claims Details

Outcome

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Outcome *4]

VARCHAR2(4000)

Matter:Litigation/Claims Details

Outcome Notes

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Outcome Notes *3]

NUMBER

Matter:Litigation/Claims Details

Payment Amount

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Payment Amount *2]

NUMBER

Matter:Litigation/Claims Details

Recovery Amount

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Recovery Amount *2]

NVARCHAR2(100)

Matter:Litigation/Claims Details

Recovery/Payment

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Recovery/Payment *2]

NVARCHAR2(4000)

Matter:Litigation/Claims Details

Text01

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Text01 *5]

NVARCHAR2(4000)

Matter:Litigation/Claims Details

Text02

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Text02 *5]

NVARCHAR2(4000)

Matter:Litigation/Claims Details

Text03

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Text03 *5]

NVARCHAR2(4000)

Matter:Litigation/Claims Details

Text04

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Text04 *5]

DATE

Matter:Litigation/Claims Details

Trial Date

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Trial Date]

DATE

Matter:Litigation/Claims Details

Trial Motions Due

Custom Field under Category Matter:Litigation/Claims Details. The location in the cube is within Matter:Litigation/Claims Details table/block called [Trial Motions Due]

NVARCHAR2(100)

Matter:Mergers & Acquisitions Details

Matter Sub-Type

Custom Field under Category Matter:Mergers & Acquisitions Details. The location in the cube is within Matter:Mergers & Acquisitions Details table/block called [Matter Sub-Type4]

NVARCHAR2(100)

Matter:Real Estate Details

Matter Sub-Type

Custom Field under Category Matter:Real Estate Details. The location in the cube is within Matter:Real Estate Details table/block called [Matter Sub-Type1]

VARCHAR2(4000)

Matter:Real Estate Details

Property Description

Custom Field under Category Matter:Real Estate Details. The location in the cube is within Matter:Real Estate Details table/block called [Property Description]

NVARCHAR2(4000)

Matter:Real Estate Details

Property Name

Custom Field under Category Matter:Real Estate Details. The location in the cube is within Matter:Real Estate Details table/block called [Property Name]

NVARCHAR2(100)

Matter:Real Estate Details

Property Type

Custom Field under Category Matter:Real Estate Details. The location in the cube is within Matter:Real Estate Details table/block called [Property Type]

DATE

Matter:Subpoena Details

Date Due

Custom Field under Category Matter:Subpoena Details. The location in the cube is within Matter:Subpoena Details table/block called [Date Due]

DATE

Matter:Subpoena Details

Date Received

Custom Field under Category Matter:Subpoena Details. The location in the cube is within Matter:Subpoena Details table/block called [Date Received]

NVARCHAR2(4000)

Matter:Subpoena Details

Docket Number

Custom Field under Category Matter:Subpoena Details. The location in the cube is within Matter:Subpoena Details table/block called [Docket Number *2]

NVARCHAR2(100)

Matter:Subpoena Details

Matter Sub-Type

Custom Field under Category Matter:Subpoena Details. The location in the cube is within Matter:Subpoena Details table/block called [Matter Sub-Type *8]

DATE

Matter|Involved Party Details

End Date

Custom Field under Category Matter|Involved Party Details. The location in the cube is within Matter|Involved Party Details table/block called [End Date]

DATE

Matter|Involved Party Details

Start Date

Custom Field under Category Matter|Involved Party Details. The location in the cube is within Matter|Involved Party Details table/block called [Start Date]

 

 

  • Was this article helpful?