Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

accountInvolvedType

Before TeamConnect 3.3 SP2: applTypeInvolvedIID

INVOLVED_APPL_TYPE_IID

(NUMBER)

Post Account to Involved

(Posting Criteria block)

x

Enum

Specifies whether the involved is associated to a specific project or to any project.

1 - Any (ANY)

2 - One (ONE)

x

x

accountOverdraftType

Before TeamConnect 3.3 SP2: overdraftTypeIID

OVERDRAFT_TYPE_IID

(NUMBER)

Overdraft Type

(General block)

x

Enum

Specifies what happens when there are not enough funds to cover the manual withdrawals, transfers, or automatically posted transactions.

1 - Do not allow negative account (NONNEGATIVE)

2 - Allow negative account (ALLOW_NEGATIVE)

3 - Automatic overdraft protection (OVERDRAFT)

x

x

accountProjectType

Before TeamConnect 3.3 SP2: applTypeProjectIID

PROJECT_APPL_TYPE_IID

(NUMBER)

Post Project to this Account

(Posting Criteria block)

x

Enum

Indicates whether to post transactions associated to a specific project, any project, or a project of a specific category.

1 - Any (ANY_PROJECT)

2 - One (ONE_PROJECT))

3 - By Type (BY_TYPE)

x

x

accountVendorType

Before TeamConnect 3.3 SP2: applTypeVendorIID

VENDOR_APPL_TYPE_IID

(NUMBER)

Post Account to Vendor

(Posting Criteria block)

x

Enum

Indicates whether to post transactions associated to a specific vendor or any vendor.

1 - Any (ANY_VENDOR)

2 - One (ONE_VENDOR)

x

x

allocated

TOTAL_ALLOCATED

(NUMBER)

Total Allocated

(General block)

x

decimal

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

x

x

allocationLimit

ALLOC_LIMIT

(NUMBER)

Allocation Limit

(General block)

x

decimal

Total amount of funds allowed to be allocated to the account records as specified by the user.

x

x

accrual

TOTAL_ACCRUAL

(NUMBER)

Total Accruals

(General block)

x

decimal

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

x

x

applProjDetailField-->

APPL_PROJECT_DETAIL_FIELD_ID

(NUMBER)

Currently not used.

autoPost

Before TeamConnect 3.3 SP2: isAutoPost

AUTO_POST

(NUMBER)

Allow Posting

(General block)

x

boolean

Indicates whether expense, task, and invoice line item transactions can be posted to the account.

0 - Do not post

1 - Post

x

x

available

TOTAL_BG_AVAILABLE

(NUMBER)

Balance

(General block)

x

decimal

Account balance, which results from the following equation:

allocated - used = available

categories-->

Before TeamConnect 3.3 SP2: detailList-->

n/a

x

x

EAcctDetail

In Object Navigator, links to Category list which appears in the UI only.

8 The list of categories added to the current object.

--> In the object model, the added categories link to the values that have been added for custom fields, according to field type.

--> In Object Navigator, this attribute is enhanced. It links to a list of all categories defined for the object definition, rather than those added to the current object. From there, you can select a category and traverse to the list of custom fields that belong to it.

createdBy-->

CREATED_BY_ID

(NUMBER)

Created By

(Security block)

x

x

YUser

object

8 User who created the account.

--> Links to specific information about the user account.

createdOn

CREATED_ON

(DATE)

Created On

(Security block)

x

date

Date and time the account was created.

x

createdOnBehalfOf

CREATED_ON_ BEHALF_OF_ID

x

TContact

object

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.

X

defaultCategory-->

DEFAULT_CATEGORY_ ID

(NUMBER)

Default Category

(indicated by a blue diamond - Categories block)

x

x

YRecentlyViewedRecord

object

8 Default category for the account.

--> Links to the definition information of the category.

documentFolder-->

DOCUMENT_FOLDER_I D

(NUMBER)

Documents block

x

TDocument

object

Links to specific information about the document folder.

EndOn

Before TeamConnect 3.3 SP2: applEndOn

APPL_END_ON

(DATE)

Period ends on:

(General block)

x

date

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

x

x

expenseCategory-->

Before TeamConnect 3.3 SP2: applExpeCategory-->

APPL_EXPENSE_CATE GORY_ID

(NUMBER)

Post Expenses of Category

(Posting Criteria block)

x

x

YRecentlyViewedRecord

object

8 Expense category specified as the posting criterion for the account.

--> Links to the definition information of the category.

x

x

expensePercent

Before TeamConnect 3.3 SP2: applExpePercent

APPL_EXPENSE_PERC ENT

(NUMBER

Expense Percent

(Posting Criteria block)

x

decimal

Percentage of the total expense amount allowed to be posted to the account.

x

x

groupAccessList-->

n/a

x

EAcctGroupAccess

Links to the group security information entered through the Security block of the record.

historyList-->

n/a

History tab

x

x

THistory

8 The list of all histories that are added to the account record.

--> Links to specific history information for all of the account's history records.

x

active

Before TeamConnect 3.3 SP2: iisActive

STATUS_IID

(NUMBER)

Status

(General block)

x

boolean

Indicates whether the account is currently active or inactive.

0 - Inactive

1 - Active

x

x

allowExpense

Before TeamConnect 3.3 SP2: iisApplExpense

APPL_EXPENSE

(NUMBER)

Post Expenses to this Account

(Posting Criteria block)

x

boolean

Indicates whether expense transactions can be posted to the account.

0 - Do not post

1 - Post

x

x

allowInvoiceExpense

Before TeamConnect 3.3 SP2: iisApplLineExpense

APPL_INVD_EXPENSE

(NUMBER)

Post Invoice Expenses to this Account

(Posting Criteria block)

x

boolean

Indicates whether invoice line item transactions of type Expense can be posted to the account.

0 - Do not post

1 - Post

x

x

iallowInvoiceTask

Before TeamConnect 3.3 SP2: isApplLineTask

APPL_INVD_TASK

(NUMBER)

Post Invoice Tasks to this Account

(Posting Criteria block)

x

boolean

Indicates whether invoice line item transactions of type Task can be posted to the account.

0 - Do not post

1 - Post

x

x

allowTask

Before TeamConnect 3.3 SP2: iisApplTask

APPL_TASK

(NUMBER)

Post Tasks to this Account

(Posting Criteria block)

x

boolean

Indicates whether task transactions can be posted to the account.

0 - Do not post

1 - Post

x

x

invoiceExpenseCategory-->

Before TeamConnect 3.3 SP2: applLineExpeCategory-->

APPL_INVD_EXP_CAT EGORY_ID

(NUMBER)

Post Invoice Expense of Category

(Posting Criteria block)

x

x

YRecentlyViewedRecord

object

8 Expense category for an invoice line item that is specified as the posting criterion for the account.

--> Links to the definition information of the category.

x

x

invoiceExpensePercent

Before TeamConnect 3.3 SP2: applLineExpePercent

APPL_INVD_EXPENSE _PERCENT

(NUMBER)

Invoice Expense Percent

(Posting Criteria block)

x

decimal

Percentage of the total expense line item amount allowed to be posted to the account.

x

x

invoiceTaskCategory

Before TeamConnect 3.3 SP2: applLineTaskCategory-->

APPL_INVD_TASK_CA TEGORY_ID

(NUMBER)

Post Invoice Tasks of Type

(Posting Criteria block)

x

x

YRecentlyViewedRecord

object

8 Task category for an invoice line item that is specified as the posting criterion for the account.

--> Links to the definition information of the category.

x

x

invoiceTaskPercent

Before TeamConnect 3.3 SP2: applLineTaskPercent

APPL_INVD_TASK_PE RCENT

(NUMBER)

Invoice Task Percent

(Posting Criteria block)

x

decimal

Percent of the task invoice line item allowed to be posted to the account.

Note: This column is populated only when allowInvoiceTask is set to 1.

x

x

applInvcNonUSTaxType-->

APPL_NON_US_TAX_T YPE

(NUMBER)

Non-US Tax Type

x

LInvcNonUSTaxType

object

8 The tax type category associated with the tax amount.

x

x

applInvcNonUSTaxPercent

APPL_INVC_NON_US_ TAX_PERCENT

(NUMBER

Non-US Tax Percent

(Posting Criteria block)

x

decimal

Percentage of the total non-US tax amount allowed to be posted to the account.

x

x

involved-->

Before TeamConnect 3.3 SP2: applInvolved-->

APPL_INVOLVED_ID

(NUMBER)

This Involved

(Posting Criteria block)

x

x

TContact

object

8 The contact involved in the project who is specified as the posting criterion for the account.

--> Links to the specific information about the contact object.

x

x

modifiedBy-->

MODIFIED_BY_ID

(NUMBER)

Modified By

(Security block)

x

x

YUser

object

8 User who most recently modified the account.

--> Links to specific information about the user account.

modifiedOn

MODIFIED_ON

(DATE)

Modified On

(Security block)

x

date

Date and time the account was most recently modified.

name

NAME

(VARCHAR2) (250)

Name

(General block)

x

string (250)

Name used to describe the account.

x

note-->

NOTE_ID

(NUMBER)

Notes

(General block)

x

JNote

object

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

parentAccount-->

PARENT_ACCOUNT_ID

(NUMBER)

Parent Account

(General block)

x

x

TAccount

object

8 The account that is specified as the parent of this account.

--> Links to specific information about the account record.

x

x

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the account record.

project

Before TeamConnect 3.3 SP2: applProject

PROJECT_ID

(NUMBER)

This Project

(Posting Criteria tab)

x

x

TProject

object

8 Project that is specified as the posting criterion for the account.

--> Links to specific information about the project record.

x

x

projectCategory-->

Before TeamConnect 3.3 SP2: applProjCategory-->

APPL_PROJECT_CATE GORY_ID

(NUMBER)

Post Projects of Type

(Posting Criteria block)

x

x

YRecentlyViewedRecord

object

8 Project category specified as the posting criterion for the account.

--> Links to the definition information of the category.

x

x

securityTypeIID

SECURITY_TYPEIID

(NUMBER)

Security Type

(Security block)

x

int

Specifies whether the account is public or private.

0 - Public (PUBLIC)

2 - Private (PRIVATE)

startOn

Before TeamConnect 3.3 SP2: applStartOn

APP_START_ON

(DATE)

Account period begins:

(General block)

x

date

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

x

x

taskCategory-->

Before TeamConnect 3.3 SP2: applTaskCategory-->

APPL_TASK_CATEGOR Y_ID

(NUMBER)

Post Tasks of Type

(Posting Criteria block)

x

x

YRecentlyViewedRecord

object

8 Task category specified as the posting criterion for the account.

--> Links to the definition information of the category.

x

x

taskPercent

Before TeamConnect 3.3 SP2: applTaskPercent

APPL_TASK_PERCENT

(NUMBER)

Task Percent

(Posting Criteria block)

x

decimal

Percentage of the total task amount allowed to be posted to the account.

x

x

iisApplInvcStandard

APPL_INVC_STANDAR D

(NUMBER)

Post Invoice Type

x

boolean

Indicates whether standard invoices can be posted to the account.

0 - No

1 - Yes

x

x

iisApplInvcAccrual

APPL_INVC_ACCRUAL

(NUMBER)

Post Invoice Type

x

boolean

Indicates whether accrual invoices can be posted to the account.

0 - No

1 - Yes

x

x

iisApplInvcCreditNote

APPL_INVC_CREDIT_ NOTE

(NUMBER)

Post Invoice Type

x

boolean

Indicates whether credit notes can be posted to the account.

0 - No

1 - Yes

x

x

iisApplInvcShadow

APPL_INVC_SHADOW

(NUMBER)

Post Invoice Type

x

boolean

Indicates whether shadow invoices can be posted to the account.

0 - No

1 - Yes

x

x

iisApplInvcNonUSTax

APPL_NON_US_TAX

(NUMBER)

Post Non-US Tax

x

boolean

Indicates whether non-US tax amounts can be posted to the account.

0 - No

1 - Yes

x

x

treeKey

TREE_KEY

(VARCHAR2) (700)

x

string (700)

The chain of primary keys that identifies the parent tree of the account. Used for searching and reporting purposes only.

type

Before TeamConnect 3.3 SP2: typeIID

TYPE_IID

(NUMBER)

Account Type

(General block)

x

Enum

Indicates the account type.

1 - Budget (BUDGET)

2 - Reserve (RESERVE)

x

x

used

TOTAL_USED

(NUMBER)

Total Used

(General block)

x

decimal

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

x

userAccessList-->

n/a

x

EAcctUserAccess

Links to the user security information entered through the Security block of the record.

vendor

Before TeamConnect 3.3 SP2: applVendor

APPL_VENDOR_ID

(NUMBER)

This Vendor

(Posting Criteria block)

x

x

TContact

object

8 Contact specified as the posting criterion for the account.

--> Links to the specific information about the contact object.

x

x

version

VERSION

(NUMBER)

x

int

Indicates how many times the account record was updated.

postedType

POSTED_TYPE_IID

(NUMBER)

x

int

Indicates which types of transactions have previously posted to this account.

0 - None (NONE_POSTED)

1 - Non-shadow (NON_SHADOW_POSTED)

2 - Shadow invoices (SHADOW_POSTED)

x

x