SV_Invoice_MSTR (SV00700)

azurecurve Products WennSoft Products (131)3rd PartySV_Invoice_MSTR (SV00700)

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

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

Display Name: SV_Invoice_MSTR
Physical Name: SV00700
Technical Name: SV_Invoice_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
2	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Invoice_MSTR'].CUSTNMBR AS 'SV_Invoice_MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV00700 AS ['SV_Invoice_MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Invoice_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3	Call_Invoice_Number	Call Invoice Number	STR17_LBAU	String	17
4	ADRSCODE	Address Code	STR15_Address_Code	String	15
5	Invoice_Type	Invoice Type	DDL_Invoice_Type	Integer	0
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_Invoice_MSTR'].USERID AS 'SV_Invoice_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00700 AS ['SV_Invoice_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_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	Technician_ID2	Technician ID2	STR15_Employee_ID	String	15
13	Corporate_Invoice_Number	Corporate Invoice Number	STR17_LBAU	String	17
14	CPRCSTNM	Corporate Customer Number	STR15_RM_Customer_Number	String	15
15	BACHNUMB	Batch Number	STR15_LBAU	String	15
16	BCHSOURC	Batch Source	STR15	String	15
17	Labor_Cost_Catagory_1	Labor Cost Catagory 1	DLR14_RBS0_STR$	Currency	14
18	Labor_Cost_Catagory_2	Labor Cost Catagory 2	DLR14_RBS0_STR$	Currency	14
19	Labor_Cost_Catagory_3	Labor Cost Catagory 3	DLR14_RBS0_STR$	Currency	14
20	Labor_Cost_Catagory_4	Labor Cost Catagory 4	DLR14_RBS0_STR$	Currency	14
21	Labor_Cost_Catagory_5	Labor Cost Catagory 5	DLR14_RBS0_STR$	Currency	14
22	Cost_Equipment	Cost Equipment	DLR14_RBS0_STR$	Currency	14
23	Cost_Material	Cost Material	DLR14_RBS0_STR$	Currency	14
24	Cost_Labor	Cost Labor	DLR14_RBS0_STR$	Currency	14
25	Cost_Subs	Cost Subs	DLR14_RBS0_STR$	Currency	14
26	Cost_Other	Cost Other	DLR14_RBS0_STR$	Currency	14
27	Cost_Tax	Cost Tax	DLR14_RBS0_STR$	Currency	14
28	Cost_All	Cost All	DLR14_RBS0_STR$	Currency	14
29	Labor_Billing_Catagory_1	Labor Billing Catagory 1	DLR14_RBS0_STR$	Currency	14
30	Labor_Billing_Catagory_2	Labor Billing Catagory 2	DLR14_RBS0_STR$	Currency	14
31	Labor_Billing_Catagory_3	Labor Billing Catagory 3	DLR14_RBS0_STR$	Currency	14
32	Labor_Billing_Catagory_4	Labor Billing Catagory 4	DLR14_RBS0_STR$	Currency	14
33	Labor_Billing_Catagory_5	Labor Billing Catagory 5	DLR14_RBS0_STR$	Currency	14
34	Billable_Equipment	Billable Equipment	DLR14_RBS0_STR$	Currency	14
35	Billable_Material	Billable Material	DLR14_RBS0_STR$	Currency	14
36	Billable_Labor	Billable Labor	DLR14_RBS0_STR$	Currency	14
37	Billable_Subs	Billable Subs	DLR14_RBS0_STR$	Currency	14
38	Billable_Other	Billable Other	DLR14_RBS0_STR$	Currency	14
39	Tax_Detail_ID_1	Tax Detail ID 1	STR15_Tax_Detail_ID	String	15
40	Tax_Amount1	Tax Amount1	DLR14_RBS0_STR$	Currency	14
41	Tax_Detail_ID_2	Tax Detail ID 2	STR15_Tax_Detail_ID	String	15
42	Tax_Amount2	Tax Amount2	DLR14_RBS0_STR$	Currency	14
43	Tax_Detail_ID_3	Tax Detail ID 3	STR15_Tax_Detail_ID	String	15
44	Tax_Amount3	Tax Amount3	DLR14_RBS0_STR$	Currency	14
45	Tax_Detail_ID_4	Tax Detail ID 4	STR15_Tax_Detail_ID	String	15
46	Tax_Amount_4	Tax Amount 4	DLR14_RBS0_STR$	Currency	14
47	Billable_Tax	Billable Tax	DLR14_RBS0_STR$	Currency	14
48	Billable_All	Billable All	DLR14_RBS0_STR$	Currency	14
49	Billing_Amount_Fixed	Billing Amount Fixed	DLR11_$S2	Currency	14
50	Billing_Amount_NTE	Billing Amount NTE	DLR14_RBS0_STR$	Currency	14
51	TOTLAMNT_1	Total Amount[1]	DLR19_$S2	Currency	19
52	TOTLAMNT_2	Total Amount[2]	DLR19_$S2	Currency	19
53	TOTLAMNT_3	Total Amount[3]	DLR19_$S2	Currency	19
54	TOTLAMNT_4	Total Amount[4]	DLR19_$S2	Currency	19
55	TOTLAMNT_5	Total Amount[5]	DLR19_$S2	Currency	19
56	TOTLAMNT_6	Total Amount[6]	DLR19_$S2	Currency	19
57	TOTLAMNT_7	Total Amount[7]	DLR19_$S2	Currency	19
58	TOTLAMNT_8	Total Amount[8]	DLR19_$S2	Currency	19
59	TOTLAMNT_9	Total Amount[9]	DLR19_$S2	Currency	19
60	TOTLAMNT_10	Total Amount[10]	DLR19_$S2	Currency	19
61	TOTLAMNT_11	Total Amount[11]	DLR19_$S2	Currency	19
62	TOTLAMNT_12	Total Amount[12]	DLR19_$S2	Currency	19
63	TOTLAMNT_13	Total Amount[13]	DLR19_$S2	Currency	19
64	TOTLAMNT_14	Total Amount[14]	DLR19_$S2	Currency	19
65	TOTLAMNT_15	Total Amount[15]	DLR19_$S2	Currency	19
66	TOTLAMNT_16	Total Amount[16]	DLR19_$S2	Currency	19
67	TOTLAMNT_17	Total Amount[17]	DLR19_$S2	Currency	19
68	TOTLAMNT_18	Total Amount[18]	DLR19_$S2	Currency	19
69	TOTLAMNT_19	Total Amount[19]	DLR19_$S2	Currency	19
70	TOTLAMNT_20	Total Amount[20]	DLR19_$S2	Currency	19
71	TOTLAMNT_21	Total Amount[21]	DLR19_$S2	Currency	19
72	TOTLAMNT_22	Total Amount[22]	DLR19_$S2	Currency	19
73	TOTLAMNT_23	Total Amount[23]	DLR19_$S2	Currency	19
74	TOTLAMNT_24	Total Amount[24]	DLR19_$S2	Currency	19
75	TOTLAMNT_25	Total Amount[25]	DLR19_$S2	Currency	19
76	TOTLAMNT_26	Total Amount[26]	DLR19_$S2	Currency	19
77	TOTLAMNT_27	Total Amount[27]	DLR19_$S2	Currency	19
78	TOTLAMNT_28	Total Amount[28]	DLR19_$S2	Currency	19
79	TOTLAMNT_29	Total Amount[29]	DLR19_$S2	Currency	19
80	TOTLAMNT_30	Total Amount[30]	DLR19_$S2	Currency	19
81	TOTLAMNT_31	Total Amount[31]	DLR19_$S2	Currency	19
82	TOTLAMNT_32	Total Amount[32]	DLR19_$S2	Currency	19
83	TOTLAMNT_33	Total Amount[33]	DLR19_$S2	Currency	19
84	TOTLAMNT_34	Total Amount[34]	DLR19_$S2	Currency	19
85	TOTLAMNT_35	Total Amount[35]	DLR19_$S2	Currency	19
86	TOTLAMNT_36	Total Amount[36]	DLR19_$S2	Currency	19
87	TOTLAMNT_37	Total Amount[37]	DLR19_$S2	Currency	19
88	TOTLAMNT_38	Total Amount[38]	DLR19_$S2	Currency	19
89	TOTLAMNT_39	Total Amount[39]	DLR19_$S2	Currency	19
90	TOTLAMNT_40	Total Amount[40]	DLR19_$S2	Currency	19
91	ACCTAMNT	Account Amount	DLR19_RBS0_UTR$	Currency	19
92	PYMTRMID	Payment Terms ID	STR20_Payment_Terms_ID	String	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SV_Invoice_MSTR'].PYMTRMID AS 'SV_Invoice_MSTR-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM SV00700 AS ['SV_Invoice_MSTR'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SV_Invoice_MSTR'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
93	TAXSCHID	Tax Schedule ID	STR15_Tax_Schedule_ID	String	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SV_Invoice_MSTR'].TAXSCHID AS 'SV_Invoice_MSTR-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SV00700 AS ['SV_Invoice_MSTR'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SV_Invoice_MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
94	Invoice_Comment_ID_1	Invoice Comment ID 1	INT5	Integer	4
95	Invoice_Comment_ID_2	Invoice Comment ID 2	INT5	Integer	4
96	CASHAMNT	Cash Amount	DLR19_RBS0_UTR$	Currency	19
97	DOCDATE	Document Date	DT	Date	8
98	SLPRSNID	Salesperson ID	STR15_Salesperson_ID	String	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SV_Invoice_MSTR'].SLPRSNID AS 'SV_Invoice_MSTR-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM SV00700 AS ['SV_Invoice_MSTR'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SV_Invoice_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
99	COMPRCNT	Commission Percent	INT5_%2	Integer	5
100	Commission_Pct_of_Sale	Commission Percent of Sale	INT5_%2	Integer	5
101	COMMERNG	Commission Earnings	DLR11_$S2	Currency	14
102	SALSTERR	Sales Territory	STR15_Sales_Territory	String	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['SV_Invoice_MSTR'].SALSTERR AS 'SV_Invoice_MSTR-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM SV00700 AS ['SV_Invoice_MSTR'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['SV_Invoice_MSTR'].SALSTERR = ['Sales Territory Master File'].SALSTERR
103	Salesperson_ID_2	Salesperson ID 2	STR15_Salesperson_ID	String	15
104	Commission_Percent_2	Commission Percent 2	INT5_%2	Integer	5
105	Commission_Pct_of_Sale_2	Commission Percent of Sale 2	INT5_%2	Integer	5
106	Commission_Earnings_2	Commission Earnings 2	DLR11_$S2	Currency	14
107	Sales_Territory_2	Sales Territory 2	STR15_Sales_Territory	String	15
108	PORDNMBR	Purchase Order Number	Purchase Order Number	String	20
109	TRDISAMT	Trade Discount Amount	DLR17_RBS0_UTR$	Currency	17
110	CBKIDCHK	Checkbook ID Check	STR15_Checkbook_ID	String	15
111	CASHDATE	Cash Date	DATE	Date	6
112	DCNUMCSH	Document Number Cash	STR20_Document_Number	String	20
113	CHEKAMNT	Check Amount	DLR19_RBS0_UTR$	Currency	19
114	CBKIDCRD	Checkbook ID Credit Card	STR15_Checkbook_ID	String	15
115	CHEKNMBR	Check Number	STR20_Document_Number	String	20
116	CHEKDATE	Check Date	DATE	Date	6
117	DCNUMCHK	Document Number Check	STR20_Document_Number	String	20
118	DCNUMCRD	Document Number Credit Card	STR20_Document_Number	String	20
119	CRCRDAMT	Credit Card Amount	DLR19_RBS0_UTR$	Currency	19
120	CRCRDNAM	Credit Card Name	STR15	String	15
121	RCTNCCRD	Receipt Number Credit Card	STR20_Document_Number	String	20
122	CRCARDDT	Credit Card Date	DATE	Date	6
123	DISTKNAM	Discount Taken Amount	DLR17_RBS0_UTR$	Currency	17
124	CBKIDCSH	Checkbook ID Cash	STR15_Checkbook_ID	String	15
125	Wennsoft_Posting_Status	Wennsoft Posting Status	STR1	String	1
126	POSTEDDT	Posted Date	DATE	Date	6
127	Invoice_Style	Invoice Style	INT2	Integer	2
128	No_Times_Printed	No. Times Printed	INT2	Integer	2
129	Printed_Date	Printed Date	DATE	Date	6
130	Chgd_Since_Printing_Flag	Changed Since Printing Flag	Boolean	Boolean	0
131	DOCAMNT	Document Amount	DLR19_RBSO_UTR$	Currency	19
132	DSCPCTAM	Discount Percent Amount	INT5_%2	Integer	5
133	DSCDLRAM	Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	11
134	DISAVAMT	Discount Available Amount	DLR17_RBS0_UTR$	Currency	17
135	DISCDATE	Discount Date	DT	Date	8
136	DUEDATE	Due Date	DT	Date	8
137	RMDNUMWK	RM Document Number-WORK	STR17_LBAU	String	17
138	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
139	Date_Paid	Date Paid	DT	Date	8
140	Amount_Recieved	Amount Recieved	DLR11_$U2	Currency	14
141	Corporate_Contract_Nbr	Corporate Contract Number	STR20_LBAU	String	20
142	WSMSTRCONTSQ	WS Master Contract Seq Number	LI_Sequence_Number	Long Integer	10
143	Contract_Number	WS Contract Number	STR10	String	10
144	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
145	Tax_Date	Tax Date	DT	Date	8
146	Labor_Group_Name	Labor Group Name	STR15_RM_Customer_Number	String	15
147	Pricing_Matrix_Name	Pricing Matrix Name	STR15_RM_Customer_Number	String	15
148	Travel_Rate_Name	Travel Rate Name	STR15_RM_Customer_Number	String	15
149	Bill_Customer_Number	Bill Customer Number	STR15_RM_Customer_Number	String	15
150	Bill_Address_Code	Bill Address Code	STR15_Address_Code	String	15
151	Service_User_Define_1	Service User Define 1	STR20	String	20
152	Service_User_Define_2	Service User Define 2	STR20	String	20
153	Service_User_Define_3	Service User Define 3	STR30	String	30
154	Service_User_Define_4	Service User Define 4	STR30	String	30
155	Service_User_Define_5	Service User Define 5	LI6_S2	Long Integer	6
156	Service_User_Define_6	Service User Define 6	LI6_S2	Long Integer	6
157	Service_User_Define_7	Service User Define 7	LI6_S2	Long Integer	6
158	Service_User_Define_8	Service User Define 8	LI6_S2	Long Integer	6
159	Service_User_Define_9	Service User Define 9	DT	Date	8
160	Service_User_Define_10	Service User Define 10	DT	Date	8
161	Service_User_Define_11	Service User Define 11	DT	Date	8
162	Service_User_Define_12	Service User Define 12	DT	Date	8
163	Service_User_Define_18	Service User Define 18	CB	Boolean	0
164	Service_User_Define_19	Service User Define 19	CB	Boolean	0
165	Service_User_Define_20	Service User Define 20	CB	Boolean	0
166	Service_User_Define_21	Service User Define 21	CB	Boolean	0
167	Service_User_Define_22	Service User Define 22	DLR14_RBS0_STR$	Currency	14
168	Service_User_Define_23	Service User Define 23	DLR14_RBS0_STR$	Currency	14
169	Service_User_Define_24	Service User Define 24	DLR14_RBS0_STR$	Currency	14
170	Service_User_Define_25	Service User Define 25	DLR14_RBS0_STR$	Currency	14
171	MODIFDT	Modified Date	DT	Date	8
172	Modified_Time	Modified Time	TM6	Time	6
173	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Invoice_MSTR'].MDFUSRID AS 'SV_Invoice_MSTR-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00700 AS ['SV_Invoice_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Invoice_MSTR'].MDFUSRID = ['Users Master'].USERID
174	Time_Zone	Time Zone	STR3	String	3
175	SV_Language_ID	SV Language ID	INT2	Integer	2
176	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
177	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
178	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
179	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
180	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
181	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
182	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
183	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
184	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
185	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
186	WSReserved_STR1	WSReserved STR1	STR10	String	10
187	WSReserved_STR2	WSReserved STR2	STR10	String	10
188	Invoice_Short_Desc	Invoice Short Description	STR30	String	30
189	Manual_Sales_Dist	Manual Sales Distribution	Boolean	Boolean	0
190	Manual_Commission_Dist	Manual Commission Distribution	Boolean	Boolean	0
191	BilledToJobEquipment	BilledToJobEquipment	DLR14_RBS0_STR$	Currency	14
192	BilledToJobMaterial	BilledToJobMaterial	DLR14_RBS0_STR$	Currency	14
193	BilledToJobLabor	BilledToJobLabor	DLR14_RBS0_STR$	Currency	14
194	BilledToJobSubcontractor	BilledToJobSubcontractor	DLR14_RBS0_STR$	Currency	14
195	BilledToJobOther	BilledToJobOther	DLR14_RBS0_STR$	Currency	14
196	WS_Grouped	WS Grouped	Boolean	Boolean	0
197	Invoice_Description	Invoice Description	TX2000	Text	2000

azurecurve Products WennSoft Products (131)3rd PartySV_Invoice_MSTR (SV00700)

Leave a Reply Cancel reply