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. Account Total Budget Allocated includes Allocated Internal Fee and Allocated Internal Expense.

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.

NUMBER

Account

Account Vendor Contact Primary Key

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

NUMBER

Account Budget And Spend

Account Vendor Contact Primary Key

Account Vendor Contact Primary Key

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

 

Appointment Object

Table Name in Database Column Name in Database Data Type Friendly Table Name in eCube Friendly Column Name in eCube Field Hint
SI$_APPOINTMENT APPT_AREA_ITEM_NAME NVARCHAR2(50) Appointment Appointment Area Item Name Geographical area where the appointment will take place (for example, Orange County, and Chicago).
SI$_APPOINTMENT APPT_CREATED_BY NVARCHAR2(353) Appointment Appointment Created By     User who created the appointment.
SI$_APPOINTMENT APPT_CREATED_ON DATE Appointment Appointment Created On Date and time the appointment was created.
SI$_APPOINTMENT APPT_CREATED_ON_BEHALF_OF NVARCHAR2(353) Appointment Appointment 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.
SI$_APPOINTMENT APPT_END_ON DATE Appointment Appointment End on Date and time when the appointment ends.
SI$_APPOINTMENT APPT_IS_ALL_DAY VARCHAR2(3) Appointment Appointment Is All Day Indicates whether the appointment is scheduled for the entire day. 0 - not all day 1 - all day
SI$_APPOINTMENT APPT_LOCATION NVARCHAR2(250) Appointment Appointment Location Location where the appointment takes place (such as Corporate Headquarters or Conference Room 3rd Floor).
SI$_APPOINTMENT APPT_MODIFIED_BY NVARCHAR2(353) Appointment Appointment Modified By User who most recently modified the appointment.
SI$_APPOINTMENT APPT_MODIFIED_ON DATE Appointment Appointment Modified On Date and time the appointment was most recently modified.
SI$_APPOINTMENT APPT_PRIMARY_KEY NUMBER Appointment Appointment Primary Key Unique ID for the appointment record.
SI$_APPOINTMENT APPT_START_ON DATE Appointment Appointment Start On Date and time when the appointment begins.
SI$_APPOINTMENT APPT_SUBJECT NVARCHAR2(250) Appointment Appointment Subject Description of the appointment (e.g. Meeting with client).
SI$_APPOINTMENT APPT_DEFAULT_CATEGORY NVARCHAR2(50) Appointment Appointment Default Category The default category for the appointment.
SI$_APPOINTMENT APPT_DEFAULT_CATEGORY_FULL NVARCHAR2(2000) Appointment Appointment Default Catgory Full The full name of the default appointment category including the parent's name (for example, Appointment:Internal:Copy).
SI$_APPOINTMENT APPT_NOTE VARCHAR2(4000) Appointment Appointment Note Links to the table that contains the text entered into the Notes field of the record.
SI$_APPOINTMENT APPT_SECURITY VARCHAR2(7) Appointment Appointment Security The security of the record.
SI$_APPOINTMENT APPT_WORKFLOW_CURRENT_STATUS VARCHAR2(9) Appointment Appointment Workflow Current Status Workflow Current Status.
SI$_APPOINTMENT APPT_WORKFLOW_CURRENT_ACTION NVARCHAR2(50) Appointment Appointment Workflow Current Action Workflow Current Action.
SI$_APPOINTMENT APPT_WKFL_CURRENT_APPROVER NVARCHAR2(353) Appointment Appointment Workflow Current Approver Workflow Current Approver.
SI$_APPOINTMENT APPT_WKFL_LAST_PERFORMER NVARCHAR2(353) Appointment Appointment Workflow Last Performer Workflow Last Performer.
SI$_APPOINTMENT APPT_WKFL_MULTIPLE_APPROVERS VARCHAR2(3) Appointment Appointment Workflow Multiple Approvers Workflow has multiple approver? Yes/No.
SI$_APPOINTMENT_CATEGORIES APPT_CATEGORY NVARCHAR2(50) Appointment Categories Appointment Category Each category associated with the appointment.
SI$_APPOINTMENT_CATEGORIES APPT_CATEGORY_FULL NVARCHAR2(2000) Appointment Categories Appointment Category Full The full name of each appointment category including the parent's name (for example, Appointment:Internal:Copy).
SI$_APPOINTMENT_CATEGORIES APPT_CATEGORY_IS_LEAF VARCHAR2(3) Appointment Categories Appointment Category Is Leaf The identifier if the category is the leaf (lowest level selected) or not.
 
