Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CT00200
Product: Manufacturing (346)
Series:
Display Name: IC_COST_Tracked_Changes
Physical Name: CT00200
Technical Name: IC_COST_Tracked_ChangesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['IC_COST_Tracked_Changes'].ITEMNMBR AS 'IC_COST_Tracked_Changes-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
CT00200 AS ['IC_COST_Tracked_Changes']
INNER JOIN
IV00101 AS ['Item Master']
ON
['IC_COST_Tracked_Changes'].ITEMNMBR = ['Item Master'].ITEMNMBR
2 STRNG132 String 132 String STR132 132 3 ITEMDESC Item Description String STR100 100 4 ITEM_COSTS_ARRAY_I_1 Item Costs Array[1] Currency DLR17_RBS0_UTR$ 17 5 ITEM_COSTS_ARRAY_I Item Costs Array DLR17_RBS0_UTR$ Currency 17 6 ITEM_COSTS_ARRAY_I_2 Item Costs Array[2] Currency DLR17_RBS0_UTR$ 17 7 ITEM_COSTS_ARRAY_OLD_I Item Costs Array Old DLR17_RBS0_UTR$ Currency 17 8 ITEM_COSTS_CHANGEARRAY_I Item Costs Change Array DLR17_RBS0_UTR$ Currency 17 9 ITEM_COSTS_ARRAY_I_3 Item Costs Array[3] Currency DLR17_RBS0_UTR$ 17 10 ITEM_COSTS_ARRAY_I_4 Item Costs Array[4] Currency DLR17_RBS0_UTR$ 17 11 ITEM_COSTS_ARRAY_I_5 Item Costs Array[5] Currency DLR17_RBS0_UTR$ 17 12 ITEM_COSTS_ARRAY_I_6 Item Costs Array[6] Currency DLR17_RBS0_UTR$ 17 13 ITEM_COSTS_ARRAY_I_7 Item Costs Array[7] Currency DLR17_RBS0_UTR$ 17 14 ITEM_COSTS_ARRAY_I_8 Item Costs Array[8] Currency DLR17_RBS0_UTR$ 17 15 ITEM_COSTS_ARRAY_I_9 Item Costs Array[9] Currency DLR17_RBS0_UTR$ 17 16 ITEM_COSTS_ARRAY_I_10 Item Costs Array[10] Currency DLR17_RBS0_UTR$ 17 17 ITEM_COSTS_ARRAY_OLD_I_1 Item Costs Array Old[1] Currency DLR17_RBS0_UTR$ 17 18 ITEM_COSTS_ARRAY_OLD_I_2 Item Costs Array Old[2] Currency DLR17_RBS0_UTR$ 17 19 ITEM_COSTS_ARRAY_OLD_I_3 Item Costs Array Old[3] Currency DLR17_RBS0_UTR$ 17 20 ITEM_COSTS_ARRAY_OLD_I_4 Item Costs Array Old[4] Currency DLR17_RBS0_UTR$ 17 21 ITEM_COSTS_ARRAY_OLD_I_5 Item Costs Array Old[5] Currency DLR17_RBS0_UTR$ 17 22 ITEM_COSTS_ARRAY_OLD_I_6 Item Costs Array Old[6] Currency DLR17_RBS0_UTR$ 17 23 ITEM_COSTS_ARRAY_OLD_I_7 Item Costs Array Old[7] Currency DLR17_RBS0_UTR$ 17 24 ITEM_COSTS_ARRAY_OLD_I_8 Item Costs Array Old[8] Currency DLR17_RBS0_UTR$ 17 25 ITEM_COSTS_ARRAY_OLD_I_9 Item Costs Array Old[9] Currency DLR17_RBS0_UTR$ 17 26 ITEM_COSTS_ARRAY_OLD_I_10 Item Costs Array Old[10] Currency DLR17_RBS0_UTR$ 17 27 ITEM_COSTS_CHANGEARRAY_I_1 Item Costs Change Array[1] Currency DLR17_RBS0_UTR$ 17 28 ITEM_COSTS_CHANGEARRAY_I_2 Item Costs Change Array[2] Currency DLR17_RBS0_UTR$ 17 29 ITEM_COSTS_CHANGEARRAY_I_3 Item Costs Change Array[3] Currency DLR17_RBS0_UTR$ 17 30 ITEM_COSTS_CHANGEARRAY_I_4 Item Costs Change Array[4] Currency DLR17_RBS0_UTR$ 17 31 ITEM_COSTS_CHANGEARRAY_I_5 Item Costs Change Array[5] Currency DLR17_RBS0_UTR$ 17 32 ITEM_COSTS_CHANGEARRAY_I_6 Item Costs Change Array[6] Currency DLR17_RBS0_UTR$ 17 33 ITEM_COSTS_CHANGEARRAY_I_7 Item Costs Change Array[7] Currency DLR17_RBS0_UTR$ 17 34 ITEM_COSTS_CHANGEARRAY_I_8 Item Costs Change Array[8] Currency DLR17_RBS0_UTR$ 17 35 ITEM_COSTS_CHANGEARRAY_I_9 Item Costs Change Array[9] Currency DLR17_RBS0_UTR$ 17 36 ITEM_COSTS_CHANGEARRAY_I_10 Item Costs Change Array[10] Currency DLR17_RBS0_UTR$ 17 37 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['IC_COST_Tracked_Changes'].USERID AS 'IC_COST_Tracked_Changes-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CT00200 AS ['IC_COST_Tracked_Changes']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['IC_COST_Tracked_Changes'].USERID = ['Users Master'].USERID
38 CHANGEDATE_I Change Date Date DT 8 39 CHANGETIME_I Change Time Time TM 6