Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JCCIS150
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Sub_CIS24_Reconcile
Physical Name: JCCIS150
Technical Name: JC_Sub_CIS24_ReconcileSeq 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
['JC_Sub_CIS24_Reconcile'].VENDORID AS 'JC_Sub_CIS24_Reconcile-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
JCCIS150 AS ['JC_Sub_CIS24_Reconcile']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['JC_Sub_CIS24_Reconcile'].VENDORID = ['PM Vendor Master File'].VENDORID2 VENDNAME Vendor Name STR64_Vendor_Name String 64 3 PMNTNMBR Payment Number STR20_LBAU String 20 4 VCHNUMWK Voucher Number - WORK STR17_LBAU String 17 5 DOCNUMBR Document Number STR20_Document_Number String 20 6 DOCDATE Document Date DT Date 8 7 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 8 CHEKTOTL Check Total DLR19_RBS0_UTR$ Currency 19 9 CIS_Certificate_Type CIS Certificate Type DDL Integer 0 10 Subcontractor_Type Subcontractor Type DDL Integer 0 11 RCPTNMBR Receipt Number STR20_Document_Number String 20 12 CIS_Card_Number CIS Card Number STR32 String 32 13 DATE1 Date DT6 Date 6 14 AMOUNT Amount DLR19_RBS0_STR$ Currency 19 15 Outstanding_Amount Outstanding Amount DLR19_RBS0_UTR$ Currency 19 16 Matched Matched Boolean Boolean 0 17 VOIDED Voided CB Boolean 0