Changes to Vista Tables and Columns
The following tables display all Vista tables and columns that were added or deleted for the 2025.6 release.
Deleted Tables and Columns
If you are using these deleted tables in any custom reports or custom coding, you should revise them for this release.
|
Table |
Column |
|---|---|
| vSMCO | UseTaxVariance |
Added Tables and Columns
| Table | Column |
|---|---|
| bAPDB | AuditID |
| FieldName | |
| HostName | |
| KeyString | |
| LogDateTime | |
| NewValue | |
| OldValue | |
| RecType | |
| TableName | |
| UserName | |
| bAPHB | AuditID |
| FieldName | |
| HostName | |
| KeyString | |
| LogDateTime | |
| NewValue | |
| OldValue | |
| RecType | |
| TableName | |
| UserName | |
| bAPPB | AuditID |
| EFTDownloadStatus | |
| FieldName | |
| HostName | |
| KeyString | |
| LogDateTime | |
| NewValue | |
| OldValue | |
| RecType | |
| TableName | |
| UserName | |
| bAPTB | AuditID |
| FieldName | |
| HostName | |
| KeyString | |
| LogDateTime | |
| NewValue | |
| OldValue | |
| RecType | |
| TableName | |
| UserName | |
| bJCCD | LastModifiedTS |
| bPRDL | InclPaybackInAutoAP |
| PreserveZero | |
| bPRDeductionGroup | AddnlAnnualCULimit |
| AddnlAnnualCULimitMaxAge | |
| AddnlAnnualCULimitMinAge | |
| bPREC | SuppEarningsYN |
| bPRFI | SuppTaxRate |
| YTDSuppEarnThreshold | |
| bPRTB | RowVersion |
| bRQRL | BuyerUserKeyID |
| udtExecDashCacheAPAll_TC1 | KeyID |
| udtExecDashCacheAP_TC1 | KeyID |
| udtExecDashCacheAR_TC1 | KeyID |
| udtExecDashCacheJCWIP_TC1 | KeyID |
| udtExecDashCacheJCWIPxtd_TC1 | KeyID |
| udtExecDashCacheLastUpdateCost_TC1 | KeyID |
| udtExecDashCacheLastUpdate_TC1 | ContractJobOrdinal |
| Job | |
| KeyID | |
| LastModified | |
| LastModifiedPCO | |
| RecordLastUpdated | |
| vPREmployeeDailyTime | EMCostCodeKeyID |
| EMWorkOrderItemKeyID | |
| EMWorkOrderKeyID | |
| EquipmentKeyID | |
| MealBreak | |
| vSMWorkCompletedDetail | Assignment |
| Trip |
