Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00702
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Invoice_MSTR_Report
Physical Name: SV00702
Technical Name: SV_Invoice_MSTR_ReportSeq 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_Report'].CUSTNMBR AS 'SV_Invoice_MSTR_Report-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV00702 AS ['SV_Invoice_MSTR_Report']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Invoice_MSTR_Report'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR3 Call_Invoice_Number Call Invoice Number STR17_LBAU String 17 4 ADRSCODE Address Code STR15_Address_Code String 15 5 PRBTADCD Primary Billto Address Code STR15_LBAU String 15 6 Invoice_Type Invoice Type DDL_Invoice_Type Integer 0 7 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 8 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 9 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 10 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Invoice_MSTR_Report'].USERID AS 'SV_Invoice_MSTR_Report-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV00702 AS ['SV_Invoice_MSTR_Report']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Invoice_MSTR_Report'].USERID = ['Users Master'].USERID11 Technician_ID Technician ID STR15_Employee_ID String 15 12 Technician_Team Technician Team STR15_LBAU String 15 13 CUSTNAME Customer Name STR64_Customer_Name String 64 14 Corporate_Invoice_Number Corporate Invoice Number STR17_LBAU String 17 15 CPRCSTNM Corporate Customer Number STR15_RM_Customer_Number String 15 16 BACHNUMB Batch Number STR15_LBAU String 15 17 BCHSOURC Batch Source STR15 String 15 18 Labor_Cost_Catagory_1 Labor Cost Catagory 1 DLR14_RBS0_STR$ Currency 14 19 Labor_Cost_Catagory_2 Labor Cost Catagory 2 DLR14_RBS0_STR$ Currency 14 20 Labor_Cost_Catagory_3 Labor Cost Catagory 3 DLR14_RBS0_STR$ Currency 14 21 Labor_Cost_Catagory_4 Labor Cost Catagory 4 DLR14_RBS0_STR$ Currency 14 22 Labor_Cost_Catagory_5 Labor Cost Catagory 5 DLR14_RBS0_STR$ Currency 14 23 Cost_Equipment Cost Equipment DLR14_RBS0_STR$ Currency 14 24 Cost_Material Cost Material DLR14_RBS0_STR$ Currency 14 25 Cost_Labor Cost Labor DLR14_RBS0_STR$ Currency 14 26 Cost_Subs Cost Subs DLR14_RBS0_STR$ Currency 14 27 Cost_Other Cost Other 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 TOTLAMNT_1 Total Amount[1] DLR19_$S2 Currency 19 50 TOTLAMNT_2 Total Amount[2] DLR19_$S2 Currency 19 51 TOTLAMNT_3 Total Amount[3] DLR19_$S2 Currency 19 52 TOTLAMNT_4 Total Amount[4] DLR19_$S2 Currency 19 53 TOTLAMNT_5 Total Amount[5] DLR19_$S2 Currency 19 54 TOTLAMNT_6 Total Amount[6] DLR19_$S2 Currency 19 55 TOTLAMNT_7 Total Amount[7] DLR19_$S2 Currency 19 56 TOTLAMNT_8 Total Amount[8] DLR19_$S2 Currency 19 57 TOTLAMNT_9 Total Amount[9] DLR19_$S2 Currency 19 58 TOTLAMNT_10 Total Amount[10] DLR19_$S2 Currency 19 59 TOTLAMNT_11 Total Amount[11] DLR19_$S2 Currency 19 60 TOTLAMNT_12 Total Amount[12] DLR19_$S2 Currency 19 61 TOTLAMNT_13 Total Amount[13] DLR19_$S2 Currency 19 62 TOTLAMNT_14 Total Amount[14] DLR19_$S2 Currency 19 63 TOTLAMNT_15 Total Amount[15] DLR19_$S2 Currency 19 64 TOTLAMNT_16 Total Amount[16] DLR19_$S2 Currency 19 65 TOTLAMNT_17 Total Amount[17] DLR19_$S2 Currency 19 66 TOTLAMNT_18 Total Amount[18] DLR19_$S2 Currency 19 67 TOTLAMNT_19 Total Amount[19] DLR19_$S2 Currency 19 68 TOTLAMNT_20 Total Amount[20] DLR19_$S2 Currency 19 69 TOTLAMNT_21 Total Amount[21] DLR19_$S2 Currency 19 70 TOTLAMNT_22 Total Amount[22] DLR19_$S2 Currency 19 71 TOTLAMNT_23 Total Amount[23] DLR19_$S2 Currency 19 72 TOTLAMNT_24 Total Amount[24] DLR19_$S2 Currency 19 73 TOTLAMNT_25 Total Amount[25] DLR19_$S2 Currency 19 74 TOTLAMNT_26 Total Amount[26] DLR19_$S2 Currency 19 75 TOTLAMNT_27 Total Amount[27] DLR19_$S2 Currency 19 76 TOTLAMNT_28 Total Amount[28] DLR19_$S2 Currency 19 77 TOTLAMNT_29 Total Amount[29] DLR19_$S2 Currency 19 78 TOTLAMNT_30 Total Amount[30] DLR19_$S2 Currency 19 79 TOTLAMNT_31 Total Amount[31] DLR19_$S2 Currency 19 80 TOTLAMNT_32 Total Amount[32] DLR19_$S2 Currency 19 81 TOTLAMNT_33 Total Amount[33] DLR19_$S2 Currency 19 82 TOTLAMNT_34 Total Amount[34] DLR19_$S2 Currency 19 83 TOTLAMNT_35 Total Amount[35] DLR19_$S2 Currency 19 84 TOTLAMNT_36 Total Amount[36] DLR19_$S2 Currency 19 85 TOTLAMNT_37 Total Amount[37] DLR19_$S2 Currency 19 86 TOTLAMNT_38 Total Amount[38] DLR19_$S2 Currency 19 87 TOTLAMNT_39 Total Amount[39] DLR19_$S2 Currency 19 88 TOTLAMNT_40 Total Amount[40] DLR19_$S2 Currency 19 89 ACCTAMNT Account Amount DLR19_RBS0_UTR$ Currency 19 90 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_Report'].PYMTRMID AS 'SV_Invoice_MSTR_Report-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
SV00702 AS ['SV_Invoice_MSTR_Report']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['SV_Invoice_MSTR_Report'].PYMTRMID = ['Payment Terms Master'].PYMTRMID91 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_Report'].TAXSCHID AS 'SV_Invoice_MSTR_Report-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SV00702 AS ['SV_Invoice_MSTR_Report']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SV_Invoice_MSTR_Report'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID92 Invoice_Comment_ID_1 Invoice Comment ID 1 INT5 Integer 4 93 Invoice_Comment_ID_2 Invoice Comment ID 2 INT5 Integer 4 94 CASHAMNT Cash Amount DLR19_RBS0_UTR$ Currency 19 95 DOCDATE Document Date DT Date 8 96 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['SV_Invoice_MSTR_Report'].SLPRSNID AS 'SV_Invoice_MSTR_Report-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SV00702 AS ['SV_Invoice_MSTR_Report']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['SV_Invoice_MSTR_Report'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID97 COMPRCNT Commission Percent INT5_%2 Integer 5 98 Commission_Pct_of_Sale Commission Percent of Sale INT5_%2 Integer 5 99 COMMERNG Commission Earnings DLR11_$S2 Currency 14 100 SALSTERR Sales Territory STR15_Sales_Territory String 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['SV_Invoice_MSTR_Report'].SALSTERR AS 'SV_Invoice_MSTR_Report-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
SV00702 AS ['SV_Invoice_MSTR_Report']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['SV_Invoice_MSTR_Report'].SALSTERR = ['Sales Territory Master File'].SALSTERR101 Salesperson_ID_2 Salesperson ID 2 STR15_Salesperson_ID String 15 102 Commission_Percent_2 Commission Percent 2 INT5_%2 Integer 5 103 Commission_Pct_of_Sale_2 Commission Percent of Sale 2 INT5_%2 Integer 5 104 Commission_Earnings_2 Commission Earnings 2 DLR11_$S2 Currency 14 105 Sales_Territory_2 Sales Territory 2 STR15_Sales_Territory String 15 106 PORDNMBR Purchase Order Number Purchase Order Number String 20 107 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 108 CBKIDCHK Checkbook ID Check STR15_Checkbook_ID String 15 109 CASHDATE Cash Date DATE Date 6 110 DCNUMCSH Document Number Cash STR20_Document_Number String 20 111 CHEKAMNT Check Amount DLR19_RBS0_UTR$ Currency 19 112 CBKIDCRD Checkbook ID Credit Card STR15_Checkbook_ID String 15 113 CHEKNMBR Check Number STR20_Document_Number String 20 114 CHEKDATE Check Date DATE Date 6 115 DCNUMCHK Document Number Check STR20_Document_Number String 20 116 DCNUMCRD Document Number Credit Card STR20_Document_Number String 20 117 CRCRDAMT Credit Card Amount DLR19_RBS0_UTR$ Currency 19 118 CRCRDNAM Credit Card Name STR15 String 15 119 RCTNCCRD Receipt Number Credit Card STR20_Document_Number String 20 120 CRCARDDT Credit Card Date DATE Date 6 121 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 122 CBKIDCSH Checkbook ID Cash STR15_Checkbook_ID String 15 123 POSTEDDT Posted Date DATE Date 6 124 Invoice_Style Invoice Style INT2 Integer 2 125 No_Times_Printed No. Times Printed INT2 Integer 2 126 Printed_Date Printed Date DATE Date 6 127 Chgd_Since_Printing_Flag Changed Since Printing Flag Boolean Boolean 0 128 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 129 DSCPCTAM Discount Percent Amount INT5_%2 Integer 5 130 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 131 DISAVAMT Discount Available Amount DLR17_RBS0_UTR$ Currency 17 132 DISCDATE Discount Date DT Date 8 133 DUEDATE Due Date DT Date 8 134 RMDNUMWK RM Document Number-WORK STR17_LBAU String 17 135 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 Payments136 Date_Paid Date Paid DT Date 8 137 Amount_Recieved Amount Recieved DLR11_$U2 Currency 14 138 Corporate_Contract_Nbr Corporate Contract Number STR20_LBAU String 20 139 WSMSTRCONTSQ WS Master Contract Seq Number LI_Sequence_Number Long Integer 10 140 Contract_Number WS Contract Number STR10 String 10 141 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 142 Tax_Date Tax Date DT Date 8 143 Labor_Group_Name Labor Group Name STR15_RM_Customer_Number String 15 144 Pricing_Matrix_Name Pricing Matrix Name STR15_RM_Customer_Number String 15 145 Travel_Rate_Name Travel Rate Name STR15_RM_Customer_Number String 15 146 Bill_Customer_Number Bill Customer Number STR15_RM_Customer_Number String 15 147 Bill_Address_Code Bill Address Code STR15_Address_Code String 15 148 Service_User_Define_1 Service User Define 1 STR20 String 20 149 Service_User_Define_2 Service User Define 2 STR20 String 20 150 Service_User_Define_3 Service User Define 3 STR30 String 30 151 Service_User_Define_4 Service User Define 4 STR30 String 30 152 Service_User_Define_5 Service User Define 5 LI6_S2 Long Integer 6 153 Service_User_Define_6 Service User Define 6 LI6_S2 Long Integer 6 154 Service_User_Define_7 Service User Define 7 LI6_S2 Long Integer 6 155 Service_User_Define_8 Service User Define 8 LI6_S2 Long Integer 6 156 Service_User_Define_9 Service User Define 9 DT Date 8 157 Service_User_Define_10 Service User Define 10 DT Date 8 158 Service_User_Define_11 Service User Define 11 DT Date 8 159 Service_User_Define_12 Service User Define 12 DT Date 8 160 Service_User_Define_18 Service User Define 18 CB Boolean 0 161 Service_User_Define_19 Service User Define 19 CB Boolean 0 162 Service_User_Define_20 Service User Define 20 CB Boolean 0 163 Service_User_Define_21 Service User Define 21 CB Boolean 0 164 Service_User_Define_22 Service User Define 22 DLR14_RBS0_STR$ Currency 14 165 Service_User_Define_23 Service User Define 23 DLR14_RBS0_STR$ Currency 14 166 Service_User_Define_24 Service User Define 24 DLR14_RBS0_STR$ Currency 14 167 Service_User_Define_25 Service User Define 25 DLR14_RBS0_STR$ Currency 14 168 Time_Zone Time Zone STR3 String 3 169 SV_Language_ID SV Language ID INT2 Integer 2 170 WSReserved_CB1 WSReserved CB1 CB Boolean 0 171 WSReserved_CB2 WSReserved CB2 CB Boolean 0 172 WSReserved_CB3 WSReserved CB3 CB Boolean 0 173 WSReserved_CB4 WSReserved CB4 CB Boolean 0 174 WSReserved_CB5 WSReserved CB5 CB Boolean 0 175 WSReserved_CB6 WSReserved CB6 CB Boolean 0 176 WSReserved_CB7 WSReserved CB7 CB Boolean 0 177 WSReserved_CB8 WSReserved CB8 CB Boolean 0 178 WSReserved_CB9 WSReserved CB9 CB Boolean 0 179 WSReserved_CB10 WSReserved CB10 CB Boolean 0 180 WSReserved_STR1 WSReserved STR1 STR10 String 10 181 WSReserved_STR2 WSReserved STR2 STR10 String 10 182 Invoice_Short_Desc Invoice Short Description STR30 String 30 183 Manual_Sales_Dist Manual Sales Distribution Boolean Boolean 0 184 Manual_Commission_Dist Manual Commission Distribution Boolean Boolean 0 185 ADDRESS1 Address 1 STR60 String 60 186 ADDRESS2 Address 2 STR60 String 60 187 CITY City STR35 String 35 188 STATE State STR30_State String 29 189 ZIP Zip STR10 String 10 190 COUNTRY Country STR60 String 60 191 Invoice_Comment_1 Invoice Comment 1 STR60 String 60 192 Invoice_Comment_2 Invoice Comment 2 STR60 String 60 193 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SV_Invoice_MSTR_Report'].CURNCYID AS 'SV_Invoice_MSTR_Report-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SV00702 AS ['SV_Invoice_MSTR_Report']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SV_Invoice_MSTR_Report'].CURNCYID = ['Currency Setup'].CURNCYID194 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SV_Invoice_MSTR_Report'].CURRNIDX AS 'SV_Invoice_MSTR_Report-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SV00702 AS ['SV_Invoice_MSTR_Report']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SV_Invoice_MSTR_Report'].CURRNIDX = ['Currency Setup'].CURRNIDX195 ORDISTKN Originating Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 196 WS_Orig_Billable_All WS Orig Billable All DLR14_RBS0_STR$ Currency 14 197 WS_Orig_Billable_Equipme WS Orig Billable Equipment DLR14_RBS0_STR$ Currency 14 198 WS_Orig_Billable_Labor WS Orig Billable Labor DLR14_RBS0_STR$ Currency 14 199 WS_Orig_Billable_Materia WS Orig Billable Material DLR14_RBS0_STR$ Currency 14 200 WS_Orig_Billable_Other WS Orig Billable Other DLR14_RBS0_STR$ Currency 14 201 WS_Orig_Billable_Subs WS Orig Billable Subs DLR14_RBS0_STR$ Currency 14 202 WS_Orig_Billable_Tax WS Orig Billable Tax DLR14_RBS0_STR$ Currency 14 203 WS_Orig_Billable_Subtota WS Orig Billable Subtotal DLR14_RBS0_STR$ Currency 14 204 WS_Orig_Tax_Amount_4 WS Orig Tax Amount 4 DLR14_RBS0_STR$ Currency 14 205 WS_Orig_Tax_Amount1 WS Orig Tax Amount1 DLR14_RBS0_STR$ Currency 14 206 WS_Orig_Tax_Amount2 WS Orig Tax Amount2 DLR14_RBS0_STR$ Currency 14 207 WS_Orig_Tax_Amount3 WS Orig Tax Amount3 DLR14_RBS0_STR$ Currency 14 208 ORCCDAMT Originating Credit Card Amount DLR19_RBSO_UTR$ Currency 19 209 ORCHKAMT Originating Check Amount DLR19_RBSO_UTR$ Currency 19 210 ORCASAMT Originating Cash Amount DLR19_RBSO_UTR$ Currency 19 211 Invoice_Description Invoice Description TX2000 Text 2000