Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV_Recon
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Reconciliation_View
Physical Name: SV_Recon
Technical Name: SV_Reconciliation_ViewSeq 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 TRXSOURC Transaction Source STR25 String 25 5 DOCTYPE Document Type DDL_Document_Type Integer 0 6 Wennsoft_Status Wennsoft Status STR4_LBAU String 4 7 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 8 Divisions Divisions STR15_LBAU String 15 9 Type_Call_Short Type Call Short STR3_LBAU String 3 10 WS_WIP_PostDate WS_WIP_PostDate DATE Date 6 11 WS_WIP_Entry_DR WS_WIP_Entry_DR DLR14_RBS0_STR$ Currency 14 12 WS_WIP_Entry_CR WS_WIP_Entry_CR DLR14_RBS0_STR$ Currency 14 13 WS_COGS_PostDate WS_COGS_PostDate DATE Date 6 14 WS_COGS_Entry_DR WS_COGS_Entry_DR DLR14_RBS0_STR$ Currency 14 15 WS_COGS_Entry_CR WS_COGS_Entry_CR DLR14_RBS0_STR$ Currency 14 16 WS_Extended_Cost WS Extended Cost DLR14_RBS0_STR$ Currency 14 17 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Reconciliation_View'].CUSTNMBR AS 'SV_Reconciliation_View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV_Recon AS ['SV_Reconciliation_View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Reconciliation_View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR18 ADRSCODE Address Code STR15_Address_Code String 15 19 Contract_Number WS Contract Number STR10 String 10 20 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 21 Contract_Start_Date WS Contract Start Date DT Date 8 22 Contract_Expiration_Date Contract Experation Date DT Date 8