Finance Automation SAP REL functions, Miscellaneous

The following base REL functions are used in all flavors. The functions reside in the Redwood_FCA library. You call these functions by specifying =<partition>.Redwood_FCA.<function>. The examples on this page assume the definition which calls these functions resides in the same partition as the library, specified as $. The default partition of the library is FCA. The REL functions can be accessed via RedwoodScript from the com.redwood.scheduler.custom.fl.flow.rel.FlFlowRel class.

getTemplateDocumentNamePairs

This function retrieves a list of Document and name pairs for use in a SimplePairListConstraint.

Syntax

Redwood_FCA.getTemplateDocumentNamePairs(String partitionName, String template)

Returns String

Example

=Constraint.pairListConstraint('Name,Description', $.Redwood_FCA.getTemplateDocumentNamePairs($, value))

Result

Returns a list of template Documents and their names to choose from.

taskListDetails

This function returns details of a task list as specified. The following details can be queried:

• Language - Language
• Description - Description of a Template or Task List
• ClosingType - Month-End/Quarter-End/Year-End Closing
• FactoryCalendar - Factory Calendar
• CloseDate - Date of close
• FiscalYear - Fiscal year
• FiscalPeriod - Fiscal period
• Owner - Person Responsible for Close Template
• TemplateTimeZone - Template Timezone
• Notification_JD - Redwood Finance Automation Notification method
• SAPSystem - SAP source system
• Client - SAP client
• Insight_URL - URL to maintain tasklist in NWBC
• CA_Count - Number of controlling areas
• CC_Count - Number of company codes
• TrCPSCurrent - Current Change Transport [Planned]
• TrCPSNext - Next Change Transport [Planned]
• TrFPACurrent - Current Change Transport [Planned]
• TrFPANext - Next Change Transport [Planned]
• CPS_Parent - CPS Parent JobId [Planned]

note

Parameter must be Runtime!

Syntax

Redwood_FCA.taskListDetails(Long jobId, String inParameter)

Returns String

Example

=$.Redwood_FCA.taskListDetails(jobId, 'ClosingType')

Result

Returns Monthly.

financeTopic