Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC10100
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance Purchase Order Header
Physical Name: ENC10100
Technical Name: ENC_POSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PONUMBER 
PO Number String STR17_POP_Number 17 2 POSTATUS PO Status Integer DDL_PO_Status 0 3 POTYPE PO Type Integer DDL_POP_PO_Type 0 4 DOCDATE Document Date Date DT 8 5 REQDATE Required Date Date DATE_L 0 6 REMSUBTO Remaining Subtotal Currency DLR17_RBS0_UTR$ 17 7 SUBTOTAL Subtotal Currency DLR17_RBS0_STR$ 17 8 VENDORID Vendor ID String STR_15_Vendor_ID 15 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'].VENDORID9 VENDNAME Vendor Name String STR64_Vendor_Name 64 10 CREATDDT Created Date Date DT 8 11 MODIFDT Modified Date Date DT 8 12 COMMNTID Comment ID String STR15_Comment_ID 15 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'].COMMNTID13 CURNCYID Currency ID String STR15_Currency_ID 15 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'].CURNCYID14 CURRNIDX Currency Index Integer INT3 3 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'].CURRNIDX15 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 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'].RATETPID16 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 17 EXCHDATE Exchange Date Date DT_Date 6 18 HOLD Hold Boolean CB_Hold 0 19 Revision_Number Revision Number Integer INT4 4 20 ORIGIN Origin Integer DDL 0