JC_Subs_Status_VIEW (JC90500)

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_VIEW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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'].VENDORID
2VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
3Retention_Withheld_TTD SearchRetention Withheld TTDDLR19_TSCurrency1019
4Apply_Doc_Paid_TTD SearchApply Doc Paid TTDDLR19_TSCurrency1019
5Orig_Contract_Amount SearchOriginal Contract AmountDLR19_TSCurrency1019
6Change_Orders_TTD SearchChange Orders TTDDLR19_TSCurrency1019
7Contract_to_Date SearchContract to DateDLR14_TSCurrency1014
8Vendor_Invoices_TTD SearchVendor Invoices TTDDLR19_TSCurrency1019
9Actual_Units_TTD SearchActual Units TTDDLR14_TSCurrency1014
10Total_Invoices_Due SearchTotal Invoices DueDLR19_TSCurrency1019
11HOLD SearchHoldCB_HoldBoolean20
12ContractAgreementAmount SearchContract Agreement AmountDLR19_TSCurrency1019
13ContractAgreementCOAmt SearchContract Agreement Change Order AmountDLR19_TSCurrency1019

Leave a Reply

Your email address will not be published. Required fields are marked *