biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Landed Costs / VAT Transactions - Rows
DTW VAT Transactions - Rows
API Landed Cost / Tax 1
TAX1 - VAT Transactions - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal IDInt
11OTAX
VAT Transactions		PRIMARYYes
LineSeqRow SequenceInt
11
SrcArrTypeSource Array TypeInt
-1) Default
1) Main
12) Array1
13) Array2
14) Array3
15) Array4
16) Array5
17) Array6
18) Array7
24) Array13
11
-1
SrcLineNumSource Row NumberInt
11
-1
SrcGrpNumSource Group NumberInt
-1) Default
0
1) Group2
2) Group3
11
-1
TaxCodeTax CodenVarChar
8
StaCodeTax Authority CodenVarChar
8OSTA
Sales Tax Authorities
StaTypeTax Authority TypeInt
11OSTT
Sales Tax Authorities Type
StaIndexTax Authority seq indexInt
11
IsLiableIs Tax LiableVarChar
Y) Yes
N) No
1
Y
TaxTypeTax TypeVarChar
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
1
Y
IsAcqAcquisition Tax LiableVarChar
N) No
Y) Yes
1
N
IsdeferredDeferred Tax [Yes/No]VarChar
N) No
Y) Yes
1
N
ValueDateDue Date for PaymentDate
8
VatPercentVAT PercentNum
20
NdPercentNon Deductible %Num
20
EqPercentEqualization PercentNum
20
BaseObjTypBase Object TypenVarChar
-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
20
-1
BaseAbsBase Document Internal No.Int
11
-1
BaseArrTypBase Array TypeInt
-1) Default
1) Main
12) Array1
13) Array2
14) Array3
15) Array4
16) Array5
17) Array6
18) Array7
24) Array13
11
-1
BaseLinNumBase Row NumberInt
11
-1
BaseGrpNumBase Group No.Int
-1) Default
0
1) Group2
2) Group3
11
-1
BaseSumBase SumNum
20
BaseSumScBase Sum (SC)Num
20
BaseSumFcBase Sum (FC)Num
20
VatSumVAT SumNum
20
VatSumScVAT Sum (SC)Num
20
VatSumFcVAT Sum (FC)Num
20
DeductSumDeduct VAT SumNum
20
DedctSumSCDeduct VAT Sum (SC)Num
20
DedctSumFCDeduct VAT Sum (FC)Num
20
EqSumEqualization SumNum
20
EqSumSCEqualization Sum (SC)Num
20
EqSumFCEqualization Sum (FC)Num
20
TaxAcctTax AccountnVarChar
15OACT
G/L Accounts
DefAcctDeferred Tax AccountnVarChar
15OACT
G/L Accounts
NdAcctNon Deduct. AccountnVarChar
15OACT
G/L Accounts
AcqAcctAcquisition Tax AccountnVarChar
15OACT
G/L Accounts
ExpAcctExpense AccountnVarChar
15OACT
G/L Accounts
CrditDebitCredit Or Debit TransactionVarChar
C) Credit
D) Debit
1
PostingTypSales or PurchaseVarChar
N) None
R) Sales
P) Purchase
1
N
BasePaidApplied Base SumNum
20
BasePaidSCApplied Base Sum (SC)Num
20
BasePaidFCApplied Base Sum (FC)Num
20
VatPaidApplied VAT SumNum
20
VatPaidSCApplied VAT Sum (SC)Num
20
VatPaidFCApplied VAT Sum (FC)Num
20
DeductPaidApplied Deduct SumNum
20
DdctPaidSCApplied Deduct Sum (SC)Num
20
DdctPaidFCApplied Deduct Sum (FC)Num
20
EqPaidApplied Equalization SumNum
20
EqPaidSCApplied Equalization Sum (SC)Num
20
EqPaidFCApplied Equalization Sum (FC)Num
20
TransAcctTransaction AcccountnVarChar
15OACT
G/L Accounts
LnDataNumRow Number in Tax DataInt
11
-1
InPriceIncluded in PriceVarChar
Y) Yes
N) No
1
N
ExemptExemptVarChar
Y) Yes
N) No
1
N
InGrossRevIncluded in Gross RevenueVarChar
Y) Yes
N) No
1
N
PostStatusPosting StatusVarChar
Y) Yes
N) No
1
Y
IsItmLevelIs Item Level TaxVarChar
N) No
Y) Yes
1
N
MinTAmtMin. Taxable AmountNum
20
MinTAmtSCMin. Taxable Amount (SC)Num
20
MinTAmtFCMin. Taxable Amount (FC)Num
20
MaxTAmtMax. Taxable AmountNum
20
MaxTAmtSCMax. Taxable Amount (SC)Num
20
MaxTAmtFCMax. Taxable Amount (FC)Num
20
FlatTAmtFlat Tax AmountNum
20
FlatTAmtSCFlat Tax Amount (SC)Num
20
FlatTAmtFCFlat Tax Amount (FC)Num
20
EqTaxAcctEqualization Tax AccountnVarChar
15OACT
G/L Accounts
RepostedReposted in Transfer WizardVarChar
Y) Yes
N) No
1
N
UnencumbrdUnencumberedVarChar
Y) Yes
N) No
1
N
IsSplitPaySplit PaymentVarChar
Y) Yes
N) No
1
N
SplitPayAcSplit Payment AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT TAX1.AbsEntry AS 'Internal ID', TAX1.LineSeq AS 'Row Sequence', TAX1.SrcArrType AS 'Source Array Type', TAX1.SrcLineNum AS 'Source Row Number', TAX1.SrcGrpNum AS 'Source Group Number', TAX1.TaxCode AS 'Tax Code', TAX1.StaCode AS 'Tax Authority Code', TAX1.StaType AS 'Tax Authority Type', TAX1.StaIndex AS 'Tax Authority seq index', TAX1.IsLiable AS 'Is Tax Liable', TAX1.TaxType AS 'Tax Type', TAX1.IsAcq AS 'Acquisition Tax Liable', TAX1.Isdeferred AS 'Deferred Tax [Yes/No]', TAX1.ValueDate AS 'Due Date for Payment', TAX1.VatPercent AS 'VAT Percent', TAX1.NdPercent AS 'Non Deductible %', TAX1.EqPercent AS 'Equalization Percent', TAX1.BaseObjTyp AS 'Base Object Type', TAX1.BaseAbs AS 'Base Document Internal No.', TAX1.BaseArrTyp AS 'Base Array Type', TAX1.BaseLinNum AS 'Base Row Number', TAX1.BaseGrpNum AS 'Base Group No.', TAX1.BaseSum AS 'Base Sum', TAX1.BaseSumSc AS 'Base Sum (SC)', TAX1.BaseSumFc AS 'Base Sum (FC)', TAX1.VatSum AS 'VAT Sum', TAX1.VatSumSc AS 'VAT Sum (SC)', TAX1.VatSumFc AS 'VAT Sum (FC)', TAX1.DeductSum AS 'Deduct VAT Sum', TAX1.DedctSumSC AS 'Deduct VAT Sum (SC)', TAX1.DedctSumFC AS 'Deduct VAT Sum (FC)', TAX1.EqSum AS 'Equalization Sum', TAX1.EqSumSC AS 'Equalization Sum (SC)', TAX1.EqSumFC AS 'Equalization Sum (FC)', TAX1.TaxAcct AS 'Tax Account', TAX1.DefAcct AS 'Deferred Tax Account', TAX1.NdAcct AS 'Non Deduct. Account', TAX1.AcqAcct AS 'Acquisition Tax Account', TAX1.ExpAcct AS 'Expense Account', TAX1.CrditDebit AS 'Credit Or Debit Transaction', TAX1.PostingTyp AS 'Sales or Purchase', TAX1.BasePaid AS 'Applied Base Sum', TAX1.BasePaidSC AS 'Applied Base Sum (SC)', TAX1.BasePaidFC AS 'Applied Base Sum (FC)', TAX1.VatPaid AS 'Applied VAT Sum', TAX1.VatPaidSC AS 'Applied VAT Sum (SC)', TAX1.VatPaidFC AS 'Applied VAT Sum (FC)', TAX1.DeductPaid AS 'Applied Deduct Sum', TAX1.DdctPaidSC AS 'Applied Deduct Sum (SC)', TAX1.DdctPaidFC AS 'Applied Deduct Sum (FC)', TAX1.EqPaid AS 'Applied Equalization Sum', TAX1.EqPaidSC AS 'Applied Equalization Sum (SC)', TAX1.EqPaidFC AS 'Applied Equalization Sum (FC)', TAX1.TransAcct AS 'Transaction Acccount', TAX1.LnDataNum AS 'Row Number in Tax Data', TAX1.InPrice AS 'Included in Price', TAX1.Exempt AS 'Exempt', TAX1.InGrossRev AS 'Included in Gross Revenue', TAX1.PostStatus AS 'Posting Status', TAX1.IsItmLevel AS 'Is Item Level Tax', TAX1.MinTAmt AS 'Min. Taxable Amount', TAX1.MinTAmtSC AS 'Min. Taxable Amount (SC)', TAX1.MinTAmtFC AS 'Min. Taxable Amount (FC)', TAX1.MaxTAmt AS 'Max. Taxable Amount', TAX1.MaxTAmtSC AS 'Max. Taxable Amount (SC)', TAX1.MaxTAmtFC AS 'Max. Taxable Amount (FC)', TAX1.FlatTAmt AS 'Flat Tax Amount', TAX1.FlatTAmtSC AS 'Flat Tax Amount (SC)', TAX1.FlatTAmtFC AS 'Flat Tax Amount (FC)', TAX1.EqTaxAcct AS 'Equalization Tax Account', TAX1.Reposted AS 'Reposted in Transfer Wizard', TAX1.Unencumbrd AS 'Unencumbered', TAX1.IsSplitPay AS 'Split Payment', TAX1.SplitPayAc AS 'Split Payment Account' FROM TAX1 AS TAX1

Related information


Tax 1 Tax1 Property· Table: TAX1
The tax amount relevant for the imported items. This has no impact on the journal entry. Field name: Vat1.
   Parent: Landed Cost LandedCost Object· Table: OIPF
TAX1 SQL Table

VAT Transactions OTAX SQL Table

G/L Accounts OACT SQL Table

Sales Tax Authorities OSTA SQL Table

Sales Tax Authorities Type OSTT SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates