eCube Data Dictionary for TeamConnect Enterprise

Last updated
Save as PDF

What is a Data Dictionary?

This data dictionary defines the following fields:

Table and Column names in the database
Data Types
Friendly field names for the Tables and Columns in the eCube
Field hints.

These fields are used to pull information from the system to create and manage reports.

Note:

These objects are not available for reporting - Expenses, History, Documents.
This page contains only tables and fields contained in the starter ecube.

How to generate Data Dictionary Report?

You can generate a dynamic data dictionary from TCBI which will contain all custom tables and fields in your data. Follow the below instructions to create a data dictiontionary report:

Open the Reports tab in TeamConnect.
Create a new widget/report and click Select Data.
Add the following data dictionary fields from Zz Data Dictionary:
- Table Friendly Name In ECube
- Field Friendly Name In ECube
- Field Description
- Field Calculation
Click Create button.

Account System Object

Table Name in Database	Column Name in Database	Data Type	Friendly Table Name in eCube	Friendly column Name in eCube	Field Hint
SI$_ACCOUNT	ACCT_BUDGET_AVAILABLE	NUMBER	Account	Account Budget Available	Account balance, which results from the following equation: allocated - used = available
SI$_ACCOUNT	ACCT_DEFAULT_CATEGORY	NVARCHAR2(100)	Account	Account Default Category	The default category for the account.
SI$_ACCOUNT	ACCT_DEFAULT_CATEGORY_FULL	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).
SI$_ACCOUNT	ACCT_NAME	NVARCHAR2(500)	Account	Account Name	Name used to describe the account.
SI$_ACCOUNT	ACCT_NOTE	VARCHAR2(4000)	Account	Account Note	Links to the table that contains the text entered into the Notes field of the record.
SI$_ACCOUNT	ACCT_PERIOD_END_ON	DATE	Account	Account Period End On	Specifies the date after which transactions cannot be posted to the account.
SI$_ACCOUNT	ACCT_PERIOD_START_ON	DATE	Account	Account Period Start On	Specifies the start date from which transactions can be posted to the account.
SI$_ACCOUNT	ACCT_PRIMARY_KEY	NUMBER	Account	Account Primary Key	The unique ID of the account record.
SI$_ACCOUNT	ACCT_TOTAL_ACCRUAL	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.
SI$_ACCOUNT	ACCT_TOTAL_ALLOCATED	NUMBER	Account	Account Total Allocated	Total amount of money allocated to the account through deposits or automatic transfers. Account Total Allocated includes Allocated Internal Fees and Allocated Internal Expenses.
SI$_ACCOUNT	ACCT_TOTAL_USED	NUMBER	Account	Account Total Used	Total amount of money used through transfers, withdrawals, and posted transactions.
SI$_ACCOUNT	ACCT_VENDOR	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.
SI$_ACCOUNT	ACCT_VENDOR_CONT_PRIMARY_KEY	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.
SI$_ACCOUNT_BUDGET_SPEND	ACCT_VENDOR_CONT_PRIMARY_KEY	NUMBER	Account Budget And Spend	Account Vendor Contact Primary Key	Account Vendor Contact Primary Key
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_CREATED_BY	NVARCHAR2(706)	Account Budget And Spend	Account Created By	User who created the account. Links to specific information about the user account.
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_CREATED_ON	DATE	Account Budget And Spend	Account Created On	Date and time the account was created.
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_CREATED_ON_BEHALF_OF	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.
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_FISCAL_START_MONTH	VARCHAR2(2)	Account Budget And Spend	Account Fiscal Start Month	First month of the Fiscal Year associated with the Account
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_FISCAL_YEAR	NUMBER	Account Budget And Spend	Account Fiscal Year	The Fiscal Year associated with the Account
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_MODIFIED_BY	NVARCHAR2(706)	Account Budget And Spend	Account Modified By	User who most recently modified the account. Links to specific information about the user account.
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_MODIFIED_ON	DATE	Account Budget And Spend	Account Modified On	Date and time the account was most recently modified.
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_MONTH_NUM	NUMBER	Account Budget And Spend	Account Month Num	The numeric month for the account
SI$_ACCOUNT_BUDGET_SPEND	ACCOUNT_NAME	NVARCHAR2(500)	Account Budget And Spend	Account Name	Name used to describe the account.
SI$_ACCOUNT_BUDGET_SPEND	BUDGET_END_YEARMONTH	DATE	Account Budget And Spend	Budget End Yearmonth	The last month for the Budget this Account is associated with
SI$_ACCOUNT_BUDGET_SPEND	BUDGET_MONTHS	NUMBER	Account Budget And Spend	Budget Months	The month for the account
SI$_ACCOUNT_BUDGET_SPEND	BUDGET_START_YEARMONTH	DATE	Account Budget And Spend	Budget Start Yearmonth	The first month for the Budget this Account is associated with
SI$_ACCOUNT_BUDGET_SPEND	SPEND	NUMBER	Account Budget And Spend	Spend	The total amount of all invoices posted to this Account
SI$_ACCOUNT_BUDGET_SPEND	STARTDATE	DATE	Account Budget And Spend	Startdate	Date which the account starts on
SI$_ACCOUNT_BUDGET_SPEND	TOTALBUDGET	NUMBER	Account Budget And Spend	Totalbudget	The total budget on this account
SI$_ACCOUNT_MONTHNUM	ACCOUNT_MONTH_NUM_FISCAL_MONTH	DATE	Account Month Number	Account Month Num Fiscal Month	Enables user to plot month numbers 1-12 on a graph
SI$_ACCOUNT_MONTHNUM	ACCOUNT_MONTH_NUM_START_YEAR	NUMBER	Account Month Number	Account Month Num Start Year	Plot by year on a graph - ie, 2016, 2017, 2018, etc.
SI$_ACCOUNT_MONTHNUM	SPEND	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

