biuan SAP® BUSINESS ONE SDK
API WTX1
WTX1 - WTax Transactions - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal IDInt
11OWTX
WTax Transactions
PRIMARYYes
LineSeqRow SequenceInt
11
SrcArrTypeSource Array TypeInt
-1) Default
1) Main
12) Array 1
13) Array 2
14) Array 3
11
-1
SrcLineNumSource Row NumberInt
11
-1
SrcGrpNumSource Group NumberInt
-1) Default
0
1) Group 2
2) Group 3
11
-1
BaseObjTypBase Object TypenVarChar
20
-1
BaseAbsBase Document Internal No.Int
11
-1
BaseArrTypBase Array TypeInt
-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
BaseLinNumBase Row NumberInt
11
-1
BaseGrpNumBase Group No.Int
-1) Default
0
1) Group 2
2) Group 3
11
-1
WTaxAbsIdTax Code IDnVarChar
8
AccountAccountnVarChar
15OACT
G/L Accounts
RateRateNum
20
ExemptionExemption RateNum
20
BaseTypeBase TypeVarChar
N) Net
V) VAT
G) Gross
1
N
BaseNetSumBase Net SumNum
20
BaseNetSCBase Net Sum (SC)Num
20
BaseNetFCBase Net Sum (FC)Num
20
BaseVatSumBase VAT SumNum
20
BaseVatSCBase VAT Sum (SC)Num
20
BaseVatFCBase VAT Sum (FC)Num
20
AccBaseSumAccumulated SumNum
20
AccBaseSCAccumulated Sum (SC)Num
20
AccBaseFCAccumulated Sum (FC)Num
20
AccWTaxSumAccumulated WTax SumNum
20
AccWTaxSCAccumulated WTax Sum (SC)Num
20
AccWTaxFCAccumulated WTax Sum (FC)Num
20
TxblSumTaxable SumNum
20
TxblSumScTaxable Sum (SC)Num
20
TxblSumFcTaxable Sum (FC)Num
20
WTaxSumWTax SumNum
20
WTaxSumScWTax Sum (SC)Num
20
WTaxSumFcWTax Sum (FC)Num
20
ApplSumApplied SumNum
20
ApplSumScApplied Sum (SC)Num
20
ApplSumFcApplied Sum (FC)Num
20
CrditDebitCredit or Debit TransactionVarChar
C) Credit
D) Debit
1
PostingTypSales or PurchaseVarChar
N) None
R) Sales
P) Purchase
1
N
CategoryCategoryVarChar
I) Invoice
P) Payment
1
P
WTTypeIdTypeInt
11
WhtTypeWithholding TypeVarChar
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
FmlIdFormula IDInt
11

Table relationship map

SELECT statement

SELECT WTX1.AbsEntry AS 'Internal ID', WTX1.LineSeq AS 'Row Sequence', WTX1.SrcArrType AS 'Source Array Type', WTX1.SrcLineNum AS 'Source Row Number', WTX1.SrcGrpNum AS 'Source Group Number', WTX1.BaseObjTyp AS 'Base Object Type', WTX1.BaseAbs AS 'Base Document Internal No.', WTX1.BaseArrTyp AS 'Base Array Type', WTX1.BaseLinNum AS 'Base Row Number', WTX1.BaseGrpNum AS 'Base Group No.', WTX1.WTaxAbsId AS 'Tax Code ID', WTX1.Account AS 'Account', WTX1.Rate AS 'Rate', WTX1.Exemption AS 'Exemption Rate', WTX1.BaseType AS 'Base Type', WTX1.BaseNetSum AS 'Base Net Sum', WTX1.BaseNetSC AS 'Base Net Sum (SC)', WTX1.BaseNetFC AS 'Base Net Sum (FC)', WTX1.BaseVatSum AS 'Base VAT Sum', WTX1.BaseVatSC AS 'Base VAT Sum (SC)', WTX1.BaseVatFC AS 'Base VAT Sum (FC)', WTX1.AccBaseSum AS 'Accumulated Sum', WTX1.AccBaseSC AS 'Accumulated Sum (SC)', WTX1.AccBaseFC AS 'Accumulated Sum (FC)', WTX1.AccWTaxSum AS 'Accumulated WTax Sum', WTX1.AccWTaxSC AS 'Accumulated WTax Sum (SC)', WTX1.AccWTaxFC AS 'Accumulated WTax Sum (FC)', WTX1.TxblSum AS 'Taxable Sum', WTX1.TxblSumSc AS 'Taxable Sum (SC)', WTX1.TxblSumFc AS 'Taxable Sum (FC)', WTX1.WTaxSum AS 'WTax Sum', WTX1.WTaxSumSc AS 'WTax Sum (SC)', WTX1.WTaxSumFc AS 'WTax Sum (FC)', WTX1.ApplSum AS 'Applied Sum', WTX1.ApplSumSc AS 'Applied Sum (SC)', WTX1.ApplSumFc AS 'Applied Sum (FC)', WTX1.CrditDebit AS 'Credit or Debit Transaction', WTX1.PostingTyp AS 'Sales or Purchase', WTX1.Category AS 'Category', WTX1.WTTypeId AS 'Type', WTX1.WhtType AS 'Withholding Type', WTX1.FmlId AS 'Formula ID' FROM WTX1 AS WTX1

Related information


WTax Transactions OWTX SQL Table

G/L Accounts OACT 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