📚 SAP Business One SDK Help

Table Name: PQW1

Table Description: Purchase Quotation Generation: Line Items

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 OPQW      
LineNum Row Number Int 11 -      
ItemCode Item No. nVarChar 50 OITM      
Dscription Item/Service Description nVarChar 200 -      
PQTReqDate Pur Quotation: Required Date Date 8 -      
PQTReqQty Pur Quotation: Required Qty Num 19.6 -      
BuyUnitMsr Purchasing UoM nVarChar 100 -      
FreeTxt Free Text nVarChar 100 -      
PQTGrpNum Pur. Quotation Group Number Int 11 -      
PQTGrpSer Pur. Quotation Group Series Int 11 -      
PQTGrpHW Pur. Quotation Group Manual VarChar 1 - N Y Yes
            N No
ValidUntil Valid Until Date Date 8 -      
WhsCode Warehouse Code nVarChar 8 OWHS      
PQTSeries Purchase Quotation Series Int 11 NNM1      
PRAbsEntry Purchase Request Number Int 11 OPRQ      
ReqName Requester Name nVarChar 155 -      
PRLineNum Purchase Request Row Number Int 11 -      
PRLineStat Purchase Request Row Status VarChar 1 -      
DistriRule Distribution Rule nVarChar 8 -      
Project Project Code nVarChar 20 -      
VendMfrNum Vendor Mfr Catalog No. nVarChar 17 -      
ShipType Shipping Type Int 6 -      
ItmPerUnit No. of Items per Purchase Unit Num 19.6 -      
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 -      
Key Unique Field
PRIMARY Yes AbsEntry
    LineNum