List of Database Tables |
Top Previous Next |
AP AP1099S.ADT COMPANY Work File for producing 1099s AP APAGING.ADT USER A/P Aging Schedule Work File AP APCHECKS.ADT COMPANY Historical A/P Cash Disb AP APCKBAT.ADT USER Batch of Checks (Auto, H/W, Void) AP APCUSACT.ADT USER Vendor Activity Report Temp File AP APHWBAT.ADT USER Batch of H/W and Void A/P Checks AP APMAGCTL.ADT COMPANY 1099 control file for printed & mm AP APPJBAT.ADT USER Batch of Purchases (Payables) AP APREPRNT.ADT COMPANY Work File for reprinting A/P Checks AP APSPBAT.ADT USER Batch of Sub Payment Sheets AP APSPJBAT.ADT USER Batch of Sub Purchases (Payables) AP DISBSUM.ADT COMPANY YTD Cash Disb Summary AP NEXTAPNO.ADT COMPANY Next Avail A/P Inv Ref # AP OPENAP.ADT COMPANY Open A/P Invoices-Unpaid AP PURCHJNL.ADT COMPANY Historical Purchase Journal AP SUBPMTS.ADT COMPANY Historical Sub Pmt Sheets AR ARAGING.ADT USER A/R Aging Schedule Work File AR ARBKBAT.ADT USER Batch of BackCharge Receipts AR ARCRBAT.ADT USER Batch of Cash Receipts AR ARCUSACT.ADT USER Customer Activity Report Temp Table AR ARJTBAT.ADT USER Batch of Joint Check Receipts AR ARMIBAT.ADT USER Misc Invoice Trans File AR ARMIHIST.ADT COMPANY Historical Misc Invoices AR ARMIVBAT.ADT USER Void Misc Invoice Batch File AR ARTAXREP.ADT USER Sales Tax Report - Invoices AR CITRSBAT.ADT COMPANY Trucking Batch of Citrus Billings AR CRTAXREP.ADT USER Sales Tax Report - Receipts AR DISPATCH.ADT COMPANY Current Trucking Dispatch Log AR DISPHIST.ADT COMPANY Historical Trucking Dispatch Log AR DISPREP.ADT USER Dispatch Log Report - Temp File AR HANDTAGS.ADT COMPANY Hand Tag Master List AR NEXTARNO.ADT COMPANY Next Available AR Inf Ref AR OPENAR.ADT COMPANY Open A/R Invoices-Unpaid AR RECEIPTS.ADT COMPANY Historical Cash Recpts AR SALES.ADT COMPANY Historical Sales Jrnl AR SALESMAS.ADT COMPANY Sales Code Master File AR TRBROKE.ADT COMPANY Trucking Broker Properties AR TRCRBAT.ADT USER Trucking Cash Receipts Batch File AR TRCUSACT.ADT USER Trucking Cust Activity Report Table AR TRENOPCT.ADT COMPANY Trucking Employee Load % Payment AR TRKBILLS.ADT COMPANY Historical Customer Billlings AR TRKREP7.ADT USER Temp user file for subhauler stmnts AR TROPENAR.ADT USER Working Table for Cash Receipts AR TRPUCMAS.ADT COMPANY Trucking PUC Classification Master AR TRUCKBAT.ADT COMPANY Trucking Batch of Customer Billings AR TRUKPROP.ADT COMPANY Trucking Receivable Properties BC CJOBHRS.ADT COMPANY Current Job Clock Trans BC CMAINHRS.ADT COMPANY Current Main Clock Trans BC HJOBHRS.ADT COMPANY Hist Job Clock Trans BC HMAINHRS.ADT COMPANY Hist Main Clock Trans BC SUPRVISE.ADT COMPANY List of Supervisors BC WSMASTER.ADT COMPANY Workstation I.D. List CL CLIENTS.ADT COMPANY Client\Vendor Info CL CLRELATE.ADT COMPANY Client Relations File CL LIENS.ADT COMPANY Client Lien\Release Info CL NEXTCLNO.ADT COMPANY Next Avail Client No CL PROFIDF.ADT COMPANY Default Profile Items CL PROFIJOB.ADT COMPANY Default Job Profile Info CL PROFILES.ADT COMPANY Client Profile Info DM DMBATCH.ADT COMPANY Batch Scans of TIFF Files DM DMDETAIL.ADT COMPANY Document Management Document Trans DM DMEMGRP.ADT COMPANY EMail Group Master File DM DMEMLIST.ADT COMPANY EMail Contact Master File DM DMGRPXRF.ADT COMPANY EMail Group Member Cross Reference DM DMMASTER.ADT COMPANY Document Management Master File DM DMVOLXRF.ADT COMPANY Document Management Volume ID File EQ EQAPLEXP.ADT USER Equipment Applied G&A Exp Tmp File EQ EQGLACCT.ADT COMPANY Equipment G/L Account List EQ EQGLREP5.ADT USER Equipment Utilization Report File EQ EQJEBAT.ADT USER Equipment Journal Transaction Batch EQ EQTRANS.ADT COMPANY Equipment Transaction File EQ EQUIPCAT.ADT COMPANY Equipment Category File EQ EQUIPMAS.ADT COMPANY Equipment Master File GL BANKBAT.ADT USER Bank Reconciliation User Batch File GL BANKREC.ADT COMPANY Bank Reconciliation Historical File GL CKREGBAT.ADT USER Check Register Batch File GL FINSTMT.ADT COMPANY Empty Financial Statment Design GL FSLIST.ADT COMPANY List of Financial Statement Formats GL GLCKBAT.ADT USER Check Reconciliation Trans Batch GL GLDETAIL.ADT COMPANY Historical G/L Trans GL GLFSCALC.ADT USER Financial Statement Print Calc File GL GLJEBAT.ADT USER Batch of Journal Entries GL GLMASTER.ADT COMPANY G/L Master - Accounts GL GLPCBAT.ADT USER Batch - Post Closing Journal Enties GL GLVARREP.ADT USER G/L-EQ,JC Discrepencies Report File IV IVGROUPS.ADT COMPANY Inventory Groups List IV IVMASTER.ADT COMPANY Inventory Master List IV IVRCVBAT.ADT USER Batch of Receivers (Shipments) IV IVRECVR.ADT COMPANY Historical I/V Receivers IV IVXFERS.ADT COMPANY Historical I/V Transfers IV IVXFRBAT.ADT USER Batch of Inventory Transfers JC ESTDETL.ADT COMPANY Estimate/Billing Info JC IMESTBAT.ADT USER Batch of Import Records from others JC JCCAPREP.ADT USER Temp Table for Job Capsheet Reports JC JCCBBAT.ADT USER Job Billing Transaction File JC JCCBINF.ADT USER Job Billing Invoice Info File JC JCOPTMAS.ADT COMPANY Residential Options Master List JC JCRESMAS.ADT COMPANY Residential Master List Templates JC JCRPBILL.ADT USER Job Billings trans file for reprint JC JCTMPLAT.ADT USER Job Estimate Template File JC JOBBILLS.ADT COMPANY Historical Job Billings JC JOBCCCAP.ADT USER Committed Cost To Complete WorkFile JC JOBCOST.ADT COMPANY Job Cost Master JC JOBDETL.ADT COMPANY Historical Job Trans. JC JOBLIST.ADT COMPANY List of Jobs JC PHASEMAS.ADT COMPANY List of Job Phases PO NEXTPONO.ADT COMPANY Next Available PO Number PO POAGENTS.ADT COMPANY List of Purchasing Agents PO POAPINV.ADT COMPANY Historical A/P Invoices PO PODETAIL.ADT COMPANY Purchase Order Line Items PO POFFBAT.ADT USER Batch of Stock Fulfillments PO POFULFIL.ADT COMPANY Historical Stock Fulfills PO POINVBAT.ADT USER Batch of PO Payable Invoices PO POMASTER.ADT COMPANY Purchase Order Master PO PORCVBAT.ADT USER Batch of PO Receivers (Shipments) PO PORECVR.ADT COMPANY Historical P/O Receivers PO POSHIP.ADT COMPANY Purchase Order Shipping Terms PO POTERMS.ADT COMPANY List of Payment Terms PO POTYPES.ADT COMPANY List of PO Types PR COMPCODE.ADT COMPANY List of W/Comp Ins Codes PR CPRDETL.ADT COMPANY Historical Cert P/R Trans PR DEPTMAS.ADT COMPANY List of Dept Codes PR EMPSTATE.ADT COMPANY Employee Multi-State W/H Info PR LOCALTAX.ADT COMPANY Local Tax and Misc Deduct Table PR NEXTENO.ADT COMPANY Next avail. Emp No. PR PERSONAL.ADT COMPANY Employee Info PR PRCHECKS.ADT COMPANY Historical P/R Cash Disb PR PRCKBAT.ADT USER Batch of P/R Checks PR PRDIRDEP.ADT COMPANY Historical List of Direct Deposits PR PRHWCHK.ADT USER Batch of hand written checks PR PRHWTIME.ADT USER Handwritten time cards PR PRMAGASC.ADT COMPANY Magnetic Media Ascii Work File PR PRMAGCTL.ADT COMPANY Magnetic Media Federal Control Info PR PRMAGEMP.ADT COMPANY Magnetic Media/W2 Employee Info PR PRTCBAT.ADT USER Batch of Time Card Entries PR PRUNEFDT.ADT USER Advanced Union Report Effective Dt PR PRUNREP.ADT USER Advanced Union Report TempTable PR TCIMPORT.ADT USER Ascii Time Card Import File PR TIMECARD.ADT COMPANY Historical Time Cards PR UNIONS.ADT COMPANY List of Union Codes PR WAGEMAST.ADT COMPANY Historical YTD Wages SY USERGLOBALS USER Single Record of All Current Company Global Settings
|