Behavior Descriptors for Selectors
Behavior descriptors show NetSuite’s internal logic for returning data using selectors. The following table details behavior descriptors used for selectors.
|
Behavior Descriptor |
Term |
Description |
|
D |
Day |
A day is the smallest unit of time selector calculations. It is a whole calendar day starting at 12 a.m. and ending at 11:59 p.m. For example, if a three days ago selector (D-3) is used at 9:00 a.m. on a Thursday and you use the three days ago selector, the data in the report returns data from Monday from 12:00 a.m. through 11:59 p.m. |
|
W |
Week |
When using week in a selector, reports return data based on what days of the week your week starts and finishes. For example, if your week starts on a Sunday and finishes on Saturday and the one week ago selector (W-1) is used on a Thursday, September 11, 2014 the report will return data beginning on August 31 at 12:00 a.m. through September 6 at 11:59 p.m. In the United States, a week starts on a Sunday. In many parts of the world, a week starts on Monday. |
|
BW |
Business Week |
Business weeks start on a Monday and finish on Sunday and the one business week ago selector (BW-1) is used from a Thursday, September 11, 2014 the report will return data beginning on September 1, 2014 at 12:00 a.m. through September 7, 2014 at 11:59 p.m. |
|
M |
Month |
Months are counted as calendar months not by the amount of days. If you use the last month selector on January 4, 2014, then the report returns data from December 1, 2013 at 12:00 a.m. through December 31, 2013 at 11:59 p.m. For example, if today is January 4 and you want to see one month ago (D M-1), the value returned is December 4. |
|
Q |
Quarter |
When using quarter in a selector, reports return data based on what occurs in three month increments using the standard January-March, April-June, July-September, and October-December. For example, if you use the last quarter (Q-1) selector on a Thursday, August 5, August is in the third quarter so the report returns the second quarter, April 1-June 30. |
|
Y |
Year |
When using year in a selector, years are defined by calendar years. If you use the this year selector on a Thursday, August 5, 2014, the report returns data from the year 2014 from January 1, 2014 at 12:00 a.m. until December 31, 2014 at 11:59 p.m. |
|
FP |
Fiscal Period |
Fiscal periods can defined by any date range. Fiscal periods are used in organizations with additional flexibility to define date ranges for accounting requirements. If you use the last fiscal half selector (6FP-1 FY) on a Thursday, August 5, the report filters data to return all data from the last fiscal half, which is the last six fiscal periods. Typically, organizations define fiscal periods equivalent to calendar months. In this case, the report returns data from February 1 at 12:00 a.m. through July 31 at 11:59 p.m. |
|
FQ |
Fiscal Quarter |
When using fiscal quarter in a selector, fiscal quarters are counted by how your organization defines its fiscal quarters. Fiscal quarters can vary depending on your business preference. For example, if an organization arranges fiscal quarters for May 1-July 31, August 1-October 31, November 1-January 31, and February 1–April 30 and the last fiscal quarter (FQ-1) selector is selected on a Thursday, August 5, which is in the second fiscal quarter, the report filters data to return all data from the first fiscal quarter, May 1–July 31. |
|
FY |
Fiscal Year |
When using fiscal year in a selector, fiscal years are counted by how your organization defines its fiscal year. For example, if you use the last fiscal year (FY-1) selector on a Thursday, August 5, 2014, the report returns the last fiscal year from May 1, 2013 through April 30, 2014. In this case, the business uses a standard calendar as its fiscal year, beginning May 1 and ending April 30. |
For more information about selectors, see Date Range Selectors, Date As Of Selectors, and Period Selectors.