How To DTS Import Transaction Database Custom Data to Data Warehouse

A Transaction DTS task does not export to the Datawarehouse database any new fields or new columns that you add to OrderGroup, OrderGroupAddress, OrderFormHeader, or OrderFormLineItems.

There are four Transaction tables where the Transaction DTS locates data. These are OrderGroup, OrderGroupAddress, OrderFormHeader, and OrderFormLineItems.

If you add fields or columns to these tables, Transaction DTS may not recognize them. To export the data in those additional custom columns to the DataWarehouse database, do the following:

1. For a new field in any of the four Transaction tables, add an entry in the TransDimension Table (located in the Commerce transaction database) that has the RequiredDim column set to 1.
   
   For example, if you add a custom column named TaxPercentage to the OrderformHeader table, an entry should be added to the Transdimension table as in the following example:

   DimensionName  FieldName      CategoryName    KeyField RequiredDim
   TaxPercentage  TaxPercentage  OrderFormHeader  0        1
   					

   
   
2. After this change, you can use the Transaction DTS to import data in the custom column TaxPercentage into the Data Warehouse.