vr_PCardTransaction

Updated November 26, 2025 17:38

Field Name	Field Description	Data Type	FK Join
CardTotal	Card Total	decimal
Comment	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DailyCount	Daily Count	int
DailyTotal	Daily Total	decimal
Date	Date	datetime
FreightAmount	Freight Amount	decimal
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Purchase Card Transaction Id	int
LastStatementDate	Last Statement Date	datetime
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
MonthlyTotal	Monthly Total	decimal
Number	Purchase Card Transaction Number	int
PCardTypeCode	Purchase Card Type Code	nvarchar
PCardTypeDescription	Purchase Card Type Description	nvarchar
PCardTypeId	Purchase Card Type Id	int
PCTaxCompound	Indicates if the record utilizes tax compound	bit
PCTaxPassThruRate	Purchase Card Tax Pass Thru Rate	decimal
PCTaxRate	Purchase Card Tax Rate	decimal
PCTaxRate2	Purchase Card Tax Rate 2	decimal
ReconcileDate	Reconcile Date	datetime
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
SubTotal	Sub Total	decimal
TaxAmount	Tax Amount	decimal
TaxAmount1	Tax Amount 1	decimal
TaxAmount2	Tax Amount 2	decimal
TaxLineSubTotal	Tax Sub Total	decimal
TaxRateCompound	Indicates if the record utilizes the tax rate compound	bit
TaxRateDescription1	Tax Rate 1 Description	nvarchar
TaxRateDescription2	Tax Rate 2 Description	nvarchar
TaxRateId	Tax Rate Id	int	vr_TaxRate
TaxRateName	Tax Rate Name	nvarchar
TaxRatePCard	Indicates if the record utilizes the tax rate on Purchase Card transactions	bit
TaxRateRate1	Tax Rate 1 Rate	decimal
TaxRateRate2	Tax Rate 2 Rate	decimal
TechnicianPCardDailyLimit	Technician Purchase Card Daily Limit	decimal
TechnicianPCardDailyTransaction	Technician Purchase Card Daily Transaction	int
TechnicianPCardExpiration	Technician Purchase Card Expiration	datetime
TechnicianPCardId	Technician Purchase Card Id	int
TechnicianPCardIssuingBank	Technician Purcahse Card Issuing Bank	nvarchar
TechnicianPCardLast4Digit	Technician Purchase Card Last 4 Digit	nvarchar
TechnicianPCardLastStatementBalance	Technician Purchase Card Last Statement Balance	decimal
TechnicianPCardMonthlyLimit	Technician Purchase Card Monthly Limit	decimal
TechnicianPCardTechnicianCode	Technician Purchase Card Technician Code	nvarchar
TechnicianPCardTechnicianId	Purchase Card Technician Id	int	vrpt_Technician
TechnicianPCardTechnicianName	Technician Purchase Card Technician Name	nvarchar
TechnicianPCardTransactionLimit	Technician Purchase Card Transaction Limit	decimal
TechnicianPCardType	Technician Purchase Card Type	nvarchar
TotalAmount	Total Amount	decimal
UserId	User Id	int	vr_users
UserInitials	User Initials	nvarchar
VendorAddressAddress1	Vendor Address Line 1	nvarchar
VendorAddressAddress2	Vendor Address Line 2	nvarchar
VendorAddressCategory	Vendor Address Category	nvarchar
VendorAddressCity	Vendor City	nvarchar
VendorAddressContact	Vendor Contact	nvarchar
VendorAddressEmail	Vendor Email	nvarchar
VendorAddressFax	Vendor Fax #	nvarchar
VendorAddressId	Vendor Address Id	int	vr_VendorAddress
VendorAddressPhone	Vendor Phone #	nvarchar
VendorAddressPhoneExtension	Vendor Phone # Extension	nvarchar
VendorAddressState	Vendor State	nvarchar
VendorAddressZipCode	Vendor Zip Code	nvarchar
VendorCode	Vendor Code	nvarchar
VendorComment	Vendor Comments	nvarchar
VendorCustomerNumber	Vendor Customer Number	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar

Articles in this section