Gtt Item Expense Detail

Out of Scope

Technical: GTT_ITEM_EXP_DETAIL | ID: OR-ITM-GTT_ITEM_EXP_DETAIL-GTT_ITEM_EXP_DETAIL

Global Temporary Table to hold the details from itemexp screen.

See how this object fits into Item Management

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
GTT_ITEM_EXP_DETAIL

Field Definitions(5)

Rules & Considerations(19)

Sample Load Data(4)

Example values from field definitions

ITEM
SAMPLE
COMP_ID
SAMPLE
CVB_CODE
SAMPLE
SUPPLIER
1
COMP_RATE
1.0000
PER_COUNT
1.0000
NOM_FLAG_1
S
NOM_FLAG_2
S
NOM_FLAG_3
S
NOM_FLAG_4
S
NOM_FLAG_5
S
KEY_VALUE_1
SAMPLE
KEY_VALUE_2
SAMPLE
ITEM_EXP_SEQ
1
COMP_CURRENCY
SAM
EST_EXP_VALUE
1.0000
ITEM_EXP_TYPE
S
PER_COUNT_UOM
SAMP
DEFAULTED_FROM
SAMPLE

default

ITEM
Gtt Item Exp Detail-002-A
COMP_ID
ALT-GTT_IT
CVB_CODE
ALT-GTT_IT
SUPPLIER
3
COMP_RATE
12.5000
PER_COUNT
12.5000
NOM_FLAG_1
G
NOM_FLAG_2
G
NOM_FLAG_3
G
NOM_FLAG_4
G
NOM_FLAG_5
G
KEY_VALUE_1
Gtt Item E
KEY_VALUE_2
Gtt Item E
ITEM_EXP_SEQ
3
COMP_CURRENCY
Gtt
EST_EXP_VALUE
12.5000
ITEM_EXP_TYPE
G
PER_COUNT_UOM
Gtt
DEFAULTED_FROM
S

default

ITEM
Gtt Item Exp Detail-003-E
COMP_ID
EDGE-GTT_I
CVB_CODE
EDGE-GTT_I
SUPPLIER
5
COMP_RATE
14.0000
PER_COUNT
14.0000
NOM_FLAG_1
G
NOM_FLAG_2
G
NOM_FLAG_3
G
NOM_FLAG_4
G
NOM_FLAG_5
G
KEY_VALUE_1
Gtt Item E
KEY_VALUE_2
Gtt Item E
ITEM_EXP_SEQ
5
COMP_CURRENCY
Gtt
EST_EXP_VALUE
14.0000
ITEM_EXP_TYPE
G
PER_COUNT_UOM
Gtt
DEFAULTED_FROM
C

Rule Validation Summary

Source Rule Count
27
Governed Rule Count
19