|
1
|
SELECT MAX(A.TYPE_ID) AS N'NHÓM CẤP 1', MAX(A.GROUP_CODE) AS N'MÃ NHÓM VẬT LIỆU', MAX(A.GROUP_NAME) AS N'TÊN NHÓM VẬT LIỆU',
|
|
2
|
MAX(B.GROUP_CODE) AS N'MÃ NHÓM CHA', MAX(B.GROUP_NAME) AS N' NHÓM VẬT LIỆU CHA',MAX(A.UNIT_ID) AS N'ĐƠN VỊ TÍNH', MAX(A.IS_LEAF) AS IS_LEAF,
|
|
3
|
MAX(A.GROUP_LEVEL) AS LEVEL, MAX(A.EXP_ACCTNO) AS EXP_ACCTNO,
|
|
4
|
MAX(A.INC_ACCTNO) AS INC_ACCTNO, MAX(A.LIQ_ACCTNO) AS LIQ_ACCTNO, MAX(A.MATERIAL_ACCTNO) AS MATERIAL_ACCTNO,
|
|
5
|
MAX(A.MATERIAL_ACCTNO_NHNN) AS MATERIAL_ACCTNO_NHNN, MAX(A.VAT_ACCTNO) AS VAT_ACCTNO, MAX(A.NOTES) AS N'GHI CHÚ'
|
|
6
|
FROM MW_GROUP A
|
|
7
|
LEFT JOIN MW_GROUP B ON A.PARENT_ID = B.GROUP_ID
|
|
8
|
GROUP BY A.GROUP_CODE
|
|
9
|
HAVING COUNT (*) =1
|
|
10
|
ORDER BY MAX(A.TYPE_ID) DESC, MAX(A.GROUP_LEVEL)
|
|
11
|
|
|
12
|
SELECT MAX(A.MATERIAL_CODE) AS N' MÃ LOẠI VẬT LIỆU',
|
|
13
|
MAX(A.MATERIAL_NAME) AS N' TÊN LOẠI VẬT LIỆU',
|
|
14
|
MAX(B.GROUP_CODE) AS N'MÃ NHÓM',
|
|
15
|
MAX(B.GROUP_NAME) AS N'TÊN NHÓM',
|
|
16
|
ISNULL(MAX(U.UNIT_NAME),'') AS N'ĐƠN VỊ TÍNH',
|
|
17
|
MAX(A.EXP_ACCTNO) AS N'TÀI KHOẢN CHI PHÍ',
|
|
18
|
MAX(A.MATERIAL_ACCTNO) AS N'TÀI KHOẢN VẬT LIỆU',
|
|
19
|
MAX(A.VAT_ACCTNO) AS N'TÀI KHOẢN VAT',
|
|
20
|
ISNULL(MAX(A.INC_ACCTNO),'') AS N'TÀI KHOẢN GL TREO',
|
|
21
|
ISNULL(MAX(A.LIQ_ACCTNO),'') AS N'TÀI KHOẢN CHI PHÍ THANH LÝ',
|
|
22
|
ISNULL(MAX(A.MATERIAL_ACCTNO_NHNN),'') AS N'TÀI KHOẢN THU NHẬP THANH LÝ '
|
|
23
|
FROM MW_MATERIAL A
|
|
24
|
INNER JOIN MW_GROUP B ON A.GROUP_ID = B.GROUP_ID
|
|
25
|
LEFT JOIN CM_UNIT U ON A.UNIT_ID = U.UNIT_ID
|
|
26
|
GROUP BY A.MATERIAL_CODE
|
|
27
|
HAVING COUNT (*) =1
|