Table Name in Database	Column Name in Database	Data Type	Friendly Table Name in eCube	Friendly Column Name in eCube	Field Hint
SI$_CONTACT	CONT_BIRTH_DATE	DATE	Contact	Contact Birth Date	The birth date of the contact. Time-zone- independent.
SI$_CONTACT	CONT_COMPANY_NAME	NVARCHAR2(500)	Contact	Contact Company Name	The name of the contact, if the contact is a company.
SI$_CONTACT	CONT_CREATED_BY	NVARCHAR2(706)	Contact	Contact Created By	The user who created the contact record. The username assigned to this user account.
SI$_CONTACT	CONT_CREATED_ON	DATE	Contact	Contact Created On	Date the contact record was created.
SI$_CONTACT	CONT_CREATED_ON_BEHALF_OF	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.
SI$_CONTACT	CONT_CURRENCY_CODE	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.
SI$_CONTACT	CONT_CURRENCY_NAME	NVARCHAR2(100)	Contact	Contact Currency Name	The name of the currency item.
SI$_CONTACT	CONT_CURRENCY_SYMBOL	NVARCHAR2(6)	Contact	Contact Currency Symbol	The ISO symbol of the currency item.
SI$_CONTACT	CONT_DEFAULT_ADDRESS_CITY	NVARCHAR2(100)	Contact	Contact Default Address City	The city in the primary contact address.
SI$_CONTACT	CONT_DEFAULT_ADDRESS_COUNTRY	NVARCHAR2(100)	Contact	Contact Default Address Country	The country in the primary contact address.
SI$_CONTACT	CONT_DEFAULT_ADDRESS_COUNTY	NVARCHAR2(100)	Contact	Contact Default Address County	The county of the primary contact address.
SI$_CONTACT	CONT_DEFADD_CURRENT_AS_OF	DATE	Contact	Contact Default Address Current As Of	The last known date the primary address was current. Time- zone- independent.
SI$_CONTACT	CONT_DEFADD_IS_CURRENT	VARCHAR2(3)	Contact	Contact Default Address Is Current	Indicates whether the primary address is current. 0 = Not Current; 1 = Current
SI$_CONTACT	CONT_DEFADD_POSTAL_CODE	NVARCHAR2(100)	Contact	Contact Default Address Postal Code	The zip code in the primary contact address.
SI$_CONTACT	CONT_DEFADD_REFERENCE_NUMBER	NVARCHAR2(100)	Contact	Contact Default Address Reference Number	The reference number for the primary contact address.
SI$_CONTACT	CONT_DEFAULT_ADDRESS_STATE	NVARCHAR2(100)	Contact	Contact Default Address State	The US state in the primary contact address.
SI$_CONTACT	CONT_DEFAULT_ADDRESS_STREET	NVARCHAR2(500)	Contact	Contact Default Address Street	The street address in the primary contact address.
SI$_CONTACT	CONT_DEFAULT_ADDRESS_TYPE	NVARCHAR2(100)	Contact	Contact Default Address Type	The type of the primary contact address (such as Home or Business)
SI$_CONTACT	CONT_DEFAULT_CATEGORY	NVARCHAR2(100)	Contact	Contact Default Category	The default category for the contact.
SI$_CONTACT	CONT_DEFAULT_CATEGORY_FULL	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).
SI$_CONTACT	CONT_DEFAULT_EMAIL	NVARCHAR2(500)	Contact	Contact Default Email	The selected default email address for the contact.
SI$_CONTACT	CONT_DEFAULT_EMAIL_TYPE	NVARCHAR2(100)	Contact	Contact Default Email Type	The type of the email address (such as Home or Business)
SI$_CONTACT	CONT_DEFAULT_FAX	NVARCHAR2(100)	Contact	Contact Default Fax	The selected default fax number for the contact.
SI$_CONTACT	CONT_DEFAULT_FAX_TYPE	NVARCHAR2(100)	Contact	Contact Default Fax Type	The name of the phone type.
SI$_CONTACT	CONT_DEFAULT_INET_ADDRESS	NVARCHAR2(500)	Contact	Contact Default Inet Address	The selected default internet address for the contact. The actual internet address.
SI$_CONTACT	CONT_DEFAULT_INET_ADDRESS_TYPE	NVARCHAR2(100)	Contact	Contact Default Inet Address Type	The type of the internet address.
SI$_CONTACT	CONT_DEFAULT_PHONE	NVARCHAR2(100)	Contact	Contact Default Phone	The selected default phone number for the contact.
SI$_CONTACT	CONT_DEFAULT_PHONE_TYPE	NVARCHAR2(100)	Contact	Contact Default Phone Type	The name of the phone type.
SI$_CONTACT	CONT_FIRST_NAME	NVARCHAR2(100)	Contact	Contact First Name	The first name of the contact.
SI$_CONTACT	CONT_FULL_NAME	NVARCHAR2(706)	Contact	Contact Full Name	Derived field containing the first and last names of the contact.
SI$_CONTACT	CONT_IS_PERSON_OR_COMPANY	VARCHAR2(7)	Contact	Contact Is Person Or Company	The type of the contact. P - Person (PERSON) or C - Company (COMPANY)
SI$_CONTACT	CONT_JOB_TITLE	NVARCHAR2(500)	Contact	Contact Job Title	The job title of the contact.
SI$_CONTACT	CONT_MIDDLE_NAME	NVARCHAR2(100)	Contact	Contact Middle Name	The middle name of the contact.
SI$_CONTACT	CONT_MODIFIED_BY	NVARCHAR2(706)	Contact	Contact Modified By	The user who last modified the contact record. The username assigned to this user account.
SI$_CONTACT	CONT_MODIFIED_ON	DATE	Contact	Contact Modified On	Date the contact was last modified.
SI$_CONTACT	CONT_NAME	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.
SI$_CONTACT	CONT_NOTE	VARCHAR2(4000)	Contact	Contact Note	Links to the table that contains the text entered into the Notes field of the record.
SI$_CONTACT	CONT_NUMBER	NVARCHAR2(100)	Contact	Contact Number	Alphanumeric text that identifies this contact as per your company's standards.
SI$_CONTACT	CONT_PREFIX	NVARCHAR2(100)	Contact	Contact Prefix	The prefix of the contact's name (such as Mr. or Mrs.).
SI$_CONTACT	CONT_PRIMARY_KEY	NUMBER	Contact	Contact Primary Key	The unique ID of the contact record.
SI$_CONTACT	CONT_SS_OR_TAX_NUMBER	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.
SI$_CONTACT	CONT_SALUTATION	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.
SI$_CONTACT	CONT_SECURITY	VARCHAR2(7)	Contact	Contact Security	The security of the record.
SI$_CONTACT	CONT_SUFFIX	NVARCHAR2(100)	Contact	Contact Suffix	The suffix of the contact's name (such as Jr., Sr., or II)
SI$_CONTACT	CONT_SUPERVISOR	NVARCHAR2(353)	Contact	Contact Supervisor	Contact Supervisor
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_CITY	NVARCHAR2(100)	Contact Addresses	Contact Address City	The city in the contact address.
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_COUNTRY	NVARCHAR2(100)	Contact Addresses	Contact Address Country	The country in the contact address.
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_COUNTY	NVARCHAR2(100)	Contact Addresses	Contact Address County	The county of the contact address.
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_CURRENT_AS_OF	DATE	Contact Addresses	Contact Address Current As Of	The last known date the address was current. Time- zone- independent.
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_IS_CURRENT	VARCHAR2(3)	Contact Addresses	Contact Address Is Current	Indicates whether the address is current. 0 = Not Current; 1 = Current
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_IS_DEFAULT	VARCHAR2(3)	Contact Addresses	Contact Address Is Default	Indicates whether the address is default. 0 = Not Default; 1 = Current
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_POSTAL_CODE	NVARCHAR2(100)	Contact Addresses	Contact Address Postal Code	The zip code in the contact address.
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_REFERENCE_NUMBER	NVARCHAR2(100)	Contact Addresses	Contact Address Reference Number	The reference number for the contact address.
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_STATE	NVARCHAR2(100)	Contact Addresses	Contact Address State	The US state in the contact address.
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_STREET	NVARCHAR2(500)	Contact Addresses	Contact Address Street	The street address in the contact address.
SI$_CONTACT_ADDRESSES	CONT_ADDRESS_TYPE	NVARCHAR2(100)	Contact Addresses	Contact Address Type	The type of the contact address (such as Home or Business)
SI$_CONTACT_CATEGORIES	CONT_CATEGORY	NVARCHAR2(100)	Contact Categories	Contact Category	Each category for the contact.
SI$_CONTACT_CATEGORIES	CONT_CATEGORY_FULL	NVARCHAR2(4000)	Contact Categories	Contact Category Full	The full name of each contact category including the parent's name (for example, Contact:Subsidiaries:Officers).
SI$_CONTACT_EMAILS	CONT_EMAIL	NVARCHAR2(500)	Contact E-Mails	Contact Email	The actual email address.
SI$_CONTACT_EMAILS	CONT_EMAIL_IS_DEFAULT	VARCHAR2(3)	Contact E-Mails	Contact Email Is Default	Is Email the default method of contacting the contact?
SI$_CONTACT_EMAILS	CONT_EMAIL_TYPE	NVARCHAR2(100)	Contact E-Mails	Contact Email Type	The type of the email address (such as Home or Business)
SI$_CONTACT_FAXES	CONT_FAX	NVARCHAR2(100)	Contact Faxes	Contact Fax	The actual fax number.
SI$_CONTACT_FAXES T	CONT_FAX_IS_DEFAULT	VARCHAR2(3)	Contact Faxes	Contact Fax Is Default	Is Fax the default method of contacting the contact?
SI$_CONTACT_FAXES	CONT_FAX_TYPE	NVARCHAR2(100)	Contact Faxes	Contact Fax Type	The type of the fax number (such as Home or Business)
SI$_CONTACT_INET_ADDRESSES	CONT_INET_ADDRESS	NVARCHAR2(500)	Contact Internet Addresses	Contact Inet Address	The actual internet address.
SI$_CONTACT_INET_ADDRESSES	CONT_INET_ADDRESS_IS_DEFAULT	VARCHAR2(3)	Contact Internet Addresses	Contact Inet Address Is Default	Is Internet the default method of contacting the contact?
SI$_CONTACT_INET_ADDRESSES	CONT_INET_ADDRESS_TYPE	NVARCHAR2(100)	Contact Internet Addresses	Contact Inet Address Type	The type of the internet address.
SI$_CONTACT_LEFT_RELATION	CONT_LEFT_RELATION_FULL_NAME	NVARCHAR2(706)	Contact Left Relation	Contact Left Relation Full Name	Derived field containing the first and last names of the contact.
SI$_CONTACT_LEFT_RELATION	CONT_LEFT_RELATION_TYPE	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").
SI$_CONTACT_PHONES	CONT_PHONE	NVARCHAR2(100)	Contact Phones	Contact Phone	The actual phone number.
SI$_CONTACT_PHONES	CONT_PHONE_IS_DEFAULT	VARCHAR2(3)	Contact Phones	Contact Phone Is Default	Is Phone the default method of contacting the contact?
SI$_CONTACT_PHONES	CONT_PHONE_TYPE	NVARCHAR2(100)	Contact Phones	Contact Phone Type	The type of this phone number (such as Home or Business)
SI$_CONTACT_RATE_CURRENT	CONT_CURRENT_RATE	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 appears 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.
SI$_CONTACT_RATE_CURRENT	CONT_CURRENT_RATE_EFF_FROM	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.
SI$_CONTACT_RATE_CURRENT	CONT_CURRENT_RATE_EFF_TO	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.
SI$_CONTACT_RATE_HISTORY	CONT_RATE	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 appears 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.
SI$_CONTACT_RATE_HISTORY	CONT_RATE_EFFECTIVE_FROM	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.
SI$_CONTACT_RATE_HISTORY	CONT_RATE_EFFECTIVE_TO	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.
SI$_CONTACT_RATE_HISTORY	CONT_CURRENCY_CODE	NVARCHAR2(3)	Contact Rate History	Contact Current Converted Code	The current code for the contact
SI$_CONTACT_RATE_HISTORY	CONT_CONVERTED_RATE	NUMBER	Contact Rate History	Contact Current Converted Rate	The current converted rate for the contact
SI$_CONTACT_RIGHT_RELATION	CONT_RIGHT_RELATION_FULL_NAME	NVARCHAR2(706)	Contact Right Relation	Contact Right Relation Full Name	Derived field containing the first and last names of the contact.
SI$_CONTACT_RIGHT_RELATION	CONT_RIGHT_RELATION_TYPE	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").
SI$_CONTACT_SKILLS	CONT_SKILL	NVARCHAR2(100)	Contact Skills	Contact Skill	The name of the skill type.
SI$_CONTACT_SKILLS	CONT_SKILL_LEVEL	NUMBER	Contact Skills	Contact Skill Level	The skill level assigned to the contact for the skill type.
SI$_CONTACT_RATE_TASK_CURRENT	CONT_CURRENT_TASK_CATEGORY	NVARCHAR2(4000)	Contact Task Rate Current	Contact Current Task Category	The task category that belongs to the rate.
SI$_CONTACT_RATE_TASK_CURRENT	CONT_CURRENT_TASK_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 appears 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.
SI$_CONTACT_RATE_TASK_CURRENT	CONT_CURR_TASK_RATE_EFF_FROM	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.
SI$_CONTACT_RATE_TASK_CURRENT	CONT_CURRENT_TASK_RATE_EFF_TO	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.
SI$_CONTACT_RATE_TASK_HISTORY	CONT_TASK_RATE	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 appears 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.
SI$_CONTACT_RATE_TASK_HISTORY	CONT_TASK_RATE_CATEGORY	NVARCHAR2(4000)	Contact Task Rate History	Contact Task Rate Category	The task category that belongs to the rate.
CONT_TASK_RATE_EFFECTIVE_FROM	SI$_CONTACT_RATE_TASK_HISTORY	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.
SI$_CONTACT_RATE_TASK_HISTORY	CONT_TASK_RATE_EFFECTIVE_TO	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.
SI$_CONTACT_TERRITORIES	CONT_TERRITORY	NVARCHAR2(100)	Contact Territories	Contact Territory	The name of the territory type.

