ASIEXP08 - SmartList Receivables Transaction | Prospr

ASIEXP08 - SmartList Receivables Transaction

Query Builder

Select * from ASIEXP08

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View
CPRCSTNM	Corporate Customer Number	String	16	View
DOCNUMBR	Document Number	String	22	View
CHEKNMBR	Check Number	String	22	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
TRXSORCE	TRX Source	String	14	View
CURNCYID	Currency ID	String	16	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
CSHRCTYP	Cash Receipt Type	Integer	2	View
DUEDATE	Due Date	Date	4	View
DOCDATE	Document Date	Date	4	View
SYSPSTDT	System Posted Date	Date	4	View
POSTDATE	Post Date	Date	4	View
PSTUSRID	Post User ID	String	16	View
LSTEDTDT	Last Edit Date	Date	4	View
LSTUSRED	Last User to Edit	String	16	View
ORTRXAMT	Original Trx Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
SLSAMNT	Sales Amount	Currency	10	View
COSTAMNT	Cost Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVAMT	Discount Available Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
WROFAMNT	Write Off Amount	Currency	10	View
TRXDSCRN	Transaction Description	String	32	View
CSPORNBR	Customer Purchase Order Number	String	22	View
SLPRSNID	Salesperson ID	String	16	View
SLSTERCD	Sales Territory Code	String	16	View
DINVPDOF	Date Invoice Paid Off	Date	4	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
GSTDSAMT	GST Discount Amount	Currency	10	View
DELETE1	Delete	Boolean	2	View
AGNGBUKT	Aging Bucket	Integer	2	View
VOIDED	Voided	Boolean	2	View
DOCABREV	Document Abbreviation	String	4	View
DSCRIPTN	Description	String	32	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
TRDISAMT	Trade Discount Amount	Currency	10	View
GLPOSTDT	GL Posting Date	Date	4	View
CURRNIDX	Currency Index	Integer	2	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
ORCTRXAM	Originating Current Trx Amount	Currency	10	View
ORSLSAMT	Originating Sales Amount	Currency	10	View
ORCSTAMT	Originating Cost Amount	Currency	10	View
ORFRTAMT	Originating Freight Amount	Currency	10	View
ORMISCAMT	Originating Misc Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
ORCASAMT	Originating Cash Amount	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
ORDAVAMT	Originating Discount Available Amount	Currency	10	View
ORDATKN	Originating Discount Available Taken	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
ORORGTRX	Originating Original Trx Amount	Currency	10	View
ORWROFAM	Originating Write Off Amount	Currency	10	View
AGPERAMT_1	Aging Period Amounts[1]	Currency	10	View
AGPERAMT_2	Aging Period Amounts[2]	Currency	10	View
AGPERAMT_3	Aging Period Amounts[3]	Currency	10	View
AGPERAMT_4	Aging Period Amounts[4]	Currency	10	View
AGPERAMT_5	Aging Period Amounts[5]	Currency	10	View
AGPERAMT_6	Aging Period Amounts[6]	Currency	10	View
AGPERAMT_7	Aging Period Amounts[7]	Currency	10	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = 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	View
Aging_Period_Amount	Aging Period Amount	Currency	10	View
RATETPID	Rate Type ID	String	16	View
CBKIDCSH	Checkbook ID Cash	String	16	View
CBKIDCHK	Checkbook ID Check	String	16	View
CBKIDCRD	Checkbook ID Credit Card	String	16	View
DISAVTKN	Discount Available Taken	Currency	10	View
DISCRTND	Discount Returned	Currency	10	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
VOIDDATE	Void Date	Date	4	View
TAXSCHID	Tax Schedule ID	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
SHIPMTHD	Shipping Method	String	16	View
SLSCHDID	Sales Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
ADRSCODE	Address Code	String	16	View
DOCPRFIX	Document Prefix	String	4	View
DOCDESCR	Document Description	String	32	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
COMAPPTO	Commission Applied To	Integer	2	View
NCOMAMNT	Non-Commissioned Amount	Currency	10	View
SALSTERR	Sales Territory	String	16	View
CSTPONBR	Customer PO Number	String	22	View
BKTSLSAM	Backout Sales Amount	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
TXENGCLD	Tax Engine Called	Boolean	2	View
DOCAMNT	Document Amount	Currency	10	View
APPLDAMT	Applied Amount	Currency	10	View
CASHDATE	Cash Date	Date	4	View
DCNUMCSH	Document Number Cash	String	22	View
CHEKAMNT	Check Amount	Currency	10	View
CHEKDATE	Check Date	Date	4	View
DCNUMCHK	Document Number Check	String	22	View
CRCRDAMT	Credit Card Amount	Currency	10	View
CRCRDNAM	Credit Card Name	String	16	View
RCTNCCRD	Receipt Number Credit Card	String	22	View
CRCARDDT	Credit Card Date	Date	4	View
DCNUMCRD	Document Number Credit Card	String	22	View
ACCTAMNT	Account Amount	Currency	10	View
TRDDISCT	Trade Discount	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
POSTED	Posted	Boolean	2	View
Tax_Date	Tax Date	Date	4	View
APLYWITH	Apply Withholding	Boolean	2	View
SALEDATE	Sale Date	Date	4	View
CORRCTN	Correction	Boolean	2	View
SIMPLIFD	Simplified	Boolean	2	View
BALFWDNM	Balance Forward Number	String	22	View
RMTREMSG	RM TRX Posting Error Messages	Long Integer	4	View
RMDPEMSG	RM Dist Posting Error Messages	Long Integer	4	View
EXGTBLID	Exchange Table ID	String	16	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
ORCHKAMT	Originating Check Amount	Currency	10	View
ORCCDAMT	Originating Credit Card Amount	Currency	10	View
ORAPPAMT	Originating Applied Amount	Currency	10	View
ORDISRTD	Originating Discount Returned	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
ORCOMAMT	Originating Commission Dollar Amount	Currency	10	View
ORBKTSLS	Originating Backout Sales Amount	Currency	10	View
ORBKTFRT	Originating Backout Freight Amount	Currency	10	View
ORBKTMSC	Originating Backout Misc Amount	Currency	10	View
UNGANLOS	Unrealized Gain-Loss Amount	Currency	10	View
RMMCERRS	RM MC Posting Error Messages	Long Integer	4	View
CUSTCLAS	Customer Class	String	16	View
CNTCPRSN	Contact Person	String	62	View
STMTNAME	Statement Name	String	66	View
SHRTNAME	Short Name	String	16	View
UPSZONE	UPS Zone	String	4	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
COUNTRY	Country	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIP	Zip	String	12	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAX	Fax	String	22	View
PRBTADCD	Primary Billto Address Code	String	16	View
PRSTADCD	Primary Shipto Address Code	String	16	View
STADDRCD	Statement Address Code	String	16	View
CHEKBKID	Checkbook ID	String	16	View
CRLMTTYP	Credit Limit Type	Integer	2	View
CRLMTAMT	Credit Limit Amount	Currency	10	View
CRLMTPER	Credit Limit Period	Integer	2	View
CRLMTPAM	Credit Limit Period Amount	Currency	10	View
CUSTDISC	Customer Discount	Integer	2	View
PRCLEVEL	PriceLevel	String	12	View
MINPYTYP	Minimum Payment Type	Integer	2	View
MINPYDLR	Minimum Payment Dollar	Currency	10	View
MINPYPCT	Minimum Payment Percent	Integer	2	View
FNCHPCNT	Finance Charge Percent	Integer	2	View
FINCHDLR	Finance Charge Dollar	Currency	10	View
FNCHATYP	Finance Charge Amt Type	Integer	2	View
MXWOFTYP	Maximum Writeoff Type	Integer	2	View
MXWROFAM	Max Writeoff Amount	Currency	10	View
COMMENT1	Comment1	String	32	View
COMMENT2	Comment2	String	32	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
TXRGNNUM	Tax Registration Number	String	26	View
BALNCTYP	Balance Type	Integer	2	View
STMTCYCL	Statement Cycle 1. No Statement 2. Weekly 3. Biweekly 4. Semi Monthly 5. Monthly 6. Bimonthly 7. Quarterly	Integer	2	View
BANKNAME	Bank Name	String	32	View
BNKBRNCH	Bank Branch	String	22	View
DEFCACTY	Default Cash Account Type 0. Checkbook 1. Customer	Integer	2	View
RMCSHACC	RM Cash Account Index	Long Integer	4	View
RMARACC	RM AR Account Index	Long Integer	4	View
RMSLSACC	RM Sales Account Index	Long Integer	4	View
RMIVACC	RM IV Account Index	Long Integer	4	View
RMCOSACC	RM Cost Of Sales Account Index	Long Integer	4	View
RMTAKACC	RM Discounts Taken Account Index	Long Integer	4	View
RMAVACC	RM Discounts Avail Account Index	Long Integer	4	View
RMFCGACC	RM Finance Charge Account Index	Long Integer	4	View
RMWRACC	RM Writeoff Account Index	Long Integer	4	View
FRSTINDT	First Invoice Date	Date	4	View
INACTIVE	Inactive	Boolean	2	View
HOLD	Hold	Boolean	2	View
CRCARDID	Credit Card ID	String	16	View
CRCRDNUM	Credit Card Number	String	22	View
CCRDXPDT	Credit Card Exp Date	Date	4	View
KPDSTHST	Keep Distribution History	Boolean	2	View
KPCALHST	Keep Calendar History	Boolean	2	View
KPERHIST	Keep Period History	Boolean	2	View
KPTRXHST	Keep Trx History	Boolean	2	View
Revalue_Customer	Revalue Customer	Boolean	2	View
Post_Results_To	Post Results To	Integer	2	View
FINCHID	Finance Charge ID	String	16	View
GOVCRPID	Governmental Corporate ID	String	32	View
GOVINDID	Governmental Individual ID	String	32	View
TNSFCLIF	Total Amount Of NSF Checks Life	Currency	10	View
NONSFLIF	Number Of NSF Checks Life	Long Integer	4	View
CUSTBLNC	Customer Balance	Currency	10	View
LASTAGED	Last Aged	Date	4	View
LSTNSFCD	Last NSF Check Date	Date	4	View
LPYMTAMT	Last Payment Amount	Currency	10	View
LASTPYDT	Last Payment Date	Date	4	View
LSTTRXDT	Last Transaction Date	Date	4	View
LSTTRXAM	Last Transaction Amount	Currency	10	View
LSTFCHAM	Last Finance Charge Amount	Currency	10	View
UPFCHYTD	Unpaid Finance Charges YTD	Currency	10	View
AVDTPLIF	Average Days To Pay - Life	Integer	2	View
AVDTPLYR	Average Days to Pay - LYR	Integer	2	View
AVGDTPYR	Average Days To Pay - Year	Integer	2	View
NUMADTPL	Number ADTP Documents - Life	Long Integer	4	View
NUMADTPR	Number ADTP Documents - LYR	Long Integer	4	View
NUMADTPY	Number ADTP Documents - Year	Long Integer	4	View
TDTKNLTD	Total Discounts Taken LTD	Currency	10	View
TDTKNLYR	Total Discounts Taken LYR	Currency	10	View
TDTKNYTD	Total Discounts Taken YTD	Currency	10	View
TDISAYTD	Total Discounts Available YTD	Currency	10	View
RETAINAG	Retainage	Currency	10	View
TNSFCYTD	Total Amount Of NSF Checks YTD	Currency	10	View
NONSFYTD	Number Of NSF Checks YTD	Long Integer	4	View
UNPSTDSA	Unposted Sales Amount	Currency	10	View
UNPSTDCA	Unposted Cash Amount	Currency	10	View
UNPSTOCA	Unposted Other Cash Amount	Currency	10	View
UNPSTOSA	Unposted Other Sales Amount	Currency	10	View
NCSCHPMT	Non Current Scheduled Payments	Currency	10	View
TTLSLLTD	Total Sales LTD	Currency	10	View
TTLSLLYR	Total Sales LYR	Currency	10	View
TTLSLYTD	Total Sales YTD	Currency	10	View
TCOSTLTD	Total Costs LTD	Currency	10	View
TCOSTLYR	Total Costs LYR	Currency	10	View
TCOSTYTD	Total Costs YTD	Currency	10	View
TCSHRLTD	Total Cash Received LTD	Currency	10	View
TCSHRLYR	Total Cash Received LYR	Currency	10	View
TCSHRYTD	Total Cash Received YTD	Currency	10	View
TFNCHLTD	Total Finance Charges LTD	Currency	10	View
TFNCHLYR	Total Finance Charges LYR	Currency	10	View
TFNCHYTD	Total Finance Charges YTD	Currency	10	View
FNCHCYTD	Finance Charges CYTD	Currency	10	View
FNCHLYRC	Finance Charges LYR Calendar	Currency	10	View
TBDDTLYR	Total Bad Deb LYR	Currency	10	View
TBDDTLTD	Total Bad Debt LTD	Currency	10	View
TBDDTYTD	Total Bad Debt YTD	Currency	10	View
TWVFCLTD	Total Waived FC LTD	Currency	10	View
TWVFCLYR	Total Waived FC LYR	Currency	10	View
TWVFCYTD	Total Waived FC YTD	Currency	10	View
TWROFLTD	Total Writeoffs LTD	Currency	10	View
TWROFLYR	Total Writeoffs LYR	Currency	10	View
TWROFYTD	Total Writeoffs YTD	Currency	10	View
TTLINLTD	Total # Invoices LTD	Long Integer	4	View
TTLINLYR	Total # Invoices LYR	Long Integer	4	View
TTLINYTD	Total # Invoices YTD	Long Integer	4	View
TTLFCLTD	Total # FC LTD	Long Integer	4	View
TTLFCLYR	Total # FC LYR	Long Integer	4	View
TTLFCYTD	Total # FC YTD	Long Integer	4	View
WROFSLIF	Write Offs LIFE	Currency	10	View
WROFSLYR	Write Offs LYR	Currency	10	View
WROFSYTD	Write Offs YTD	Currency	10	View
HIBALLTD	High Balance LTD	Currency	10	View
HIBALLYR	High Balance LYR	Currency	10	View
HIBALYTD	High Balance YTD	Currency	10	View
LASTSTDT	Last Statement Date	Date	4	View
LSTSTAMT	Last Statement Amount	Currency	10	View
DEPRECV	Deposits Received	Currency	10	View
ONORDAMT	On Order Amount	Currency	10	View
DISGRPER	Discount Grace Period	Integer	2	View
DOCFMTID	Document Format ID	String	16	View
DUEGRPER	Due Date Grace Period	Integer	2	View
ECTRX	EC Transaction	Boolean	2	View
Electronic	Electronic	Boolean	2	View
CORRNXST	Correction to Nonexisting Transaction	Boolean	2	View
DocPrinted	DocPrinted	Boolean	2	View
DOCNCORR	Document Number Corrected	String	22	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
RMTREMSG2	RM TRX Posting Error Messages 2	Long Integer	4	View
CUSTNAME1	ASI_Customer_Name	String	66	View
CPRCSTNM1	ASI_Corporate_Customer_Number	String	16	View
ASI_Address_Code	ASI_Address_Code	String	16	View
SHIPMTHD1	ASI_Shipping_Method	String	16	View
TAXSCHID1	ASI_Tax_Schedule_ID	String	16	View
SLPRSNID1	ASI_Salesperson_ID	String	16	View
PYMTRMID1	ASI_Payment_Terms_ID	String	22	View
CURNCYID1	ASI_Currency_ID	String	16	View
RATETPID1	ASI_Rate_Type_ID	String	16	View
SALSTERR1	ASI_Sales_Territory	String	16	View
NOTEINDX1	ASI_Note_Index	Currency	10	View
CREATDDT1	ASI_Created_Date	Date	4	View
MODIFDT1	ASI_Modified_Date	Date	4	View
DISGRPER1	ASI_Discount_Grace_Period	Integer	2	View
DUEGRPER1	ASI_Due_Date_Grace_Period	Integer	2	View
Factoring	Factoring	Boolean	2	View
ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	2	View
CUSTPRIORITY	Customer Priority	Integer	2	View

ASIEXP08 - SmartList Receivables Transaction

Query Builder

Customer Service

Information

My Account

Contact Us