select count (*) from cbcheck

----------- 
17373

select top 1 * from cbcheck order by trans_nbr asc

CASH_CODE BANK_INST_CODE TRANS_NBR  TRANS_IDENT  COMPANY PROC_LEVEL REC_STATUS VENDOR_GROUP PAY_GROUP PAID_VENDOR PAID_NAME                      REMIT_TO_CODE BASE_PMT_AMT      BASE_ND TRAN_PMT_AMT      TRAN_ND TOT_INV_PAID      CHECK_DATE                                             PAY_CURRENCY ACT_CNV_RATE   SERIAL_NUM  CHECK_TYPE RELEASE_FL BASE_APPL_AMT     BANK_CURR_AMT     BNK_CNV_RATE   BANK_APPL_AMT     BANK_ND REJECT_DATE                                            SORT_OPTION1    SORT_OPTION2    SORT_OPTION3    INVOICE_GROUP PROC_GRP RECON_STMT_NBR 
--------- -------------- ---------- ------------ ------- ---------- ---------- ------------ --------- ----------- ------------------------------ ------------- ----------------- ------- ----------------- ------- ----------------- ------------------------------------------------------ ------------ -------------- ----------- ---------- ---------- ----------------- ----------------- -------------- ----------------- ------- ------------------------------------------------------ --------------- --------------- --------------- ------------- -------- -------------- 
CASH01    MAN                     2 1406         1                  2          FOO         1              3261   EXAMPLE VENDOR               49.49             2       70.22             2       70.22             2003-05-01 00:00:00.000                                CAD          .704800        0           M          Y          49.49             70.22             1.000000       70.22             2       1753-01-01 00:00:00.000                                                                                                       0


select count (*) from cbtrans

----------- 
17334


select top 1 * from cbtrans order by trans_nbr asc

CASH_CODE BANK_INST_CODE TRANS_NBR  SUFFIX BANK_INST_TYPE SOURCE_CODE COMPANY VENDOR    CUSTOMER  EMPLOYEE    TRANS_IDENT  PROC_LEVEL ISSUE_DATE                                             RECON_DATE                                             ISSUE_BNK_AMT     ISSUE_BASE_AMT    RECON_BNK_AMT     RECON_BASE_AMT    TRAN_ND BASE_ND BNK_TRANS_SIGN ORIG_CNV_RATE  RECON_CNV_RATE ISSUE_TRAN_AMT    BNK_CNV_RATE   BANK_ND CURRENCY_CODE DESCRIPTION                    REFERENCE  PERIOD_DATE                                            LAST_DIST_SEQ REC_STATUS REINSTATE_FL PRINT_STATUS DIST_APPLIED      BASE_APPLIED      DIST_DATE                                              SERIAL_NUM  SUMMARY_OPTION REC_TYPE PAY_GROUP JRNL_BOOK_NBR RECON_STMT_NBR STMT_STATUS JBK_SEQ_NBR  SOURCE CBTSET4_SS_SW 
--------- -------------- ---------- ------ -------------- ----------- ------- --------- --------- ----------- ------------ ---------- ------------------------------------------------------ ------------------------------------------------------ ----------------- ----------------- ----------------- ----------------- ------- ------- -------------- -------------- -------------- ----------------- -------------- ------- ------------- ------------------------------ ---------- ------------------------------------------------------ ------------- ---------- ------------ ------------ ----------------- ----------------- ------------------------------------------------------ ----------- -------------- -------- --------- ------------- -------------- ----------- ------------ ------ ------------- 
CASH01    MAN                     2 0      C              AP          1            3261           0           1406                    2003-05-01 00:00:00.000                                1753-01-01 00:00:00.000                                70.22             49.49             .00               .00               2       2       DR             .660400        .000000        70.22             1.000000       2       CAD           EXAMPLE VENDOR AP170      1753-01-01 00:00:00.000                                0             1          N            N            70.22             49.49             2003-05-01 00:00:00.000                                0                                   1                       0              0           0                   N