Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLSP003
Product: Scheduled Instalment (1150)
Series: Purchasing
Display Name: Creditor Scheduled Instalments Master
Physical Name: RVLSP003
Technical Name: rvlVendPmntSchldMSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Creditor Scheduled Instalments Master'].VENDORID AS 'Creditor Scheduled Instalments Master-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
RVLSP003 AS ['Creditor Scheduled Instalments Master']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Creditor Scheduled Instalments Master'].VENDORID = ['PM Vendor Master File'].VENDORID2 PMNTSCHLDID PmntSchldID STR15_LBAU String 15 3 PAYDAY_1 Payday[1] Pay Day Integer 2 4 PAYDAY_2 Payday[2] Pay Day Integer 2 5 PAYDAY_3 Payday[3] Pay Day Integer 2 6 PAYDAY_4 Payday[4] Pay Day Integer 2 7 NOPAYMTH_1 Nonpaying Month[1] Nonpaying Month Integer 2 8 NOPAYMTH_2 Nonpaying Month[2] Nonpaying Month Integer 2