GP Tables

ASIEXP08 - SmartList Receivables Transaction

Dynamics GP table ASIEXP08 (SmartList Receivables Transaction) contains 307 columns including ASI_Order_By, CUSTNMBR, CUSTNAME....

SQL Query Builder

307 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
CUSTNMBR Customer Number String 16
CUSTNAME Customer Name String 66
ASI_Document_Status ASI_Document_Status Integer 2
CPRCSTNM Corporate Customer Number String 16
DOCNUMBR Document Number String 22
CHEKNMBR Check Number String 22
BACHNUMB Batch Number String 16
BCHSOURC Batch Source String 16
TRXSORCE TRX Source String 14
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
RMDTYPAL RM Document Type-All0 = Reserved for balance carried forward records1 = Sales / Invoice2 = Reserved for schedule payments3 = Debit Memos4 = Finance Charges5 = Service Repairs6= Warranties7 = Credit Memos8 = Returns9 = Payments Integer 2
CSHRCTYP Cash Receipt Type Integer 2
DUEDATE Due Date Date 4
DOCDATE Document Date Date 4
SYSPSTDT System Posted Date Date 4
POSTDATE Post Date Date 4
PSTUSRID Post User ID String 16
LSTEDTDT Last Edit Date Date 4
LSTUSRED Last User to Edit String 16
ORTRXAMT Original Trx Amount Currency 10
CURTRXAM Current Trx Amount Currency 10
SLSAMNT Sales Amount Currency 10
COSTAMNT Cost Amount Currency 10
FRTAMNT Freight Amount Currency 10
MISCAMNT Misc Amount Currency 10
TAXAMNT Tax Amount Currency 10
COMDLRAM Commission Dollar Amount Currency 10
CASHAMNT Cash Amount Currency 10
DISTKNAM Discount Taken Amount Currency 10
DISAVAMT Discount Available Amount Currency 10
DISCDATE Discount Date Date 4
WROFAMNT Write Off Amount Currency 10
TRXDSCRN Transaction Description String 32
CSPORNBR Customer Purchase Order Number String 22
SLPRSNID Salesperson ID String 16
SLSTERCD Sales Territory Code String 16
DINVPDOF Date Invoice Paid Off Date 4
PPSAMDED PPS Amount Deducted Currency 10
GSTDSAMT GST Discount Amount Currency 10
DELETE1 Delete Boolean 2
AGNGBUKT Aging Bucket Integer 2
VOIDED Voided Boolean 2
DOCABREV Document Abbreviation String 4
DSCRIPTN Description String 32
VOIDSTTS Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. Integer 2
Void Status values (2)
0 = Normal1 = Voided
TRDISAMT Trade Discount Amount Currency 10
GLPOSTDT GL Posting Date Date 4
CURRNIDX Currency Index Integer 2
XCHGRATE Exchange Rate Currency (Variable) 10
ORCTRXAM Originating Current Trx Amount Currency 10
ORSLSAMT Originating Sales Amount Currency 10
ORCSTAMT Originating Cost Amount Currency 10
ORFRTAMT Originating Freight Amount Currency 10
ORMISCAMT Originating Misc Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
ORCASAMT Originating Cash Amount Currency 10
ORDISTKN Originating Discount Taken Amount Currency 10
ORDAVAMT Originating Discount Available Amount Currency 10
ORDATKN Originating Discount Available Taken Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
ORORGTRX Originating Original Trx Amount Currency 10
ORWROFAM Originating Write Off Amount 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
DENXRATE Denomination Exchange Rate Currency (Variable) 10
MCTRXSTT MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = Originating is not a denomination; Functional is the Euro currency.3 = Originating is not a denomination; Functional is a denomination.4 = Originating is a denomination; Functional is not a denomination.5 = Originating is a denomination; Functional is a denomination.6 = Originating is a denomination; Functional is the Euro currency.7 = Originating is the Euro currency; Functional is a denomination.8 = Originating is the Euro currency; Functional is not a denomination. Integer 2
Aging_Period_Amount Aging Period Amount Currency 10
RATETPID Rate Type ID String 16
CBKIDCSH Checkbook ID Cash String 16
CBKIDCHK Checkbook ID Check String 16
CBKIDCRD Checkbook ID Credit Card String 16
DISAVTKN Discount Available Taken Currency 10
DISCRTND Discount Returned Currency 10
DSCDLRAM Discount Dollar Amount Currency 10
DSCPCTAM Discount Percent Amount Integer 2
VOIDDATE Void Date Date 4
TAXSCHID Tax Schedule ID String 16
PYMTRMID Payment Terms ID String 22
SHIPMTHD Shipping Method String 16
SLSCHDID Sales Schedule ID String 16
FRTSCHID Freight Schedule ID String 16
MSCSCHID Misc Schedule ID String 16
ADRSCODE Address Code String 16
DOCPRFIX Document Prefix String 4
DOCDESCR Document Description String 32
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
COMAPPTO Commission Applied To Integer 2
NCOMAMNT Non-Commissioned Amount Currency 10
SALSTERR Sales Territory String 16
CSTPONBR Customer PO Number String 22
BKTSLSAM Backout Sales Amount Currency 10
BKTFRTAM Backout Freight Amount Currency 10
BKTMSCAM Backout Misc Amount Currency 10
TXENGCLD Tax Engine Called Boolean 2
DOCAMNT Document Amount Currency 10
APPLDAMT Applied Amount Currency 10
CASHDATE Cash Date Date 4
DCNUMCSH Document Number Cash String 22
CHEKAMNT Check Amount Currency 10
CHEKDATE Check Date Date 4
DCNUMCHK Document Number Check String 22
CRCRDAMT Credit Card Amount Currency 10
CRCRDNAM Credit Card Name String 16
RCTNCCRD Receipt Number Credit Card String 22
CRCARDDT Credit Card Date Date 4
DCNUMCRD Document Number Credit Card String 22
ACCTAMNT Account Amount Currency 10
TRDDISCT Trade Discount Integer 2
NOTEINDX Note Index Currency 10
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
POSTED Posted Boolean 2
Tax_Date Tax Date Date 4
APLYWITH Apply Withholding Boolean 2
SALEDATE Sale Date Date 4
CORRCTN Correction Boolean 2
SIMPLIFD Simplified Boolean 2
BALFWDNM Balance Forward Number String 22
RMTREMSG RM TRX Posting Error Messages Long Integer 4
RMDPEMSG RM Dist Posting Error Messages Long Integer 4
EXGTBLID Exchange Table ID String 16
EXCHDATE Exchange Date Date 4
TIME1 Time Time 4
RTCLCMTD Rate Calculation Method Integer 2
ORCHKAMT Originating Check Amount Currency 10
ORCCDAMT Originating Credit Card Amount Currency 10
ORAPPAMT Originating Applied Amount Currency 10
ORDISRTD Originating Discount Returned Currency 10
ORDDLRAT Originating Discount Dollar Amount Currency 10
ORCOMAMT Originating Commission Dollar Amount Currency 10
ORBKTSLS Originating Backout Sales Amount Currency 10
ORBKTFRT Originating Backout Freight Amount Currency 10
ORBKTMSC Originating Backout Misc Amount Currency 10
UNGANLOS Unrealized Gain-Loss Amount Currency 10
RMMCERRS RM MC Posting Error Messages Long Integer 4
CUSTCLAS Customer Class String 16
CNTCPRSN Contact Person String 62
STMTNAME Statement Name String 66
SHRTNAME Short Name String 16
UPSZONE UPS Zone String 4
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
PHONE3 Phone 3 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
CHEKBKID Checkbook ID String 16
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
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
FNCHPCNT Finance Charge Percent Integer 2
FINCHDLR Finance Charge Dollar Currency 10
FNCHATYP Finance Charge Amt Type Integer 2
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
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
TNSFCLIF Total Amount Of NSF Checks Life Currency 10
NONSFLIF Number Of NSF Checks Life Long Integer 4
CUSTBLNC Customer Balance 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
AVDTPLIF Average Days To Pay - Life Integer 2
AVDTPLYR Average Days to Pay - LYR Integer 2
AVGDTPYR Average Days To Pay - Year Integer 2
NUMADTPL Number ADTP Documents - Life Long Integer 4
NUMADTPR Number ADTP Documents - LYR Long Integer 4
NUMADTPY Number ADTP Documents - Year Long Integer 4
TDTKNLTD Total Discounts Taken LTD Currency 10
TDTKNLYR Total Discounts Taken LYR Currency 10
TDTKNYTD Total Discounts Taken YTD 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
UNPSTOCA Unposted Other Cash Amount Currency 10
UNPSTOSA Unposted Other Sales Amount Currency 10
NCSCHPMT Non Current Scheduled Payments Currency 10
TTLSLLTD Total Sales LTD Currency 10
TTLSLLYR Total Sales LYR Currency 10
TTLSLYTD Total Sales YTD Currency 10
TCOSTLTD Total Costs LTD Currency 10
TCOSTLYR Total Costs LYR Currency 10
TCOSTYTD Total Costs YTD Currency 10
TCSHRLTD Total Cash Received LTD Currency 10
TCSHRLYR Total Cash Received LYR Currency 10
TCSHRYTD Total Cash Received YTD Currency 10
TFNCHLTD Total Finance Charges LTD Currency 10
TFNCHLYR Total Finance Charges LYR Currency 10
TFNCHYTD Total Finance Charges YTD Currency 10
FNCHCYTD Finance Charges CYTD Currency 10
FNCHLYRC Finance Charges LYR Calendar Currency 10
TBDDTLYR Total Bad Deb LYR Currency 10
TBDDTLTD Total Bad Debt LTD Currency 10
TBDDTYTD Total Bad Debt YTD Currency 10
TWVFCLTD Total Waived FC LTD Currency 10
TWVFCLYR Total Waived FC LYR Currency 10
TWVFCYTD Total Waived FC YTD Currency 10
TWROFLTD Total Writeoffs LTD Currency 10
TWROFLYR Total Writeoffs LYR Currency 10
TWROFYTD Total Writeoffs YTD Currency 10
TTLINLTD Total # Invoices LTD Long Integer 4
TTLINLYR Total # Invoices LYR Long Integer 4
TTLINYTD Total # Invoices YTD Long Integer 4
TTLFCLTD Total # FC LTD Long Integer 4
TTLFCLYR Total # FC LYR Long Integer 4
TTLFCYTD Total # FC YTD Long Integer 4
WROFSLIF Write Offs LIFE Currency 10
WROFSLYR Write Offs LYR Currency 10
WROFSYTD Write Offs YTD Currency 10
HIBALLTD High Balance LTD Currency 10
HIBALLYR High Balance LYR Currency 10
HIBALYTD High Balance YTD 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
DISGRPER Discount Grace Period Integer 2
DOCFMTID Document Format ID String 16
DUEGRPER Due Date Grace Period Integer 2
ECTRX EC Transaction Boolean 2
Electronic Electronic Boolean 2
CORRNXST Correction to Nonexisting Transaction Boolean 2
DocPrinted DocPrinted Boolean 2
DOCNCORR Document Number Corrected String 22
PSTGSTUS Posting Status1 = Work2 = Open3 = History4 = Originating Integer 2
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
RMTREMSG2 RM TRX Posting Error Messages 2 Long Integer 4
CUSTNAME1 ASI_Customer_Name String 66
CPRCSTNM1 ASI_Corporate_Customer_Number String 16
ASI_Address_Code ASI_Address_Code String 16
SHIPMTHD1 ASI_Shipping_Method String 16
TAXSCHID1 ASI_Tax_Schedule_ID String 16
SLPRSNID1 ASI_Salesperson_ID String 16
PYMTRMID1 ASI_Payment_Terms_ID String 22
CURNCYID1 ASI_Currency_ID String 16
RATETPID1 ASI_Rate_Type_ID String 16
SALSTERR1 ASI_Sales_Territory String 16
NOTEINDX1 ASI_Note_Index Currency 10
CREATDDT1 ASI_Created_Date Date 4
MODIFDT1 ASI_Modified_Date Date 4
DISGRPER1 ASI_Discount_Grace_Period Integer 2
DUEGRPER1 ASI_Due_Date_Grace_Period Integer 2
Factoring Factoring Boolean 2
ORDERFULFILLDEFAULT Order Fulfillment Shortage Default Integer 2
CUSTPRIORITY Customer Priority Integer 2

Related Tables

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

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP24

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19 ASIEXP20

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

BACHNUMB

ASIEXP06 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25 ASIEXP27