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