📚 SAP Business One SDK Help

Table Name: PRQ4

Table Description: Purchase Request - Tax Amount per Document

Field Description Type Size Related Default Value Constraints
DocEntry Internal Document ID Int 11 OPRQ      
LineNum Row Number Int 11 - -1    
GroupNum Group Number Int 11 - -1    
ExpnsCode Expense Code Int 11 OEXD -1    
RelateType Relation Type Int 11 - 1 1 Row
            2 Row Freight Charges
            3 Document Expenses
            13 Distributed Freights
StcCode Tax Code nVarChar 8 OSTC      
StaCode Authority Code nVarChar 8 OSTA      
staType Authority Type Int 11 OSTT      
TaxRate Tax Rate Num 19.6 -      
TaxAcct Tax Account nVarChar 15 OACT      
TaxSum Tax Amount Num 19.6 -      
TaxSumFrgn Tax Amount (FC) Num 19.6 -      
TaxSumSys Tax Amount (SC) Num 19.6 -      
BaseSum Base Amount Num 19.6 -      
BaseSumFrg Base Amount (FC) Num 19.6 -      
BaseSumSys Base Amount (SC) Num 19.6 -      
ObjectType Object Type nVarChar 20 ADP1 1470000113    
LogInstanc Log Instance Int 11 - 0    
TaxStatus Tax Status VarChar 1 - Y Y Regular Tax
            N No Tax
            U Use Tax
VatApplied VAT Applied Num 19.6 -      
VatAppldFC Applied Tax (FC) Num 19.6 -      
VatAppldSC Applied Tax (SC) Num 19.6 -      
LineSeq Line Sequence Int 11 -      
DeferrAcct Deferred Tax Account nVarChar 15 OACT      
BaseType Base Document Type Int 11 - -1    
BaseAbs Base Doc. Abs. Entry Int 11 - -1    
BaseSeq Base Doc. Line Sequence Int 11 -      
DeductTax Deductible Tax Amount Num 19.6 -      
DdctTaxFrg Deductible Tax Amount (FC) Num 19.6 -      
DdctTaxSys Deductible Tax Amount (SC) Num 19.6 -      
BaseAppld Applied Base Amount Num 19.6 -      
BaseApldFC Applied Base Amount (FC) Num 19.6 -      
BaseApldSC Applied Base Amount (SC) Num 19.6 -      
NonDdctPrc Non Deductible % Num 19.6 -      
NonDdctAct Non Deductible Account nVarChar 15 OACT      
TaxInPrice Tax Included in Price VarChar 1 - N Y Yes
            N No
Exempt Exempt VarChar 1 - N Y Yes
            N No
TaxExpAct Expense Account for Tax nVarChar 15 OACT      
OnHoldTax On Hold Tax Amount Num 19.6 -      
OnHoldTaxF On Hold Tax Amount (FC) Num 19.6 -      
OnHoldTaxS On-Hold Tax Amount (SC) Num 19.6 -      
InGrossRev Included in Gross Revenue VarChar 1 - N Y Yes
            N No
TaxSumOrg Tax Amount Original Num 19.6 -      
TaxSumOrgF Tax Amount Original (FC) Num 19.6 -      
TaxSumOrgS Tax Amount Original (SC) Num 19.6 -      
OpenTax Open Service Tax Num 19.6 -      
OpenTaxFC Open Service Tax (FC) Num 19.6 -      
OpenTaxSC Open Service Tax (SC) Num 19.6 -      
Unencumbrd Unencumbered VarChar 1 - N Y Yes
            N No
TaxOnRI Tax On Reserve Invoice VarChar 1 - N Y Yes
            N No
RvsChrgPrc Reverse Charge % Num 19.6 -      
RvsChrgTax Reverse Charge Tax Amount Num 19.6 -      
RvsChrgSC Reverse Charge Tax Amount (SC) Num 19.6 -      
RvsChrgFC Reverse Charge Tax Amount (FC) Num 19.6 -      
InFirstIns Included in First Installment VarChar 1 - N Y Yes
            N No
ExtTaxRate External Tax Rate Num 19.6 -      
ExtTaxSum External Tax Amount Num 19.6 -      
TaxAmtSrc Tax Amount Source VarChar 1 - S S Internal System Calculation
            E External Calculation
ExtTaxSumF External Tax Amount (FC) Num 19.6 -      
ExtTaxSumS External Tax Amount (SC) Num 19.6 -      
CESTrel CEST Relevant VarChar 1 - N Y  
            N  
Key Unique Field
PRIMARY Yes DocEntry
    LineSeq
SCONDARY No DocEntry
    LineNum
    GroupNum
    ExpnsCode
    StcCode
    StaCode
    staType