count_tblrec.sql

 

---

 select count(*) from APACCRCODE;
 select count(*) from APAUDIT;
 select count(*) from APAUTHOR;
 select count(*) from APBANKCODE;
 select count(*) from APBATCH;
 select count(*) from APCDISTRIB;
 select count(*) from APCINVOICE;
 select count(*) from APCOMMENTS;
 select count(*) from APCOMPANY;
 select count(*) from APCPAYMENT;
 select count(*) from APCRMEMO;
 select count(*) from APCVENBAL;
 select count(*) from APCVENMAST;
 select count(*) from APDISTCODE;
 select count(*) from APDISTRIB;
 select count(*) from APHOLDCODE;
 select count(*) from APINCCODE;
 select count(*) from APINVOICE;
 select count(*) from APMONITOR;
 select count(*) from APPAYMENT;
 select count(*) from APPROCLEV;
 select count(*) from APTERMS;
 select count(*) from APVENBAL;
 select count(*) from APVENCLASS;
 select count(*) from APVENGROUP;
 select count(*) from APVENLOC;
 select count(*) from APVENMAST;
 select count(*) from APVENTABLE;
 select count(*) from AGINGCODE;
 select count(*) from AR50WORK;
 select count(*) from AR53WORK;
 select count(*) from AR73WORK;
 select count(*) from AR90WORK;
 select count(*) from ARADJUST;
 select count(*) from ARAPPLIED;
 select count(*) from ARBANKCODE;
 select count(*) from ARCASHCODE;
 select count(*) from ARCDSELECT;
 select count(*) from ARCODE;
 select count(*) from ARCOMMENT;
 select count(*) from ARCOMP;
 select count(*) from ARCONTACTS;
 select count(*) from ARCPAYMENT;
 select count(*) from ARCRMEMO;
 select count(*) from ARCUSTFLDS;
 select count(*) from ARCUSTGRP;
 select count(*) from ARCUSTOMER;
 select count(*) from ARCUSTTOTS;
 select count(*) from ARCYCLE;
 select count(*) from ARDISPUTE;
 select count(*) from ARDISTRIB;
 select count(*) from ARDUNNING;
 select count(*) from ARFINANCE;
 select count(*) from ARIADJUST;
 select count(*) from ARIAPPLIED;
 select count(*) from ARICOMMENT;
 select count(*) from ARICREDIT;
 select count(*) from ARICST;
 select count(*) from ARICUST;
 select count(*) from ARICUSTCMT;
 select count(*) from ARIDISPUTE;
 select count(*) from ARIDISTRIB;
 select count(*) from ARILOCKBOX;
 select count(*) from ARIMICR;
 select count(*) from ARIPAYMENT;
 select count(*) from ARIREMIT;
 select count(*) from ARITRANS;
 select count(*) from ARLOCKBOX;
 select count(*) from ARMEMOHDR;
 select count(*) from ARMICRCUST;
 select count(*) from AROITEMS;
 select count(*) from AROPTR;
 select count(*) from ARPAYMENT;
 select count(*) from ARPROCLEVL;
 select count(*) from ARPYMNTHDR;
 select count(*) from ARREASON;
 select count(*) from ARREMIT;
 select count(*) from ARRTM;
 select count(*) from ARRTMADJ;
 select count(*) from ARSUMMARY;
 select count(*) from BALFWDTOT;
 select count(*) from BLINVHDR;
 select count(*) from CRANALYST;
 select count(*) from CUSTDEFLTS;
 select count(*) from CUSTDESC;
 select count(*) from DISPCODES;
 select count(*) from HOLDCODES;
 select count(*) from MAJCUSTCL;
 select count(*) from MINCUSTCL;
 select count(*) from NATACCT;
 select count(*) from NATBALANCE;
 select count(*) from NOTICEWRK;
 select count(*) from PLGRPDTL;
 select count(*) from PLGRPHDR;
 select count(*) from PROCLVLGRP;
 select count(*) from R_REVERSE;
 select count(*) from REVERSEDTL;
 select count(*) from SALESREP;
 select count(*) from STATICCUST;
 select count(*) from TERITORY;
 select count(*) from TERMS;
 select count(*) from OECOMPANY;
 select count(*) from OECREDCARD;
 select count(*) from OECUSTCODE;
 select count(*) from OEFRTCODE;
 select count(*) from OEORDDISC;
 select count(*) from OEPRCLIST;
 select count(*) from SHIPTO;
 select count(*) from BENEFICRY;
 select count(*) from BENEFIT;
 select count(*) from BNCOMMENTS;
 select count(*) from BNCOMPANY;
 select count(*) from BNINVDETL;
 select count(*) from BNINVEST;
 select count(*) from BNPAYDETL;
 select count(*) from BNPAYMENT;
 select count(*) from BNPROCLEV;
 select count(*) from BNSIMDTL;
 select count(*) from BNSIMHDR;
 select count(*) from BONDBENIF;
 select count(*) from CODA;
 select count(*) from COMPHIST;
 select count(*) from CONTRDETL;
 select count(*) from EMPFLEXDOL;
 select count(*) from EMPINVEST;
 select count(*) from FLEXCREDIT;
 select count(*) from FLEXDOLLAR;
 select count(*) from FLEXPLAN;
 select count(*) from LETTERCODE;
 select count(*) from LETTERTEXT;
 select count(*) from NAVIGATE;
 select count(*) from OCCURTYPE;
 select count(*) from PARTBEN;
 select count(*) from PARTICIPNT;
 select count(*) from R_PLAN;
 select count(*) from PREMIUM;
 select count(*) from RATETBLDTL;
 select count(*) from RATETBLHDR;
 select count(*) from RESTRANS;
 select count(*) from SBBEN;
 select count(*) from SPHIST;
 select count(*) from VESTHOURS;
 select count(*) from VESTSCHDDT;
 select count(*) from VESTSCHDHD;
 select count(*) from ACDETAIL;
 select count(*) from ACHEADER;
 select count(*) from CACOMMENT;
 select count(*) from CAHEADER;
 select count(*) from CBADJUST;
 select count(*) from CBBALANCE;
 select count(*) from CBBANKACCT;
 select count(*) from CBCCHECK;
 select count(*) from CBCHECK;
 select count(*) from CBDISTRIB;
 select count(*) from CBRECON;
 select count(*) from CBTRANSDEF;
 select count(*) from EEADVANCE;
 select count(*) from EEAPPROVAL;
 select count(*) from EECATEGORY;
 select count(*) from EEDISTRIB;
 select count(*) from EEEXPENSE;
 select count(*) from EEMATCHING;
 select count(*) from ACRTABLE;
 select count(*) from ASSET;
 select count(*) from ASSETAUDIT;
 select count(*) from ASSETBASE;
 select count(*) from ASSETITEM;
 select count(*) from ASSETMISC;
 select count(*) from ASSETRPAIR;
 select count(*) from ASSETUOP;
 select count(*) from ASSETYPE;
 select count(*) from ASTCDDTL;
 select count(*) from ASTCDHDR;
 select count(*) from ASTSUBTYPE;
 select count(*) from DBDICT;
 select count(*) from FABASE;
 select count(*) from FABATCH;
 select count(*) from FACMPUTE;
 select count(*) from FACOMMENTS;
 select count(*) from FACOMPANY;
 select count(*) from FAGLSUMM;
 select count(*) from FAGLTRANS;
 select count(*) from FAINTER;
 select count(*) from FALOCATION;
 select count(*) from FAPROCLEV;
 select count(*) from ITCTABLE;
 select count(*) from PUCODES;
 select count(*) from PULIMIT;
 select count(*) from PURECAP;
 select count(*) from RICLASS;
 select count(*) from RIPERCENT;
 select count(*) from XASSET;
 select count(*) from XASSETBASE;
 select count(*) from XASSETITEM;
 select count(*) from XASSETMISC;
 select count(*) from XASSETUOP;
 select count(*) from XPU;
 select count(*) from FBSPREAD;
 select count(*) from CADETAIL;
 select count(*) from CATRANS;
 select count(*) from CMPUTE;
 select count(*) from CUAMOUNT;
 select count(*) from FBDETAIL;
 select count(*) from FBHEADER;
 select count(*) from FBINTFACE;
 select count(*) from FBUDGETREL;
 select count(*) from GLACCOUNT;
 select count(*) from GLACCTREL;
 select count(*) from GLAUDIT;
 select count(*) from GLCOMMENT;
 select count(*) from GLCOMPREL;
 select count(*) from GLCONSOL;
 select count(*) from GLCONTROL;
 select count(*) from GLLEVEL;
 select count(*) from GLMASTREL;
 select count(*) from GLRPTDEF;
 select count(*) from GLRPTSEL;
 select count(*) from GLTRANS;
 select count(*) from GLTRANSREL;
 select count(*) from GLUNITS;
 select count(*) from GLZONE;
 select count(*) from RADEFINE;
 select count(*) from RATOTALS;
 select count(*) from RJCONTROL;
 select count(*) from RJTRANS;
 select count(*) from RWDICT;
 select count(*) from RWDRILL;
 select count(*) from RWFORMAT;
 select count(*) from RWGRPDET;
 select count(*) from RWHEADER;
 select count(*) from RWREQUEST;
 select count(*) from RWROWDET;
 select count(*) from DEPTCODE;
 select count(*) from EMDEPEND;
 select count(*) from EMPLOYEE;
 select count(*) from EMSTATUS;
 select count(*) from HRUTILITY;
 select count(*) from JOBCLASS;
 select count(*) from JOBCODE;
 select count(*) from R_LOGFILE;
 select count(*) from PADICT;
 select count(*) from PAEMPLOYEE;
 select count(*) from PAEMPPOS;
 select count(*) from PASCRTY;
 select count(*) from PATHFIND;
 select count(*) from PCODES;
 select count(*) from PERSGROUP;
 select count(*) from PGEMPLOYEE;
 select count(*) from PGSELECT;
 select count(*) from PRSAGDTL;
 select count(*) from PRSAGHEAD;
 select count(*) from PRSYSTEM;
 select count(*) from PSGRELATE;
 select count(*) from PWAUTHOR;
 select count(*) from PWCOMPUTE;
 select count(*) from PWSELECT;
 select count(*) from PWTITLE;
 select count(*) from ICCATEGORY;
 select count(*) from ICCOMPANY;
 select count(*) from ICLOCATION;
 select count(*) from ICRECEIPTS;
 select count(*) from ICTRANS;
 select count(*) from ITEMLOC;
 select count(*) from ITEMMAST;
 select count(*) from CUACCT;
 select count(*) from CUCODES;
 select count(*) from CUCONV;
 select count(*) from CURELAT;
 select count(*) from CUTRANSL;
 select count(*) from GLADDRESS;
 select count(*) from GLCODES;
 select count(*) from GLINTCO;
 select count(*) from GLITRANS;
 select count(*) from GLMASTER;
 select count(*) from GLNAMES;
 select count(*) from GLSYSTEM;
 select count(*) from PSGLACCT;
 select count(*) from SUMMTYPE;
 select count(*) from TRCODES;
 select count(*) from CKPOINT;
 select count(*) from CUSTORDER;
 select count(*) from OEMETHOD;
 select count(*) from OESTDORDER;
 select count(*) from APPJOBHIST;
 select count(*) from APPLICANT;
 select count(*) from EEODETAIL;
 select count(*) from EEOUNIT;
 select count(*) from EMPAUTO;
 select count(*) from EMPCODES;
 select count(*) from EMPVISA;
 select count(*) from INTERVIEW;
 select count(*) from JOBAUTH;
 select count(*) from JOBRELATE;
 select count(*) from MILITARY;
 select count(*) from OSHA;
 select count(*) from PACLASS;
 select count(*) from PACLASSPOS;
 select count(*) from PACOMMENTS;
 select count(*) from PAEMERGCNT;
 select count(*) from PAMEDICAL;
 select count(*) from PAPOSITION;
 select count(*) from PERSACTION;
 select count(*) from PERSACTYPE;
 select count(*) from REFERENC;
 select count(*) from REVIEW;
 select count(*) from STAFFING;
 select count(*) from POAOCDTL;
 select count(*) from POAPPROVE;
 select count(*) from POCOMPANY;
 select count(*) from POINTAOC;
 select count(*) from POINTERFAC;
 select count(*) from POINVOICE;
 select count(*) from POLINE;
 select count(*) from POMESSAGE;
 select count(*) from POPROCLEV;
 select count(*) from PORECLINE;
 select count(*) from POTAXAPPV;
 select count(*) from POTAXDTL;
 select count(*) from POVENDLOC;
 select count(*) from POVENDOR;
 select count(*) from PURCHORDER;
 select count(*) from STPURCHORD;
 select count(*) from BANKACCT;
 select count(*) from BANKFILE;
 select count(*) from CONTRSCHD;
 select count(*) from DCCLASS;
 select count(*) from DEDCODE;
 select count(*) from DEDFREQTBL;
 select count(*) from EMACHDEPST;
 select count(*) from EMDEDMASTR;
 select count(*) from EMDISTMAST;
 select count(*) from EMPACHDIST;
 select count(*) from EMPSUMM;
 select count(*) from GARNISHID;
 select count(*) from ONETMDED;
 select count(*) from PAYCLASS;
 select count(*) from PAYDEDUCTN;
 select count(*) from PAYMASTR;
 select count(*) from PAYSUMGRP;
 select count(*) from PAYWAGE;
 select count(*) from PRBATCH;
 select count(*) from PRCHECK;
 select count(*) from PRDISTRIB;
 select count(*) from PRMANPAY;
 select count(*) from PRPAYCODE;
 select count(*) from PRPROCGRP;
 select count(*) from PRQUALIFY;
 select count(*) from PRRATES;
 select count(*) from REQCODE;
 select count(*) from STANDTIME;
 select count(*) from TAXGROUP;
 select count(*) from TAXID;
 select count(*) from TAXIDCODE;
 select count(*) from TAXIDEXMP;
 select count(*) from TIMERECORD;
 select count(*) from TIPPAY;
 select count(*) from WCCLASS;
 select count(*) from WCCLASSHDR;
 select count(*) from WCPOLICY;
 select count(*) from YTDSUM;
 select count(*) from BASERATE;
 select count(*) from CHGDETAIL;
 select count(*) from CHGHEADER;
 select count(*) from COSTCAT;
 select count(*) from CTLGRPHEAD;
 select count(*) from JOBBUDGET;
 select count(*) from JOBTYPE;
 select count(*) from PERCCOMPLT;
 select count(*) from PROJECT;
 select count(*) from PSBUDGET;
 select count(*) from PSCCOST;
 select count(*) from PSCOMMENTS;
 select count(*) from PSCOMPANY;
 select count(*) from PSMASTER;
 select count(*) from PSREPORTGP;
 select count(*) from PSTRANS;
 select count(*) from ROLLACTUAL;
 select count(*) from ROLLBUDGET;
 select count(*) from RPTGRPHEAD;
 select count(*) from SPREADCODE;
 select count(*) from ACCRSCHED;
 select count(*) from ACTRLIMIT;
 select count(*) from EMTAMASTR;
 select count(*) from EMTATRANS;
 select count(*) from EMTATRNSUM;
 select count(*) from PLANCLASS;
 select count(*) from PLANMASTER;
 select count(*) from TAFORMULA;
 select count(*) from ATCLASS;
 select count(*) from ATTENDCODE;
 select count(*) from ATTENDHIST;
 select count(*) from TPPARAM;
 select count(*) from TXTAXCODE;
 select count(*) from TXTAXRATE;
 select count(*) from TXTAXTABLE;
 select count(*) from TXTAXTRAN;
 select count(*) from UGPARAM;

---