vr_PurchaseDistrib

Updated February 04, 2026 16:54

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ActualQuantity	Actual Quantity	decimal
Balance	Remaining Balance	decimal
ChargeTypeCode	Charge Type Code	nvarchar
ChargeTypeDescription	Charge Type Description	nvarchar
ChargeTypeId	Charge Type Id	int	vr_chargeType
Comment	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DetailCode	Detail Code	nvarchar
DetailDescription	Detail Description	nvarchar
Email	Email	nvarchar
Id	Purchase Distribution Id	int
ISOTP	Indicates if the record is an one time purchase	bit
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
OrderedInvidualQty	Ordered Invidual Quantity	int
PurchaseOrderItemId	Purchase Order Item Id	int	vr_PurchaseOrderItems
PurchaseOrderItemPurchaseOrderId	Purchase Order Id	int	vr_PurchaseOrder
Quantity	Quantity	decimal
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
TaskDescripton	Task Description	nvarchar
WorkOrderChargeable	Indicates if the Work Order is Chargeable	bit
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar
WorkOrderTaskDisplay	Work Order Task Display	nvarchar
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask