fiscal_period

«Fiscal period» / Global (global)

Table Details

Name:
fiscal_period
Label:
Fiscal period (en)
Created On:
2022.12.30 11:39:21
Created By:
admin
Updated On:
2022.12.30 11:39:20
Updated By:
admin
Column Updated On:
2022.12.30 11:39:21
Column Updated By:
admin
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  all_day
 All day boolean 40 Global cmn_schedule_span
 
M
calendar
 Calendar reference 32 Global business_calendar business_calendar_span
  counter
 Counter integer 40 Global business_calendar_span
  days_of_week
 Repeat on days_of_week 40 Global cmn_schedule_span
 
M
end
 End calendar_date_time 40 Global business_calendar_span
  end_date_time
 End date time schedule_date_time 40 Global cmn_schedule_span
  fiscal_end_date_time
 Fiscal end date time glide_date_time 40 Global fiscal_period
  fiscal_start_date_time
 Fiscal start date time glide_date_time 40 Global fiscal_period
  fiscal_type
 Fiscal Type string[choice] 40 Global fiscal_period
  fiscal_year
 Fiscal Year reference 32 Global fiscal_period fiscal_period
  float_day
 Float day string[choice] 40 Global cmn_schedule_span
  float_week
 Float week string[choice] 40 Global cmn_schedule_span
  group
 Group reference 32 Global sys_user_group cmn_schedule_span
  index0
 Index0 integer 40 Global business_calendar_span
  index1
 Index1 integer 40 Global business_calendar_span
  index2
 Index2 integer 40 Global business_calendar_span
  index3
 Index3 integer 40 Global business_calendar_span
  index4
 Index4 integer 40 Global business_calendar_span
  index5
 Index5 integer 40 Global business_calendar_span
  index6
 Index6 integer 40 Global business_calendar_span
  index7
 Index7 integer 40 Global business_calendar_span
  index8
 Index8 integer 40 Global business_calendar_span
  index9
 Index9 integer 40 Global business_calendar_span
  month
 Month month_of_year 40 Global cmn_schedule_span
  monthly_type
 Monthly type string[choice] 40 Global cmn_schedule_span
 
D
name
 Name string 80 Global cmn_schedule_span
  notes
 Notes string 1000 Global cmn_schedule_span
  open
 Open boolean 40 Global fiscal_period
  override_start_date
 Overridden Start Date integer_date 40 Global cmn_schedule_span
  parent
 Overridden Item reference 32 Global cmn_schedule_span cmn_schedule_span
  parent_period
 Parent Period reference 32 Global fiscal_period fiscal_period
  repeat_count
 Repeat every repeat_count 40 Global cmn_schedule_span
  repeat_type
 Repeats repeat_type[choice] 40 Global cmn_schedule_span
  repeat_until
 Repeat until integer_date 40 Global cmn_schedule_span
  schedule
 Schedule reference 32 Global cmn_schedule cmn_schedule_span
  show_as
 Show as string[choice] 40 Global cmn_schedule_span
 
M
D
span_name
 Name reference 32 Global business_calendar_span_name business_calendar_span
 
M
start
 Start calendar_date_time 40 Global business_calendar_span
  start_date_time
 Start date time schedule_date_time 40 Global cmn_schedule_span
  sys_class_name
 Class sys_class_name[choice] 80 Global business_calendar_span
  sys_created_by
 Created by string 40 Global business_calendar_span
  sys_created_on
 Created glide_date_time 40 Global business_calendar_span
 
K
sys_id
 Sys ID GUID 32 Global fiscal_period
  sys_mod_count
 Updates integer 40 Global business_calendar_span
  sys_updated_by
 Updated by string 40 Global business_calendar_span
  sys_updated_on
 Updated glide_date_time 40 Global business_calendar_span
  type
 Type string[choice] 40 Global cmn_schedule_span
  user
 User reference 32 Global sys_user cmn_schedule_span
  yearly_type
 Yearly type string[choice] 40 Global cmn_schedule_span
P
 Passive
M
 Mandatory
D
 Display Value
K
 Key
U
 Unique
X
 Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Washington Tokyo (Vanilla) Tokyo
fiscal_end_date_time missing missing missing
fiscal_start_date_time missing missing missing
fiscal_type missing missing missing
fiscal_year missing missing missing
open missing missing missing
parent_period missing missing missing

Referenced

business_calendar_span referenced from table:
sn_gf_core_goal, sn_gf_strategy
cmn_schedule_span referenced from table:
cmn_schedule_span, mtg_meeting
fiscal_period referenced from table:
apm_app_indicator_score, apm_app_score, fiscal_period, goal
×

Diagram fiscal_period  «Fiscal period» / Global (global)

Download PDFDownload PNGDownload DrawIO Download PDFDownload PNGDownload DrawIO
shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out