Attribute

Database column name

Field in user interface

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

ADJUSTMENT_TYPE_ID

(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.

adjustmentTarget

Before TeamConnect 3.3 SP2: adjustmentTargetIID

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

adjustmentQuantity

ADJUSTMENT_QUANTITY

(NUMBER)

x

decimal

Adjustment quantity to be applied to the existing line item quantity.

adjustmentAmount

ADJUSTMENT_AMOUNTS

(NUMBER)

x

decimal

Adjustment amount to be applied to the line item cost. Calculation is done as specified by attribute adjustmentTypeIID.

commentsToVendor

COMMENT_TO_VENDOR

(VARCHAR 2000)

x

string (2000)

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.

LineItemID

LINEITEM_ID

(NUMBER)

x

JInvcLineItem

object

8 The invoice line item to which the adjustment belongs.

--> Links to the specific information about the line item.

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.