Subledger Tables
General structure
Subledger tables are similar to the Global tables in that their structure is based on the fields contained in the Template. All features of the Global tables, including views, linked fields, NULL row and system-defined fields are present in the Subledger tables.
Subledgers are used in conjunction with the General Ledger accounts; more than one GL account can be associated with the same Subledger Template. Since there is only one table created for each Subledger Template, SF_IDG column is added to the table in order to keep track of the controlling GL account (by making its internal number a part of the Subledger record).
GL accounts that have subledgers may also support processing of Open Items. This implies tracking the grouping information derived from the designated match fields, and setting the strategy for such grouping (automatic, based on the contents of the match field, or manually selected by the user). The match field id and the strategy code are associated with the controlling GL account and recorded in the Account Chart table -- in other words, they are set for all records of the given Subledger that are attached to this GL account. However, these default settings can be overridden for the individual Subledger records; for this purpose Subledger tables maintain two more system-defined columns: SF_MatchFieldId and SF_MatchStrategy.
The summary of these additional fields is shown below:
Column | Generalized data type | Use |
SF_IDG | INT | Internal number of controlling GL account |
SF_MatchFieldId | SMALLINT | Id number of the field used to match Open Items |
SF_MatchStrategy | CHAR(1) | Strategy for matching Open Items (A or S) |
Subledger number
Externally, subledger numbers are stored in the mandatory SF_SubledgerNumber field. Whenever the subledger number is displayed by the data entry Templates, it is this character-based number that is shown to the user. However, when the subledger number is used in accounting transactions, the transaction record stores the internal representation of the subledger number from SF_ID column of the subledger table.