Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV_NotSV
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_GLCostNotInService_VIEW
Physical Name: SV_NotSV
Technical Name: SV_GLCostNotInService_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 OPENYEAR 
Open Year INT4_S0 Integer 4 2 JRNENTRY Journal Entry LI8_U0 Long Integer 8 3 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 4 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].SOURCDOC AS 'SV_GLCostNotInService_VIEW-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['SV_GLCostNotInService_VIEW'].SOURCDOC = ['Source Document Master'].SOURCDOC5 REFRENCE Reference STR30 String 30 6 DSCRIPTN Description STR30 String 30 7 TRXDATE TRX Date DT_Date Date 6 8 TRXSORCE TRX Source STR13 String 13 9 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].ACTINDX AS 'SV_GLCostNotInService_VIEW-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SV_GLCostNotInService_VIEW'].ACTINDX = ['Account Index Master'].ACTINDX10 POLLDTRX Polled Transaction YN Boolean 0 11 LASTUSER Last User User_ID String 15 12 LSTDTEDT Last Date Edited DT_Date Date 6 13 USWHPSTD User Who Posted User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].USWHPSTD AS 'SV_GLCostNotInService_VIEW-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_GLCostNotInService_VIEW'].USWHPSTD = ['Users Master'].USERID14 ORGNTSRC Originating Source STR15 String 15 15 ORGNATYP Originating Type INT Integer 0 16 QKOFSET Quick Offset INT Integer 0 17 SERIES Series DDL_Series Integer 0 18 ORTRXTYP Originating TRX Type INT Integer 0 19 ORCTRNUM Originating Control Number STR20 String 20 20 ORMSTRID Originating Master ID STR30 String 30 21 ORMSTRNM Originating Master Name STR64 String 64 22 ORDOCNUM Originating Document Number STR20 String 20 23 ORPSTDDT Originating Posted Date DT_Date Date 6 24 ORTRXSRC Originating TRX Source STR13 String 13 25 OrigDTASeries Originating DTA Series INT Integer 0 26 OrigSeqNum Originating Sequence Number Long Int Long Integer 8 27 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 28 DTA_GL_Status DTA GL Status INT1 Integer 1 29 DTA_Index DTA Index DLR14 Currency 14 30 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].CURNCYID AS 'SV_GLCostNotInService_VIEW-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SV_GLCostNotInService_VIEW'].CURNCYID = ['Currency Setup'].CURNCYID31 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].CURRNIDX AS 'SV_GLCostNotInService_VIEW-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SV_GLCostNotInService_VIEW'].CURRNIDX = ['Currency Setup'].CURRNIDX32 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].RATETPID AS 'SV_GLCostNotInService_VIEW-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SV_GLCostNotInService_VIEW'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID33 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].EXGTBLID AS 'SV_GLCostNotInService_VIEW-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['SV_GLCostNotInService_VIEW'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID34 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 35 EXCHDATE Exchange Date DT_Date Date 6 36 TIME1 Time TM6 Time 6 37 RTCLCMTD Rate Calculation Method GB Integer 0 38 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].NOTEINDX AS 'SV_GLCostNotInService_VIEW-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SV_GLCostNotInService_VIEW'].NOTEINDX = ['Record Notes Master'].NOTEINDX39 ICTRX IC TRX CB_IC_TRX Boolean 0 Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany40 ORCOMID Originating Company ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['SV_GLCostNotInService_VIEW'].ORCOMID AS 'SV_GLCostNotInService_VIEW-Originating Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
SV_NotSV AS ['SV_GLCostNotInService_VIEW']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['SV_GLCostNotInService_VIEW'].ORCOMID = ['Company Master'].CMPANYID41 ORIGINJE Originating Journal Entry LI8_U0 Long Integer 8 42 PERIODID Period ID INT3 Integer 3 43 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 44 DEBITAMT Debit Amount DLR19_$S2 Currency 19 45 ORCRDAMT Originating Credit Amount DLR19_$S2 Currency 19 46 ORDBTAMT Originating Debit Amount DLR19_$S2 Currency 19 47 DOCDATE Document Date DT Date 8 48 PSTGNMBR Posting Number LI8_U0 Long Integer 8 49 PPSGNMBR Period Posting Number LI8_U0 Long Integer 8 50 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 51 MCTRXSTT MC Transaction State INT1 Integer 1 52 CorrespondingUnit CorrespondingUnit STR5_IC_ID String 5 53 VOIDED Voided CB Boolean 0 54 Back_Out_JE Back Out JE LI8_U0 Long Integer 8 55 Back_Out_JE_Year Back Out JE Year INT Integer 0 56 Correcting_JE Correcting JE LI8_U0 Long Integer 8 57 Correcting_JE_Year Correcting JE Year INT Integer 0 58 Original_JE Original JE LI8_U0 Long Integer 8 59 Original_JE_Seq_Num Original JE Seq Num DLR19_$S2 Currency 19 60 Original_JE_Year Original JE Year INT Integer 0