vrpt_PurchaseReqItems

Updated January 13, 2026 15:58

Field Name	Field Description	Data Type	FK Join
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
fpr_batchNumber	Batch Number	float
fpr_comment	Comment	nvarchar
fpr_detailcode	Detail Code	nvarchar
fpr_detaildescription	Detail Description	nvarchar
fpr_extendedcost	Extended Cost	decimal
fpr_pk	Purchase Requisition Detail Id	int
fpr_pr_fk	Purchase Requisition Id	int	vrpt_PurchaseRequisition
fpr_Quantity	Quantity	decimal
fpr_taxAmount	Tax Amount	decimal
fpr_unitCost	Unit Cost	decimal
Id	Purchase Requisition Detail Id	int
LineUnitOfMeasure	Line Unit Of Measure	nvarchar
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
orderUnitAndQuantity	Order Unit and Quantity	nvarchar
otp_code	One Time Purchase Code	nvarchar
otp_description	One Time Purchase Description	nvarchar
pa_manufacturerNumber	Part Manufacturer Number	nvarchar
pa_orderUnit	Part Order Unit	nvarchar
pa_orderUnitQuantity	Part Order Unit Quantity	int
pa_specification	Part Specification	nvarchar
VendorPartCode	Vendor Part Code	nvarchar