Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Peter Ireland
    eText Header Record
    Topic posted July 17, 2017 by Peter Ireland, last edited July 17, 2017, tagged BI Publisher, Fusion Financial reporting, OBIEE Answers, OTBI, Reports 
    66 Views
    Title:
    eText Header Record
    Summary:
    I need to create a header record in an fixed position eText Template.
    Content:

    I need to create a header record in an fixed position eText Template.

    Which contains the following but it doesn't relate to a SQL query in the data model as per the other data in the Template

    <LEVEL>

    Header

    <POSITION>

    <LENGTH>

    <FORMAT>

    <PAD>

    <DATA>

    <COMMENTS>

    <NEW RECORD>

    Header

    1

    1

    Number

     

    ‘2’

    Record Type

    2

    6

    Alpha

     

    ‘CUST1’

    Customer ID

    8

    8

    Date, yyyymmdd

     

    SYSDATE

    Creation Date

    16

    28

    Number

    L, ‘ ‘

     

    Filler

    <END LEVEL>

    Header

    It is showing no data.

    Thanks

    Comment