SI$_APPOINTMENT_ATTENDEES APPT_BEGIN DATE Appointment Attendees Appointment Begin Start date and time when the user is scheduled to attend.
SI$_APPOINTMENT_ATTENDEES APPT_END DATE Appointment Attendees Appointment End End date and time until which the user is scheduled to attend.
SI$_APPOINTMENT_ATTENDEES APPT_ATTENDEE NVARCHAR2(353) Appointment Attendees Appointment Attendeee User who is added as an attendee to the appointment record.
SI$_APPOINTMENT_ATTENDEES APPT_ATTENDEE_JOB_TITLE NVARCHAR2(250) Appointment Attendees Appointment Attendeee Job Title User's job title who is added as an attendee to the appointment record.
SI$_APPOINTMENT_ATTENDEES APPT_ATTENDEE_SUPERVISOR NVARCHAR2(353) Appointment Attendees Appointment Attendeee Supervisor User's supervisor who is added as an attendee to the appointment record.
SI$_APPOINTMENT_ATTENDEES APPT_ATTENDENCE_TYPE VARCHAR2(15) Appointment Attendees Appointment Attendeee Type Indicates the attendance status of the attendee: 0 - Will Attend (WILL_ATTEND) 1 - Tentative (TENTATIVE) 2 - Will Not Attend (WILL_NOT_ATTEND) 3 - Unknown
 
SI$_APPOINTMENT_RESOURCES APPT_RESOURCE_END_ON DATE Appointment Resources Appointment Resource End On End date and time until which the user is scheduled to attend.
SI$_APPOINTMENT_RESOURCES APPT_RESOURCE_NAME NVARCHAR2(50) Appointment Resources Appointment Resource Name Appointment Resources - Appointment Resource Name
SI$_APPOINTMENT_RESOURCES APPT_RESOURCE_START_ON DATE Appointment Resources Appointment Resource Start On Appointment Resources - Appointment Resource Start On

 

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(353) Contact Contact Supervisor Contact Supervisor

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(3) Contact Rate History Contact Current Converted Code The current code for the contact
NUMBER Contact Rate History Contact Current Converted Rate The current converted rate for the contact

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)

NUMBER Invoice Account Vendor Contact Primary Key The contact primary key record of the vendor associated with the invoice

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.

NUMBER Invoice Line Item Invoice Line Item Timekeeper Contact Primary Key The contact primary key who performed the service or provided the goods. Links to the specific information about the contact object.

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 Line Item Adjustments Invoice Line Item Adjustment Calculated Total The difference between the total before the adjustment and the total after the adjustment.

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?

NVARCHAR2(6) Invoice <Object Title> Contact Invoice <Object Title> Currency Code Invoice Vendor Currency Code
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Currency Name Invoice Vendor Currency Name
NVARCHAR2(6) Invoice <Object Title> Contact Invoice <Object Title> Currency Symbol Invoice Vendor Currency Symbol
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Default Category
The default Invoice Vendor category (for example, External)
NVARCHAR2(4000) Invoice <Object Title> Contact Invoice <Object Title> Default Category Full The default Invoice Vendor category along with Parent(Example, "External" when only parent category exists; can be expanded to "External:Attorney" when child category exists)
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Default City Invoice Vendor Default City
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Default Country Invoice Vendor Default Country
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Default County Invoice Vendor Default County
NVARCHAR2(500) Invoice <Object Title> Contact Invoice <Object Title> Default Email Invoice Vendor Default Email
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Default Fax Invoice Vendor Default Fax
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Default Phone Invoice Vendor Default Phone
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Default Postal Code Invoice Vendor Default Postal Code
NVARCHAR2(100) Invoice <Object Title> Contact Invoice <Object Title> Default State Invoice Vendor Default State
NVARCHAR2(500) Invoice <Object Title> Contact Invoice <Object Title> Default Street Invoice Vendor Default Street
NVARCHAR2(706) Invoice <Object Title> Contact Invoice <Object Title> Full Name Invoice Vendor Full Name
NVARCHAR2(500) Invoice <Object Title> Contact Invoice <Object Title> Inet Address Invoice Vendor Default Inet Address

 

