In SAP Business One, the OJDT table is a transaction journal table that stores information about all entries and transactions made in the SAP Business One database. This information can be accessed through the OJDT table. It stores a record for each transaction and entry made in the database.
The OJDT table contains one record for each transaction and these records contain information about the transaction, such as the transaction date, the type of transaction, the transaction number and the reference date. Furthermore, the table contains information about the entries that were part of the transaction, such as the AccountThe amount of the transaction and the currency code.
As the OJDT table contains all the entries and transactions made in the database, it is considered one of the most important tables in SAP Business One. Therefore, it is considered an important source of financial and accounting information in the SAP Business One database.
On the other hand, it should be noted that the OJDT table can be very large due to the large number of entries it stores. Therefore, performance problems may occur if it is not adequately controlled. It is therefore important to maintain the table regularly to ensure that its size and functionality remain optimised. Among others, the following fields are represented in the table:
- TransID: Unique ID of the transaction in the table.
- TransType: The type of transaction, e.g. "AP-Invoice" for incoming invoices or "AR-Invoice" for outgoing invoices.
- TransDate: The date on which the transaction was carried out.
- RefDate: The date to which the transaction refers.
- Memo: A description of the transaction or booking.
- Project: The project with which the transaction or booking is associated.
- CardCode: The customer's code or Suppliers, with which the transaction is associated.
- DocEntry: The entry number of the document to which the transaction refers, e.g. an invoice number.
- TransCode: The code of the transaction used to identify the booking.
- Series: The number of the series list used for the transaction.