Feature: Report Key Fields
Environment: Comsense Advantage (Version 21.1.100.094 and later), Advantage Submittal & Report Tool
How it works:
A key field is a placeholder text that auto-populates text parameter fields with the appropriate system data at the time of report generation. Comsense uses key fields to automate a portion of the report-generation process.
The following reports use key fields to automatically pull data from the project:
- All Cover Sheets
- Bid Proposal
- Quote Request
- Hardware Preamble
- Door and Frame Preamble
- Submittal Templates
To use the key fields, copy and paste the key fields from the table below into the appropriate parameter field in the Report Management window or at the time of report generation. Always include the brackets { } and use capital letters for the key field name.
| Key Field | Definition | Notes |
|---|---|---|
| {ARCADDR} | Architect address | Lines of address appear on separate lines |
| {ARCADDR1} |
Architect address |
Lines of address appear on one line separated by commas |
| {ARCCODE} | Architect code | |
| {ARCCTRY} | Architect country | |
| {ARCCTY} | Architect city | |
| {ARCEMAIL} | Architect email | |
| {ARCFAX} | Architect fax | |
| {ARCNAME} | Architect name | |
| {ARCTEL} | Architect telephone | |
| {ARCZIP} | Architect Zip/Postal Code | |
| {ARCPRST} | Architect Province/State | |
| {BIDTOTAL} | Total bid amount | |
| {CMPADDR} | Company address | Lines of address appear on separate lines |
| {CMPADDR1} | Company address | Lines of address appear on one line separated by commas |
| {CMPCODE} | Company code | |
| {CMPCTRY} | Company country | |
| {CMPEMAIL} | Company email | |
| {CMPFAX} | Company fax | |
| {CMPNAME} | Company name | |
| {CMPPRST} | Company Province/State | |
| {CMPTEL} | Company telephone | |
| {CMPZIP} | Company Zip/Postal Code | |
| {CSTADDR} | Customer address | Lines of address appear on separate lines |
| {CSTADDR1} | Customer address | Lines of address appear on one line separated by commas |
| {CSTCODE} | Customer code | |
| {CSTCTRY} | Customer country | |
| {CSTCTY} | Customer city | |
| {CSTEMAIL} | Customer email | |
| {CSTFAX} | Customer fax | |
| {CSTNAME} | Customer name | |
| {CSTTEL} | Customer telephone | |
| {CSTPRST} | Customer Province/State | |
| {CSTZIP} | Customer Zip/Postal Code | |
| {DETAILER} | Primary detailer's name | |
| {DIVADDR} | Division address | Lines of address appear on separate lines |
| {DIVADDR1} | Division address | Lines of address appear on one line separated by commas |
| {DIVCODE} | Division code | |
| {DIVCTRY} | Division country | |
| {DIVCTY} | Division city | |
| {DIVEMAIL} | Division email | |
| {DIVFAX} | Division fax | |
| {DIVNAME} | Division name | |
| {DIVPRST} | Division Province/State | |
| {DIVTEL} | Division telephone | |
| {DIVZIP} | Division Zip/Postal Code | |
| {DODGE} | Dodge code | |
| {ESTIMATOR} | Primary estimator's name | |
| {INSALES} | Primary inside salesperson's name | |
| {OUTSALES} | Primary outside salesperson's name | |
| {PRJADDR} | Project address | Lines of address appear on their own line |
| {PRJADDR1} | Project address | Lines of address appear on one line separated with commas |
| {PRJCODE} | Project code | |
| {PRJCTRY} | Project country | |
| {PRJCTY} | Project city | |
| {PRJEMAIL} | Project email | |
| {PRJFAX} | Project fax | |
| {PRJMGR} | Primary project manager's name | |
| {PRJNAME} | Project name | |
| {PRJPRST} | Project Province/State | |
| {PRJTEL} | Project telephone | |
| {PRJZIP} | Project Zip/Postal Code | |
| {SPECWRTR} | Spec writer's name | |
| {SUPADDR} | Supplier address | Lines of address appear on their own line |
| {SUPADDR1} | Supplier address | Lines of address appear on one line separated by commas |
| {SUPCODE} | Supplier code | |
| {SUPCTRY} | Supplier country | |
| {SUPCTY} | Supplier city | |
| {SUPEMAIL} | Supplier email | |
| {SUPFAX} | Supplier fax | |
| {SUPNAME} | Supplier name | |
| {SUPPRST} | Supplier Province/State | |
| {SUPTEL} | Supplier telephone | |
| {SUPZIP} | Supplier Zip/Postal Code | |
| {USERCODE} | Usercode of person printing report | |
| {USERNAME} | User name of user printing report |
Comments
Please sign in to leave a comment.