📚 SAP Business One SDK Help

Table Name: PQW2

Table Description: Purchase Quotation Generation Parameters

Field Description Type Size Related Default Value Constraints
RunUser Run User ID Int 6 -      
RunDate Job Running Date Date 8 -      
RunTime Job Running Time Int 6 -      
DocNum Document Number Int 11 -      
LineNum Row Number Int 11 -      
VendorCode Vendor Code nVarChar 15 -      
VendorName Vendor Name nVarChar 200 -      
ItemCode Item No. nVarChar 50 OITM      
Dscription Item/Service Description nVarChar 200 -      
WhsCode Warehouse Code nVarChar 8 OWHS      
MinOrdrQty Minimum Order Quantity Num 19.6 -      
InStock Item in Stock Num 19.6 -      
Ordered Item Ordered Num 19.6 -      
Committed Item Committed Num 19.6 -      
ItmPerUnit Number of Items per Purchase Unit Num 19.6 -      
BuyUnitMsr Purchasing UoM nVarChar 100 -      
FreeTxt Free Text nVarChar 100 -      
PQTGrpNum Purchase Quotation Group Number Int 11 -      
PQTGrpSer Purchase Quotation Group Series Int 11 -      
PQTGrpHW Purchase Quotation Group Manual VarChar 1 - N Y Yes
            N No
PQTReqQty Purchase Quotation: Required Qty Num 19.6 -      
PQTSeries Purchase Quotation Series Int 11 NNM1      
PQTReqDate Purchase Quotation: Required Date Date 8 -      
ValidUntil Valid Until Date Date 8 -      
PRAbsEntry Purchase Request Number Int 11 OPRQ      
PRDocNum Purchase Request Document Number Int 11 -      
ReqName Requester Name nVarChar 155 -      
PRLineNum Purchase Request Row Number Int 11 -      
PRLineStat Purchase Request Row Status VarChar 1 -      
DistRule Distribution Rule nVarChar 8 -      
DistRule2 Distribution Rule 2 nVarChar 8 -      
DistRule3 Distribution Rule 3 nVarChar 8 -      
DistRule4 Distribution Rule 4 nVarChar 8 -      
DistRule5 Distribution Rule 5 nVarChar 8 -      
Project Project Code nVarChar 20 -      
VendMfrNum Vendor Mfr Catalog No. nVarChar 17 -      
ShipType Shipping Type Int 6 -      
Buyer Buyer Int 11 -      
PriceMode Price Mode VarChar 1 - N N Net
            G Gross
UoMNum UoM Item Per Unit Numerator Num 19.6 -      
UoMDen UoM Item Per Unit Denominator Num 19.6 -      
IsNewPQ Is New Purchase Quotation VarChar 1 - Y N No
            Y Yes
Key Unique Field
PRIMARY Yes RunUser
    RunDate
    RunTime
    DocNum
    LineNum