SV_Contract_Billing_MSTR (sv00510)

azurecurve Products WennSoft Products (131)3rd PartySV_Contract_Billing_MSTR (sv00510)

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

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

Display Name: SV_Contract_Billing_MSTR
Physical Name: sv00510
Technical Name: SV_Contract_Billing_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Contract_Billing_MSTR'].CUSTNMBR AS 'SV_Contract_Billing_MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM sv00510 AS ['SV_Contract_Billing_MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Contract_Billing_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	STR15_Address_Code	String	15
3	Contract_Number	WS Contract Number	STR10	String	10
4	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
5	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	10
6	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
7	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
8	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
9	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Contract_Billing_MSTR'].USERID AS 'SV_Contract_Billing_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM sv00510 AS ['SV_Contract_Billing_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Contract_Billing_MSTR'].USERID = ['Users Master'].USERID
10	Technician_ID	Technician ID	STR15_Employee_ID	String	15
11	Technician_Team	Technician Team	STR15_LBAU	String	15
12	Wennsoft_Close_Date	Wennsoft Close Date	DT	Date	8
13	YEAR1	Year	Year	Integer	4
14	PERIODID	Period ID	INT3	Integer	3
15	Contract_Billing_Desc	Contract Billing Description	STR40	String	40
16	Billing_Date	Billing Date	DATE	Date	6
17	Corporate_Invoice_Number	Corporate Invoice Number	STR17_LBAU	String	17
18	Corporate_Contract_Nbr	Corporate Contract Number	STR20_LBAU	String	20
19	WSMSTRCONTSQ	WS Master Contract Seq Number	LI_Sequence_Number	Long Integer	10
20	RMDTYPAL	RM Document Type-All	INT2	Integer	2
	Document Type records the type of document. Click to show/hide the Document Types 0 Balance Carried Forward 1 Sales / Invoice 2 Scheduled Payments 3 Debit Memo 4 Finance Charge 5 Service Repairs 6 Warranties 7 Credit Memo 8 Returns 9 Payments
21	Tax_Detail_ID_1	Tax Detail ID 1	STR15_Tax_Detail_ID	String	15
22	Tax_Amount1	Tax Amount1	DLR14_RBS0_STR$	Currency	14
23	Tax_Detail_ID_2	Tax Detail ID 2	STR15_Tax_Detail_ID	String	15
24	Tax_Amount2	Tax Amount2	DLR14_RBS0_STR$	Currency	14
25	Tax_Detail_ID_3	Tax Detail ID 3	STR15_Tax_Detail_ID	String	15
26	Tax_Amount3	Tax Amount3	DLR14_RBS0_STR$	Currency	14
27	Tax_Detail_ID_4	Tax Detail ID 4	STR15_Tax_Detail_ID	String	15
28	Tax_Amount_4	Tax Amount 4	DLR14_RBS0_STR$	Currency	14
29	DOCAMNT	Document Amount	DLR19_RBSO_UTR$	Currency	19
30	Escalation_Idx_ID_Equip	Escalation Index ID Equip	STR3_LBAU	String	3
31	Escal_Idx_ID_Material	Escalation Index ID Material	STR3_LBAU	String	3
32	Escalation_Idx_ID_Labor	Escalation Index ID Labor	STR3_LBAU	String	3
33	Escalation_Index_ID_Subs	Escalation Index ID Subs	STR3_LBAU	String	3
34	Escalation_Idx_ID_Other	Escalation Index ID Other	STR3_LBAU	String	3
35	Escalation_Pct_Equip	Escalation Percentage Equip	DLR5_%2	Currency	8
36	Escalation_Pct_Material	Escalation Percentage Material	DLR5_%2	Currency	8
37	Escalation_Pct_Labor	Escalation Percentage Labor	DLR5_%2	Currency	8
38	Escalation_Pct_Subs	Escalation Percentage Subs	DLR5_%2	Currency	8
39	Escalation_Pct_Other	Escalation Percentage Other	DLR5_%2	Currency	8
40	Escal_Fixed_Amt_Equip	Escalation Fixed Amount Equip	DLR14_RBS0_STR$	Currency	14
41	Escalation_Fixed_Amt_Mat	Escalation Fixed Amount Mat	DLR14_RBS0_STR$	Currency	14
42	Escal_Fixed_Amt_Labor	Escalation Fixed Amount Labor	DLR14_RBS0_STR$	Currency	14
43	Escal_Fixed_Amt_Subs	Escalation Fixed Amount Subs	DLR14_RBS0_STR$	Currency	14
44	Escal_Fixed_Amt_Other	Escalation Fixed Amount Other	DLR14_RBS0_STR$	Currency	14
45	Billable_Escalation	Billable Escalation	DLR14_RBS0_STR$	Currency	14
46	Billable_Total	Billable Total	DLR14_RBS0_STR$	Currency	14
47	Contract_Escalation_Desc	Contract Escalation Descript	STR40	String	40
48	DATE1	Date	DT6	Date	6
49	POSTDATE	Post Date	DT_Date	Date	6
50	Period2	Period2	INT3	Integer	3
51	WS_Closed	WS Closed	True/False	Boolean	0
52	Invoice_Comment_ID_1	Invoice Comment ID 1	INT5	Integer	4
53	Invoice_Comment_ID_2	Invoice Comment ID 2	INT5	Integer	4
54	SLPRSNID	Salesperson ID	STR15_Salesperson_ID	String	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SV_Contract_Billing_MSTR'].SLPRSNID AS 'SV_Contract_Billing_MSTR-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM sv00510 AS ['SV_Contract_Billing_MSTR'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SV_Contract_Billing_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
55	COMPRCNT	Commission Percent	INT5_%2	Integer	5
56	Commission_Pct_of_Sale	Commission Percent of Sale	INT5_%2	Integer	5
57	COMMERNG	Commission Earnings	DLR11_$S2	Currency	14
58	SALSTERR	Sales Territory	STR15_Sales_Territory	String	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['SV_Contract_Billing_MSTR'].SALSTERR AS 'SV_Contract_Billing_MSTR-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM sv00510 AS ['SV_Contract_Billing_MSTR'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['SV_Contract_Billing_MSTR'].SALSTERR = ['Sales Territory Master File'].SALSTERR
59	Salesperson_ID_2	Salesperson ID 2	STR15_Salesperson_ID	String	15
60	Commission_Percent_2	Commission Percent 2	INT5_%2	Integer	5
61	Commission_Pct_of_Sale_2	Commission Percent of Sale 2	INT5_%2	Integer	5
62	Commission_Earnings_2	Commission Earnings 2	DLR11_$S2	Currency	14
63	Sales_Territory_2	Sales Territory 2	STR15_Sales_Territory	String	15
64	Invoice_Style	Invoice Style	INT2	Integer	2
65	Service_User_Define_1	Service User Define 1	STR20	String	20
66	Service_User_Define_2	Service User Define 2	STR20	String	20
67	Service_User_Define_3	Service User Define 3	STR30	String	30
68	Service_User_Define_4	Service User Define 4	STR30	String	30
69	Service_User_Define_5	Service User Define 5	LI6_S2	Long Integer	6
70	Service_User_Define_6	Service User Define 6	LI6_S2	Long Integer	6
71	Service_User_Define_7	Service User Define 7	LI6_S2	Long Integer	6
72	Service_User_Define_8	Service User Define 8	LI6_S2	Long Integer	6
73	Service_User_Define_9	Service User Define 9	DT	Date	8
74	Service_User_Define_10	Service User Define 10	DT	Date	8
75	Service_User_Define_11	Service User Define 11	DT	Date	8
76	Service_User_Define_12	Service User Define 12	DT	Date	8
77	Service_User_Define_18	Service User Define 18	CB	Boolean	0
78	Service_User_Define_19	Service User Define 19	CB	Boolean	0
79	Service_User_Define_20	Service User Define 20	CB	Boolean	0
80	Service_User_Define_21	Service User Define 21	CB	Boolean	0
81	Service_User_Define_22	Service User Define 22	DLR14_RBS0_STR$	Currency	14
82	Service_User_Define_23	Service User Define 23	DLR14_RBS0_STR$	Currency	14
83	Service_User_Define_24	Service User Define 24	DLR14_RBS0_STR$	Currency	14
84	Service_User_Define_25	Service User Define 25	DLR14_RBS0_STR$	Currency	14
85	MODIFDT	Modified Date	DT	Date	8
86	Modified_Time	Modified Time	TM6	Time	6
87	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Contract_Billing_MSTR'].MDFUSRID AS 'SV_Contract_Billing_MSTR-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM sv00510 AS ['SV_Contract_Billing_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Contract_Billing_MSTR'].MDFUSRID = ['Users Master'].USERID
88	Time_Zone	Time Zone	STR3	String	3
89	Base_Currency_ID	Base Currency ID	STR15_Currency_ID	String	15
90	Base_Curr_Conv_Factor	Base Curr Conversion Factor	DLR14_Exchange_Rate	Currency (Variable)	14
91	Billing_Currency_ID	Billing Currency ID	STR15_Currency_ID	String	15
92	Billing_Curr_Conv_Factor	Billing Curr Conversion Factor	DLR14_Exchange_Rate	Currency (Variable)	14
93	Local_Currency_ID	Local Currency ID	STR15_Currency_ID	String	15
94	Bill_Customer_Number	Bill Customer Number	STR15_RM_Customer_Number	String	15
95	Bill_Address_Code	Bill Address Code	STR15_Address_Code	String	15
96	RMDNUMWK	RM Document Number-WORK	STR17_LBAU	String	17
97	ACTINDX_CR	Account Index Credit	LI_14	Long Integer	14
98	ACTINDX_DR	Account Index Debit	LI_14	Long Integer	14
99	GLPOSTDT	GL Posting Date	DT	Date	8
100	JRNENTRY	Journal Entry	LI8_U0	Long Integer	8
101	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
102	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
103	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
104	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
105	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
106	WSReserved_STR1	WSReserved STR1	STR10	String	10
107	WSReserved_STR2	WSReserved STR2	STR10	String	10

azurecurve Products WennSoft Products (131)3rd PartySV_Contract_Billing_MSTR (sv00510)

Click to show/hide

Click to show/hide

Click to show/hide the Document Types

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply