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