biuan SAP® BUSINESS ONE SDK
DTW Journal Entry
API Journal Entries / Jdt Num
OJDT - Journal Entry Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BatchNumJournal Voucher No.Int
11OBTD
Journal Vouchers List
TransId KEY UNIQUETransaction NumberInt
11
PRIMARYYes
BtfStatusStatusVarChar
O) Open
C) Closed
1
O
TransType KEYOriginal JournalnVarChar
16) Returns
203) A/R Down Payment
15) Delivery
13) A/R Invoice
165) A/R Correction Invoice
166) A/R Correction Invoice Reversal
14) A/R Credit Memo
132) Correction Invoice
(-0) (-
20) Goods Receipt PO
21) Goods Return
204) A/P Down Payment
18) A/P Invoice
163) A/P Correction Invoice
164) A/P Correction Invoice Reversal
19) A/P Credit Memo
281) A/P Tax Invoice
69) Landed Costs
(-1) (-
140000009) Outgoing Excise Invoice
140000010) Incoming Excise Invoice
10000079) TDS Adjustment
(-2) (-
24) Incoming Payment
25) Deposit
46) Vendor Payment
57) Checks for Payment
76) Postdated Deposit
182) BoE Transaction
(-3) (-
-2) Opening Balance
-3) Closing Balance
321) Internal Reconciliation
10000046) Data Archive
30) Journal Entry
(-4) (-
58) Inventory List
59) Goods Receipt
60) Goods Issue
67) Inventory Transfers
68) Work Instructions
162) Inventory Valuation
202) Production Order
(-5) (-
1470000049) Fixed Asset Capitalization
1470000060) Fixed Asset Capitalization Credit Memo
1470000094) Fixed Asset Retirement
1470000075) Fixed Asset Manual Depreciation
1470000090) Fixed Asset Transfer
1470000085) Fixed Asset Revaluation
(-6) (-
-1) All Transactions
310000001) Inventory Opening Balance
10000071) Inventory Posting
20
-1TRANS_TYPENo
BaseRefBase ReferencenVarChar
11
RefDate KEYPosting DateDate
8
REFDATENo
MemoDetailsnVarChar
50
Ref1Reference 1nVarChar
100
Ref2Reference 2nVarChar
100
CreatedByOriginalInt
11
LocTotalTotal (LC)Num
20
FcTotalTotal (FC)Num
20
SysTotalTotal (SC)Num
20
TransCodeTransaction CodenVarChar
4OTRC
Journal Entry Codes
OrignCurrRevaluation CurrencynVarChar
3OCRN
Currency Codes
TransRateRevaluation RateNum
20
BtfLineRow in VoucherInt
11
TransCurrTransaction CurrencynVarChar
3
ProjectProject CodenVarChar
20OPRJ
Project Codes
DueDateDue DateDate
8
TaxDateDocument DateDate
8
PCAdditionPC AdditionVarChar
Y) Yes
N) No
1
N
FinncPriodPosting PeriodInt
11OFPR
Posting Period
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
UpdateDateDate of UpdateDate
8
CreateDateRecording DateDate
8
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
RefndRprtRepayment ReportVarChar
Y) Yes
N) No
1
N
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
30
IndicatorIndicator CodenVarChar
2OIDC
Indicator
AdjTranAdjusting TransactionVarChar
Y) Yes
N) No
1
N
RevSourceRevaluation SourceVarChar
F) FC
S) System
N) No
1
N
StornoDate KEYReversal DateDate
8
STORNONo
StornoToTr KEYReverse TransactionInt
11
STORNO_TRANo
AutoStornoUse Auto-ReverseVarChar
Y) Yes
N) No
1
N
CorisptiviTransaction ValuesVarChar
Y) Yes
N) No
1
N
VatDateVAT DateDate
8
StampTaxStamp TaxVarChar
Y) Yes
N) No
1
N
Series KEY UNIQUESeriesInt
6
0SERIESYes
NumberNumberInt
11
AutoVATAutomatic VATVarChar
Y) Yes
N) No
1
N
DocSeriesDocument SeriesInt
6
FolioPrefFolio Prefix StringnVarChar
4
FolioNumFolio NumberInt
11
CreateTimeGeneration TimeInt
6
BlockDunnBlock Dunning LetterVarChar
N) No
Y) Yes
1
N
ReportEUInclude in EU ReportVarChar
Y) Yes
N) No
1
N
Report347Include in 347 ReportVarChar
Y) Yes
N) No
1
N
PrintedPrintedVarChar
Y) Yes
N) No
1
N
DocTypeDocument TypenVarChar
60OJET
JE Document Type
AttNumNumber of AttachmentsInt
11
0
GenRegNoGenerate Reg. No. or NotVarChar
Y) Yes
N) No
1
N
RG23APart2RG23A Part2 NoInt
11
RG23CPart2RG23C Part2 NoInt
11
MatTypeMaterial TypeInt
11
CreatorCreator NamenVarChar
127
ApproverApprover NamenVarChar
127
LocationLoc.Int
11OLCT
Location
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
AutoWTAutomatic WTaxVarChar
Y) Yes
N) No
1
N
WTSumWTax AmountNum
20
WTSumSCWTax Amount (SC)Num
20
WTSumFCWTax Amount (FC)Num
20
WTAppliedApplied WTaxNum
20
WTAppliedSApplied WTax (SC)Num
20
WTAppliedFApplied WTax (FC)Num
20
BaseAmntBase AmountNum
20
BaseAmntSCBase Amount (SC)Num
20
BaseAmntFCBase Amount (FC)Num
20
BaseVtAtWTax Base VAT AmountNum
20
BaseVtAtSCWTax Base VAT Amount (SC)Num
20
BaseVtAtFCWTax Base VAT Amount (FC)Num
20
VersionNumVersion NumbernVarChar
11
BaseTransBase Transaction NumberInt
11
ResidenNumResidence NumberVarChar
1) Spanish Fiscal ID
2) VAT Registration Number
3) Passport
4) Fiscal ID Issued by the Country of Residence
5) Certificate of Fiscal Residence
6) Other Document
1
1
OperatCodeOperation CodeVarChar
1
Ref3Reference 3nVarChar
27
SSIExmptSSI ExemptionVarChar
Y) Yes
N) No
1
SignMsgSignature Input MessageText
16
SignDigestSignature DigestText
16
CertifNumCertification NumbernVarChar
50
KeyVersionPrivate Key VersionInt
11
CUPUnique Code of ProjectInt
11OCUP
CUP Codes
CIGContract Code IdentificationInt
11OCIG
CIG Codes
SupplCodeSupplementary CodenVarChar
127
SPSrcTypeService Posting Source TypeInt
11
SPSrcIDService Posting Source IDInt
11
SPSrcDLNService Post. Source DeliveryInt
11
DeferedTaxDeferred TaxVarChar
Y) Yes
N) No
1
N
AgrNoBlanket Agreement NumberInt
11OOAT
Blanket Agreement
SeqNumSequence NumberInt
11
ECDPosTypECD Posting TypeVarChar
N) Normal
E) Statement
1
N
RptPeriodReporting PeriodnVarChar
5
RptMonthReporting MonthDate
8
ExTransIdExposed Transaction IDInt
11

