Getting Started # The list below contains all tables available for download in TAD . Selecting a table displays its properties , which provide important details such as security access, key columns, and update capabilities .
Available Tables # Select a Table JCContractLastMthActivity - JC Contract Last Mth Activity PREDLCodesByType - PR EDLCodes Combined SMWorkOrderStatus - SM Work Order Status bAPAA - AP Vendors -- Additional Addresses bAPCD - AP Clear GL Distributions bAPCO - AP Company Parameters bAPCT - AP Clear Transactions bAPDB - AP Payment Posting Transaction Lines bAPEM - AP Equipment Distributions bAPFT - AP 1099 Totals bAPGL - AP GL Expense Distributions bAPHB - AP Transaction Entry Header bAPHD - AP Transaction Hold Detail bAPHR - AP Hold-Release to be Released bAPIN - AP Inventory Distributions bAPJC - AP Job Cost Distributions bAPLB - AP Transaction Entry Detail bAPPB - AP Payment Posting Header bAPPC - AP Pay Category bAPPD - AP Payment History Detail bAPPG - AP Payment Posting GL Distribution bAPPH - AP Payment History Header bAPPT - AP Payable Types bAPRH - AP Recurring Invoices Header bAPRL - AP Recurring Invoices Items bAPT5 - AP T5018 Report Dates bAPTB - AP Payment Posting Transactions bAPTD - AP Transaction Detail bAPTH - AP Transaction Header bAPTL - AP Transaction Line bAPTT - AP 1099 Types bAPUI - AP Unapproved Invoice Entry bAPUL - AP Unapproved Invoice Items bAPUR - AP Unapproved Invoice Reviewers bAPVA - AP Vendor Activity bAPVC - AP Vendor Compliance bAPVH - AP Vendor Hold Codes bAPVM - AP Vendors bAPWD - AP Payment Workfile Detail bAPWH - AP Payment Workfile Header bARAA - AR Cash Receipts Auto Applied bARBA - AR Transactions GL Distribution bARBC - AR CM Distribution Batch bARBE - AR Misc Receipts Equipment Distributions bARBH - AR Invoice Entry Header bARBI - AR Invoice Entry Contract Distribution bARBJ - AR Misc Receipts Job Distributions bARBL - AR Invoice Entry Detail bARBM - AR Cash Receipts Misc Distributions bARCM - AR Customers bARCN - AR Credit Notes bARCO - AR Company Parameters bARMC - AR Misc Distribution Codes bARMD - AR Miscellaneous Distributions Detail bARMT - AR Customer Monthly Totals bARRT - AR Receivable Types bARTH - AR Transaction Header bARTL - AR Transaction Lines bCMAC - CM Accounts bCMCE - CM Cleared Entries bCMCO - CM Company Parameters bCMDA - CM Detail GL Distribution bCMDB - CM Outstanding Entries bCMDT - CM Detail Transactions bCMST - CM Statement Control bCMTA - CM Transfers GL Distribution bCMTB - CM Transfers bCMTT - CM Transfer Transactions bEMAD - EM Allocation Codes -- Departments bEMAE - EM Allocation Codes -- Equipment bEMAG - EM Allocation Codes -- Categories bEMAH - EM Allocation Codes bEMAR - EM Monthly Revenue bEMAT - EM Allocation Codes -- Cost Types bEMAV - EM Allocation Codes -- Revenue Codes bEMBC - EM Batch Rev Breakdown Distribution bEMBE - EM Revenue Rates by Equipment -- Rev Breakdown bEMBF - EM Posting Batches bEMBG - EM Revenue Rates by Category -- Rev Breakdown bEMCC - EM Cost Codes bEMCD - EM Cost Detail bEMCH - EM Cost Header bEMCM - EM Categories bEMCO - EM Company Parameters bEMCT - EM Cost Types bEMCX - EM Cost Codes -- Cost Types bEMDB - EM Departments -- Rev Breakdown Codes bEMDE - EM Departments -- Earnings Types bEMDG - EM Departments -- Cost Types bEMDL - EM Departments -- Liability Type bEMDM - EM Departments bEMDO - EM Departments -- Cost Codes bEMDP - EM Asset Setup bEMDR - EM Departments -- Revenue Codes bEMDS - EM Asset Setup -- Depreciation Schedule bEMED - EM Equip Code Change Detail bEMEH - EM Equip Code Change Header bEMEM - EM Equipment bEMEP - EM Equipment Parts bEMGL - EM Batch GL Distribution bEMHC - EM Component Transfers bEMIN - EM Batch Inventory Distributions bEMJC - EM Batch Job Cost Distributions bEMJT - EM Job Templates bEMLH - EM Location History bEMLM - EM Locations bEMMC - EM Monthly Costs bEMMH - EM Miles By State Batch Header bEMML - EM Miles By State Batch Detail bEMMR - EM Meter Readings bEMPB - EM Company Parameters -- Labor bEMPS - EM Work Order Parts Status bEMRB - EM Revenue Breakdown Detail bEMRC - EM Revenue Codes bEMRD - EM Revenue Detail bEMRH - EM Revenue Rates by Equipment bEMRR - EM Revenue Rates by Category bEMRT - EM Revenue Breakdown Codes bEMRX - EM Work Order Repair Types bEMSD - EM Miles By State Posted Detail bEMSH - EM Standard Maintenance Groups Header bEMSI - EM Standard Maintenance Groups Items bEMSL - EM Standard Maintenance Groups -- Linked Groups bEMSM - EM Miles By State Posted Header bEMSP - EM Standard Maintenance Groups Items -- Parts bEMSX - EM Shops bEMTC - EM Revenue Template Category Rates bEMTD - EM Revenue Template Category Breakdown bEMTE - EM Revenue Template Equipment Rates bEMTF - EM Revenue Template Equipment Breakdown bEMTH - EM Revenue Template bEMTY - EM Component Types bEMUC - EM Auto Usage Posting Template -- Category bEMUD - EM Usage Rules Table Detail bEMUE - EM Auto Usage Posting Template -- Equipment bEMUH - EM Auto Usage Posting Template bEMUR - EM Usage Rules Table bEMWF - EM Warranties bEMWH - EM Work Order Edit Header bEMWI - EM Work Order Edit Items bEMWP - EM Work Order Edit Items -- Parts bEMWS - EM Work Order Status Codes bGLAC - GL Chart of Accounts bGLAJ - GL Auto Journal Entry Setup bGLAS - GL Account Summary Balances bGLBC - GL Budget Codes bGLBD - GL Budgets -- Monthly Budgets bGLBL - GL Monthly Balances bGLBR - GL Budgets bGLCO - GL Company Parameters bGLDA - GL Journal Transaction Entry GL Batch Distribution bGLDB - GL Journal Transaction Entry bGLDT - GL Detail bGLFP - GL Fiscal Periods bGLFY - GL Fiscal Years bGLIA - GL Intercompany Accounts bGLJA - GL Auto Journal Audit bGLJB - GL Auto Journal Batch bGLJR - GL Journals bGLPD - GL Account Parts bGLPI - GL Account Parts -- Instances bGLRA - GL Auto Reversal Entry GL Batch Distribution bGLRB - GL Auto Reversal Entry bGLRF - GL Journal References bGLYB - GL Beginning Balances bHQAD - DM Attachment Cross Reference Columns bHQAF - HQ Attachment Types bHQAI - DM Attachment Index Search bHQAO - HQ Attachment Options bHQAT - HQ Attachments bHQAX - DM Attachment Cross Reference Header bHQBC - HQ Batch Control bHQBE - HQ Batch Errors bHQCC - HQ Batch Close Control bHQCG - HQ Compliance Groups bHQCO - HQ Company Setup bHQCP - HQ Compliance Codes bHQCX - HQ Compliance Groups -- Compliance Codes bHQCountry - HQ Countries bHQDR - DM Document Review bHQDS - DM Document Routing Status bHQDX - VA Document Export bHQET - HQ Earn Types bHQFC - HQ Frequency Codes bHQGP - HQ Groups bHQHC - HQ Hold Codes bHQIC - HQ Insurance Codes bHQLT - HQ Liability Types bHQMA - HQ Audit Detail bHQMC - HQ Material Categories bHQMT - HQ Materials bHQMU - HQ Materials -- Units of Measure bHQNT - HQ Standard Note bHQPD - HQ Escalation Index -- Monthly Index bHQPM - HQ Escalation Index -- Material bHQPO - HQ Escalation Index bHQPT - HQ Payment Terms bHQRC - HQ Reason Codes bHQRP - HQ Reviewers -- User Names bHQRS - HQ States -- Reciprocal States bHQRV - HQ Reviewers bHQSM - HQ SMSA Codes bHQST - HQ States bHQTC - HQ Transaction Control bHQTL - HQ Tax Codes -- Single Level Members bHQTX - HQ Tax Codes bHQUM - HQ Units of Measure bHQWD - PM Create & Send Templates bHQWF - PM Create & Send Templates -- Merge Fields bHQWL - PM Create & Send Locations bHQWO - PM Create & Send Data Sources bHQWT - PM Create & Send Template Document Types bHRAC - HR Accidents -- Claims bHRAD - HR Accidents -- Body Parts bHRAG - HR Approval Groups bHRAI - HR Accidents Details bHRAL - HR Accidents - Restricted/Lost Days bHRAP - HR Applicant Position bHRAR - HR Applicant References bHRAT - HR Accidents Header bHRAW - HR Accidents -- Witness bHRBB - HR Benefit Batch Header bHRBC - HR Benefit Codes bHRBD - HR Benefit Batch Detail bHRBE - HR Resource Benefits -- Earnings bHRBG - HR Benefit Groups bHRBI - HR Benefit Codes -- Earnings/Dedn/Liabs bHRBL - HR Resource Benefits -- Dedn/Liabs bHRCA - HR Company Assets bHRCC - HR Accident Claim Contacts bHRCL - HR Accidents -- Contacts Log bHRCM - HR Codes bHRCO - HR Company Parameters bHRCT - HR Code Types bHRDL - HR Resource License Endorsements bHRDP - HR Resource Dependents bHRDT - HR Resource Drug Testing bHREB - HR Resource Benefits bHREC - HR Resource Contact bHRED - HR Resource Discipline bHREG - HR Resource Grievances bHREH - HR Resource Employment History bHREI - HR Applicant Interview bHRER - HR Resource Review bHRES - HR Resource Schedule bHRET - HR Resource Training bHRGI - HR Benefit Groups -- Benefit Codes bHRHI - HR Hospital Information bHRHP - HR PR Employee Update Workfile bHRMN - HR Mine bHRPC - HR Position Codes bHRPQ - HR Position Codes -- Qualifications bHRPR - HR Position Codes -- Performance Ratings bHRPT - HR Position Codes -- Training bHRRC - HR Resource COBRA bHRRD - HR Resource Rewards bHRRE - HR License Endorsements bHRRG - HR Ratings Group bHRRI - HR Ratings Group -- Rating Group Codes bHRRM - HR Resources bHRRP - HR Resource Review -- Performance Ratings bHRRS - HR Resource Skills bHRSH - HR Resource Salary History bHRSP - HR Resource Salary History -- Salary Reasons bHRST - HR Employment Status bHRTA - HR Asset In/Out by Resource bHRTC - HR Training Classes bHRTS - HR Training Classes -- Skills bHRWI - HR Resource Filing Status bIMTD - IM Template -- Template Detail bIMTH - IM Template bIMTR - IM Template -- Record Types bIMWE - IM Work Edit Detail bIMWENotes - IM Work Edit Notes bIMWH - IM Work Edit Header bIMWM - IM Work Edit Errors bIMXD - IM Cross Reference -- Cross Reference Values bIMXF - IM Cross Reference -- Source Identifiers bIMXH - IM Cross Reference bINAB - IN Adjustment Entry bINAG - IN Adjustment Entry GL Distribution bINBH - IN Bill of Materials bINBL - IN Bill of Materials Override bINBM - IN Bill of Materials -- Components bINBO - IN Bill of Materials Override -- Components bINCB - IN Material Order Confirmation bINCG - IN MO Confirmation GL Distribution bINCJ - IN MO Confirmation JC Distribution bINCO - IN Company Parameters bINCW - IN Physical Count Worksheet bINDT - IN Inventory Detail bINIB - IN Material Order Entry Items bINJC - IN MO Job Cost Distribution bINLC - IN Location Company and Category Override bINLG - IN Location Groups bINLM - IN Locations bINLO - IN Location Category Override bINLS - IN Location Company Override bINMA - IN Monthly Activity bINMB - IN Material Order Entry Header bINMI - IN Material Order Posted Items bINMO - IN Material Order Posted Header bINMT - IN Location Materials bINMU - IN Location Materials -- Addl Ums bINPB - IN Production Entry Header bINPD - IN Production Entry Detail bINPG - IN Production GL Distribution bINRI - IN Reconciliation In bINRO - IN Reconciliation Out bINTB - IN Transfer Entry bINTG - IN Transfer GL Distribution bINXB - IN Material Order Close Batch bINXI - IN MO Close Inventory Distribution bINXJ - IN MO Close Job Cost Distribution bJBAL - JB Interface Details bJBAR - JB Interface Header bJBBE - JB T&M Bill Errors bJBBG - JB Bill Groups bJBBM - JB Misc Distribution Distribution bJBCC - JB Change Order Header bJBCE - JB Contract Billing Errors bJBCO - JB Company Parameters bJBCX - JB Change Order Detail bJBER - JB T&M Template Equipment Rate bJBGC - JB Processing Group -- Contract/Customer bJBGL - JB GL Distributions bJBID - JB T&M Bill Line Sequences bJBIJ - JB T&M Job Cost Transactions bJBIL - JB T&M Bill Lines bJBIN - JB Progress Billing Header bJBIS - JB Billing Items and Change Orders bJBIT - JB Progress Billing Items bJBJC - JB Job Cost Distributions bJBJE - JB T&M Transaction Errors bJBLC - JB T&M Labor Categories bJBLO - JB T&M Template Labor Override bJBLR - JB T&M Template Labor Rates bJBLX - JB T&M Labor Categories -- Assignments bJBMD - JB Miscellaneous Distributions bJBMO - JB T&M Template Material Rates bJBPG - JB Processing Group bJBTA - JB T&M Template Setup Detail -- Addons bJBTC - JB T&M Template Setup Detail -- Cost Types bJBTM - JB T&M Template Setup Header bJBTS - JB T&M Template Setup Detail bJCAC - JC Allocation Codes bJCAD - JC Allocation Codes -- Departments bJCAJ - JC Allocation Codes -- Jobs bJCAT - JC Allocation Codes -- Cost Types bJCCB - JC Cost Adjustments bJCCC - JC Contract Close Batch Table bJCCD - JC Cost Detail bJCCH - JC Original Estimates bJCCI - JC Contract Items bJCCM - JC Contracts bJCCO - JC Company Parameters bJCCP - JC Cost By Mth bJCCT - JC Cost Types bJCDA - JC Cost Adjustment GL Distribution bJCDC - JC Departments -- Cost Types bJCDE - JC Departments -- Earnings Types bJCDL - JC Departments -- Liability Types bJCDM - JC Departments bJCDO - JC Departments -- Phase Override bJCHC - JC History by Contract bJCHJ - JC History by Job bJCIA - JC Revenue Adjustment GL Distribution bJCIB - JC Revenue Adjustments bJCID - JC Contract Item Detail bJCIN - JC Inventory Dist Batch bJCIP - JC Revenue By Mth bJCIR - JC Revenue Projections bJCJM - JC Jobs bJCJP - JC Job Phases bJCJR - JC Job Reviewers bJCMC - JC Metric Conversions bJCMP - JC Project Managers bJCOD - JC Change Order Detail bJCOH - JC Change Orders Header bJCOI - JC Change Orders Items bJCOP - JC Override Projections -- Cost bJCOR - JC Override Projections -- Revenue bJCPB - JC Cost Projections Header bJCPC - JC Phases -- Cost Types bJCPD - JC Cost Projections Detail bJCPM - JC Phases bJCPP - JC Progress Entry bJCPPCostTypes - JC Progress Entry Cost Types bJCPPPhases - JC Progress Entry Phases bJCPR - JC Cost Projections Res Detail bJCRD - JC Fixed Rate Template -- Template Detail bJCRT - JC Fixed Rate Template bJCRU - JC Detail Roll-up Codes bJCSI - JC Standard Item Codes bJCTE - JC Liability Template -- Basis Earnings Codes bJCTH - JC Liability Template bJCTI - JC Insurance Template -- Phases bJCTL - JC Liability Template -- Liability Types bJCTN - JC Insurance Template bJCUO - JC User Options bJCXA - JC Contract Close GL Distribution bJCXB - JC Contract Close bMSAP - MS AP Invoice Lines bMSAR - MS Invoice AR Distribution bMSCO - MS Company Parameters bMSDD - MS Discount Template Detail bMSDH - MS Discount Template Header bMSDX - MS Quotes -- Discount Overrides bMSEM - MS Ticket Entry EM Distribution bMSGL - MS Ticket Entry GL Distribution bMSHB - MS Hauler Time Sheet Entry Header bMSHC - MS Haul Codes bMSHH - MS Hauler Time Sheet Posted bMSHO - MS Quotes -- Haul Overrides bMSHR - MS Haul Codes -- Rates bMSHX - MS Quotes -- Haul Code Defaults bMSIB - MS Invoice Edit Header bMSID - MS Invoice Edit Detail bMSIG - MS Invoice GL Distribution bMSIH - MS Invoice Posted Header bMSII - MS Intercompany Invoice Header bMSIL - MS Invoice Posted Lines bMSIN - MS Ticket Entry IN Distribution bMSIX - MS Intercompany Invoice Detail bMSJC - MS Ticket Entry JC Distribution bMSJP - MS Quotes -- Job Phases bMSLB - MS Hauler Time Sheet Entry Detail bMSMA - MS Material Payment Vendor Detail bMSMD - MS Quotes -- Price Overrides bMSMG - MS Material Payment Worksheet GL Distribution bMSMH - MS Material Payment Worksheet Header bMSMT - MS Material Payment Worksheet Detail bMSMX - MS Invoice Misc Distribution bMSPA - MS Ticket Entry IN Production Distribution bMSPC - MS Pay Codes bMSPR - MS Pay Codes -- Rates bMSPX - MS Quotes -- Pay Codes bMSQD - MS Quotes -- Quote Detail bMSQH - MS Quotes bMSRB - MS Hauler Time Sheet Entry EM Rev Bkdn Distribution bMSSA - MS Sales Activity bMSSurchargeCodeRates - MS Surcharge Code Rates bMSSurchargeCodes - MS Surcharge Codes bMSSurchargeGroupCodes - MS Surcharge Group Codes bMSSurchargeGroups - MS Surcharge Groups bMSSurchargeOverrides - MS Surcharge Overrides bMSSurcharges - MS Surcharges bMSTB - MS Ticket Entry bMSTD - MS Ticket Detail bMSTH - MS Price Templates bMSTP - MS Price Templates -- Rates bMSTT - MS Truck Types bMSTX - MS Deleted Tickets bMSVT - MS Vendor Trucks bMSWD - MS Haul Payment Worksheet Detail bMSWG - MS Haul Payment Worksheet GL Distribution bMSWH - MS Haul Payment Worksheet Header bMSZD - MS Quotes -- Haul Zones bPMBC - PM Subcontract Batch bPMBE - PM Interface Errors bPMCA - PM Company Parameters -- Add-Ons bPMCD - PM Change Order Distribution bPMCO - PM Company Parameters bPMCT - PM Document Categories bPMCU - PM Create & Send Settings bPMDC - PM Daily Log Distribution bPMDD - PM Daily Logs Detail bPMDG - PM Drawing Logs Header bPMDH - PM Document History bPMDL - PM Daily Logs Header bPMDR - PM Drawing Logs Revisions bPMDT - PM Document Types bPMDZ - PM Create and Send Dist bPMEC - PM Billing and Cost Rate IDs bPMED - PM Project Budget Detail bPMEH - PM Project Budget Header bPMFM - PM Firms bPMFT - PM Firm Types bPMHA - PM Document History Audit bPMHF - PM Document Hist Attachments bPMHI - PM Document Audit Information bPMIH - PM Issues -- Issue Log Entry bPMIL - PM Inspection Logs bPMIM - PM Issues bPMMD - PM Meeting Minutes -- Attendees bPMMF - PM Material Detail bPMMI - PM Meeting Minutes Items bPMML - PM Meeting Minutes Items -- Lines bPMMM - PM Meeting Minutes Header bPMNR - PM Notes Review bPMOA - PM Change Order Addons bPMOB - PM PCO Cost Addon Distribution bPMOC - PM Other Documents -- Distribution bPMOD - PM Other Documents bPMOH - PM Approved Change Orders Header bPMOI - PM Approved Change Orders Items bPMOL - PM Approved Change Orders Items -- Estimate Detail bPMOM - PM Pending Change Orders -- Markups bPMOP - PM Pending Change Orders Header bPMPA - PM Projects -- Add-Ons bPMPC - PM Projects -- Markups bPMPD - PM Punch Lists Items -- Lines bPMPF - PM Project Firms bPMPI - PM Punch Lists Items bPMPL - PM Project Locations bPMPM - PM Firm Contacts bPMPN - PM Notes bPMPS - PM Phase Submittals - 6.5 bPMPU - PM Punch Lists Header bPMQD - PM Request For Quote -- Distribution bPMRD - PM Request for Information -- Distribution bPMRI - PM Request for Information bPMRQ - PM Request For Quote - 6.6 bPMSC - PM Status IDs bPMSI - PM Submittal Items - 6.5 bPMSL - PM Subcontract Detail bPMSM - PM Submittals - 6.5 bPMSS - PM Subcontract Send To Info bPMTC - PM Transmittal Copies bPMTD - PM Template Cost Types bPMTH - PM Template Phases Header bPMTL - PM Test Logs bPMTM - PM Transmittals bPMTP - PM Template Phases Detail bPMTS - PM Transmittals -- Documents bPMUC - PM Import Estimates Template -- Create Cost Types bPMUD - PM Import Template Detail bPMUI - PM Import Routines bPMUR - PM Import Estimates Template Detail bPMUT - PM Import Estimates Template bPMUX - PM Import Estimates Template -- Cross Refs bPMVC - PM Document Tracking Grid Cols bPMVG - PM Document Tracking Grids bPMVM - PM Document Tracking Views bPMWD - PM Import Estimates Work Table -- Cost Types bPMWH - PM Import Estimates Work Table Header bPMWI - PM Import Estimates Work Table -- Items bPMWM - PM Import Estimates Work Table -- Materials bPMWP - PM Import Estimates Work Table -- Phases bPMWS - PM Import Estimates Work Table -- Subcontracts bPMWX - PM Import Data bPOCA - PO CO Job Cost Distribution bPOCB - PO Change Order Entry bPOCD - PO Change Order Posted Detail bPOCI - PO CO Inventory Distribution bPOCO - PO Company Parameters bPOCT - PO Compliance bPOHB - PO Purchase Order Entry Header bPOHD - PO Purchase Order Header bPOIA - PO Purchase Order JC Distribution Batch bPOIB - PO Purchase Order Entry Detail bPOII - PO Purchase Order IN Distribution Batch bPOIT - PO Purchase Order Items bPOJC - PO Category Discount -- Job Discounts bPOJM - PO Vendor Materials -- Overrides by Job bPORA - PO Receipts JC Distribution Batch bPORB - PO Receipts Entry bPORD - PO Receiving Detail bPORE - PO Receipts EM Distribution Batch bPORG - PO Receipts GL Distribution Batch bPORH - PO Receipt Expense Initialize Header bPORI - PO Receipts IN Distribution Batch bPORJ - PO Receipts AP JC Distribution Batch bPORN - PO Receipts AP IN Distribution Batch bPORS - PO Receipt Expense Initialize Detail bPOSL - PO Shipping Locations bPOSM - PO Vendor Materials -- Substitute Materials bPOVC - PO Category Discount bPOVM - PO Vendor Materials bPOXA - PO Close JC Distribution Batch bPOXB - PO Close Batch bPOXI - PO Close IN Distribution Batch bPRAB - PR Leave Entry bPRAE - PR Automatic Earnings bPRAF - PR Pay Period Control -- Active Frequency Codes bPRAP - PR AP Update bPRAU - PR Leave Codes -- Accrual/Usage Info bPRCA - PR Craft Accumulations bPRCACodes - PR Canada T4 Codes bPRCAEmployeeCodes - PR Canada Employee Codes bPRCAEmployeeItems - PR Canada Employee Items bPRCAEmployeeProvince - PR Canada Employee Province bPRCAEmployees - PR Employee T4 Slips bPRCAEmployer - PR Canada T4 bPRCAEmployerCodes - PR Canada T4 -- T4 Other Codes bPRCAEmployerItems - PR Canada T4 -- T4 Box Items bPRCAItems - PR Canada T4 Items bPRCB - PR Crafts -- Capped Basis bPRCC - PR Craft Classes bPRCD - PR Craft Classes -- Dedn/Liab bPRCE - PR Craft Classes -- Variable Earnings bPRCF - PR Craft Classes -- Add-on Earnings bPRCH - PR Crafts -- Holidays bPRCI - PR Crafts -- Earn/Dedn/Liab bPRCM - PR Crafts bPRCO - PR Company Parameters bPRCP - PR Craft Classes -- Pay Rates bPRCR - PR Crews bPRCS - PR Crafts -- Capped Codes bPRCT - PR Craft Templates bPRCW - PR Crews -- Crew Members bPRCX - PR Craft Accum Rate Detail bPRDB - PR Deductions/Liabilities -- Basis Codes bPRDD - PR Employees -- Add'l Direct Deposits bPRDE - PR Departments -- Earnings Types bPRDG - PR Departments -- Liability Types bPRDH - PR EFT Deposit History bPRDL - PR Deductions/Liabilities bPRDP - PR Departments bPRDS - PR Employee Pay Seq Control -- Direct Deposit bPRDT - PR Employee Pay Seq Control -- Earn/Dedn/Liab bPRDeductionGroup - PR Pre-Tax Deduction Groups bPREA - PR Employee Accumulations bPREC - PR Earnings Codes bPRED - PR Employee Dedns / Liabs bPREH - PR Employees bPREL - PR Employee Leave bPREM - PR Ledger Update EM Cost Distribution bPRER - PR Ledger Update EM Revenue Distribution bPRES - PR Earning Codes -- Subject Earnings bPRFD - PR Federal Information -- Add'l Federal Dedn/Liab bPRFI - PR Federal Information bPRGB - PR Groups -- Liabilities bPRGG - PR Garnishment Groups bPRGI - PR Garnishment Groups -- Dedn/Earn bPRGL - PR Ledger Update GL Distribution bPRGR - PR Groups bPRGS - PR Groups -- Group Security bPRGV - PR Groups -- Leave Codes bPRHD - PR Pay Period Control -- Holidays bPRIA - PR Insurance Accumulations bPRID - PR State Insurance Codes -- Dedn/Liab bPRIN - PR State Insurance Codes bPRJC - PR Ledger Update JC Distribution bPRLB - PR Employee Leave -- Accrual/Usage Overrides bPRLD - PR Local Information -- Add'l Local Dedn/Liab bPRLH - PR Leave History bPRLI - PR Local Codes bPRLL - PR Leave Levels bPRLV - PR Leave Codes bPRLVEarnLeave - PR Leave Codes -- Leave Level Overrides bPRMyTimesheet - PR My Timesheet bPRMyTimesheetDetail - PR My Timesheet Detail bPROP - PR Occupational Categories bPROS - PR Overtime Schedule -- Shift Overrides bPROT - PR Overtime Schedule bPRPC - PR Pay Period Control bPRPH - PR Payment History bPRPS - PR Pay Period Control -- Payment Sequence bPRRB - PR Ledger Update EM Revenue Breakdown Distribution bPRRC - PR Race Codes bPRRE - PR Crew Timesheet Entry -- Employee Hours bPRRH - PR Crew Timesheet Entry bPRRM - PR Routines bPRRN - PR Crew Timesheet Entry -- Non-Job Earnings bPRRO - PR Crew Timesheet Entry -- Other Job Earnings bPRRQ - PR Crew Timesheet Entry -- Equipment Usage bPRSD - PR State Information -- Add'l State Dedn/Liab bPRSI - PR State Information bPRSP - PR Check/EFT Stub Header bPRSQ - PR Employee Pay Seq Control bPRSX - PR Check/EFT Stub Detail bPRTA - PR Posted Timecards -- Addons bPRTB - PR Timecard Entry bPRTC - PR Craft Class Templates bPRTD - PR Craft Class Templates -- Dedn/Liab bPRTE - PR Craft Class Templates -- Variable Earnings bPRTF - PR Craft Class Templates -- Add-on Earnings bPRTH - PR Posted Timecards bPRTI - PR Craft Templates -- Earn/Dedn/Liab bPRTL - PR Posted Timecards -- Liabilities bPRTM - PR Templates bPRTP - PR Craft Class Templates -- Pay Rates bPRTR - PR Craft Templates -- Job Craft Items bPRTS - PR Timesheet Send Progress bPRTT - PR Timesheet Send Batches bPRUE - PR Unemployment Process -- Employees bPRUH - PR Unemployment Process bPRUP - PR Time Card Entry -- Customize Grids bPRUR - PR Update Errors bPRVP - PR Void Payments bPRW2MiscDetail - PR W2 Process -- Employees -- State Box 14 bPRW2MiscHeader - PR W2 Process -- State Box 14 Information bPRWA - PR W2 Process -- Employees -- Federal bPRWC - PR W2 Process -- Federal Information bPRWE - PR W-2 Process -- Employees bPRWH - PR W-2 Process bPRWI - PR W2 Report Items bPRWL - PR W2 Process -- Employees -- Local bPRWS - PR W2 Process -- Employees -- State bPRWT - PR W-2 Process -- State/Local Information bSLAD - SL Add-Ons bSLCA - SL Change Order Job Cost Distribution bSLCB - SL Change Order Entry bSLCD - SL Change Order Posted Detail bSLCO - SL Company Parameters bSLCT - SL Compliance bSLHB - SL Subcontract Entry Header bSLHD - SL Subcontract Header bSLIA - SL Subcontract Job Cost Distribution bSLIB - SL Subcontract Entry Detail bSLIT - SL Subcontract Items bSLWH - SL Worksheet Header bSLWI - SL Worksheet Items bSLXA - SL Close Job Cost Distribution bSLXB - SL Close bUDTC - UD User Table and Form Setup Columns bUDTH - UD User Table and Form Setup Header bUDTM - UD User Table and Form Setup -- Modules bUDVD - UD User Validation -- Parameters bUDVH - UD User Validation bUDVT - UD User Validation -- Tables bbudTADTables - TAD Setups - Tables bbudTADTablesecurity - TAD Admin - Table Security brvAROpenTrans - AR Open Transactions brvJCCDDetlDesc - JC Detail Long Descr brvJCContStat - JC Contract Status Data brvJCContrMinJob - JC Contract Minimum Job brvPRLiabilities - PR Liabilities brvPRMissingTimecards - PR Missing Timecards brvPRRecon - PR Pay Period Cost budPRGroupAccess - UD PR Group Access budTADColDefinitions - TAD Setups - Financial Columns budTADLicenses - TAD Admin - Licenses budTADLog - TAD Admin - Log budTADReportSecurity - TAD Admin - Report Security budTADReports - TAD Setups - Reports budTADRowDefinitions - TAD Setups - Financial Rows budTADSandbox - TAD Sandbox budTADTableColumns - TAD Setups - Table Columns budTADTableJoins - TAD Setups - Table Joins budTADTemplates - TAD Setups - Templates budTADTmplateSecurity - TAD Admin - Template Security budTADVersion - TAD Admin - Version vAPAUPayeeTaxPaymentATO - AP AU ATO Payee Tax Payment vAPAUPayerTaxPaymentATO - AP AU ATO Payer Tax Payment vAPOnCostGroupTypes - AP On-Cost Group Types vAPOnCostGroups - AP Vendors -- On-Cost Groups vAPOnCostType - AP On-Cost Types vAPOnCostWorkFileDetail - AP On-Cost WorkFile Detail vAPOnCostWorkFileHeader - AP On-Cost Workfile vAPReleaseRetention - AP Release Retention vAPSM - AP SM Distributions vAPT5018Payment - AP T5018 Payments Header vAPT5018PaymentDetail - AP T5018 Payments Detail vAPVendorMasterOnCost - AP Vendors -- On-Cost vARStatementDeliveryRecipients - AR Customers Statement Recipients vDDCBc - VA Custom Field Combo Boxes vDDCIc - VA Custom Field Combo Boxes -- Items vDDDS - VA Data Type Security Access vDDDTc - DD Datatype Override vDDFHc - VA Form Header vDDFIc - VA Form Input Overrides vDDFLc - VA Form Field Lookups vDDFS - VA Form Security vDDFTc - VA Custom Form Tabs vDDFormButtonParametersCustom - VA Custom Form Buttons -- Parameters vDDFormButtonsCustom - VA Custom Form Buttons vDDGBc - VA Custom Group Boxes vDDLDc - UD User Defined Lookups -- Details/Columns vDDLHc - UD User Defined Lookups vDDRelatedFormsCustom - VA Custom Form Tabs -- Grid Links vDDSG - VA Security Groups vDDSU - VA Security Groups -- Users vDDTFc - VA Menu Templates Custom vDDUP - VA User Profile vEMDepartmentApprovalProcess - EM Departments -- Workflow vEMDepartmentRole - EM Departments -- Roles vEMLocationHistory - EM Location Transfer vEMLocationHistoryAttach - EM Location Transfer -- Attachments vGLMajorCategory - GL Report Categories vGLMinorCategory - GL Report Categories -- Minor Category vHQAUSuperClearingHouse - HQ Super Clearing House vHQAUSuperSchemes - HQ Super Funds vHQBASReasonCodes - AUS BAS Reason Codes vHQCompanyProcess - HQ Company Process vHQContact - HQ Contacts vHQDocTemplateResponseField - PM Create & Send Templates -- Response Fields vHQProjectStatusCodes - HQ Project Status Codes vHQRD - HQ Reviewer Group -- Reviewers vHQRG - HQ Reviewer Group vHQResponseValue - HQ Response Value vHQResponseValueItem - HQ Response Value Item vHQRoleLimit - HQ Roles -- Spending Limits vHQRoleMember - HQ Roles -- Users vHQRoleMemberOverride - HQ Roles -- User Overrides vHQRoles - HQ Roles vHRBenefitCodeOption - HR Benefit Codes -- Benefit Code Options vHRHiringLocation - HR Hiring Location Setup vHRLookBackGroup - HR ACA Look Back Group vHRLookBackPeriod - HR ACA Look Back Group -- Look Back Period vHRResBenACACoverageHist - HR Resources ACA Coverage Hist vHRResourceMasterACAHistory - HR Resources -- ACA History vIMAutoImportProfiles - IM Auto Import Profile Setup vIMAutoImportQueue - IM Auto Import Queue vIMNotifications - IM Template -- Notifications vINLocationApprovalProcess - IN Locations -- Workflow vINLocationRole - IN Locations -- Roles vJBRecipients - JB Recipients vJBReviewers - JB Reviewers vJCCMPO - JC Contracts Purchase Order vJCCostProjection - PM Cost Projections vJCCostProjectionColumnOption - PM Cost Projections Layouts -- Column Options vJCCostProjectionColumnOptionDetail - PM Cost Projections Layouts -- Column Option Detail vJCCostProjectionDetail - PM Cost Projections -- Detail vJCCostProjectionInUseBy - PM Cost Projections -- In Use By vJCCostProjectionOptionCostType - PM Cost Projections Options -- Cost Type vJCCostProjectionOptionProjectionCode - PM Cost Projections Options -- Phase vJCCostProjectionResDet - PM Cost Projections -- Detail Window vJCFT - JC Field Ticket vJCForecastMonth - JC Forecast Month vJCJPRoles - JC Job Phases -- Roles vJCJobApprovalProcess - JC Job Approval Process vJCJobRoles - JC Jobs -- Roles vJCProjectionCode - PM Projection Codes vJCProjectionCodePhaseCT - PM Projection Codes -- Phase/Cost Type vMailQueueArchive - VA Message Archive vPCBidCoverage - PC Bid Coverage vPCBidMessageHistory - PC Bid Message History vPCBidPackage - PC Bid Package vPCBidPackageBidList - PC Bid Package -- Bid List vPCBidPackageScopeNotes - PC Bid Package -- Notes vPCBidPackageScopes - PC Bid Package -- Scope/Phase vPCCertificateTypes - PC M/WBE Certificate Types vPCCertificates - PC Pre-Qualification Info -- Certificates vPCContactTypeCodes - PC Contact Types vPCContacts - PC Pre-Qualification Info -- Contacts vPCForecastMonth - PC Potential Projects -- Forecast vPCOSHA - PC Pre-Qualification Info -- OSHA vPCOwners - PC Pre-Qualification Info -- Ownership vPCPotentialProjectCertificate - PC Potential Projects -- M/WBE Goals vPCPotentialProjectTeam - PC Potential Projects -- Project Team vPCPotentialWork - PC Potential Projects vPCProjectTypeCodes - PC Project Types vPCProjectTypes - PC Pre-Qualification Info -- Proj Types vPCQualifications - PC Pre-Qualification Info vPCReferenceTypeCodes - PC Reference Types vPCReferences - PC Pre-Qualification Info -- References vPCRegionCodes - PC Region IDs vPCScopeCodes - PC Scope IDs vPCScopePhases - PC Scope IDs -- Phases vPCScopes - PC Scope IDs -- Scope/Phase vPCStates - PC Pre-Qualification Info -- States vPCUnionContracts - PC Pre-Qualification Info -- Unions vPCWorkRegions - PC Pre-Qualification Info -- Regions vPMChangeOrderRequest - PM Change Order Request vPMChangeOrderRequestPCO - PM Change Order Request PCo vPMCompanyTemplates - PM Company Parameters -- Document Templates vPMContractChangeOrder - PM Contract Change Orders vPMContractChangeOrderACO - PM Contract ACO Change Orders vPMContractChangeOrderCommit - PM Contr Chge Order Commit vPMDistribution - PM Document Distribution vPMDistributionGroup - PM Distribution Groups vPMDistributionGroupContact - PM Distribution Groups -- Contacts vPMIssueHistory - PM Issue History vPMPCOApprove - PCO Approve vPMPCOApproveItem - PCO Approve Item vPMPOCO - PM Purchase Change Order vPMProjectDefaultDistributions - PM Project Default Distributions vPMProjectDefaultDocumentDistribution - PM Project Default Doc Dist vPMProjectMasterTemplates - PM Projects Distribution Templates vPMRFIResponse - PM RFI Response vPMRelateRecord - PM Relate Record vPMRequestForQuote - PM Request For Quote vPMRequestForQuoteDetail - PM Request For Quote Detail vPMRevenueProjection - PM Revenue Projection vPMSubcontractCO - PM Subcontract Change Order vPMSubmittal - PM Submittal vPMSubmittalPackage - PM Submittal Package vPOItemLine - PO Item Lines vPOPendingPurchaseOrder - PO Pending Purchase Order Header vPOPendingPurchaseOrderItem - PO Pending Purchase Order Items vPR1094ALEMemberInfo - PR ACA Process -- ALE Member Info vPR1094ALEOtherMembers - PR ACA Process -- ALE Group Members vPR1094Header - PR ACA Process vPR1095Covered - PR ACA 1095-C Employee -- Covered Individuals vPR1095EmployeeDetail - PR ACA 1095-C Employee -- Monthly Offer of Coverage vPR1095Header - PR ACA 1095-C Employee vPRAUETPProcessingSetup - PR Auto Termination Pay Setup vPRAUEmployeeETPAmounts - PR ETP Summary Process Employee Amounts vPRAUEmployeeETPByDate - PR ETP Summary Process -- Employee EFP By Date vPRAUEmployees - PR PAYG Summary Process -- Employees vPRAUEmployer - PR PAYG Summary Process vPRAUEmployerATOItems - PR PAYG Summary Process -- ATO / Super Items vPRAUEmployerBAS - HQ BAS Process vPRAUEmployerBASAmounts - HQ BAS Process -- GST Tax Codes vPRAUEmployerBASGSTTaxCodes - HQ BAS Process -- GST/PAYG Amounts vPRAUEmployerETP - PR ETP Summary Process vPRAUEmployerFBT - PR FBT Summary Process vPRAUEmployerFBTCategories - PR FBT Categories vPRAUEmployerFBTCodes - PR FBT Summary Process -- Reportable Amounts vPRAUEmployerFBTItems - PR FBT Summary Process -- FBT Info vPRAUEmployerMaster - AUS Employers vPRAUEmployerMiscItems - PR PAYG Summary Process -- Misc Items vPRAULimitsAndRates - PR Limits and Rates vPRAUSTPSubmission - PR STP Process vPRAUSuperClearingHouse - PR Super Clearing House Funds vPRAUSuperClearingHouseFund - PR Super Clearing House Funds -- Funds vPRAllowanceRuleSet - PR Allowance Rule Sets vPRAllowanceRules - PR Allowance Rules vPRAllowanceType - PR Allowances vPRArrears - PR Arrears/Payback History vPRCAEmployeeAccumsDetail - PR CA Employee Accums Detail vPRCAEmployeeT4SlipCodes - PR Employee T4 Slips -- T4 Other Codes vPRCAEmployeeT4SlipItems - PR Employee T4 Slips -- T4 Box Items vPRCAEmployeeT4Slips - PR Employee T4 Slips -- T4 Slips Grid vPRCAEmployeesArchive - PR CA Employees Archive vPRCALimitsAndRates - PR CA Limits and Rates vPRCAPayrollDetail - PR CA Payroll Detail vPRCAProgramAccounts - PR CA Program Accounts vPRCraftClassAllowance - PR Craft Classes -- Allowance Earnings vPRCraftClassTemplateAllowance - PR Craft Class Templates -- Allowance Earnings vPRCraftMasterAllowance - PR Crafts -- Allowance Earnings vPRCraftTemplateAllowance - PR Craft Templates -- Allowance Earnings vPRCraftTemplateCappedBasis - PR Craft Templates -- Capped Basis vPREmplPeriodsWithoutPay - PR Employee Periods Without Pay vPREmplTermProcessWorkfile - PR ETP Processing Workfile vPREmployeeDailyTime - PR Employee Daily Time vPRLedgerUpdateDistribution - PR Ledger Update Distribution vPRLedgerUpdateMonth - PR Ledger Update Month vPRROEEmployeeHistory - PR Record of Employment vPRROEEmployeeInsurEarningsPPD - PR ROE Employee Insurable Earn vPRROEEmployeeSSPayments - PR ROE Separate/Special Paymts vPRROEEmployeeWorkfile - PR Employee ROE Workfile vRPFD - RP Reports by Form Parameter Defaults vRPFDc - RP Reports by Form Parameter Defaults Custom vRPFR - RP Reports by Form vRPFRc - RP Reports by Form Custom vRPPL - RP Report Parameters -- Addl Lookups vRPPLc - RP Report Parameters -- Addl Lookups Custom vRPRF - RP Report Titles -- Layout vRPRL - RP Report Locations vRPRM - RP Reports by Module vRPRMc - RP Reports by Module Custom vRPRP - RP Report Parameters vRPRPc - RP Report Parameters Custom vRPRQ - RP Report Titles -- Queries vRPRQc - RP Report Titles -- Queries Custom vRPRS - RP Report Security Access vRPRSServer - RP RS Server vRPRT - RP Report Titles vRPRTc - RP Report Titles Custom vRPSP - RP Last Used Parameters vRPTM - RP Report Titles -- Assigned Templates vRPTMc - RP Report Titles -- Assigned Templates Custom vRPTP - RP Report Tables vRPTY - RP Report Type vRPTYc - RP Report Type Custom vRPUP - RP Report Titles -- Printer/Viewer Options vSLClaimHeader - SL Subcontract Claims Header vSLClaimItem - SL Subcontract Claims Item vSLClaimItemVariation - SL Subcontract Claims Unapproved Change Orders vSLInExclusions - SL Inclusions/Exclusions Posted vSLInExclusionsBatch - SL Subcontract Entry -- Inclusions/Exclusions vSMAgreement - SM Agreements vSMAgreementAmrt - SM Agreements Amrt vSMAgreementBillingSchedule - SM Agreements -- Billing Schedule vSMAgreementBudget - SM Agreements -- Budget vSMAgreementLaborAllocation - SM Agreements Labor Allocation vSMAgreementLaborAllocationYear - SM Agreements Labor Allocation Year vSMAgreementNotes - SM Agreements -- Agreement Notes vSMAgreementRevenueDeferral - SM Agreements -- Amortization Schedule vSMAgreementService - SM Agreements -- Work Schedule vSMAgreementServiceItems - SM Agreements Service Items vSMAgreementServiceWorkSchedule - SM Agreements Service Work Schedules vSMAgreementSite - SM Agreements -- Spot Coverage vSMAgreementSiteCoverage - SM Agreements Site Coverage vSMAgreementTaskSchedule - SM Agreements Task Schedule vSMAgreementTerm - SM Agreements -- Term Notes vSMAgreementType - SM Agreements Types vSMAgreementTypeCallTypeCoverage - SM Agreements Type Call Type Coverage vSMAgreementWorkSchedule - SM Agreements -- Service Schedule vSMAssignment - SM Assignment vSMAssociatedCallType - SM Service Centers -- Call Types vSMBC - SM Batches vSMCO - SM Company Parameters vSMCall - SM Call Handler vSMCallType - SM Call Types vSMCallTypeCategory - SM Call Type Category vSMClass - SM Serviceable Item Class vSMClassMaintenance - SM Serviceable Item Class -- Maintenance vSMCostType - SM Cost Types vSMCustomer - SM Customers vSMCustomerContact - SM Customer Contact vSMDeliveryGroup - SM Delivery Group vSMDeliveryGroupInvoice - SM Delivery Group Invoice vSMDeliveryReport - SM Delivery Report vSMDepartment - SM Departments vSMDepartmentBurdenOverride - SM Departments -- Burden Rates vSMDepartmentCostTypes - SM Departments -- Cost Types vSMDepartmentOverrides - SM Departments -- Overrides vSMDepartmentStandardItems - SM Departments -- Standard Items vSMDetailTransaction - SM Detail Transaction vSMDispatchBoardUserSettings - SM Dispatch Brd Usr Settings vSMDispatchLastUsedNamedBoard - SM Disp Lst Used Named Brd vSMDivision - SM Service Centers -- Division vSMEMUsageBatch - SM EM Usage Batch Distribution vSMEMUsageBreakdownDistribution - SM EM Usage Breakdown Batch Distribution vSMEntity - SM Entity vSMFlatPriceRevenueSplit - SM Flat Price Revenue vSMFrequencySetup - SM Frequency Setup vSMGLDistribution - SM GL Batch Distribution vSMINBatch - SM IN Batch Distribution vSMInvoice - SM Invoices vSMInvoiceARBH - SM Invoice Header Distribution vSMInvoiceDetail - SM Invoice Detail vSMInvoiceLine - SM Invoice Lines vSMInvoiceSession - SM Invoice Session vSMJobCostDistribution - SM Job Cost Distribution vSMLaborCode - SM Labor Codes vSMLaborCostEstimate - SM Labor Cost Estimate vSMLaborCostEstimateEffectiveDate - SM Labor Cost Estimate -- Effective Date vSMLineType - SM Line Types vSMMyTimesheetLink - SM My Timesheet Link vSMNamedDispatchBoard - SM Dispatch Board Setup vSMNamedDispatchBoardQuery - SM Named Dispatch Board -- Custom Queries vSMNamedDispatchBoardStdQuery - SM Named Dispatch Board -- Standard Queries vSMNamedDispatchBoardTechnician - SM Named Dispatch Board -- Technicians vSMPOItemLine - SM PO Item Lines vSMPartType - SM Part Types vSMPayType - SM Pay Types vSMRateOverrideBaseRate - SM Customers Override Rates vSMRateOverrideEquip - SM Rate Templates -- Equipment Override vSMRateOverrideLabor - SM Rate Templates -- Labor Override vSMRateOverrideMaterial - SM Rate Templates -- Material Override vSMRateOverrideMatlBP - SM Rate Templates -- Material Override BP vSMRateOverrideNonMaterial - SM Rate Templates -- Non-Material Override vSMRateOverrideNonMatlBP - SM Rate Templates -- Non-Material Override BP vSMRateOverrideStandardItem - SM Rate Templates -- Standard Item Override vSMRateTemplate - SM Rate Templates vSMRateTemplateEffectiveDate - SM Rate Templates -- Effective Date vSMRequiredEquipment - SM Standard Tasks -- Equipment vSMRequiredLabor - SM Standard Tasks -- Labor vSMRequiredMaterial - SM Standard Tasks -- Material vSMRequiredMisc - SM Standard Tasks -- Misc vSMRequiredTasks - SM Required Tasks vSMScopePriority - SM Scope Priority vSMServiceCenter - SM Service Centers vSMServiceItemPart - SM Service Sites -- Serviceable Items -- Parts vSMServiceItems - SM Service Sites -- Serviceable Items vSMServiceSite - SM Service Sites vSMServiceSiteContact - SM Service Sites -- Contacts vSMSession - SM Session vSMStandardItem - SM Standard Items vSMStandardItemDefault - SM Standard Items Default vSMStandardTask - SM Standard Tasks vSMTaskGroup - SM Task Group vSMTechnician - SM Technicians vSMTechnicianPreferences - SM Technician Preferences vSMTechnicianUnavailableTime - SM Technician Unavailable Time vSMTrip - SM Trips vSMTripStatusHistory - SM Trip Status History vSMType - SM Serviceable Item Class -- Types vSMWorkCompleted - SM Work Completed vSMWorkCompletedBatch - SM Work Completed Batch vSMWorkCompletedDetail - SM Work Completed Detail vSMWorkCompletedEquipment - SM Work Completed Equipment vSMWorkCompletedLabor - SM Work Completed Labor vSMWorkCompletedMisc - SM Work Completed Misc vSMWorkCompletedPart - SM Work Completed Part vSMWorkCompletedPurchase - SM Work Completed Purchase vSMWorkOrder - SM Work Orders Header vSMWorkOrderPOHB - SM Work Order POHB vSMWorkOrderPOHD - SM Work Order POHD vSMWorkOrderQuote - SM Work Order Quotes Header vSMWorkOrderQuoteScope - SM Work Order Quotes Detail vSMWorkOrderScope - SM Work Orders Details vSMWorkScope - SM Work Scopes vVAAttachmentTypeSecurity - VA Attachment Type Security Access vVAFileExtensionWhiteList - VA File Extension Allow List -- File Extensions vVAFileUploadType - VA File Extension Allow List vVAScheduledChanges - VA Scheduled Changes vVPGridColumns - VA Inquiries -- Columns vVPGridColumnsc - VA Inquiries -- Columns Custom vVPGridQueries - VA Inquiries vVPGridQueriesc - VA Inquiries Custom vVPGridQueryAssociation - VA Inquiries -- Associations vVPGridQueryAssociationc - VA Inquiries -- Associations Custom vVPGridQueryLinkParameters - VA Inquiries -- Links -- Parameters vVPGridQueryLinkParametersc - VA Inquiries -- Links -- Parameters Custom vVPGridQueryLinks - VA Inquiries -- Links vVPGridQueryLinksc - VA Inquiries -- Links Custom vVPGridQueryParameters - VA Inquiries -- Parameters vVPGridQueryParametersc - VA Inquiries -- Parameters Custom vrvAPHoldStatus - AP Hold Status vrvJCCommittedCost - JC Committed Cost Detail vrvPMContractStatusDD - PM Contract Status Data With PCO vrvSMInvoiceListOnlyInvoiced - SM Invoice List Only Invoiced
Select a table from the dropdown above.
Table Properties # Description – The name of the table, often referencing its purpose. Example: AP Vendors – Additional Addresses .
Company Column – The column that determines company-specific filtering . Example: VendorGroup .
Duplicate Columns – Identifies the columns that must be unique in the table. These columns help prevent duplicate records. Example: VendorGroup, Vendor, AddressSeq .
Update Columns – Lists the identity column (if present) or the primary key columns used in UPDATE
statements when modifying existing records. An example is the KeyID
column.
Identity Columns – Specifies system-generated key columns that automatically increment. Example: KeyID .
Vista Form Security – Displays the Vista form associated with the table, which determines security access within TAD . Example: APAddtlAddr .
Default Alias – The alternate name assigned to the table for easier reference in queries and selections.
Object Type – Categorizes the table as part of Tables, Views, or other database objects . Example: Tables .
Record Type – Defines whether the table contains Standard or System-generated records . Example: Standard .
Notes – Provides additional details or special considerations for using the table.
Selecting a table from the list allows you to review its structure, security settings, and key properties , ensuring you work with the correct dataset in TAD .