Choice [sn_fcms_choice] |
Stores the calendar months to be used as a reference for the
Applicable months field in a functional workbook and close
task. Stores the finance calendars to associate close tasks with different
calendars used by various teams in the organization. |
Close Task [sn_fcms_close_task] |
Stores all the tasks in a workbook. |
Close Task Load Data [sn_fcms_close_task_load_data] |
Interface table for importing data into a close task using a transform map.
|
Close Task Type [sn_fcms_task_type] |
Stores the types of the tasks defined in the application such as Journal Entry
and Reconciliation. Note: In this table, the entry for the Journal Entry task type is
locked for any edits because an integration to ERP is associated with
it. |
Close Workbook [sn_fcms_global_checklist] |
Stores the global workbooks. |
ERP JE Detail [sn_fcms_erp_journal_detail] |
Stores mapping between the ERP document ID, JE header, and close task. |
Follow-up Task [sn_fcms_followup_task] |
Stores all follow-up tasks in a workbook. |
Functional Workbook [sn_fcms_functional_checklist] |
Stores all functional workbooks. |
Function [sn_fcms_functions] |
Stores the functions in the finance organization such as General Ledger,
Revenue, and Commissions. |
JE Approval Configuration [sn_fcms_je_approval_configuration] |
Stores approval configuration rules for JE approval decisions. |
JE Approval Definition [sn_fcms_journal_approval_definition] |
Stores rules that derive the approvers and the number of levels of approval
required for a rule. |
JE Approver [sn_fcms_journal_approver] |
List of approvers for approving a journal entry if approval is automatically
assigned by the system. |
JE Approver Definition [sn_fcms_journal_approver_definition] |
Stores the approvers and the level information for each rule condition defined
in the JE Approval Definition table. |
JE Header [sn_fcms_journal_header] |
Stores the header information of journal entries. A journal entry consists of
a journal entry header and a journal entry line. |
JE Header Template [sn_fcms_journal_header_template] |
Stores the JE header templates defined in the application. |
JE Line [sn_fcms_journal_line] |
Stores the line information of journal entries. |
JE Reversal Template Field
Mapping [sn_fcms_je_reversal_field_mapping] |
Stores mapping of JE reversal template fields with columns in the JE header.
The mapped fields appear in the Reverse Journal Entry dialog box when you reverse a
posted journal entry. |
JE Template [sn_fcms_journal_templates] |
Stores the JE templates defined in the application. The templates can be
assigned to different functions defined in the Functions [sn_fcms_functions] table.
A template may be applicable to multiple teams, and therefore can be assigned to
multiple functions. |
JE Template Field Mapping [sn_fcms_je_template_field_mapping] |
Stores mapping between JE template fields with columns in the JE line. |
Journal Entry Type [sn_fcms_journal_type] |
Stores journal entry types as configured in ERP sources. |
Kickstart Errors [sn_fcms_kickstart_error] |
Stores validation errors during the kickstart of a workbook. |
Ledger Group [sn_fcms_ledger_type] |
Stores ledgers defined in the ERP. |
Reversal Code [sn_fcms_reversal_code] |
Stores the reversal codes used for reversing journal entries. The reversal
codes are taken from the ERP system. |
Task Progress % Mapping [sn_fcms_progress_percent_mapping] |
Stores the mapping of the task states with the percent complete. When a task
moves from one state to another, the system automatically assigns percent complete
defined in the table. |
GRC tables |
GRC Profile [sn_fcms_grc_profile] |
Maintains the list of GRC profiles. These profiles are mapped to the profiles
in GRC application. |