What Does Origin ID Show on the Sales Order?

Origin ID can be used in reports, Order Manager, and queries to see who created the Order. See below for more details.

OriginID can be found in tbOrders and used for various reports or queries to help identify who created the Sales Order. Origin ID shows the ID of who created the Customer Sales Order. Origin ID is based on the Origin Type. Origin Type is how the order was created. See the table below to determine what Origin ID is used for each Origin Type in the Orders table. 


Origin Type Code Origin Type  Origin ID
M Manual Entry  ID of the user who created the order
E EDI  Trading Partner ID
W Web Store Integration  Web Store Template ID
I Import/Sales Order Import Import Template ID
Q QuickBooks Order Migration during Create Company N/A. Origin ID is blank