vrpt_OnHandAdjustmentDetail

Updated January 05, 2026 17:31

Field Name	Field Description	Data Type	FK Join
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
DailyUnderstockReportType	Daily Understock Report Type	int
fmov_comment	Comment	nvarchar
fmov_createddate	Record Creation Date	datetime
fmov_creator_fk	User Id (Record Creator)	int	vr_users
fmov_damagedQuantity	Damaged Quantity	decimal
fmov_extendedcost	Extended Cost	decimal
fmov_freightCost	Freight Cost	decimal
fmov_inv_fk	Part Inventory Id	int	vrpt_PartInventoryList
fmov_modifieddate	Last Modified Date	datetime
fmov_modifier_fk	User Id (Record Modifier)	int	vr_users
fmov_otpCode	One Time Purchase Code	nvarchar
fmov_otpDescription	One Time Purchase Description	nvarchar
fmov_pk	Oh Hand Adjustment Detail Id	int
fmov_pmov_fk	Oh Hand Adjustment Id	int	vr_OnHandAdjustment
fmov_postDate	Post Date	datetime
fmov_purchaseOrderNumber	Purchase Order Number	nvarchar
fmov_quantity	Quantity	decimal
fmov_unitCost	Unit Cost	decimal
fmov_unitOfMeasure	Unit of Measure	nvarchar
fpo_detailcode	Detail Code	nvarchar
fpo_detaildescription	Detail Description	nvarchar
fpo_lineNumber	Line Number	smallint
fpo_po_fk	Purchase Order Id	int	vr_PurchaseOrder
Id	Oh Hand Adjustment Detail Id	int
inv_binLabel	Inventory Bin Label	nvarchar
inv_maximumLevel	Inventory Maximum Level	int
inv_minimumLevel	Inventory Minimum Level	int
inv_reorderQuantity	Inventory Reorder Quantity	int
isReceivingType	Indicates if this record is Receiving Type	bit
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
newwh_code	New Warehouse Code	nvarchar
newwh_name	New Warehouse Name	nvarchar
ohSubType_desc	On Hand Adjustment Sub Type Description	nvarchar
ohType_code	On Hand Adjustment Type Code	nvarchar
ohType_Description	On Hand Adjustment Type Description	nvarchar
OptionField1	Option Field 1	nvarchar
OptionField2	Option Field 2	nvarchar
OptionField3	Option Field 3	nvarchar
OptionField4	Option Field 4	nvarchar
OverStock	Over Stock	int
PA_AverageCost	Part Average Cost	decimal
pa_code	Part Code	nvarchar
pa_description	Part Description	nvarchar
pa_manufacturerNumber	Part Manufacturer Number	nvarchar
pa_pk	Part Id	int	vr_Part
pct_number	PCard Transaction Number	int
pct_pk	Purchase Card Transaction Id	int	vr_PCardTransaction
pmov_number	On Hand Adjustment Number	int
po_number	Purchase Order Number	nvarchar
ser_serialNumber	Serial Number	nvarchar
sku	SKU	nvarchar
sku_description	SKU Description	nvarchar
transactionnumber	Transaction Number	nvarchar
UnderStock	Under Stock	int
UnitCostLiteral	Unit Cost Literal	decimal
WH_CODE	Warehouse Code	nvarchar
WH_NAME	Warehouse Name	nvarchar
WH_PK	Warehouse Id	int	vr_warehouse
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder

Articles in this section