GP Tables

ASIEXP24 - SmartList Customer Items

Dynamics GP table ASIEXP24 (SmartList Customer Items) contains 251 columns including ASI_Order_By, ITEMNMBR, CUSTNMBR....

SQL Query Builder

251 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
ITEMNMBR Item Number String 32
CUSTNMBR Customer Number String 16
ASICUSTITNO ASI Customer Item Number String 32
ASICUSTITDSC ASI Customer Item Description String 52
ASICUSTITSNM ASI Customer Item Short Name String 16
ASICUSTITGDSC ASI Customer Item Generic Description String 12
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
USRDEF03 User Defined 3 String 22
USRDEF04 User Defined 4 String 22
USRDEF05 User Defined 5 String 22
ASIUSERDEF1 ASI User Defined Key1 String 52
ASIUSERDEF2 ASI User Defined Key2 String 52
ASIUSERDEF3 ASI User Defined Key3 String 52
ASIUSERDEF4 ASI User Defined Key4 String 52
CUSTNAME Customer Name String 66
CUSTCLAS Customer Class String 16
CPRCSTNM Corporate Customer Number String 16
CNTCPRSN Contact Person String 62
STMTNAME Statement Name String 66
SHRTNAME Short Name String 16
ADRSCODE Address Code String 16
UPSZONE UPS Zone String 4
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
PRBTADCD Primary Billto Address Code String 16
PRSTADCD Primary Shipto Address Code String 16
STADDRCD Statement Address Code String 16
SLPRSNID Salesperson ID 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
USERDEF11 ASI_User_Defined_1 String 22
USERDEF21 ASI_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
NOTEINDX Note Index Currency 10
CREATDDT Created Date Date 4
MODIFDT Modified Date Date 4
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
TNSFCLIF Total Amount Of NSF Checks Life Currency 10
NONSFLIF Number Of NSF Checks Life Long Integer 4
CUSTBLNC Customer Balance Currency 10
AGPERAMT_1 Aging Period Amounts[1] Currency 10
AGPERAMT_2 Aging Period Amounts[2] Currency 10
AGPERAMT_3 Aging Period Amounts[3] Currency 10
AGPERAMT_4 Aging Period Amounts[4] Currency 10
AGPERAMT_5 Aging Period Amounts[5] Currency 10
AGPERAMT_6 Aging Period Amounts[6] Currency 10
AGPERAMT_7 Aging Period Amounts[7] Currency 10
LASTAGED Last Aged Date 4
LSTNSFCD Last NSF Check Date Date 4
LPYMTAMT Last Payment Amount Currency 10
LASTPYDT Last Payment Date Date 4
LSTTRXDT Last Transaction Date Date 4
LSTTRXAM Last Transaction Amount Currency 10
LSTFCHAM Last Finance Charge Amount Currency 10
UPFCHYTD Unpaid Finance Charges YTD Currency 10
AVDTPLYR Average Days to Pay - LYR Integer 2
AVDTPLIF Average Days To Pay - Life Integer 2
AVGDTPYR Average Days To Pay - Year Integer 2
NUMADTPL Number ADTP Documents - Life Long Integer 4
NUMADTPY Number ADTP Documents - Year Long Integer 4
NUMADTPR Number ADTP Documents - LYR Long Integer 4
TDTKNYTD Total Discounts Taken YTD Currency 10
TDTKNLYR Total Discounts Taken LYR Currency 10
TDTKNLTD Total Discounts Taken LTD Currency 10
TDISAYTD Total Discounts Available YTD Currency 10
RETAINAG Retainage Currency 10
TNSFCYTD Total Amount Of NSF Checks YTD Currency 10
NONSFYTD Number Of NSF Checks YTD Long Integer 4
UNPSTDSA Unposted Sales Amount Currency 10
UNPSTDCA Unposted Cash Amount Currency 10
UNPSTOSA Unposted Other Sales Amount Currency 10
UNPSTOCA Unposted Other Cash Amount Currency 10
NCSCHPMT Non Current Scheduled Payments Currency 10
TTLSLYTD Total Sales YTD Currency 10
TTLSLLTD Total Sales LTD Currency 10
TTLSLLYR Total Sales LYR Currency 10
TCOSTYTD Total Costs YTD Currency 10
TCOSTLTD Total Costs LTD Currency 10
TCOSTLYR Total Costs LYR Currency 10
TCSHRYTD Total Cash Received YTD Currency 10
TCSHRLTD Total Cash Received LTD Currency 10
TCSHRLYR Total Cash Received LYR Currency 10
TFNCHYTD Total Finance Charges YTD Currency 10
TFNCHLTD Total Finance Charges LTD Currency 10
TFNCHLYR Total Finance Charges LYR Currency 10
FNCHCYTD Finance Charges CYTD Currency 10
FNCHLYRC Finance Charges LYR Calendar Currency 10
TBDDTYTD Total Bad Debt YTD Currency 10
TBDDTLYR Total Bad Deb LYR Currency 10
TBDDTLTD Total Bad Debt LTD Currency 10
TWVFCYTD Total Waived FC YTD Currency 10
TWVFCLTD Total Waived FC LTD Currency 10
TWVFCLYR Total Waived FC LYR Currency 10
TWROFYTD Total Writeoffs YTD Currency 10
TWROFLTD Total Writeoffs LTD Currency 10
TWROFLYR Total Writeoffs LYR Currency 10
TTLINYTD Total # Invoices YTD Long Integer 4
TTLINLTD Total # Invoices LTD Long Integer 4
TTLINLYR Total # Invoices LYR Long Integer 4
TTLFCYTD Total # FC YTD Long Integer 4
TTLFCLTD Total # FC LTD Long Integer 4
TTLFCLYR Total # FC LYR Long Integer 4
WROFSLIF Write Offs LIFE Currency 10
WROFSLYR Write Offs LYR Currency 10
WROFSYTD Write Offs YTD Currency 10
HIBALLYR High Balance LYR Currency 10
HIBALYTD High Balance YTD Currency 10
HIBALLTD High Balance LTD Currency 10
LASTSTDT Last Statement Date Date 4
LSTSTAMT Last Statement Amount Currency 10
DEPRECV Deposits Received Currency 10
ONORDAMT On Order Amount Currency 10
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
DISGRPER Discount Grace Period Integer 2
DOCFMTID Document Format ID String 16
DUEGRPER Due Date Grace Period Integer 2
PHONE3 Phone 3 String 22
TTLRTLTD Total Returns LTD Currency 10
TTLRTLYR Total Returns LYR Currency 10
TTLRTYTD Total Returns YTD Currency 10
ITEMDESC Item Description String 102
NOTEINDX1 ASI_Note_Index Currency 10
ITMSHNAM Item Short Name String 16
ITEMTYPE Item Type1. Sales Inventory (For SBM, this type is Stock Item.)2. Discontinued3. Kit4. Misc Charges5. Services6. Flat Fee (For SBM, this type is Labor.) Integer 2
Item Type values (6)
1 = Sales Inventory2 = Discontinued3 = Kit4 = Misc Charges5 = Services6 = Flat Fee
ITMGEDSC Item Generic Description String 12
STNDCOST Standard Cost Currency 10
CURRCOST Current Cost Currency 10
ITEMSHWT Item Shipping Weight Long Integer 4
DECPLQTY Decimal Places QTYS Integer 2
DECPLCUR Decimal Places Currency Integer 2
ITMTSHID Item Tax Schedule ID String 16
TAXOPTNS Tax Options1.  Taxable2.  Nontaxable3.  Base on customers Integer 2
Tax Options values (3)
1 = Taxable2 = Nontaxable3 = Base on customer/vendor
IVIVINDX IV IV Index Long Integer 4
IVIVOFIX IV IV Offset Index Long Integer 4
IVCOGSIX IV COGS Index Long Integer 4
IVSLSIDX IV Sales Index Long Integer 4
IVSLDSIX IV Sales Discounts Index Long Integer 4
IVSLRNIX IV Sales Returns Index Long Integer 4
IVINUSIX IV In Use Index Long Integer 4
IVINSVIX IV In Service Index Long Integer 4
IVDMGIDX IV Damaged Index Long Integer 4
IVVARIDX IV Variances Index Long Integer 4
DPSHPIDX Drop Ship Index Long Integer 4
PURPVIDX Purchase Price Variance Index Long Integer 4
UPPVIDX Unrealized Purchase Price Variance Index Long Integer 4
IVRETIDX Inventory Returns Index Long Integer 4
ASMVRIDX Assembly Variance Index Long Integer 4
ITMCLSCD Item Class Code String 12
ITMTRKOP Item Tracking Option1. None2. Serial Numbers3. Lot Numbers Integer 2
Item Tracking Option values (3)
1 = None2 = Serial Numbers3 = Lot Numbers
LOTTYPE Lot Type String 12
KPERHIST1 ASI_Keep_Period_History Boolean 2
KPTRXHST1 ASI_Keep_Trx_History Boolean 2
KPCALHST1 ASI_Keep_Calendar_History Boolean 2
KPDSTHST1 ASI_Keep_Distribution_History Boolean 2
ALWBKORD Allow Back Orders Boolean 2
VCTNMTHD Valuation Method1. FIFO Perpetual2. LIFO Perpetual3. Average Perpetual4. FIFO Periodic (This value is not available for SBM.)5. LIFO Periodic (This value is not available for SBM.) Integer 2
Valuation Method values (5)
1 = FIFO Perpetual2 = LIFO Perpetual3 = Average Perpetual4 = FIFO Periodic5 = LIFO Periodic
UOMSCHDL U Of M Schedule String 12
ALTITEM1 Alternate Item 1 String 32
ALTITEM2 Alternate Item 2 String 32
USCATVLS_1 User Category Values[1] String 12
USCATVLS_2 User Category Values[2] String 12
USCATVLS_3 User Category Values[3] String 12
USCATVLS_4 User Category Values[4] String 12
USCATVLS_5 User Category Values[5] String 12
USCATVLS_6 User Category Values[6] String 12
MSTRCDTY Master Record Type Integer 2
MODIFDT1 ASI_Modified_Date Date 4
CREATDDT1 ASI_Created_Date Date 4
WRNTYDYS Warranty Days Integer 2
PRCLEVEL1 ASI_PriceLevel String 12
LOCNCODE Location Code String 12
PINFLIDX Purch Inflation Index Long Integer 4
PURMCIDX Purch Monetary Correction Index Long Integer 4
IVINFIDX Inventory Inflation Index Long Integer 4
INVMCIDX Inventory Monetary Correction Index Long Integer 4
CGSINFLX COGS Inflation Index Long Integer 4
CGSMCIDX COGS Monetary Correction Index Long Integer 4
ITEMCODE Item Code String 16
TCC Tax Commodity Code String 32
PriceGroup Price Group String 12
PRICMTHD Price Method1 – Currency Amount2 – % of List Price3 – % Markup – Current Cost4 – % Markup – Standard Cost5 – % Margin – Current Cost6 – % Margin – Standard Cost Integer 2
Price Method values (6)
1 = Currency Amount2 = % of List Price3 = % Markup - Current Cost4 = % Markup - Standard Cost5 = % Margin - Current Cost6 = % Margin - Standard Cost
PRCHSUOM Purchasing U Of M String 10
SELNGUOM Selling U Of M String 10
KTACCTSR Kit COGS Account Source0 – COGS accounts from the components1 – COGS account from the kit Integer 2
Kit COGS Account Source values (2)
0 = From component items1 = From kit item
LASTGENSN Last Generated Serial Number String 22
ABCCODE ABC Code1 – (None)2 – A3 – B4 – C Integer 2
STR30 STR30 String 32
ORDERFULFILLDEFAULT Order Fulfillment Shortage Default Integer 2
CUSTPRIORITY Customer Priority Integer 2
SUBITEMNMBR Substitute Item Number String 32

Related Tables

Tables that share columns with ASIEXP24. 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 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

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

ITEMNMBR

AAG20001 AAG20011 ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23