Mandateme :UI+backend implementation of request that dynamically generate text file

.
Sp_ Mandatement_Metamodele provides all necessary inputs to create mandement file.

3.2.3 InterfaceGF service (or method)

This service applied transformations to get mandatement file : treatments are applied on Mandatement_Metamodele_service resulset
• Inputs for treatments :
o Mandatement_Metamodele_resultset
o Mand_FormatSettings : general + detailed information for needed mandatement file formatting

a) Create madantement file
b) Header insertion
For current InterfaceGFTypeId , If Mand_FormatSettings.Header isn t empty insert it.
Insert separator field (see Mand_FormatSettings.SeparatorLabel)
For each row in Mandatement_Metamodele_resultset

c) Insert first column

c-1) First column is specified in Mand_FormatSettings.columnOrder. Then Mand_FormatSettings.MetaModelColumnHeader provides the header label to seach in Mandatement_Metamodele_resultset..
c-2) then we apply format (amount, decimal, date) data according its type (Mand_FormatSettings.FieldFormat)
c-3) Insert separator field (see Mand_FormatSettings.SeparatorLabel)

c-4) we move to next Mandatement_Metamodele_resultset row
d) Insert footer if need

3.2.4 Update TA
All rows inserted in mandatement file may generate an update in TA table : Mandatement or Verouillage fields.