📚 SAP Business One SDK Help

Table Name: BTF2

Table Description: Journal Voucher Withholding Tax - History

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 OBTF      
WTCode WTax Code nVarChar 4 OWHT      
Rate Rate Num 19.6 -      
TaxbleAmnt Taxable Amount Num 19.6 -      
TxblAmntSC Taxable Amount (SC) Num 19.6 -      
TxblAmntFC Taxable Amount (FC) Num 19.6 -      
WTAmnt WTax Amount Num 19.6 -      
WTAmntSC WTax Amount (SC) Num 19.6 -      
WTAmntFC WTax Amount (FC) Num 19.6 -      
ApplAmnt Applied WTax Amount Num 19.6 -      
ApplAmntSC Applied WTax Amount (SC) Num 19.6 -      
ApplAmntFC Applied WTax Amount (FC) Num 19.6 -      
Category Category VarChar 1 -   P Payment
            I Invoice
Criteria Criteria VarChar 1 -   Y Accrual
            N Cash
Account G/L Account nVarChar 15 OACT      
Type Withholding Tax Type VarChar 1 -   V VAT Withholding
            I Income Tax Withholding
RoundType Rounding Type VarChar 1 -   T Truncated
            C Commercial Values
            N No Rounding
BaseType Base Type VarChar 1 -   G Gross
            N Net
            V VAT
            U UoM
BaseAbsEnt Base Document Reference Int 11 - -1    
BaseLine Base Row Int 11 -      
BaseNum Base Document Type Int 11 -   -1  
LineNum Row Number Int 11 -      
BaseRef Base Document Reference Int 11 -      
Status Status VarChar 1 - O O Open
            C Closed
TrgType Target Document Type Int 11 -      
TrgAbsEntr Target Doc. Internal No. Int 11 - -1    
LogInstanc Log Instance Int 11 - 0    
ObjType Object Type nVarChar 20 ADP1 30    
Doc1LineNo DOC1 Line Number Int 11 - -1    
WtLineType WTax Row Type VarChar 1 - D D Document Level WTax
            L Row Level WTax
TxblCurr Taxable Currency from Doc Row nVarChar 3 -      
DtblCurr Deductible Currency nVarChar 3 -      
DtblRate Rate for Deductible Amount Num 19.6 -      
txblRate Rate for Taxable Amount Num 19.6 -      
DtblAmount Deductible Amount Num 19.6 -      
TdsAcc TDS Account nVarChar 15 OACT      
SurAcc Surcharge Account nVarChar 15 OACT      
CessAcc Cess Account nVarChar 15 OACT      
HscAcc HSC Account nVarChar 15 OACT      
TdsRate TDS Rate Num 19.6 -      
SurRate Surcharge Rate Num 19.6 -      
CessRate Cess Rate Num 19.6 -      
HscRate HSC Rate Num 19.6 -      
TdsBAmt TDS Base Amount Num 19.6 -      
TdsBAmtSC TDS Base Amount (SC) Num 19.6 -      
TdsBAmtFC TDS Base Amount (FC) Num 19.6 -      
SurBAmt Surcharge Base Amount Num 19.6 -      
SurBAmtSC Surcharge Base Amount (SC) Num 19.6 -      
SurBAmtFC Surcharge Base Amount (FC) Num 19.6 -      
CessBAmt Cess Base Amount Num 19.6 -      
CessBAmtSC Cess Base Amount (SC) Num 19.6 -      
CessBAmtFC Cess Base Amount (FC) Num 19.6 -      
HscBAmt HSC Base Amount Num 19.6 -      
HscBAmtSC HSC Base Amount (SC) Num 19.6 -      
HscBAmtFC HSC Base Amount (FC) Num 19.6 -      
TdsAmnt TDS Tax Amount Num 19.6 -      
TdsAmntSC TDS Tax Amount (SC) Num 19.6 -      
TdsAmntFC TDS Tax Amount (FC) Num 19.6 -      
SurAmnt Surcharge Tax Amount Num 19.6 -      
SurAmntSC Surcharge Tax Amount (SC) Num 19.6 -      
SurAmntFC Surcharge Tax Amount (FC) Num 19.6 -      
CessAmnt Cess Tax Amount Num 19.6 -      
CessAmntSC Cess Tax Amount (SC) Num 19.6 -      
CessAmntFC Cess Tax Amount (FC) Num 19.6 -      
HscAmnt HSC Tax Amount Num 19.6 -      
HscAmntSC HSC Tax Amount (SC) Num 19.6 -      
HscAmntFC HSC Tax Amount (FC) Num 19.6 -      
TdsAppl Applied TDS Amount Num 19.6 -      
TdsApplSC Applied TDS Amount (SC) Num 19.6 -      
TdsApplFC Applied TDS Amount (FC) Num 19.6 -      
SurAppl Applied Surcharge Amount Num 19.6 -      
SurApplSC Applied Surcharge Amount (SC) Num 19.6 -      
SurApplFC Applied Surcharge Amount (FC) Num 19.6 -      
CessAppl Applied Cess Amount Num 19.6 -      
CessApplSC Applied Cess Amount (SC) Num 19.6 -      
CessApplFC Applied Cess Amount (FC) Num 19.6 -      
HscAppl Applied HSC Amount Num 19.6 -      
HscApplSC Applied HSC Amount (SC) Num 19.6 -      
HscApplFC Applied HSC Amount (FC) Num 19.6 -      
BatchNum Journal Voucher No. Int 11 OBTD      
InCSTCode CST Code Incoming nVarChar 2 -      
OutCSTCode CST Code Outgoing nVarChar 2 -      
DpmWTApl DPM WT Applied Amount Num 19.6 -      
DpmWTAplSC DPM WT Applied Amount (SC) Num 19.6 -      
DpmWTAplFC DPM WT Applied Amount (FC) Num 19.6 -      
WTTypeId WT Type Id Int 11 OWTT      
LnBsAmt BR Line WT Base Amount Num 19.6 -      
LnBsAmtSC BR Line WT Base Amount(SC) Num 19.6 -      
LnBsAmtFC BR Line WT Base Amount(FC) Num 19.6 -      
LnCmTAmt BR Line Cumulated Taxable Amount Num 19.6 -      
LnCmTAmtSC BR Line Cumulated Taxable Amount(SC) Num 19.6 -      
LnCmTAmtFC BR Line Cumulated Taxable Amount(FC) Num 19.6 -      
TDSType TDS Type VarChar 1 -   E eTDS
            D GST TDS
            C GST TCS
            S SALES TCS
