📚 SAP Business One SDK Help

Table Name: PQT2

Table Description: Purchase Quotation - Freight - Rows

Field Description Type Size Related Default Value Constraints
DocEntry Internal Document ID Int 11 OPQT      
LineNum Row Number Int 11 -      
GroupNum Group Number Int 11 -      
ExpnsCode Freight 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 -      
ObjType Object Type nVarChar 20 ADP1 540000006    
LogInstanc Log Instance Int 11 - 0    
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
VatApplied Vat Applied Num 19.6 -      
VatAppldFC Vat Applied Frgn Num 19.6 -      
VatAppldSC Vat Applied Sys 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 -      
lineVatlF Net Tax Amount (FC) Num 19.6 -      
lineVatS Net Tax Amount (SC) Num 19.6 -      
WtLiable WTax Liable VarChar 1 -   Y Yes
            N No
BaseMethod Drawing 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 -   Y Yes
            N No
BaseGroup Base Document Group Int 11 - -1 -1  
            0  
            1  
            2  
Status Status VarChar 1 - O O Open
            C Close
TrgGroup Target Group Int 11 - -1 -1  
            0  
            1  
            2  
VisOrder Visual Order Int 11 -      
FixCurr Fixation Currency nVarChar 3 OCRN      
VatDscntPr Tax Discount % Num 19.6 -      
OcrCode Distribution Rule nVarChar 8 OOCR      
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 -      
RetReqLC Return Request Amount Num 19.6 -      
RetReqFC Return Request Amount (FC) Num 19.6 -      
RetReqSC Return Request Amount (SC) Num 19.6 -      
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
    GroupNum
LINE No DocEntry
    LineNum