biuan SAP® BUSINESS ONE SDK
API PQT4
PQT4 - Purchase Quotation - Tax Amount per Document Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEYInternal Document IDInt
11OPQT
Purchase Quotation
SCONDARYNo
LineNumRow NumberInt
11
-1
GroupNumGroup NumberInt
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
StaCodeAuthority CodenVarChar
8OSTA
Sales Tax Authorities
staTypeAuthority TypeInt
11OSTT
Sales Tax Authorities Type
TaxRateTax RateNum
20
TaxAcctTax AccountnVarChar
15OACT
G/L Accounts
TaxSumTax AmountNum
20
TaxSumFrgnTax Amount (FC)Num
20
TaxSumSysTax Amount (SC)Num
20
BaseSumBase AmountNum
20
BaseSumFrgBase Amount (FC)Num
20
BaseSumSysBase Amount (SC)Num
20
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History
540000006
LogInstancLog InstanceInt
11
0
TaxStatusTax StatusVarChar
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 PQT4.DocEntry AS 'Internal Document ID', PQT4.LineNum AS 'Row Number', PQT4.GroupNum AS 'Group Number', PQT4.ExpnsCode AS 'Expense Code', PQT4.RelateType AS 'Relation Type', PQT4.StcCode AS 'Tax Code', PQT4.StaCode AS 'Authority Code', PQT4.staType AS 'Authority Type', PQT4.TaxRate AS 'Tax Rate', PQT4.TaxAcct AS 'Tax Account', PQT4.TaxSum AS 'Tax Amount', PQT4.TaxSumFrgn AS 'Tax Amount (FC)', PQT4.TaxSumSys AS 'Tax Amount (SC)', PQT4.BaseSum AS 'Base Amount', PQT4.BaseSumFrg AS 'Base Amount (FC)', PQT4.BaseSumSys AS 'Base Amount (SC)', PQT4.ObjectType AS 'Object Type', PQT4.LogInstanc AS 'Log Instance', PQT4.TaxStatus AS 'Tax Status', PQT4.VatApplied AS 'VAT Applied', PQT4.VatAppldFC AS 'Applied Tax (FC)', PQT4.VatAppldSC AS 'Applied Tax (SC)', PQT4.LineSeq AS 'Line Sequence', PQT4.DeferrAcct AS 'Deferred Tax Account', PQT4.BaseType AS 'Base Document Type', PQT4.BaseAbs AS 'Base Doc Abs Entry', PQT4.BaseSeq AS 'Base Doc. Line Sequence', PQT4.DeductTax AS 'Deductible Tax Amount', PQT4.DdctTaxFrg AS 'Deductible Tax Amount (FC)', PQT4.DdctTaxSys AS 'Deductible Tax Amount (SC)', PQT4.BaseAppld AS 'Applied Base Amount', PQT4.BaseApldFC AS 'Applied Base Amount (FC)', PQT4.BaseApldSC AS 'Applied Base Amount (SC)', PQT4.NonDdctPrc AS 'Non Deductible %', PQT4.NonDdctAct AS 'Non Deductible Account', PQT4.TaxInPrice AS 'Tax Included in Price?', PQT4.Exempt AS 'Exempt?', PQT4.TaxExpAct AS 'Expense Account for Tax', PQT4.OnHoldTax AS 'On Hold Tax Amount', PQT4.OnHoldTaxF AS 'On Hold Tax Amount (FC)', PQT4.OnHoldTaxS AS 'On Hold Tax Amount (SC)', PQT4.InGrossRev AS 'Included in Gross Revenue', PQT4.TaxSumOrg AS 'Tax Amount Original', PQT4.TaxSumOrgF AS 'Tax Amount Original (FC)', PQT4.TaxSumOrgS AS 'Tax Amount Original (SC)', PQT4.OpenTax AS 'Open Service Tax', PQT4.OpenTaxFC AS 'Open Service Tax (FC)', PQT4.OpenTaxSC AS 'Open Service Tax (SC)', PQT4.Unencumbrd AS 'Unencumbered' FROM PQT4 AS PQT4

Related information


G/L Accounts OACT SQL Table

Purchase Quotation OPQT 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