Liren Large Software Subsidy 5/05.iso/a/a044/3.ddi/CARET/LETTER.RET

Text File | 1993-08-31 | 5.8 KB | 70 lines

{\rtf1\ansi
{\*\demo}
{\fonttbl{\f0\fswiss Arial;}{\f1\froman Times New Roman;}{\f2\fswiss Helvetica;}}
{\colortbl\red0\green0\blue0;\red128\green0\blue0;\red0\green128\blue0;\red128\green128\blue0;\red0\green0\blue128;\red128\green0\blue128;\red0\green128\blue128;\red128\green128\blue128;\red192\green192\blue192;\red255\green0\blue0;\red0\green255\blue0;\red255\green255\blue0;\red0\green0\blue255;\red255\green0\blue255;\red0\green255\blue255;}
{\info{\author CA-RET}{\title Report title}}
{\*\vrwvern1\vrwsubn0}
\paperw12240 \paperh15840 \margl2745 \margr2745 \margt1440 \margb1440
{\*\vrwcol table1{\col0 0 1530 180}{\col1 1710 1980 180}{\col2 3870 810 180}{\col3 4860 990 180}{\col4 6030 720 180}}
{\*\ctrcol}
\sectd \linex0 \pard
{\*\vrwvar {\v0 ORDER_NUMBER\colnum1\colnam ORDER_NUMB\len8\flt}
{\v1 CUST_NAME\colnum2\colnam CUST_NAME\len16\txt}
{\v2 SHIP_ADDR1\colnum3\colnam SHIP_ADDR1\len27\txt}
{\v3 SHIP_CITY\colnum4\colnam SHIP_CITY\len11\txt}
{\v4 SHIP_STATE\colnum5\colnam SHIP_STATE\len3\txt}
{\v5 SHIP_ZIP\colnum6\colnam SHIP_ZIP\len8\flt}
{\v6 ORDER_DATE\colnum7\colnam ORDER_DATE\len8\dat}
{\v7 ITEM_CODE\colnum8\colnam ITEM_CODE\len8\flt}
{\v8 DESCRIPTION\colnum9\colnam DESCRIPTIO\len96\txt}
{\v9 QUANTITY\colnum10\colnam QUANTITY\len8\flt}
{\v10 PRICE\colnum11\colnam PRICE\len8\flt}
{\v11 ORDER_NUMB\colnum1\colnam ORDER_NUMB\len8\flt}
{\v12 DESCRIPTIO\colnum9\colnam DESCRIPTIO\len96\txt}
{\v13 cost{\expcr16 QUANTITY * PRICE}\flt}
{\v14 order_cost{\expcr25 Sum( cost, ORDER_NUMBER )}\flt}
{\v15 item_count{\expcr27 Count( ORDER_NUMBER, BODY )}\flt}
{\v16 _date{\expcr12 SystemDate()}\dat}
{\v17 _pagenumber{\expcr12 PageNumber()}\int}
{\*\vrwqry \qrynam QUERY2\inptyp3 {\*\qrytbl SAMPLES\\CARET\\LETTER1.DBF}
{\*\qrycol ORDER_NUMB    0 }
{\*\qrycol CUST_NAME    0 }
{\*\qrycol SHIP_ADDR1    0 }
{\*\qrycol SHIP_CITY    0 }
{\*\qrycol SHIP_STATE    0 }
{\*\qrycol SHIP_ZIP    0 }
{\*\qrycol ORDER_DATE    0 }
{\*\qrycol ITEM_CODE    0 }
{\*\qrycol DESCRIPTIO    0 }
{\*\qrycol QUANTITY    0 }
{\*\qrycol PRICE    0 }
{\*\qryord ORDER_NUMB    0 0 }
{\*\qryord ITEM_CODE    0 0 }
{\map ORDER_NUMBER\mapcol ORDER_NUMB\maptbl LETTER1\mapnum1}
{\map CUST_NAME\mapcol CUST_NAME\maptbl LETTER1\mapnum2}
{\map SHIP_ADDR1\mapcol SHIP_ADDR1\maptbl LETTER1\mapnum3}
{\map SHIP_CITY\mapcol SHIP_CITY\maptbl LETTER1\mapnum4}
{\map SHIP_STATE\mapcol SHIP_STATE\maptbl LETTER1\mapnum5}
{\map SHIP_ZIP\mapcol SHIP_ZIP\maptbl LETTER1\mapnum6}
{\map ORDER_DATE\mapcol ORDER_DATE\maptbl LETTER1\mapnum7}
{\map ITEM_CODE\mapcol ITEM_CODE\maptbl LETTER1\mapnum8}
{\map DESCRIPTION\mapcol DESCRIPTIO\maptbl LETTER1\mapnum9}
{\map QUANTITY\mapcol QUANTITY\maptbl LETTER1\mapnum10}
{\map PRICE\mapcol PRICE\maptbl LETTER1\mapnum11}
{\map ORDER_NUMB\mapcol ORDER_NUMB\maptbl LETTER1\mapnum1}
{\map DESCRIPTIO\mapcol DESCRIPTIO\maptbl LETTER1\mapnum9}
}
{\*\vrwsct {\BCK15524 {\sctrct288 158 11952 15682}\nstlev1 }
\pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }
{\*\vrwsct {\PHD1432 {\sctrct2745 1440 9495 2872}\keptgr \txthgt \nstlev1 }
\pard\plain\ql {\b\f0\fs36 sycam's}{\*\brdwid36}\brdrt\brdrs\brdrw36\par\pard\plain\ql {\i\f0\fs20 the department store with more}\par\pard\plain\ql {\f0\fs20  }{\*\brdwid36}\brdrb\brdrs\brdrw36\par\pard\plain\ql {\f0\fs20  }\par\pard\plain\ql {\f0\fs20 }
{\*\vrwsct {\GHD3485 {\sctrct2745 2872 9495 6357}\keptgr \txthgt \rptbrk \nstlev1 {\grpvbllst ORDER_NUMBER}}
\pard\plain\ql {\f0\fs20 {\*\varref CUST_NAME\trmblk}}{\f0\fs20 }\par\pard\plain\ql {\f0\fs20 {\*\varref SHIP_ADDR1\trmblk}}{\f0\fs20 }\par\pard\plain\ql {\f0\fs20 {\*\varref SHIP_CITY\trmblk}}{\f0\fs20 , }{\f0\fs20 {\*\varref SHIP_STATE\trmblk}}{\f0\fs20  }{\f0\fs20 {\*\varref SHIP_ZIP\trmblk}}{\f0\fs20 }\par\pard\plain\ql {\f0\fs20  }\par\pard\plain\ql {\f0\fs20 Dear Customer:}\par\pard\plain\ql {\f0\fs20  }\par\pard\plain\qj {\f0\fs20 Your order placed on }{\f0\fs20 {\*\varref ORDER_DATE\pic d-Mmm-yy \trmblk}}{\f0\fs20  has been delayed because the }{\f0\fs20 {\*\varref item_count\pic #,### }}{\f0\fs20  items listed below are out of stock.  They will be shipped from our warehouse as soon as they are available from the manufacturer.  Your account will be charged with the total amount of }{\f0\fs20 {\*\varref order_cost\pic Currency }}{\f0\fs20  only when the items are shipped.  If you have any questions, please call our customer service hotline at [phone] and refer to order number }{\f0\fs20 {\*\varref ORDER_NUMBER\trmblk}}{\f0\fs20 .}\par\pard\plain\ql {\f0\fs20  }{\*\brdwid20}\brdrb\brdrs\brdrw20\par\pard\plain\trowd \trgaph90\trleft-90\cellx1620\cellx3780\cellx4770\cellx5940\cellx6840
{\*\vrwcoldef1}
\intbl \ql {\ul\f0\fs20 Catalog number}\cell\pard\plain\intbl \ql {\ul\f0\fs20 Description}\cell\pard\plain\intbl \qr {\ul\f0\fs20 Quantity}\cell\pard\plain\intbl \qr {\ul\f0\fs20 Price}\cell\pard\plain\intbl \qr {\ul\f0\fs20 Total}\cell\row
{\*\vrwsct {\BDY231 {\sctrct2745 6357 9495 6588}\keptgr \txthgt \nstlev1 }
\pard\plain\intbl \ql {\f0\fs20 {\*\varref ITEM_CODE\trmblk}}{\f0\fs20 }\cell\pard\plain\intbl \ql {\f0\fs14 {\*\varref DESCRIPTION\trmblk}}{\f0\fs14 }\cell\pard\plain\intbl \qr {\f0\fs20 {\*\varref QUANTITY\pic #,### \trmblk}}{\f0\fs20 }\cell\pard\plain\intbl \qr {\f0\fs20 {\*\varref PRICE\pic 0.00 \trmblk}}{\f0\fs20 }\cell\pard\plain\intbl \qr {\f0\fs20 {\*\varref cost\pic #,##0.00 }}{\f0\fs20 }\cell\row
{\*\vrwsct {\GFT1415 {\sctrct2745 6588 9495 8003}\keptgr \pagbrk \txthgt \nstlev1 {\grpvbllst ORDER_NUMBER}}
\pard\plain\ql {\f0\fs20  }{\*\brdwid20}\brdrt\brdrs\brdrw20\par\pard\plain\ql {\f0\fs20 We thank you for being a }{\b\f0\fs20 sycam's }{\f0\fs20 customer and look forward to serving you again.}\par\pard\plain\qr {\f0\fs20 }\par\pard\plain\qr {\f0\fs20 }\par\pard\plain\qr {\f0\fs20 }
}