biuan SAP® BUSINESS ONE SDK
DTW Journal Voucher Withholding Tax - History
API Withholding Tax Data / Base Doc Entry
BTF2 - Journal Voucher Withholding Tax - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEYInternal NumberInt
11OBTF
Journal Voucher Entry
SECONDERYNo
WTCodeWTax CodenVarChar
4OWHT
Withholding Tax
RateRateNum
20
TaxbleAmntTaxable AmountNum
20
TxblAmntSCTaxable Amount (SC)Num
20
TxblAmntFCTaxable Amount (FC)Num
20
WTAmntWTax AmountNum
20
WTAmntSCWTax Amount (SC)Num
20
WTAmntFCWTax Amount (FC)Num
20
ApplAmntApplied WTax AmountNum
20
ApplAmntSCApplied WTax Amount (SC)Num
20
ApplAmntFCApplied WTax Amount (FC)Num
20
CategoryCategoryVarChar
P) Payment
I) Invoice
1
CriteriaCriteriaVarChar
Y) Accrual
N) Cash
1
AccountG/L AccountnVarChar
15OACT
G/L Accounts
TypeWithholding Tax TypeVarChar
V) VAT Withholding
I) Income Tax Withholding
1
RoundTypeRounding TypeVarChar
T) Truncated
C) Commercial Values
N) No Rounding
1
BaseTypeBase TypeVarChar
G) Gross
N) Net
V) VAT
1
BaseAbsEntBase Document ReferenceInt
11
-1
BaseLineBase RowInt
11
BaseNumBase Document TypeInt
-1)
11
LineNumRow NumberInt
11
BaseRefBase Document ReferenceInt
11
StatusStatusVarChar
O) Open
C) Closed
1
O
TrgTypeTarget Document TypeInt
11
TrgAbsEntrTarget Doc. Internal No.Int
11
-1
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
30
Doc1LineNoDOC1 Line NumberInt
11
-1
WtLineTypeWTax Row TypeVarChar
D) Document Level WTax
L) Row Level WTax
1
D
TxblCurrTaxable Currency from Doc RownVarChar
3
DtblCurrDeductible CurrencynVarChar
3
DtblRateRate for Deductible AmountNum
20
txblRateRate for Taxable AmountNum
20
DtblAmountDeductible AmountNum
20
TdsAccTDS AccountnVarChar
15OACT
G/L Accounts
SurAccSurcharge AccountnVarChar
15OACT
G/L Accounts
CessAccCess AccountnVarChar
15OACT
G/L Accounts
HscAccHSC AccountnVarChar
15OACT
G/L Accounts
TdsRateTDS RateNum
20
SurRateSurcharge RateNum
20
CessRateCess RateNum
20
HscRateHSC RateNum
20
TdsBAmtTDS Base AmountNum
20
TdsBAmtSCTDS Base Amount (SC)Num
20
TdsBAmtFCTDS Base Amount (FC)Num
20
SurBAmtSurcharge Base AmountNum
20
SurBAmtSCSurcharge Base Amount (SC)Num
20
SurBAmtFCSurcharge Base Amount (FC)Num
20
CessBAmtCess Base AmountNum
20
CessBAmtSCCess Base Amount (SC)Num
20
CessBAmtFCCess Base Amount (FC)Num
20
HscBAmtHSC Base AmountNum
20
HscBAmtSCHSC Base Amount (SC)Num
20
HscBAmtFCHSC Base Amount (FC)Num
20
TdsAmntTDS Tax AmountNum
20
TdsAmntSCTDS Tax Amount (SC)Num
20
TdsAmntFCTDS Tax Amount (FC)Num
20
SurAmntSurcharge Tax AmountNum
20
SurAmntSCSurcharge Tax Amount (SC)Num
20
SurAmntFCSurcharge Tax Amount (FC)Num
20
CessAmntCess Tax AmountNum
20
CessAmntSCCess Tax Amount (SC)Num
20
CessAmntFCCess Tax Amount (FC)Num
20
HscAmntHSC Tax AmountNum
20
HscAmntSCHSC Tax Amount (SC)Num
20
HscAmntFCHSC Tax Amount (FC)Num
20
TdsApplApplied TDS AmountNum
20
TdsApplSCApplied TDS Amount (SC)Num
20
TdsApplFCApplied TDS Amount (FC)Num
20
SurApplApplied Surcharge AmountNum
20
SurApplSCApplied Surcharge Amount (SC)Num
20
SurApplFCApplied Surcharge Amount (FC)Num
20
CessApplApplied Cess AmountNum
20
CessApplSCApplied Cess Amount (SC)Num
20
CessApplFCApplied Cess Amount (FC)Num
20
HscApplApplied HSC AmountNum
20
HscApplSCApplied HSC Amount (SC)Num
20
HscApplFCApplied HSC Amount (FC)Num
20
BatchNum KEY UNIQUEJournal Voucher No.Int
11OBTD
Journal Vouchers List
PRIMARYYes
InCSTCodeCST Code IncomingnVarChar
2
OutCSTCodeCST Code OutgoingnVarChar
2
DpmWTAplDPM WT Applied AmountNum
20
DpmWTAplSCDPM WT Applied Amount (SC)Num
20
DpmWTAplFCDPM WT Applied Amount (FC)Num
20

Table relationship map

SELECT statement

