Inserting Plugs in Clauses
Set up and maintain clauses using Material Clauses and Subcontract Clauses (on the Procurement – Setup – Technical Information menu).
Subcontract Clauses – Adding a Clause
To enter a new line in the clause, press Ctrl+Enter. However, Coins ERP+plus does not interpret line break characters correctly, so if you are also using Coins ERP+plus, avoid entering new lines in clauses.
While you are editing the clause, click Lookup (
).Select the appropriate plug from the lookup. Coins ERP+ inserts the token for the plug in the text.
The tokens are as shown in the following table:
Plug | Token | Coins ERP+ Only |
Character | $$CHA## |
|
Character (Mandatory) | $$CHAM## | Y |
Integer | $$INT## |
|
Integer (Mandatory) | $$INTM## | Y |
Decimal | $$DEC## |
|
Decimal (Mandatory) | $$DECM## | Y |
Date | $$DA## | Y |
Date (Mandatory) | $$DAM## |
|
Text Area | $$TXTA## | Y |
Text Area (Mandatory) | $$TXTAM## | Y |
Checkbox | $$LO## | Y |
Numbered Document Set | $$NDS## | Y |
$$NDS## should be used together with the ^CODE parameter (it specifies the code of the Numbered Document Set – see - Plugs in Numbered Documents).
NOTE
To enter plugs in clauses in Coins ERP+plus , you need to type the plug as shown above. If the clause has been maintained in Coins ERP+ and contains any of the plugs marked “Coins ERP+ only”, you will not be able to update the clause using Coins ERP+plus.
Default Values for Plugs
You can specify a default value for the plug – when the user adds the clause to an order, Coins ERP+ inserts this value in the plug, but the user can change it.
$$TXTA^DEFAULT="Subject to our standard terms and conditions"##
$$CHA^DEFAULT="main gate"##
$$LO^DEFAULT="YES"##
$$INT^DEFAULT="12"##
$$DEC^DEFAULT="12.345"##
$$DA^DEFAULT="25/12/08"
Autofill Plugs
You can also include plugs in the clause that will be filled in automatically using data from the table(s) as well as the database or RO_/RW_ fields.
Enclose the table and field name in curly brackets, for example: {po_hdr.job_num}. These plugs are not updateable. You can retrieve values from po_hdr, ci_company, ci_office, jc_job, pi_project.
These can take the following parameters:
^FORMAT=... | Allow you to specify a format. Example: {po_hdr.poh_revrequired^FORMAT=Yes/No} |
^POPULATE=... | Allow you to specify the RSP from which the field is populated, like the "Populate" option in the page designer. Example: {pi_project.pij_formofexec^POPULATE=pij-rsp} |
Example:
Contract {po_hdr.job_num} is {pi_project.pij_formofexec^POPULATE=pij-rsp} for {po_hdr.poh_amount^FORMAT=>>>>9.99} GBP.
This order is for trade $$CHA^DEFAULT=po_hdr.poh_desc##.
This will lead to a result like this:
