DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module JC tables JC40702
You are currently viewing the COMPANY database.
Change

COMPANY..JC40702 Table Definition

(COMPANY..JC_Subs_Dates_SETP)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
Record_Sequence smallint
Ins_Cert_on_File tinyint
Lien_Waiver_on_File tinyint
O_M_Manuals tinyint
Payment_Bond tinyint
Performance_Bond tinyint
Ins_Certificate_Reminder tinyint
Lien_Waiver_Reminder tinyint
O_M_Manuals_Reminder tinyint
Payment_Bond_Reminder tinyint
Performance_Bond_Reminde tinyint
Ins_Certificate_Days smallint
Lien_Waiver_Days_Notice smallint
O_M_Manuals_Days smallint
Payment_Bond_Days_Notice smallint
Perform_Bond_Days_Notice smallint
JC_Required_CB_1 tinyint
JC_Required_CB_2 tinyint
JC_Required_CB_3 tinyint
JC_Required_CB_4 tinyint
JC_Required_CB_5 tinyint
JC_Required_CB_6 tinyint
JC_Required_CB_7 tinyint
JC_Required_CB_8 tinyint
JC_Required_CB_9 tinyint
JC_Required_CB_10 tinyint
JC_Required_CB_11 tinyint
JC_Required_CB_12 tinyint
JC_Required_CB_13 tinyint
JC_Required_CB_14 tinyint
JC_Required_CB_15 tinyint
JC_Required_CB_16 tinyint
JC_Required_CB_17 tinyint
JC_Required_CB_18 tinyint
JC_Required_CB_19 tinyint
JC_Required_CB_20 tinyint
JC_Reminder_CB_1 tinyint
JC_Reminder_CB_2 tinyint
JC_Reminder_CB_3 tinyint
JC_Reminder_CB_4 tinyint
JC_Reminder_CB_5 tinyint
JC_Reminder_CB_6 tinyint
JC_Reminder_CB_7 tinyint
JC_Reminder_CB_8 tinyint
JC_Reminder_CB_9 tinyint
JC_Reminder_CB_10 tinyint
JC_Reminder_CB_11 tinyint
JC_Reminder_CB_12 tinyint
JC_Reminder_CB_13 tinyint
JC_Reminder_CB_14 tinyint
JC_Reminder_CB_15 tinyint
JC_Reminder_CB_16 tinyint
JC_Reminder_CB_17 tinyint
JC_Reminder_CB_18 tinyint
JC_Reminder_CB_19 tinyint
JC_Reminder_CB_20 tinyint
JC_Days_Notice_1 smallint
JC_Days_Notice_2 smallint
JC_Days_Notice_3 smallint
JC_Days_Notice_4 smallint
JC_Days_Notice_5 smallint
JC_Days_Notice_6 smallint
JC_Days_Notice_7 smallint
JC_Days_Notice_8 smallint
JC_Days_Notice_9 smallint
JC_Days_Notice_10 smallint
JC_Days_Notice_11 smallint
JC_Days_Notice_12 smallint
JC_Days_Notice_13 smallint
JC_Days_Notice_14 smallint
JC_Days_Notice_15 smallint
JC_Days_Notice_16 smallint
JC_Days_Notice_17 smallint
JC_Days_Notice_18 smallint
JC_Days_Notice_19 smallint
JC_Days_Notice_20 smallint
USERID char(15)

 The user t...(more) Join Now
join ... more text available
User_Define_1 char(31)
User_Define_2 char(31)
USERDEF1 char(21)

 UserDefine...(more) Join Now
USERDEF2 char(21)

 UserDefine...(more) Join Now
User_Defined_CB_1 tinyint
User_Defined_CB_2 tinyint
User_Defined_CB_3 tinyint
User_Defined_CB_4 tinyint
User_Def_Integer_1 int
User_Def_Integer_2 int
User_Defined_Integer_3 int
User_Defined_Integer_4 int
User_Defined_Dollar_1 numeric(19,5)
User_Defined_Dollar_2 numeric(19,5)
User_Defined_Dollar_3 numeric(19,5)
User_Defined_Dollar_4 numeric(19,5)
Wennsoft_Affiliate char(15)
Wennsoft_Branch char(15)
Wennsoft_Region char(15)
MODIFDT datetime

 Date the r...(more) Join Now
Modified_Time datetime
MDFUSRID char(15)

 User that ...(more) Join Now
join ... more text available
SV_Language_ID smallint
Time_Zone char(3)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 tinyint
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3