GP Tables

ASIEXP03 - SmartList PM Vendor Master File

Dynamics GP table ASIEXP03 (SmartList PM Vendor Master File) contains 150 columns including ASI_Order_By, VENDORID, VENDNAME....

SQL Query Builder

150 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
VENDORID Vendor ID String 16
VENDNAME Vendor Name String 66
VNDCHKNM Vendor Check Name String 66
VENDSHNM Vendor Short Name String 16
VADDCDPR Vendor Address Code - Primary String 16
VADCDPAD Vendor Address Code - Purchase Address String 16
VADCDSFR Vendor Address Code - Ship From String 16
VADCDTRO Vendor Address Code - Remit To String 16
VNDCLSID Vendor Class ID String 12
VNDCNTCT Vendor Contact String 62
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
COUNTRY Country String 62
PHNUMBR1 Phone Number 1 String 22
PHNUMBR2 Phone Number 2 String 22
FAXNUMBR Fax Number String 22
UPSZONE UPS Zone String 4
SHIPMTHD Shipping Method String 16
TAXSCHID Tax Schedule ID String 16
ACNMVNDR Account Number With Vendor String 22
TXIDNMBR Tax ID Number String 12
VENDSTTS Vendor Status1. Active2. Inactive3. Temporary Integer 2
Vendor Status values (3)
1 = Active2 = Inactive3 = Temporary
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
TXRGNNUM Tax Registration Number String 26
PARVENID Parent Vendor ID String 16
TRDDISCT Trade Discount Integer 2
TEN99TYPE 1099 Type1 – Not a 1099 vendor2 – Dividend3 – Interest4 - Miscellaneous Integer 2
1099 Type values (5)
1 = Not a 1099 Vendor2 = Dividend3 = Interest4 = Miscellaneous5 = Nonemployee Compensation
MINORDER Minimum Order Currency 10
PYMTRMID Payment Terms ID String 22
MINPYTYP Minimum Payment Type Integer 2
MINPYPCT Minimum Payment Percent Integer 2
MINPYDLR Minimum Payment Dollar Currency 10
MXIAFVND Maximum Invoice Amount For Vendors Integer 2
MAXINDLR Maximum Invoice Dollar Currency 10
COMMENT1 Comment1 String 32
COMMENT2 Comment2 String 32
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
CRLMTDLR Credit Limit Dollar Currency 10
PYMNTPRI Payment Priority String 4
KPCALHST Keep Calendar History Boolean 2
KGLDSTHS Keep GL Dist History Boolean 2
KPERHIST Keep Period History Boolean 2
KPTRXHST Keep Trx History Boolean 2
HOLD Hold Boolean 2
Hold Status values (2)
0 = Not on hold1 = On hold
PTCSHACF Post To Cash Account From Integer 2
CREDTLMT Credit Limit Integer 2
Credit Limit Type values (3)
0 = No Credit1 = Unlimited2 = Amount (see CRLMTDLR)
WRITEOFF Writeoff Integer 2
MXWOFAMT Maximum Write Off Amount Currency 10
SBPPSDED Subject To PPS Deductions Boolean 2
PPSTAXRT PPS Tax Rate Integer 2
DXVARNUM Deduction Exemption/Variation Number String 26
CRTCOMDT Certificate Commencing Date Date 4
CRTEXPDT Certificate Expiration Date Date 4
RTOBUTKN Reporting Obligation Undertaken Boolean 2
XPDTOBLG Expiration Date Obligation Boolean 2
PRSPAYEE Prescribed Payee Boolean 2
PMAPINDX PM AP Index Long Integer 4
PMCSHIDX PM Cash Index Long Integer 4
PMDAVIDX PM Discount Available Index Long Integer 4
PMDTKIDX PM Discount Taken Index Long Integer 4
PMFINIDX PM Finance Charge Index Long Integer 4
PMMSCHIX PM Misc Charges Index Long Integer 4
PMFRTIDX PM Freight Index Long Integer 4
PMTAXIDX PM Tax Index Long Integer 4
PMWRTIDX PM Write Offs Index Long Integer 4
PMPRCHIX PM Purchases Index Long Integer 4
PMRTNGIX PM Retainage Index Long Integer 4
PMTDSCIX PM Trade Discount Index Long Integer 4
ACPURIDX Accrued Purchases Index Long Integer 4
PURPVIDX Purchase Price Variance Index Long Integer 4
NOTEINDX Note Index Currency 10
CHEKBKID Checkbook ID String 16
MODIFDT Modified Date Date 4
CREATDDT Created Date Date 4
RATETPID Rate Type ID String 16
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
HIESTBAL Highest Balance Currency 10
CURRBLNC Current Balance Currency 10
NOINVYTD Number of Invoices YTD Long Integer 4
NOINVLIF Number of Invoices LIFE Long Integer 4
NOINVLYR Number of Invoices LYR Long Integer 4
NOPINYTD Number of Paid Invoices YTD Long Integer 4
NOPILIFE Number of Paid Invoices LIFE Long Integer 4
AMBLDTYD Amount Billed YTD Currency 10
AMBLDLIF Amount Billed LIFE Currency 10
AMBLDLYR Amount Billed LYR Currency 10
AMTPDYTD Amount Paid YTD Currency 10
AMTPDLIF Amount Paid LIFE Currency 10
AMTPDLYR Amount Paid LYR Currency 10
TEN99AYTD 1099 Amount YTD Currency 10
TEN99ALIF 1099 Amount LIFE Currency 10
TEN99ALYR 1099 Amount LYR Currency 10
DISAVYTD Discount Available YTD Currency 10
DISAVLIF Discount Available LIFE Currency 10
DISAVLYR Discount Available LYR Currency 10
DISTKYTD Discount Taken YTD Currency 10
DISTKNLF Discount Taken LIFE Currency 10
DISTKLYR Discount Taken LYR Currency 10
DISLSYTD Discount Lost YTD Currency 10
DISLSTLF Discount Lost LIFE Currency 10
DISLSLYR Discount Lost LYR Currency 10
FINCHLIF Finance Charge LIFE Currency 10
FINCHLYR Finance Charge LYR Currency 10
FINCHYTD Finance Charge YTD Currency 10
WROFSYTD Write Offs YTD Currency 10
WROFSLIF Write Offs LIFE Currency 10
WROFSLYR Write Offs LYR Currency 10
RTRNSYTD Returns YTD Currency 10
RTRNSLIF Returns LIFE Currency 10
RTRNSLYR Returns LYR Currency 10
TRDTKLIF Trade Discounts Taken LIFE Currency 10
TRDTLYR Trade Discounts Taken LYR Currency 10
TRDTYTD Trade Discounts Taken YTD Currency 10
NFNCHLIF Number of Finance Charges LIFE Long Integer 4
NFNCHLYR Number of Finance Charges LYR Long Integer 4
NFNCHYTD Number of Finance Charges YTD Long Integer 4
RTNGOWED Retainage Owed Currency 10
LSTCHNUM Last Check Number String 22
LSTCHKDT Last Check Date Date 4
LSTCHAMT Last Check Amount Currency 10
LSTINNUM Last Invoice Number String 22
LSTINVAM Last Invoice Amount Currency 10
LSTPURDT Last Purchase Date Date 4
FSTPURDT First Purchase Date Date 4
CURUNPBN Current Unapplied Payment Balance Currency 10
UNPDFNCH Unpaid Finance Charges Currency 10
DYCHTCLR Days Checks To Clear Integer 2
AVGDTPYR Average Days To Pay - Year Integer 2
AVDTPLIF Average Days To Pay - Life Integer 2
ONORDAMT On Order Amount Currency 10
Revalue_Vendor Revalue Vendor Boolean 2
Post_Results_To Post Results To Integer 2
FREEONBOARD Free On Board Integer 2
DISGRPER Discount Grace Period Integer 2
DOCFMTID Document Format ID String 16
DUEGRPER Due Date Grace Period Integer 2
GOVCRPID Governmental Corporate ID String 32
GOVINDID Governmental Individual ID String 32
PHONE3 Phone 3 String 22
TaxInvRecvd Tax Invoice Received Boolean 2
Withholding_LIFE Withholding LIFE Currency 10
WITHLYR Withholding LYR Currency 10
WITHYTD Withholding YTD Currency 10
CPRCSTNM Corporate Customer Number String 16

Related Tables

Tables that share columns with ASIEXP03. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP04

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP06

VENDORID

ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27 ASIEXP28

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP12

CREATDDT

ASIEXP01 ASIEXP02 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP11 ASIEXP12 ASIEXP13

SHIPMTHD

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15 ASIEXP16

TAXSCHID

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15 ASIEXP16

PYMTRMID

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15 ASIEXP16

ADDRESS1

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09