biuan SAP® BUSINESS ONE SDK
API OJST
OJST - TDS Adjustment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocDatePosting DateDate
8
CommentsRemarksnVarChar
127
JrnlMemoJournal RemarksnVarChar
50
TransIdTransaction NumberInt
11OJDT
Journal Entry
LogInstancLog InstanceInt
11
0
UserSignUser SignatureInt
11OUSR
Users
CreateDateCreation DateDate
8
CreateTimeGeneration TimeInt
11
DepositNumDeposit NumberInt
11OVPM
Outgoing Payments
CertNumCertificate NumbernVarChar
31

Table relationship map

SELECT statement

SELECT OJST.AbsId AS 'Internal Number', OJST.DocDate AS 'Posting Date', OJST.Comments AS 'Remarks', OJST.JrnlMemo AS 'Journal Remarks', OJST.TransId AS 'Transaction Number', OJST.LogInstanc AS 'Log Instance', OJST.UserSign AS 'User Signature', OJST.CreateDate AS 'Creation Date', OJST.CreateTime AS 'Generation Time', OJST.DepositNum AS 'Deposit Number', OJST.CertNum AS 'Certificate Number' FROM OJST AS OJST

Related information


OJST SQL Table

Outgoing Payments OVPM SQL Table

Journal Entry OJDT 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates