Export summary

Note that the same data is identified in different ways at different points in the export process. To summarize, it will be helpful to trace the path of a single piece of data from the database to an output file. For example, a delinquency notice, like most billing correspondence, will include the customer’s account number. The path from the database to the notice is as follows:

In the database, account numbers are stored in the ACCOUNTNUMBER column of the ACCOUNT table.

The business object property that corresponds to the ACCOUNT.ACCOUNTNUMBER column is Hansen.Billing.Account.Number.

To include this property in an export template, you first use the Keyword Manager to add a keyword called KW_Hansen.Billing_Account_Number.

In the section of the export template that defines the structure of the output file, the account number keyword is represented as follows:

<ACCOUNT_NUMBER><IdAccount.KW_Hansen.Billing_Account_Number/></ACCOUNT_NUMBER>

In the data output file, each customer’s account number is displayed between the opening and closing ACCOUNT_NUMBER tags that are defined in the template, such as <ACCOUNT_NUMBER>10001123</ACCOUNT_NUMBER>.

In the stylesheet, finally, an <xsl:value-of> element is used to get the account numbers from the output file:

<xsl:value-of select="HANSEN/DELINQUENCYNOTICE/ACCOUNT_NUMBER"/>