This discussion is archived
1 Reply Latest reply: Dec 28, 2012 11:24 PM by Muthu RSS

add journal batch id and journal name in my query

Muthu Newbie
Currently Being Moderated
Hello all,

I have inserted a line in GL interface which I have been attached below.

insert into GL_INTERFACE (
STATUS, LEDGER_ID, USER_JE_SOURCE_NAME, USER_JE_CATEGORY_NAME,
ACCOUNTING_DATE, CURRENCY_CODE, DATE_CREATED, CREATED_BY,
SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5,
ACTUAL_FLAG, ENTERED_DR, ENTERED_CR, GROUP_ID
*)*
values (
*'NEW', 1, 'Payroll', 'Payroll',*
to_date('DEC-22-2008','MON-DD-YYYY'), 'USD',
to_date('DEC-23-2008','MON-DD-YYYY'), 1092,
*'01', '830', '5300', '0000', '000',*
*'A', 1000.00, 0.00, 12345*
*);*

insert into GL_INTERFACE (
STATUS, LEDGER_ID, USER_JE_SOURCE_NAME, USER_JE_CATEGORY_NAME,
ACCOUNTING_DATE, CURRENCY_CODE, DATE_CREATED, CREATED_BY,
SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5,
ACTUAL_FLAG, ENTERED_DR, ENTERED_CR, GROUP_ID
*)*
values (
*'NEW', 1, 'Payroll', 'Payroll',*
to_date('DEC-22-2008','MON-DD-YYYY'), 'USD',
to_date('DEC-23-2008','MON-DD-YYYY'), 1092,
*'01', '000', '1110', '0000', '000',*
*'A', 0.00, 1000.00, 12345*
*);*


My doubt is, How to add Journal batch name and Journal name in this query. Because I am seeing only batch_id not name.

Please guide me how to achieve.

Thanks and Regards,
Muthu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points