📚 SAP Business One SDK Help

Table Name: WTX1

Table Description: WTax Transactions - Rows

Field Description Type Size Related Default Value Constraints
AbsEntry Internal ID Int 11 OWTX      
LineSeq Row Sequence Int 11 -      
SrcArrType Source Array Type Int 11 - -1 -1 Default
            1 Main
            12 Array 1
            13 Array 2
            14 Array 3
SrcLineNum Source Row Number Int 11 - -1    
SrcGrpNum Source Group Number Int 11 - -1 -1 Default
            0 Group 1
            1 Group 2
            2 Group 3
BaseObjTyp Base Object Type nVarChar 20 - -1    
BaseAbs Base Document Internal No. Int 11 - -1    
BaseArrTyp Base Array Type Int 11 - -1 -1 Default
            1 Main
            12 Array 1
            13 Array 2
            14 Array 3
            15 Array 4
            16 Array 5
            17 Array 6
            18 Array 7
            24 Array 13
BaseLinNum Base Row Number Int 11 - -1    
BaseGrpNum Base Group No. Int 11 - -1 -1 Default
            0 Group 1
            1 Group 2
            2 Group 3
WTaxAbsId Tax Code ID nVarChar 8 -      
Account Account nVarChar 15 OACT      
Rate Rate Num 19.6 -      
Exemption Exemption Rate Num 19.6 -      
BaseType Base Type VarChar 1 - N N Net
            V VAT
            G Gross
            H Gross - VAT
BaseNetSum Base Net Sum Num 19.6 -      
BaseNetSC Base Net Sum (SC) Num 19.6 -      
BaseNetFC Base Net Sum (FC) Num 19.6 -      
BaseVatSum Base VAT Sum Num 19.6 -      
BaseVatSC Base VAT Sum (SC) Num 19.6 -      
BaseVatFC Base VAT Sum (FC) Num 19.6 -      
AccBaseSum Accumulated Sum Num 19.6 -      
AccBaseSC Accumulated Sum (SC) Num 19.6 -      
AccBaseFC Accumulated Sum (FC) Num 19.6 -      
AccWTaxSum Accumulated WTax Sum Num 19.6 -      
AccWTaxSC Accumulated WTax Sum (SC) Num 19.6 -      
AccWTaxFC Accumulated WTax Sum (FC) Num 19.6 -      
TxblSum Taxable Sum Num 19.6 -      
TxblSumSc Taxable Sum (SC) Num 19.6 -      
TxblSumFc Taxable Sum (FC) Num 19.6 -      
WTaxSum WTax Sum Num 19.6 -      
WTaxSumSc WTax Sum (SC) Num 19.6 -      
WTaxSumFc WTax Sum (FC) Num 19.6 -      
ApplSum Applied Sum Num 19.6 -      
ApplSumSc Applied Sum (SC) Num 19.6 -      
ApplSumFc Applied Sum (FC) Num 19.6 -      
CrditDebit Credit or Debit Transaction VarChar 1 -   C Credit
            D Debit
PostingTyp Sales or Purchase VarChar 1 - N N None
            R Sales
            P Purchase
Category Category VarChar 1 - P I Invoice
            P Payment
WTTypeId Type Int 11 -      
WhtType Withholding Type VarChar 1 - V V VAT Withholding
            G Gross Income Withholding
            N Income Tax Withholding
            S Social Security Withholding
            I Industry Specific Withholding
            D District Specific Withholding
FmlId Formula ID Int 11 -      
BaseMin Min. Amount Num 19.6 -      
BaseMinSc Min. Amount (SC) Num 19.6 -      
BaseMinFc Min. Amount (FC) Num 19.6 -      
ResMin Min.Ret./Perc. Amount Num 19.6 -      
ResMinSc Min.Ret./Perc. Amount (SC) Num 19.6 -      
ResMinFc Min.Ret./Perc. Amount (FC) Num 19.6 -      
AddBas Add to Base Amount Num 19.6 -      
AddBasSc Add to Base Amount (SC) Num 19.6 -      
AddBasFc Add to Base Amount (FC) Num 19.6 -      
ABWVAT Add to Base without VAT Amount Num 19.6 -      
ABWVATSc Add to Base without VAT Amount (SC) Num 19.6 -      
ABWVATFc Add to Base without VAT Amount (FC) Num 19.6 -      
Key Unique Field
PRIMARY Yes AbsEntry
    LineSeq