Project System Object

In the below table, 

XXXX indicates the unique code of the custom object.
<Object Title> indicates the object title of the custom object.

For example, if the unique code is MTR$ – and the Object Title is Matter, the Closed On field will be stated as follow:
 

Table Name in Database Column Name in Database Data Type Friendly Table Name in eCube Friendly Column Name in eCube Field Hint
SI$_PROJECT_MTR$   MTR$_CREATED_BY NVARCHAR2(706) Matter   Matter Created By User who created the project.

 

Table Name in Database Column Name in Database Data Type Friendly Table Name in eCube Friendly Column Name in eCube Field Hint
SI$_PROJECT_XXXX XXXX_CLOSED_ON DATE <Object Title> <Object Title> Closed On Date the project status was changed to closed.
SI$_PROJECT_XXXX XXXX_CREATED_BY NVARCHAR2(706) <Object Title> <Object Title> Created By User who created the project.
SI$_PROJECT_XXXX XXXX_CREATED_ON DATE <Object Title> <Object Title> Created On Date the project record was created.
SI$_PROJECT_XXXX XXXX_CREATED_ON_BEHALF_OF NVARCHAR2(706) <Object Title> <Object Title> 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.
SI$_PROJECT_XXXX XXXX_CURRENT_PHASE NVARCHAR2(500) <Object Title> <Object Title> Current Phase The current phase of the project.
SI$_PROJECT_XXXX XXXX_DEFAULT_CATEGORY NVARCHAR2(100) <Object Title> <Object Title> Default Category The default category associated with the project.
SI$_PROJECT_XXXX XXXX_DEFAULT_CATEGORY_FULL NVARCHAR2(4000) <Object Title> <Object Title> Default Category Full The full name of the default matter category including the parent's name (for example, Project:Litigation:Contract).
SI$_PROJECT_XXXX XXXX_MAIN_ASSIGNEE_ASSIGN_ON DATE <Object Title> <Object Title> Main Assignee Assign On Date primary assignee was assigned to the matter
SI$_PROJECT_XXXX XXXX_MAIN_ASSIGNEE_NAME NVARCHAR2(706) <Object Title> <Object Title> Main Assignee Name Primary assignee's name.
SI$_PROJECT_XXXX XXXX_MAIN_ASSIGNEE_ROLE NVARCHAR2(100) <Object Title> <Object Title> Main Assignee Role Primary assignee's role.
SI$_PROJECT_XXXX XXXX_MODIFIED_BY NVARCHAR2(706) <Object Title> <Object Title> Modified By User who last modified the project.
SI$_PROJECT_XXXX XXXX_MODIFIED_ON DATE <Object Title> <Object Title> Modified On Date the record was last modified.
SI$_PROJECT_XXXX XXXX_NAME NVARCHAR2(500) <Object Title> <Object Title> Name The name of the record.
 