IgstAcc IGST Account nVarChar 15 OACT      
CgstAcc CGST Account nVarChar 15 OACT      
SgstAcc SGST Account nVarChar 15 OACT      
IgstAmnt IGST Tax Amount Num 19.6 -      
IgstAmntSC IGST Tax Amount (SC) Num 19.6 -      
IgstAmntFC IGST Tax Amount (FC) Num 19.6 -      
CgstAmnt CGST Tax Amount Num 19.6 -      
CgstAmntSC CGST Tax Amount (SC) Num 19.6 -      
CgstAmntFC CGST Tax Amount (FC) Num 19.6 -      
SgstAmnt SGST Tax Amount Num 19.6 -      
SgstAmntSC SGST Tax Amount (SC) Num 19.6 -      
SgstAmntFC SGST Tax Amount (FC) Num 19.6 -      
IgstRate IGST Rate Num 19.6 -      
CgstRate CGST Rate Num 19.6 -      
SgstRate SGST Rate Num 19.6 -      
IgstBAmt IGST Base Amount Num 19.6 -      
IgstBAmtSC IGST Base Amount (SC) Num 19.6 -      
IgstBAmtFC IGST Base Amount (FC) Num 19.6 -      
CgstBAmt CGST Base Amount Num 19.6 -      
CgstBAmtSC CGST Base Amount (SC) Num 19.6 -      
CgstBAmtFC CGST Base Amount (FC) Num 19.6 -      
SgstBAmt SGST Base Amount Num 19.6 -      
SgstBAmtSC SGST Base Amount (SC) Num 19.6 -      
SgstBAmtFC SGST Base Amount (FC) Num 19.6 -      
IgstAppl Applied IGST Amount Num 19.6 -      
IgstApplSC Applied IGST Amount (SC) Num 19.6 -      
IgstApplFC Applied IGST Amount (FC) Num 19.6 -      
CgstAppl Applied CGST Amount Num 19.6 -      
CgstApplSC Applied CGST Amount (SC) Num 19.6 -      
CgstApplFC Applied CGST Amount (FC) Num 19.6 -      
SgstAppl Applied SGST Amount Num 19.6 -      
SgstApplSC Applied SGST Amount (SC) Num 19.6 -      
SgstApplFC Applied SGST Amount (FC) Num 19.6 -      
UtgstAcc UTGST Account nVarChar 15 OACT      
CsgstAcc Cess GST Account nVarChar 15 OACT      
UtgstAmt UTGST Tax Amount Num 19.6 -      
UtgstAmtSC UTGST Tax Amount (SC) Num 19.6 -      
UtgstAmtFC UTGST Tax Amount (FC) Num 19.6 -      
CsgstAmt Cess GST Tax Amount Num 19.6 -      
CsgstAmtSC Cess GST Tax Amount (SC) Num 19.6 -      
CsgstAmtFC Cess GST Tax Amount (FC) Num 19.6 -      
UtgstRate UTGST Rate Num 19.6 -      
CsgstRate Cess GST Rate Num 19.6 -      
UtgstBAmt UTGST Base Amount Num 19.6 -      
UtgstBAmtS UTGST Base Amount (SC) Num 19.6 -      
UtgstBAmtF UTGST Base Amount (FC) Num 19.6 -      
CsgstBAmt Cess GST Base Amount Num 19.6 -      
CsgstBAmtS Cess GST Base Amount (SC) Num 19.6 -      
CsgstBAmtF Cess GST Base Amount (FC) Num 19.6 -      
UtgstAppl Applied UTGST Amount Num 19.6 -      
UtgstApplS Applied UTGST Amount (SC) Num 19.6 -      
UtgstApplF Applied UTGST Amount (FC) Num 19.6 -      
CsgstAppl Applied Cess GST Amount Num 19.6 -      
CsgstApplS Applied Cess GST Amount (SC) Num 19.6 -      
CsgstApplF Applied Cess GST Amount (FC) Num 19.6 -      
EncryptIV Encrypt IV nVarChar 100 -      
TcsIntAcct TCS Interim Account nVarChar 15 OACT      
SurIntAcct Surcharge Interim Account nVarChar 15 OACT      
CesIntAcct Cess Interim Account nVarChar 15 OACT      
HscIntAcct HSC interim Account nVarChar 15 OACT      
LnIntAcct Interim Account for Tax nVarChar 15 OACT      
FixedAmnt Fixed Amount Num 19.6 -      
FixedAmtSC Fixed Amount (SC) Num 19.6 -      
FixedAmtFC Fixed Amount (FC) Num 19.6 -      
BaseQty Base Quantity Num 19.6 -      
Key Unique Field
PRIMARY Yes BatchNum
    AbsEntry
    LineNum
SECONDERY No AbsEntry
    WTCode
    BaseAbsEnt