biuan SAP® BUSINESS ONE SDK
API AJD1
AJD1 - Journal Entry - History - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TransId KEY UNIQUETransaction KeyInt
11OJDT
Journal Entry
PRIMARYYes
Line_IDRow NumberInt
11
0
Account KEYAccount CodenVarChar
15OACT
G/L Accounts
ACCOUNTNo
DebitDebit AmountNum
20
CreditCredit AmountNum
20
SYSCredCredit Amount (SC)Num
20
SYSDebDebit Amount (SC)Num
20
FCDebitDebit Amount (FC)Num
20
FCCreditCredit Amount (FC)Num
20
FCCurrency KEYForeign CurrencynVarChar
3
CURRENCYNo
DueDate KEYValue DateDate
8
DUEDATENo
SourceIDSource KeyInt
11
SourceLineSource Row No.Int
6
ShortName KEYG/L Acc./BP CodenVarChar
15
SHORT_NAMENo
IntrnMatchInternal Reconciliation No.Int
11
0
ExtrMatchExternal Reconciliation No.Int
11
0
ContraActCounter AccountnVarChar
15
LineMemoRow DetailsnVarChar
50
Ref3LineReference 3nVarChar
27
TransType KEYOriginal JournalnVarChar
15) Delivery
16) Returns
203) A/R Down Payment
13) A/R Invoice
14) A/R Credit Memo
132) Correction Invoice
(-0) (-
20) Goods Receipt
21) Goods Return
204) A/P Down Payment
18) A/P Invoice
19) A/P Credit Memo
69) Landed Costs
163) A/P Correction Invoice
(-1) (-
24) Incoming Payment
25) Deposit
46) Vendor Payment
57) Checks for Payment
76) Postdated Deposit
182) BoE Transaction
(-2) (-
-2) Opening Balance
-3) Closing Balance
30) Journal Entry
(-3) (-
58) Stock Update
59) Goods Receipt
60) Goods Issue
67) Inventory Transfers
68) Work Instructions
162) Inventory Valuation
(-4) (-
-1) All Transactions
321) Internal Reconciliation
140000009) Outgoing Excise Invoice
10000079) TDS Adjustment
164) A/P Correction Invoice Reversal
165) A/R Correction Invoice
166) A/R Correction Invoice Reversal
140000010) Incoming Excise Invoice
(-5) (-
202) Production Order
20
-1TRANS_TYPENo
RefDate KEYPosting DateDate
8
REFDATENo
Ref2DatePosting Date 3Date
8
Ref1Ref. 1nVarChar
100
Ref2Ref. 2nVarChar
100
CreatedByOriginInt
11
BaseRefBase ReferencenVarChar
11
ProjectProject CodenVarChar
20OPRJ
Project Codes
TransCodeTransaction CodenVarChar
4OTRC
Journal Entry Codes
ProfitCode KEYDistribution RulenVarChar
8OOCR
Distribution Rule
PROFIT_IDNo
TaxDateTax DateDate
8
SystemRatePrice (SC)Num
20
MthDateReconciliation DateDate
8
ToMthSumReconciliation TotalNum
20
UserSignUser SignatureInt
6OUSR
Users
BatchNumJournal Voucher No.Int
11OBTD
Journal Vouchers List
FinncPriodPosting PeriodInt
11OFPR
Posting Period
RelTransIdLinked Transaction KeyInt
11
-1
RelLineIDLinked Row No.Int
11
-1
RelTypeLink TypeVarChar
N) Without Link
D) WTax Deduction - Correction
1
N
LogInstancLog InstanceInt
11
0
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
BaseSumBase AmountNum
20
VatRateTax %Num
20
IndicatorIndicator CodenVarChar
2OIDC
Indicator
AdjTranAdjusting Trans. (Period 13)VarChar
Y) Yes
N) No
1
N
RevSourceRevaluation SourceVarChar
F) Foreign Currency
S) System
N) No
1
N
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
30
VatDateTax DateDate
8
PaymentRefPayment ReferencenVarChar
27
SYSBaseSumSystem Base AmountNum
20
MultMatchMultiple BP Reconciliation No.Int
11
0
VatLineVAT LineVarChar
Y) Yes
N) No
1
N
VatAmountVAT AmountNum
20
SYSVatSumSystem VAT AmountNum
20
ClosedClosedVarChar
1
N
GrossValueGross ValueNum
20
CheckAbsCheck AbsInt
11
LineTypeLineTypeInt
11
0
DebCredDebit Credit Line IndicatorVarChar
D) Debit
C) Credit
1
SequenceNrAssigned Sequence No.Int
11
0
StornoAccStorno Account CodenVarChar
15OACT
G/L Accounts
BalDueDebBalance Due - DebitNum
20
BalDueCredBalance Due - CreditNum
20
BalFcDebBalance Due FC - DebitNum
20
BalFcCredBalance Due FC - CreditNum
20
BalScDebBalance Due SC - DebitNum
20
BalScCredBalance Due SC - CreditNum
20
IsNetIs NetVarChar
Y) Yes
N) No
1
Y
DunWizBlckWizard Dunning BlockVarChar
N) No
Y) Yes
1
N
DunnLevelDunning LevelInt
11ODUN
Dunning Letters
0
DunDateLast Dunning DateDate
8
TaxTypeTax TypeInt
6
0
TaxPostAccTax Posting AccountVarChar
N)
R) Sales Tax Account
P) Purchasing Tax Account
1
N
StaCodeAuthority CodenVarChar
8OSTA
Sales Tax Authorities
StaTypeAuthority TypeInt
11OSTT
Sales Tax Authorities Type
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
ValidFromValid FromDate
8
19000101
GrossValFcGross Value (FC)Num
20
LvlUpdDateDunning Level Update DateDate
8
OcrCode2Costing Code 2nVarChar
8OOCR
Distribution Rule
OcrCode3Costing Code 3nVarChar
8OOCR
Distribution Rule
OcrCode4Costing Code 4nVarChar
8OOCR
Distribution Rule
OcrCode5Costing Code 5nVarChar
8OOCR
Distribution Rule
MIEntryMI Entry when include this OBInt
11
0
MIVEntryA/P Monthly InvoiceInt
11
0
ClsInTPTax Payment WizardInt
11
0
CenVatComCENVAT ComponentInt
11
-1
MatTypeMaterial TypeInt
11
-1
PstngTypePosting TypeInt
11
0
ValidFrom2Valid from2Date
8
19000101
ValidFrom3Valid from3Date
8
19000101
ValidFrom4Valid from4Date
8
19000101
ValidFrom5Valid from5Date
8
19000101
LocationLoc.Int
11OLCT
Location
WTaxCodeWithholding Tax CodenVarChar
4OWHT
Withholding Tax
EquVatRateEqualization Tax %Num
20
EquVatSumEqualization Tax AmountNum
20
SYSEquSumSystem Equalization Tax AmountNum
20
TotalVatTotal TaxNum
20
SYSTVatSystem Total TaxNum
20
WTLiableWTax-LiableVarChar
Y) Yes
N) No
1
N
WTLineWTax RowVarChar
Y) Yes
N) No
1
N
WTAppliedApplied WTaxNum
20
WTAppliedSApplied WTax (SC)Num
20
WTAppliedFApplied WTax (FC)Num
20
WTSumWTax AmountNum
20
WTSumFCWTax Amount (FC)Num
20
WTSumSCWTax Amount (SC)Num
20
PayBlockPayment BlockVarChar
Y) Yes
N) No
1
N
PayBlckRefPayment Block Abs EntryInt
11OPYB
Payment Block
LicTradNumFederal Tax IDnVarChar
32
InterimTypInterim Account TypeInt
11
0
DprIdDown Payment Request KeyInt
11
MatchRefReconciliation ReferencenVarChar
20
OrderedPayment OrderedVarChar
Y) Yes
N) No
1
N
CUPUnique Code of ProjectInt
11OCUP
CUP Codes
CIGContract Code IdentificationInt
11OCIG
CIG Codes
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
VatRegNumVAT Reg. NumbernVarChar
32
SLEDGERFSubledger FlagVarChar
1
ExTransIdExposed Transaction IDInt
11
InitRef2Initial Reference 2nVarChar
100
InitRef3LnInitial Reference 3nVarChar
27

