Skip to main content
Mitratech Success Center

JInvcNonUSTax

JInvcNonUSTax contains information about the non-U.S. tax amounts in line items in an invoice record.

Object: JInvcAdjustment (J_INVC_NON_US_TAX)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

primary
Key

PRIMARY_ KEY
(NUMBER)

 

x

   

int

The unique ID of this object.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the object was updated.

   

owner-->

Before TeamCo nnect 3.3 SP2: invoice-- >

INVOICE_
ID (NUMBER)

   

x

TInvoice

object

8 The invoice to which the tax amount 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 tax amount.

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

 

x

 

 

x

 

nonUSTax
Type-->

NON_US_
TAX_TYPE
(NUMBER)

Non-US
Tax Type

 

 

x

 

LInvcNon
USTaxType

object

8 The tax type category associated with the tax amount.

 

x

 

 

x

 

taxAmount

TAX_
AMOUNT
(NUMBER)

Tax Amount

 

x

 

   

decimal

The tax amount in original, local currency.

   

default
Currency
TaxAmount

DEFAULT_ CURR_ TAX_
AMOUNT
(NUMBER)

Tax Amount

 

x

 

   

decimal

The tax amount in the invoice's default currency.

   

LInvcNonUSTaxType

LInvcNonUSTaxType contains information about the tax types available when creating invoice line items containing non-U.S. taxes. This information includes the description of the tax type, tree position, and display order. This table represents the Non-US Tax Type tab in the Invoice object definition in Designer.

Object: LInvcNonUSTaxType (L_INVC_NON_US_TAX_TYPE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

display
Order

DISPLAY_ORDER
(NUMBER)xxxx

Order

 

x

 

   

int

The order in which the items will be listed in the GUI, lowest number first.

   

name

NAME
(VARCHAR2) (50)

Item Name

 

x

 

   

string (50)

The description of the tax type.

   

parent-->

PARENT_ ID
(NUMBER)

Show items in node

 

x

 

 

x

 

LInvcNon
USTaxType

object

8 The parent item of the current item.

--> Links to definition information for the parent tax type.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

 

x

 

   

int

The unique ID of the tax type list item.

   

tree
Position

TREE_
POSITION

(VARCHAR2) (250)

Tree Position

 

x

 

   

string (250)

The unique four- character alphanumeric code that is created when the tax type is defined.

   

version

VERSION
(NUMBER)

 

 

x

 

   

int

Indicates how many times the skill type list item was updated.

   

unique
Code

UNIQUE_ CODE
(VARCHAR2) (250)

Tax Code

 

x

 

   

string (20)

The unique 20- character alphanumeric code that the solution developer specifies when entering a new tax code.

   

JInvcTimekeeperAdjustment

JInvcTimekeeperAdjustment 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: JInvcTimekeeperAdjustment (J_INVC_TIMEKEEPER_ADJUSTMENT)

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 TeamConn ect 3.3
SP2: adjustedOn

ADJUSTED_ ON (DATE)

       

date

Defaults to current date/time.

   

adjustmentMethod

Before TeamConn ect 3.3
SP2: adjustment
TypeIID

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.

   

comments ToVendor

COMMENT_TO_
VENDOR
(VARCHAR 250)

 

 

x

 

   

string (250)

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

   

inHouse
Comments

IN_
HOUSE_
COMMENT<
(VARCHAR 250)

 

 

x

 

   

string (250)

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

   

owner-->

INVOICE_
ID (NUMBER)

   

 

x

 

TInvoice

object

8 The invoice to which the line item belongs.

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

   

previous
NetTotal

PREVIOUS_NET_
TOTAL
(NUMBER)

Original Discount

 

x

 

   

decimal

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

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

 

x

 

   

int

The unique ID of this object.

   

version

VERSION (NUMBER)

 

 

x

 

   

int

Indicates how many times the object was updated.

   

JLitmAdjustment

JLitmAdjustment 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: JILitm Adjustment (J_LITM_ADJUSTMENT)

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 TeamCon nect 3.3 SP2:

adjustedOn

ADJUSTED_ON (DATE)

       

date

Defaults to current date/time.

   

adjustmentMethod

Before TeamCon nect 3.3 SP2:

adjustment
TypeIID

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.

   

adjustment
Target

Before TeamConnect 3.3
SP2: adjustmen tTargetIID

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

   

comments ToVendor

COMMENT_TO_
VENDOR (VARCHAR 2000)

 

x

   

string (2000)

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

   

inHouse
Comments

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

JInvcLine
Item

object

8 The invoice line item to which the adjustment belongs.

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

   

LineItemID

LINEITEM_
ID (NUMBER)

   

x

 

object

8 The invoice line item to which the adjustment belongs.

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

   

previous
NetTotal

PREVIOUS_NET_
TOTAL (NUMBER)

Original Discount

x

   

decimal

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

   

primary
Key

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of this object.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the object was updated.

   
  • Was this article helpful?