biuan SAP® BUSINESS ONE SDK
API JST1
JST1 - TDS Adjustment - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEYInternal NumberInt
11OJST
TDS Adjustment
WT_CODENo
LineNumRow NumberInt
11
0
WTCodeWTax CodenVarChar
4OWHT
Withholding Tax
BaseNumBase Document TypeInt
-1)
18) A/P Invoice
204) A/P Down Payment
11
-1
BaseAbsIdBase Document Internal IDInt
11
BaseLineBase RowInt
11
LogInstancLog InstanceInt
11
0
RateRateNum
20
TdsRateTDS RateNum
20
SurRateSurcharge RateNum
20
CessRateCess RateNum
20
HscRateHSC RateNum
20
TaxbleAmntTaxable AmountNum
20
TxblAmntSCTaxable Amount (SC)Num
20
TxblAmntFCTaxable Amount (FC)Num
20
CategoryCategoryVarChar
P) Payment
I) Invoice
1
CriteriaCriteriaVarChar
Y) Accrual
N) Cash
1
TypeWithholding Tax TypeVarChar
V) VAT Withholding
I) Incoming Tax Withholding
1
RoundTypeRounding TypeVarChar
T) Truncated
C) Commercial Values
1
BaseTypeBase TypeVarChar
G) Gross
N) Net
V) VAT
1
AccountG/L AccountnVarChar
15OACT
G/L Accounts
TdsAccTDS AccountnVarChar
15OACT
G/L Accounts
SurAccSurcharge AccountnVarChar
15OACT
G/L Accounts
CessAccCess AccountnVarChar
15OACT
G/L Accounts
HscAccHSC AccountnVarChar
15OACT
G/L Accounts
WTAmntWTax AmountNum
20
WTAmntSCWTax Amount (SC)Num
20
WTAmntFCWTax Amount (FC)Num
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

Table relationship map

SELECT statement

SELECT JST1.AbsId AS 'Internal Number', JST1.LineNum AS 'Row Number', JST1.WTCode AS 'WTax Code', JST1.BaseNum AS 'Base Document Type', JST1.BaseAbsId AS 'Base Document Internal ID', JST1.BaseLine AS 'Base Row', JST1.LogInstanc AS 'Log Instance', JST1.Rate AS 'Rate', JST1.TdsRate AS 'TDS Rate', JST1.SurRate AS 'Surcharge Rate', JST1.CessRate AS 'Cess Rate', JST1.HscRate AS 'HSC Rate', JST1.TaxbleAmnt AS 'Taxable Amount', JST1.TxblAmntSC AS 'Taxable Amount (SC)', JST1.TxblAmntFC AS 'Taxable Amount (FC)', JST1.Category AS 'Category', JST1.Criteria AS 'Criteria', JST1.Type AS 'Withholding Tax Type', JST1.RoundType AS 'Rounding Type', JST1.BaseType AS 'Base Type', JST1.Account AS 'G/L Account', JST1.TdsAcc AS 'TDS Account', JST1.SurAcc AS 'Surcharge Account', JST1.CessAcc AS 'Cess Account', JST1.HscAcc AS 'HSC Account', JST1.WTAmnt AS 'WTax Amount', JST1.WTAmntSC AS 'WTax Amount (SC)', JST1.WTAmntFC AS 'WTax Amount (FC)', JST1.TdsBAmt AS 'TDS Base Amount', JST1.TdsBAmtSC AS 'TDS Base Amount (SC)', JST1.TdsBAmtFC AS 'TDS Base Amount (FC)', JST1.SurBAmt AS 'Surcharge Base Amount', JST1.SurBAmtSC AS 'Surcharge Base Amount (SC)', JST1.SurBAmtFC AS 'Surcharge Base Amount (FC)', JST1.CessBAmt AS 'Cess Base Amount', JST1.CessBAmtSC AS 'Cess Base Amount (SC)', JST1.CessBAmtFC AS 'Cess Base Amount (FC)', JST1.HscBAmt AS 'HSC Base Amount', JST1.HscBAmtSC AS 'HSC Base Amount (SC)', JST1.HscBAmtFC AS 'HSC Base Amount (FC)', JST1.TdsAmnt AS 'TDS Tax Amount', JST1.TdsAmntSC AS 'TDS Tax Amount (SC)', JST1.TdsAmntFC AS 'TDS Tax Amount (FC)', JST1.SurAmnt AS 'Surcharge Tax Amount', JST1.SurAmntSC AS 'Surcharge Tax Amount (SC)', JST1.SurAmntFC AS 'Surcharge Tax Amount (FC)', JST1.CessAmnt AS 'Cess Tax Amount', JST1.CessAmntSC AS 'Cess Tax Amount (SC)', JST1.CessAmntFC AS 'Cess Tax Amount (FC)', JST1.HscAmnt AS 'HSC Tax Amount', JST1.HscAmntSC AS 'HSC Tax Amount (SC)', JST1.HscAmntFC AS 'HSC Tax Amount (FC)' FROM JST1 AS JST1

Related information


TDS Adjustment OJST SQL Table

G/L Accounts OACT 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