CN10300 - Collections - Email Attachments
Dynamics GP table CN10300 (Collections - Email Attachments) contains 9 columns including USERID, PRCSSQNC, CUSTNMBR....
SQL Query Builder
9 Columns
| Column | Description | Type | Length | Shared With | |
|---|---|---|---|---|---|
| USERID | User ID | String | 16 | 338 tables | |
| PRCSSQNC | Process Sequence | Integer | 2 | 4 tables | |
| CUSTNMBR | Customer Number | String | 16 | 230 tables | |
| CUSTNAME | Customer Name | String | 66 | 41 tables | |
| ADRSCODE | Address Code | String | 16 | 164 tables | |
| SEQNUMBR | Sequence Number | Long Integer | 4 | 86 tables | |
| fileName | fileName | String | 256 | 4 tables | |
| Delete_After_Attach | Delete After Attach | Boolean | 2 | 1 tables | |
| EmailBody | Email Body | Text | 2 | - |
Related Tables
Tables that share columns with CN10300. Click "Join" to add to your query.
USERID
AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 APR_APR30000 APR_APR30300 ASIEXP100 ASIEXP85 CAM10200 CM20203 CN00100 CN01400 CN100100 CN100200 CN100201 CN10200 CO07260 DD10100 DD10400 DD10700 DD30100 EDCEI001 EDCEI017 EDCML001 EDCVAT01 EDCVAT10 FA15000 IF000003 IF000004 IF000005 IVC30100 IVC50100 MC10101 ME123504 ME142801 ME142802 ME142803 ME142804 ME142806 ME142807 ME142818 PA000001 PA000002 PA10000 PA10100 PA10200 PA10500 PA10900 PA11800 PA30100 PA30103 PA30200 PA30300 PA30500 PA30600 PA30900 PA50102 PA50105 PM00400 PM10100 PM10600 PM10900 PM10901 PM20100 PM20200 PM30600 PM80100 PP000002 PP000030 PP000032 PP000100 PP100100 RM50100 RM50103 RM50104 ReportErrorLog ReportPublishers ReportUserPrefs SE000401 SE00400 SOP10104 STN41100 STN41300 STN41350 SVC00700 SY00800 SY00801 SY01301 SY01400 SY01402 SY01403 SY01404 SY01405 SY01450 WDC51100 aagError JC00102 JC00103 JC00104 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701 JC00702 JC00801 JC01001 JC01002 JC01003 JC01102 JC01301 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC01601 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20004 JC20005 JC20101 JC20401 JC20501 JC20502 JC20503 JC20504 JC20511 JC30001 JC30006 JC30101 JC30102 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40102 JC40203 JC40204 JC40302 JC40303 JC40304 JC40307 JC40308 JC40501 JC40702 JC40703 JC40801 JC41101 JC41201 JC70001 JC10211 JCPCHECK SV00012 SV00021 SV00030 SV00032 SV00033 SV00034 SV00040 SV00053 SV00077 SV00100 SV00105 SV00110 SV00115 SV00130 SV00131 SV00132 SV00143 SV00144 SV00150 SV00155 SV00160 SV00199 SV00200 SV00205 SV00215 SV00220 SV00225 SV00230 SV00300 SV00310 SV00315 SV00320 SV00325 SV00330 SV00331 SV00340 SV00351 SV00360 SV00361 SV00362 SV00370 SV00387 SV00392 SV00393 SV00394 SV00400 SV00401 SV00402 SV00420 SV00460 SV00470 SV00490 SV00500 SV00501 SV00502 SV00505 SV00506 SV00507 SV00508 SV00509 SV00510 SV00512 SV00514 SV00515 SV00517 SV00519 SV00520 SV00521 SV00522 SV00523 SV00524 SV00525 SV00529 SV00532 SV00536 SV00538 SV00544 SV00545 SV00550 SV00551 SV00552 SV00555 SV00556 SV00560 SV00561 SV00564 SV00566 SV00567 SV00568 SV00575 SV00581 SV00582 SV00592 SV00640 SV00650 SV00651 SV00652 SV00700 SV00701 SV00702 SV00800 SV00910 SV01100 SV01110 SV01120 SV01130 SV01140 SV01150 SV01160 SV01170 SV02001 SV30302 SV585CLP SV_SVC_R SVDOCMST SVDOCPAR SVDOCVUE SVINTER1 SVINTER3 SVINTER4 SVINTER5 SVINTER7 SVINTER8 SVMAINTE SVRSPMST SVA0053 SVA0100 SVA0115 SVA0150 SVA0155 SVA0160 SVA0200 SVA0205 SVA0215 SVA0300 SVA0340 SVA0400 SVA0460 SVA0500 SVA0501 SVA0505 SVA0507 SVA0508 SVA0509 SVA0514 SVA0519 SVA0550 SVA0564 SVA0568 SVA0575 SVA0598 SVA0701 SVA00805 SVA00815 SVADOCMS WS10702 WS30702 WS50101 WS50102 WS50103 WSAUDT WSWHSE
CUSTNMBR
ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP24 ASIEXP25 ASILOC50 CFM20101 CFM20102 CFM30000 CFM30500 CN00100 CN00500 CN100100 CN100200 CN100201 CN20100 DO10100 DO40100 EDCEI009 EDCEI016 EDCEI021 ICJC9000 IEBEGBAL IERMTRXI IV30300 IVC10100 IVC30101 MC020102 MC10101 PA00001 PA00501 PA00502 PA00503 PA00504 PA00511 PA00531 PA01101 PA01201 PA11801 PA12000 PA13100 PA13200 PA23100 PA23200 PA23302 PA23400 PA33100 PA33200 PA33701 PA50102 PA50103 POP10100 RM00101 RM00103 RM10201 RM10301 RM20101 RM20201 RM30101 RM30202 RM50100 RM50103 RM50104 RVLPD004 RVLPD005 RVLPD007 RVLPD008 RVLPD009 RVLPD010 SOP10100 SOP30200 palbInvc JC00102 JC00106 JC00201 JC00401 JC01003 JC01701 JC10501 JC10511 JC10701 JC20003 JC20501 JC20511 JC30001 JC30003 JC30006 JC30401 JC30501 JC30511 JC31201 JC50201 SV00053 SV00054 SV00055 SV00100 SV00119 SV00131 SV00132 SV00160 SV00200 SV00201 SV00205 SV00215 SV00300 SV00302 SV00308 SV00309 SV00351 SV00387 SV00400 SV00401 SV00402 SV00403 SV00430 SV00460 SV00500 SV00501 SV00502 SV00503 SV00504 SV00505 SV00507 SV00508 SV00509 SV00510 SV00514 SV00531 SV00533 SV00534 SV00536 SV00537 SV00544 SV00545 SV00546 SV00547 SV00548 SV00549 SV00550 SV00564 SV00567 SV00568 SV00575 SV00581 SV00582 SV00583 SV00585 SV00586 SV00587 SV00640 SV00650 SV00654 SV00660 SV00700 SV00701 SV00702 SV00800 SV00801 SV00910 SV02001 SV70001 SV99999 SV333333 SV585CLP SVDOCMST SVINTER1 SVINTER3 SVINTER5 SVINTER6 SVINTER7 SVINTER8 SVMAINTE SVRMA305 SVA0053 SVA0054 SVA0055 SVA0100 SVA0160 SVA0200 SVA0205 SVA0215 SVA0300 SVA0302 SVA0309 SVA0400 SVA0430 SVA0460 SVA0500 SVA0501 SVA0503 SVA0505 SVA0507 SVA0508 SVA0509 SVA0514 SVA0533 SVA0534 SVA0547 SVA0550 SVA0564 SVA0568 SVA0575 SVA0587 SVA0598 SVA0701 SVA00805 SVA00815 SVADOCMS WS10702 WS30702 WSAUDT WSDC003 WSDC004 WSDC005 WSDC006 WSDC007 WSDC008 WSDC009 WSDC010 WSDC011 WSDC012 WSDOCS WSWHSE WSS10100 WSS30200
ADRSCODE
ASIEXP02 ASIEXP05 ASIEXP07 ASIEXP08 ASIEXP10 ASIEXP15 ASIEXP16 ASIEXP18 ASIEXP20 ASIEXP21 ASIEXP24 ASIEXP32 CN00100 CN00500 CN100100 CN100200 CN100201 EDCEI003 EDCEI004 EDCEI008 EDCEI009 ICJC9000 IEPMTRXI IERMTRXI PA01101 PM00300 POP10110 POP30110 RM00101 RM10301 RM20101 RM30101 SVC00106 JC00106 JC01501 JC01511 JC10501 JC10511 JC10701 JC20501 JC20511 JC30006 JC30501 JC30511 JC41201 SV00053 SV00054 SV00055 SV00119 SV00131 SV00132 SV00200 SV00201 SV00205 SV00215 SV00300 SV00302 SV00308 SV00309 SV00351 SV00387 SV00400 SV00401 SV00402 SV00403 SV00430 SV00460 SV00500 SV00501 SV00502 SV00503 SV00504 SV00505 SV00507 SV00508 SV00509 SV00510 SV00514 SV00531 SV00533 SV00534 SV00536 SV00537 SV00544 SV00545 SV00546 SV00547 SV00548 SV00549 SV00550 SV00564 SV00567 SV00568 SV00575 SV00581 SV00582 SV00583 SV00585 SV00586 SV00587 SV00660 SV00700 SV00701 SV00702 SV00800 SV02001 SV70001 SV99999 SV333333 SV585CLP SVDOCMST SVINTER1 SVINTER3 SVINTER5 SVINTER6 SVINTER7 SVINTER8 SVMAINTE SVA0053 SVA0054 SVA0055 SVA0200 SVA0205 SVA0215 SVA0300 SVA0302 SVA0309 SVA0400 SVA0430 SVA0460 SVA0500 SVA0501 SVA0503 SVA0505 SVA0507 SVA0508 SVA0509 SVA0514 SVA0533 SVA0534 SVA0547 SVA0550 SVA0564 SVA0568 SVA0575 SVA0587 SVA0598 SVA0701 SVA00805 SVA00815 SVADOCMS WS10702 WS30702 WSAUDT WSDC005 WSDC006 WSDC007 WSDC008 WSDC009 WSDC010 WSDC011 WSDC012 WSDOCS WSWHSE
SEQNUMBR
AAG20001 AAG20011 AAG30001 AAG40001 AF40201 AHPSLH01 ASIEXP14 ASIEXP29 CAM30100 CFM20001 CM00001 CN04000 CO07260 DO10100 DTA10100 DTA10200 GL20000 GL30000 GTM20001V IV00104 IV40202 IVC10200 IVC10300 IVC10400 IVC50100 MC10101 ME142804 ME142807 ME142811 ME142818 PM00101 PM00203 PM10801 PP000002 PP000013 RM50104 RVLPD014 SEE30303 SOP10101 SOP10102 SOP10103 SY01301 TX30000 WHPSETP WHPT001 palbInvc JC10500 JC10701 JC30001L JC40104 JC40205 JC40206 JC40306 JC40308 JC40703 JC10001L SV00030 SV00032 SV00131 SV00132 SV00149 SV00166 SV00167 SV00221 SV00303 SV00304 SV00387 SV00507 SV00508 SV00509 SV00510 SV00569 SV01105 SV02001 SVINTER7 SVRMA305 SVA0507 SVA0508 SVA0509 SVA00815 AS000600 WS10702 WS30702 WS50102 WSAUDT WSWHSE
CUSTNAME
ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP17 ASIEXP20 ASIEXP21 ASIEXP24 ASIEXP25 CN100100 ICJC9000 IERMTRXI IVC10100 IVC30101 RM00101 RM10301 RVLPD008 RVLPD009 RVLPD010 SOP10100 SOP30200 SVC00700 palbInvc SV00054 SV00055 SV00200 SV00300 SV00430 SV00702 SV70001 SVINTER1 SVINTER6 SVINTER8 SVA0054 SVA0055 SVA0200 SVA0300 SVA0430 SVA0598 SVA00805
Delete_After_Attach