I was working on capturing transaction summary data for use later in trending reports. A colleague of mine mentioned incorporating a date dimension table to save having to do all the complicated date calculations on the fly. This was a great idea, but not so simple to implement in NetSuite.
In short, a date dimension table is a series of rows, each representing a day. Corresponding columns represent date associations, like start of week, day in week, start of month, day in month, start and end of quarter, start and end of fiscal year, day suffix, etc. It’s extremely handy when looking back on the first of the month to say, what is the start and end dates of this week, month, year, fiscal year, etc. My end result was a series of Map/Reduce Suitescripts that wake up on start of month, quarter or year and capture summary data for the period that just ended. Once I had the dimDate table, the rest was easy.
To build my dimDate table, I started with the article my colleague sent me which builds one from a script in Microsoft SQL Server. Rather than translate this to JavaScript and run it in SuiteScript, I opted to run it and export the result. Then I created a custom record type (table) in NetSuite called dimDate with matching fields. I’ll include the definition of that table as saved via SuiteCloud Developer Framework (SDF). I’ll also include the script I used to create my dimDate data (in MS SQL Server).
Here is the original article that describes the dimDate table. https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/
This is what you’ll be building in NetSuite.
This is the definition you’ll be importing. It’s a custom record type called dimDate.
Here is the Transact SQL code used to create my dimDate table. It uses October 1st as the start of the fiscal year. It starts on January 1st, 1999 and builds rows that represent all days for 40 years.
-- Run this in a sql server 2012 or higher
-- Export to CSV using the SQL Mgmt Studio Export feature (Right click on DB and Export)
-- Don't open this with Excel, or the date formats in the first 4 fields will be screwed up
DROP table DimDate;
DECLARE @StartDate date = '19990101';
DECLARE @CutoffDate date = DATEADD(DAY, -1, DATEADD(YEAR, 40, @StartDate));
;WITH seq(n) AS
(
SELECT 0 UNION ALL SELECT n + 1 FROM seq
WHERE n < DATEDIFF(DAY, @StartDate, @CutoffDate)
),
d(d) AS
(
SELECT DATEADD(DAY, n, @StartDate) FROM seq
),
src AS
(
SELECT
Date = CONVERT(date, d),
Day = DATEPART(DAY, d),
DayName = DATENAME(WEEKDAY, d),
Week = DATEPART(WEEK, d),
FiscalWeek = DATEPART(WEEK, DATEADD(MONTH, -9, d)),
DayOfWeek = DATEPART(WEEKDAY, d),
Month = DATEPART(MONTH, d),
FiscalMonth = DATEPART(MONTH, DATEADD(MONTH, -9, d)),
MonthName = DATENAME(MONTH, d),
Quarter = DATEPART(Quarter, d),
FiscalQuarter = DATEPART(Quarter, DATEADD(MONTH, -9, d)),
Year = DATEPART(YEAR, d),
FiscalYear = DATEPART(YEAR, DATEADD(MONTH, -9, d)),
FirstOfMonth = CONVERT(varchar, DATEFROMPARTS(YEAR(d), MONTH(d), 1), 101),
LastOfYear = CONVERT(varchar, DATEFROMPARTS(YEAR(d), 12, 31), 101),
FiscalLastOfYear = CONVERT(varchar, DATEFROMPARTS(DATEPART(YEAR, DATEADD(MONTH, -9, d)), 9, 30), 101),
DayOfYear = DATEPART(DAYOFYEAR, d),
FiscalDayOfYear = DATEPART(DAYOFYEAR, DATEADD(MONTH, -9, d))
FROM d
),
dim AS
(
SELECT
DateKey = CAST(CONVERT(char(8), Date, 112) as varchar),
ExternalID = CAST(CONVERT(char(8), Date, 112) as varchar),
Date = CAST(CONVERT(varchar,Date, 101) as varchar),
LongDate = CAST(CONVERT(varchar(20), Date, 101) as varchar),
ShortDate = CAST(DATEPART(MONTH, Date) as varchar) + '/' + cast(DATEPART(DAY, Date) as varchar) + '/' + CAST(YEAR(Date) as varchar),
SortDate = CAST(CONVERT(char(10), Date, 120) as varchar),
Day,
DaySuffix = cast(Day as varchar(10)) + CONVERT(char(2), CASE WHEN Day / 10 = 1 THEN 'th' ELSE
CASE RIGHT(Day, 1) WHEN '1' THEN 'st' WHEN '2' THEN 'nd'
WHEN '3' THEN 'rd' ELSE 'th' END END),
DayName,
DayOfWeek,
DayOfWeekInMonth = CONVERT(tinyint, ROW_NUMBER() OVER
(PARTITION BY FirstOfMonth, DayOfWeek ORDER BY Date)),
DayOfYear,
FiscalDayOfYear,
IsWeekend = CASE WHEN DayOfWeek IN (CASE @@DATEFIRST WHEN 1 THEN 6 WHEN 7 THEN 1 END,7)
THEN 1 ELSE 0 END,
Week,
FiscalWeek,
FirstOfWeek = CONVERT(varchar, DATEADD(DAY, 1 - DayOfWeek, Date), 101),
LastOfWeek = CONVERT(varchar, DATEADD(DAY, 6, DATEADD(DAY, 1 - DayOfWeek, Date)), 101),
WeekOfMonth = CONVERT(tinyint, DENSE_RANK() OVER
(PARTITION BY Year, Month ORDER BY Week)),
Month,
MonthName,
FirstOfMonth,
LastOfMonth = CONVERT(varchar, MAX(Date) OVER (PARTITION BY Year, Month), 101),
FirstOfNextMonth = CONVERT(varchar, DATEADD(MONTH, 1, FirstOfMonth), 101),
LastOfNextMonth = CONVERT(varchar, DATEADD(DAY, -1, DATEADD(MONTH, 2, FirstOfMonth)), 101),
Quarter,
FiscalQuarter,
FirstOfQuarter = CONVERT(varchar, MIN(Date) OVER (PARTITION BY Year, Quarter), 101),
LastOfQuarter = CONVERT(varchar, MAX(Date) OVER (PARTITION BY Year, Quarter), 101),
FiscalFirstOfQuarter = CONVERT(varchar, MIN(Date) OVER (PARTITION BY Year, FiscalQuarter), 101),
FiscalLastOfQuarter = CONVERT(varchar, MAX(Date) OVER (PARTITION BY Year, FiscalQuarter), 101),
Year,
FiscalYear,
FirstOfYear = CONVERT(varchar, DATEFROMPARTS([Year], 1, 1), 101),
LastOfYear,
FiscalFirstOfYear = CONVERT(varchar, DATEFROMPARTS(FiscalYear, 10, 1), 101),
FiscalLastOfYear,
IsLeapYear = CASE when CONVERT(bit, CASE WHEN (Year % 400 = 0)
OR (Year % 4 = 0 AND Year % 100 <> 0)
THEN 1 ELSE 0 END) = 1 then 'T' else 'F' end,
Has53Weeks = CASE WHEN DATEPART(WEEK, LastOfYear) = 53 THEN 'T' ELSE 'F' END,
MMYYYY = CONVERT(char(2), CONVERT(char(8), Date, 101))
+ CONVERT(char(4), Year)
FROM src
)
SELECT *
INTO dimDate
FROM dim
ORDER BY Date
OPTION (MAXRECURSION 0)
Here is the dimDate table definition saved via SuiteCloud Developer Framework. It’s huge. Sorry!
<customrecordtype scriptid="customrecord_logic_dimdate">
<accesstype>CUSTRECORDENTRYPERM</accesstype>
<allowattachments>F</allowattachments>
<allowinlinedeleting>F</allowinlinedeleting>
<allowinlinedetaching>F</allowinlinedetaching>
<allowinlineediting>F</allowinlineediting>
<allowmobileaccess>F</allowmobileaccess>
<allownumberingoverride>F</allownumberingoverride>
<allowquickadd>F</allowquickadd>
<allowquicksearch>F</allowquicksearch>
<allowuiaccess>T</allowuiaccess>
<description></description>
<enabledle>T</enabledle>
<enablekeywords>F</enablekeywords>
<enablemailmerge>F</enablemailmerge>
<enablenametranslation>F</enablenametranslation>
<enablenumbering>F</enablenumbering>
<enableoptimisticlocking>T</enableoptimisticlocking>
<enablesystemnotes>F</enablesystemnotes>
<hierarchical>F</hierarchical>
<icon></icon>
<iconbuiltin>T</iconbuiltin>
<iconindex>30</iconindex>
<includeinsearchmenu>F</includeinsearchmenu>
<includename>F</includename>
<isinactive>F</isinactive>
<isordered>F</isordered>
<numberinginit></numberinginit>
<numberingmindigits></numberingmindigits>
<numberingprefix></numberingprefix>
<numberingsuffix></numberingsuffix>
<recordname>dimDate Table</recordname>
<showcreationdate>F</showcreationdate>
<showcreationdateonlist>F</showcreationdateonlist>
<showid>F</showid>
<showlastmodified>F</showlastmodified>
<showlastmodifiedonlist>F</showlastmodifiedonlist>
<shownotes>F</shownotes>
<showowner>F</showowner>
<showownerallowchange>F</showownerallowchange>
<showowneronlist>F</showowneronlist>
<customrecordcustomfields>
<customrecordcustomfield scriptid="custrecord_dimdate_datekey">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>TEXT</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>DateKey</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_date">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>Date</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_longdate">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>TEXT</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>LongDate</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_shortdate">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>TEXT</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>ShortDate</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_sortdate">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>TEXT</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>SortDate</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_day">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>Day</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_daysuffix">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>TEXT</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>DaySuffix</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_dayname">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>TEXT</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>DayName</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_dayofweek">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>DayOfWeek</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_dayofweekinmonth">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>DayOfWeekInMonth</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_dayofyear">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>DayOfYear</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_fiscaldayofyear">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FiscalDayOfYear</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_isweekend">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>IsWeekend</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_week">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>Week</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_fiscalweek">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FiscalWeek</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_firstofweek">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FirstOfWeek</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_lastofweek">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>LastOfWeek</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_weekofmonth">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>WeekOfMonth</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_month">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>Month</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_monthname">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>TEXT</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>MonthName</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_firstofmonth">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FirstOfMonth</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_lastofmonth">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>LastOfMonth</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_firstofnextmonth">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FirstOfNextMonth</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_lastofnextmonth">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>LastOfNextMonth</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_quarter">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>Quarter</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_fiscalquarter">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FiscalQuarter</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_firstofquarter">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FirstOfQuarter</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_lastofquarter">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>LastOfQuarter</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_fiscalfirstofquarter">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FiscalFirstOfQuarter</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_fiscallastofquarter">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FiscalLastOfQuarter</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_year">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>Year</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_fiscalyear">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>T</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>INTEGER</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FiscalYear</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>T</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_firstofyear">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FirstOfYear</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_lastofyear">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>LastOfYear</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_fiscalfirstofyear">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FiscalFirstOfYear</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_fiscallastofyear">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>DATE</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>FiscalLastOfYear</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_isleapyear">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>CHECKBOX</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>IsLeapYear</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_has53weeks">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>CHECKBOX</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>Has53Weeks</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
<customrecordcustomfield scriptid="custrecord_dimdate_mmyyyy">
<accesslevel>2</accesslevel>
<allowquickadd>F</allowquickadd>
<applyformatting>F</applyformatting>
<checkspelling>F</checkspelling>
<defaultchecked>F</defaultchecked>
<defaultselection></defaultselection>
<defaultvalue></defaultvalue>
<description></description>
<displayheight></displayheight>
<displaytype>NORMAL</displaytype>
<displaywidth></displaywidth>
<dynamicdefault></dynamicdefault>
<encryptatrest>F</encryptatrest>
<fieldtype>TEXT</fieldtype>
<globalsearch>F</globalsearch>
<help></help>
<isformula>F</isformula>
<ismandatory>F</ismandatory>
<isparent>F</isparent>
<label>MMYYYY</label>
<linktext></linktext>
<maxlength></maxlength>
<maxvalue></maxvalue>
<minvalue></minvalue>
<onparentdelete></onparentdelete>
<parentsubtab></parentsubtab>
<rolerestrict>F</rolerestrict>
<searchcomparefield></searchcomparefield>
<searchdefault></searchdefault>
<searchlevel>2</searchlevel>
<selectrecordtype></selectrecordtype>
<showinlist>F</showinlist>
<sourcefilterby></sourcefilterby>
<sourcefrom></sourcefrom>
<sourcelist></sourcelist>
<storevalue>T</storevalue>
<subtab></subtab>
</customrecordcustomfield>
</customrecordcustomfields>
</customrecordtype>
NetSuite Experiences 