All formula fields of the apportionment group binding file have the following features in common that must be noted in their use.
If a entity code is entered, a simple text must be written between inverted commas.
The fields of table CTQ (Off-line Apportionment File) are available in the formulas use as long as they are referenced through alias “M->”
Standard functions or the ones defined by the users can be used by using its direct call with parameters passing.
Types of formula usage:
Expression to define the description concatenating with the apportionment file code to be generated. | |
Field | Description (CW2_DESCRI) |
Expression | “RATEIO “+M->CTQ_RATEIO |
Expression to define the double entry depending on the origin | |
Field | Double Entry (CW2_CT1PAR) |
Expression | IIF(M->CTQ_CT1ORI == “31”,”91”,”92”) |
Definition of user function for factor formula | |
Field | Factor Formula (CW2_FORMUL) |
Expression | U_XCTFATOR( M->CTQ_CT1CPAR,M->CTQ_CTTCPAR,M->CTQ_CTDCPAR,; M->CTQ_CTHPAR) |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas