===========================================================
===========================================================
获得会计期类型
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2007.01.18 11:56
分类: 财务
出处: http://moonsoft.itpub.net/post/15182/252305
---------------------------------------------------------------
(是否为调整期)
SELECT h.period_name, p.*
FROM gl_sets_of_books b, gl_periods p, gl_je_headers h
WHERE h.set_of_books_id = b.set_of_books_id
AND b.period_set_name = p.period_set_name
AND h.period_name = p.period_name
AND h.je_header_id = 108407
SELECT h.period_name, p.*
FROM gl_sets_of_books b, gl_periods p, gl_je_headers h
WHERE h.set_of_books_id = b.set_of_books_id
AND b.period_set_name = p.period_set_name
AND h.period_name = p.period_name
AND h.je_header_id = 108407
