ASIEXP03 - SmartList PM Vendor Master File | Prospr

ASIEXP03 - SmartList PM Vendor Master File

Query Builder

Select * from ASIEXP03

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
VENDORID	Vendor ID	String	16	View
VENDNAME	Vendor Name	String	66	View
VNDCHKNM	Vendor Check Name	String	66	View
VENDSHNM	Vendor Short Name	String	16	View
VADDCDPR	Vendor Address Code - Primary	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
SHIPMTHD	Shipping Method	String	16	View
TAXSCHID	Tax Schedule ID	String	16	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
CURNCYID	Currency ID	String	16	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
PYMTRMID	Payment Terms ID	String	22	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
HOLD	Hold	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
PPSTAXRT	PPS Tax Rate	Integer	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
NOTEINDX	Note Index	Currency	10	View
CHEKBKID	Checkbook ID	String	16	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
RATETPID	Rate Type ID	String	16	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	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
AMTPDLIF	Amount Paid LIFE	Currency	10	View
AMTPDLYR	Amount Paid LYR	Currency	10	View
TEN99AYTD	1099 Amount YTD	Currency	10	View
TEN99ALIF	1099 Amount LIFE	Currency	10	View
TEN99ALYR	1099 Amount LYR	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
WROFSYTD	Write Offs YTD	Currency	10	View
WROFSLIF	Write Offs LIFE	Currency	10	View
WROFSLYR	Write Offs LYR	Currency	10	View
RTRNSYTD	Returns YTD	Currency	10	View
RTRNSLIF	Returns LIFE	Currency	10	View
RTRNSLYR	Returns LYR	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
ONORDAMT	On Order Amount	Currency	10	View
Revalue_Vendor	Revalue Vendor	Boolean	2	View
Post_Results_To	Post Results To	Integer	2	View
FREEONBOARD	Free On Board	Integer	2	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
CPRCSTNM	Corporate Customer Number	String	16	View

ASIEXP03 - SmartList PM Vendor Master File

Query Builder

Customer Service

Information

My Account

Contact Us