SI$_PROJECT_XXXX XXXX_NUMBER NVARCHAR2(100) <Object Title> <Object Title> Number The record number.
SI$_PROJECT_XXXX XXXX_OPENED_ON DATE <Object Title> <Object Title> Opened On Date the project was opened.
SI$_PROJECT_XXXX XXXX_PRIMARY_KEY NUMBER <Object Title> <Object Title> Primary Key The unique ID of the project record.
SI$_PROJECT_XXXX XXXX_RECENT_PROGRESS_DATE DATE <Object Title> <Object Title> Recent Progress Date Matter recent progress creation date
SI$_PROJECT_XXXX XXXX_RECENT_PROGRESS_NOTES VARCHAR2(4000) <Object Title> <Object Title> Recent Progress Notes Matter recent progress notes
SI$_PROJECT_XXXX XXXX_SECURITY VARCHAR2(7) <Object Title> <Object Title> Security The security of the record
SI$_PROJECT_XXXX XXXX_WORKFLOW_CURRENT_ACTION NVARCHAR2(100) <Object Title> <Object Title> Workflow Current Action Workflow Current Action
SI$_PROJECT_XXXX XXXX_WKFL_CURRENT_APPROVER NVARCHAR2(706) <Object Title> <Object Title> Workflow Current Approver Workflow Current Approver.
SI$_PROJECT_XXXX XXXX_WORKFLOW_CURRENT_STATUS VARCHAR2(9) <Object Title> <Object Title> Workflow Current Status Workflow Current Status.
SI$_PROJECT_XXXX XXXX_WKFL_LAST_PERFORMER NVARCHAR2(706) <Object Title> <Object Title> Workflow Last Performer Workflow Last Performer.
SI$_PROJECT_XXXX XXXX_WKFL_MULTIPLE_APPROVERS VARCHAR2(3) <Object Title> <Object Title> Workflow Multiple Approvers Workflow has multiple approver? Yes/No.
SI$_PROJECT_XXXX XXXX_MAIN_ASSIGNEE_USER_ID$$ NUMBER <Object Title> <Object Title> Main assignee user ID Object assigned main assignee User ID
SI$_PROJECT_XXXX XXXX_MAIN_ASSIGNEE_CONT_ID$$ NUMBER <Object Title>  <Object Title> Main assignee contact ID Object assigned main assignee Contact ID
SI$_PROJECT_XXXX_ASSIGNEES MTR$_ASSIGNEE_ASSIGNED_ON DATE <Object Title> Assignees <Object Title> Assignee Assigned On The assigned on date of the assignee.
SI$_PROJECT_XXXX_ASSIGNEES XXXX_ASSIGNEE_NAME NVARCHAR2(706) <Object Title> Assignees <Object Title>  Assignee Name Name of any assignee on that matter.
SI$_PROJECT_XXXX_ASSIGNEES XXXX_ASSIGNEE_ROLE NVARCHAR2(100) <Object Title> Assignees <Object Title> Assignee Role Role of a given matter assignee.
SI$_PROJECT_XXXX_ASSIGNEES XXXX_ASSIGNEE_STATUS VARCHAR2(8) <Object Title> Assignees <Object Title> Assignee Status The status of the assignee.
 
SI$_PROJECT_XXXX_ASSIGNEES XXXX_ASSIGNEE_UNASSIGNED_ON DATE <Object Title> Assignees <Object Title> Assignee Unassigned On The unassigned on date of the assignee.
SI$_PROJECT_XXXX_ASSIGNEES XXXX_ASSIGNEE_USER_ID$$ NUMBER <Object Title> Assignees <Object Title> User ID Object assigned User ID
SI$_PROJECT_XXXX_ASSIGNEES XXXX_ASSIGNEE_CONTACT_ID$$ NUMBER <Object Title> Assignees <Object Title> Contact ID Object assigned Contact ID
SI$_PROJECT_XXXX_CATEGORIES XXXX_CATEGORY
 
NVARCHAR2(100)
 
