Changes to Vista Tables and Columns
The following tables display all Vista tables and columns that were added for the Vista 2023 R2 release.
| Table | Column |
|---|---|
| CDCAuditTable | AuditRecordID |
| TableName | |
| UpdateTable | |
| bEMSIOrphans | ArchiveID |
| CostCode | |
| Description | |
| EMCo | |
| EMGroup | |
| Equipment | |
| EstCost | |
| EstHrs | |
| InOutFlag | |
| LastDoneDate | |
| LastGallons | |
| LastHourMeter | |
| LastOdometer | |
| LastReplacedHourMeter | |
| LastReplacedOdometer | |
| Notes | |
| RepairType | |
| StdMaintGroup | |
| StdMaintItem | |
| bHQBC | InUseWatchDogTime |
| bPRPC | InUseState |
| InUseWatchDogTime | |
| bPRSP | W4_2020VersionSubmittedYN |
| W4_Deductions | |
| W4_DependentAmt | |
| W4_MultiJobsYN | |
| W4_OtherIncome | |
| vEmailDelivery | CreatedBy |
| vPRLedgerUpdateControl | DateValidated |
| KeyHash | |
| VPUserName | |
| vRPFDShared_Data | Custom |
| DefaultType | |
| Form | |
| ParameterDefault | |
| ParameterName | |
| ReportID | |
| Status | |
| UsedForPublish | |
| vRPFRShared_Data | Active |
| Custom | |
| Form | |
| OvrDocumentTitle | |
| ReportID | |
| Status | |
| vRPPLShared_Data | Active |
| Custom | |
| LoadSeq | |
| Lookup | |
| LookupParams | |
| ParameterName | |
| ReportID | |
| Status | |
| vRPRMShared_Data | Active |
| Custom | |
| MenuSeq | |
| Mod | |
| ReportID | |
| Status | |
| vRPRPShared_Data | ActiveLookup |
| Custom | |
| Datatype | |
| DefaultType | |
| Description | |
| DisplaySeq | |
| InputLength | |
| InputMask | |
| InputType | |
| LookupParams | |
| LookupSeq | |
| MultiValue | |
| ParamRequired | |
| ParameterDefault | |
| ParameterName | |
| PortalAccess | |
| PortalParameterDefault | |
| Prec | |
| ReportDatatype | |
| ReportID | |
| Status | |
| vRPRTShared_Data | AppType |
| AvailableToPortal | |
| ChangeNotes | |
| Country | |
| Custom | |
| FileName | |
| IconKey | |
| IsBIReport | |
| IsOfficeLicenseRequired | |
| KeyID | |
| Location | |
| ReportDesc | |
| ReportID | |
| ReportMemo | |
| ReportOwner | |
| ReportType | |
| ShowOnMenu | |
| Status | |
| Title | |
| UniqueAttchID | |
| UserNotes | |
| Version | |
| vRPTYShared_Data | Active |
| Custom | |
| Description | |
| ReportType | |
| Status | |
| VPType | |
| vSMAgreement | SeparateScopePerItem |
| vSMAgreementServiceWorkSchedule | ServiceItem |
| vSMAgreementWorkSchedule | ServiceItem |
| vSMCO | AllCustSiteAttachments |
| vSMInvoiceDetailOrphans | Agreement |
| AgreementBilling | |
| ArchiveID | |
| Invoice | |
| InvoiceDetail | |
| IsRemoved | |
| SMCo | |
| SMInvoiceDetailID | |
| Scope | |
| Service | |
| Version | |
| WorkCompleted | |
| WorkOrder | |
| vSMInvoiceLineOrphans | Amount |
| ArchiveID | |
| BatchLine | |
| Department | |
| Description | |
| DiscountOffered | |
| GLAccount | |
| GLCo | |
| Invoice | |
| InvoiceDetail | |
| InvoiceDetailSeq | |
| InvoiceLine | |
| Invoiced | |
| LastPostedARCo | |
| LastPostedARLine | |
| LastPostedARMth | |
| LastPostedARTrans | |
| NoCharge | |
| SMCo | |
| SMInvoiceLineID | |
| TaxAmount | |
| TaxBasis | |
| TaxCode | |
| TaxDiscount | |
| TaxGroup | |
| vSMServiceItems | QRCodeID |
| vSMWorkCompletedDetailOrphans | Agreement |
| ArchiveID | |
| CostAccount | |
| CostWIPAccount | |
| Coverage | |
| Date | |
| EntitySeq | |
| GLCo | |
| IsSession | |
| JCCostType | |
| NoCharge | |
| Notes | |
| PhaseGroup | |
| PriceRate | |
| PriceTotal | |
| RevenueAccount | |
| RevenueWIPAccount | |
| Revision | |
| SMCo | |
| SMCostType | |
| SMWorkCompletedDetailID | |
| SMWorkCompletedID | |
| Scope | |
| ServiceItem | |
| ServiceSite | |
| Task | |
| TaxAmount | |
| TaxBasis | |
| TaxCode | |
| TaxGroup | |
| TaxType | |
| Technician | |
| UseAgreementRates | |
| WorkCompleted | |
| WorkOrder | |
| vSMWorkCompletedOrphans | APCo |
| APInUseBatchId | |
| APInUseMth | |
| APTLKeyID | |
| ARTLKeyID | |
| ArchiveID | |
| AutoAdded | |
| CostCo | |
| CostDetailID | |
| CostMth | |
| CostTrans | |
| CostsCaptured | |
| DestJCCType | |
| DestSMCo | |
| DestWorkCompleted | |
| DestWorkOrder | |
| HasAdjustment | |
| InitialCostsCaptured | |
| IsCostAdjustment | |
| IsDeleted | |
| IsFromAdjustment | |
| JCCo | |
| JCCostEntryID | |
| JCCostTaxTrans | |
| JCCostTrans | |
| JCMth | |
| NonBillable | |
| OrigWorkCompleted | |
| PREmployee | |
| PREndDate | |
| PRGroup | |
| PRLedgerUpdateMonthID | |
| PRPaySeq | |
| PRPostDate | |
| PRPostSeq | |
| Provisional | |
| ReadyToBill | |
| ReferenceNo | |
| RevenueGLEntryID | |
| RevenueJCWIPGLEntryID | |
| RevenueSMWIPGLEntryID | |
| SMCo | |
| SMWorkCompletedID | |
| SrcSMCo | |
| SrcWorkCompleted | |
| SrcWorkOrder | |
| Type | |
| UniqueAttchID | |
| WorkCompleted | |
| WorkOrder |
