GP Tables
Home
Modules
Fields
Query Builder
Home
/
WennSoft Job Cost
/
JC41102
JC41102 - JC_Setup_Custom_Options
SQL Query Builder
Reset Joins
Copy
SELECT * FROM JC41102
78 Columns
Select all
Column
Description
Type
Length
Shared With
Record
smallint
21 tables
WS_Setup_CB_1
tinyint
-
WS_Setup_CB_2
tinyint
-
WS_Setup_CB_3
tinyint
-
WS_Setup_CB_4
tinyint
-
WS_Setup_CB_5
tinyint
-
WS_Setup_CB_6
tinyint
-
WS_Setup_CB_7
tinyint
-
WS_Setup_CB_8
tinyint
-
WS_Setup_CB_9
tinyint
-
WS_Setup_CB_10
tinyint
-
WS_Setup_CB_11
tinyint
-
WS_Setup_CB_12
tinyint
-
WS_Setup_CB_13
tinyint
-
WS_Setup_CB_14
tinyint
-
WS_Setup_CB_15
tinyint
-
WS_Setup_CB_16
tinyint
-
WS_Setup_CB_17
tinyint
-
WS_Setup_CB_18
tinyint
-
WS_Setup_CB_19
tinyint
-
WS_Setup_CB_20
tinyint
-
WS_Setup_RG_1
smallint
-
WS_Setup_RG_2
smallint
-
WS_Setup_RG_3
smallint
-
WS_Setup_RG_4
smallint
-
WS_Setup_RG_5
smallint
-
WS_Setup_RG_6
smallint
-
WS_Setup_RG_7
smallint
-
WS_Setup_RG_8
smallint
-
WS_Setup_RG_9
smallint
-
WS_Setup_RG_10
smallint
-
WS_Setup_Date_1
datetime
-
WS_Setup_Date_2
datetime
-
WS_Setup_Date_3
datetime
-
WS_Setup_Date_4
datetime
-
WS_Setup_Date_5
datetime
-
WS_Setup_Long_1
int
-
WS_Setup_Long_2
int
-
WS_Setup_Long_3
int
-
WS_Setup_Long_4
int
-
WS_Setup_Long_5
int
-
WS_Setup_Long_6
int
-
WS_Setup_Long_7
int
-
WS_Setup_Long_8
int
-
WS_Setup_Long_9
int
-
WS_Setup_Long_10
int
-
WS_Setup_String20_1
char(21)
-
WS_Setup_String20_2
char(21)
-
WS_Setup_String20_3
char(21)
-
WS_Setup_String20_4
char(21)
-
WS_Setup_String20_5
char(21)
-
WS_Setup_String50_1
char(51)
-
WS_Setup_String50_2
char(51)
-
WS_Setup_String50_3
char(51)
-
WS_Setup_String50_4
char(51)
-
WS_Setup_String50_5
char(51)
-
WS_Setup_String50_6
char(51)
-
WS_Setup_String50_7
char(51)
-
WS_Setup_String50_8
char(51)
-
WS_Setup_String50_9
char(51)
-
WS_Setup_String50_10
char(51)
-
WS_Setup_String100_1
char(101)
-
WS_Setup_String100_2
char(101)
-
WS_Setup_String100_3
char(101)
-
WS_Setup_String100_4
char(101)
-
WS_Setup_String100_5
char(101)
-
WS_Setup_String254_1
char(255)
-
WS_Setup_String254_2
char(255)
-
WS_Setup_String254_3
char(255)
-
WS_Setup_String254_4
char(255)
-
WS_Setup_String254_5
char(255)
-
WS_Setup_String254_6
char(255)
-
WS_Setup_String254_7
char(255)
-
WS_Setup_String254_8
char(255)
-
WS_Setup_String254_9
char(255)
-
WS_Setup_String254_10
char(255)
-
DEX_ROW_ID
int auto number (1,1)
608 tables
WS_Setup_Text
text
-
Related Tables
Tables that share columns with JC41102. Click "Join" to add to your query.
DEX_ROW_ID
AAG00200
Join
AAG00201
Join
AAG00202
Join
AAG00300
Join
AAG00301
Join
AAG00302
Join
ACColumn
Join
AF00100
Join
APR_APR30000
Join
APR_APR30300
Join
APR_BLM42100
Join
APR_BLM42101
Join
APR_DIA30100
Join
CAM10000
Join
CAM30000
Join
CAM30100
Join
CAM40001
Join
CAM40003
Join
CAM40004
Join
CAM40005
Join
CFM00100
Join
CFM00101
Join
CO00101
Join
CO00102
Join
CO07260
Join
CO40100
Join
DTA10100
Join
DTA10200
Join
EDCEI003
Join
EDCEI004
Join
EDCEI005
Join
EDCEI008
Join
EDCEI010
Join
EDCEI013
Join
EDCEI015
Join
EDCEI017
Join
EDCEI018
Join
EDCML001
Join
EDCML002
Join
EDCML003
Join
EDCML004
Join
EDCML005
Join
EDCML006
Join
EDCML008
Join
ENC10110
Join
ENC10111
Join
ENC10310V
Join
ENC10500
Join
ENC40000
Join
ENC40100
Join
ENC40200
Join
ENCAA10110
Join
FA00199
Join
FA00300
Join
FA00400
Join
FA00500
Join
FA00600
Join
FA00700
Join
FA00701
Join
GL00100
Join
GL00102
Join
GL00105
Join
GL10001
Join
GL10110
Join
GL10111
Join
GL20000
Join
GL30000
Join
GL40200
Join
IV00106
Join
IV00107
Join
IV00108
Join
IV00200
Join
IV00300
Join
IV10000
Join
IV10001
Join
IV10200
Join
IV10201
Join
IV30101
Join
IV30200
Join
IV30300
Join
IV40202
Join
IV40700
Join
IVC30100
Join
IVC30102
Join
IVC40100
Join
IVC40101
Join
MC00200
Join
ME123501
Join
ME123502
Join
ME123503
Join
ME123504
Join
ME123506
Join
ME123515
Join
ME123516
Join
ME142801
Join
ME142804
Join
ME142807
Join
ME142808
Join
ME142809
Join
ME142811
Join
ME142812
Join
ME142813
Join
ME142814
Join
ME142815
Join
ME142818
Join
ME27607
Join
ML00001
Join
MinPONum
Join
PM80100
Join
PP000001
Join
PP000002
Join
PP000011
Join
RVLPD001
Join
RVLPD002
Join
RVLPD003
Join
RVLPD004
Join
RVLPD005
Join
RVLPD006
Join
RVLPD007
Join
RVLPD008
Join
RVLPD009
Join
RVLPD010
Join
RVLPD011
Join
RVLPD012
Join
RVLPD013
Join
RVLPD014
Join
RVLPD015
Join
ReportCatalog
Join
ReportCatalogPending
Join
ReportCenters
Join
ReportCentersPending
Join
ReportErrorLog
Join
ReportInternalNames
Join
ReportPublishers
Join
ReportRolesPending
Join
ReportSchedule
Join
ReportUserPrefs
Join
SOP10101
Join
SOP10102
Join
SOP10103
Join
SOP10104
Join
SOP10105
Join
SOP10106
Join
JC00102
Join
JC00103
Join
JC00104
Join
JC00105
Join
JC00106
Join
JC00107
Join
JC00201
Join
JC00203
Join
JC00301
Join
JC00401
Join
JC00501
Join
JC00600
Join
JC00601
Join
JC00701
Join
JC00702
Join
JC00801
Join
JC00901
Join
JC01001
Join
JC01002
Join
JC01003
Join
JC01101
Join
JC01102
Join
JC01201
Join
JC01301
Join
JC01401
Join
JC01501
Join
JC01502
Join
JC01503
Join
JC01504
Join
JC01505
Join
JC01511
Join
JC01513
Join
JC01514
Join
JC001520
Join
JC01519
Join
JC01601
Join
JC01701
Join
JC01801
Join
JC01802
Join
JC10201
Join
JC10301
Join
JC10302
Join
JC10500
Join
JC10501
Join
JC10503
Join
JC10504
Join
JC10506
Join
JC10511
Join
JC10512
Join
JC10513
Join
JC10514
Join
JC10701
Join
JC10703
Join
JC10801
Join
JC10802
Join
JC10901
Join
JC10902
Join
JC20002
Join
JC20003
Join
JC20004
Join
JC20005
Join
JC20101
Join
JC20301
Join
JC20401
Join
JC20501
Join
JC20502
Join
JC20503
Join
JC20504
Join
JC20511
Join
JC20601
Join
JC20705
Join
JC20801
Join
JC20902
Join
JC30001
Join
JC30001L
Join
JC30002
Join
JC30003
Join
JC30004
Join
JC30006
Join
JC30101
Join
JC30102
Join
JC30107
Join
JC30202
Join
JC30301
Join
JC30401
Join
JC30501
Join
JC30502
Join
JC30503
Join
JC30504
Join
JC30511
Join
JC30601
Join
JC30701
Join
JC30210
Join
JC30801
Join
JC31001
Join
JC31002
Join
JC31201
Join
JC40101
Join
JC40102
Join
JC40103
Join
JC40104
Join
JC40105
Join
JC40106
Join
JC40107
Join
JC40201
Join
JC40202
Join
JC40203
Join
JC40204
Join
JC40205
Join
JC40206
Join
JC40207
Join
JC40208
Join
JC40209
Join
JC40301
Join
JC40302
Join
JC40303
Join
JC40304
Join
JC40305
Join
JC40306
Join
JC40307
Join
JC40308
Join
JC40401
Join
JC40501
Join
JC40502
Join
JC40503
Join
JC40601
Join
JC40602
Join
JC40603
Join
JC40701
Join
JC40702
Join
JC40703
Join
JC40711
Join
JC40801
Join
JC40901
Join
JC41101
Join
JC41103
Join
JC41201
Join
JC50101
Join
JC50201
Join
JC70001
Join
JC0CHECK
Join
JC10001L
Join
JC10211
Join
JCCIS150
Join
JCCIS200
Join
JCCIS201
Join
JCERRORS
Join
JCPCHECK
Join
JCRFP100
Join
JCRFP300
Join
JCVAT150
Join
SV00AD1
Join
SV00010
Join
SV00012
Join
SV00015
Join
SV00021
Join
SV00030
Join
SV00032
Join
SV00033
Join
SV00034
Join
SV00040
Join
SV00045
Join
SV00053
Join
SV00054
Join
SV00055
Join
SV00077
Join
SV00099
Join
SV00100
Join
SV00101
Join
SV00105
Join
SV00110
Join
SV00114
Join
SV00115
Join
SV00116
Join
SV00117
Join
SV00118
Join
SV00119
Join
SV00120
Join
SV00130
Join
SV00131
Join
SV00132
Join
SV00142
Join
SV00143
Join
SV00144
Join
SV00145
Join
SV00148
Join
SV00149
Join
SV00150
Join
SV00155
Join
SV00160
Join
SV00165
Join
SV00166
Join
SV00167
Join
SV00196
Join
SV00197
Join
SV00198
Join
SV00199
Join
SV00200
Join
SV00201
Join
SV00205
Join
SV00215
Join
SV00220
Join
SV00221
Join
SV00225
Join
SV00230
Join
SV00300
Join
SV00301
Join
SV00302
Join
SV00303
Join
SV00304
Join
SV00305
Join
SV00306
Join
SV00307
Join
SV00308
Join
SV00309
Join
SV00310
Join
SV00311
Join
SV00312
Join
SV00314
Join
SV00315
Join
SV00320
Join
SV00324
Join
SV00325
Join
SV00326
Join
SV00330
Join
SV00331
Join
SV00340
Join
SV00351
Join
SV00360
Join
SV00361
Join
SV00362
Join
SV00370
Join
SV00387
Join
SV00392
Join
SV00393
Join
SV00394
Join
SV00400
Join
SV00401
Join
SV00402
Join
SV00403
Join
SV00405
Join
SV00406
Join
SV00410
Join
SV00411
Join
SV00420
Join
SV00425
Join
SV00430
Join
SV00460
Join
SV00470
Join
SV00480
Join
SV00490
Join
SV00500
Join
SV00501
Join
SV00502
Join
SV00503
Join
SV00504
Join
SV00505
Join
SV00506
Join
SV00507
Join
SV00508
Join
SV00509
Join
SV00510
Join
SV00511
Join
SV00512
Join
SV00514
Join
SV00515
Join
SV00517
Join
SV00519
Join
SV00520
Join
SV00521
Join
SV00522
Join
SV00523
Join
SV00524
Join
SV00525
Join
SV00526
Join
SV00527
Join
SV00528
Join
SV00529
Join
SV00531
Join
SV00532
Join
SV00533
Join
SV00534
Join
SV00535
Join
SV00536
Join
SV00537
Join
SV00538
Join
SV00540
Join
SV00541
Join
SV00544
Join
SV00545
Join
SV00546
Join
SV00547
Join
SV00548
Join
SV00549
Join
SV00550
Join
SV00551
Join
SV00552
Join
SV00555
Join
SV00556
Join
SV00559
Join
SV00560
Join
SV00561
Join
SV00562
Join
SV00563
Join
SV00564
Join
SV00565
Join
SV00566
Join
SV00567
Join
SV00568
Join
SV00569
Join
SV00570
Join
SV00572
Join
SV00573
Join
SV00575
Join
SV00580
Join
SV00581
Join
SV00582
Join
SV00583
Join
SV00584
Join
SV00585
Join
SV00586
Join
SV00587
Join
SV00591
Join
SV00592
Join
SV00593
Join
SV00602
Join
SV00640
Join
SV00650
Join
SV00651
Join
SV00652
Join
SV00654
Join
SV00660
Join
SV00700
Join
SV00701
Join
SV00702
Join
SV00735
Join
SV00736
Join
SV00800
Join
SV00801
Join
SV00900
Join
SV00905
Join
SV00906
Join
SV00910
Join
SV008115
Join
SV01100
Join
SV01105
Join
SV01110
Join
SV01115
Join
SV01120
Join
SV01130
Join
SV01140
Join
SV01150
Join
SV01160
Join
SV01170
Join
SV02001
Join
SV30301
Join
SV30302
Join
SV40100
Join
SV40200
Join
SV40201
Join
SV40401
Join
SV70001
Join
SV99999
Join
SV333333
Join
SV585CLP
Join
SV_SVC_R
Join
SVAUTONM
Join
SVDOCMST
Join
SVDOCPAR
Join
SVDOCVUE
Join
SVERRORS
Join
SVINTER1
Join
SVINTER2
Join
SVINTER3
Join
SVINTER4
Join
SVINTER5
Join
SVINTER6
Join
SVINTER7
Join
SVINTER8
Join
SVMAINTE
Join
SVPGMESG
Join
SVPGSETP
Join
SVPGVNDR
Join
SVRSPMST
Join
SVRMA305
Join
SVA0053
Join
SVA0054
Join
SVA0055
Join
SVA0100
Join
SVA0115
Join
SVA0118
Join
SVA0150
Join
SVA0155
Join
SVA0160
Join
SVA0200
Join
SVA0205
Join
SVA0215
Join
SVA0300
Join
SVA0301
Join
SVA0302
Join
SVA0309
Join
SVA0311
Join
SVA0340
Join
SVA0400
Join
SVA0430
Join
SVA0460
Join
SVA0500
Join
SVA0501
Join
SVA0503
Join
SVA0505
Join
SVA0507
Join
SVA0508
Join
SVA0509
Join
SVA0514
Join
SVA0519
Join
SVA0533
Join
SVA0534
Join
SVA0547
Join
SVA0550
Join
SVA0564
Join
SVA0568
Join
SVA0575
Join
SVA0587
Join
SVA0598
Join
SVA0701
Join
SVA00805
Join
SVA00815
Join
SVADOCMS
Join
AS000100
Join
AS000210
Join
AS000220
Join
AS000300
Join
AS000500
Join
AS000600
Join
AS000700
Join
AS000800
Join
WS00106
Join
WS10101
Join
WS10702
Join
WS30702
Join
WS40300
Join
WS40302
Join
WS40303
Join
WS50101
Join
WS50102
Join
WS50103
Join
WSAUDT
Join
WSDC001
Join
WSDC002
Join
WSDC003
Join
WSDC004
Join
WSDC005
Join
WSDC006
Join
WSDC007
Join
WSDC008
Join
WSDC009
Join
WSDC010
Join
WSDC011
Join
WSDC012
Join
WSDOCS
Join
WSWHSE
Join
WSS10100
Join
WSS10200
Join
WSS30200
Join
WSS30300
Join
+600 more
Record
JC01101
Join
SV00010
Join
SV00012
Join
SV00117
Join
SV00148
Join
SV00196
Join
SV00197
Join
SV00430
Join
SV00480
Join
SV00506
Join
SV00512
Join
SV00552
Join
SV00735
Join
SV00736
Join
SV00900
Join
SV00905
Join
SV008115
Join
SV01105
Join
SVINTER6
Join
SVA0430
Join
AS000210
Join
+13 more