ࡱ> ()   !"#$%&'*,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXRoot Entry4@Contents+2ZSummaryInformation(Database (TLV) F Oh+'Oh+'0m    $08@H`32@O;@ Dԁ@L4@:XgCrystal Reports0SQL pdsodbc.dll ODBC - ESI15 <  TOTAL_AMT_PAID <  DATE_LAST_CHECK  <  LAST_CHECK_NO <  PAY_CODE  <  NEXT_PAY_DISC <  NEXT_PAY_AMT <  NEXT_PAY_DATE  <  ORDER_DISC_PCT <  DUE_DATE  <  DISCOUNT_DATE  <  DISCOUNT_AMT <  TERMS_CODE  <  PAYMENT_TYPE  <  BANK_CODE  <  INVOICE_VAT <  INVOICE_TAX_3 <  INVOICE_TAX_2 <  INVOICE_TAX_AMT <  INVOICE_FRT_AMT |<  INVOICE_AMT t<  VAT_CODE  p<  TAX_CODE  f <  FREIGHT_CODE  d<  BUYER_ID  `<  PO_VENDOR  W<  PO_TYPE  U<  PO_ID  L<  REFERENCE  ;<  INVOICE_DATE  3<  INVOICE_TYPE  0<  INVOICE_ID  <  VENDOR_ID  <  VOUCHER_ID   <  RECNUM  < *  3                                                                    !  "  #  $  %  &  '  (  )  *  +  ,  -  .  /  0  1  2/  pdsodbc.dll POFVM &aA POFVM 9  ODBC - ESI15 ESI15 ESIDB_15ALL sysdba! " POFVM M DELETE_FLAG  <  DATE_LAST_UPDT  <  TIME_LAST_UPDT  <  COMMENT_8  ! <  COMMENT_7  !h <  COMMENT_6  !G <  COMMENT_5  !& <  COMMENT_4  ! <  COMMENT_3  ! <  COMMENT_2  ! <  COMMENT_1  ! < D  T# $ apfcr left outer join apfvo on apfcr.voucher_id = apfvo.voucher_id and apfcr.vendor_id = apfvo.vendor_id left outer join pofvm on apfcr.vendor_id = pofvm.vendor_id left outer join xxfcf on xxfcf.recnum > 0   pdsodbc.dll APFCR `SaA APFCR 9  ODBC - ESI15 ESI15 ESIDB_15ALL sysdba! " APFCR $ DELETE_FLAG  <  DATE_LAST_UPDT  <  TIME_LAST_UPDT   <  CURR_RATE  <  CURR_CODE  <  BC_GAIN_LOSS <  BC_DISC_OLD <  BC_AMT_OLD <  BC_DISC_USED <  BC_AMT_PAID <  LC_GAIN_LOSS <  LC_DISC_OLD <  LC_AMT_OLD <  LC_RATE_1 <  LC_AMT_PAID <  LC_DISC_LOST <  LC_DISC_USED <  LC_GROSS_AMT <  CHK_AMT_PAID <  CHK_DISC_LOST <  CHK_DISC_TAKEN <  CHK_GROSS_AMT w<  REPORT_FLAG  u<  AMOUNT_PAID m<  DISCOUNT_LOST e<  DISCOUNT_TAKEN ]<  GROSS_AMOUNT U<  GL_MONTH M<  GL_YEAR  H<  CHECK_DATE  @<  CHECK_NUMBER 8<  BATCH_NUMBER 0<  VOUCHER_ID  " <  INVOICE_ID  <  VENDOR_ID  <  RECNUM  < *  $                                                                    !  "  #/  pdsodbc.dll APFVO YaA APFVO q9  ODBC - ESI15 ESI15 ESIDB_15ALL sysdba! " APFVO 3 DELETE_FLAG  o<  DATE_LAST_UPDT  g<  TIME_LAST_UPDT  a<  GL_MONTH Y<  GL_YEAR  T<  LC_CURRENT_BAL L<  LC_DISC_LOST D<  LC_DISC_USED <<  LC_AMT_PAID 4<  INVOICE_LC_AMT ,<  BC_RATE $ <  CURR_RATE  <  CURR_CODE  <  INVOICE_STATUS  <  CURRENT_BALANCE <  TOTAL_DISC_LOST <  TOTAL_DISC_USED  COMMENT_ID   <  EARLY_RECEIPT  <  PARTIAL_SHIP  <  ORDER_DISC_PCT <  AUTO_PO_HOLD  <  LAST_YR_LOST } <  LAST_YR_DISC u <  LAST_YR_PAID m<  LC_CURRENT_BAL e<  LANGUAGE  b<  CURR_CODE  ^<  CURRENT_BALANCE V<  DISC_LOST_YTD N<  DISCOUNTS_YTD F<  PAYMENTS_YTD ><  LAST_CHECK_AMT 6<  DATE_LAST_CHECK  .<  PURCHASES_YTD &<  NUMBER_PO_YTD <  DATE_LAST_PO  <  DATE_CREATED  <  VENDOR_STATUS   <  VENDOR_TYPE   <  BANK_CODE  <  POFVM_USER_8 <  POFVM_USER_7 <  POFVM_USER_6 <  POFVM_USER_5  <  POFVM_USER_4  <  POFVM_USER_3  <  POFVM_USER_2  <  POFVM_USER_1  <  BUSINESS_TYPE  <  SIC_CODE  <  TAX_1099_TYPE  <  TAX_1099_NO   <  MAX_PAYMENT <  VAR_RECV_QTY <  VARIANCE_PCT <  VARIANCE_AMT z <  EXP_ACCOUNT  q<  EXP_DEPT  l<  COMPANY_ID  i<  AP_PHONE_NO  T<  AP_CONTACT  ?<  TAX_CODE  5 <  FOB  1<  SHIP_METHOD  -<  DAYS_LATE %<  TERMS_CODE  "<  BUYER_ID  <  PAY_TO_VENDOR  <  FAX_NO  <  PO_PHONE_NO  <  PO_CONTACT  <  SEARCH_NAME  <  COUNTRY  <  ZIP_CODE   <  STATE  <  CITY  <  ADDRESS_3  n<  ADDRESS_2  O<  ADDRESS_1  0<  VENDOR_NAME  <  VENDOR_ID  <  RECNUM  < *  M                                                                    !  "  #  $  %  &  '  (  )  *  +  ,  -  .  /  0  1  2  3  4  5  6  7  8  9  :  ;  <  =  >  ?  @  A  B  C  D  E  F  G  H  I  J  K  L/  pdsodbc.dll XXFCF RZaA XXFCF 89  ODBC - ESI15 ESI15 ESIDB_15ALL sysdba! " XXFCF " DATE_LAST_UPDT  0<  CO_FAX_NO  <  QUERY_PATH  ! <  USER_FIELD_2  <  USER_FIELD_1  <  BASE_CURR  <  LOCAL_CURR  <  POST_TO_GL  <  AUTO_PROG_LOG  <  AUTO_SO_HOLD  <  PAY_CODE_DEF  <  QTR_EXTRA_MO <  FISCAL_MONTHS <  RETAILER_ID  <  COMPANY_ID  <  AR_COUNTRY  <  AR_ZIP_CODE   <  AR_STATE  <  AR_CITY  l<  AR_ADDRESS_3  M<  AR_ADDRESS_2  .<  AR_ADDRESS_1  <  AR_COMPANY_NAME  <  PO_COUNTRY  <  PO_ZIP_CODE   <  PO_STATE  <  PO_CITY  <  PO_ADDRESS_3  <  PO_ADDRESS_2  z<  PO_ADDRESS_1  [<  PO_COMPANY_NAME  <<  CO_PHONE_NO  '<  CO_COMPANY_NAME  <  RECNUM  < *  "                                                                    !/   APFCR  VOUCHER_ID VENDOR_ID APFVO zB APFVO  VENDOR_ID POFVM zB POFVM  RECNUM XXFCF zB6 pN E APFCRO P gDSN=ESI15;UID=sysdba;APP=???????s$;WSID=JYARBROUGH;DATABASE=ESIDB_15ALL;QuotedId=No;AnsiNPW=NoQ N E APFVON E POFVMN E XXFCFR R R R ReportInfoPESI15 ESIDB_15ALLAPFCRsysdba_DSN=ESI15;UID=sysdba;APP=???????s$;WSID=JYARBROUGH;DATABASE=ESIDB_15ALL;QuotedId=No;AnsiNPW=NoSQL pdsodbc.dll ODBC - ESI15ESI15 ESIDB_15ALLAPFVOsysdba_DSN=ESI15;UID=sysdba;APP=???????s$;WSID=JYARBROUGH;DATABASE=ESIDB_15ALL;QuotedId=No;AnsiNPW=NoSQL pdsodbc.dll ODBC - ESI15ESI15 ESIDB_15ALLPOFVMsysdba_DSN=ESI15;UID=sysdba;APP=???????s$;WSID=JYARBROUGH;DATABASE=ESIDB_15ALL;QuotedId=No;AnsiNPW=NoSQL pdsodbc.dll ODBC - ESI15ESI15 ESIDB_15ALLXXFCFsysdba_DSN=ESI15;UID=sysdba;APP=???????s$;WSID=JYARBROUGH;DATABASE=ESIDB_15ALL;QuotedId=No;AnsiNPW=No0dgdldddddddedddAydddddddddedcddddtdAydddddedddddddddddddddddddddddddddddddddddddddddd$dddddddddlefcfffffgffgfffffffffffgfgfgfffffffffgfffffbfffffffffgffffffffffgfgffff7affffl7776777777_4afffffgf` __8o hoooo} oooooosFtssssWpppp`3?/3?= 1>)/>1=5p{popppqpc{se++505]0<,0<>#2=*,=2>6ss@tssssRpppp} ?/144"5##/Ap{popppqpc{s`++505]#<,277!6 ,Bss@tssssRpppp} ?/144"5##/Bp{popppqpc{s`++505]#<,277!6 ,Ass@tssssRpppp} ?/144"5##/Cp{popppqpc{s`++505]#<,277!6 ,@ss6tssssoppppx ?/39$)p{pipppqpc{s}++505]#<,0:'*ss8tssssnppppy ?/#$1$5p{ptpppqpc{s|++505]#<, '2'6ss>tssssSpppp| ?/*9 /3?45p{p{pppqpc{sa++505]#<,):#,0<76ss:tssssmppppz&5>4?"/94p{pypppqpc{sc2#50!]%6=74?"/94p{pypppqpc{sc2#5%<]%6=7tssssSpppp|$1(/A@II/>?p{p}pppqpc{sa#<5%>]'2+,BCJJ,=tssssSpppp|1=?%>$/ 194pvpxpppqpc{sa2#50!]2><&=',#2:7ss<tsssslpppp{3853;/41$5ppxpppqpc{sb2#50!]0;608,72'6ss<tsssslpppp{&?%385"/94p{p~pppqpc{sb2#50!]%<&0;6!,:7ss>tssssSpppp|&5>4?"/$) 5p{pspppqpc{sa#<5%>]%6=7]'2+,BCJJ,'*#6ss>tssssSpppp|&5>4?"/>1=5p{popppqpc{sa#<5%>]%6=76ss:tssssmppppz144"5##/Ap{popppqpc{sc#<5%>]277!6 ,Bss:tssssmppppz144"5##/Bp{popppqpc{sc#<5%>]277!6 ,Ass:tssssmppppz144"5##/Cp{popppqpc{sc#<5%>]277!6 ,@ss0tssssjppppu39$)p{pipppqpc{sx#<5%>]0:'*ss2tssssippppv#$1$5p{ptpppqpc{s#<5%>] '2'6ss8tssssnppppy*9 /3?45p{p{pppqpc{s|#<5%>]):#,0<76ss:tssssmppppz"565"5>35p{papppqpc{sc2#5%<]!656!6=06swǏpwwwtpppp|p{ppppqpYYGBG/BN^BNLQ@OX^O@LDYYGBG/QN^@EESDRR^0YYGBG/QN^@EESDRR^3YYGBG/QN^@EESDRR^2YYGBG/QN^BHUXYYGBG/QN^RU@UDYYGBG/QN^[HQ^BNEDrushofw`s!wmhod0!;zQNGWL/BHUX|!*!&-!&!*!zQNGWL/RU@UD|!*!&!&!*!zQNGWL/[HQ^BNED| wwwwwNpwwww5pppp~3P)p{pupppqp&3110& wwwwwIpwwwwJpppp{3 P94p{pspppqp&11& wwwwwRpwwww1p%ppph /1/2/?/ pxprpppqp wwwwwpwwwvpppp{pvpxpppqp@QGBS/BIDBJ^E@UD AB`mdoe`s!Xd`s@QGBS/WNTBIDS^HE  ABnlq`ox!HEQNGWL/WDOENS^UXQDQNGWL/U@Y^0188^UXQD@QGBS/@LNTOU^Q@HE hg )Xd`s!)z@QGBS/BIDBJ^E@UD|(!p{popppqpQNGWL/WDOENS^O@LDzQNGWL/WDOENS^O@LD| wwwwx xxxxu   xx xxxxu    yx xxxxu   zx xxxxu    {x xxxxu   |x xxxxu    }x xxxxu    rx xxxxu    sx xxxxu    tx xxxxu    ux xxxxu    vx xxxxu    wx xxxxu   hx xxxxu   ~x xxxxu   px xxxxu   qx xxxxu    ix xxxxu   CxHp pppqpvpxpppqp A`lntouq`he~~IxBp pppqpvpxpppqp@QGBS/@LNTOU^Q@HE ~~y~yyyyt  yyyyyyxyz }zzzzk rnjy {zzzb?ZZ#ZZ( zzzzzz{zzqzzzzzzzzzzzzzzzzzzzzzzz{zzz{zzzzz{zzzzzzz{zzzzzzzzzzzzzǂ }zzzzn Hdf{jer {zzzh?Z9 Z3>Zzzzzzz{zzqzyzyzzzyJJzzyzzzyJKzzyzzzyJHzzzzzzzzzzzzzzzzzzzzzz{zzz{zzzzz{zzzzzzz{zzzr9 zzzzzzzzzzzz{zzzz{zzzz{z8pllllmllllmlllllllllllllllllmllwpwwwvppppa"/#pxprpppqp@QGBS/BIDBJ^E@UD >xd`s@QGBS/WNTBIDS^HE >Bnlq`oxQNGWL/WDOENS^UXQDQNGWL/U@Y^0188^UXQD@QGWN/SDGDSDOBDXd`s!)z@QGBS/BIDBJ^E@UD|(!xd`s|(!`oe z@QGBS/WNTBIDS^HE|Z0!un!3\!Bnlq`ox|!`oe zQNGWL/WDOENS^UXQD|!