Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV_SVRec
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_SVReconciliation_View
Physical Name: SV_SVRec
Technical Name: SV_SVReconciliation_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 WS_Orgin_Str 
WS_Orgin_Str STR20 String 20 2 POSTDATE Post Date DT_Date Date 6 3 ACTNUMST Account Number String STR128_LBU String 128 4 ACTDESCR Account Description STR50 String 50 5 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SV_SVReconciliation_View'].ACTINDX AS 'SV_SVReconciliation_View-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
SV_SVRec AS ['SV_SVReconciliation_View']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SV_SVReconciliation_View'].ACTINDX = ['Account Index Master'].ACTINDX6 Service_Call_ID Service Call ID STR17_LBAU String 17 7 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 8 TRXSOURC Transaction Source STR25 String 25 9 Reference_TRX_Number Reference TRX Number STR17_LBAU String 17 10 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 11 WS_Extended_Cost WS Extended Cost DLR14_RBS0_STR$ Currency 14 12 WS_WIP_Entry_DR WS_WIP_Entry_DR DLR14_RBS0_STR$ Currency 14 13 WS_WIP_Entry_CR WS_WIP_Entry_CR DLR14_RBS0_STR$ Currency 14 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 Divisions Divisions STR15_LBAU String 15 17 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_SVReconciliation_View'].CUSTNMBR AS 'SV_SVReconciliation_View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV_SVRec AS ['SV_SVReconciliation_View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_SVReconciliation_View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR18 ADRSCODE Address Code STR15_Address_Code String 15 19 WS_Cost_Code_STR WS Cost Code STR STR20_LBAU String 20 20 Contract_Number WS Contract Number STR10 String 10 21 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 22 Contract_Start_Date WS Contract Start Date DT Date 8 23 Contract_Expiration_Date Contract Experation Date DT Date 8