1> Step 1

require_once(‘app/Mage.php’);
Mage::app()->setCurrentStore(Mage::getModel(‘core/store’)->load(Mage_Core_Model_App::ADMIN_STORE_ID));

$installer = new Mage_Sales_Model_Mysql4_Setup;
$attribute = array(
‘type’ => ‘text’,
‘backend_type’ => ‘text’,
‘frontend_input’ => ‘text’,
‘is_user_defined’ => true,
‘label’ => ‘Amazone Order Id’,
‘visible’ => true,
‘required’ => false,
‘user_defined’ => true,
‘searchable’ => true,
‘filterable’ => true,
‘comparable’ => true,
//’default’ => 0
);
$installer->addAttribute(‘order’, ‘amazoneid’, $attribute);
$installer->endSetup();

2> Step 2

Add this in xml

<amazoneid>
<to_order>*</to_order>
</amazoneid>