| 19 | 39 | CPROMPT | {Run Every 13 hourofday} | 1 | 1 |
Fulfillment Request;30;nonulls;nocommas;Ground;SecondDay;NextDay;Saturday;FEG;F2D;FES;FEP;49,6 |
'H','COMPANYCODE',' ',' ',' ',shipmethod,' ',' ',(select count(LineItemID) from orderlineitem as t1 where t1.transactionid = Orders.transactionid),' ',date,' ',' ',' ',' ',orders.transactionid,STR( subtotalitems, 10,2),STR( totalamount, 10,2),' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',Company,left( name, CHARINDEX( ' ', name ) ),SUBSTRING( name, CHARINDEX( ' ', name )+1, len( name ) - CHARINDEX( ' ', name )+1 ),address,' ',city,state,zip,country,phone,' ',' ',' ',' ',' ','I',sku,Quantity,OrderLineItem.PriceEA,STR( Quantity*OrderLineItem.PriceEA, 10,2),' ',' ',' '
|
youremail@yourbiz.com;copy@mybiz.com |
2004-08-21 13:12:00.000 | 2004-08-21 13:11:19.000 | 0 | FulFillment Job ran okay |