1 Reply Latest reply: Dec 29, 2012 1:24 AM by Muthu RSS

    add journal batch id and journal name in my query

    Muthu
      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