Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC90500
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Subs_Status_VIEW
Physical Name: JC90500
Technical Name: JC_Subs_Status_VIEWSeq 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_Subs_Status_VIEW'].VENDORID AS 'JC_Subs_Status_VIEW-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
JC90500 AS ['JC_Subs_Status_VIEW']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['JC_Subs_Status_VIEW'].VENDORID = ['PM Vendor Master File'].VENDORID2 VENDNAME Vendor Name STR64_Vendor_Name String 64 3 Retention_Withheld_TTD Retention Withheld TTD DLR19_TS Currency 19 4 Apply_Doc_Paid_TTD Apply Doc Paid TTD DLR19_TS Currency 19 5 Orig_Contract_Amount Original Contract Amount DLR19_TS Currency 19 6 Change_Orders_TTD Change Orders TTD DLR19_TS Currency 19 7 Contract_to_Date Contract to Date DLR14_TS Currency 14 8 Vendor_Invoices_TTD Vendor Invoices TTD DLR19_TS Currency 19 9 Actual_Units_TTD Actual Units TTD DLR14_TS Currency 14 10 Total_Invoices_Due Total Invoices Due DLR19_TS Currency 19 11 HOLD Hold CB_Hold Boolean 0 12 ContractAgreementAmount Contract Agreement Amount DLR19_TS Currency 19 13 ContractAgreementCOAmt Contract Agreement Change Order Amount DLR19_TS Currency 19