Invoice System Object

Table Name in Database	Column Name in Database	Data Type	Friendly Table Name in eCube	Friendly Column Name in eCube	Field Hint
SI$_INVOICE	INVC_ADJUSTMENT_TOTAL	NUMBER	Invoice	Invoice Adjustment Total	(Fee adjustments total) + (Expense adjustments total)
SI$_INVOICE	INVC_BATCH_NUMBER	NVARCHAR2(500)	Invoice	Invoice Batch Number	Not used
SI$_INVOICE	INVC_BATCH_SHORT_DESC	NVARCHAR2(500)	Invoice	Invoice Batch Short Description	Not used
SI$_INVOICE	INVC_BILLING_END_DATE	DATE	Invoice	Invoice Billing End Date	The end date of the invoice period (time zone dependent)
SI$_INVOICE	INVC_BILLING_START_DATE	DATE	Invoice	Invoice Billing Start Date	The start date of the invoice period (time zone dependent)
SI$_INVOICE	INVC_COMMENTS	NVARCHAR2(4000)	Invoice	Invoice Comments	The comments intended to appear on the invoice for the vendor.
SI$_INVOICE	INVC_CREATED_BY	NVARCHAR2(706)	Invoice	Invoice Created By	The user who created the invoice record. Links to specific information about the user account.
SI$_INVOICE	INVC_CREATED_ON	DATE	Invoice	Invoice Created On	Date the invoice was created.
SI$_INVOICE	INVC_CREATED_ON_BEHALF_OF	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.
SI$_INVOICE	INVC_CURRENCY_NAME	NVARCHAR2(100)	Invoice	Invoice Currency Name	The name of the currency item.
SI$_INVOICE	INVC_CURRENCY_SYMBOL	NVARCHAR2(6)	Invoice	Invoice Currency Symbol	The ISO symbol of the currency item.
SI$_INVOICE	INVC_DATE	DATE	Invoice	Invoice Date	The date when the invoice was issued. (time zone dependent)
SI$_INVOICE	INVC_DEFAULT_CATEGORY	NVARCHAR2(100)	Invoice	Invoice Default Category	The default category associated with the invoice.
SI$_INVOICE	INVC_DEFAULT_CATEGORY_FULL	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).
SI$_INVOICE	INVC_DISCOUNT_TOTAL	NUMBER	Invoice	Invoice Discount Total	(Fee discounts total) + (Expense discounts total)
SI$_INVOICE	INVC_EXCHANGE_RATE	NUMBER	Invoice	Invoice Exchange Rate	The exchange rate of the invoice.
SI$_INVOICE	INVC_EXPENSE_ADJ_TOTAL	NUMBER	Invoice	Invoice Expense Adj Total	Sum of line item expense adjustments
SI$_INVOICE	INVC_EXPENSE_DISCOUNT_TOTAL	NUMBER	Invoice	Invoice Expense Discount Total	Sum of line item expense original discounts
SI$_INVOICE	INVC_EXPENSE_TAX_TOTAL	NUMBER	Invoice	Invoice Expense Tax Total	(Taxable line item expense net total)*(Invoice tax rate)
SI$_INVOICE	INVC_FEE_ADJUSTMENT_TOTAL	NUMBER	Invoice	Invoice Fee Adjustment Total	Line item fee adjustments total.
SI$_INVOICE	INVC_FEE_DISCOUNT_TOTAL	NUMBER	Invoice	Invoice Fee Discount Total	Line item fee original discounts total.
SI$_INVOICE	INVC_FEE_TAX_TOTAL	NUMBER	Invoice	Invoice Fee Tax Total	(Taxable line item fee net total)*(Invoice tax rate)
SI$_INVOICE	INVOICE_HAS_NON_US_TAX	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.
SI$_INVOICE	INVC_HAS_NON_US_TAX_RATE	VARCHAR2(3)	Invoice	Invoice Has Non Us Tax Rate	Is this Invoice using Non-US Tax Rates?
SI$_INVOICE	INVC_HAS_PERCENTAGE_DISCOUNT	NUMBER	Invoice	Invoice Has Percentage Discount	An invoice discount in percent form.
SI$_INVOICE	INVC_IS_CURRENT_VERSION	VARCHAR2(3)	Invoice	Invoice Is Current Version	Is this Invoice the current version
SI$_INVOICE	INVC_IS_ELECTRONIC	NUMBER	Invoice	Invoice Is Electronic	If TRUE, indicates that the invoice originated from an e-billing application such as Collaborati.
SI$_INVOICE	INVC_IS_NONUSTAX_SUMMARY_LVL	VARCHAR2(3)	Invoice	Invoice Is Non US Tax Summary Level	Is the Non-US Tax Rate set to Summary Level?
SI$_INVOICE	INVC_LINE_ITEM_NUMBER	NUMBER	Invoice	Invoice Line Item Number	Display the next available line item number. For example, If there are 10 lineitems in the invoice, the next available number could be 11.
SI$_INVOICE	INVC_MANUAL_AMOUNT	NUMBER	Invoice	Invoice Manual Amount	The total amount of the invoice as entered manually by the user.
SI$_INVOICE	INVC_MODIFIED_BY	NVARCHAR2(706)	Invoice	Invoice Modified By	The user who last modified the invoice record. Links to specific information about the user account.
SI$_INVOICE	INVC_MODIFIED_ON	DATE	Invoice	Invoice Modified On	Date the invoice was last modified.
SI$_INVOICE	INVC_NET_EXPENSE_TOTAL	NUMBER	Invoice	Invoice Net Expense Total	(Line item expenses total) + (Expense taxes total)
SI$_INVOICE	INVC_NET_FEE_TOTAL	NUMBER	Invoice	Invoice Net Fee Total	(Line item fees net total) + (Fees taxes total)
SI$_INVOICE	INVC_NET_TOTAL	NUMBER	Invoice	Invoice Net Total	(Net fees total) + (Net expenses total)
SI$_INVOICE	INVC_NOTE	VARCHAR2(4000)	Invoice	Invoice Note	Links to the table that contains the text entered into the Notes field of the record.
SI$_INVOICE	INVC_NUMBER	NVARCHAR2(100)	Invoice	Invoice Number	Any alphanumeric text that describes the invoice record.
SI$_INVOICE	INVC_ORIGINAL_EXPENSE_TOTAL	NUMBER	Invoice	Invoice Original Expense Total	(Line item expenses Original total) + (Line item expenses Original discounts total)
SI$_INVOICE	INVC_ORIGINAL_FEE_TOTAL	NUMBER	Invoice	Invoice Original Fee Total	(Line item fees Original total) + (Line item fees Original discounts total)
SI$_INVOICE	INVC_ORIGINAL_INVOICE_TOTAL	NUMBER	Invoice	Invoice Original Invoice Total	(Original fees total) + (Original expenses total)
SI$_INVOICE	INVC_POSTING_STATUS	VARCHAR2(10)	Invoice	Invoice Posting Status	The posting status of the invoice. 1 = Not Submitted; 2 = Posted; 3 = Not Posted; 5 = Rejected
SI$_INVOICE	INVC_PRIMARY_KEY	NUMBER	Invoice	Invoice Primary Key	The unique ID of the invoice record.
SI$_INVOICE	INVC_RECEIVED_DATE	DATE	Invoice	Invoice Received Date	The date the invoice was received (time zone dependent)
SI$_INVOICE	INVC_REFERENCE_NUMBER	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.
SI$_INVOICE	INVC_SECURITY	VARCHAR2(7)	Invoice	Invoice Security	The security of the record.
SI$_INVOICE	INVC_SUBMITTED_CURRENCY_CODE	NVARCHAR2(6)	Invoice	Invoice Submitted Currency Code	The currency selected for the invoice.
SI$_INVOICE	INVC_TAX_TOTAL	NUMBER	Invoice	Invoice Tax Total	(Fee taxes total) + (Expense taxes total)
SI$_INVOICE	INVC_TAX_TYPE	VARCHAR2(6)	Invoice	Invoice Tax Type	Tax Type for this Invoice (US vs Non-US)
SI$_INVOICE	INVC_TYPE	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)
SI$_INVOICE	INVC_VENDOR	NVARCHAR2(706)	Invoice	Invoice Vendor	The contact record of the vendor associated with the invoice.
SI$_INVOICE	INVC_WARNING	CHAR	Invoice	Invoice Warning	Warning message for the invoice captured by TeamConnect that is generated by another application that processes invoices.
SI$_INVOICE	INVC_VENDOR_CONT_PRIMARY_KEY	NUMBER	Invoice	Account Vendor Contact Primary Key	The contact primary key record of the vendor associated with the invoice
SI$_INVOICE_ADJUSTMENT	INVC_ADJUSTED_ON	DATE	Invoice Adjustment	Invoice Adjusted On	Defaults to current date/time.
SI$_INVOICE_ADJUSTMENT	INVC_ADJUSTMENT_ADJUSTED_BY	NVARCHAR2(706)	Invoice Adjustment	Invoice Adjustment Adjusted By	The user who made the adjustment. Links to specific information about the user account.
SI$_INVOICE_ADJUSTMENT	INVC_ADJ_COMMENTS_TO_VENDOR	NVARCHAR2(500)	Invoice Adjustment	Invoice Adjustment Comments To Vendor	Comments about the adjustment that will be visible to vendors outside your company.
SI$_INVOICE_ADJUSTMENT	INVC_ADJ_IN_HOUSE_COMMENTS	NVARCHAR2(500)	Invoice Adjustment	Invoice Adjustment In House Comments	Comments that are private, not transmitted to vendors or other outside sources.
SI$_INVOICE_ADJUSTMENT	INVC_ADJ_PREV_NET_TOTAL	NUMBER	Invoice Adjustment	Invoice Adjustment Previous Net Total	The net total of the entire invoice immediately before the current adjustment was applied.
SI$_INVOICE_ADJUSTMENT	INVC_ADJUSTMENT_REASON	NVARCHAR2(100)	Invoice Adjustment	Invoice Adjustment Reason	The selected reason for the adjustment.
SI$_INVOICE_ADJUSTMENT	INVC_ADJUSTMENT_TARGET	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
SI$_INVOICE_ADJUSTMENT	INVC_ADJUSTMENT_TOTAL_EXPENSE	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 TypeID.
SI$_INVOICE_ADJUSTMENT	INVC_ADJUSTMENT_TOTAL_FEE	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 TypeID.
SI$_INVOICE_ADJUSTMENT	INVC_ADJUSTMENT_TOTAL_INVOICE	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 TypeID.
SI$_INVOICE_ADJUSTMENT	INVC_ADJUSTMENT_TYPE	VARCHAR2(10)	Invoice Adjustment	Invoice Adjustment Type	Adjustment type. One of these choices: 1 = By Amount; 2 = By Percentage; 3 = To Amount
SI$_INVOICE_CATEGORIES	INVC_CATEGORY	NVARCHAR2(100)	Invoice Categories	Invoice Category	Each category associated with the invoice.
SI$_INVOICE_CATEGORIES	INVC_CATEGORY_FULL	NVARCHAR2(4000)	Invoice Categories	Invoice Category Full	The full name of each invoice category including the parent's name (for example, Invoice:Contracts:Research).
SI$_INVOICE_CATEGORY_ADJ	INVC_CATEGORY_ADJUSTED_AMOUNT	NUMBER	Invoice Category Adjustment	Invoice Category Adjusted Amount	Adjustment amount for Invoice Adjustment
SI$_INVOICE_CATEGORY_ADJ	INVC_CATEGORY_ADJUSTED_BY	NVARCHAR2(706)	Invoice Category Adjustment	Invoice Category Adjusted By	Who submitted the Adjustment
SI$_INVOICE_CATEGORY_ADJ	INVC_CATEGORY_ADJUSTED_ON	DATE	Invoice Category Adjustment	Invoice Category Adjusted On	When the adjustment was submitted
SI$_INVOICE_CATEGORY_ADJ	INVC_CATEGORY_ADJUSTED_TYPE	VARCHAR2(10)	Invoice Category Adjustment	Invoice Category Adjusted Type	Type of adjustment: By Percent, By Amount, or To Amount
SI$_INVOICE_CATEGORY_ADJ	INVC_CAT_ADJ_CATEGORY_NAME	NVARCHAR2(100)	Invoice Category Adjustment	Invoice Category Adjustment Category Name	Invoice category adjustment category name.
SI$_INVOICE_CATEGORY_ADJ	INVC_CAT_ADJ_COMMENT_TO_VENDOR	NVARCHAR2(500)	Invoice Category Adjustment	Invoice Category Adjustment Comments To Vendor	Comments to Requester for Adjustments made to Invoice
SI$_INVOICE_CATEGORY_ADJ	INVC_CAT_ADJ_IN_HOUSE_COMMENT	NVARCHAR2(500)	Invoice Category Adjustment	Invoice Category Adjustment In House Comments	In House comments for Adjustments made to Invoice
SI$_INVOICE_CATEGORY_ADJ	INVC_CAT_ADJ_PREVIOUS_TOTAL	NUMBER	Invoice Category Adjustment	Invoice Category Adjustment Previous Net Total	Invoice total prior to Adjustments
SI$_INVOICE_CATEGORY_ADJ	INVC_CAT_ADJ_REASON	NVARCHAR2(100)	Invoice Category Adjustment	Invoice Category Adjustment Reason	Reason for Adjustment to Invoice
SI$_LINEITEM	LNI$_ACTIVITY_ITEM	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.
SI$_LINEITEM	LNI$_ADJUSTED_DISCOUNT	NUMBER	Invoice Line Item	Invoice Line Item Adjusted Discount	The net discount of the line item.
SI$_LINEITEM	LNI$_ADJUSTED_QUANTITY	NUMBER	Invoice Line Item	Invoice Line Item Adjusted Quantity	The net quantity of the line item.
SI$_LINEITEM	LNI$_ADJUSTED_RATE	NUMBER	Invoice Line Item	Invoice Line Item Adjusted Rate	The net rate of the line item.
SI$_LINEITEM	LNI$_ADJUSTMENT_SOURCE	VARCHAR2(6)	Invoice Line Item	Invoice Line Item Adjustment Source	Source of adjustment. One of two choices: 1 = Manual; 2 = Automatic
SI$_LINEITEM	LNI$_CREATED_BY	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.
SI$_LINEITEM	LNI$_CREATED_ON	DATE	Invoice Line Item	Invoice Line Item Created On	Date the invoice was created.
SI$_LINEITEM	LNI$_CURRENCY_ITEM	NVARCHAR2(100)	Invoice Line Item	Invoice Line Item Currency Item	Name of currency.
SI$_LINEITEM	LNI$_DEFAULT_CATEGORY	NVARCHAR2(100)	Invoice Line Item	Invoice Line Item Default Category	The default category associated with the line item.
SI$_LINEITEM	LNI$_DEFAULT_CATEGORY_FULL	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).
SI$_LINEITEM	LNI$_DEFAULT_CURRENT_DISCOUNT	NUMBER	Invoice Line Item	Invoice Line Item Default Current Discount	The net discount of the line item in the system's default currency.
SI$_LINEITEM	LNI$_DEFAULT_CURRENT_RATE	NUMBER	Invoice Line Item	Invoice Line Item Default Current Rate	The net rate of the line item in the system's default currency
SI$_LINEITEM	LNI$_DEFAULT_CURRENT_TOTAL	NUMBER	Invoice Line Item	Invoice Line Item Default Current Total	The net total of the line item in the system's default currency
SI$_LINEITEM	LNI$_DESCRIPTION	NVARCHAR2(4000)	Invoice Line Item	Invoice Line Item Description	The description of the line item.
SI$_LINEITEM	LNI$_EXPENSE_TYPE	NVARCHAR2(100)	Invoice Line Item	Invoice Line Item Expense Type	The expense category of the line item, if the line item is an expense.
SI$_LINEITEM	LNI$_EXPENSE_TYPE_FULL	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.
SI$_LINEITEM	LNI$_HAS_ADJUSTMENTS	VARCHAR2(3)	Invoice Line Item	Invoice Line Item Has Adjustments	Have any adjustments been applied to this Line Item?
SI$_LINEITEM	LNI$_HAS_WARNINGS	VARCHAR2(3)	Invoice Line Item	Invoice Line Item Has Warnings	Indicates whether warning conditions have been noted for this line item.
SI$_LINEITEM	LNI$_INTERNAL_COMMENTS	NVARCHAR2(4000)	Invoice Line Item	Invoice Line Item Internal Comments	In House comments on a Line Item
SI$_LINEITEM	LNI$_IS_APPEALED	VARCHAR2(3)	Invoice Line Item	Invoice Line Item Is Appealed	Has this Line Item been appealed?
SI$_LINEITEM	LNI$_IS_TAXABLE	VARCHAR2(3)	Invoice Line Item	Invoice Line Item Is Taxable	Currently not used.
SI$_LINEITEM	LNI$_MODIFIED_BY	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
SI$_LINEITEM	LNI$_MODIFIED_ON	DATE	Invoice Line Item	Invoice Line Item Modified On	The date that the line item was modified.
SI$_LINEITEM	LNI$_NET_TOTAL	NUMBER	Invoice Line Item	Invoice Line Item Net Total	The net total of the line item.
SI$_LINEITEM	LNI$_NUMBER	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.
SI$_LINEITEM	LNI$_ORIGINAL_DISCOUNT	NUMBER	Invoice Line Item	Invoice Line Item Original Discount	The original discount of the line item.
SI$_LINEITEM	LNI$_ORIGINAL_QUANTITY	NUMBER	Invoice Line Item	Invoice Line Item Original Quantity	The original quantity of line item.
SI$_LINEITEM	LNI$_ORIGINAL_RATE	NUMBER	Invoice Line Item	Invoice Line Item Original Rate	The original rate of the line item.
SI$_LINEITEM	LNI$_ORIGINAL_TOTAL	NUMBER	Invoice Line Item	Invoice Line Item Original Total	The original total of the line item.
SI$_LINEITEM	LNI$_PRIMARY_KEY	NUMBER	Invoice Line Item	Invoice Line Item Primary Key	The unique ID of the line item.
SI$_LINEITEM	LNI$_QUANTITY	NUMBER	Invoice Line Item	Invoice Line Item Quantity	The current quantity of the line item.
SI$_LINEITEM	LNI$_SECURITY	VARCHAR2(7)	Invoice Line Item	Invoice Line Item Security	The security of the record.
SI$_LINEITEM	LNI$_SERVICE_DATE	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 .
SI$_LINEITEM	LNI$_TASK_CATEGORY	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.
SI$_LINEITEM	LNI$_TASK_CATEGORY_FULL	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.
SI$_LINEITEM	LNI$_TASK_OR_EXPENSE	VARCHAR2(7)	Invoice Line Item	Invoice Line Item Task Or Expense	Defines line item type as Fee or Expense.
SI$_LINEITEM	LNI$_TIMEKEEPER	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.
SI$_LINEITEM	LNI$_TOTAL_ADJUSTMENT	NUMBER	Invoice Line Item	Invoice Line Item Total Adjustment	The total amount of all adjustments made to the line item.
SI$_LINEITEM	LNI$_WARNINGS	NVARCHAR2(4000)	Invoice Line Item	Invoice Line Item Warnings	Collected text of warning messages related to this line item.
SI$_LINEITEM	LNI$_TMK$_CONT_PRIMARY_KEY	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.
SI$_LNI$_ADJUSTMENTS	LNI$_ADJUSTED_BY	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.
SI$_LNI$_ADJUSTMENTS	LNI$_ADJUSTED_ON	DATE	Invoice Line Item Adjustments	Invoice Line Item Adjusted On	Defaults to current date/ time.
SI$_LNI$_ADJUSTMENTS	LNI$_ADJUSTMENT_AMOUNT	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 TypeID.
SI$_LNI$_ADJUSTMENTS	LNI$_ADJ$_COMMENT_TO_VENDOR	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.
SI$_LNI$_ADJUSTMENTS	LNI$_ADJ$_IN_HOUSE_COMMENT	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.
SI$_LNI$_ADJUSTMENTS	LNI$_ADJ$_PREV_NET_TOTAL	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.
SI$_LNI$_ADJUSTMENTS	LNI$_ADJUSTMENT_QUANTITY	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
SI$_LNI$_ADJUSTMENTS	LNI$_ADJ$_CALC_TOTAL	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.
SI$_INVOICE_NONUSTAX	INVC_DCURR_TAX_AMOUNT	NUMBER	Invoice Non US Tax	Invoice Dcurr Tax Amount	The tax amount in the invoice's default currency.
SI$_INVOICE_NONUSTAX	INVC_NONUSTAX_AMOUNT	NUMBER	Invoice Non US Tax	Invoice Non US Tax Amount	The tax amount in original, local currency.
SI$_INVOICE_NONUSTAX	INVC_NONUSTAX_CODE	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.
SI$_INVOICE_NONUSTAX_RATES	INVC_NONUSTAX_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.
SI$_INVOICE_NONUSTAX_RATES	INVC_NONUSTAX_RATE	NUMBER	Invoice Non US Tax Rates	Invoice Non US Tax Rate	Rate associated with each tax code?
SI$_INVC_VEN$_CONTACT	INVC_VEN$_CURRENCY_CODE	NVARCHAR2(6)	Invoice <Object Title> Contact	Invoice <Object Title> Currency Code	Invoice Vendor Currency Code
SI$_INVC_VEN$_CONTACT	INVC_VEN$_CURRENCY_NAME	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Currency Name	Invoice Vendor Currency Name
SI$_INVC_VEN$_CONTACT	INVC_VEN$_CURRENCY_SYMBOL	NVARCHAR2(6)	Invoice <Object Title> Contact	Invoice <Object Title> Currency Symbol	Invoice Vendor Currency Symbol
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_CATEGORY	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Default Category	The default Invoice Vendor category (for example, External)
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_CAT_FULL	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)
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_CITY	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Default City	Invoice Vendor Default City
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_COUNTRY	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Default Country	Invoice Vendor Default Country
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_COUNTY	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Default County	Invoice Vendor Default County
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_EMAIL	NVARCHAR2(500)	Invoice <Object Title> Contact	Invoice <Object Title> Default Email	Invoice Vendor Default Email
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_FAX	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Default Fax	Invoice Vendor Default Fax
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_PHONE	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Default Phone	Invoice Vendor Default Phone
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_POSTALCODE	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Default Postal Code	Invoice Vendor Default Postal Code
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_STATE	NVARCHAR2(100)	Invoice <Object Title> Contact	Invoice <Object Title> Default State	Invoice Vendor Default State
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_STREET	NVARCHAR2(500)	Invoice <Object Title> Contact	Invoice <Object Title> Default Street	Invoice Vendor Default Street
SI$_INVC_VEN$_CONTACT	INVC_VEN$_FULL_NAME	NVARCHAR2(706)	Invoice <Object Title> Contact	Invoice <Object Title> Full Name	Invoice Vendor Full Name
SI$_INVC_VEN$_CONTACT	INVC_VEN$_DEFAULT_INET_ADDR	NVARCHAR2(500)	Invoice <Object Title> Contact	Invoice <Object Title> Inet Address	Invoice Vendor Default Inet Address

