ASI_SOP_Prospect_MSTR_SmartList (ASIEXP17)

azurecurve Products SmartList (1493)PathnameASI_SOP_Prospect_MSTR_SmartList (ASIEXP17)

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

Display Name: ASI_SOP_Prospect_MSTR_SmartList
Physical Name: ASIEXP17
Technical Name: ASI_SOP_Prospect_MSTR_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	PROSPID	Prospect ID	String	STR15_RM_Customer_Number	15
3	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['ASI_SOP_Prospect_MSTR_SmartList'].NOTEINDX AS 'ASI_SOP_Prospect_MSTR_SmartList-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP17 AS ['ASI_SOP_Prospect_MSTR_SmartList'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['ASI_SOP_Prospect_MSTR_SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
5	CNTCPRSN	Contact Person	String	STR60	60
6	ADDRESS1	Address 1	String	STR60	60
7	ADDRESS2	Address 2	String	STR60	60
8	ADDRESS3	Address 3	String	STR60	60
9	CITY	City	String	STR35	35
10	STATE	State	String	STR30_State	29
11	ZIP	Zip	String	STR10	10
12	COUNTRY	Country	String	STR60	60
13	CUSTCLAS	Customer Class	String	STR15_Customer_Class	15
14	PHONE1	Phone 1	String	Phone_Number	14
15	PHONE2	Phone 2	String	Phone_Number	14
16	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
17	FAX	Fax	String	STR14_FAX	14
18	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['ASI_SOP_Prospect_MSTR_SmartList'].SHIPMTHD AS 'ASI_SOP_Prospect_MSTR_SmartList-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP17 AS ['ASI_SOP_Prospect_MSTR_SmartList'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['ASI_SOP_Prospect_MSTR_SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
19	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_SOP_Prospect_MSTR_SmartList'].TAXSCHID AS 'ASI_SOP_Prospect_MSTR_SmartList-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP17 AS ['ASI_SOP_Prospect_MSTR_SmartList'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['ASI_SOP_Prospect_MSTR_SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
20	USERDEF1	User Defined 1	String	STR20	20
21	USERDEF2	User Defined 2	String	STR20	20
22	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ASI_SOP_Prospect_MSTR_SmartList'].USER2ENT AS 'ASI_SOP_Prospect_MSTR_SmartList-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP17 AS ['ASI_SOP_Prospect_MSTR_SmartList'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ASI_SOP_Prospect_MSTR_SmartList'].USER2ENT = ['Users Master'].USERID
23	CREATDDT	Created Date	Date	DT	8
24	MODIFDT	Modified Date	Date	DT	8
25	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
26	PHONE3	Phone 3	String	Phone_Number3	14

azurecurve Products SmartList (1493)PathnameASI_SOP_Prospect_MSTR_SmartList (ASIEXP17)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply