ASIEXP09 - SmartList Payables Transactions | Prospr

ASIEXP09 - SmartList Payables Transactions

Query Builder

Select * from ASIEXP09

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
VENDORID	Vendor ID	String	16	View
DOCNUMBR	Document Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
DOCAMNT	Document Amount	Currency	10	View
DOCDATE	Document Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
VADDCDPR	Vendor Address Code - Primary	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
TAXSCHID	Tax Schedule ID	String	16	View
DUEDATE	Due Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
PRCHAMNT	Purchases Amount	Currency	10	View
CHRGAMNT	Charge Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
CAMCBKID	Cash Amount Checkbook ID	String	16	View
CDOCNMBR	Cash Document Number	String	22	View
CAMTDATE	Cash Amount Date	Date	4	View
CAMPMTNM	Cash Amount Payment Number	String	22	View
CHEKAMNT	Check Amount	Currency	10	View
CHAMCBID	Check Amount Checkbook ID	String	16	View
CHEKDATE	Check Date	Date	4	View
CAMPYNBR	Check Amount Payment Number	String	22	View
CRCRDAMT	Credit Card Amount	Currency	10	View
CCAMPYNM	Credit Card Amount Payment Number	String	22	View
CHEKNMBR	Check Number	String	22	View
CARDNAME	Card Name	String	16	View
CCRCTNUM	Credit Card Receipt Number	String	22	View
CRCARDDT	Credit Card Date	Date	4	View
CURNCYID	Currency ID	String	16	View
CHEKBKID	Checkbook ID	String	16	View
TRXDSCRN	Transaction Description	String	32	View
UN1099AM	Unapplied 1099 Amount	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
TEN99AMNT	1099 Amount	Currency	10	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
PORDNMBR	Purchase Order Number	String	22	View
SHIPMTHD	Shipping Method	String	16	View
DISAMTAV	Discount Amount Available	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
APDSTKAM	Applied Discount Taken Amount	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
TXENGCLD	Tax Engine Called	Boolean	2	View
PMWRKMSG	PM WORK Messages	Long Integer	4	View
PMDSTMSG	PM Distribution Messages	Long Integer	4	View
GSTDSAMT	GST Discount Amount	Currency	10	View
PGRAMSBJ	Percent Of Gross Amount Subject	Integer	2	View
PPSAMDED	PPS Amount Deducted	Currency	10	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
POSTED	Posted	Boolean	2	View
APPLDAMT	Applied Amount	Currency	10	View
VCHRNMBR	Voucher Number	String	22	View
CNTRLTYP	Control Type	Integer	2	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
NOTEINDX	Note Index	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
PCHSCHID	Purchase Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
PRINTED	Printed	Boolean	2	View
PRCTDISC	Percent Discount	Integer	2	View
RETNAGAM	Retainage Amount	Currency	10	View
ICTRX	IC TRX	Boolean	2	View
ICDISTS	ICDists	Boolean	2	View
PMICMSGS	ICMessages 1 The currency ID is missing. 2 A destination company does not have access to this currency ID. 3 The currency ID is inactive for a destination company. 4 A rate type ID is missing for a destination company. 5 Rate type ID is not associated with the currency ID for a destination company. 6 An exchange table ID is missing for a destination company. 7 A destination company does not have access to an exchange table ID. 8 An exchange table ID is inactive for a destination company. 9 An exchange rate does not exist for a destination company. 10 An exchange rate has expired for a destination company. 11 Cannot post intercompany multicurrency transactions to a recurring batch. 12 A rounding account missing for a destination company. 13 A distribution type is invalid for a destination company distribution. 14 A destination company distribution contains MDA information. 15 A destination company ID does not exist; please select another company ID. 16 The user does not have access to a destination company. 17 A destination company does not have a functional currency set up. 18 Destination functional currency doesn't match originating functional currency. 19 No relationship exists between originating company and a destination company. 20 Due To / Due From account not specified. 21 The rounding account does not exist for the originating company. 22 Unknown SQL error occurred. 23 Intrastat information is missing or invalid. 24 The goods value for Intrastat exceeds the document total. 25 Transaction has successfully posted.	Long Integer	4	View
Tax_Date	Tax Date	Date	4	View
DISCAMNT	Discount Amount	Currency	10	View
TRXSORCE	TRX Source	String	14	View
VOIDED	Voided	Boolean	2	View
HOLD	Hold	Boolean	2	View
DINVPDOF	Date Invoice Paid Off	Date	4	View
PYENTTYP	Payment Entry Type	Integer	2	View
TTLPYMTS	Total Payments	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
VOIDPDATE	Void GL Posting Date	Date	4	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
DCSTATUS	Document Status 1 = Work 2 = Open 3 = History	Integer	2	View
PMNTNMBR	Payment Number	String	22	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
ORCTRXAM	Originating Current Trx Amount	Currency	10	View
OPURAMT	Originating Purchases Amount	Currency	10	View
ORFRTAMT	Originating Freight Amount	Currency	10	View
OMISCAMT	Originating Misc Charges Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
ORCASAMT	Originating Cash Amount	Currency	10	View
ORCHKAMT	Originating Check Amount	Currency	10	View
ORCHKTTL	Originating Check Total	Currency	10	View
ORCCDAMT	Originating Credit Card Amount	Currency	10	View
ORAPPAMT	Originating Applied Amount	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
ORDATKN	Originating Discount Available Taken	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
ORWROFAM	Originating Write Off Amount	Currency	10	View
OBKPURAMT	Originating Backout Purchases 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
OCHGAMT	Originating Charge Amount	Currency	10	View
ORDOCAMT	Originating Document Amount	Currency	10	View
ODISAMTAV	Originating Discount Amount Available	Currency	10	View
ORGAPDISCTKN	Originating Applied Discount Taken Amount	Currency	10	View
OTOTPAY	Originating Total Payments	Currency	10	View
OR1099AM	Originating 1099 Amount	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
VENDNAME	Vendor Name	String	66	View
VNDCHKNM	Vendor Check Name	String	66	View
VENDSHNM	Vendor Short Name	String	16	View
VADCDPAD	Vendor Address Code - Purchase Address	String	16	View
VADCDSFR	Vendor Address Code - Ship From	String	16	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View
VNDCLSID	Vendor Class ID	String	12	View
VNDCNTCT	Vendor Contact	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTRY	Country	String	62	View
PHNUMBR1	Phone Number 1	String	22	View
PHNUMBR2	Phone Number 2	String	22	View
FAXNUMBR	Fax Number	String	22	View
UPSZONE	UPS Zone	String	4	View
ACNMVNDR	Account Number With Vendor	String	22	View
TXIDNMBR	Tax ID Number	String	12	View
VENDSTTS	Vendor Status 1. Active 2. Inactive 3. Temporary	Integer	2	View
TXRGNNUM	Tax Registration Number	String	26	View
PARVENID	Parent Vendor ID	String	16	View
TRDDISCT	Trade Discount	Integer	2	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
MINORDER	Minimum Order	Currency	10	View
MINPYTYP	Minimum Payment Type	Integer	2	View
MINPYPCT	Minimum Payment Percent	Integer	2	View
MINPYDLR	Minimum Payment Dollar	Currency	10	View
MXIAFVND	Maximum Invoice Amount For Vendors	Integer	2	View
MAXINDLR	Maximum Invoice Dollar	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
CRLMTDLR	Credit Limit Dollar	Currency	10	View
PYMNTPRI	Payment Priority	String	4	View
KPCALHST	Keep Calendar History	Boolean	2	View
KGLDSTHS	Keep GL Dist History	Boolean	2	View
KPERHIST	Keep Period History	Boolean	2	View
KPTRXHST	Keep Trx History	Boolean	2	View
PTCSHACF	Post To Cash Account From	Integer	2	View
CREDTLMT	Credit Limit	Integer	2	View
WRITEOFF	Writeoff	Integer	2	View
MXWOFAMT	Maximum Write Off Amount	Currency	10	View
SBPPSDED	Subject To PPS Deductions	Boolean	2	View
DXVARNUM	Deduction Exemption/Variation Number	String	26	View
CRTCOMDT	Certificate Commencing Date	Date	4	View
CRTEXPDT	Certificate Expiration Date	Date	4	View
RTOBUTKN	Reporting Obligation Undertaken	Boolean	2	View
XPDTOBLG	Expiration Date Obligation	Boolean	2	View
PRSPAYEE	Prescribed Payee	Boolean	2	View
PMAPINDX	PM AP Index	Long Integer	4	View
PMCSHIDX	PM Cash Index	Long Integer	4	View
PMDAVIDX	PM Discount Available Index	Long Integer	4	View
PMDTKIDX	PM Discount Taken Index	Long Integer	4	View
PMFINIDX	PM Finance Charge Index	Long Integer	4	View
PMMSCHIX	PM Misc Charges Index	Long Integer	4	View
PMFRTIDX	PM Freight Index	Long Integer	4	View
PMTAXIDX	PM Tax Index	Long Integer	4	View
PMWRTIDX	PM Write Offs Index	Long Integer	4	View
PMPRCHIX	PM Purchases Index	Long Integer	4	View
PMRTNGIX	PM Retainage Index	Long Integer	4	View
PMTDSCIX	PM Trade Discount Index	Long Integer	4	View
ACPURIDX	Accrued Purchases Index	Long Integer	4	View
PURPVIDX	Purchase Price Variance Index	Long Integer	4	View
Revalue_Vendor	Revalue Vendor	Boolean	2	View
Post_Results_To	Post Results To	Integer	2	View
FREEONBOARD	Free On Board	Integer	2	View
HIESTBAL	Highest Balance	Currency	10	View
CURRBLNC	Current Balance	Currency	10	View
NOINVYTD	Number of Invoices YTD	Long Integer	4	View
NOINVLIF	Number of Invoices LIFE	Long Integer	4	View
NOINVLYR	Number of Invoices LYR	Long Integer	4	View
NOPINYTD	Number of Paid Invoices YTD	Long Integer	4	View
NOPILIFE	Number of Paid Invoices LIFE	Long Integer	4	View
AMBLDTYD	Amount Billed YTD	Currency	10	View
AMBLDLIF	Amount Billed LIFE	Currency	10	View
AMBLDLYR	Amount Billed LYR	Currency	10	View
AMTPDYTD	Amount Paid YTD	Currency	10	View
AMTPDLYR	Amount Paid LYR	Currency	10	View
AMTPDLIF	Amount Paid LIFE	Currency	10	View
TEN99ALIF	1099 Amount LIFE	Currency	10	View
TEN99ALYR	1099 Amount LYR	Currency	10	View
TEN99AYTD	1099 Amount YTD	Currency	10	View
DISAVYTD	Discount Available YTD	Currency	10	View
DISAVLIF	Discount Available LIFE	Currency	10	View
DISAVLYR	Discount Available LYR	Currency	10	View
DISTKYTD	Discount Taken YTD	Currency	10	View
DISTKNLF	Discount Taken LIFE	Currency	10	View
DISTKLYR	Discount Taken LYR	Currency	10	View
DISLSYTD	Discount Lost YTD	Currency	10	View
DISLSTLF	Discount Lost LIFE	Currency	10	View
DISLSLYR	Discount Lost LYR	Currency	10	View
FINCHLIF	Finance Charge LIFE	Currency	10	View
FINCHLYR	Finance Charge LYR	Currency	10	View
FINCHYTD	Finance Charge YTD	Currency	10	View
WROFSLIF	Write Offs LIFE	Currency	10	View
WROFSLYR	Write Offs LYR	Currency	10	View
WROFSYTD	Write Offs YTD	Currency	10	View
RTRNSLIF	Returns LIFE	Currency	10	View
RTRNSLYR	Returns LYR	Currency	10	View
RTRNSYTD	Returns YTD	Currency	10	View
TRDTKLIF	Trade Discounts Taken LIFE	Currency	10	View
TRDTLYR	Trade Discounts Taken LYR	Currency	10	View
TRDTYTD	Trade Discounts Taken YTD	Currency	10	View
NFNCHLIF	Number of Finance Charges LIFE	Long Integer	4	View
NFNCHLYR	Number of Finance Charges LYR	Long Integer	4	View
NFNCHYTD	Number of Finance Charges YTD	Long Integer	4	View
RTNGOWED	Retainage Owed	Currency	10	View
LSTCHNUM	Last Check Number	String	22	View
LSTCHKDT	Last Check Date	Date	4	View
LSTCHAMT	Last Check Amount	Currency	10	View
LSTINNUM	Last Invoice Number	String	22	View
LSTINVAM	Last Invoice Amount	Currency	10	View
LSTPURDT	Last Purchase Date	Date	4	View
FSTPURDT	First Purchase Date	Date	4	View
CURUNPBN	Current Unapplied Payment Balance	Currency	10	View
UNPDFNCH	Unpaid Finance Charges	Currency	10	View
DYCHTCLR	Days Checks To Clear	Integer	2	View
AVGDTPYR	Average Days To Pay - Year	Integer	2	View
AVDTPLIF	Average Days To Pay - Life	Integer	2	View
ACCRDINV	Accured Inventory	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
GOVCRPID	Governmental Corporate ID	String	32	View
GOVINDID	Governmental Individual ID	String	32	View
PHONE3	Phone 3	String	22	View
TaxInvRecvd	Tax Invoice Received	Boolean	2	View
Withholding_LIFE	Withholding LIFE	Currency	10	View
WITHLYR	Withholding LYR	Currency	10	View
WITHYTD	Withholding YTD	Currency	10	View
APLYWITH	Apply Withholding	Boolean	2	View
CORRCTN	Correction	Boolean	2	View
DocPrinted	DocPrinted	Boolean	2	View
ECTRX	EC Transaction	Boolean	2	View
Electronic	Electronic	Boolean	2	View
PRCHDATE	Purchase Date	Date	4	View
SIMPLIFD	Simplified	Boolean	2	View
TaxInvReqd	Tax Invoice Required	Boolean	2	View
BNKRCAMT	Bank Receipts Amount	Currency	10	View
CORRNXST	Correction to Nonexisting Transaction	Boolean	2	View
PMWRKMS2	PM WORK Messages 2	Long Integer	4	View
VCHRNCOR	Voucher Number Corrected	String	22	View
VNDCHKNM1	ASI_Vendor_Check_Name	String	66	View
VADDCDPR1	ASI_Vendor_Address_Code_Primary	String	16	View
PYMTRMID1	ASI_Payment_Terms_ID	String	22	View
SHIPMTHD1	ASI_Shipping_Method	String	16	View
TAXSCHID1	ASI_Tax_Schedule_ID	String	16	View
CURNCYID1	ASI_Currency_ID	String	16	View
HOLD1	ASI_Hold	Boolean	2	View
PPSTAXRT1	ASI_PPS_Tax_Rate	Integer	2	View
NOTEINDX1	ASI_Note_Index	Currency	10	View
CHEKBKID1	ASI_Checkbook_ID	String	16	View
MODIFDT1	ASI_Modified_Date	Date	4	View
CREATDDT1	ASI_Created_Date	Date	4	View
RATETPID1	ASI_Rate_Type_ID	String	16	View
TaxInvRecvd1	ASI_Tax_Invoice_Received	Boolean	2	View
VADCDTRO1	ASI_Vendor_Address_Code_Remit_To	String	16	View

ASIEXP09 - SmartList Payables Transactions

Query Builder

Customer Service

Information

My Account

Contact Us