vrpt_Payment

Updated January 12, 2026 17:12

Field Name	Field Description	Data Type	FK Join
CJProjectNumber	Capital Project Number	datetime
CJProjectTitle	Capital Project Title	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
Id	Payment Id	int
py_amount	Amount	decimal
py_archivepyi_fk	Archive Payment Item Id	int
py_authorizationDate	Authorization Date	datetime
py_cancellationDate	Cancellation Date	datetime
py_cancelledBy_fk	Cancelled By Id	int	vr_users
py_cardExpirationDate	Card Expiration Date	datetime
py_cardHolder	Card Holder	nvarchar
py_cardtype	Card Type	smallint
py_cjProject_fk	Capital Project Id	int
py_createdDate	Record Creation Date	datetime
py_creator_fk	User Id (Record Creator)	int	vr_users
py_cst_fk	Account Id	int	vr_account
py_curr_fk	Currency Id	int	vrpt_Currency
py_datepaid	Date Paid	datetime
py_documentNumber	Document Number	nvarchar
py_dp_fk	Department Id	int	vr_Department
py_exch_date	Currency Exchange Date	datetime
py_exch_fk	Currency Exchange Id	int
py_isAP	Indicates if the payment record is Accounts Payable	bit
py_modifiedDate	Last Modified Date	datetime
py_modifier_fk	User Id (Record Modifier)	int	vr_users
py_number	Payment Number	int
py_paymenttype	Payment Type	smallint
py_pk	Payment Id	int
py_pyi_fk	Payment Item Id	int
py_ven_fk	Vendor Id	int	vr_Vendor
py_wk_fk	Technician Id	int	vrpt_Technician
ven_code	Vendor Code	nvarchar
ven_name	Vendor Name	nvarchar
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar