Module List > Module SV tables SV00045
You are currently viewing the COMPANY database.
Change

COMPANY..SV00045 Table Definition

(COMPANY..SV_Time_Zone_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Time_Zone_Tag char(5)


Time_Zone_Description char(65)


GMT_Offset_Hours smallint


GMT_Offset_Minutes smallint


Standard_Start_Date_Week smallint


Standard_Start_Date_Day smallint


Standard_Start_Date_Mont smallint


DST_Bias_Hours smallint


DST_Bias_Minutes smallint


DST_Start_Date_Week smallint


DST_Start_Date_Day smallint


DST_Start_Date_Monh smallint


WS_Daylight_Savings_Time tinyint


Bias smallint


Standard_Bias smallint


Standard_Date datetime


Standard_Time datetime


Daylight_Bias smallint


Daylight_Date datetime


Daylight_Time datetime


WSReserved_CB1 tinyint


WSReserved_CB2 tinyint


WSReserved_CB3 tinyint


WSReserved_CB4 tinyint


WSReserved_CB5 tinyint


WSReserved_CB6 tinyint


WSReserved_CB7 tinyint


WSReserved_CB8 tinyint


WSReserved_CB9 tinyint


WSReserved_CB10 tinyint


WSReserved_STR1 char(11)


WSReserved_STR2 char(11)


DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3