Timekeeper Rate Object

Table Name in Database	Column Name in Database	Data Type	Friendly Table Name in eCube	Friendly Column Name in eCube	Field Hint
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_COMPANY_NAME	NVARCHAR2(500)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Company Name	Invoice Line Item Timekeeper Company Name
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_CURRENCY_CODE	NVARCHAR2(6)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Currency Code	Invoice Line Item Timekeeper Currency Code
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_CURRENCY_NAME	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Currency Name	Invoice Line Item Timekeeper Currency Name
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_CURRENCY_SYMBOL	NVARCHAR2(6)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Currency Symbol	Invoice Line Item Timekeeper Currency Symbol
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_CATEGORY	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default Category	The default Line Item Timekeeper category (for example, "External")
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_CAT_FULL	NVARCHAR2(4000)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default Category Full	The default Timekeeper category along with Parent(Example, "External" when only parent category exists; can be expanded to "External:Attorney" when child category exists)
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_CITY	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default City	Invoice Line Item Timekeeper Default City
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_COUNTRY	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default Country	Invoice Line Item Timekeeper Default Country
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_COUNTY	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default County	Invoice Line Item Timekeeper Default County
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_EMAIL	NVARCHAR2(500)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default Email	Invoice Line Item Timekeeper Default Email
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_FAX	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default Fax	Invoice Line Item Timekeeper Default Fax
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_PHONE	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default Phone	Invoice Line Item Timekeeper Default Phone
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_POSTALCODE	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default PostalCode	Invoice Line Item Timekeeper Default Postal Code
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_STATE	NVARCHAR2(100)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default State	Invoice Line Item Timekeeper Default State
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_STREET	NVARCHAR2(500)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Default Street	Invoice Line Item Timekeeper Default Street
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_FULL_NAME	NVARCHAR2(706)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Full Name	Invoice Line Item Timekeeper Full Name
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_DEF_INET_ADDR	NVARCHAR2(500)	Invoice Line Item <Object Title> Contact	Invoice Line Item <Object Title> Inet Address	Invoice Line Item Timekeeper Default Inet Address
SI$_LNI$_TMK$_CONTACT	LNI$_TMK$_HOME_OFFICE_PROFILE	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)
SI$_LNI$_TMK$_DEF_RATE	TMK$_CURRENT_RATE	NUMBER	Invoice Line Item <Object Title> Default Rate	<Object Title> Current Rate	Invoice Line Item Timekeeper Default Current Rate
SI$_LNI$_TMK$_DEF_RATE	TMK$_CURRENT_RATE_EFF_FROM	DATE	Invoice Line Item <Object Title> Default Rate	<Object Title> Current Rate Effective From	Invoice Line Item Timekeeper Default Rate Effective From
SI$_LNI$_TMK$_DEF_RATE	TMK$_CURRENT_RATE_EFF_TO	DATE	Invoice Line Item <Object Title> Default Rate	<Object Title> Current Rate Effective To	Invoice Line Item Timekeeper Default Rate Effective To
SI$_LNI$_TMK$_DEF_RATE	TMK$_CURRENT_RATE_PROJ_NAME	NVARCHAR2(500)	Invoice Line Item <Object Title> Default Rate	<Object Title> Project Centric Current Rate Project Name	The project centric project name default rate value for the timekeeper
SI$_LNI$_TMK$_DEF_RATE	TMK$_CURRENT_RATE_PROJ_NUMBER	NVARCHAR2(100)	Invoice Line Item <Object Title> Default Rate	<Object Title> Project Centric Current Rate Project Number	The project centric project number default rate value for the timekeeper
SI$_LNI$_TMK$_DEF_RATE	TMK$_CURRENT_RATE_PROJ_TITLE	NVARCHAR2(500)	Invoice Line Item <Object Title> Default Rate	<Object Title> Project Centric Current Rate Project Object Title	The project centric object title default rate value for the timekeeper
SI$_LNI$_TMK$_DEF_RATE_HIST	TMK$_RATE_PROJECT_NAME	NVARCHAR2(500)	Invoice Line Item <Object Title> Default Rate History	<Object Title> Project Centric Rate Project Name	The project centric project name default rate history value for the timekeeper
SI$_LNI$_TMK$_DEF_RATE_HIST	TMK$_RATE_PROJECT_NUMBER	NVARCHAR2(100)	Invoice Line Item <Object Title> Default Rate History	<Object Title> Project Centric Rate Project Number	The project centric project number default rate history value for the timekeeper
SI$_LNI$_TMK$_DEF_RATE_HIST	TMK$_RATE_PROJECT_OBJECT_TITLE	NVARCHAR2(500)	Invoice Line Item <Object Title> Default Rate History	<Object Title> Project Centric Rate Project Object Title	The project centric object title default rate history value for the timekeeper
SI$_LNI$_TMK$_DEF_RATE_HIST	TMK$_RATE	NUMBER	Invoice Line Item <Object Title> Default Rate History	<Object Title> Rate	Invoice Line Item Timekeeper Default History Rate
SI$_LNI$_TMK$_DEF_RATE_HIST	TMK$_RATE_EFF_FROM	DATE	Invoice Line Item <Object Title> Default Rate History	<Object Title> Rate Effective From	Invoice Line Item Timekeeper Default Rate History Effective From
SI$_LNI$_TMK$_DEF_RATE_HIST	TMK$_RATE_EFF_TO	DATE	Invoice Line Item <Object Title> Default Rate History	<Object Title> Rate Effective To	Invoice Line Item Timekeeper Default Rate History Effective To
SI$_LNI$_TMK$_TASK_RATE	TMK$_CURRENT_TASK_RATE	NUMBER	Invoice Line Item <Object Title> Task Rate	<Object Title> Current Task Rate	Invoice Line Item Timekeeper Current Task Rate
SI$_LNI$_TMK$_TASK_RATE	TMK$_CURR_TASK_RATE_EFF_FROM	DATE	Invoice Line Item <Object Title> Task Rate	<Object Title> Current Task Rate Effective From	Invoice Line Item Timekeeper Current Task Rate Effective From
SI$_LNI$_TMK$_TASK_RATE	TMK$_CURR_TASK_RATE_EFF_TO	DATE	Invoice Line Item <Object Title> Task Rate	<Object Title> Current Task Rate Effective To	Invoice Line Item Timekeeper Current Task Rate Effective To
SI$_LNI$_TMK$_TASK_RATE	TMK$_CURR_TASK_RATE_PROJ_NAME	NVARCHAR2(500)	Invoice Line Item <Object Title> Task Rate	<Object Title> Project Centric Task Rate Project Name	The project centric project name task rate value for the timekeeper
SI$_LNI$_TMK$_TASK_RATE	TMK$_CURR_TASK_RATE_PROJ_NUM	NVARCHAR2(100)	Invoice Line Item <Object Title> Task Rate	<Object Title> Project Centric Task Rate Project Number	The project centric project number task rate value for the timekeeper
SI$_LNI$_TMK$_TASK_RATE	TMK$_CURR_TASK_RATE_PROJ_TITLE	NVARCHAR2(500)	Invoice Line Item <Object Title> Task Rate	<Object Title> Project Centric Task Rate Project Object Title	The project centric object title task rate value for the timekeeper
SI$_LNI$_TMK$_TASK_RATE_HIST	TMK$_TASK_RATE_PROJ_NAME	NVARCHAR2(500)	Invoice Line Item <Object Title> Task Rate History	<Object Title> Project Centric Task Rate Project Name	The project centric project name task rate history value for the timekeeper
SI$_LNI$_TMK$_TASK_RATE_HIST	TMK$_TASK_RATE_PROJ_NUMBER	NVARCHAR2(100)	Invoice Line Item <Object Title> Task Rate History	<Object Title> Project Centric Task Rate Project Number	The project centric project number task rate history value for the timekeeper
SI$_LNI$_TMK$_TASK_RATE_HIST	TMK$_TASK_RATE_PROJ_OBJ_TITLE	NVARCHAR2(500)	Invoice Line Item <Object Title> Task Rate History	<Object Title> Project Centric Task Rate Project Object Title	The project centric object title task rate history value for the timekeeper
SI$_LNI$_TMK$_TASK_RATE_HIST	TMK$_TASK_RATE	NUMBER	Invoice Line Item <Object Title> Task Rate History	<Object Title> Task Rate	Invoice Line Item Timekeeper Task Rate History
SI$_LNI$_TMK$_TASK_RATE_HIST	TMK$_TASK_RATE_EFF_FROM	DATE	Invoice Line Item <Object Title> Task Rate History	<Object Title> Task Rate Effective From	Invoice Line Item Timekeeper Task Rate History Effective From
SI$_LNI$_TMK$_TASK_RATE_HIST	TMK$_TASK_RATE_EFF_TO	DATE	Invoice Line Item <Object Title> Task Rate History	<Object Title> 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

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 DISP – and the Object Title is Dispute, 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_DISP	DISP_CLOSED_ON DATE	DATE	Dispute	Dispute Closed On	Date the project status was changed to closed.

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_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_RECENT_STATUS_DATE	DATE	<Object Title>	<Object Title>Recent status creation date	Recent status creation date
SI$_PROJECT_XXXX	XXXX_RECENT_STATUS_NOTES	NVARCHAR2(2000)	<Object Title>	<Object Title>Recent status notes	Recent status notes
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	XXXX_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_PHASES	XXXX_PHASE_DURATION	NUMBER	<Object Title> Phase History	<Object Title> Phase Duration	The duration of the phase.
SI$_PROJECT_XXXX_PHASES	XXXX_PHASE_NAME	NVARCHAR2(500)	<Object Title> Phase History	<Object Title> Phase Name	The name of the phase.
SI$_PROJECT_XXXX_PHASES	XXXX_PHASE_TRANSITION_BY	NVARCHAR2(706)	<Object Title> Phase History	<Object Title> Phase Transition By	The user who changed the project o this phase.
SI$_PROJECT_XXXX_PHASES	XXXX_PHASE_TRANSITIONED_ON	DATE	<Object Title> Phase History	<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

Table Name in Database	Column Name in Database	Data Type	Friendly Table Name in eCube	Friendly Column Name in eCube	Field Hint
SI$_PROJECTS_SECURITY	USERNAME	NVARCHAR2(200)	Project Row Security	Username	Project Row Security Username