Page 1 of 1
What is the Exported bit field in the Orders table?
Posted: Mon Nov 09, 2009 11:53 am
by Mike718NY
Is the Exported bit field in the Orders table used for anything?
I could really use that field for something else.
Could I safely use it for another purpose?
Re: What is the Exported bit field in the Orders table?
Posted: Tue Nov 10, 2009 7:48 am
by Mike718NY
I can't find any documentation on this. Anyone know what it is?
Re: What is the Exported bit field in the Orders table?
Posted: Tue Nov 10, 2009 10:46 am
by nickc
I've been using to flag orders after they are pushed to my fulfiller. Don't know if Able has ever implemented the field; I'm using an older build. In my world, my app is the only thing that touches it.
Re: What is the Exported bit field in the Orders table?
Posted: Tue Nov 10, 2009 10:53 am
by Mike718NY
Thanks Nick.
Do you think this is related to the Data Port? Where else would an order be "exported" to?
Re: What is the Exported bit field in the Orders table?
Posted: Tue Nov 10, 2009 11:28 am
by nickc
That would be one possibility. I think how I'm using is more likely - the field implies a reason to persist the status; i.e. once an order is exported, you don't want to be able to export it a second time. Dataport is a more generic tool - you might be exporting for reporting purposes, in which case you would want to be able to export an order over and over.
Re: What is the Exported bit field in the Orders table?
Posted: Thu Nov 19, 2009 7:24 am
by AbleMods
Able does not use this field.
I use it in my Quickbooks module to mark which orders have been pushed to Quickbooks.
Re: What is the Exported bit field in the Orders table?
Posted: Thu Nov 19, 2009 11:59 am
by Mike718NY
I wish there were a few more of these "un-used" fields.
It would make customizations a lot easier.
Should add a few more in Products, Orders, and OrderItems.
I guess they are not needed in Products because of custom fields,
but definately in Orders and OrderItems.
Re: What is the Exported bit field in the Orders table?
Posted: Thu Nov 19, 2009 1:00 pm
by AbleMods
LineMessage in orderitems is unused.
Re: What is the Exported bit field in the Orders table?
Posted: Thu Nov 19, 2009 1:18 pm
by Mike718NY
thanks . . I'll take it!
Re: What is the Exported bit field in the Orders table?
Posted: Thu Nov 19, 2009 1:20 pm
by AbleMods
AbleMods wrote:LineMessage in orderitems is unused.
The nice thing about it is it's also in the basket class. That means you can use it pre-checkout to store something and it'll pass unmodified all the way through to the order post-checkout.