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 TypeLength
1VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

       ['JC_Subs_Status_VIEW'].VENDORID AS 'JC_Subs_Status_VIEW-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
       JC90500 AS ['JC_Subs_Status_VIEW']
       PM00200 AS ['PM Vendor Master File']
                     ['JC_Subs_Status_VIEW'].VENDORID = ['PM Vendor Master File'].VENDORID
2VENDNAME SearchVendor NameSTR64_Vendor_NameString64
3Retention_Withheld_TTD SearchRetention Withheld TTDDLR19_TSCurrency19
4Apply_Doc_Paid_TTD SearchApply Doc Paid TTDDLR19_TSCurrency19
5Orig_Contract_Amount SearchOriginal Contract AmountDLR19_TSCurrency19
6Change_Orders_TTD SearchChange Orders TTDDLR19_TSCurrency19
7Contract_to_Date SearchContract to DateDLR14_TSCurrency14
8Vendor_Invoices_TTD SearchVendor Invoices TTDDLR19_TSCurrency19
9Actual_Units_TTD SearchActual Units TTDDLR14_TSCurrency14
10Total_Invoices_Due SearchTotal Invoices DueDLR19_TSCurrency19
11HOLD SearchHoldCB_HoldBoolean0
12ContractAgreementAmount SearchContract Agreement AmountDLR19_TSCurrency19
13ContractAgreementCOAmt SearchContract Agreement Change Order AmountDLR19_TSCurrency19

Leave a Reply

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