biuan SAP® BUSINESS ONE SDK
API WTQ4
WTQ4 - Inventory Transfer Request - Tax Amount per Document Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEYInternal Document IDInt
11OWTQ
Inventory Transfer Request
SCONDARYNo
LineNumRow NumberInt
11
-1
GroupNumGroup No.Int
11
-1
ExpnsCodeExpense CodeInt
11OEXD
Freight Setup
-1
RelateTypeRelation TypeInt
1) Row
2) Row Freight Charges
3) Document Expenses
13) Distributed Freights
11
1
StcCodeTax CodenVarChar
8OSTC
Sales Tax Codes
StaCodeTax CodenVarChar
8OSTA
Sales Tax Authorities
staTypeAuthority TypeInt
11OSTT
Sales Tax Authorities Type
TaxRateAuthority TypeNum
20OSTT
Sales Tax Authorities Type
TaxAcctAuthority CodenVarChar
15
TaxSumTax %Num
20OACT
G/L Accounts
TaxSumFrgnTax AccountNum
20
TaxSumSysTax AmountNum
20
BaseSumTax Amount (FC)Num
20
BaseSumFrgBase AmountNum
20
BaseSumSysBase Amount (FC)Num
20
ObjectTypeBase Amount (SC)nVarChar
20
LogInstancTax Amount (SC)Int
11ADP1
Object Settings - History
0
TaxStatusBase AmountVarChar
Y) Regular Tax
N) No Tax
U) Use Tax
1
Y
VatAppliedVAT AppliedNum
20
VatAppldFCApplied Tax (FC)Num
20
VatAppldSCApplied Tax (SC)Num
20
LineSeqLine SequenceInt
11
DeferrAcctDeferred Tax AccountnVarChar
15OACT
G/L Accounts
BaseTypeBase Document TypeInt
11
-1
BaseAbsBase Doc Abs EntryInt
11
-1
BaseSeqBase Doc. Line SequenceInt
11
DeductTaxDeductible Tax AmountNum
20
DdctTaxFrgDeductible Tax Amount (FC)Num
20
DdctTaxSysDeductible Tax Amount (SC)Num
20
BaseAppldApplied Base AmountNum
20
BaseApldFCApplied Base Amount (FC)Num
20
BaseApldSCApplied Base Amount (SC)Num
20
NonDdctPrcNon Deductible %Num
20
NonDdctActNon Deductible AccountnVarChar
15OACT
G/L Accounts
TaxInPriceTax Included in Price?VarChar
Y) Yes
N) No
1
N
ExemptExempt?VarChar
Y) Yes
N) No
1
N
TaxExpActExpense Account for TaxnVarChar
15OACT
G/L Accounts
OnHoldTaxOn Hold Tax AmountNum
20
OnHoldTaxFOn Hold Tax Amount (FC)Num
20
OnHoldTaxSOn Hold Tax Amount (SC)Num
20
InGrossRevIncluded in Gross RevenueVarChar
Y) Yes
N) No
1
N
TaxSumOrgTax Amount OriginalNum
20
TaxSumOrgFTax Amount Original (FC)Num
20
TaxSumOrgSTax Amount Original (SC)Num
20
OpenTaxOpen Service TaxNum
20
OpenTaxFCOpen Service Tax (FC)Num
20
OpenTaxSCOpen Service Tax (SC)Num
20
UnencumbrdUnencumberedVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT WTQ4.DocEntry AS 'Internal Document ID', WTQ4.LineNum AS 'Row Number', WTQ4.GroupNum AS 'Group No.', WTQ4.ExpnsCode AS 'Expense Code', WTQ4.RelateType AS 'Relation Type', WTQ4.StcCode AS 'Tax Code', WTQ4.StaCode AS 'Tax Code', WTQ4.staType AS 'Authority Type', WTQ4.TaxRate AS 'Authority Type', WTQ4.TaxAcct AS 'Authority Code', WTQ4.TaxSum AS 'Tax %', WTQ4.TaxSumFrgn AS 'Tax Account', WTQ4.TaxSumSys AS 'Tax Amount', WTQ4.BaseSum AS 'Tax Amount (FC)', WTQ4.BaseSumFrg AS 'Base Amount', WTQ4.BaseSumSys AS 'Base Amount (FC)', WTQ4.ObjectType AS 'Base Amount (SC)', WTQ4.LogInstanc AS 'Tax Amount (SC)', WTQ4.TaxStatus AS 'Base Amount', WTQ4.VatApplied AS 'VAT Applied', WTQ4.VatAppldFC AS 'Applied Tax (FC)', WTQ4.VatAppldSC AS 'Applied Tax (SC)', WTQ4.LineSeq AS 'Line Sequence', WTQ4.DeferrAcct AS 'Deferred Tax Account', WTQ4.BaseType AS 'Base Document Type', WTQ4.BaseAbs AS 'Base Doc Abs Entry', WTQ4.BaseSeq AS 'Base Doc. Line Sequence', WTQ4.DeductTax AS 'Deductible Tax Amount', WTQ4.DdctTaxFrg AS 'Deductible Tax Amount (FC)', WTQ4.DdctTaxSys AS 'Deductible Tax Amount (SC)', WTQ4.BaseAppld AS 'Applied Base Amount', WTQ4.BaseApldFC AS 'Applied Base Amount (FC)', WTQ4.BaseApldSC AS 'Applied Base Amount (SC)', WTQ4.NonDdctPrc AS 'Non Deductible %', WTQ4.NonDdctAct AS 'Non Deductible Account', WTQ4.TaxInPrice AS 'Tax Included in Price?', WTQ4.Exempt AS 'Exempt?', WTQ4.TaxExpAct AS 'Expense Account for Tax', WTQ4.OnHoldTax AS 'On Hold Tax Amount', WTQ4.OnHoldTaxF AS 'On Hold Tax Amount (FC)', WTQ4.OnHoldTaxS AS 'On Hold Tax Amount (SC)', WTQ4.InGrossRev AS 'Included in Gross Revenue', WTQ4.TaxSumOrg AS 'Tax Amount Original', WTQ4.TaxSumOrgF AS 'Tax Amount Original (FC)', WTQ4.TaxSumOrgS AS 'Tax Amount Original (SC)', WTQ4.OpenTax AS 'Open Service Tax', WTQ4.OpenTaxFC AS 'Open Service Tax (FC)', WTQ4.OpenTaxSC AS 'Open Service Tax (SC)', WTQ4.Unencumbrd AS 'Unencumbered' FROM WTQ4 AS WTQ4

Related information


G/L Accounts OACT SQL Table

Inventory Transfer Request OWTQ SQL Table

Freight Setup OEXD SQL Table

Object Settings - History ADP1 SQL Table

Sales Tax Authorities OSTA SQL Table

Sales Tax Authorities Type OSTT SQL Table

Sales Tax Codes OSTC 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