IM Item Gts Helper (GTT)

Out of Scope

Technical: IM_ITEM_GTS_HELPER_GTT | ID: OR-IM-IM_ITEM_GTS_HELPER_GTT-IM_ITEM_GTS_HELPER_GTT

This table is used to hold Item GTS Tax Information from Tax Engine where Reverse Vat Indicator is set to Yes.

See how this object fits into Invoice Matching

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: gtt

Target Structure

Load Approach: Table
Target Objects: IM_ITEM_GTS_HELPER_GTT

Field Definitions(5)

Rules & Considerations(9)

Sample Load Data(4)

_scenario	ID	ITEM	TAX_CODE	TAX_RATE	UOM_TYPE	TAX_CALC_TYPE	REVERSE_TAX_IND	TAX_BASE_AMOUNT	TAX_VALUE_AMOUNT
Example values from field definitions	1	SAMPLE	SAMPLE	1.0000000000	SAMP	S	S	1.0000000000	1.0000000000
default	3	IM Item Gts Helper Gtt-00	ALT-IM	12.5000000000	IM I	P	I	12.5000000000	12.5000000000
default	5	IM Item Gts Helper Gtt-00	EDGE-I	14.0000000000	IM I	P	I	14.0000000000	14.0000000000

Example values from field definitions

ID: 1
ITEM: SAMPLE
TAX_CODE: SAMPLE
TAX_RATE: 1.0000000000
UOM_TYPE: SAMP
TAX_CALC_TYPE: S
REVERSE_TAX_IND: S
TAX_BASE_AMOUNT: 1.0000000000
TAX_VALUE_AMOUNT: 1.0000000000

default

ID: 3
ITEM: IM Item Gts Helper Gtt-00
TAX_CODE: ALT-IM
TAX_RATE: 12.5000000000
UOM_TYPE: IM I
TAX_CALC_TYPE: P
REVERSE_TAX_IND: I
TAX_BASE_AMOUNT: 12.5000000000
TAX_VALUE_AMOUNT: 12.5000000000

default

ID: 5
ITEM: IM Item Gts Helper Gtt-00
TAX_CODE: EDGE-I
TAX_RATE: 14.0000000000
UOM_TYPE: IM I
TAX_CALC_TYPE: P
REVERSE_TAX_IND: I
TAX_BASE_AMOUNT: 14.0000000000
TAX_VALUE_AMOUNT: 14.0000000000

Rule Validation Summary

Source Rule Count: 17
Governed Rule Count: 9