eCube Data Dictionary for TeamConnect Essentials

Last updated
Save as PDF

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]