Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00799
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Invoices_To_Group_TEMP
Physical Name: SV00799
Technical Name: SV_Invoices_To_Group_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Service_Call_ID 
Service Call ID STR17_LBAU String 17 2 Reference_TRX_Number Reference TRX Number STR17_LBAU String 17 3 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 4 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Invoices_To_Group_TEMP'].USERID AS 'SV_Invoices_To_Group_TEMP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV00799 AS ['SV_Invoices_To_Group_TEMP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Invoices_To_Group_TEMP'].USERID = ['Users Master'].USERID5 RMDNUMWK RM Document Number-WORK STR17_LBAU String 17 6 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 Payments7 BACHNUMB Batch Number STR15_LBAU String 15 8 Group_Invoice_Checkbox Group Invoice Checkbox CB Boolean 0 9 Bill_Checkbox Bill Checkbox CB Boolean 0 10 Completion_Date SV Completion Date DT Date 8 11 Divisions Divisions STR15_LBAU String 15 12 WS_Job_Type WS Job Type STR17_LBAU String 17 13 WS_Job_Name WS Job Name STR30 String 30 14 Committed_Cost Committed Cost DLR19_TS Currency 19 15 WS_Extended_Cost WS Extended Cost DLR14_RBS0_STR$ Currency 14 16 Billing_Amount Billing Amount DLR14_RBS0_STR$ Currency 14 17 Call_Invoice_Number Call Invoice Number STR17_LBAU String 17 18 Bill_Customer_Number Bill Customer Number STR15_RM_Customer_Number String 15 19 CUSTNAME Customer Name STR64_Customer_Name String 64 20 Bill_Address_Code Bill Address Code STR15_Address_Code String 15 21 Bill_To_Location_Name Bill To Location Name STR30 String 30 22 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['SV_Invoices_To_Group_TEMP'].VENDORID AS 'SV_Invoices_To_Group_TEMP-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SV00799 AS ['SV_Invoices_To_Group_TEMP']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SV_Invoices_To_Group_TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID23 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 24 Cost_Code_Description Cost Code Description STR30 String 30 25 WS_Other_Cost_Sub_Code WS Other Cost Sub Code LI8_U0 Long Integer 8 26 WS_Sub_Code_Desc WS Sub Code Description STR30_LBAU String 30 27 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['SV_Invoices_To_Group_TEMP'].ITEMNMBR AS 'SV_Invoices_To_Group_TEMP-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SV00799 AS ['SV_Invoices_To_Group_TEMP']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SV_Invoices_To_Group_TEMP'].ITEMNMBR = ['Item Master'].ITEMNMBR28 ITEMDESC Item Description STR100 String 100 29 Billable_All Billable All DLR14_RBS0_STR$ Currency 14 30 Cost_All Cost All DLR14_RBS0_STR$ Currency 14 31 PORDNMBR Purchase Order Number Purchase Order Number String 20