SV_User_Defined_MSTR (SV00900)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_User_Defined_MSTR
Physical Name: SV00900
Technical Name: SV_User_Defined_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	16	15
2	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	16	15
3	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	16	15
4	Record	Record	INT	Integer	2	0
5	User_Define_1	User Define 1	STR30	String	32	30
6	User_Define_2	User Define 2	STR30	String	32	30
7	User_Define_3	User Define 3	STR30	String	32	30
8	User_Define_4	User Define 4	STR30	String	32	30
9	User_Define_5	User Define 5	STR30	String	32	30
10	User_Define_6	User Define 6	STR30	String	32	30
11	User_Define_7	User Define 7	STR30	String	32	30
12	User_Define_8	User Define 8	STR30	String	32	30
13	User_Define_9	User Define 9	STR30	String	32	30
14	User_Define_10	User Define 10	STR30	String	32	30
15	User_Define_11	User Define 11	STR30	String	32	30
16	User_Define_12	User Define 12	STR30	String	32	30
17	User_Define_13	User Define 13	STR30	String	32	30
18	User_Define_14	User Define 14	STR30	String	32	30
19	User_Define_15	User Define 15	STR30	String	32	30
20	User_Define_16	User Define 16	STR30	String	32	30
21	User_Define_17	User Define 17	STR30	String	32	30
22	User_Define_18	User Define 18	STR30	String	32	30
23	User_Define_19	User Define 19	STR30	String	32	30
24	User_Define_20	User Define 20	STR30	String	32	30
25	User_Define_21	User Define 21	STR30	String	32	30
26	User_Define_22	User Define 22	STR30	String	32	30
27	User_Define_23	User Define 23	STR30	String	32	30
28	User_Define_24	User Define 24	STR30	String	32	30
29	User_Define_25	User Define 25	STR30	String	32	30
30	User_Define_26	User Define 26	STR30	String	32	30
31	User_Define_27	User Define 27	STR30	String	32	30
32	User_Define_28	User Define 28	STR30	String	32	30
33	User_Define_29	User Define 29	STR30	String	32	30
34	User_Define_30	User Define 30	STR30	String	32	30
35	User_Define_31	User Define 31	STR30	String	32	30
36	User_Define_32	User Define 32	STR30	String	32	30
37	User_Define_33	User Define 33	STR30	String	32	30
38	User_Define_34	User Define 34	STR30	String	32	30
39	User_Define_35	User Define 35	STR30	String	32	30
40	User_Define_36	User Define 36	STR30	String	32	30
41	User_Define_37	User Define 37	STR30	String	32	30
42	User_Define_38	User Define 38	STR30	String	32	30
43	User_Define_39	User Define 39	STR30	String	32	30
44	User_Define_40	User Define 40	STR30	String	32	30
45	User_Define_41	User Define 41	STR30	String	32	30
46	User_Define_42	User Define 42	STR30	String	32	30
47	User_Define_43	User Define 43	STR30	String	32	30
48	User_Define_44	User Define 44	STR30	String	32	30
49	User_Define_45	User Define 45	STR30	String	32	30
50	MODIFDT	Modified Date	DT	Date	4	8
51	Modified_Time	Modified Time	TM6	Time	4	6
52	MDFUSRID	Modified User ID	STR15	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_User_Defined_MSTR'].MDFUSRID AS 'SV_User_Defined_MSTR-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00900 AS ['SV_User_Defined_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_User_Defined_MSTR'].MDFUSRID = ['Users Master'].USERID
53	Time_Zone	Time Zone	STR3	String	4	3
54	SV_Language_ID	SV Language ID	INT2	Integer	2	2
55	WSReserved_CB1	WSReserved CB1	CB	Boolean	2	0
56	WSReserved_CB2	WSReserved CB2	CB	Boolean	2	0
57	WSReserved_CB3	WSReserved CB3	CB	Boolean	2	0
58	WSReserved_CB4	WSReserved CB4	CB	Boolean	2	0
59	WSReserved_CB5	WSReserved CB5	CB	Boolean	2	0
60	WSReserved_STR1	WSReserved STR1	STR10	String	12	10
61	WSReserved_STR2	WSReserved STR2	STR10	String	12	10

azurecurve Products WennSoft Products (131)3rd PartySV_User_Defined_MSTR (SV00900)

Click to show/hide

Leave a Reply Cancel reply