PA00001 - Customer Vendor Master
Dynamics GP table PA00001 (Customer Vendor Master) contains 7 columns including CUSTNMBR, VENDORID, CURNCYID....
SQL Query Builder
7 Columns
| Column | Description | Type | Length | Shared With | |
|---|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | 230 tables | |
| VENDORID | Vendor ID | String | 16 | 107 tables | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | 136 tables | |
| RATETPID | Rate Type ID | String | 16 | 80 tables | |
| CREATDDT | Created Date | Date | 4 | 74 tables | |
| CRUSRID | Created User ID | String | 16 | 27 tables | |
| MODIFDT | Modified Date | Date | 4 | 394 tables |
Related Tables
Tables that share columns with PA00001. Click "Join" to add to your query.
MODIFDT
ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP12 ASIEXP13 ASIEXP15 ASIEXP16 ASIEXP17 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23 ASIEXP24 ASIEXP25 ASIEXP27 ASIEXP28 BM00101 BM10200 BM30200 CM20200 CM20300 CN01400 CT00002 CT00102 CT40401 ENC10110 ENC10111 ENCAA10110 GL00100 IC40100 ICJC9001 IV00101 IV10000 IVC10100 IVC30101 PDK10500 PM00100 PM00200 PM10000 PM10300 PM10400 PM20000 PM20100 PM30200 POP10100 POP10300 POP30300 RM00101 SOP10100 SOP30200 STN41100 STN41250 STN41300 SY01400 SY01500 SY01501 gpPayWork JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301 JC00401 JC00501 JC00600 JC00601 JC00701 JC00702 JC00801 JC00901 JC01001 JC01002 JC01003 JC01301 JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC01701 JC10201 JC10302 JC10501 JC10503 JC10504 JC10506 JC10511 JC10701 JC10802 JC10901 JC20002 JC20003 JC20004 JC20005 JC20101 JC20501 JC20502 JC20503 JC20504 JC20511 JC20601 JC20705 JC30001 JC30002 JC30003 JC30006 JC30101 JC30102 JC30107 JC30301 JC30401 JC30501 JC30502 JC30503 JC30504 JC30511 JC30601 JC30210 JC31001 JC31002 JC31201 JC40101 JC40102 JC40104 JC40106 JC40107 JC40201 JC40202 JC40203 JC40204 JC40205 JC40206 JC40209 JC40301 JC40302 JC40303 JC40304 JC40306 JC40307 JC40308 JC40501 JC40502 JC40701 JC40702 JC40703 JC40801 JC40901 JC41101 JC41201 JC10211 JCRFP100 JCRFP300 SV00012 SV00015 SV00021 SV00030 SV00032 SV00033 SV00040 SV00054 SV00077 SV00100 SV00105 SV00110 SV00114 SV00115 SV00116 SV00119 SV00130 SV00142 SV00143 SV00144 SV00145 SV00150 SV00155 SV00160 SV00165 SV00166 SV00167 SV00196 SV00197 SV00199 SV00200 SV00201 SV00205 SV00215 SV00220 SV00225 SV00230 SV00300 SV00301 SV00302 SV00305 SV00309 SV00310 SV00311 SV00312 SV00314 SV00315 SV00320 SV00324 SV00325 SV00330 SV00331 SV00340 SV00351 SV00360 SV00361 SV00362 SV00370 SV00387 SV00392 SV00393 SV00394 SV00400 SV00401 SV00402 SV00405 SV00411 SV00420 SV00425 SV00460 SV00470 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 SV00538 SV00540 SV00541 SV00544 SV00545 SV00546 SV00549 SV00550 SV00551 SV00555 SV00556 SV00559 SV00560 SV00561 SV00562 SV00563 SV00564 SV00565 SV00566 SV00567 SV00568 SV00570 SV00572 SV00573 SV00575 SV00580 SV00581 SV00582 SV00583 SV00586 SV00587 SV00591 SV00592 SV00593 SV00640 SV00650 SV00651 SV00652 SV00654 SV00700 SV00701 SV00900 SV00905 SV00910 SV01100 SV01105 SV01110 SV01120 SV01130 SV01140 SV01150 SV01160 SV01170 SV02001 SV30301 SV40200 SV40201 SVDOCMST SVDOCPAR SVDOCVUE SVINTER1 SVINTER3 SVINTER4 SVINTER5 SVINTER7 SVINTER8 SVMAINTE SVPGMESG SVPGSETP SVPGVNDR SVRSPMST SVA0054 SVA0100 SVA0115 SVA0150 SVA0155 SVA0160 SVA0200 SVA0205 SVA0215 SVA0300 SVA0301 SVA0302 SVA0309 SVA0311 SVA0340 SVA0400 SVA0460 SVA0500 SVA0501 SVA0503 SVA0505 SVA0507 SVA0508 SVA0509 SVA0514 SVA0519 SVA0533 SVA0534 SVA0550 SVA0564 SVA0568 SVA0575 SVA0587 SVA0598 SVA0701 SVA00805 SVA00815 SVADOCMS WS10702 WS30702 WSAUDT WSDC001 WSDC002 WSDC003 WSDC004 WSDC005 WSDC006 WSDC007 WSDC008 WSDC009 WSDC010 WSDC011 WSDC012 WSWHSE WSS10100 WSS30200
CUSTNMBR
ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP24 ASIEXP25 ASILOC50 CFM20101 CFM20102 CFM30000 CFM30500 CN00100 CN00500 CN100100 CN100200 CN100201 CN10300 CN20100 DO10100 DO40100 EDCEI009 EDCEI016 EDCEI021 ICJC9000 IEBEGBAL IERMTRXI IV30300 IVC10100 IVC30101 MC020102 MC10101 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
CURNCYID
AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001 AAG70001 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP12 ASIEXP15 ASIEXP16 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23 ASIEXP24 ASIEXP25 ASIEXP27 ASIEXP28 CM00001 CM20200 CM20300 CM20501 CN100201 CN20100 EDCEI002 EDCEI005 EDCML002 EDCML003 EDCML005 ENCAA10210V FA00700 FA00701 GL10000 GL20000 GL30000 GTM20001V ICJC9000 ICJC9001 IV00105 IV00107 IV00108 IVC10100 IVC10200 IVC30101 MC00200 MC00500 MC020102 MC020103 ME142807 PA00601 PA01001 PA01403 PA01405 PA10000 PA10100 PA10200 PA10500 PA11800 PA13100 PA23100 PA30100 PA30103 PA30200 PA30300 PA30500 PA30901 PA33100 PA50103 PA50105 PDK10500 PM00100 PM00200 PM10000 PM10100 PM10200 PM10201 PM10300 PM10400 PM10600 PM10801 PM10900 PM10901 PM20000 PM20100 PM20200 PM30200 PM30300 PM30600 POP10100 POP10110 POP10300 POP30300 RM00101 RM10201 RM10301 RM20101 RM20201 RM30101 RM50100 RM50103 RM50104 RVLPD008 RVLPD009 RVLPD010 RVLPD011 RVLPD014 SOP10100 SOP10103 SOP30200 gpPayWork JC00102 JC01301 JC10301 JC10501 JC10511 JC20004 JC20301 JC20501 JC20511 JC30001 JC30202 JC30501 JC30511 JCRFP100 JCRFP300 SV00144 SV00702
VENDORID
ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27 ASIEXP28 CAM10000 CAM10100 CAM30000 CAM30100 CPO10110 ECM10002 EDCEI008 EDCML007 ENC10110 ENC10111 ENCAA10110 ENCAA10210V ICJC9001 IEBEGBAL IEPMTRXI IV00103 IV10200 MC020103 ME142805 ME27607 PA00601 PA00901 PA10702 PA10721 PA10900 PA11800 PA30900 PA40601 PA50103 PM00200 PM00201 PM00202 PM00203 PM00204 PM00300 PM00400 PM10000 PM10100 PM10200 PM10300 PM10400 PM10600 PM10900 PM10901 PM20000 PM20100 PM30200 PM30300 PM30600 PM80500 POA40003 POP10100 POP10110 POP10300 POP30110 POP30300 SEE30303 SVC00106 gpPayWork JC01501 JC01502 JC01503 JC01504 JC01505 JC01511 JC01513 JC01514 JC001520 JC10201 JC10302 JC10500 JC10504 JC10701 JC20004 JC20504 JC20705 JC30504 JC30210 JC10211 JCCIS150 JCCIS200 JCCIS201 JCRFP100 JCRFP300 JCVAT150 SV00115 SV00460 SV00910 SVINTER4 SVINTER7 SVA0115 SVA0460 SVA00815 WS10702 WS30702 WSAUDT WSDOCS WSWHSE
RATETPID
AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP12 ASIEXP15 ASIEXP16 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23 ASIEXP24 ASIEXP27 CM00001 CM20200 CM20300 CM20501 FA00700 FA00701 GL10000 GL10001 GL20000 GL30000 MC00500 MC020102 MC020103 PA00601 PA01001 PA01403 PA01405 PA10000 PA10001 PA10100 PA10101 PA10200 PA10201 PA10500 PA10501 PA10702 PA10901 PA11800 PA13100 PA23100 PA30100 PA30101 PA30200 PA30201 PA30300 PA30301 PA30500 PA30501 PA30901 PA31102 PA33100 PDK00301 PDK10001 PDK10500 PDK10501 PM00100 PM00200 PM10100 POP10100 POP10300 POP30300 RM00101 SOP10100 SOP30200 JC00102 JC01001 JC30001 JC31001
CREATDDT
ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP11 ASIEXP12 ASIEXP13 ASIEXP15 ASIEXP16 ASIEXP17 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24 ASIEXP25 ASIEXP27 ASIEXP28 BM00101 BM10200 BM30200 CN01400 CO00101 CO00102 CT00102 EDCVAT10 ENC10110 ENC10111 ENCAA10110 GL00100 IC40100 IV00101 IVC10100 IVC30101 PA10000 PA10100 PA10200 PA10500 PA30100 PA30200 PA30300 PA30500 PM00100 PM00200 PM80100 POP10100 POP10300 POP30300 RM00101 SOP10100 SOP30200 STN41100 STN41250 STN41300 SY01400 SY01450 SY01500 SY01501 JC00102 JC01301 JC30001 SV00119 SV00301 SV00302 SV00324 SV30301 SV40200 SV40201 SVA0301 SVA0302 WSS10100 WSS30200