biuan SAP® BUSINESS ONE SDK
API OBTD / Journal Vouchers
OBTD - Journal Vouchers List Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BatchNum KEY UNIQUEJournal Voucher No.Int
11
PRIMARYYes
Status KEYOpen/Closed DocumentVarChar
O) Open
C) Closed
1
OSTATUSNo
NumOfTransNo. of TransactionsInt
6
DateIDPosting DateDate
8
LocTotalTotal (LC)Num
20
FcTotalTotal (FC)Num
20
SysTotalTotal (SC)Num
20
MemoIDDetailsnVarChar
50
UserSignUser SignatureInt
6OUSR
Users
RemarksJournal Voucher Remarks FieldnVarChar
50

Table relationship map

SELECT statement

SELECT OBTD.BatchNum AS 'Journal Voucher No.', OBTD.Status AS 'Open/Closed Document', OBTD.NumOfTrans AS 'No. of Transactions', OBTD.DateID AS 'Posting Date', OBTD.LocTotal AS 'Total (LC)', OBTD.FcTotal AS 'Total (FC)', OBTD.SysTotal AS 'Total (SC)', OBTD.MemoID AS 'Details', OBTD.UserSign AS 'User Signature', OBTD.Remarks AS 'Journal Voucher Remarks Field' FROM OBTD AS OBTD

Related information


Journal Vouchers JournalVouchers Object· Table: OBTD
JournalVouchers is a business object that represents the journal vouchers in the Finance module. Use the JournalVouchers object as a draft for journal entries. That is, no values are created in the general ledger. The properties of the journal...

OBTD SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates