GP Tables

ASIEXP15 - ASI_RM_Customer_MSTR_ADDR_SmartList

Dynamics GP table ASIEXP15 (ASI_RM_Customer_MSTR_ADDR_SmartList) contains 104 columns including ASI_Order_By, CUSTNMBR, ADRSCODE....

SQL Query Builder

104 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
CUSTNMBR Customer Number String 16
ADRSCODE Address Code String 16
CUSTNAME Customer Name String 66
SLPRSNID Salesperson ID String 16
UPSZONE UPS Zone String 4
CUSTCLAS Customer Class String 16
CPRCSTNM Corporate Customer Number String 16
CNTCPRSN Contact Person String 62
SHIPMTHD Shipping Method String 16
TAXSCHID Tax Schedule ID String 16
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
COUNTRY Country String 62
CITY City String 36
STATE State String 30
ZIP Zip String 12
PHONE1 Phone 1 String 22
PHONE2 Phone 2 String 22
FAX Fax String 22
MODIFDT Modified Date Date 4
CREATDDT Created Date Date 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
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
STMTNAME Statement Name String 66
SHRTNAME Short Name String 16
PRBTADCD Primary Billto Address Code String 16
PRSTADCD Primary Shipto Address Code String 16
STADDRCD Statement Address Code String 16
ASI_Main_Salesperson ASI_Main_Salesperson String 16
CHEKBKID Checkbook ID String 16
PYMTRMID Payment Terms ID String 22
CRLMTTYP Credit Limit Type Integer 2
CRLMTAMT Credit Limit Amount Currency 10
CRLMTPER Credit Limit Period Integer 2
CRLMTPAM Credit Limit Period Amount Currency 10
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
RATETPID Rate Type ID String 16
CUSTDISC Customer Discount Integer 2
PRCLEVEL PriceLevel String 12
MINPYTYP Minimum Payment Type Integer 2
MINPYDLR Minimum Payment Dollar Currency 10
MINPYPCT Minimum Payment Percent Integer 2
FNCHATYP Finance Charge Amt Type Integer 2
FNCHPCNT Finance Charge Percent Integer 2
FINCHDLR Finance Charge Dollar Currency 10
MXWOFTYP Maximum Writeoff Type Integer 2
MXWROFAM Max Writeoff Amount Currency 10
COMMENT1 Comment1 String 32
COMMENT2 Comment2 String 32
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
TAXEXMT1 Tax Exempt 1 String 26
TAXEXMT2 Tax Exempt 2 String 26
TXRGNNUM Tax Registration Number String 26
BALNCTYP Balance Type Integer 2
STMTCYCL Statement Cycle1. No Statement2. Weekly3. Biweekly4. Semi Monthly5. Monthly6. Bimonthly7. Quarterly Integer 2
BANKNAME Bank Name String 32
BNKBRNCH Bank Branch String 22
SALSTERR Sales Territory String 16
DEFCACTY Default Cash Account Type0. Checkbook1. Customer Integer 2
RMCSHACC RM Cash Account Index Long Integer 4
RMARACC RM AR Account Index Long Integer 4
RMSLSACC RM Sales Account Index Long Integer 4
RMIVACC RM IV Account Index Long Integer 4
RMCOSACC RM Cost Of Sales Account Index Long Integer 4
RMTAKACC RM Discounts Taken Account Index Long Integer 4
RMAVACC RM Discounts Avail Account Index Long Integer 4
RMFCGACC RM Finance Charge Account Index Long Integer 4
RMWRACC RM Writeoff Account Index Long Integer 4
FRSTINDT First Invoice Date Date 4
INACTIVE Inactive Boolean 2
Active Status values (2)
0 = Active1 = Inactive
HOLD Hold Boolean 2
Hold Status values (2)
0 = Not on hold1 = On hold
CRCARDID Credit Card ID String 16
CRCRDNUM Credit Card Number String 22
CCRDXPDT Credit Card Exp Date Date 4
KPDSTHST Keep Distribution History Boolean 2
KPCALHST Keep Calendar History Boolean 2
KPERHIST Keep Period History Boolean 2
KPTRXHST Keep Trx History Boolean 2
Revalue_Customer Revalue Customer Boolean 2
Post_Results_To Post Results To Integer 2
FINCHID Finance Charge ID String 16
GOVCRPID Governmental Corporate ID String 32
GOVINDID Governmental Individual ID String 32
NOTEINDX Note Index Currency 10
PHONE3 Phone 3 String 22
DISGRPER Discount Grace Period Integer 2
DOCFMTID Document Format ID String 16
DUEGRPER Due Date Grace Period Integer 2
ORDERFULFILLDEFAULT Order Fulfillment Shortage Default Integer 2
SALSTERR1 ASI_Sales_Territory String 16
LOCNCODE Location Code String 12
USERDEF11 ASI_User_Defined_1 String 22
USERDEF21 ASI_User_Defined_2 String 22
CUSTPRIORITY Customer Priority Integer 2

Related Tables

Tables that share columns with ASIEXP15. 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

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP24

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 ASIEXP16

TAXSCHID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP16

PYMTRMID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP16

ADDRESS1

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08