Primary Tables

The General Account system uses these primary tables:

Table Name (Number)

Description

Account Master (F0901)

Stores account definitions, including account numbers and descriptions. One record exists for each account.

Account Balances (F0902)

Stores account balances including net postings for each period and prior year balances (net and cumulative). One record exists for each account/ledger type/subledger/subledger type/fiscal year and, if you post by currency, transaction currency.

Account Ledger (F0911)

Stores detail transactions in the general ledger. One record exists for each transaction. When you use multiple currencies, two records exist for each transaction.