PA PO Distribution Work (PA10705)

azurecurveProductsProject Accounting (258)ProjectPA PO Distribution Work (PA10705)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA PO Distribution Work
Physical Name: PA10705
Technical Name: PA_PO_Distribution

Group Display Name: PA Purchasing Transactions
Group Technical Name: PA Purchasing Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PAVIDN SearchPA Vendor Invoice Document No.STR17_LBAUString1817
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
3ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PA PO Distribution Work'].ACTINDX AS 'PA PO Distribution Work-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PA10705 AS ['PA PO Distribution Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PA PO Distribution Work'].ACTINDX = ['Account Index Master'].ACTINDX
4DISTTYPE SearchDistribution TypeDDLInteger20
5XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
6VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PA PO Distribution Work'].VENDORID AS 'PA PO Distribution Work-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PA10705 AS ['PA PO Distribution Work']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PA PO Distribution Work'].VENDORID = ['PM Vendor Master File'].VENDORID
7CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA PO Distribution Work'].CURNCYID AS 'PA PO Distribution Work-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PA10705 AS ['PA PO Distribution Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA PO Distribution Work'].CURNCYID = ['Currency Setup'].CURNCYID
8CNTRLTYP SearchControl TypeINT1Integer21
9DEX_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.

azurecurveProductsProject Accounting (258)ProjectPA PO Distribution Work (PA10705)

Leave a Reply

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