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.

adjustmentAmount

ADJUSTMENT_AMOUNT

(NUMBER)

x

decimal

Adjustment amount.

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.

dcategory-->

CATEGORY_ID

(NUMBER)

Category

object

8 The category fto which this adjustment applies.

x

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.

iowner-->

INVOICE_ID

(NUMBER)

x

TInvoice

object

8 The invoice to which the line item belongs.

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

project-->

PROJECT_ID

(NUMBER)

Project

x

x

TProject

object

8 The project associated with the adjustment.

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

x

x

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.