📚 SAP Business One SDK Help

Table Name: ADO3

Table Description: Marketing Document - Freight - History

Field Description Type Size Related Default Value Constraints
DocEntry Document Internal ID Int 11 ADOC      
ExpnsCode Expense Code Int 11 OEXD      
LineTotal Total Num 19.6 -      
TotalFrgn Total (FC) Num 19.6 -      
TotalSumSy Total (SC) Num 19.6 -      
PaidToDate Paid to Date Num 19.6 -      
PaidFC Paid (FC) Num 19.6 -      
PaidSys Paid (SC) Num 19.6 -      
Comments Remarks nVarChar 100 -      
ObjType Object Type nVarChar 20 ADP1      
LogInstanc Log Instance Int 11 - 0    
DistrbMthd Distribution Method VarChar 1 -   N None
            Q Quantity
            V Volume
            W Weight
            E Equally
            T Row Total
TaxStatus Tax Liable VarChar 1 - Y Y Yes
            N No
VatGroup Tax Group nVarChar 8 OVTG      
VatPrcnt Row Tax % Num 19.6 -      
VatSum Tax Amount Num 19.6 -      
VatSumFrgn Tax Amount (FC) Num 19.6 -      
VatSumSy Tax Amount (SC) Num 19.6 -      
DedVatSum Deductible Tax Amount Num 19.6 -      
DedVatSumF Deductible Tax Amount (FC) Num 19.6 -      
DedVatSumS Deductible Tax Amount (SC) Num 19.6 -      
IsAcquistn Aquisition Tax VarChar 1 - N Y Yes
            N No
TaxCode Tax Code nVarChar 8 OSTC      
TaxType Tax Type VarChar 1 - Y Y Regular Tax
            N No Tax
            U Use Tax
WTLiable WT Liable VarChar 1 -   Y Yes
            N No
VatApplied Vat Applied Num 19.6 -      
VatAppldFC Applied Tax (FC) Num 19.6 -      
VatAppldSC Applied Tax (SC) Num 19.6 -      
EquVatPer Equalization Tax % Num 19.6 -      
EquVatSum Total Equalization Tax Num 19.6 -      
EquVatSumF Total Equalization Tax (FC) Num 19.6 -      
EquVatSumS Total Equalization Tax (SC) Num 19.6 -      
LineVat Net Tax Amount Num 19.6 -      
LineVatF Net Tax Amount (FC) Num 19.6 -      
LineVatS Net Tax Amount (SC) Num 19.6 -      
BaseMethod Base Method VarChar 1 -   N None
            Q Quantity
            V Volume
            W Weight
            T Total
            A All
Stock Stock VarChar 1 -   Y Yes
            N No
LstPchPrce Last Purchase Price VarChar 1 -   Y Yes
            N No
AnalysRpt Analysis Report VarChar 1 - N Y Yes
            N No
BaseAbsEnt Base Abs Entry Int 11 - -1    
BaseType Base Document Type Int 11 - -1 -1  
            0  
            13 Invoices
            15 Delivery notes
            16 Revert Delivery Notes
            17 Orders
            18 Purchases
            20 Purchase Delivery Notes
            21 Revert Purchase Delivery Notes
            22 Purchase orders
            23 Quotations
BaseRef Base Document Reference Int 11 -      
BaseLnNum Base Document Line No. Int 11 -      
LineNum line num Int 11 - -1    
Status Status VarChar 1 - O O Open
            C Closed
TrgType Target Type Int 11 -      
TrgAbsEnt Target Abs. Entry Int 11 - -1    
StDstr Stock Distributed Sum Num 19.6 -      
StDstrSC Stock Distributed Sum (SC) Num 19.6 -      
StDstrFC Stock Distributed Sum (FC) Num 19.6 -      
FixCurr Fixation Currency nVarChar 3 OCRN      
VatDscntPr Tax Discount % Num 19.6 -      
OcrCode Distribution Rule nVarChar 8 OOCR      
TaxDistMtd Tax Distribution Method VarChar 1 -   N None
            Q Quantity
            V Volume
            W Weight
            E Equally
            T Row Total
OcrCode2 Distribution Rule2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule5 nVarChar 8 OOCR      
Project Project Code nVarChar 20 OPRJ      
VatGrpSrc VAT Group Source VarChar 1 - N N Not Defined
            M Manually Entered
            D Determined
DrawnTotal Drawn Total Num 19.6 -      
DrawnFC Drawn Total (FC) Num 19.6 -      
DrawnSC Drawn Total (SC) Num 19.6 -      
GrsAmount Gross Amount Num 19.6 -      
GrsFC Gross Amount (FC) Num 19.6 -      
GrsSC Gross Amount (SC) Num 19.6 -      
BaseTotal Base Total for Calculation VarChar 1 - N N Net Total
            G Gross Total
RetReqLC Return Request Amount Num 19.6 -      
RetReqFC Return Request Amount (FC) Num 19.6 -      
RetReqSC Return Request Amount (SC) Num 19.6 -      
RRVatLC Return Request VAT Amount Num 19.6 -      
RRVatFC Return Request VAT Amount (FC) Num 19.6 -      
RRVatSC Return Request VAT Amount (SC) Num 19.6 -      
EncryptIV Encrypt IV nVarChar 100 -      
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 -      
CUSplit CU Split VarChar 1 - N Y Yes
            N No
DocFreight Included in Operating Profit VarChar 1 -   Y Yes
            N No
Key Unique Field
PRIMARY Yes DocEntry
    LineNum
    LogInstanc
    ObjType
DOCUMENT No DocEntry