Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC10111
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance Purchase Order Line Changes
Physical Name: ENC10111
Technical Name: ENC_POLineChgSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PONUMBER 
PO Number String STR17_POP_Number 17 2 POLNENUM PO Line Number Long Integer LI_Sequence_Number 10 3 POLNESTA PO Line Status Integer DDL_PO_Line_Status 0 4 ENCBSTAT Encumbrance Status Integer Encumbrance Status 0 5 ENCMBAMT Encumbered Amount Currency DLR19_$S2 19 6 LIQUIDAT Liquidated Boolean Liquidated 0 7 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Encumbrance Purchase Order Line Changes'].ITEMNMBR AS 'Encumbrance Purchase Order Line Changes-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ENC10111 AS ['Encumbrance Purchase Order Line Changes']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Encumbrance Purchase Order Line Changes'].ITEMNMBR = ['Item Master'].ITEMNMBR8 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 Line Changes'].VENDORID AS 'Encumbrance Purchase Order Line Changes-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ENC10111 AS ['Encumbrance Purchase Order Line Changes']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Encumbrance Purchase Order Line Changes'].VENDORID = ['PM Vendor Master File'].VENDORID9 NONINVEN Non IV Integer INT1 1 10 INVINDX Inventory Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Encumbrance Purchase Order Line Changes'].INVINDX AS 'Encumbrance Purchase Order Line Changes-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ENC10111 AS ['Encumbrance Purchase Order Line Changes']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Encumbrance Purchase Order Line Changes'].INVINDX = ['Account Index Master'].ACTINDX11 YEAR1 Year Integer Year 4 12 PERIODID Period ID Integer INT3 3 13 UOFM U Of M String U_Of_M 8 14 UMQTYINB U Of M QTY In Base Currency DLR17_QTY_RBS0_STR 17 15 QTYORDER QTY Ordered Currency DLR17_QTY_RBS0_UTR 17 16 QTYCANCE QTY Canceled Currency DLR17_QTY_RBS0_UTR 17 17 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 18 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 19 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 20 TRXDATE TRX Date Date DT_Date 6 21 REQDATE Required Date Date DATE_L 0 22 DOCDATE Document Date Date DT 8 23 CRUSRID Created User ID String STR15_User_ID 15 24 CREATDDT Created Date Date DT 8 25 MDFUSRID Modified User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Encumbrance Purchase Order Line Changes'].MDFUSRID AS 'Encumbrance Purchase Order Line Changes-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ENC10111 AS ['Encumbrance Purchase Order Line Changes']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Encumbrance Purchase Order Line Changes'].MDFUSRID = ['Users Master'].USERID26 MODIFDT Modified Date Date DT 8 27 LINEORIGIN Line Origin Integer DDL_Line_Origin 0 28 POTYPE PO Type Integer DDL_POP_PO_Type 0 29 LineNumber LineNumber Integer INT 0 30 aaDimID aaDimID Long Integer aaLONG_INT 8 31 aaTrxDimID aaTrxDimID Long Integer aaLONG_INT 8 32 ProjNum Project Number String STR15_LBAU 15 33 CostCatID Cost Category ID String STR15_LBAU 15