In SAP Business One, information about the company's general ledger accounts is stored in the OACT table. Each Account in the general ledger is reflected in the table by an entry containing the corresponding account number, the account name, the account type and all other relevant information on this account.
The account number not only serves as a unique identifier for the account in the ledgerbut is also used in other SAP Business One modules as a reference point for transactions and postings. The user has the option of recognising their account more quickly by giving it a name that is both descriptive and informative for its purpose.
The account type can be used to recognise whether it is a debit account, a credit account or a balance confirmation account. This information is essential for the correct posting of transactions in the system. Other data that can be included in the OACT table includes the categorisation of the account, the currency in which the account is managed and the date of the last update. The fields in the OACT table include
- AcctCode: This field contains the account number of the general ledger account.
- AcctName: The name of the general ledger account is stored here.
- GroupMask: This field contains a bit mask that specifies the group to which the account belongs.
- Postable: This indicates whether the account is authorised for postings or not.
- Levels: This field defines the hierarchy level of the account in the general ledger.
- Finanse: This field indicates whether the account is a debit or credit account.
- LocManTran: This defines whether the account is used for local bookings or for bookings in other currencies.
- MaxCT: This field contains the maximum credit amount allowed for the account.
- MaxDT: The maximum debit amount for the account is specified here.
- ToleranceDays: This field specifies the number of tolerance days for payments that apply to the account.