<Object Title> Categories <Object Title> Category Each category associated with the project.
SI$_PROJECT_XXXX_CATEGORIES XXXX_CATEGORY_FULL NVARCHAR2(4000) <Object Title> Categories <Object Title> Category Full The full name of each matter category including the parent's name (for example, Project:Litigation:Contract).
SI$_PROJECT_XXXX_CATEGORIES XXXX_CATEGORY_IS_LEAF VARCHAR2(3) <Object Title> Categories <Object Title> Category Is Leaf The identifier if the category is the leaf (lowest level selected) or not.
SI$_PROJECT_XXXX_PHASES XXXX_PHASE_DURATION NUMBER <Object Title> Phases <Object Title> Phase Duration                              The duration of the phase.
SI$_PROJECT_XXXX_PHASES XXXX_PHASE_NAME NVARCHAR2(500) <Object Title> Phases <Object Title> Phase Name The name of the phase.
SI$_PROJECT_XXXX_PHASES XXXX_PHASE_TRANSITION_BY NVARCHAR2(706) <Object Title> Phases <Object Title> Phase Transition By
The user who changed the project of this phase.
SI$_PROJECT_XXXX_PHASES XXXX_PHASE_TRANSITIONED_ON DATE <Object Title> Phases <Object Title> Phase Transitioned On The date on which the phase was selected for the project (or, the date that the phase was changed).


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

NVARCHAR2(353) Invoice Line Item <Object Title> Contact Invoice Line Item <Object Title> Home Office Profile

Invoice Line Item Timekeeper Home Office Profile

The value will be stored in the format:
 full_name (company_name)

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

 

Task Object

