vr_APInvoice

Updated November 14, 2025 17:40

Field Name	Field Description	Data Type	FK Join
Comment	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Date	Accounts Payable Invoice Date	datetime
Id	Account Payable Invoice Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Account Payable Invoice Number	int
Paid	Paid	bit
PONumber	Purchase Order Number	nvarchar
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
Total	Total	decimal
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
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
VendorUtilityAccountLinkCode	Vendor Account Link Code	nvarchar
VendorUtilityAccountLinkId	Vendor Account Link Id	int
VendorUtilityAccountLinkName	Vendor Account Link Name	nvarchar