SV_Reconciliation_View (SV_Recon)

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_View

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Service_Call_ID SearchService Call IDSTR17_LBAUString1817
2Reference_TRX_Number SearchReference TRX NumberSTR17_LBAUString1817
3SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
4TRXSOURC SearchTransaction SourceSTR25String2625
5DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
6Wennsoft_Status SearchWennsoft StatusSTR4_LBAUString64
7WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer48
8Divisions SearchDivisionsSTR15_LBAUString1615
9Type_Call_Short SearchType Call ShortSTR3_LBAUString43
10WS_WIP_PostDate SearchWS_WIP_PostDateDATEDate46
11WS_WIP_Entry_DR SearchWS_WIP_Entry_DRDLR14_RBS0_STR$Currency1014
12WS_WIP_Entry_CR SearchWS_WIP_Entry_CRDLR14_RBS0_STR$Currency1014
13WS_COGS_PostDate SearchWS_COGS_PostDateDATEDate46
14WS_COGS_Entry_DR SearchWS_COGS_Entry_DRDLR14_RBS0_STR$Currency1014
15WS_COGS_Entry_CR SearchWS_COGS_Entry_CRDLR14_RBS0_STR$Currency1014
16WS_Extended_Cost SearchWS Extended CostDLR14_RBS0_STR$Currency1014
17CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
18ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
19Contract_Number SearchWS Contract NumberSTR10String1210
20WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer410
21Contract_Start_Date SearchWS Contract Start DateDTDate48
22Contract_Expiration_Date SearchContract Experation DateDTDate48

Leave a Reply

Your email address will not be published. Required fields are marked *