Edit

Modify models and mappings to generate documents that have application data

  • Article

To complete the steps in this procedure, you must first complete the procedure, "ER Generate documents with application data update (Part 2: Generate documents)".

The steps in this procedure explain how to design Electronic reporting (ER) configurations to generate an electronic document and update application data. In this procedure, you will modify the ER configurations to start using them to generate electronic documents and update application data. This procedure is created for users with the assigned role of system administrator or electronic reporting developer. These steps can be completed using the DEMF dataset.

Modify data model

  1. Go to Organization administration > Electronic reporting > Configurations.
  2. In the tree, select 'Intrastat (model)'.
    • You will extend how you use the data model. Besides using it as data source to generate the Intrastat report, the data model will be used to collect details about the Intrastat reporting process. The details will then be used to update application data.
  3. Click Designer.
  4. Click New to open the drop dialog.
  5. In the New node as a field, enter 'Model root'.
  6. In the Name field, type 'For application data update'.
    • For application data update
  7. Click Add.
  8. In the tree, select 'For application data update'.
    • This new root item is added to specify the data flow for moving data from the Intrastat report (used as a data source) to the application tables (the update destination). Note that different root items must be used for getting data that is posted to the outgoing document and for getting data from the document that is used to update application data.
  9. Click New to open the drop dialog.
  10. In the Name field, type 'Archive header'.
    • Archive header
  11. In the Item type field, select 'Record list'.
  12. Click Add.
    • Because you will create a record for each Intrastat report that is generated, you must create a new item for that.
  13. Click New to open the drop dialog.
  14. In the Name field, type 'File name'.
    • File name
  15. In the Item type field, select 'String'.
  16. Click Add.
  17. Click New to open the drop dialog.
  18. In the Name field, type 'Number of lines'.
    • Number of lines
  19. In the Item type field, select 'Integer'.
  20. Click Add.
    • Add this item to represent the number of Intrastat transactions that are reported during the current reporting process.
  21. Click New to open the drop dialog.
  22. In the Name field, type 'Archive lines'.
    • Archive lines
  23. In the Item type field, select 'Record list'.
  24. Click Add.
    • Add this item to represent the list of Intrastat transactions that are reported during the current reporting process.
  25. Click New to open the drop dialog.
  26. In the Name field, type 'Amount'.
    • Amount
  27. In the Item type field, select 'Real'.
  28. Click Add.
  29. Click New to open the drop dialog.
  30. In the Name field, type 'Commodity rec id'.
    • Commodity rec id
  31. In the Item type field, select 'Int64'.
  32. Click Add.
  33. Click New to open the drop dialog.
  34. In the Name field, type 'Item number'.
    • Item number
  35. In the Item type field, select 'String'.
  36. Click Add.
  37. Click Save.
  38. Close the page.

Modify model mapping

  1. In the tree, expand 'Intrastat (model)'.
  2. In the tree, select 'Intrastat (model)\Intrastat (mapping)'.
    • Modify the existing model mapping to start using it for the application data update and to archive Intrastat reporting details.
  3. Click Designer.
  4. Click New.
  5. In the Name field, type 'Update archive'.
    • Update archive
  6. In the Direction field, select 'To destination'.
  7. Click Save.
    • This new mapping specifies the data flow for moving data (Intrastat reporting details) from the data model to the application tables (the update destination). Note that different model's root items must be used to get data from the application for the reporting process and then use the data from data model for the application data update.
  8. Click Designer.
  9. In the tree, select 'Data model\Data model'.
    • Add the required data source. This is the data model that contains details of the reported Intrastat transactions that must be archived.
  10. Click Add root.
  11. In the Name field, type 'model'.
    • model
  12. In the Definition field, enter or select the value 'For application data update'.
    • For application data update
  13. Click OK.
  14. In the tree, expand 'model'.
  15. In the tree, select 'Functions\Calculated field'.
  16. In the tree, select 'model\Archive header'.
  17. Click Add.
    • Because you want to enumerate reported Intrastat transactions for archiving, the appropriate data source must be added.
  18. In the Name field, type 'Enumerated lines'.
    • Enumerated lines
  19. Click Edit formula.
  20. In the tree, select 'List\ENUMERATE'.
  21. Click Add function.
  22. In the tree, expand 'model'.
  23. In the tree, expand 'model\Archive header'.
  24. In the tree, select 'model\Archive header\Archive lines'.
  25. Click Add data source.
  26. In the Formula field, enter 'ENUMERATE(model.'Archive header'.'Archive lines')'.
    • ENUMERATE(model.'Archive header'.'Archive lines')
  27. Click Save.
  28. Close the page.
  29. Click OK.
  30. Click Add destination.
    • Add application tables as required destinations that require updates to archive details of reported Intrastat transactions.
  31. In the Name field, type 'Archive'.
    • Archive
  32. In the Table name field, type 'IntrastatArchiveGeneral'.
    • IntrastatArchiveGeneral
    • Keep the record action 'Insert' so you can add records during the detail archiving of each Intrastat reporting process.
  33. Select Yes in the Record infolog field.
    • Select Yes to get information about issues with the application data update.
  34. Select Yes in the Skip record action validation field.
    • Select Yes to suppress validation errors about the empty 'Intrastat archive ID' field. This will be done after records are added, based on the sequence number settings that are configured for this table in the Foreign trade parameters form.
  35. Click OK.
    • Bind elements of the added data source (the filtered model based on the selected root item) with elements from the added destination.
  36. In the tree, expand 'Archive'.
  37. In the tree, expand 'Archive<Relations'.
  38. In the tree, expand 'Archive<Relations\IntrastatArchiveDetail'.
  39. In the tree, select 'Archive<Relations\IntrastatArchiveDetail\Amount(AmountMST)'.
  40. In the tree, expand 'model\Archive header\Enumerated lines'.
  41. In the tree, expand 'model\Archive header\Enumerated lines\Value'.
  42. In the tree, select 'model\Archive header\Enumerated lines\Value\Amount'.
  43. Click Bind.
  44. In the tree, select 'Archive<Relations\IntrastatArchiveDetail\Commodity(IntrastatCommodity)'.
  45. In the tree, select 'model\Archive header\Enumerated lines\Value\Commodity rec id'.
  46. Click Bind.
  47. In the tree, select 'Archive<Relations\IntrastatArchiveDetail\Item number(ItemId)'.
  48. In the tree, select 'model\Archive header\Enumerated lines\Value\Item number'.
  49. Click Bind.
  50. In the tree, select 'Archive<Relations\IntrastatArchiveDetail\Line number(LineNumber)'.
  51. In the tree, select 'model\Archive header\Enumerated lines\Number'.
  52. Click Bind.
  53. In the tree, select 'Archive<Relations\IntrastatArchiveDetail'.
  54. In the tree, select 'model\Archive header\Enumerated lines'.
  55. Click Bind.
  56. In the tree, select 'Archive\File name(FileName)'.
  57. In the tree, select 'model\Archive header\File name'.
  58. Click Bind.
  59. In the tree, select 'Archive\Number of lines(NumberOfLines)'.
  60. In the tree, select 'model\Archive header\Number of lines'.
  61. Click Bind.
  62. In the tree, select 'Archive'.
  63. In the tree, select 'model\Archive header'.
  64. Click Bind.
  65. Click Save.
  66. Close the page.
  67. Close the page.