In SAP Business One, the OBTF table contains information on bank account entries. Each row in the table represents a single transaction that has been posted to a bank account.
The OBTF table contains information such as the ID of the booking, the date of the booking, the booking amount and the associated bank account. Further information, such as the currency of the booking, the corresponding booking cycle and comments, can also be included.
The OBTF table is closely related to other modules of SAP Business One, such as the Sales Order and Supplier invoice. In this way, bookings can be assigned to an individual business partner or a transaction to be assigned to the accounting and the Receivables management to simplify the process. The following are examples of fields in the OBTF table in SAP Business One:
- TransId: This field contains the unique ID number of the booking.
- DocNum: The number of the document that is assigned to the booking (e.g. invoice number, credit note number) is saved here.
- TransType: The type of booking is defined in this field (e.g. bank transfer, cash payment).
- TransDate: The date of the booking is stored in this field.
- Debit: The amount of the debit is posted here.
- Credit: The amount of the credit note is posted in this field.
- BankCode: The code of the associated bank account is saved here.
- Ref1: An internal reference number for the booking can be saved in this field.
- Ref2: Further information on the booking can be saved here.
- ShortName: The name of the business partner associated with the booking is saved in this field.
