SV00406 - SV_IV_Item_MSTR
SQL Query Builder
34 Columns
| Column | Description | Type | Length | Shared With | |
|---|---|---|---|---|---|
| ITEMNMBR | char(31) | 87 tables | |||
| Equipment_Type | char(31) | 35 tables | |||
| Wennsoft_Model_Number | char(21) | 16 tables | |||
| USERDEF1 | char(21) | 138 tables | |||
| USERDEF2 | char(21) | 138 tables | |||
| USRDEF03 | char(21) | 10 tables | |||
| USRDEF04 | char(21) | 10 tables | |||
| USRDEF05 | char(21) | 8 tables | |||
| User_Defined_CB_1 | tinyint | 97 tables | |||
| UDCB1 | tinyint | 5 tables | |||
| User_Defined_CB_2 | tinyint | 97 tables | |||
| UDCB2 | tinyint | 5 tables | |||
| User_Defined_CB_3 | tinyint | 92 tables | |||
| User_Defined_CB_4 | tinyint | 92 tables | |||
| USRDAT01 | datetime | 100 tables | |||
| USRDAT02 | datetime | 98 tables | |||
| User_Defined_Date_3 | datetime | 87 tables | |||
| User_Defined_Date_4 | datetime | 87 tables | |||
| User_Defined_Dollar_1 | numeric(19,5) | 97 tables | |||
| UserDD1 | numeric(19,5) | 5 tables | |||
| User_Defined_Dollar_2 | numeric(19,5) | 97 tables | |||
| UserDD2 | numeric(19,5) | 5 tables | |||
| User_Defined_Dollar_3 | numeric(19,5) | 92 tables | |||
| User_Defined_Dollar_4 | numeric(19,5) | 92 tables | |||
| User_Defined_EInfo1 | char(255) | 1 tables | |||
| User_Defined_EInfo2 | char(255) | 1 tables | |||
| User_Def_Integer_1 | int | 97 tables | |||
| UDI1 | int | 2 tables | |||
| User_Def_Integer_2 | int | 97 tables | |||
| UDI2 | int | 2 tables | |||
| User_Defined_Integer_3 | int | 92 tables | |||
| User_Defined_Integer_4 | int | 92 tables | |||
| User_Defined_Time_1 | datetime | 1 tables | |||
| DEX_ROW_ID | int auto number (1,1) | 608 tables |
Related Tables
Tables that share columns with SV00406. Click "Join" to add to your query.
DEX_ROW_ID
AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100 APR_APR30000 APR_APR30300 APR_BLM42100 APR_BLM42101 APR_DIA30100 CAM10000 CAM30000 CAM30100 CAM40001 CAM40003 CAM40004 CAM40005 CFM00100 CFM00101 CO00101 CO00102 CO07260 CO40100 DTA10100 DTA10200 EDCEI003 EDCEI004 EDCEI005 EDCEI008 EDCEI010 EDCEI013 EDCEI015 EDCEI017 EDCEI018 EDCML001 EDCML002 EDCML003 EDCML004 EDCML005 EDCML006 EDCML008 ENC10110 ENC10111 ENC10310V ENC10500 ENC40000 ENC40100 ENC40200 ENCAA10110 FA00199 FA00300 FA00400 FA00500 FA00600 FA00700 FA00701 GL00100 GL00102 GL00105 GL10001 GL10110 GL10111 GL20000 GL30000 GL40200 IV00106 IV00107 IV00108 IV00200 IV00300 IV10000 IV10001 IV10200 IV10201 IV30101 IV30200 IV30300 IV40202 IV40700 IVC30100 IVC30102 IVC40100 IVC40101 MC00200 ME123501 ME123502 ME123503 ME123504 ME123506 ME123515 ME123516 ME142801 ME142804 ME142807 ME142808 ME142809 ME142811 ME142812 ME142813 ME142814 ME142815 ME142818 ME27607 ML00001 MinPONum PM80100 PP000001 PP000002 PP000011 RVLPD001 RVLPD002 RVLPD003 RVLPD004 RVLPD005 RVLPD006 RVLPD007 RVLPD008 RVLPD009 RVLPD010 RVLPD011 RVLPD012 RVLPD013 RVLPD014 RVLPD015 ReportCatalog ReportCatalogPending ReportCenters ReportCentersPending ReportErrorLog ReportInternalNames ReportPublishers ReportRolesPending ReportSchedule ReportUserPrefs SOP10101 SOP10102 SOP10103 SOP10104 SOP10105 SOP10106 JC00102 JC00103 JC00104 JC00105 JC00106 JC00107 JC00201 JC00203 JC00301 JC00401 JC00501 JC00600 JC00601 JC00701 JC00702 JC00801 JC00901 JC01001 JC01002 JC01003 JC01101 JC01102 JC01201 JC01301 JC01401 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC01519 JC01601 JC01701 JC01801 JC01802 JC10201 JC10301 JC10302 JC10500 JC10501 JC10503 JC10504 JC10506 JC10511 JC10512 JC10513 JC10514 JC10701 JC10703 JC10801 JC10802 JC10901 JC10902 JC20002 JC20003 JC20004 JC20005 JC20101 JC20301 JC20401 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC20801 JC20902 JC30001 JC30001L JC30002 JC30003 JC30004 JC30006 JC30101 JC30102 JC30107 JC30202 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30701 JC30210 JC30801 JC31001 JC31002 JC31201 JC40101 JC40102 JC40103 JC40104 JC40105 JC40106 JC40107 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40207 JC40208 JC40209 JC40301 JC40302 JC40303 JC40304 JC40305 JC40306 JC40307 JC40308 JC40401 JC40501 JC40502 JC40503 JC40601 JC40602 JC40603 JC40701 JC40702 JC40703 JC40711 JC40801 JC40901 JC41101 JC41102 JC41103 JC41201 JC50101 JC50201 JC70001 JC0CHECK JC10001L JC10211 JCCIS150 JCCIS200 JCCIS201 JCERRORS JCPCHECK JCRFP100 JCRFP300 JCVAT150 SV00AD1 SV00010 SV00012 SV00015 SV00021 SV00030 SV00032 SV00033 SV00034 SV00040 SV00045 SV00053 SV00054 SV00055 SV00077 SV00099 SV00100 SV00101 SV00105 SV00110 SV00114 SV00115 SV00116 SV00117 SV00118 SV00119 SV00120 SV00130 SV00131 SV00132 SV00142 SV00143 SV00144 SV00145 SV00148 SV00149 SV00150 SV00155 SV00160 SV00165 SV00166 SV00167 SV00196 SV00197 SV00198 SV00199 SV00200 SV00201 SV00205 SV00215 SV00220 SV00221 SV00225 SV00230 SV00300 SV00301 SV00302 SV00303 SV00304 SV00305 SV00306 SV00307 SV00308 SV00309 SV00310 SV00311 SV00312 SV00314 SV00315 SV00320 SV00324 SV00325 SV00326 SV00330 SV00331 SV00340 SV00351 SV00360 SV00361 SV00362 SV00370 SV00387 SV00392 SV00393 SV00394 SV00400 SV00401 SV00402 SV00403 SV00405 SV00410 SV00411 SV00420 SV00425 SV00430 SV00460 SV00470 SV00480 SV00490 SV00500 SV00501 SV00502 SV00503 SV00504 SV00505 SV00506 SV00507 SV00508 SV00509 SV00510 SV00511 SV00512 SV00514 SV00515 SV00517 SV00519 SV00520 SV00521 SV00522 SV00523 SV00524 SV00525 SV00526 SV00527 SV00528 SV00529 SV00531 SV00532 SV00533 SV00534 SV00535 SV00536 SV00537 SV00538 SV00540 SV00541 SV00544 SV00545 SV00546 SV00547 SV00548 SV00549 SV00550 SV00551 SV00552 SV00555 SV00556 SV00559 SV00560 SV00561 SV00562 SV00563 SV00564 SV00565 SV00566 SV00567 SV00568 SV00569 SV00570 SV00572 SV00573 SV00575 SV00580 SV00581 SV00582 SV00583 SV00584 SV00585 SV00586 SV00587 SV00591 SV00592 SV00593 SV00602 SV00640 SV00650 SV00651 SV00652 SV00654 SV00660 SV00700 SV00701 SV00702 SV00735 SV00736 SV00800 SV00801 SV00900 SV00905 SV00906 SV00910 SV008115 SV01100 SV01105 SV01110 SV01115 SV01120 SV01130 SV01140 SV01150 SV01160 SV01170 SV02001 SV30301 SV30302 SV40100 SV40200 SV40201 SV40401 SV70001 SV99999 SV333333 SV585CLP SV_SVC_R SVAUTONM SVDOCMST SVDOCPAR SVDOCVUE SVERRORS SVINTER1 SVINTER2 SVINTER3 SVINTER4 SVINTER5 SVINTER6 SVINTER7 SVINTER8 SVMAINTE SVPGMESG SVPGSETP SVPGVNDR SVRSPMST SVRMA305 SVA0053 SVA0054 SVA0055 SVA0100 SVA0115 SVA0118 SVA0150 SVA0155 SVA0160 SVA0200 SVA0205 SVA0215 SVA0300 SVA0301 SVA0302 SVA0309 SVA0311 SVA0340 SVA0400 SVA0430 SVA0460 SVA0500 SVA0501 SVA0503 SVA0505 SVA0507 SVA0508 SVA0509 SVA0514 SVA0519 SVA0533 SVA0534 SVA0547 SVA0550 SVA0564 SVA0568 SVA0575 SVA0587 SVA0598 SVA0701 SVA00805 SVA00815 SVADOCMS AS000100 AS000210 AS000220 AS000300 AS000500 AS000600 AS000700 AS000800 WS00106 WS10101 WS10702 WS30702 WS40300 WS40302 WS40303 WS50101 WS50102 WS50103 WSAUDT WSDC001 WSDC002 WSDC003 WSDC004 WSDC005 WSDC006 WSDC007 WSDC008 WSDC009 WSDC010 WSDC011 WSDC012 WSDOCS WSWHSE WSS10100 WSS10200 WSS30200 WSS30300
USERDEF1
ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP11 ASIEXP12 ASIEXP13 ASIEXP15 ASIEXP16 ASIEXP17 ASIEXP18 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23 ASIEXP24 ASIEXP25 ASIEXP32 ASILOC50 BM10200 BM30200 CM20200 CM20300 CN00100 CN00200 CN00500 CN100100 GL00100 IVC10100 IVC30101 PM00100 PM00200 RM00101 SOP10106 JC00102 JC00103 JC00104 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40501 JC40702 JC40703 JC40801 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 SV00301 SV00305 SV00324 SV30301 SVA0301 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE
USERDEF2
ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP11 ASIEXP12 ASIEXP13 ASIEXP15 ASIEXP16 ASIEXP17 ASIEXP18 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23 ASIEXP24 ASIEXP25 ASIEXP32 ASILOC50 BM10200 BM30200 CM20200 CM20300 CN00100 CN00200 CN00500 CN100100 GL00100 IVC10100 IVC30101 PM00100 PM00200 RM00101 SOP10106 JC00102 JC00103 JC00104 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40501 JC40702 JC40703 JC40801 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 SV00301 SV00305 SV00324 SV30301 SVA0301 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE
USRDAT01
CN00100 CN00500 SOP10106 SY01403 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01504 JC01505 JC01511 JC01514 JC001520 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30107 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40308 JC40501 JC40703 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 SV00301 SV00324 SV30301 SVA0301 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE
USRDAT02
SOP10106 SY01403 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01504 JC01505 JC01511 JC01514 JC001520 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30107 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40308 JC40501 JC40703 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 SV00301 SV00324 SV30301 SVA0301 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE
User_Defined_CB_1
JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30107 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40308 JC40501 JC40702 JC40703 JC40801 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE
User_Defined_CB_2
JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30107 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40308 JC40501 JC40702 JC40703 JC40801 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE
User_Defined_Dollar_1
JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30107 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40308 JC40501 JC40702 JC40703 JC40801 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE
User_Defined_Dollar_2
JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30107 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40308 JC40501 JC40702 JC40703 JC40801 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE
User_Def_Integer_1
JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01201 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30003 JC30006 JC30101 JC30102 JC30107 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40104 JC40106 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40302 JC40303 JC40304 JC40306 JC40307 JC40308 JC40501 JC40702 JC40703 JC40801 JC41201 JC10211 JCCIS200 JCCIS201 SV00148 WS10702 WS30702 WS40300 WS40302 WS40303 WSAUDT WSWHSE