TableSets

When you plan your business unit structure, you need to be familiar with TableSets, which are used in all PeopleSoft Financials products.

The accounting structure and processing rules for each PeopleSoft application are defined in a series of control tables. A TableSet is a group of rows across control tables, identified by the same SetID, on which you define the accounting structure for each of your business units, aging rules, entry types and reasons, payment terms, credit and receivables personnel, and so forth. For a business unit to process transactions, it must have an associated TableSet.

You can think of business units and TableSets in the following simplified terms:

• A business unit contains all the actual data.

• A TableSet contains the rules by which the data is processed.

A SetID identifies each TableSet. You can have as many SetIDs as you want. However, using numerous SetIDs creates complex TableSet sharing. You must create at least one SetID, even if you do not use TableSet sharing.