Function	Description
fR_Boolean	Used in Boolean fields to indicate a specific text field for which the values is True or False Format : fR_Boolean(field;"True";"False") Where: o  field : indicates the type of Boolean field o  "True" : shows the text for True field, e.g.: "Sim", "Yes"; "Has" o    "False" : shows the text for the False field,  e.g.: "Não"; "No";...
fR_DataTrafego	Used for Monthly Schedule reports, and calculates the exact date of broadcast of a program Format: fR_DataTrafego
fR_DispTrafego	Indicates versions available for a specific program.  If a version is found, the result will be "Traffic Available"; if not found, it will indicate "Expected Traffic xx/xx/xx" (expected delivery date of the program copy) Format: fR_DispTrafego
fR_Versoes	Displays a list of recorded versions for a specific program as: n:vfm vfm vfm .... Where: n: stands for the number of versions for a program vfm : stands for the versions available as follows: V: first letter for the version (L:Leg, D:Dub, S:Script,...) F : first letter for the formatting (B:Beta, V:VHS, ...) M : first letter for the material (M:Master, C:Copy, B:backup, ...) Format: fR_Versoes
fR_PlayDateAte	Indicates the total number of play dates of a program.  It is also fills the variable RV_ProgDays with the list of play dates Format: fR_PlayDateAte
fR_PlayDatePer	Indicates the number of play dates of a program within the indicated report period.It is also fills the variable RV_ProgDays with the list of play dates Format: fR_PlayDatePer
fR_Quoted	Indicates fields in quotation marks Format: fR_Quoted(field) Where: o       field : indicates the "quoted" field
fR_DescontoOI	Indicates the discount negotiated for an Ad Sales Order.  It is calculated based on the value negotiated and the table value Format: fR_DescontoOI
fR_VlrTablOI	Indicates the Ad Sales Order price table Value.  It also puts the calculated discount in the variable RV_Desconto Format: fR_VlrTablOI
UThhTimeToZone	Used to convert a time field into different time zones Format: UThhTimeToZone(field;"timezone"[;date][;"datetype"][;channel]) Where: o       field : indicates the original time field o       timezone : the name of the time zone to be converted to.  It must correspond to a timezone defined in the system and in quotation marks o       date : reference date for the conversion; if ommitted, the current date will be used o       datetype : informs the type of the date parameter and can be: "B"= the date represents the broadcast date; or "C"= the date is the calendar date (default). o       channel : the corresponding channel to be used as basis to determining time zone conversions; this is required if the datetype is "B" as channles may have a distinct broadcast day start time.
UTtxfAdjustTitle	Adjusts program titles containing articles at the end.  The article is transferred to the beginning of the title Format: UTtxfAdjustTitle(field) Where: o       field : indicates the title field to be adjusted
UTtxNormalizeName	Converts cast's names into a standard format: "lastname, firstname". Format: UTtxNormalizeName(field) Where: o       field : indicates the name field to be converted
UTtxNaturalName	Converts names from  "lastname, firstname" format to "firstname lastname" format Format: UTuxNaturalName(field) Where: o       field : indicates the name field to be converted
UUtxCapitals	Capitalizes the first letter of each word Format: UUtxCapitals(field) Where: o       field : indicates the field to be capitalized
UUtxFixStringSize	Changes the size of characters strings, adjusting the text accordingly.  It can be used when exporting texts with fixed string sizes Format: UUtxFixStringSize(field; size) Where: o       field : indicates the field to be adjusted o       size : indicates the desired number of characters