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 TypeLength
1Divisions SearchDivisionsSTR15_LBAUString15
2CB_Trade_Discount SearchCB Trade DiscountCB_Trade_DiscountBoolean0
3FREIGHT SearchFreightCB_FreightBoolean0
4MISC SearchMiscCB_MiscBoolean0
5TAX SearchTaxCB_TaxBoolean0
6Cost_Code_Number_Array_1_1 SearchCost Code Number Array[1]:CC_PhaseSTR6_CC_PhaseString6
7Cost_Code_Number_Array_1_2 SearchCost Code Number Array[1]:CC_StepSTR6_CC_StepsString6
8Cost_Code_Number_Array_1_3 SearchCost Code Number Array[1]:CC_DetailSTR6_CC_DetailString6
9Cost_Code_Number_Array_1_4 SearchCost Code Number Array[1]:CC_ComponentSTR6_CC_ComponentString6
10Cost_Code_Number_Array_2_1 SearchCost Code Number Array[2]:CC_PhaseSTR6_CC_PhaseString6
11Cost_Code_Number_Array_2_2 SearchCost Code Number Array[2]:CC_StepSTR6_CC_StepsString6
12Cost_Code_Number_Array_2_3 SearchCost Code Number Array[2]:CC_DetailSTR6_CC_DetailString6
13Cost_Code_Number_Array_2_4 SearchCost Code Number Array[2]:CC_ComponentSTR6_CC_ComponentString6
14Cost_Code_Number_Array_3_1 SearchCost Code Number Array[3]:CC_PhaseSTR6_CC_PhaseString6
15Cost_Code_Number_Array_3_2 SearchCost Code Number Array[3]:CC_StepSTR6_CC_StepsString6
16Cost_Code_Number_Array_3_3 SearchCost Code Number Array[3]:CC_DetailSTR6_CC_DetailString6
17Cost_Code_Number_Array_3_4 SearchCost Code Number Array[3]:CC_ComponentSTR6_CC_ComponentString6
18Cost_Code_Number_Array_4_1 SearchCost Code Number Array[4]:CC_PhaseSTR6_CC_PhaseString6
19Cost_Code_Number_Array_4_2 SearchCost Code Number Array[4]:CC_StepSTR6_CC_StepsString6
20Cost_Code_Number_Array_4_3 SearchCost Code Number Array[4]:CC_DetailSTR6_CC_DetailString6
21Cost_Code_Number_Array_4_4 SearchCost Code Number Array[4]:CC_ComponentSTR6_CC_ComponentString6
22Cost_Code_Number_Array_5_1 SearchCost Code Number Array[5]:CC_PhaseSTR6_CC_PhaseString6
23Cost_Code_Number_Array_5_2 SearchCost Code Number Array[5]:CC_StepSTR6_CC_StepsString6
24Cost_Code_Number_Array_5_3 SearchCost Code Number Array[5]:CC_DetailSTR6_CC_DetailString6
25Cost_Code_Number_Array_5_4 SearchCost Code Number Array[5]:CC_ComponentSTR6_CC_ComponentString6
26Cost_Code_Number_Array_6_1 SearchCost Code Number Array[6]:CC_PhaseSTR6_CC_PhaseString6
27Cost_Code_Number_Array_6_2 SearchCost Code Number Array[6]:CC_StepSTR6_CC_StepsString6
28Cost_Code_Number_Array_6_3 SearchCost Code Number Array[6]:CC_DetailSTR6_CC_DetailString6
29Cost_Code_Number_Array_6_4 SearchCost Code Number Array[6]:CC_ComponentSTR6_CC_ComponentString6
30Cost_Code_Number_Array_7_1 SearchCost Code Number Array[7]:CC_PhaseSTR6_CC_PhaseString6
31Cost_Code_Number_Array_7_2 SearchCost Code Number Array[7]:CC_StepSTR6_CC_StepsString6
32Cost_Code_Number_Array_7_3 SearchCost Code Number Array[7]:CC_DetailSTR6_CC_DetailString6
33Cost_Code_Number_Array_7_4 SearchCost Code Number Array[7]:CC_ComponentSTR6_CC_ComponentString6
34Cost_Code_Number_Array_8_1 SearchCost Code Number Array[8]:CC_PhaseSTR6_CC_PhaseString6
35Cost_Code_Number_Array_8_2 SearchCost Code Number Array[8]:CC_StepSTR6_CC_StepsString6
36Cost_Code_Number_Array_8_3 SearchCost Code Number Array[8]:CC_DetailSTR6_CC_DetailString6
37Cost_Code_Number_Array_8_4 SearchCost Code Number Array[8]:CC_ComponentSTR6_CC_ComponentString6
38Cost_Code_Number_Array_9_1 SearchCost Code Number Array[9]:CC_PhaseSTR6_CC_PhaseString6
39Cost_Code_Number_Array_9_2 SearchCost Code Number Array[9]:CC_StepSTR6_CC_StepsString6
40Cost_Code_Number_Array_9_3 SearchCost Code Number Array[9]:CC_DetailSTR6_CC_DetailString6
41Cost_Code_Number_Array_9_4 SearchCost Code Number Array[9]:CC_ComponentSTR6_CC_ComponentString6
42Cost_Code_Number_Array_10_1 SearchCost Code Number Array[10]:CC_PhaseSTR6_CC_PhaseString6
43Cost_Code_Number_Array_10_2 SearchCost Code Number Array[10]:CC_StepSTR6_CC_StepsString6
44Cost_Code_Number_Array_10_3 SearchCost Code Number Array[10]:CC_DetailSTR6_CC_DetailString6
45Cost_Code_Number_Array_10_4 SearchCost Code Number Array[10]:CC_ComponentSTR6_CC_ComponentString6
46Cost_Element_Array_1 SearchCost Element Array[1]INT3_RB0_UInteger3
47Cost_Element_Array_2 SearchCost Element Array[2]INT3_RB0_UInteger3
48Cost_Element_Array_3 SearchCost Element Array[3]INT3_RB0_UInteger3
49Cost_Element_Array_4 SearchCost Element Array[4]INT3_RB0_UInteger3
50Cost_Element_Array_5 SearchCost Element Array[5]INT3_RB0_UInteger3
51Cost_Element_Array_6 SearchCost Element Array[6]INT3_RB0_UInteger3
52Cost_Element_Array_7 SearchCost Element Array[7]INT3_RB0_UInteger3
53Cost_Element_Array_8 SearchCost Element Array[8]INT3_RB0_UInteger3
54Cost_Element_Array_9 SearchCost Element Array[9]INT3_RB0_UInteger3
55Cost_Element_Array_10 SearchCost Element Array[10]INT3_RB0_UInteger3
56Cost_Code_Desc_Array_1 SearchCost Code Description Array[1]STR30String30
57Cost_Code_Desc_Array_2 SearchCost Code Description Array[2]STR30String30
58Cost_Code_Desc_Array_3 SearchCost Code Description Array[3]STR30String30
59Cost_Code_Desc_Array_4 SearchCost Code Description Array[4]STR30String30
60Cost_Code_Desc_Array_5 SearchCost Code Description Array[5]STR30String30
61Cost_Code_Desc_Array_6 SearchCost Code Description Array[6]STR30String30
62Cost_Code_Desc_Array_7 SearchCost Code Description Array[7]STR30String30
63Cost_Code_Desc_Array_8 SearchCost Code Description Array[8]STR30String30
64Cost_Code_Desc_Array_9 SearchCost Code Description Array[9]STR30String30
65Cost_Code_Desc_Array_10 SearchCost Code Description Array[10]STR30String30
66CC_Account_Index_Array_1 SearchCC Account Index Array[1]LI_14Long Integer14
67CC_Account_Index_Array_2 SearchCC Account Index Array[2]LI_14Long Integer14
68CC_Account_Index_Array_3 SearchCC Account Index Array[3]LI_14Long Integer14
69CC_Account_Index_Array_4 SearchCC Account Index Array[4]LI_14Long Integer14
70CC_Account_Index_Array_5 SearchCC Account Index Array[5]LI_14Long Integer14
71CC_Account_Index_Array_6 SearchCC Account Index Array[6]LI_14Long Integer14
72CC_Account_Index_Array_7 SearchCC Account Index Array[7]LI_14Long Integer14
73CC_Account_Index_Array_8 SearchCC Account Index Array[8]LI_14Long Integer14
74CC_Account_Index_Array_9 SearchCC Account Index Array[9]LI_14Long Integer14
75CC_Account_Index_Array_10 SearchCC Account Index Array[10]LI_14Long Integer14
76USERID SearchUser IDSTR15_User_IDString15
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 1STR30String30
78User_Define_2 SearchUser Define 2STR30String30
79USERDEF1 SearchUser Defined 1STR20String20
80USERDEF2 SearchUser Defined 2STR20String20
81User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
82User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
83User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
84User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
85USRDAT01 SearchUser Defined Date 1DTDate8
86USRDAT02 SearchUser Defined Date 2DTDate8
87User_Defined_Date_3 SearchWS User Defined Date 3DATEDate6
88User_Defined_Date_4 SearchWS User Defined Date 4DATEDate6
89User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
90User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
91User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
92User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
93User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
94User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
95User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
96User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
97Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
98Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
99Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
100SV_Language_ID SearchSV Language IDINT2Integer2
101Time_Zone SearchTime ZoneSTR3String3
102MODIFDT SearchModified DateDTDate8
103Modified_Time SearchModified TimeTM6Time6
104MDFUSRID SearchModified User IDSTR15String15
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 CB1CBBoolean0
106WSReserved_CB2 SearchWSReserved CB2CBBoolean0
107WSReserved_CB3 SearchWSReserved CB3CBBoolean0
108WSReserved_CB4 SearchWSReserved CB4CBBoolean0
109WSReserved_CB5 SearchWSReserved CB5CBBoolean0
110WSReserved_STR1 SearchWSReserved STR1STR10String10
111WSReserved_STR2 SearchWSReserved STR2STR10String10
azurecurveProductsWennSoft Products (131)3rd PartyJC_Default_Cost_Codes_SETP (JC40304)

Leave a Reply

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