GST PA PM Class MSTR (GST00111)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GST00111

Product: Project Accounting (258)
Series: Project

Display Name: GST PA PM Class MSTR
Physical Name: GST00111
Technical Name: GST_PA_PM_Class_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VNDCLSID SearchVendor Class IDSTR10_Class_IDString1210
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['GST PA PM Class MSTR'].VNDCLSID AS 'GST PA PM Class MSTR-Vendor Class ID'
       ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
       GST00111 AS ['GST PA PM Class MSTR']
INNER JOIN
       PM00100 AS ['PM Class Master File']
              ON
                     ['GST PA PM Class MSTR'].VNDCLSID = ['PM Class Master File'].VNDCLSID
2TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
3WithholdingType SearchWithholding TypeDDL_WithholdingTypeInteger20
4DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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