Show/Hide Toolbars

JInvcHeaderAdjustment contains information about the adjustment of line items in an invoice record. This information includes the nature of the adjustment calculation, the reason for the adjustment, and comments about the adjustment.

Object: JInvcHeaderAdjustment (J_INVC_ADJUSTMENT)

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.