biuan SAP® BUSINESS ONE SDK
SQL JE Document Type
DTW JE Document Type
API Journal Entries / Document Type
OJET - JE Document Type Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
JEType KEY UNIQUEJE Document TypenVarChar
60
PRIMARYYes
LockedLockedVarChar
Y) Yes
N) No
1
N
DocTypDescDocument Type DescriptionnVarChar
127
ShortNameShort NamenVarChar
127
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OJET.JEType AS 'JE Document Type', OJET.Locked AS 'Locked', OJET.DocTypDesc AS 'Document Type Description', OJET.ShortName AS 'Short Name', OJET.DataSource AS 'Data Source', OJET.UserSign AS 'User Signature' FROM OJET AS OJET

Related information


Document Type DocumentType Property· Table: OJET
property DocumentType
· Table: OBTF    Parent: Journal Entries JournalEntries Object· Table: OJDT OBTF
OJET 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