GP Tables

ASIEXP16 - ASI_PM_Address_MSTR_SmartList

Dynamics GP table ASIEXP16 (ASI_PM_Address_MSTR_SmartList) contains 105 columns including ASI_Order_By, VENDORID, ADRSCODE....

SQL Query Builder

105 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
VENDORID Vendor ID String 16
ADRSCODE Address Code String 16
VENDNAME Vendor Name String 66
VNDCHKNM Vendor Check Name String 66
VENDSHNM Vendor Short Name 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
UPSZONE UPS Zone String 4
PHNUMBR1 Phone Number 1 String 22
PHNUMBR2 Phone Number 2 String 22
FAXNUMBR Fax Number String 22
SHIPMTHD Shipping Method String 16
TAXSCHID Tax Schedule ID String 16
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
INET1 INet1 String 202
INET2 INet2 String 202
INET3 INet3 String 202
INET4 INet4 String 202
INET5 INet5 String 202
INET6 INet6 String 202
INET7 INet7 String 202
INET8 INet8 String 202
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
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
RegKey RegKey String 130
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
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

Related Tables

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

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP21 ASIEXP23 ASIEXP27 ASIEXP28

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

CREATDDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP11 ASIEXP12

SHIPMTHD

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

TAXSCHID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

PYMTRMID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

ADDRESS1

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08