Encumbrance Purchase Order Header (ENC10100)

azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance Purchase Order Header (ENC10100)

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

Product: Encumbrance Management (3258)
Series: Purchasing

Display Name: Encumbrance Purchase Order Header
Physical Name: ENC10100
Technical Name: ENC_PO

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMBER SearchPO NumberSTR17_POP_NumberString1817
2POSTATUS SearchPO StatusDDL_PO_StatusInteger20
3POTYPE SearchPO TypeDDL_POP_PO_TypeInteger20
4DOCDATE SearchDocument DateDTDate48
5REQDATE SearchRequired DateDATE_LDate40
6REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency1017
7SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
8VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Encumbrance Purchase Order Header'].VENDORID AS 'Encumbrance Purchase Order Header-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ENC10100 AS ['Encumbrance Purchase Order Header']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Encumbrance Purchase Order Header'].VENDORID = ['PM Vendor Master File'].VENDORID
9VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
10CREATDDT SearchCreated DateDTDate48
11MODIFDT SearchModified DateDTDate48
12COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Encumbrance Purchase Order Header'].COMMNTID AS 'Encumbrance Purchase Order Header-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       ENC10100 AS ['Encumbrance Purchase Order Header']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Encumbrance Purchase Order Header'].COMMNTID = ['Comment Master'].COMMNTID
13CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Encumbrance Purchase Order Header'].CURNCYID AS 'Encumbrance Purchase Order Header-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ENC10100 AS ['Encumbrance Purchase Order Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Encumbrance Purchase Order Header'].CURNCYID = ['Currency Setup'].CURNCYID
14CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Encumbrance Purchase Order Header'].CURRNIDX AS 'Encumbrance Purchase Order Header-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ENC10100 AS ['Encumbrance Purchase Order Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Encumbrance Purchase Order Header'].CURRNIDX = ['Currency Setup'].CURRNIDX
15RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Encumbrance Purchase Order Header'].RATETPID AS 'Encumbrance Purchase Order Header-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ENC10100 AS ['Encumbrance Purchase Order Header']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Encumbrance Purchase Order Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
16XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
17EXCHDATE SearchExchange DateDT_DateDate46
18HOLD SearchHoldCB_HoldBoolean20
19Revision_Number SearchRevision NumberINT4Integer24
20ORIGIN SearchOriginDDLInteger20
21DEX_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.

azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance Purchase Order Header (ENC10100)

Leave a Reply

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