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

COMPANY..sv00196 Table Definition

(COMPANY..SV_Setup2_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Record smallint


DATE1 datetime

Field Type...(more) Join Now
WS_Time_1 datetime


Timeup smallint


Postal_Group smallint


Meter_Group smallint


Meter_Checkbox tinyint


Wennbox1 tinyint


Wennbox2 tinyint


Wenngroup1 smallint


Wenngroup2 smallint


Wennsoft_Affiliate char(15)


Wennsoft_Branch char(15)


Wennsoft_Region char(15)


Service_Option_Box_1 tinyint


Service_Option_Box_10 tinyint


Service_Option_Box_11 tinyint


Service_Option_Box_12 tinyint


Service_Option_Box_13 tinyint


Service_Option_Box_14 tinyint


Service_Option_Box_15 tinyint


Service_Option_Box_16 tinyint


Service_Option_Box_17 tinyint


Service_Option_Box_18 tinyint


Service_Option_Box_19 tinyint


Service_Option_Box_2 tinyint


Service_Option_Box_20 tinyint


Service_Option_Box_21 tinyint


Service_Option_Box_22 tinyint


Service_Option_Box_23 tinyint


Service_Option_Box_24 tinyint


Service_Option_Box_25 tinyint


Service_Option_Box_26 tinyint


Service_Option_Box_27 tinyint


Service_Option_Box_28 tinyint


Service_Option_Box_29 tinyint


Service_Option_Box_3 tinyint


Service_Option_Box_30 tinyint


Service_Option_Box_31 tinyint


Service_Option_Box_32 tinyint


Service_Option_Box_33 tinyint


Service_Option_Box_34 tinyint


Service_Option_Box_35 tinyint


Service_Option_Box_36 tinyint


Service_Option_Box_37 tinyint


Service_Option_Box_38 tinyint


Service_Option_Box_39 tinyint


Service_Option_Box_4 tinyint


Service_Option_Box_40 tinyint


Service_Option_Box_41 tinyint


Service_Option_Box_42 tinyint


Service_Option_Box_43 tinyint


Service_Option_Box_44 tinyint


Service_Option_Box_45 tinyint


Service_Option_Box_46 tinyint


Service_Option_Box_47 tinyint


Service_Option_Box_48 tinyint


Service_Option_Box_49 tinyint


Service_Option_Box_5 tinyint


Service_Option_Box_50 tinyint


Service_Option_Box_6 tinyint

Invoice wi...(more) Join Now
Service_Option_Box_7 tinyint


Service_Option_Box_8 tinyint


Service_Option_Box_9 tinyint


Service_Option_Group_51 smallint


Service_Option_Group_52 smallint


Service_Option_Group_53 smallint


Service_Option_Group_54 smallint


Service_Option_Group_55 smallint

Use Stop-a...(more) Join Now
Service_Option_Group_56 smallint


Service_Option_Group_57 smallint


Service_Option_Group_58 smallint


Service_Option_Group_59 smallint


Service_Option_Group_60 smallint


Service_Option_Group_61 smallint


Service_Option_Group_62 smallint


Service_Option_Group_63 smallint


Service_Option_Group_64 smallint


Service_Option_Group_65 smallint


Service_Option_Group_66 smallint


Service_Option_Group_67 smallint


Service_Option_Group_68 smallint


Service_Option_Group_69 smallint


Service_Option_Group_70 smallint


Service_User_Define_1 char(21)


Service_User_Define_2 char(21)


Service_User_Define_3 char(31)


Service_User_Define_4 char(31)


Service_User_Define_5 int


Service_User_Define_6 int


Service_User_Define_7 int


Service_User_Define_8 int


Service_User_Define_9 datetime


Service_User_Define_10 datetime


Service_User_Define_11 datetime


Service_User_Define_12 datetime


Service_User_Define_18 tinyint


Service_User_Define_19 tinyint


Service_User_Define_20 tinyint


Service_User_Define_21 tinyint


Service_User_Define_22 numeric(19,5)


Service_User_Define_23 numeric(19,5)


Service_User_Define_24 numeric(19,5)


Service_User_Define_25 numeric(19,5)


MODIFDT datetime

Date the r...(more) Join Now
Modified_Time datetime


MDFUSRID char(15)

User that ...(more) Join Now
join ... more text available
Time_Zone char(3)


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