asterisk users - Jul 2006 - Determining what gets written to the dst field for a CDR

I have Asterisk set up to write call detail records to MySQL. The number 
written to the dst field is the number dialled by the user including any 
prefix (e.g. 12125554433 where 1 gives an outside line). However this is not 
the number dialled by Asterisk (e.g. in this case Asterisk would drop the 1 
and dial 2125554433). Is it possible to write the CDR record with the number 
dialled by Asterisk rather than that dialled by the user?

Any advice appreciated.

Regards

Cameron

I use CDR(userfield) to store dialed numbers

[call9]
exten => s,2,Set(CDR(userfield)=${number})
exten => s,3,Dial(Zap/2/${number}|40)

[outgoing]
exten => _9.,1,Set(number=${EXTEN:1})
exten => _9.,2,Goto(call9|s|1))

in cdr i have
 | dst |    userfield
 +-----+-----------------
 | s   | ${number}
> I have Asterisk set up to write call detail records to MySQL. The 
> number written to the dst field is the number dialled by the user 
> including any prefix (e.g. 12125554433 where 1 gives an outside line). 
> However this is not the number dialled by Asterisk (e.g. in this case 
> Asterisk would drop the 1 and dial 2125554433). Is it possible to 
> write the CDR record with the number dialled by Asterisk rather than 
> that dialled by the user?
>
> Any advice appreciated.
>
> Regards
>
> Cameron