📚 SAP Business One SDK Help

Table Name: TAX1

Table Description: VAT Transactions - Rows

Field Description Type Size Related Default Value Constraints
AbsEntry Internal ID Int 11 OTAX      
LineSeq Row Sequence Int 11 -      
SrcArrType Source Array Type Int 11 - -1 -1 Default
            1 Main
            12 Array1
            13 Array2
            14 Array3
            15 Array4
            16 Array5
            17 Array6
            18 Array7
            24 Array13
SrcLineNum Source Row Number Int 11 - -1    
SrcGrpNum Source Group Number Int 11 - -1 -1 Default
            0 Group1
            1 Group2
            2 Group3
TaxCode Tax Code nVarChar 8 -      
StaCode Tax Authority Code nVarChar 8 OSTA      
StaType Tax Authority Type Int 11 OSTT      
StaIndex Tax Authority seq index Int 11 -      
IsLiable Is Tax Liable VarChar 1 - Y Y Yes
            N No
TaxType Tax Type VarChar 1 - Y Y Regular
            U Use Tax
            N No Tax
            O Tax Offset Transaction
            R Reverse Tax Offset Transaction
            P DPM Request Tax Offset Transaction
            D Deferred Tax Offset Transaction
IsAcq Acquisition Tax Liable VarChar 1 - N N No
            Y Yes
Isdeferred Deferred Tax [Yes/No] VarChar 1 - N N No
            Y Yes
ValueDate Due Date for Payment Date 8 -      
VatPercent VAT Percent Num 19.6 -      
NdPercent Non Deductible % Num 19.6 -      
EqPercent Equalization Percent Num 19.6 -      
BaseObjTyp Base Object Type nVarChar 20 - -1 -1  
            13 A/R Invoice
            14 A/R Credit Memo
            165 Correction A/R Invoice
            166 Correction A/R Invoice Reversals
            18 A/P Invoice
            19 A/P Credit Memo
            163 Correction A/P Invoice
            164 Correction A/P Invoice Reversals
            46 Outgoing Payment
            24 Incoming Payment
            57 Check for Payment
            30 Journal Transaction
            67 Warehouse Transfer
            25 Deposit
            321 Internal Reconciliation
            76 Deposit Temporary
            140000010 Incoming Excise Invoice
            140000009 Outgoing Excise Invoice
            69 Import file
BaseAbs Base Document Internal No. Int 11 - -1    
BaseArrTyp Base Array Type Int 11 - -1 -1 Default
            1 Main
            12 Array1
            13 Array2
            14 Array3
            15 Array4
            16 Array5
            17 Array6
            18 Array7
            24 Array13
BaseLinNum Base Row Number Int 11 - -1    
BaseGrpNum Base Group No. Int 11 - -1 -1 Default
            0 Group1
            1 Group2
            2 Group3
BaseSum Base Sum Num 19.6 -      
BaseSumSc Base Sum (SC) Num 19.6 -      
BaseSumFc Base Sum (FC) Num 19.6 -      
VatSum VAT Sum Num 19.6 -      
VatSumSc VAT Sum (SC) Num 19.6 -      
VatSumFc VAT Sum (FC) Num 19.6 -      
DeductSum Deduct VAT Sum Num 19.6 -      
DedctSumSC Deduct VAT Sum (SC) Num 19.6 -      
DedctSumFC Deduct VAT Sum (FC) Num 19.6 -      
EqSum Equalization Sum Num 19.6 -      
EqSumSC Equalization Sum (SC) Num 19.6 -      
EqSumFC Equalization Sum (FC) Num 19.6 -      
TaxAcct Tax Account nVarChar 15 OACT      
DefAcct Deferred Tax Account nVarChar 15 OACT      
NdAcct Non Deduct. Account nVarChar 15 OACT      
AcqAcct Acquisition Tax Account nVarChar 15 OACT      
ExpAcct Expense Account nVarChar 15 OACT      
CrditDebit Credit Or Debit Transaction VarChar 1 -   C Credit
            D Debit
PostingTyp Sales or Purchase VarChar 1 - N N None
            R Sales
            P Purchase
BasePaid Applied Base Sum Num 19.6 -      
BasePaidSC Applied Base Sum (SC) Num 19.6 -      
BasePaidFC Applied Base Sum (FC) Num 19.6 -      
VatPaid Applied VAT Sum Num 19.6 -      
VatPaidSC Applied VAT Sum (SC) Num 19.6 -      
VatPaidFC Applied VAT Sum (FC) Num 19.6 -      
DeductPaid Applied Deduct Sum Num 19.6 -      
DdctPaidSC Applied Deduct Sum (SC) Num 19.6 -      
DdctPaidFC Applied Deduct Sum (FC) Num 19.6 -      
EqPaid Applied Equalization Sum Num 19.6 -      
EqPaidSC Applied Equalization Sum (SC) Num 19.6 -      
EqPaidFC Applied Equalization Sum (FC) Num 19.6 -      
TransAcct Transaction Acccount nVarChar 15 OACT      
LnDataNum Row Number in Tax Data Int 11 - -1    
InPrice Included in Price VarChar 1 - N Y Yes
            N No
Exempt Exempt VarChar 1 - N Y Yes
            N No
InGrossRev Included in Gross Revenue VarChar 1 - N Y Yes
            N No
PostStatus Posting Status VarChar 1 - Y Y Yes
            N No
IsItmLevel Is Item Level Tax VarChar 1 - N N No
            Y Yes
MinTAmt Min. Taxable Amount Num 19.6 -      
MinTAmtSC Min. Taxable Amount (SC) Num 19.6 -      
MinTAmtFC Min. Taxable Amount (FC) Num 19.6 -      
MaxTAmt Max. Taxable Amount Num 19.6 -      
MaxTAmtSC Max. Taxable Amount (SC) Num 19.6 -      
MaxTAmtFC Max. Taxable Amount (FC) Num 19.6 -      
FlatTAmt Flat Tax Amount Num 19.6 -      
FlatTAmtSC Flat Tax Amount (SC) Num 19.6 -      
FlatTAmtFC Flat Tax Amount (FC) Num 19.6 -      
EqTaxAcct Equalization Tax Account nVarChar 15 OACT      
Reposted Reposted in Transfer Wizard VarChar 1 - N Y Yes
            N No
Unencumbrd Unencumbered VarChar 1 - N Y Yes
            N No
IsSplitPay Split Payment VarChar 1 - N Y Yes
            N No
SplitPayAc Split Payment Account nVarChar 15 OACT      
TaxOnRI Tax On Reserve Invoice VarChar 1 - N Y Yes
            N No
RvsChrgPrc Reverse Charge % Num 19.6 -      
RvsChrgSum Reverse Charge Sum Num 19.6 -      
RvsChrgSC Reverse Charge Sum (SC) Num 19.6 -      
RvsChrgFC Reverse Charge Sum (FC) Num 19.6 -      
GstPayAct GST Payable Account nVarChar 15 OACT      
RvsPaid Applied Reverse Charge Sum Num 19.6 -      
RvsPaidSC Applied Reverse Charge (SC) Num 19.6 -      
RvsPaidFC Applied Reverse Charge (FC) Num 19.6 -      
InFirstIns Included in First Installment VarChar 1 - N Y Yes
            N No
GstRecvAct GST Receivable Account nVarChar 15 OACT      
IsCstmAct Apply Customer Accounting Tax Rule VarChar 1 - N N No
            Y Yes
CAOutCode Customer Accounting Output Tax Code nVarChar 8 -      
CABasSum Customer Accounting Reverse Base Sum Num 19.6 -      
CABasSumSc Customer Accounting Reverse Base Sum (SC) Num 19.6 -      
CABasSumFc Customer Accounting Reverse Base Sum (FC) Num 19.6 -      
CAVatSum Customer Accounting Reverse VAT Sum Num 19.6 -      
CAVatSumSc Customer Accounting Reverse VAT Sum (SC) Num 19.6 -      
CAVatSumFc Customer Accounting Reverse VAT Sum (FC) Num 19.6 -      
CAOutAcct Customer Accounting Output Tax Account nVarChar 15 -      
ExtVatPcnt External VAT Percent Num 19.6 -      
ExtVatSum External VAT Amount Num 19.6 -      
VatSumSrc VAT Sum Source VarChar 1 - S S Internal System Calculation
            E External Calculation
ExtVatSumF External VAT Amount (FC) Num 19.6 -      
ExtVatSumS External VAT Amount (SC) Num 19.6 -      
AcqRevTax Acquisition/Reverse Corresponding Tax Code nVarChar 8 -      
VatExmPrc VAT Exemption % Num 19.6 -      
VatExmBase VAT Base % Num 19.6 -      
RevCharge Reverse Charge VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes AbsEntry
    LineSeq