Appendix: Operators and functions - Revision history

Nele.scherrens at 15:13, 28 August 2017

2017-08-28T15:13:19Z

2017-08-28T14:16:47Z

‎List of header field codes and their parameters

2017-01-16T09:00:48Z

‎List of functions and their parameters

2017-01-16T08:19:13Z

2017-01-16T08:08:10Z

‎List of header field codes and their parameters

2017-01-13T11:25:54Z

@@ Line 293: / Line 293: @@
 == List of technical field codes and their parameters ==
 '''All environments'''
 {| class="wikitable"
@@ Line 349: / Line 352: @@
 |#{TECHNICALFIELD(BOOKINGDATE)}
 |}
 == List of functions and their parameters ==
@@ Line 355: / Line 363: @@
 * COMPANYCODE(): get the code of the company of the document.
 * COMPANYNAME(): get the name of the company of the document.
 * DOCUMENTARCHIVEID(): get the ID of the document as it is seen in the archive view.
 * DOCUMENTID(): when a document has another ID (in an external package for example), get that ID.
 * DOCUMENTLIST():
-* DOCUMENTTYPECODE():
+* DOCUMENTTYPECODE(): get the code of the type of the document.
-* DOCUMENTTYPENAME():
+* DOCUMENTTYPENAME(): get the name of the type of the document.
-* RECMETHOD():
+* RECMETHOD(): get the name of the reception method of the document.
-* RECMETHODCODE():
+* RECMETHODCODE(): get the code of the reception method of the document.
-* SCANBATCHTYPECODE():
+* SCANBATCHTYPECODE(): get the code of the type of the scanbatch with which the document was scanned.
-* SCANBATCHTYPENAME():
+* SCANBATCHTYPENAME(): get the name of the type of the scanbatch with which the document was scanned.
-* SCANNINGUSERNAME():
+* SCANNINGUSERNAME(): get the username of the user who scanned the document.
 * OPTINPARTNERS():
 * CUSTOMTEXT():

@@ Line 128: / Line 128: @@
+|
 |#{HEADERFIELD(CURRENCY,NAME)}
 |-
 |Invoice type
@@ Line 221: / Line 227: @@
+|
 |#{HEADERFIELD(VATID)}
 |}
@@ Line 257: / Line 257: @@
 |#{HEADERFIELD(SUPPVATID)}
 |-
-|Invoice number
+|Voucher date
-|INVOICENR
+|VOUCHERDATE
+|
+|
-|#{HEADERFIELD(INVOICENR)}
+|#{HEADERFIELD(PERIOD,NAME)}
 |-
 |Voucher date

@@ Line 271: / Line 271: @@
 == List of technical field codes and their parameters ==
-* SCANBATCH
+'''All environments'''
-* SCANUSER
+{| class="wikitable"
-* SCANNINGDATE
+! style="text-align:left; width:150px"|Fieldname
-** Dateformat
+! style="text-align:left; width:150px"|Fieldcode
-** Calculation
+! style="text-align:left; width:150px"|Parameter 1
-* INCOMINGDATE
+! style="text-align:left; width:150px"|Parameter 2
-** Dateformat
+! style="text-align:left"|Example usage
-** Calculation
+|-
 == List of functions and their parameters ==

@@ Line 27: / Line 27: @@
 == List of header field codes and their parameters ==
-* SUPPCODE
+<br/>
-** CODE
+<div style="font-size:110%>Usage: #{HEADERFIELD(FIELDCODE, VALUE OF PARAMETER 1, VALUE OF PARAMETER 2)}</div>
-** NAME
+<br/>
-* SUPPVATID
+'''All environments''':
-* CUSTCODE
-** CODE
+{| class="wikitable"
-** NAME
+! style="text-align:left; width:150px"|Fieldcode
-* CUSTVATID
+! style="text-align:left; width:150px"|Parameter 1
-* JOURNAL
+! style="text-align:left; width:150px"|Parameter 2
-** CODE
+! style="text-align:left"|Example usage
-** NAME
+|-
-* INVOICENR
+|SUPPCODE
-* INVDATE
+|CODE
-** Dateformat
-** Calculation
+|#{HEADERFIELD(SUPPCODE,CODE)}
-* COMMENT1
+|-
-* OGM
-* NETAMNT
+|NAME
-* VATAMNT
-* TOTAMNT
+|#{HEADERFIELD(SUPPCODE,NAME)}
-* CURRENCY
+|-
-** CODE
+|SUPPVATID
-** NAME
-* YEAR
-** CODE
+|#{HEADERFIELD(SUPPVATID)}
-** NAME
+|-
-* PERIOD
+|CUSTCODE
-** CODE
+|CODE
-** NAME
 == List of technical field codes and their parameters ==
@@ Line 100: / Line 203: @@
 * GETQUARTER():
-== Date formats ==
+== Dateformats ==
 Some operators/functions require a date format to be entered as a parameter. This is how those formats should be built:
 * '''d''': day