Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLSP010
Product: Scheduled Instalment (1150)
Series: Purchasing
Display Name: PM Scheduled Instalments Line Work
Physical Name: RVLSP010
Technical Name: rvlpmPmntSchldLINEWORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VCHNUMWK 
Voucher Number - WORK STR17_LBAU String 17 2 BCHSOURC Batch Source STR15 String 15 3 BACHNUMB Batch Number STR15_LBAU String 15 4 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 5 DEBTAMT DebtAmt DLR19_RBSO_UTR$ Currency 19 6 DATE DebtDueDate DATE Date 6 7 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PM Scheduled Instalments Line Work'].CURNCYID AS 'PM Scheduled Instalments Line Work-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RVLSP010 AS ['PM Scheduled Instalments Line Work']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Scheduled Instalments Line Work'].CURNCYID = ['Currency Setup'].CURNCYID8 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PM Scheduled Instalments Line Work'].CURRNIDX AS 'PM Scheduled Instalments Line Work-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
RVLSP010 AS ['PM Scheduled Instalments Line Work']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Scheduled Instalments Line Work'].CURRNIDX = ['Currency Setup'].CURRNIDX