📚 SAP Business One SDK Help

Table Name: AWHT

Table Description: Withholding Tax

Field Description Type Size Related Default Value Constraints
WTCode WTax Code nVarChar 4 -      
WTName WTax Name nVarChar 50 -      
Rate Rate Num 19.6 -      
EffecDate Effective From Date 8 -      
Category Category VarChar 1 - P I Invoice
            P Payment
BaseType Base Type VarChar 1 - N G Gross
            N Net
            V VAT
            U UoM
PrctBsAmnt % Base Amount Num 19.6 -      
OffclCode Official Code nVarChar 15 -      
Account Account nVarChar 15 OACT      
MinTaxAmt Minimum Taxable Amount Num 19.6 -      
IsPrgrss Progressive Tax VarChar 1 - N Y Progressive Tax
            N Not Progressive Tax
Type Withholding Type VarChar 1 - V V VAT Withholding
            I Income Tax Withholding
RoundType Rounding Type VarChar 1 - C T Truncated AU
            C Commercial Values
WTTypeId Type Int 11 OWTT      
WTCurrency Currency nVarChar 3 OCRN      
LogInstanc Log Instance Int 11 - 0    
UpdateDate Date of Update Date 8 -      
UserSign User Signature Int 6 OUSR      
Section Section Int 11 OSEC      
Threshold Cumulative Threshold Num 19.6 -      
Surcharge Surcharge Num 19.6 -      
Concess Concessional VarChar 1 - N Y Yes
            N No
Assessee Assessee Int 11 ONOA      
ApTdsAcc A/P TDS Account nVarChar 15 OACT      
ApSurAcc A/P Surcharge Account nVarChar 15 OACT      
ApCessAcc A/P Cess Account nVarChar 15 OACT      
ApHscAcc A/P HSC Account nVarChar 15 OACT      
ArTdsAcc A/R TDS Account nVarChar 15 OACT      
ArSurAcc A/R Surcharge Account nVarChar 15 OACT      
ArCessAcc A/R Cess Account nVarChar 15 OACT      
ArHscAcc A/R HSC Account nVarChar 15 OACT      
Location Location Int 11 OLCT      
ReturnType Return Type VarChar 1 -   A 26
            B 27
UserSign2 Updating User Int 6 OUSR      
Inactive Inactive VarChar 1 - N Y Yes
            N No
InCSTCode CST Code Incoming Int 11 OTSC -1    
OutCSTCode CST Code Outgoing Int 11 OTSC -1    
CalBaseN Nature of Calculation Base nVarChar 2 OBSI      
PymntRsnCd Payment Reason Code nVarChar 3 OSWA      
DIOTRpt DIOT Report VarChar 1 - N Y Yes
            N No
TDSType TDS Type VarChar 1 -   E eTDS
            D GST TDS
            C GST TCS
ApIgstAcc A/P IGST Account nVarChar 15 OACT      
ApCgstAcc A/P CGST Account nVarChar 15 OACT      
ApSgstAcc A/P SGST Account nVarChar 15 OACT      
ArIgstAcc A/R IGST Account nVarChar 15 OACT      
ArCgstAcc A/R CGST Account nVarChar 15 OACT      
ArSgstAcc A/R SGST Account nVarChar 15 OACT      
ApUtgstAcc A/P UTGST Account nVarChar 15 OACT      
ApCsgstAcc A/P Cess GST Account nVarChar 15 OACT      
ArUtgstAcc A/R UTGST Account nVarChar 15 OACT      
ArCsgstAcc A/R Cess GST Account nVarChar 15 OACT      
TransThres Transaction Threshold Num 19.6 - 0    
EBWTaxCate Withholding Tax Category Int 11 OWHC      
ArTcsInAcc A/R TCS Interim Account nVarChar 15 OACT      
ArSurInAcc A/R Surcharge Interim Account nVarChar 15 OACT      
ArCesInAcc A/R Cess Interim Account nVarChar 15 OACT      
ArHscInAcc A/R HSC Interim Account nVarChar 15 OACT      
ApTcsInAcc A/P TCS Interim Account nVarChar 15 OACT      
ApSurInAcc A/P Surcharge Interim Account nVarChar 15 OACT      
ApCesInAcc A/P Cess Interim Account nVarChar 15 OACT      
ApHscInAcc A/P HSC Interim Account nVarChar 15 OACT      
LnWTInAcc Interim Account for Tax nVarChar 15 OACT      
NoDedThrsh Apply Tax Exemption After Threshold VarChar 1 - N Y Yes
            N No
UseInAPDPR Use in A/P Down Payment Requests VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes WTCode
    LogInstanc