ASI_RM_Customer_MSTR_ADDR_SmartList (ASIEXP15)

azurecurve Products SmartList (1493)PathnameASI_RM_Customer_MSTR_ADDR_SmartList (ASIEXP15)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP15

Display Name: ASI_RM_Customer_MSTR_ADDR_SmartList
Physical Name: ASIEXP15
Technical Name: ASI_RM_Customer_MSTR_ADDR_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Order_By	ASI_Order_By	Long Integer	LI_14	14
2	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CUSTNMBR AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3	ADRSCODE	Address Code	String	STR15_Address_Code	15
4	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
5	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SLPRSNID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
6	UPSZONE	UPS Zone	String	STR3	3
7	CUSTCLAS	Customer Class	String	STR15_Customer_Class	15
8	CPRCSTNM	Corporate Customer Number	String	STR15_RM_Customer_Number	15
9	CNTCPRSN	Contact Person	String	STR60	60
10	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SHIPMTHD AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
11	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].TAXSCHID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
12	ADDRESS1	Address 1	String	STR60	60
13	ADDRESS2	Address 2	String	STR60	60
14	ADDRESS3	Address 3	String	STR60	60
15	COUNTRY	Country	String	STR60	60
16	CITY	City	String	STR35	35
17	STATE	State	String	STR30_State	29
18	ZIP	Zip	String	STR10	10
19	PHONE1	Phone 1	String	Phone_Number	14
20	PHONE2	Phone 2	String	Phone_Number	14
21	FAX	Fax	String	STR14_FAX	14
22	MODIFDT	Modified Date	Date	DT	8
23	CREATDDT	Created Date	Date	DT	8
24	INET1	INet1	String	STR200	200
25	INET2	INet2	String	STR200	200
26	INET3	INet3	String	STR200	200
27	INET4	INet4	String	STR200	200
28	INET5	INet5	String	STR200	200
29	INET6	INet6	String	STR200	200
30	INET7	INet7	String	STR200	200
31	INET8	INet8	String	STR200	200
32	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
33	STMTNAME	Statement Name	String	STR64	64
34	SHRTNAME	Short Name	String	STR15	15
35	PRBTADCD	Primary Billto Address Code	String	STR15_LBAU	15
36	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
37	STADDRCD	Statement Address Code	String	STR15_LBAU	15
38	ASI_Main_Salesperson	ASI_Main_Salesperson	String	STR15_Salesperson_ID	15
39	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CHEKBKID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
40	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].PYMTRMID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
41	CRLMTTYP	Credit Limit Type	Integer	GB_Amt_Type	0
42	CRLMTAMT	Credit Limit Amount	Currency	DLR17_RBS0_UTR$	17
43	CRLMTPER	Credit Limit Period	Integer	DDL	0
44	CRLMTPAM	Credit Limit Period Amount	Currency	DLR17_RBS0_UTR$	17
45	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CURNCYID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CURNCYID = ['Currency Setup'].CURNCYID
46	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].RATETPID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
47	CUSTDISC	Customer Discount	Integer	INT5_%2	5
48	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
49	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
50	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
51	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
52	FNCHATYP	Finance Charge Amt Type	Integer	GB_Amt_Type	0
53	FNCHPCNT	Finance Charge Percent	Integer	INT5_%2	5
54	FINCHDLR	Finance Charge Dollar	Currency	DLR17_RBS0_UTR$	17
55	MXWOFTYP	Maximum Writeoff Type	Integer	GP_Max_Writeoff	0
56	MXWROFAM	Max Writeoff Amount	Currency	DLR17_RBS0_UTR$	17
57	COMMENT1	Comment1	String	STR30	30
58	COMMENT2	Comment2	String	STR30	30
59	USERDEF1	User Defined 1	String	STR20	20
60	USERDEF2	User Defined 2	String	STR20	20
61	TAXEXMT1	Tax Exempt 1	String	STR25	25
62	TAXEXMT2	Tax Exempt 2	String	STR25	25
63	TXRGNNUM	Tax Registration Number	String	STR25	25
64	BALNCTYP	Balance Type	Integer	GB_Bal_Type	0
65	STMTCYCL	Statement Cycle	Integer	DDL_Stmt_Cycle	0
66	BANKNAME	Bank Name	String	STR30	30
67	BNKBRNCH	Bank Branch	String	STR20	20
68	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SALSTERR AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SALSTERR = ['Sales Territory Master File'].SALSTERR
69	DEFCACTY	Default Cash Account Type	Integer	GB	0
70	RMCSHACC	RM Cash Account Index	Long Integer	LI_14	14
71	RMARACC	RM AR Account Index	Long Integer	LI_14	14
72	RMSLSACC	RM Sales Account Index	Long Integer	LI_14	14
73	RMIVACC	RM IV Account Index	Long Integer	LI_14	14
74	RMCOSACC	RM Cost Of Sales Account Index	Long Integer	LI_14	14
75	RMTAKACC	RM Discounts Taken Account Index	Long Integer	LI_14	14
76	RMAVACC	RM Discounts Avail Account Index	Long Integer	LI_14	14
77	RMFCGACC	RM Finance Charge Account Index	Long Integer	LI_14	14
78	RMWRACC	RM Writeoff Account Index	Long Integer	LI_14	14
79	FRSTINDT	First Invoice Date	Date	DT_Date	6
80	INACTIVE	Inactive	Boolean	CB_Inactive	0
81	HOLD	Hold	Boolean	CB_Hold	0
82	CRCARDID	Credit Card ID	String	STR15	15
83	CRCRDNUM	Credit Card Number	String	STR20	20
84	CCRDXPDT	Credit Card Exp Date	Date	DT_Date	6
85	KPDSTHST	Keep Distribution History	Boolean	CB_Keep_Dist_History	0
86	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
87	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
88	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
89	Revalue_Customer	Revalue Customer	Boolean	CB Revalue Customer	0
90	Post_Results_To	Post Results To	Integer	GB	0
91	FINCHID	Finance Charge ID	String	STR15_Charge_ID	15
92	GOVCRPID	Governmental Corporate ID	String	STR30_Gov_Corp_ID	30
93	GOVINDID	Governmental Individual ID	String	STR30_Gov_Indiv_ID	30
94	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].NOTEINDX AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX
95	PHONE3	Phone 3	String	Phone_Number3	14
96	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
97	DOCFMTID	Document Format ID	String	STR15_LBU	15
98	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
99	ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	DDL_OrderFulfillDefault	0
100	SALSTERR1	ASI_Sales_Territory	String	STR15_Sales_Territory	15
101	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['ASI_RM_Customer_MSTR_ADDR_SmartList'].LOCNCODE AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList'] INNER JOIN IV40700 AS ['Site Setup'] ON ['ASI_RM_Customer_MSTR_ADDR_SmartList'].LOCNCODE = ['Site Setup'].LOCNCODE
102	USERDEF11	ASI_User_Defined_1	String	STR20	20
103	USERDEF21	ASI_User_Defined_2	String	STR20	20
104	CUSTPRIORITY	Customer Priority	Integer	DDL_CustomerPriority	0

azurecurve Products SmartList (1493)PathnameASI_RM_Customer_MSTR_ADDR_SmartList (ASIEXP15)

Leave a Reply Cancel reply