Additional Field Types
Formula Fields – This is a place holder - there are no built-in formulas. You will build the formulas using provided tools
Literal Text – If there is something you require on the report to show on every record, but isn't necessarily something you can pull from the system, you can add in a literal text field and type in exactly what it is that you want displayed on the report. Literal text fields can also be used as "spacers".
Literal Number – these are generally used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number.
Evaluated Fields – These are your query statements, to put that another way, your "if" statements. A good example might be...reporting for pension – show me all of the employees, but only if they are over 55 and if they are female. So if it's this, then put them in this field. If they are not that, then do not pull their information.
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
Current Date | MISCELLANEOUS | CURRENT_DATE | Size: 11 Format: DD-MMM-YYYY |
Current Date And Time | MISCELLANEOUS | CURRENT_DATE_AND_TIME | Size: 11 Format: DD-MMM-YYYY H |
Eval Field 01 | EVALUATED_FIELD | EVALUATED_FIELD_01 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 02 | EVALUATED_FIELD | EVALUATED_FIELD_02 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 03 | EVALUATED_FIELD | EVALUATED_FIELD_03 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 04 | EVALUATED_FIELD | EVALUATED_FIELD_04 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 05 | EVALUATED_FIELD | EVALUATED_FIELD_05 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 06 | EVALUATED_FIELD | EVALUATED_FIELD_06 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 07 | EVALUATED_FIELD | EVALUATED_FIELD_07 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 08 | EVALUATED_FIELD | EVALUATED_FIELD_08 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 09 | EVALUATED_FIELD | EVALUATED_FIELD_09 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Eval Field 10 | EVALUATED_FIELD | EVALUATED_FIELD_10 | These are your query statements, to put that another way, these are IF statements Size: 10 |
Formula Field 01 | FORMULA_FIELDS | FORMULA_01 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 02 | FORMULA_FIELDS | FORMULA_02 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 03 | FORMULA_FIELDS | FORMULA_03 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 04 | FORMULA_FIELDS | FORMULA_04 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 05 | FORMULA_FIELDS | FORMULA_05 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 06 | FORMULA_FIELDS | FORMULA_06 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 07 | FORMULA_FIELDS | FORMULA_07 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 08 | FORMULA_FIELDS | FORMULA_08 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 08 | FORMULA_FIELDS | FORMULA_09 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Formula Field 10 | FORMULA_FIELDS | FORMULA_10 | This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.## |
Literal Number 01 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_01 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 02 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_02 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 03 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_03 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 04 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_04 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 05 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_05 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 06 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_06 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 07 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_07 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 08 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_08 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 09 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_09 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Number 10 | LITERAL_NUMBER | LITERAL_NUMBER_FIELD_10 | used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.## |
Literal Text 01 | LITERAL_TEXT | LITERAL_TEXT_FIELD_01 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 02 | LITERAL_TEXT | LITERAL_TEXT_FIELD_02 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 03 | LITERAL_TEXT | LITERAL_TEXT_FIELD_03 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 04 | LITERAL_TEXT | LITERAL_TEXT_FIELD_04 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 05 | LITERAL_TEXT | LITERAL_TEXT_FIELD_05 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 06 | LITERAL_TEXT | LITERAL_TEXT_FIELD_06 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 07 | LITERAL_TEXT | LITERAL_TEXT_FIELD_07 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 08 | LITERAL_TEXT | LITERAL_TEXT_FIELD_08 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 09 | LITERAL_TEXT | LITERAL_TEXT_FIELD_09 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Literal Text 10 | LITERAL_TEXT | LITERAL_TEXT_FIELD_10 | Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30 |
Record Count | MISCELLANEOUS | RECORD_COUNT | Number of records selected Size: 5 Format: ########### |
The Number One | MISCELLANEOUS | THE_NUMBER_ONE | Number 1 Size: 10 Format: ########### |