Value Expression
If Value Type is set to , specify the literal expression or macro expression in this field. These macro expressions are currently supported:
| Macro | Description |
|---|---|
| ACTION() | To be used with TABLE! BODs. For an insert operation that fired the replication, it gets the value Add. For an update operation, it gets the value Change. Delete is currently undefined and substitutes to an empty string. |
| PARMS( table.column ) | Resolves to the value of the specified table/column. |
| FPARMS | Like PARMS, but it encloses the result in single quotes, for filters. |
| P(property) | The value of an IDO property. |
| FP(property) | Same as P(), but it encloses the result in single quotes, for filters. |
| Pn | Used for method parameters. Method parameters are referenced by numerical order, rather than by a specific property name. For example, P7 indicates the seventh method parameter. |
| FPn | Used for method parameters. Similar to Pn, but it encloses the result in single quotes. |
| NIDID(property|param|literal) | Resolves to the value of the NID with the location left blank. Specify a property name, an invoke parameter name, or a literal string with substitution keywords. The macro then retrieves the rest of the information required for the NID from the system. |
| LNIDID(property|param|literal) | Resolves to the value of the NID including the location (the "from" site). Specify a property name, an invoke parameter name, or a literal string with substitution keywords. The macro then retrieves the rest of the information required for the NID from the system. |
| TNIDID(property|param|literal) | Behaves like the NIDID keyword except it does not include accounting entity or location in the value it returns. Specify a property name, an invoke parameter name, or a literal string with substitution keywords. The macro then retrieves the rest of the information required for the NID from the system. |
| BODNOUN() or BODVERB() | Resolves to the
value of the BOD noun and verb from the linked Replication Document Cross
Reference form (Inbound or Outbound). The BODNOUN and BODVERB keywords are
honored in the Replication Document form's literal
Value Expression
field, as well as in the
BOD Tag Name and
Attribute Name fields.
Use of these keywords allows you to use the replication document as a template,
resolving to a different outer XML element depending on the noun/verb
combination selected on the cross reference form.
For example, the Purchase Order Sync BOD must specify SyncPurchaseOrder as the outermost XML element name. The Purchase Order Process BOD must specify ProcessPurchaseOrder as the outermost XML element name. Use BODVERB()BODNOUN() instead to specify the verb and noun in the PurchaseOrder replication document's BOD Tag Name; that way you can use the same replication document for both verbs. Be careful not to include blanks when using these keywords for tag and attribute names, because blanks are not allowed in XML names. |
| FROMLOGICALID() | Resolves to the value of site.message_bus_logical_id for the site that is the source of the original outbound message, and then appends the parms.site value for that site. For example: infor.mongoose.oh |
| BODCURDATETIME() | Resolves to the current server-based date/time, formatted for BOD-enabled applications. |
| VARIATIONID() | Resolves to a 64-bit integer value that is guaranteed to be unique. |
| TENANTID() | Resolves to the Tenant ID value set in the Sites or Sites/Entities, or Intranets form. |
| FROMSITEINTRANET() | Same as TENANTID |
| URIFROMSITEINTRANET() | URI encoded FROMSITEINTRANET so that URI characters like "/" are escaped. |
| URITENANTID() | URI encoded TENANTID so that URI characters like "/" are escaped. |
| CDATA() | Wraps the entire element so that all XML tags are ignored using the XML CDATA construct. The CDATA() must be at the beginning of the element; otherwise it is ignored. If CDATA() is found at the start of an element value, then the value will be made a CDATA section. For example: CDATA()P(P3). |