Table relationship map

SELECT statement

SELECT AJD1.TransId AS 'Transaction Key', AJD1.Line_ID AS 'Row Number', AJD1.Account AS 'Account Code', AJD1.Debit AS 'Debit Amount', AJD1.Credit AS 'Credit Amount', AJD1.SYSCred AS 'Credit Amount (SC)', AJD1.SYSDeb AS 'Debit Amount (SC)', AJD1.FCDebit AS 'Debit Amount (FC)', AJD1.FCCredit AS 'Credit Amount (FC)', AJD1.FCCurrency AS 'Foreign Currency', AJD1.DueDate AS 'Value Date', AJD1.SourceID AS 'Source Key', AJD1.SourceLine AS 'Source Row No.', AJD1.ShortName AS 'G/L Acc./BP Code', AJD1.IntrnMatch AS 'Internal Reconciliation No.', AJD1.ExtrMatch AS 'External Reconciliation No.', AJD1.ContraAct AS 'Counter Account', AJD1.LineMemo AS 'Row Details', AJD1.Ref3Line AS 'Reference 3', AJD1.TransType AS 'Original Journal', AJD1.RefDate AS 'Posting Date', AJD1.Ref2Date AS 'Posting Date 3', AJD1.Ref1 AS 'Ref. 1', AJD1.Ref2 AS 'Ref. 2', AJD1.CreatedBy AS 'Origin', AJD1.BaseRef AS 'Base Reference', AJD1.Project AS 'Project Code', AJD1.TransCode AS 'Transaction Code', AJD1.ProfitCode AS 'Distribution Rule', AJD1.TaxDate AS 'Tax Date', AJD1.SystemRate AS 'Price (SC)', AJD1.MthDate AS 'Reconciliation Date', AJD1.ToMthSum AS 'Reconciliation Total', AJD1.UserSign AS 'User Signature', AJD1.BatchNum AS 'Journal Voucher No.', AJD1.FinncPriod AS 'Posting Period', AJD1.RelTransId AS 'Linked Transaction Key', AJD1.RelLineID AS 'Linked Row No.', AJD1.RelType AS 'Link Type', AJD1.LogInstanc AS 'Log Instance', AJD1.VatGroup AS 'Tax Group', AJD1.BaseSum AS 'Base Amount', AJD1.VatRate AS 'Tax %', AJD1.Indicator AS 'Indicator Code', AJD1.AdjTran AS 'Adjusting Trans. (Period 13)', AJD1.RevSource AS 'Revaluation Source', AJD1.ObjType AS 'Object Type', AJD1.VatDate AS 'Tax Date', AJD1.PaymentRef AS 'Payment Reference', AJD1.SYSBaseSum AS 'System Base Amount', AJD1.MultMatch AS 'Multiple BP Reconciliation No.', AJD1.VatLine AS 'VAT Line', AJD1.VatAmount AS 'VAT Amount', AJD1.SYSVatSum AS 'System VAT Amount', AJD1.Closed AS 'Closed', AJD1.GrossValue AS 'Gross Value', AJD1.CheckAbs AS 'Check Abs', AJD1.LineType AS 'LineType', AJD1.DebCred AS 'Debit Credit Line Indicator', AJD1.SequenceNr AS 'Assigned Sequence No.', AJD1.StornoAcc AS 'Storno Account Code', AJD1.BalDueDeb AS 'Balance Due - Debit', AJD1.BalDueCred AS 'Balance Due - Credit', AJD1.BalFcDeb AS 'Balance Due FC - Debit', AJD1.BalFcCred AS 'Balance Due FC - Credit', AJD1.BalScDeb AS 'Balance Due SC - Debit', AJD1.BalScCred AS 'Balance Due SC - Credit', AJD1.IsNet AS 'Is Net', AJD1.DunWizBlck AS 'Wizard Dunning Block', AJD1.DunnLevel AS 'Dunning Level', AJD1.DunDate AS 'Last Dunning Date', AJD1.TaxType AS 'Tax Type', AJD1.TaxPostAcc AS 'Tax Posting Account', AJD1.StaCode AS 'Authority Code', AJD1.StaType AS 'Authority Type', AJD1.TaxCode AS 'Tax Code', AJD1.ValidFrom AS 'Valid From', AJD1.GrossValFc AS 'Gross Value (FC)', AJD1.LvlUpdDate AS 'Dunning Level Update Date', AJD1.OcrCode2 AS 'Costing Code 2', AJD1.OcrCode3 AS 'Costing Code 3', AJD1.OcrCode4 AS 'Costing Code 4', AJD1.OcrCode5 AS 'Costing Code 5', AJD1.MIEntry AS 'MI Entry when include this OB', AJD1.MIVEntry AS 'A/P Monthly Invoice', AJD1.ClsInTP AS 'Tax Payment Wizard', AJD1.CenVatCom AS 'CENVAT Component', AJD1.MatType AS 'Material Type', AJD1.PstngType AS 'Posting Type', AJD1.ValidFrom2 AS 'Valid from2', AJD1.ValidFrom3 AS 'Valid from3', AJD1.ValidFrom4 AS 'Valid from4', AJD1.ValidFrom5 AS 'Valid from5', AJD1.Location AS 'Loc.', AJD1.WTaxCode AS 'Withholding Tax Code', AJD1.EquVatRate AS 'Equalization Tax %', AJD1.EquVatSum AS 'Equalization Tax Amount', AJD1.SYSEquSum AS 'System Equalization Tax Amount', AJD1.TotalVat AS 'Total Tax', AJD1.SYSTVat AS 'System Total Tax', AJD1.WTLiable AS 'WTax-Liable', AJD1.WTLine AS 'WTax Row', AJD1.WTApplied AS 'Applied WTax', AJD1.WTAppliedS AS 'Applied WTax (SC)', AJD1.WTAppliedF AS 'Applied WTax (FC)', AJD1.WTSum AS 'WTax Amount', AJD1.WTSumFC AS 'WTax Amount (FC)', AJD1.WTSumSC AS 'WTax Amount (SC)', AJD1.PayBlock AS 'Payment Block', AJD1.PayBlckRef AS 'Payment Block Abs Entry', AJD1.LicTradNum AS 'Federal Tax ID', AJD1.InterimTyp AS 'Interim Account Type', AJD1.DprId AS 'Down Payment Request Key', AJD1.MatchRef AS 'Reconciliation Reference', AJD1.Ordered AS 'Payment Ordered', AJD1.CUP AS 'Unique Code of Project', AJD1.CIG AS 'Contract Code Identification', AJD1.BPLId AS 'Branch', AJD1.BPLName AS 'Branch Name', AJD1.VatRegNum AS 'VAT Reg. Number', AJD1.SLEDGERF AS 'Subledger Flag', AJD1.ExTransId AS 'Exposed Transaction ID', AJD1.InitRef2 AS 'Initial Reference 2', AJD1.InitRef3Ln AS 'Initial Reference 3' FROM AJD1 AS AJD1

Related information


G/L Accounts OACT SQL Table

Journal Vouchers List OBTD SQL Table

Business Place OBPL SQL Table

CIG Codes OCIG SQL Table

CUP Codes OCUP SQL Table

Dunning Letters ODUN SQL Table

Posting Period OFPR SQL Table

Indicator OIDC SQL Table

Location OLCT SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Payment Block OPYB SQL Table

Project Codes OPRJ SQL Table

Sales Tax Authorities OSTA SQL Table

Sales Tax Authorities Type OSTT SQL Table

Sales Tax Codes OSTC SQL Table

Journal Entry Codes OTRC SQL Table

Journal Entry OJDT SQL Table

Users OUSR SQL Table

Tax Definition OVTG SQL Table

Withholding Tax OWHT 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