JInvcNonUSTax

Last updated
Save as PDF

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.
isGeneratedOnPost -->	IS_GENERATED_ON_POST					number
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.
isActive -->	IS_ACTIVE					number
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.
adjustmentAmount	ADJUSTMENT_AMOUNT					number
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.
adjustmentTypeID	ADJUSTMENT_TYPE_ID					number
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.
projectID -->	PROJECT_ID					number
timekeeperID -->	TIMEKEEPER_ID					number
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
isReverted -->	IS_REVERTED					number
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.
adjustmentRate	ADJUSTMENT_RATE					number
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 .
adjustmentDiscount	ADJUSTMENT_DISCOUNT					number
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.
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.