Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Created By: Shannon Scoffield
Created Date/Time: 5/22/2014 3:34 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
 
Time Id: 2225
Template/Type: Other Documentation
Title/Caption: Tech - Migrating Data to New Date Fields
Start Date: 10/6/2011
Main Status: Active

click to enlarge - photo by: Shannon Scoffield -
click to enlarge - photo by: Shannon Scoffield -
 


Notes:
Migrating data to new date fields: (On the corp level)
Map to the following fields:
- Customer start date
- Customer end date – use_end_date
- Mapping 1 – Period start date – use_period_start
- Mapping 2 – Period end date – use_period_end
- Mapping 3 – customer_tax_id
- History add date
- Inactive and last history date
- Mapping 1 – Same as history start date or destination date
- Mapping 2 – Check for something in the term or check for a flex grid value
- Mapping 3 – Check for a flex grid value
Export Drilling – In – store
New customer date fields: add to the customers table & add to the corporation table
(See scans in photo gallery on 10/6/11)