Components installed with Finance Common Architecture

Several types of components are installed with the installation of the Finance Common Architecture application, including tables and user roles.

Roles installed

Tableau 1. Roles in Finance Common Architecture

Role title [name]	Description	Contains roles
Finance admin [sn_fin.finance_admin]	Generate fiscal and accounting periods.	sn_fin.finance_user
Finance user [sn_fin.finance_user]	View and edit accounting and fiscal periods.	None

Tables installed

Tableau 2. Tables installed in Finance Common Architecture

Table	Description
Account Access [sn_fin_gl_access]	Defines the access control for general ledger (GL) accounts, specifying who can view or modify particular GL records.
Account Access Rule [sn_fin_gl_access_rule]	Defines rules that govern access control to the general ledger, ensuring proper segregation of duties and user permissions.
Account Group Mapping [sn_fin_gl_group_mapping]	Maps general ledger accounts to specific groups for reporting purposes, ensuring proper categorization and alignment with business functions.
Accounting Periods [sn_fin_accounting_period]	Defines accounting periods for financial reporting, such as fiscal year, quarters, and months.
Balance [sn_fin_balance]	Tracks balances for different financial entities, which could include balances for accounts, departments, or cost centers.
Base Invoice [sn_fin_base_invoice]	Stores high-level details about invoices, such as invoice number, date, supplier, customer, and total amount.
Base Tax Line [sn_fin_base_tax_line]	Contains detailed tax line items associated with invoices, including tax rates, tax amounts, and tax classifications.
Currency Conversion Setting [sn_fin_gl_currency_setting]	Contains settings and preferences for handling multiple currencies in the general ledger, including conversion rates and currency codes.
Due Date Rule [sn_fin_gl_due_rule]	Defines rules for determining when accounts payable or receivable amounts are due, including due dates, grace periods, and interest rates.
ERP Source [sn_fin_erp_source]	Maps and stores information regarding source systems from which financial data is imported or integrated into the financial system.
ERP source mapping [sn_fin_erp_source_mapping]	Maps external ERP system data to the internal financial schema, facilitating data integration and synchronization.
Excel Data Import [sn_fin_excel_data_import]	Supports the asynchronous excel data import for a journal entry.
Period [sn_fin_period]	Maps external ERP system data to the internal financial schema, facilitating data integration and synchronization.
Finance Exchange Rates [sn_fin_fx_rate]	Maintains foreign exchange rates used for currency conversions in financial transactions, tracking historical and current rates.
Fixed Asset [sn_fin_fixed_asset]	Stores information about fixed assets owned by the organization, including asset type, value, depreciation, and location.
Fixed Asset to Asset [sn_fin_m2m_fixed_asset]	Represents a many-to-many relationship between fixed assets and various attributes, such as locations, departments, or asset classifications.
GL Rule [sn_fin_gl_rule]	Defines rules and policies for general ledger account management, including rules for automated journal entries and account mappings.
GL Support [sn_fin_gl_support]	Provides supporting data for general ledger accounts, such as supplementary details or documents linked to specific transactions.
Import Error [sn_fin_import_error]	Tracks errors encountered during the import process, typically for financial data, to aid in troubleshooting and data validation.
Industry [sn_fin_industry]	Holds industry classifications or categories relevant to the suppliers, customers, or financial entities in the system.
Ledger [sn_fin_ledger]	The main table for storing general ledger (GL) entries, summarizing financial transactions by account, period, and other dimensions.
Ledger Account [sn_fin_gl_account]	Stores balances for subledgers, such as accounts payable or receivable, tracking amounts owed or due by customers and suppliers.
Ledger Account Group [sn_fin_gl_group]	Organizes general ledger accounts into groups for reporting and analysis purposes, such as by department or business segment.
Ledger Balance [sn_fin_gl_balance]	Holds the balance of general ledger accounts, tracking current balances, debits, credits, and running totals.
Legal Entity [sn_fin_legal_entity]	Contains information about legal entities within the organization, such as corporations or limited liability companies, along with their legal statuses.
Office Location [sn_fin_office_location]	Contains information about office locations, including address, contact details, and organizational unit associated with each location.
Organization [sn_fin_organization]	Contains details about the organizations within the financial system, including business units, departments, and organizational hierarchies.
Organization Tax Details [sn_fin_org_tax_detail]	Contains tax-related information for different organizations, including tax registration numbers, rates, and jurisdictions.
Purchasing Entity [sn_fin_purchasing_entity]	Stores information about entities involved in purchasing transactions, such as divisions or business units within an organization.
Properties [sn_fin_properties]	Stores various configuration properties related to financial data management, such as thresholds, settings, or flags used throughout the system.
Profit Center [sn_fin_profit_center]	Defines profit centers within the organization, enabling financial reporting and analysis by business units or operational segments.
Signer [sn_fin_signer]	Stores information about individuals or entities authorized to sign financial documents or approve transactions.
Supplier [sn_fin_supplier]	Contains details about suppliers, including name, address, contact information, and payment terms
Supplier Legal Entity Mapping [sn_fin_supplier_detail]	Contains more detailed information about individual suppliers, including banking details, payment methods, and credit terms.
Supplier Payment Information [sn_fin_supplier_payment]	Stores records of payments made to suppliers, including payment dates, amounts, and methods of payment.
Subledger Balance [sn_fin_subledger_balance]	Maps general ledger accounts to specific groups for reporting purposes, ensuring proper categorization and alignment with business functions.
Tax Code [sn_fin_tax_code]	Stores various tax codes used for transactions, including sales tax, VAT, and other region-specific tax codes.
Tax Type [sn_fin_tax_type]	Contains different tax types used in financial transactions, such as VAT, sales tax, and withholding tax, along with their applicable rules.
Threshold Rule [sn_fin_gl_threshold_rule]	Defines rules for thresholds in the general ledger, such as limits for certain accounts, to ensure compliance with financial policies.
Unit of measure [sn_fin_uom]	Manages the unit of measurement (UOM) standards used across financial transactions, including different types like kilograms, liters, and hours.