|
|
API UWTX1
UWTX1 - WTax Transactions - Rows Table
WTax Transactions OWTX SQL Table
G/L Accounts OACT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal ID | Int | 11 | OWTX WTax Transactions | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineSeq | Row Sequence | Int | 11 | |||||
| SrcArrType | Source Array Type | Int | -1) Default 1) Main 12) Array 1 13) Array 2 14) Array 3 | 11 | -1 | |||
| SrcLineNum | Source Row Number | Int | 11 | -1 | ||||
| SrcGrpNum | Source Group Number | Int | -1) Default 0 1) Group 2 2) Group 3 | 11 | -1 | |||
| BaseObjTyp | Base Object Type | nVarChar | 20 | -1 | ||||
| BaseAbs | Base Document Internal No. | Int | 11 | -1 | ||||
| BaseArrTyp | Base Array Type | Int | -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 | 11 | -1 | |||
| BaseLinNum | Base Row Number | Int | 11 | -1 | ||||
| BaseGrpNum | Base Group No. | Int | -1) Default 0 1) Group 2 2) Group 3 | 11 | -1 | |||
| WTaxAbsId | Tax Code ID | nVarChar | 8 | |||||
| Account | Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Rate | Rate | Num | 20 | |||||
| Exemption | Exemption Rate | Num | 20 | |||||
| BaseType | Base Type | VarChar | N) Net V) VAT G) Gross | 1 | N | |||
| BaseNetSum | Base Net Sum | Num | 20 | |||||
| BaseNetSC | Base Net Sum (SC) | Num | 20 | |||||
| BaseNetFC | Base Net Sum (FC) | Num | 20 | |||||
| BaseVatSum | Base VAT Sum | Num | 20 | |||||
| BaseVatSC | Base VAT Sum (SC) | Num | 20 | |||||
| BaseVatFC | Base VAT Sum (FC) | Num | 20 | |||||
| AccBaseSum | Accumulated Sum | Num | 20 | |||||
| AccBaseSC | Accumulated Sum (SC) | Num | 20 | |||||
| AccBaseFC | Accumulated Sum (FC) | Num | 20 | |||||
| AccWTaxSum | Accumulated WTax Sum | Num | 20 | |||||
| AccWTaxSC | Accumulated WTax Sum (SC) | Num | 20 | |||||
| AccWTaxFC | Accumulated WTax Sum (FC) | Num | 20 | |||||
| TxblSum | Taxable Sum | Num | 20 | |||||
| TxblSumSc | Taxable Sum (SC) | Num | 20 | |||||
| TxblSumFc | Taxable Sum (FC) | Num | 20 | |||||
| WTaxSum | WTax Sum | Num | 20 | |||||
| WTaxSumSc | WTax Sum (SC) | Num | 20 | |||||
| WTaxSumFc | WTax Sum (FC) | Num | 20 | |||||
| ApplSum | Applied Sum | Num | 20 | |||||
| ApplSumSc | Applied Sum (SC) | Num | 20 | |||||
| ApplSumFc | Applied Sum (FC) | Num | 20 | |||||
| CrditDebit | Credit or Debit Transaction | VarChar | C) Credit D) Debit | 1 | ||||
| PostingTyp | Sales or Purchase | VarChar | N) None R) Sales P) Purchase | 1 | N | |||
| Category | Category | VarChar | I) Invoice P) Payment | 1 | P | |||
| WTTypeId | Type | Int | 11 | |||||
| WhtType | Withholding Type | VarChar | V) VAT Withholding G) Gross Income Withholding N) Income Tax Withholding S) Social Security Withholding I) Industry Specific Withholding D) District Specific Withholding | 1 | V | |||
| FmlId | Formula ID | Int | 11 |
Table relationship map
SELECT statement
SELECT
UWTX1.AbsEntry AS 'Internal ID',
UWTX1.LineSeq AS 'Row Sequence',
UWTX1.SrcArrType AS 'Source Array Type',
UWTX1.SrcLineNum AS 'Source Row Number',
UWTX1.SrcGrpNum AS 'Source Group Number',
UWTX1.BaseObjTyp AS 'Base Object Type',
UWTX1.BaseAbs AS 'Base Document Internal No.',
UWTX1.BaseArrTyp AS 'Base Array Type',
UWTX1.BaseLinNum AS 'Base Row Number',
UWTX1.BaseGrpNum AS 'Base Group No.',
UWTX1.WTaxAbsId AS 'Tax Code ID',
UWTX1.Account AS 'Account',
UWTX1.Rate AS 'Rate',
UWTX1.Exemption AS 'Exemption Rate',
UWTX1.BaseType AS 'Base Type',
UWTX1.BaseNetSum AS 'Base Net Sum',
UWTX1.BaseNetSC AS 'Base Net Sum (SC)',
UWTX1.BaseNetFC AS 'Base Net Sum (FC)',
UWTX1.BaseVatSum AS 'Base VAT Sum',
UWTX1.BaseVatSC AS 'Base VAT Sum (SC)',
UWTX1.BaseVatFC AS 'Base VAT Sum (FC)',
UWTX1.AccBaseSum AS 'Accumulated Sum',
UWTX1.AccBaseSC AS 'Accumulated Sum (SC)',
UWTX1.AccBaseFC AS 'Accumulated Sum (FC)',
UWTX1.AccWTaxSum AS 'Accumulated WTax Sum',
UWTX1.AccWTaxSC AS 'Accumulated WTax Sum (SC)',
UWTX1.AccWTaxFC AS 'Accumulated WTax Sum (FC)',
UWTX1.TxblSum AS 'Taxable Sum',
UWTX1.TxblSumSc AS 'Taxable Sum (SC)',
UWTX1.TxblSumFc AS 'Taxable Sum (FC)',
UWTX1.WTaxSum AS 'WTax Sum',
UWTX1.WTaxSumSc AS 'WTax Sum (SC)',
UWTX1.WTaxSumFc AS 'WTax Sum (FC)',
UWTX1.ApplSum AS 'Applied Sum',
UWTX1.ApplSumSc AS 'Applied Sum (SC)',
UWTX1.ApplSumFc AS 'Applied Sum (FC)',
UWTX1.CrditDebit AS 'Credit or Debit Transaction',
UWTX1.PostingTyp AS 'Sales or Purchase',
UWTX1.Category AS 'Category',
UWTX1.WTTypeId AS 'Type',
UWTX1.WhtType AS 'Withholding Type',
UWTX1.FmlId AS 'Formula ID'
FROM UWTX1 AS UWTX1
Related information
WTax Transactions OWTX SQL Table
G/L Accounts OACT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
