SV_Invoice_History (SV00701)

azurecurve Products WennSoft Products (131)3rd PartySV_Invoice_History (SV00701)

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

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

Display Name: SV_Invoice_History
Physical Name: SV00701
Technical Name: SV_Invoice_History

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

azurecurve Products WennSoft Products (131)3rd PartySV_Invoice_History (SV00701)

Leave a Reply Cancel reply