📚 SAP Business One SDK Help

Table Name: ADO4

Table Description: Documents - Tax - History

Field Description Type Size Related Default Value Constraints
DocEntry Document Internal ID Int 11 ADOC      
LineNum Row Number Int 11 - -1    
GroupNum Group No. 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 Tax Code nVarChar 8 OSTA      
staType Authority Type Int 11 OSTT      
TaxRate Authority Type Num 19.6 OSTT      
TaxAcct Authority Code nVarChar 15 -      
TaxSum Tax % Num 19.6 OACT      
TaxSumFrgn Tax Account Num 19.6 -      
TaxSumSys Tax Amount Num 19.6 -      
BaseSum Tax Amount (FC) Num 19.6 -      
BaseSumFrg Base Amount Num 19.6 -      
BaseSumSys Base Amount (FC) Num 19.6 -      
ObjectType Base Amount (SC) nVarChar 20 -      
LogInstanc Tax Amount (SC) Int 11 ADP1 0    
TaxStatus Base Amount 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
    ObjectType
    LogInstanc
SCONDARY No DocEntry
    LineNum
    GroupNum
    ExpnsCode
    StcCode
    StaCode
    staType