Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLPD027
Product: Payment Document Management (2150)
Series:
Display Name: Purchasing Payment Document Settlement Header
Physical Name: RVLPD027
Technical Name: rvlpmPmntDocTRXHDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 REMTYPE 
RemitType Integer RemitType 0 2 REMITID RemitID String RemitID 15 3 PMTDOCID PmntDocID String PmntDocID 15 4 OrigPmntDocStatus OrigPmntDocStatus Integer GB 0 5 ORICBOOK OrigCheckbookID String STR15_Checkbook_ID 15 6 DESCBOOK DestCheckbookID String STR15_Checkbook_ID 15 7 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Purchasing Payment Document Settlement Header'].CURNCYID AS 'Purchasing Payment Document Settlement Header-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RVLPD027 AS ['Purchasing Payment Document Settlement Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Payment Document Settlement Header'].CURNCYID = ['Currency Setup'].CURNCYID8 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Purchasing Payment Document Settlement Header'].CURRNIDX AS 'Purchasing Payment Document Settlement Header-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
RVLPD027 AS ['Purchasing Payment Document Settlement Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Payment Document Settlement Header'].CURRNIDX = ['Currency Setup'].CURRNIDX9 MCSTRUCT MC Def Structure MC_Def_Structure Composite 0 10 MCSTRUCT_1 MC Def Structure:Currency ID String STR15_Currency_ID 15 11 MCSTRUCT_2 MC Def Structure:Currency Index Integer INT3 3 12 MCSTRUCT_3 MC Def Structure:Rate Type ID String STR15_Rate_Type_ID 15 13 MCSTRUCT_4 MC Def Structure:Exchange Table ID String STR15_Exchange_Table_ID 15 14 MCSTRUCT_5 MC Def Structure:Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 15 MCSTRUCT_6 MC Def Structure:Exchange Date Date DT_Date 6 16 MCSTRUCT_7 MC Def Structure:Decimal Places Integer DDL_Decimal_Places 0 17 MCSTRUCT_8 MC Def Structure:Time Time TM6 6 18 MCSTRUCT_9 MC Def Structure:Rate Calc Method Integer INT 0 19 MCSTRUCT_10 MC Def Structure:View Mode Integer INT 0 20 MCSTRUCT_11 MC Def Structure:IS MC Trx Integer INT 0 21 MCSTRUCT_12 MC Def Structure:Expiration Date Date DT_Date 6 22 MCSTRUCT_13 MC Def Structure:Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 23 MCSTRUCT_14 MC Def Structure:MC Transaction State Integer INT1 1 24 TRXDATE TRX Date Date DT_Date 6 25 PSTGDATE Posting Date Date DT 8 26 BANKACCT BankAcct String BankAcct 35 27 COMMAMNT Commission Amount Currency DLR17_RBS0_STR$ 17 28 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Purchasing Payment Document Settlement Header'].ACTINDX AS 'Purchasing Payment Document Settlement Header-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
RVLPD027 AS ['Purchasing Payment Document Settlement Header']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Purchasing Payment Document Settlement Header'].ACTINDX = ['Account Index Master'].ACTINDX29 REMTSTAT RemitStatus Integer INT2 2 30 NUMOFTRX Number Of TRX Long Integer LI6_U0 6 31 FUNCTAMT Functional Amount Currency DLR19_$S2 19 32 ORIGAMT Originating Amount Currency DLR19_$S2 19 33 CMRecordNumber CMRecordNumber Currency DLR_Document_Number 19 34 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Purchasing Payment Document Settlement Header'].NOTEINDX AS 'Purchasing Payment Document Settlement Header-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLPD027 AS ['Purchasing Payment Document Settlement Header']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Purchasing Payment Document Settlement Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX