📚 SAP Business One SDK Help

Table Name: DLN3

Table Description: Delivery Notes - Freight

Field Description Type Size Related Default Value Constraints
DocEntry Document Internal ID Int 11 ODLN      
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 in FC Num 19.6 -      
PaidSys Paid in SC Num 19.6 -      
Comments Remarks nVarChar 100 -      
ObjType Object Type nVarChar 20 ADP1 15    
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 Acquisition 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  
            15 Delivery
            23 Sales Quotation
            17 Sales Order
            16 A/R Returns
            13 A/R Invoice
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
DOCUMENT No DocEntry
    BaseAbsEnt