Table Name in Database Column Name in Database Data Type Friendly Table Name in eCube Friendly Column Name in eCube Field Hint
SI$_TASK TASK_ACTIVITY NVARCHAR2(50) Task Task Activity Activity item specified for the task.
SI$_TASK TASK_ACTUAL_HOURS NUMBER Task Task Actual Hours Actual length of time spent to complete the task (Hours or Minutes).
SI$_TASK TASK_COMPLETED_ON DATE Task Task Completed On Date and time the task was completed. Time-zone- independent.
SI$_TASK TASK_COMPLETED_PERCENT NUMBER Task Task Completed Percent Percentage of the task that is currently complete.
SI$_TASK TASK_CONTACT NVARCHAR2(353) Task Task Contact Contact who is associated to the task, e.g. for whom the task is performed.
SI$_TASK TASK_CREATED_BY NVARCHAR2(353) Task Task Created By User who created the task record.
SI$_TASK TASK_CREATED_ON DATE Task Task Created On Date and time the task record was created.
SI$_TASK TASK_CREATED_ON_BEHALF_OF NVARCHAR2(353) Task Task 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.
SI$_TASK TASK_DUE_ON DATE Task Task Due On The date when the task is due. Time zone Independent.  
SI$_TASK TASK_ESTIMATED_HOURS NUMBER Task Task Estimated Hours Amount of time (Hours/Minutes) needed to complete the task.
SI$_TASK TASK_MODIFIED_BY NVARCHAR2(353) Task Task Modified By User who most recently modified the task.
SI$_TASK TASK_MODIFIED_ON DATE Task Task Modified On Date and time the task was most recently modified.
SI$_TASK TASK_NOTE VARCHAR2(4000) Task Task Note Contains the text of the notes entered for the record. The TeamConnect user interface enforces a limitation of 20,000 characters for this field.
SI$_TASK TASK_POSTING_STATUS VARCHAR2(19) Task Task Posting Status This enumeration is based on TAccount. Specifies whether the task was posted or not: 1 - Not Posted 2 - Posted 3 - Failed 4 - Posted For Approval
SI$_TASK TASK_PRIMARY_KEY NUMBER Task Task Primary Key The unique ID of the task record.
SI$_TASK TASK_PRIORITY VARCHAR2(7) Task Task Priority Task priority. 1 - Highest 2 - High 3 - Normal 4 - Low 5 - Lowest
SI$_TASK TASK_RATE_AMOUNT NUMBER Task Task Rate Amount Rate the user charges (per hour) to perform the task.
SI$_TASK TASK_SHORT_DESCRIPTION NVARCHAR2(250) Task Task Subject Description of the task.
SI$_TASK TASK_START_ON DATE Task Task Start On Date when the task was started. Time zone Independent.
SI$_TASK TASK_TOTAL_AMOUNT NUMBER Task Task Total Amount Total amount of money spent to completing the task as the product of the rate (rateAmount ) and amount of time spent (actualHours ).
SI$_TASK TASK_WORK_STATUS VARCHAR2(11) Task Task Work Status The current status of the task. 1 - Not Started 2 - Started 3 - Completed
SI$_TASK TASK_DEFAULT_CATEGORY NVARCHAR2(50) Task Task Default Category Default task category.
SI$_TASK TASK_DEFAULT_CATEGORY_FULL NVARCHAR2(2000) Task Task Default Category Full The full name of the default category including the parent's name (for example, Task:Internal:Copy).
SI$_TASK TASK_CURR_ASSIGNEE_IS_INFORMED VARCHAR2(3) Task Task Current Assignee Is Informed Is assignee for task aware of task? 1 = Yes, 0 = No. Default is 0.
SI$_TASK TASK_CURRENT_ASSIGNEE NVARCHAR2(353) Task Task Current Assignee The user who is currently assigned to the task.
SI$_TASK TASK_FORWARDED_BY NVARCHAR2(353) Task Task Forwarded By The user who forwarded the task to the current assignee.
SI$_TASK TASK_SECURITY VARCHAR2(7) Task Task Security The security of the record.
SI$_TASK TASK_WORKFLOW_CURRENT_STATUS VARCHAR2(9) Task Task Workflow Current Status Workflow Current Status.
SI$_TASK TASK_WORKFLOW_CURRENT_ACTION NVARCHAR2(50) Task Task Workflow Current Action Workflow Current Action.
SI$_TASK TASK_WKFL_CURRENT_APPROVER NVARCHAR2(353) Task Task Workflow Current Approver Workflow Current Approver.
SI$_TASK TASK_WKFL_LAST_PERFORMER NVARCHAR2(353) Task Task Workflow Last Performer Workflow Last Performer.
SI$_TASK TASK_WKFL_MULTIPLE_APPROVERS NVARCHAR2(3) Task Task Workflow Multiple Approvers Workflow has multiple approver? Yes/No.
SI$_TASK TASK_ASSIGNEE_JOB_TITLE NVARCHAR2(250) Task Task Assigneee Job Title Task Assignee Job Title
SI$_TASK TASK_ASSIGNEE_SUPERVISOR NVARCHAR2(353) Task Task Assignee Supervisor Task Assignee Supervisor
SI$_TASK TASK_DAYS_LATE NUMBER Task Task Days Late Days delayed for completing Task
SI$_TASK TASK_TIMELINESS VARCHAR2(7) Task Task Timeliness Task Timeliness Status:Pending,on time,early,late,overdue
SI$_TASK_CATEGORIES TASK_CATEGORY NVARCHAR2(50) Task Categories Task Category Each category associated with the task.
SI$_TASK_CATEGORIES TASK_CATEGORY_FULL NVARCHAR2(2000) Task Categories Task Category Full The full name of each task category including the parent's name (for example, Task:Internal:Copy).
SI$_TASK_CATEGORIES TASK_CATEGORY_IS_LEAF VARCHAR2(3) Task Categories Task Category Is Full The identifier if the category is the leaf (lowest level selected) or not.
SI$_TASK_ASSIGNEES TASK_ASSIGNEE NVARCHAR2(353) Task Assignees Task Assignee The user assigned to the task. Links to specific information about the user account.
SI$_TASK_ASSIGNEES TASK_ASSIGNEE_IS_INFORMED VARCHAR2(3) Task Assignees Task Assignee Is Informed Currently not used.
SI$_TASK_ASSIGNEES TASK_ASSIGNEE_JOB_TITLE NVARCHAR2(250) Task Assignees Task Assignee Job Title Task Assignee Job Title
SI$_TASK_ASSIGNEES TASK_ASSIGNEE_SUPERVISOR NVARCHAR2(353) Task Assignees Task Assignee Supervisor Task Assignee Supervisor

 

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.

Date Matter Matter Recent progress creation date Matter Recent progress creation date.
NVARCAHR2(2000) Matter Matter recent progress notes
 
Matter recent progress notes.

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