Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00614
Product: FieldService (949)
Series:
Display Name: svc Contract Line Revenue Audit
Physical Name: SVC00614
Technical Name: svcContractLineRevenueAuditSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['svc Contract Line Revenue Audit'].USERID AS 'svc Contract Line Revenue Audit-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVC00614 AS ['svc Contract Line Revenue Audit']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['svc Contract Line Revenue Audit'].USERID = ['Users Master'].USERID2 TRXSORCE TRX Source String STR13 13 3 CONSTS Contract Record Type Integer DDL_Contract_Status 0 4 CONTNBR Contract Number String STR11 11 5 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 6 YEAR1 Year Integer Year 4 7 PERIODID Period ID Integer INT3 3 8 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 9 Status Status Integer INT 0 10 POSTEDDT Posted Date Date DATE 6 11 Transaction_Date Transaction Date Date DATE_LONG 8 12 PSTDAMNT Posted Amount Currency DLR17_$S2 17 13 Source_Trx_Document_Type Source Trx Document Type String STR2 2 14 SourceTrxDocumentNumber Source Trx Document Number String STR255 255 15 Transaction_Amount Transaction Amount Currency DLR19_RBS0_UTR$ 19 16 SVC_Coverage_Start_Date SVC_Coverage_Start_Date Date DATE_L 0 17 SVC_Coverage_End_Date SVC_Coverage_End_Date Date DATE_L 0 18 DSCDLRAM Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 19 Net_Transaction_Amount Net Transaction Amount Currency DLR19_RBSO_UTR$ 19 20 ERMSGNUM Error MSG Number Long Integer LI_14 14 21 ERRDESCR Error Description String STR130 130