biuan SAP® BUSINESS ONE SDK
DTW Journal Voucher - Rows
API Journal Entries Lines / BPLID
BTF1 - Journal Voucher - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TransIdTransaction KeyInt
11OBTF
Journal Voucher Entry
Line_IDRow NumberInt
11
0
AccountAccount CodenVarChar
15OACT
G/L Accounts
DebitDebit AmountNum
20
CreditCredit AmountNum
20
SYSCredSystem Credit AmountNum
20
SYSDebSystem Debit AmountNum
20
FCDebitFC Debit AmountNum
20
FCCreditFC Credit AmountNum
20
FCCurrency KEYForeign CurrencynVarChar
3
CURRENCYNo
DueDateDue DateDate
8
SourceIDSource KeyInt
11
SourceLineSource Row NumberInt
6
ShortName KEYCard/Account CodenVarChar
15
INTRNMATCHNo
IntrnMatchInternal Reconciliation No.Int
11
0
ExtrMatchExternal Reconciliation No.Int
11
0
ContraActOffset AccountnVarChar
15
LineMemoRow DetailsnVarChar
50
Ref3LineReference 3nVarChar
27
TransTypeOriginal JournalnVarChar
-1)
20
-1
RefDatePosting DateDate
8
Ref2DatePosting Date 2Date
8
Ref1Reference 1nVarChar
100
Ref2Reference 2nVarChar
100
CreatedByOriginInt
11
BaseRefBase ReferencenVarChar
11
ProjectProject CodenVarChar
20OPRJ
Project Codes
TransCodeTransaction CodenVarChar
4OTRC
Journal Entry Codes
ProfitCodeDistribution RulenVarChar
8OOCR
Distribution Rule
TaxDateDocument DateDate
8
SystemRateSystem PriceNum
20
MthDateReconciliation DateDate
8
ToMthSumReconciliation TotalNum
20
UserSignUser SignatureInt
6OUSR
Users
BatchNum KEYJournal Voucher No.Int
11OBTD
Journal Vouchers List
BATCH_IDXNo
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) FC
S) System
N) No
1
N
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
30
VatDateDocument DateDate
8
PaymentRefPayment ReferencenVarChar
27
SYSBaseSumSystem Base AmountNum
20
MultMatchMultiple BP Reconciliation No.Int
11
0
VatLineVAT RowVarChar
Y) Yes
N) No
1
N
VatAmountVAT AmountNum
20
SYSVatSumSystem VAT AmountNum
20
ClosedClosedVarChar
1
N
GrossValueGross ValueNum
20
CheckAbsInternal Check No.Int
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 BTF1.TransId AS 'Transaction Key', BTF1.Line_ID AS 'Row Number', BTF1.Account AS 'Account Code', BTF1.Debit AS 'Debit Amount', BTF1.Credit AS 'Credit Amount', BTF1.SYSCred AS 'System Credit Amount', BTF1.SYSDeb AS 'System Debit Amount', BTF1.FCDebit AS 'FC Debit Amount', BTF1.FCCredit AS 'FC Credit Amount', BTF1.FCCurrency AS 'Foreign Currency', BTF1.DueDate AS 'Due Date', BTF1.SourceID AS 'Source Key', BTF1.SourceLine AS 'Source Row Number', BTF1.ShortName AS 'Card/Account Code', BTF1.IntrnMatch AS 'Internal Reconciliation No.', BTF1.ExtrMatch AS 'External Reconciliation No.', BTF1.ContraAct AS 'Offset Account', BTF1.LineMemo AS 'Row Details', BTF1.Ref3Line AS 'Reference 3', BTF1.TransType AS 'Original Journal', BTF1.RefDate AS 'Posting Date', BTF1.Ref2Date AS 'Posting Date 2', BTF1.Ref1 AS 'Reference 1', BTF1.Ref2 AS 'Reference 2', BTF1.CreatedBy AS 'Origin', BTF1.BaseRef AS 'Base Reference', BTF1.Project AS 'Project Code', BTF1.TransCode AS 'Transaction Code', BTF1.ProfitCode AS 'Distribution Rule', BTF1.TaxDate AS 'Document Date', BTF1.SystemRate AS 'System Price', BTF1.MthDate AS 'Reconciliation Date', BTF1.ToMthSum AS 'Reconciliation Total', BTF1.UserSign AS 'User Signature', BTF1.BatchNum AS 'Journal Voucher No.', BTF1.FinncPriod AS 'Posting Period', BTF1.RelTransId AS 'Linked Transaction Key', BTF1.RelLineID AS 'Linked Row No.', BTF1.RelType AS 'Link Type', BTF1.LogInstanc AS 'Log Instance', BTF1.VatGroup AS 'Tax Group', BTF1.BaseSum AS 'Base Amount', BTF1.VatRate AS 'Tax %', BTF1.Indicator AS 'Indicator Code', BTF1.AdjTran AS 'Adjusting Trans. (Period 13)', BTF1.RevSource AS 'Revaluation Source', BTF1.ObjType AS 'Object Type', BTF1.VatDate AS 'Document Date', BTF1.PaymentRef AS 'Payment Reference', BTF1.SYSBaseSum AS 'System Base Amount', BTF1.MultMatch AS 'Multiple BP Reconciliation No.', BTF1.VatLine AS 'VAT Row', BTF1.VatAmount AS 'VAT Amount', BTF1.SYSVatSum AS 'System VAT Amount', BTF1.Closed AS 'Closed', BTF1.GrossValue AS 'Gross Value', BTF1.CheckAbs AS 'Internal Check No.', BTF1.LineType AS 'LineType', BTF1.DebCred AS 'Debit Credit Line Indicator', BTF1.SequenceNr AS 'Assigned Sequence No.', BTF1.StornoAcc AS 'Storno Account Code', BTF1.BalDueDeb AS 'Balance Due - Debit', BTF1.BalDueCred AS 'Balance Due - Credit', BTF1.BalFcDeb AS 'Balance Due FC - Debit', BTF1.BalFcCred AS 'Balance Due FC - Credit', BTF1.BalScDeb AS 'Balance Due SC - Debit', BTF1.BalScCred AS 'Balance Due SC - Credit', BTF1.IsNet AS 'Is Net', BTF1.DunWizBlck AS 'Wizard Dunning Block', BTF1.DunnLevel AS 'Dunning Level', BTF1.DunDate AS 'Last Dunning Date', BTF1.TaxType AS 'Tax Type', BTF1.TaxPostAcc AS 'Tax Posting Account', BTF1.StaCode AS 'Authority Code', BTF1.StaType AS 'Authority Type', BTF1.TaxCode AS 'Tax Code', BTF1.ValidFrom AS 'Valid From', BTF1.GrossValFc AS 'Gross Value (FC)', BTF1.LvlUpdDate AS 'Dunning Level Update Date', BTF1.OcrCode2 AS 'Costing Code 2', BTF1.OcrCode3 AS 'Costing Code 3', BTF1.OcrCode4 AS 'Costing Code 4', BTF1.OcrCode5 AS 'Costing Code 5', BTF1.MIEntry AS 'MI Entry when include this OB', BTF1.MIVEntry AS 'A/P Monthly Invoice', BTF1.ClsInTP AS 'Tax Payment Wizard', BTF1.CenVatCom AS 'CENVAT Component', BTF1.MatType AS 'Material Type', BTF1.PstngType AS 'Posting Type', BTF1.ValidFrom2 AS 'Valid from2', BTF1.ValidFrom3 AS 'Valid from3', BTF1.ValidFrom4 AS 'Valid from4', BTF1.ValidFrom5 AS 'Valid from5', BTF1.Location AS 'Loc.', BTF1.WTaxCode AS 'Withholding Tax Code', BTF1.EquVatRate AS 'Equalization Tax %', BTF1.EquVatSum AS 'Equalization Tax Amount', BTF1.SYSEquSum AS 'System Equalization Tax Amount', BTF1.TotalVat AS 'Total Tax', BTF1.SYSTVat AS 'System Total Tax', BTF1.WTLiable AS 'WTax-Liable', BTF1.WTLine AS 'WTax Row', BTF1.WTApplied AS 'Applied WTax', BTF1.WTAppliedS AS 'Applied WTax (SC)', BTF1.WTAppliedF AS 'Applied WTax (FC)', BTF1.WTSum AS 'WTax Amount', BTF1.WTSumFC AS 'WTax Amount (FC)', BTF1.WTSumSC AS 'WTax Amount (SC)', BTF1.PayBlock AS 'Payment Block', BTF1.PayBlckRef AS 'Payment Block Abs Entry', BTF1.LicTradNum AS 'Federal Tax ID', BTF1.InterimTyp AS 'Interim Account Type', BTF1.DprId AS 'Down Payment Request Key', BTF1.MatchRef AS 'Reconciliation Reference', BTF1.Ordered AS 'Payment Ordered', BTF1.CUP AS 'Unique Code of Project', BTF1.CIG AS 'Contract Code Identification', BTF1.BPLId AS 'Branch', BTF1.BPLName AS 'Branch Name', BTF1.VatRegNum AS 'VAT Reg. Number', BTF1.SLEDGERF AS 'Subledger Flag', BTF1.ExTransId AS 'Exposed Transaction ID', BTF1.InitRef2 AS 'Initial Reference 2', BTF1.InitRef3Ln AS 'Initial Reference 3' FROM BTF1 AS BTF1

Related information


BPLID BPLID Property· Table: BTF1
property BPLID
· Table: BTF1    Parent: Journal Entries Lines JournalEntries_Lines Object· Table: JDT1 BTF1
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 Voucher Entry OBTF 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates