|
|
API UTX1
UTX1 - Unreported VAT Transactions - Rows Table
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal ID | Int | 11 | OUTX Unreported VAT Transactions | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineSeq | Row Sequence | Int | 11 | |||||
| SrcArrType | Source Array Type | Int | -1) Default 1) Main 12) Array1 13) Array2 14) Array3 15) Array4 16) Array5 17) Array6 18) Array7 24) Array13 | 11 | -1 | |||
| SrcLineNum | Source Row Number | Int | 11 | -1 | ||||
| SrcGrpNum | Source Group Number | Int | -1) Default 0 1) Group2 2) Group3 | 11 | -1 | |||
| TaxCode | Tax Code | nVarChar | 8 | |||||
| StaCode | Tax Authority Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| StaType | Tax Authority Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| StaIndex | Tax Authority Seq Index | Int | 11 | |||||
| IsLiable | Is Tax Liable | VarChar | Y) Yes N) No | 1 | Y | |||
| TaxType | Tax Type | VarChar | 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 | |||
| IsAcq | Is Acquisition Tax | VarChar | N) No Y) Yes | 1 | N | |||
| Isdeferred | Deferred Tax [Yes/No] | VarChar | N) No Y) Yes | 1 | N | |||
| ValueDate | Due Date for Payment | Date | 8 | |||||
| VatPercent | VAT Percent | Num | 20 | |||||
| NdPercent | Non Deductible % | Num | 20 | |||||
| EqPercent | Equalization Percent | Num | 20 | |||||
| BaseObjTyp | Base Object Type | nVarChar | -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 | |||
| BaseAbs | Base Document Internal No. | Int | 11 | -1 | ||||
| BaseArrTyp | Base Array Type | Int | -1) Default 1) Main 12) Array1 13) Array2 14) Array3 15) Array4 16) Array5 17) Array6 18) Array7 24) Array13 | 11 | -1 | |||
| BaseLinNum | Base Row Number | Int | 11 | -1 | ||||
| BaseGrpNum | Base Group No. | Int | -1) Default 0 1) Group2 2) Group3 | 11 | -1 | |||
| BaseSum | Base Sum | Num | 20 | |||||
| BaseSumSc | Base Sum (SC) | Num | 20 | |||||
| BaseSumFc | Base Sum (FC) | Num | 20 | |||||
| VatSum | VAT Sum | Num | 20 | |||||
| VatSumSc | VAT Sum (SC) | Num | 20 | |||||
| VatSumFc | VAT Sum (FC) | Num | 20 | |||||
| DeductSum | Deduct VAT Sum | Num | 20 | |||||
| DedctSumSC | Deduct VAT Sum (SC) | Num | 20 | |||||
| DedctSumFC | Deduct VAT Sum (FC) | Num | 20 | |||||
| EqSum | Equalization Sum | Num | 20 | |||||
| EqSumSC | Equalization Sum (SC) | Num | 20 | |||||
| EqSumFC | Equalization Sum (FC) | Num | 20 | |||||
| TaxAcct | Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| DefAcct | Deferred Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| NdAcct | Non Deduct. Account | nVarChar | 15 | OACT G/L Accounts | ||||
| AcqAcct | Acquisition Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpAcct | Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CrditDebit | Credit Or Debit Transaction | VarChar | C) Credit D) DEBIT | 1 | ||||
| PostingTyp | Sales or Purchasing | VarChar | N) None R) Sales P) Purchase | 1 | N | |||
| BasePaid | Applied Base Sum | Num | 20 | |||||
| BasePaidSC | Applied Base Sum SC | Num | 20 | |||||
| BasePaidFC | Applied Base Sum FC | Num | 20 | |||||
| VatPaid | Applied VAT Sum | Num | 20 | |||||
| VatPaidSC | Applied VAT Sum SC | Num | 20 | |||||
| VatPaidFC | Applied VAT Sum FC | Num | 20 | |||||
| DeductPaid | Applied Deduct Sum | Num | 20 | |||||
| DdctPaidSC | Applied Deduct Sum SC | Num | 20 | |||||
| DdctPaidFC | Applied Deduct Sum FC | Num | 20 | |||||
| EqPaid | Applied Equalization Sum | Num | 20 | |||||
| EqPaidSC | Applied Equalization Sum SC | Num | 20 | |||||
| EqPaidFC | Applied Equalization Sum FC | Num | 20 | |||||
| TransAcct | Transaction Acccount | nVarChar | 15 | OACT G/L Accounts | ||||
| LnDataNum | Line Number in Tax Data | Int | 11 | -1 | ||||
| InPrice | Included in Price | VarChar | Y) Yes N) No | 1 | N | |||
| Exempt | Exempt | VarChar | Y) Yes N) No | 1 | N | |||
| InGrossRev | Included in Gross Revenue | VarChar | Y) Yes N) No | 1 | N | |||
| PostStatus | Posting Status | VarChar | Y) Yes N) No | 1 | Y | |||
| IsItmLevel | Is Item Level Tax | VarChar | N) No Y) Yes | 1 | N | |||
| MinTAmt | Min. Taxable Amount | Num | 20 | |||||
| MinTAmtSC | Min. Taxable Amount (SC) | Num | 20 | |||||
| MinTAmtFC | Min. Taxable Amount (FC) | Num | 20 | |||||
| MaxTAmt | Max. Taxable Amount | Num | 20 | |||||
| MaxTAmtSC | Max. Taxable Amount (SC) | Num | 20 | |||||
| MaxTAmtFC | Max. Taxable Amount (FC) | Num | 20 | |||||
| FlatTAmt | Flat Tax Amount | Num | 20 | |||||
| FlatTAmtSC | Flat Tax Amount (SC) | Num | 20 | |||||
| FlatTAmtFC | Flat Tax Amount (FC) | Num | 20 | |||||
| EqTaxAcct | Equalization Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Reposted | Reposted in Transfer Wizard | VarChar | Y) Yes N) No | 1 | N | |||
| Unencumbrd | Unencumbered | VarChar | Y) Yes N) No | 1 | N | |||
| IsSplitPay | Split Payment | VarChar | Y) Yes N) No | 1 | N | |||
| SplitPayAc | Split Payment Account | nVarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
