biuan SAP® BUSINESS ONE SDK
API UTX1
UTX1 - Unreported VAT Transactions - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal IDInt
11OUTX
Unreported 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
IsAcqIs Acquisition TaxVarChar
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)
15) Delivery notes
16) Revert Delivery Notes
17) Sales Order
20) Goods Receipt
21) Goods Return
22) Purchase order
23) Sales Quotation
112) Document Draft
59) Goods Receipt
60) Goods Issue
28) Journal Batches
140) Payment Draft
123) Checks for Payment Drafts
540000006) Purchase Quotation
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 PurchasingVarChar
N) None
R) Sales
P) Purchase
1
N
BasePaidApplied Base SumNum
20
BasePaidSCApplied Base Sum SCNum
20
BasePaidFCApplied Base Sum FCNum
20
VatPaidApplied VAT SumNum
20
VatPaidSCApplied VAT Sum SCNum
20
VatPaidFCApplied VAT Sum FCNum
20
DeductPaidApplied Deduct SumNum
20
DdctPaidSCApplied Deduct Sum SCNum
20
DdctPaidFCApplied Deduct Sum FCNum
20
EqPaidApplied Equalization SumNum
20
EqPaidSCApplied Equalization Sum SCNum
20
EqPaidFCApplied Equalization Sum FCNum
20
TransAcctTransaction AcccountnVarChar
15OACT
G/L Accounts
LnDataNumLine 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
15

Table relationship map

SELECT statement

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

Related information


Unreported VAT Transactions OUTX 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates