SV_Maint_Invoice_MSTR (SV00564)

azurecurve Products WennSoft Products (131)3rd PartySV_Maint_Invoice_MSTR (SV00564)

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

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

Display Name: SV_Maint_Invoice_MSTR
Physical Name: SV00564
Technical Name: SV_Maint_Invoice_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_Maint_Invoice_MSTR'].CUSTNMBR AS 'SV_Maint_Invoice_MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV00564 AS ['SV_Maint_Invoice_MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Maint_Invoice_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	DATE1	Date	DT6	Date	6
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_Maint_Invoice_MSTR'].USERID AS 'SV_Maint_Invoice_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00564 AS ['SV_Maint_Invoice_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Maint_Invoice_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	Corporate_Invoice_Number	Corporate Invoice Number	STR17_LBAU	String	17
13	Corporate_Contract_Nbr	Corporate Contract Number	STR20_LBAU	String	20
14	WSMSTRCONTSQ	WS Master Contract Seq Number	LI_Sequence_Number	Long Integer	10
15	Position_on_Invoice	Position on Invoice	INT3	Integer	3
16	Wennsoft_Billing_Date	Wennsoft Billing Date	DT	Date	8
17	Wennsoft_Period_ID	Wennsoft Period ID	INT3	Integer	3
18	Billable_Tax	Billable Tax	DLR14_RBS0_STR$	Currency	14
19	Billable_Subtotal	Billable Subtotal	DLR14_RBS0_STR$	Currency	14
20	Tax_Detail_ID_1	Tax Detail ID 1	STR15_Tax_Detail_ID	String	15
21	Tax_Amount1	Tax Amount1	DLR14_RBS0_STR$	Currency	14
22	Tax_Detail_ID_2	Tax Detail ID 2	STR15_Tax_Detail_ID	String	15
23	Tax_Amount2	Tax Amount2	DLR14_RBS0_STR$	Currency	14
24	Tax_Detail_ID_3	Tax Detail ID 3	STR15_Tax_Detail_ID	String	15
25	Tax_Amount3	Tax Amount3	DLR14_RBS0_STR$	Currency	14
26	Tax_Detail_ID_4	Tax Detail ID 4	STR15_Tax_Detail_ID	String	15
27	Tax_Amount4	Tax Amount4	DLR11_$S2	Currency	14
28	Billable_All	Billable All	DLR14_RBS0_STR$	Currency	14
29	PORDNMBR	Purchase Order Number	Purchase Order Number	String	20
30	Invoice_Comment_ID_1	Invoice Comment ID 1	INT5	Integer	4
31	Invoice_Comment_ID_2	Invoice Comment ID 2	INT5	Integer	4
32	Contract_Billing_Desc	Contract Billing Description	STR40	String	40
33	Billing_Date	Billing Date	DATE	Date	6
34	RMDNUMWK	RM Document Number-WORK	STR17_LBAU	String	17
35	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
36	PB_ACTINDX	Progress Billing Account Index	LI_14	Long Integer	14
37	SLPRSNID	Salesperson ID	STR15_Salesperson_ID	String	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SV_Maint_Invoice_MSTR'].SLPRSNID AS 'SV_Maint_Invoice_MSTR-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM SV00564 AS ['SV_Maint_Invoice_MSTR'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SV_Maint_Invoice_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
38	COMPRCNT	Commission Percent	INT5_%2	Integer	5
39	Commission_Pct_of_Sale	Commission Percent of Sale	INT5_%2	Integer	5
40	COMMERNG	Commission Earnings	DLR11_$S2	Currency	14
41	SALSTERR	Sales Territory	STR15_Sales_Territory	String	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['SV_Maint_Invoice_MSTR'].SALSTERR AS 'SV_Maint_Invoice_MSTR-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM SV00564 AS ['SV_Maint_Invoice_MSTR'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['SV_Maint_Invoice_MSTR'].SALSTERR = ['Sales Territory Master File'].SALSTERR
42	Salesperson_ID_2	Salesperson ID 2	STR15_Salesperson_ID	String	15
43	Commission_Percent_2	Commission Percent 2	INT5_%2	Integer	5
44	Commission_Pct_of_Sale_2	Commission Percent of Sale 2	INT5_%2	Integer	5
45	Commission_Earnings_2	Commission Earnings 2	DLR11_$S2	Currency	14
46	Sales_Territory_2	Sales Territory 2	STR15_Sales_Territory	String	15
47	Invoice_Style	Invoice Style	INT2	Integer	2
48	No_Times_Printed	No. Times Printed	INT2	Integer	2
49	Printed_Date	Printed Date	DATE	Date	6
50	Wennsoft_Posting_Status	Wennsoft Posting Status	STR1	String	1
51	MODIFDT	Modified Date	DT	Date	8
52	Modified_Time	Modified Time	TM6	Time	6
53	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Maint_Invoice_MSTR'].MDFUSRID AS 'SV_Maint_Invoice_MSTR-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00564 AS ['SV_Maint_Invoice_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Maint_Invoice_MSTR'].MDFUSRID = ['Users Master'].USERID
54	Time_Zone	Time Zone	STR3	String	3
55	SV_Language_ID	SV Language ID	INT2	Integer	2
56	Base_Currency_ID	Base Currency ID	STR15_Currency_ID	String	15
57	Base_Curr_Conv_Factor	Base Curr Conversion Factor	DLR14_Exchange_Rate	Currency (Variable)	14
58	Billing_Currency_ID	Billing Currency ID	STR15_Currency_ID	String	15
59	Billing_Curr_Conv_Factor	Billing Curr Conversion Factor	DLR14_Exchange_Rate	Currency (Variable)	14
60	Local_Currency_ID	Local Currency ID	STR15_Currency_ID	String	15
61	Base_Currency_Amount	Base Currency Amount	DLR14_RBS0_STR$	Currency	14
62	Billing_Currency_Amount	Billing Currency Amount	DLR14_RBS0_STR$	Currency	14
63	Billable_Escalation	Billable Escalation	DLR14_RBS0_STR$	Currency	14
64	Billable_Total	Billable Total	DLR14_RBS0_STR$	Currency	14
65	Escalation_Idx_ID_Equip	Escalation Index ID Equip	STR3_LBAU	String	3
66	Escal_Idx_ID_Material	Escalation Index ID Material	STR3_LBAU	String	3
67	Escalation_Idx_ID_Labor	Escalation Index ID Labor	STR3_LBAU	String	3
68	Escalation_Index_ID_Subs	Escalation Index ID Subs	STR3_LBAU	String	3
69	Escalation_Idx_ID_Other	Escalation Index ID Other	STR3_LBAU	String	3
70	Escalation_Pct_Equip	Escalation Percentage Equip	DLR5_%2	Currency	8
71	Escalation_Pct_Material	Escalation Percentage Material	DLR5_%2	Currency	8
72	Escalation_Pct_Labor	Escalation Percentage Labor	DLR5_%2	Currency	8
73	Escalation_Pct_Subs	Escalation Percentage Subs	DLR5_%2	Currency	8
74	Escalation_Pct_Other	Escalation Percentage Other	DLR5_%2	Currency	8
75	Escal_Fixed_Amt_Equip	Escalation Fixed Amount Equip	DLR14_RBS0_STR$	Currency	14
76	Escalation_Fixed_Amt_Mat	Escalation Fixed Amount Mat	DLR14_RBS0_STR$	Currency	14
77	Escal_Fixed_Amt_Labor	Escalation Fixed Amount Labor	DLR14_RBS0_STR$	Currency	14
78	Escal_Fixed_Amt_Subs	Escalation Fixed Amount Subs	DLR14_RBS0_STR$	Currency	14
79	Escal_Fixed_Amt_Other	Escalation Fixed Amount Other	DLR14_RBS0_STR$	Currency	14
80	Contract_Escalation_Desc	Contract Escalation Descript	STR40	String	40
81	Bill_Customer_Number	Bill Customer Number	STR15_RM_Customer_Number	String	15
82	Bill_Address_Code	Bill Address Code	STR15_Address_Code	String	15
83	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
84	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
85	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
86	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
87	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
88	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
89	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
90	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
91	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
92	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
93	WSReserved_STR1	WSReserved STR1	STR10	String	10
94	WSReserved_STR2	WSReserved STR2	STR10	String	10
95	WS_GL_Posting_Date	WS GL Posting Date	DT	Date	8

azurecurve Products WennSoft Products (131)3rd PartySV_Maint_Invoice_MSTR (SV00564)

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