Understanding Multisite Consolidation Structures and Tables

Before you can consolidate account balances, you must define the structure of the consolidation. For multisite consolidations, you define the organizational structure separately from the account structure. The combination of the organizational structure and the account structure represents the multisite consolidation structure.

Multisite consolidations use the standard format (business unit.object.subsidiary) for account numbers.

The system uses the organizational structure and the account structure to create these tables, which contain consolidated balances that are sent to the target company:

  • Multi-Site Consolidation Transfer File Header (F1001).

  • Multi-Site Consolidation Transfer File (F1002).

  • Multi-Site Consolidation Transfer File - Category Codes (F1003).