axpense-api/ExpenseDepartmentList.txt at master · UintaGroup/axpense-api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
  --SELECT [DISPLAYVALUE]
  --FROM [DAXSTAGE].[dbo].[DIMENSIONATTRIBUTEVALUESETITEM]
  --WHERE [DIMENSIONATTRIBUTEVALUESETITEM].DIMENSIONATTRIBUTEVALUE IN
  --(
	 -- SELECT [DIMENSIONATTRIBUTEVALUE].RECID
	 -- FROM [DAXSTAGE].[dbo].[DIMENSIONATTRIBUTEVALUE]
	 -- INNER JOIN [DIMENSIONATTRIBUTE] DI on DI.RECID = [DIMENSIONATTRIBUTEVALUE].DIMENSIONATTRIBUTE
	 -- WHERE DI.NAME = 'Department'
  --)
  --GROUP BY [DISPLAYVALUE]
  --ORDER BY [DISPLAYVALU

  DISPLAYVALUE
010
0100
011
012
016
018
019
0200
0202
0204
0206
027
029
030
0300
0302
0304
0306
0308
032
0400
0500
0502
0504
0506
0508
0510
0512
0514
0516
0600
0602
0604
0605
0606
0608
0700
0702
0800
0802
0804
0806
0808
0810
0812
0814
0900
0902
1000
1002
1004
1006
1100
1102
1104

List of current Department:
Dimension value	          Description
0100	                    Management
0200	                    Financial Accounting
0202	                    Cost Accounting
0204	                    Payroll
0206	                    Purchasing
0300	                    Human Resources
0302	                    Bistro
0304	                    Clinic
0306	                    Fitness
0308	                    Training
0400	                    Quality
0500	                    Commercial
0502	                    Retail
0504	                    Creative
0506	                    Product / Brand
0508	                    Digital
0510	                    Demonstration
0512	                    Shipping
0514	                    Sales Operations
0516	                    Customer Service
0600	                    Manufacturing
0602	                    Electrical
0604	                    Residential
0605	                    Commercial
0606	                    Industrial Design Engineering
0608	                    Fabrication Shop
0700	                    Software
0702	                    Systems
0800	                    Blender Assembly
0802	                    Mill / Mixer
0804	                    BDX / Self Serve
0806	                    INM
0808	                    PCB
0810	                    CNC
0812	                    Manual Jars and Armatures
0814	                    Service
0900	                    Maintenance
0902	                    Custodial
1000	                    Production Managers
1002	                    Production Training
1004	                    Production Control
1006	                    Receiving
1100	                    International Business Services
1102	                    Business Development
1104	                    Global Logistics