ASIEXP15 - ASI_RM_Customer_MSTR_ADDR_SmartList | Prospr

ASIEXP15 - ASI_RM_Customer_MSTR_ADDR_SmartList

Query Builder

Select * from ASIEXP15

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
ADRSCODE	Address Code	String	16	View
CUSTNAME	Customer Name	String	66	View
SLPRSNID	Salesperson ID	String	16	View
UPSZONE	UPS Zone	String	4	View
CUSTCLAS	Customer Class	String	16	View
CPRCSTNM	Corporate Customer Number	String	16	View
CNTCPRSN	Contact Person	String	62	View
SHIPMTHD	Shipping Method	String	16	View
TAXSCHID	Tax Schedule ID	String	16	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
FAX	Fax	String	22	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
INET1	INet1	String	202	View
INET2	INet2	String	202	View
INET3	INet3	String	202	View
INET4	INet4	String	202	View
INET5	INet5	String	202	View
INET6	INet6	String	202	View
INET7	INet7	String	202	View
INET8	INet8	String	202	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
STMTNAME	Statement Name	String	66	View
SHRTNAME	Short Name	String	16	View
PRBTADCD	Primary Billto Address Code	String	16	View
PRSTADCD	Primary Shipto Address Code	String	16	View
STADDRCD	Statement Address Code	String	16	View
ASI_Main_Salesperson	ASI_Main_Salesperson	String	16	View
CHEKBKID	Checkbook ID	String	16	View
PYMTRMID	Payment Terms ID	String	22	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
CURNCYID	Currency ID	String	16	View
RATETPID	Rate Type ID	String	16	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
FNCHATYP	Finance Charge Amt Type	Integer	2	View
FNCHPCNT	Finance Charge Percent	Integer	2	View
FINCHDLR	Finance Charge Dollar	Currency	10	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
SALSTERR	Sales Territory	String	16	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
NOTEINDX	Note Index	Currency	10	View
PHONE3	Phone 3	String	22	View
DISGRPER	Discount Grace Period	Integer	2	View
DOCFMTID	Document Format ID	String	16	View
DUEGRPER	Due Date Grace Period	Integer	2	View
ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	2	View
SALSTERR1	ASI_Sales_Territory	String	16	View
LOCNCODE	Location Code	String	12	View
USERDEF11	ASI_User_Defined_1	String	22	View
USERDEF21	ASI_User_Defined_2	String	22	View
CUSTPRIORITY	Customer Priority	Integer	2	View

ASIEXP15 - ASI_RM_Customer_MSTR_ADDR_SmartList

Query Builder

Customer Service

Information

My Account

Contact Us