Table relationship map

SELECT statement

SELECT OJDT.BatchNum AS 'Journal Voucher No.', OJDT.TransId AS 'Transaction Number', OJDT.BtfStatus AS 'Status', OJDT.TransType AS 'Original Journal', OJDT.BaseRef AS 'Base Reference', OJDT.RefDate AS 'Posting Date', OJDT.Memo AS 'Details', OJDT.Ref1 AS 'Reference 1', OJDT.Ref2 AS 'Reference 2', OJDT.CreatedBy AS 'Original', OJDT.LocTotal AS 'Total (LC)', OJDT.FcTotal AS 'Total (FC)', OJDT.SysTotal AS 'Total (SC)', OJDT.TransCode AS 'Transaction Code', OJDT.OrignCurr AS 'Revaluation Currency', OJDT.TransRate AS 'Revaluation Rate', OJDT.BtfLine AS 'Row in Voucher', OJDT.TransCurr AS 'Transaction Currency', OJDT.Project AS 'Project Code', OJDT.DueDate AS 'Due Date', OJDT.TaxDate AS 'Document Date', OJDT.PCAddition AS 'PC Addition', OJDT.FinncPriod AS 'Posting Period', OJDT.DataSource AS 'Data Source', OJDT.UpdateDate AS 'Date of Update', OJDT.CreateDate AS 'Recording Date', OJDT.UserSign AS 'User Signature', OJDT.UserSign2 AS 'Updating User', OJDT.RefndRprt AS 'Repayment Report', OJDT.LogInstanc AS 'Log Instance', OJDT.ObjType AS 'Object Type', OJDT.Indicator AS 'Indicator Code', OJDT.AdjTran AS 'Adjusting Transaction', OJDT.RevSource AS 'Revaluation Source', OJDT.StornoDate AS 'Reversal Date', OJDT.StornoToTr AS 'Reverse Transaction', OJDT.AutoStorno AS 'Use Auto-Reverse', OJDT.Corisptivi AS 'Transaction Values', OJDT.VatDate AS 'VAT Date', OJDT.StampTax AS 'Stamp Tax', OJDT.Series AS 'Series', OJDT.Number AS 'Number', OJDT.AutoVAT AS 'Automatic VAT', OJDT.DocSeries AS 'Document Series', OJDT.FolioPref AS 'Folio Prefix String', OJDT.FolioNum AS 'Folio Number', OJDT.CreateTime AS 'Generation Time', OJDT.BlockDunn AS 'Block Dunning Letter', OJDT.ReportEU AS 'Include in EU Report', OJDT.Report347 AS 'Include in 347 Report', OJDT.Printed AS 'Printed', OJDT.DocType AS 'Document Type', OJDT.AttNum AS 'Number of Attachments', OJDT.GenRegNo AS 'Generate Reg. No. or Not', OJDT.RG23APart2 AS 'RG23A Part2 No', OJDT.RG23CPart2 AS 'RG23C Part2 No', OJDT.MatType AS 'Material Type', OJDT.Creator AS 'Creator Name', OJDT.Approver AS 'Approver Name', OJDT.Location AS 'Loc.', OJDT.SeqCode AS 'Sequence Code', OJDT.Serial AS 'Serial Number', OJDT.SeriesStr AS 'Series String', OJDT.SubStr AS 'Subseries String', OJDT.AutoWT AS 'Automatic WTax', OJDT.WTSum AS 'WTax Amount', OJDT.WTSumSC AS 'WTax Amount (SC)', OJDT.WTSumFC AS 'WTax Amount (FC)', OJDT.WTApplied AS 'Applied WTax', OJDT.WTAppliedS AS 'Applied WTax (SC)', OJDT.WTAppliedF AS 'Applied WTax (FC)', OJDT.BaseAmnt AS 'Base Amount', OJDT.BaseAmntSC AS 'Base Amount (SC)', OJDT.BaseAmntFC AS 'Base Amount (FC)', OJDT.BaseVtAt AS 'WTax Base VAT Amount', OJDT.BaseVtAtSC AS 'WTax Base VAT Amount (SC)', OJDT.BaseVtAtFC AS 'WTax Base VAT Amount (FC)', OJDT.VersionNum AS 'Version Number', OJDT.BaseTrans AS 'Base Transaction Number', OJDT.ResidenNum AS 'Residence Number', OJDT.OperatCode AS 'Operation Code', OJDT.Ref3 AS 'Reference 3', OJDT.SSIExmpt AS 'SSI Exemption', OJDT.SignMsg AS 'Signature Input Message', OJDT.SignDigest AS 'Signature Digest', OJDT.CertifNum AS 'Certification Number', OJDT.KeyVersion AS 'Private Key Version', OJDT.CUP AS 'Unique Code of Project', OJDT.CIG AS 'Contract Code Identification', OJDT.SupplCode AS 'Supplementary Code', OJDT.SPSrcType AS 'Service Posting Source Type', OJDT.SPSrcID AS 'Service Posting Source ID', OJDT.SPSrcDLN AS 'Service Post. Source Delivery', OJDT.DeferedTax AS 'Deferred Tax', OJDT.AgrNo AS 'Blanket Agreement Number', OJDT.SeqNum AS 'Sequence Number', OJDT.ECDPosTyp AS 'ECD Posting Type', OJDT.RptPeriod AS 'Reporting Period', OJDT.RptMonth AS 'Reporting Month', OJDT.ExTransId AS 'Exposed Transaction ID' FROM OJDT AS OJDT

Related information


Jdt Num JdtNum Property· Table: OJDT
Returns the number of the journal transaction in the system. Field name: JDT_NUM.
· Table: OJDT    Parent: Journal Entries JournalEntries Object· Table: OJDT OBTF
OJDT SQL Table

Blanket Agreement OOAT SQL Table

Journal Vouchers List OBTD SQL Table

CIG Codes OCIG SQL Table

CUP Codes OCUP SQL Table

JE Document Type OJET SQL Table

Posting Period OFPR SQL Table

Indicator OIDC SQL Table

Location OLCT SQL Table

Object Settings - History ADP1 SQL Table

Currency Codes OCRN SQL Table

Project Codes OPRJ SQL Table

Journal Entry Codes OTRC 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