Skip to main content
Mitratech Success Center

eCube Data Dictionary for TeamConnect Enterprise

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. 

 

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.
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_BUDGETSPEND     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_BUDGETSPEND     ACCOUNT_CREATED_ON DATE Account Budget And Spend Account Created On Date and time the account was created.
SI$_ACCOUNT_BUDGETSPEND     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_BUDGETSPEND     ACCOUNT_FISCAL_START_MONTH VARCHAR2(2) Account Budget And Spend Account Fiscal Start Month First month of the Fiscal Year assocaited with the Account
SI$_ACCOUNT_BUDGETSPEND     ACCOUNT_FISCAL_YEAR NUMBER Account Budget And Spend Account Fiscal Year The Fiscal Year associated with the Account
SI$_ACCOUNT_BUDGETSPEND     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_BUDGETSPEND     ACCOUNT_MODIFIED_ON DATE Account Budget And Spend Account Modified On Date and time the account was most recently modified.
SI$_ACCOUNT_BUDGETSPEND     ACCOUNT_MONTH_NUM NUMBER Account Budget And Spend Account Month Num The numeric month for the account
SI$_ACCOUNT_BUDGETSPEND     ACCOUNT_NAME NVARCHAR2(500) Account Budget And Spend Account Name Name used to describe the account.
SI$_ACCOUNT_BUDGETSPEND     BUDGET_END_YEARMONTH DATE Account Budget And Spend Budget End Yearmonth The last month for the Budget this Account is associated with
SI$_ACCOUNT_BUDGETSPEND     BUDGET_MONTHS NUMBER Account Budget And Spend Budget Months The month for the account
SI$_ACCOUNT_BUDGETSPEND     BUDGET_START_YEARMONTH DATE Account Budget And Spend Budget Start Yearmonth The first month for the Budget this Account is associated with
SI$_ACCOUNT_BUDGETSPEND     SPEND NUMBER Account Budget And Spend Spend The total amount of all invoices posted to this Account
SI$_ACCOUNT_BUDGETSPEND     STARTDATE DATE Account Budget And Spend Startdate Date which the account starts on
SI$_ACCOUNT_BUDGETSPEND     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

 

 

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_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 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.
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 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.
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_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 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.
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 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.
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 availalbe 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 TeamConne ct that is generated by another application that processes invoices.
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 TypeIID.
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 TypeIID.
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 TypeIID.
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$_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 TypeIID.
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$_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?

 

 

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

 

 

 

  • Was this article helpful?