===========================================================
===========================================================
死马当活马医： 后台插入GL HEADERS数据
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2008.01.08 18:07
分类: 财务
出处: http://moonsoft.itpub.net/post/15182/450448
---------------------------------------------------------------
这些是必输栏位
SELECT gir.*
FROM
gl_import_references gir
WHERE gir.je_header_id=4049
select sum(entered_dr), sum(entered_cr), sum(accounted_dr), sum(accounted_dr)
from gl_je_lines jl
where jl.je_header_id=4218
/* Formatted on 2008/01/08 17:49 (Formatter Plus v4.8.7) */
--4049
INSERT INTO gl_je_headers
(je_header_id, NAME, je_batch_id, period_name, je_source,
je_category, doc_sequence_id, doc_sequence_value,
set_of_books_id, currency_code, status, date_created,
accrual_rev_flag, multi_bal_seg_flag, actual_flag,
default_effective_date, tax_status_code,
accrual_rev_change_sign_flag, running_total_dr,
running_total_cr, running_total_accounted_dr,
running_total_accounted_cr, currency_conversion_rate,
currency_conversion_type, currency_conversion_date,
last_update_date, last_updated_by, creation_date, created_by,
last_update_login
)
VALUES (4049, 'MTL CNY', 8610, '2007-12', 'Inventory',
'MTL', 28, 1573,
1001, 'CNY', 'P', TO_DATE ('2007-12-17', 'YYYY-MM-DD'),
'N', 'N', 'A',
TO_DATE ('2007-12-17', 'YYYY-MM-DD'), 'N',
'N', 19184.11,
19184.11, 19184.11,
19184.11, 1,
'User', ('2007-12-17', 'YYYY-MM-DD'),
SYSDATE, 0, ('2007-12-17', 'YYYY-MM-DD'), 0,
-1
)
