Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CT00002
Product: Manufacturing (346)
Series:
Display Name: IC COST Standard Item Class Defaults Group Display Name: Manufacturing Inventory
Physical Name: CT00002
Technical Name: IC_COST_IV_STD_Item_Class_SETP
Group Technical Name: Manufacturing Inventory
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | CMPANYID | Company ID | Integer | INT5 | 4 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['IC COST Standard Item Class Defaults'].CMPANYID AS 'IC COST Standard Item Class Defaults-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CT00002 AS ['IC COST Standard Item Class Defaults']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['IC COST Standard Item Class Defaults'].CMPANYID = ['Company Master'].CMPANYID | ||||||
2 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['IC COST Standard Item Class Defaults'].ITEMNMBR AS 'IC COST Standard Item Class Defaults-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
CT00002 AS ['IC COST Standard Item Class Defaults']
INNER JOIN
IV00101 AS ['Item Master']
ON
['IC COST Standard Item Class Defaults'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
3 | ITEMDESC | Item Description | String | STR100 | 100 | |
4 | ITMCLSCD | Item Class Code | String | STR10_Class_ID | 10 | |
Key to the Item Class Setup (IV40400).
Click to show/hideSELECT
['IC COST Standard Item Class Defaults'].ITMCLSCD AS 'IC COST Standard Item Class Defaults-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
CT00002 AS ['IC COST Standard Item Class Defaults']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['IC COST Standard Item Class Defaults'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD | ||||||
5 | ITMCLSDC | Item Class Description | String | STR30 | 30 | |
6 | DEFLTCLS | Default Class | Boolean | CB_Default | 0 | |
7 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['IC COST Standard Item Class Defaults'].NOTEINDX AS 'IC COST Standard Item Class Defaults-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CT00002 AS ['IC COST Standard Item Class Defaults']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['IC COST Standard Item Class Defaults'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
8 | ITEMTYPE | Item Type | Integer | DDL_Item_Type | 0 | |
9 | LOTTYPE | Lot Type | String | STR10_Lot_Type | 10 | |
10 | KPERHIST | Keep Period History | Boolean | CB_Keep_Period_History | 0 | |
11 | KPTRXHST | Keep Trx History | Boolean | CB_Keep_Trx_History | 0 | |
12 | KPCALHST | Keep Calendar History | Boolean | CB_Keep_Calendar_History | 0 | |
13 | KPDSTHST | Keep Distribution History | Boolean | CB_Keep_Dist_History | 0 | |
14 | ALWBKORD | Allow Back Orders | Boolean | CB_Allow_Back_Orders | 0 | |
15 | ITMGEDSC | Item Generic Description | String | STR10 | 10 | |
16 | TAXOPTNS | Tax Options | Integer | DDL_Tax_Options | 0 | |
17 | ITMTSHID | Item Tax Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['IC COST Standard Item Class Defaults'].ITMTSHID AS 'IC COST Standard Item Class Defaults-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CT00002 AS ['IC COST Standard Item Class Defaults']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['IC COST Standard Item Class Defaults'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
18 | COMMCODE | Commission Code | String | STR15_LBAU | 15 | |
19 | UOMSCHDL | U Of M Schedule | String | STR10_Schedule | 10 | |
Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hideSELECT
['IC COST Standard Item Class Defaults'].UOMSCHDL AS 'IC COST Standard Item Class Defaults-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
CT00002 AS ['IC COST Standard Item Class Defaults']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['IC COST Standard Item Class Defaults'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL | ||||||
20 | VCTNMTHD | Valuation Method | Integer | DDL_Valuation_Method | 0 | |
21 | USCATVLS | User Category Values | User_Category_Value | String | 10 | |
22 | USCATVLS_1 | User Category Values[1] | String | User_Category_Value | 10 | |
23 | USCATVLS_2 | User Category Values[2] | String | User_Category_Value | 10 | |
24 | USCATVLS_3 | User Category Values[3] | String | User_Category_Value | 10 | |
25 | USCATVLS_4 | User Category Values[4] | String | User_Category_Value | 10 | |
26 | USCATVLS_5 | User Category Values[5] | String | User_Category_Value | 10 | |
27 | USCATVLS_6 | User Category Values[6] | String | User_Category_Value | 10 | |
28 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 | |
29 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 | |
30 | ICIVICOFDI | IC IV Item Class Ohead Fixed Dollars | Currency | DLR17_RBS0_UTR$ | 17 | |
31 | ICIVICOFPI | IC IV Item Class Ohead Fixed Percent | Long Integer | INTXXX.XXXXX% | 8 | |
32 | ICIVOUSEI | IC IV Overhead Use | CB | Boolean | 0 | |
33 | ICIVOGRPI | IC IV Overhead Grouping | RB_Overheard_Group | Integer | 0 | |
34 | ICIVICOVDI | IC IV Item Class Ohead Var Dollars | Currency | DLR17_RBS0_UTR$ | 17 | |
35 | ICIVICOVPI | IC IV Item Class Ohead Var Percent | Long Integer | INTXXX.XXXXX% | 8 | |
36 | ICIVICOFDOPI | IC IV Item Class Fixed Dollars or Percent | Integer | GB | 0 | |
37 | ICIVICVDOPI | IC IV Item Class Var Dollars or Percent | Integer | GB | 0 | |
38 | ICIVOUSEI_1 | IC IV Overhead Use[1] | Boolean | CB | 0 | |
39 | ICIVOUSEI_2 | IC IV Overhead Use[2] | Boolean | CB | 0 | |
40 | ICIVOUSEI_3 | IC IV Overhead Use[3] | Boolean | CB | 0 | |
41 | ICIVOUSEI_4 | IC IV Overhead Use[4] | Boolean | CB | 0 | |
42 | ICIVOUSEI_5 | IC IV Overhead Use[5] | Boolean | CB | 0 | |
43 | ICIVOUSEI_6 | IC IV Overhead Use[6] | Boolean | CB | 0 | |
44 | ICIVOUSEI_7 | IC IV Overhead Use[7] | Boolean | CB | 0 | |
45 | ICIVOUSEI_8 | IC IV Overhead Use[8] | Boolean | CB | 0 | |
46 | ICIVOUSEI_9 | IC IV Overhead Use[9] | Boolean | CB | 0 | |
47 | ICIVOUSEI_10 | IC IV Overhead Use[10] | Boolean | CB | 0 | |
48 | ICIVOUSEI_11 | IC IV Overhead Use[11] | Boolean | CB | 0 | |
49 | ICIVOUSEI_12 | IC IV Overhead Use[12] | Boolean | CB | 0 | |
50 | ICIVOUSEI_13 | IC IV Overhead Use[13] | Boolean | CB | 0 | |
51 | ICIVOUSEI_14 | IC IV Overhead Use[14] | Boolean | CB | 0 | |
52 | ICIVOUSEI_15 | IC IV Overhead Use[15] | Boolean | CB | 0 | |
53 | ICIVOUSEI_16 | IC IV Overhead Use[16] | Boolean | CB | 0 | |
54 | ICIVOUSEI_17 | IC IV Overhead Use[17] | Boolean | CB | 0 | |
55 | ICIVOUSEI_18 | IC IV Overhead Use[18] | Boolean | CB | 0 | |
56 | ICIVOUSEI_19 | IC IV Overhead Use[19] | Boolean | CB | 0 | |
57 | ICIVOUSEI_20 | IC IV Overhead Use[20] | Boolean | CB | 0 | |
58 | ICIVOUSEI_21 | IC IV Overhead Use[21] | Boolean | CB | 0 | |
59 | ICIVOUSEI_22 | IC IV Overhead Use[22] | Boolean | CB | 0 | |
60 | ICIVOUSEI_23 | IC IV Overhead Use[23] | Boolean | CB | 0 | |
61 | ICIVOUSEI_24 | IC IV Overhead Use[24] | Boolean | CB | 0 | |
62 | ICIVOUSEI_25 | IC IV Overhead Use[25] | Boolean | CB | 0 | |
63 | ICIVOUSEI_26 | IC IV Overhead Use[26] | Boolean | CB | 0 | |
64 | ICIVOUSEI_27 | IC IV Overhead Use[27] | Boolean | CB | 0 | |
65 | ICIVOUSEI_28 | IC IV Overhead Use[28] | Boolean | CB | 0 | |
66 | ICIVOUSEI_29 | IC IV Overhead Use[29] | Boolean | CB | 0 | |
67 | ICIVOUSEI_30 | IC IV Overhead Use[30] | Boolean | CB | 0 | |
68 | ICIVOUSEI_31 | IC IV Overhead Use[31] | Boolean | CB | 0 | |
69 | ICIVOUSEI_32 | IC IV Overhead Use[32] | Boolean | CB | 0 | |
70 | ICIVOUSEI_33 | IC IV Overhead Use[33] | Boolean | CB | 0 | |
71 | ICIVOUSEI_34 | IC IV Overhead Use[34] | Boolean | CB | 0 | |
72 | ICIVOUSEI_35 | IC IV Overhead Use[35] | Boolean | CB | 0 | |
73 | ICIVOGRPI_1 | IC IV Overhead Grouping[1] | Integer | RB_Overheard_Group | 0 | |
74 | ICIVOGRPI_2 | IC IV Overhead Grouping[2] | Integer | RB_Overheard_Group | 0 | |
75 | ICIVOGRPI_3 | IC IV Overhead Grouping[3] | Integer | RB_Overheard_Group | 0 | |
76 | ICIVOGRPI_4 | IC IV Overhead Grouping[4] | Integer | RB_Overheard_Group | 0 | |
77 | ICIVOGRPI_5 | IC IV Overhead Grouping[5] | Integer | RB_Overheard_Group | 0 | |
78 | PRCLEVEL | PriceLevel | String | STR10_LBAU | 10 | |
79 | MODIFDT | Modified Date | Date | DT | 8 | |
80 | MDFUSRID | Modified User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['IC COST Standard Item Class Defaults'].MDFUSRID AS 'IC COST Standard Item Class Defaults-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CT00002 AS ['IC COST Standard Item Class Defaults']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['IC COST Standard Item Class Defaults'].MDFUSRID = ['Users Master'].USERID |