JC_Default_Cost_Codes_SETP (JC40304)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Default_Cost_Codes_SETP (JC40304)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC40304

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_Default_Cost_Codes_SETP
Physical Name: JC40304
Technical Name: JC_Default_Cost_Codes_SETP

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Divisions SearchDivisionsSTR15_LBAUString1615
2CB_Trade_Discount SearchCB Trade DiscountCB_Trade_DiscountBoolean20
3FREIGHT SearchFreightCB_FreightBoolean20
4MISC SearchMiscCB_MiscBoolean20
5TAX SearchTaxCB_TaxBoolean20
6Cost_Code_Number_Array_1_1 SearchCost Code Number Array[1]:CC_PhaseSTR6_CC_PhaseString86
7Cost_Code_Number_Array_1_2 SearchCost Code Number Array[1]:CC_StepSTR6_CC_StepsString86
8Cost_Code_Number_Array_1_3 SearchCost Code Number Array[1]:CC_DetailSTR6_CC_DetailString86
9Cost_Code_Number_Array_1_4 SearchCost Code Number Array[1]:CC_ComponentSTR6_CC_ComponentString86
10Cost_Code_Number_Array_2_1 SearchCost Code Number Array[2]:CC_PhaseSTR6_CC_PhaseString86
11Cost_Code_Number_Array_2_2 SearchCost Code Number Array[2]:CC_StepSTR6_CC_StepsString86
12Cost_Code_Number_Array_2_3 SearchCost Code Number Array[2]:CC_DetailSTR6_CC_DetailString86
13Cost_Code_Number_Array_2_4 SearchCost Code Number Array[2]:CC_ComponentSTR6_CC_ComponentString86
14Cost_Code_Number_Array_3_1 SearchCost Code Number Array[3]:CC_PhaseSTR6_CC_PhaseString86
15Cost_Code_Number_Array_3_2 SearchCost Code Number Array[3]:CC_StepSTR6_CC_StepsString86
16Cost_Code_Number_Array_3_3 SearchCost Code Number Array[3]:CC_DetailSTR6_CC_DetailString86
17Cost_Code_Number_Array_3_4 SearchCost Code Number Array[3]:CC_ComponentSTR6_CC_ComponentString86
18Cost_Code_Number_Array_4_1 SearchCost Code Number Array[4]:CC_PhaseSTR6_CC_PhaseString86
19Cost_Code_Number_Array_4_2 SearchCost Code Number Array[4]:CC_StepSTR6_CC_StepsString86
20Cost_Code_Number_Array_4_3 SearchCost Code Number Array[4]:CC_DetailSTR6_CC_DetailString86
21Cost_Code_Number_Array_4_4 SearchCost Code Number Array[4]:CC_ComponentSTR6_CC_ComponentString86
22Cost_Code_Number_Array_5_1 SearchCost Code Number Array[5]:CC_PhaseSTR6_CC_PhaseString86
23Cost_Code_Number_Array_5_2 SearchCost Code Number Array[5]:CC_StepSTR6_CC_StepsString86
24Cost_Code_Number_Array_5_3 SearchCost Code Number Array[5]:CC_DetailSTR6_CC_DetailString86
25Cost_Code_Number_Array_5_4 SearchCost Code Number Array[5]:CC_ComponentSTR6_CC_ComponentString86
26Cost_Code_Number_Array_6_1 SearchCost Code Number Array[6]:CC_PhaseSTR6_CC_PhaseString86
27Cost_Code_Number_Array_6_2 SearchCost Code Number Array[6]:CC_StepSTR6_CC_StepsString86
28Cost_Code_Number_Array_6_3 SearchCost Code Number Array[6]:CC_DetailSTR6_CC_DetailString86
29Cost_Code_Number_Array_6_4 SearchCost Code Number Array[6]:CC_ComponentSTR6_CC_ComponentString86
30Cost_Code_Number_Array_7_1 SearchCost Code Number Array[7]:CC_PhaseSTR6_CC_PhaseString86
31Cost_Code_Number_Array_7_2 SearchCost Code Number Array[7]:CC_StepSTR6_CC_StepsString86
32Cost_Code_Number_Array_7_3 SearchCost Code Number Array[7]:CC_DetailSTR6_CC_DetailString86
33Cost_Code_Number_Array_7_4 SearchCost Code Number Array[7]:CC_ComponentSTR6_CC_ComponentString86
34Cost_Code_Number_Array_8_1 SearchCost Code Number Array[8]:CC_PhaseSTR6_CC_PhaseString86
35Cost_Code_Number_Array_8_2 SearchCost Code Number Array[8]:CC_StepSTR6_CC_StepsString86
36Cost_Code_Number_Array_8_3 SearchCost Code Number Array[8]:CC_DetailSTR6_CC_DetailString86
37Cost_Code_Number_Array_8_4 SearchCost Code Number Array[8]:CC_ComponentSTR6_CC_ComponentString86
38Cost_Code_Number_Array_9_1 SearchCost Code Number Array[9]:CC_PhaseSTR6_CC_PhaseString86
39Cost_Code_Number_Array_9_2 SearchCost Code Number Array[9]:CC_StepSTR6_CC_StepsString86
40Cost_Code_Number_Array_9_3 SearchCost Code Number Array[9]:CC_DetailSTR6_CC_DetailString86
41Cost_Code_Number_Array_9_4 SearchCost Code Number Array[9]:CC_ComponentSTR6_CC_ComponentString86
42Cost_Code_Number_Array_10_1 SearchCost Code Number Array[10]:CC_PhaseSTR6_CC_PhaseString86
43Cost_Code_Number_Array_10_2 SearchCost Code Number Array[10]:CC_StepSTR6_CC_StepsString86
44Cost_Code_Number_Array_10_3 SearchCost Code Number Array[10]:CC_DetailSTR6_CC_DetailString86
45Cost_Code_Number_Array_10_4 SearchCost Code Number Array[10]:CC_ComponentSTR6_CC_ComponentString86
46Cost_Element_Array_1 SearchCost Element Array[1]INT3_RB0_UInteger23
47Cost_Element_Array_2 SearchCost Element Array[2]INT3_RB0_UInteger23
48Cost_Element_Array_3 SearchCost Element Array[3]INT3_RB0_UInteger23
49Cost_Element_Array_4 SearchCost Element Array[4]INT3_RB0_UInteger23
50Cost_Element_Array_5 SearchCost Element Array[5]INT3_RB0_UInteger23
51Cost_Element_Array_6 SearchCost Element Array[6]INT3_RB0_UInteger23
52Cost_Element_Array_7 SearchCost Element Array[7]INT3_RB0_UInteger23
53Cost_Element_Array_8 SearchCost Element Array[8]INT3_RB0_UInteger23
54Cost_Element_Array_9 SearchCost Element Array[9]INT3_RB0_UInteger23
55Cost_Element_Array_10 SearchCost Element Array[10]INT3_RB0_UInteger23
56Cost_Code_Desc_Array_1 SearchCost Code Description Array[1]STR30String3230
57Cost_Code_Desc_Array_2 SearchCost Code Description Array[2]STR30String3230
58Cost_Code_Desc_Array_3 SearchCost Code Description Array[3]STR30String3230
59Cost_Code_Desc_Array_4 SearchCost Code Description Array[4]STR30String3230
60Cost_Code_Desc_Array_5 SearchCost Code Description Array[5]STR30String3230
61Cost_Code_Desc_Array_6 SearchCost Code Description Array[6]STR30String3230
62Cost_Code_Desc_Array_7 SearchCost Code Description Array[7]STR30String3230
63Cost_Code_Desc_Array_8 SearchCost Code Description Array[8]STR30String3230
64Cost_Code_Desc_Array_9 SearchCost Code Description Array[9]STR30String3230
65Cost_Code_Desc_Array_10 SearchCost Code Description Array[10]STR30String3230
66CC_Account_Index_Array_1 SearchCC Account Index Array[1]LI_14Long Integer414
67CC_Account_Index_Array_2 SearchCC Account Index Array[2]LI_14Long Integer414
68CC_Account_Index_Array_3 SearchCC Account Index Array[3]LI_14Long Integer414
69CC_Account_Index_Array_4 SearchCC Account Index Array[4]LI_14Long Integer414
70CC_Account_Index_Array_5 SearchCC Account Index Array[5]LI_14Long Integer414
71CC_Account_Index_Array_6 SearchCC Account Index Array[6]LI_14Long Integer414
72CC_Account_Index_Array_7 SearchCC Account Index Array[7]LI_14Long Integer414
73CC_Account_Index_Array_8 SearchCC Account Index Array[8]LI_14Long Integer414
74CC_Account_Index_Array_9 SearchCC Account Index Array[9]LI_14Long Integer414
75CC_Account_Index_Array_10 SearchCC Account Index Array[10]LI_14Long Integer414
76USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Default_Cost_Codes_SETP'].USERID AS 'JC_Default_Cost_Codes_SETP-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC40304 AS ['JC_Default_Cost_Codes_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Default_Cost_Codes_SETP'].USERID = ['Users Master'].USERID
77User_Define_1 SearchUser Define 1STR30String3230
78User_Define_2 SearchUser Define 2STR30String3230
79USERDEF1 SearchUser Defined 1STR20String2220
80USERDEF2 SearchUser Defined 2STR20String2220
81User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
82User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
83User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
84User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
85USRDAT01 SearchUser Defined Date 1DTDate48
86USRDAT02 SearchUser Defined Date 2DTDate48
87User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
88User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
89User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
90User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
91User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
92User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
93User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
94User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
95User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
96User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
97Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
98Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
99Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
100SV_Language_ID SearchSV Language IDINT2Integer22
101Time_Zone SearchTime ZoneSTR3String43
102MODIFDT SearchModified DateDTDate48
103Modified_Time SearchModified TimeTM6Time46
104MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Default_Cost_Codes_SETP'].MDFUSRID AS 'JC_Default_Cost_Codes_SETP-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC40304 AS ['JC_Default_Cost_Codes_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Default_Cost_Codes_SETP'].MDFUSRID = ['Users Master'].USERID
105WSReserved_CB1 SearchWSReserved CB1CBBoolean20
106WSReserved_CB2 SearchWSReserved CB2CBBoolean20
107WSReserved_CB3 SearchWSReserved CB3CBBoolean20
108WSReserved_CB4 SearchWSReserved CB4CBBoolean20
109WSReserved_CB5 SearchWSReserved CB5CBBoolean20
110WSReserved_STR1 SearchWSReserved STR1STR10String1210
111WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartyJC_Default_Cost_Codes_SETP (JC40304)

Leave a Reply

Your email address will not be published. Required fields are marked *