SELECT BTF2.AbsEntry AS 'Internal Number', BTF2.WTCode AS 'WTax Code', BTF2.Rate AS 'Rate', BTF2.TaxbleAmnt AS 'Taxable Amount', BTF2.TxblAmntSC AS 'Taxable Amount (SC)', BTF2.TxblAmntFC AS 'Taxable Amount (FC)', BTF2.WTAmnt AS 'WTax Amount', BTF2.WTAmntSC AS 'WTax Amount (SC)', BTF2.WTAmntFC AS 'WTax Amount (FC)', BTF2.ApplAmnt AS 'Applied WTax Amount', BTF2.ApplAmntSC AS 'Applied WTax Amount (SC)', BTF2.ApplAmntFC AS 'Applied WTax Amount (FC)', BTF2.Category AS 'Category', BTF2.Criteria AS 'Criteria', BTF2.Account AS 'G/L Account', BTF2.Type AS 'Withholding Tax Type', BTF2.RoundType AS 'Rounding Type', BTF2.BaseType AS 'Base Type', BTF2.BaseAbsEnt AS 'Base Document Reference', BTF2.BaseLine AS 'Base Row', BTF2.BaseNum AS 'Base Document Type', BTF2.LineNum AS 'Row Number', BTF2.BaseRef AS 'Base Document Reference', BTF2.Status AS 'Status', BTF2.TrgType AS 'Target Document Type', BTF2.TrgAbsEntr AS 'Target Doc. Internal No.', BTF2.LogInstanc AS 'Log Instance', BTF2.ObjType AS 'Object Type', BTF2.Doc1LineNo AS 'DOC1 Line Number', BTF2.WtLineType AS 'WTax Row Type', BTF2.TxblCurr AS 'Taxable Currency from Doc Row', BTF2.DtblCurr AS 'Deductible Currency', BTF2.DtblRate AS 'Rate for Deductible Amount', BTF2.txblRate AS 'Rate for Taxable Amount', BTF2.DtblAmount AS 'Deductible Amount', BTF2.TdsAcc AS 'TDS Account', BTF2.SurAcc AS 'Surcharge Account', BTF2.CessAcc AS 'Cess Account', BTF2.HscAcc AS 'HSC Account', BTF2.TdsRate AS 'TDS Rate', BTF2.SurRate AS 'Surcharge Rate', BTF2.CessRate AS 'Cess Rate', BTF2.HscRate AS 'HSC Rate', BTF2.TdsBAmt AS 'TDS Base Amount', BTF2.TdsBAmtSC AS 'TDS Base Amount (SC)', BTF2.TdsBAmtFC AS 'TDS Base Amount (FC)', BTF2.SurBAmt AS 'Surcharge Base Amount', BTF2.SurBAmtSC AS 'Surcharge Base Amount (SC)', BTF2.SurBAmtFC AS 'Surcharge Base Amount (FC)', BTF2.CessBAmt AS 'Cess Base Amount', BTF2.CessBAmtSC AS 'Cess Base Amount (SC)', BTF2.CessBAmtFC AS 'Cess Base Amount (FC)', BTF2.HscBAmt AS 'HSC Base Amount', BTF2.HscBAmtSC AS 'HSC Base Amount (SC)', BTF2.HscBAmtFC AS 'HSC Base Amount (FC)', BTF2.TdsAmnt AS 'TDS Tax Amount', BTF2.TdsAmntSC AS 'TDS Tax Amount (SC)', BTF2.TdsAmntFC AS 'TDS Tax Amount (FC)', BTF2.SurAmnt AS 'Surcharge Tax Amount', BTF2.SurAmntSC AS 'Surcharge Tax Amount (SC)', BTF2.SurAmntFC AS 'Surcharge Tax Amount (FC)', BTF2.CessAmnt AS 'Cess Tax Amount', BTF2.CessAmntSC AS 'Cess Tax Amount (SC)', BTF2.CessAmntFC AS 'Cess Tax Amount (FC)', BTF2.HscAmnt AS 'HSC Tax Amount', BTF2.HscAmntSC AS 'HSC Tax Amount (SC)', BTF2.HscAmntFC AS 'HSC Tax Amount (FC)', BTF2.TdsAppl AS 'Applied TDS Amount', BTF2.TdsApplSC AS 'Applied TDS Amount (SC)', BTF2.TdsApplFC AS 'Applied TDS Amount (FC)', BTF2.SurAppl AS 'Applied Surcharge Amount', BTF2.SurApplSC AS 'Applied Surcharge Amount (SC)', BTF2.SurApplFC AS 'Applied Surcharge Amount (FC)', BTF2.CessAppl AS 'Applied Cess Amount', BTF2.CessApplSC AS 'Applied Cess Amount (SC)', BTF2.CessApplFC AS 'Applied Cess Amount (FC)', BTF2.HscAppl AS 'Applied HSC Amount', BTF2.HscApplSC AS 'Applied HSC Amount (SC)', BTF2.HscApplFC AS 'Applied HSC Amount (FC)', BTF2.BatchNum AS 'Journal Voucher No.', BTF2.InCSTCode AS 'CST Code Incoming', BTF2.OutCSTCode AS 'CST Code Outgoing', BTF2.DpmWTApl AS 'DPM WT Applied Amount', BTF2.DpmWTAplSC AS 'DPM WT Applied Amount (SC)', BTF2.DpmWTAplFC AS 'DPM WT Applied Amount (FC)' FROM BTF2 AS BTF2

Related information


Base Doc Entry BaseDocEntry Property· Table: BTF2
Sets or returns the source document ID. Field name: BaseAbsEnt.
· Table: JDT2 BTF2    Parent: Withholding Tax Data WithholdingTaxData Object· Table: JDT2 BTF2
Journal Voucher Entry OBTF SQL Table

G/L Accounts OACT SQL Table

Journal Vouchers List OBTD SQL Table

Object Settings - History ADP1 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