Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

ADJUSTED_BY_ID (NUMBER)

x

x

YUser

Number

8 The user who made the adjustment.

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

x

x

adjustmentDate

Before TeamConnect 3.3 SP2:

adjustedOn

ADJUSTED_ON (DATE)

date

Defaults to current date/time.

adjustmentMethod

Before TeamConnect 3.3 SP2:

adjustmentTypeIID

IS_TAXABLE

(NUMBER)

x

int

Adjustment type. One of these choices:

1 = By Amount

2 = By Percentage

3 = To Amount

adjustmentReason-->

ADJUSTMENT_REASON

(NUMBER)

x

x

object

8 The selected reason for the adjustment.

adjustmentTargetIID

Before TeamConnect 3.3 SP2: adjustmentTarget

ADJUSTMENT_TARGET_ID

(NUMBER)

x

int

The target area to be impacted by the adjustment. One of these choices:

1 = Total Fees

2 = Total Expenses

3 = Total Invoice

adjustmentTotalExpenses

ADJUSTMENT_TOTAL_EXPENSES

(NUMBER)

x

decimal

Adjustment amount to be applied only to the expense portion of the invoice. Calculation is done as specified by attribute adjustmentTypeIID.

adjustmentTotalFees

ADJUSTMENT_TOTAL_FEES

(NUMBER)

x

decimal

Adjustment to be applied only to the fee portion of the invoice. Calculation is done as specified by attribute adjustmentTypeIID.

adjustmentTotalInvoice

ADJUSTMENT_TOTAL_INVOICES

(NUMBER)

x

decimal

Adjustment to be applied to the entire amount of the invoice. Calculation is done as specified by attribute adjustmentTypeIID.

commentsToVendor

COMMENT_TO_VENDOR

(VARCHAR 250))

x

string (250)

Comments about the adjustment that will be visible to vendors outside your company.

inHouseComments

IN_HOUSE_COMMENT<

(VARCHAR 250)

x

string (250)

Comments that are private, not transmitted to vendors or other outside sources.

owner-->

Before TeamConnect 3.3 SP2: invoice-->

INVOICE_ID

(NUMBER)

x

TInvoice

object

8 The invoice to which the line item belongs.

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

previousNetTotal

PREVIOUS_NET_TOTAL

(NUMBER)

Original Discount

x

decimal

The net total of the entire invoice immediately before the current adjustment was applied.

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of this object.

version

VERSION

(NUMBER)

x

int

Indicates how many times the object was updated.