Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENCAA10110
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance AA Purchase Order Line
Physical Name: ENCAA10110
Technical Name: ENC_aaPOLineSeq 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 aaSubLedgerHdrID aaSubLedgerHdrID Long Integer aaLONG_INT 8 4 aaSubLedgerDistID aaSubLedgerDistID Long Integer aaLONG_INT 8 5 aaSubLedgerAssignID aaSubLedgerAssignID Long Integer aaLONG_INT 8 6 aaTrxDimID aaTrxDimID Long Integer aaLONG_INT 8 7 aaTrxDimCodeID aaTrxDimCodeID Long Integer aaLONG_INT 8 8 aaCodeSequence aaCodeSequence Long Integer aaLONG_INT 8 9 POLNESTA PO Line Status Integer DDL_PO_Line_Status 0 10 ENCBSTAT Encumbrance Status Integer Encumbrance Status 0 11 ENCMBAMT Encumbered Amount Currency DLR19_$S2 19 12 LIQUDAMT Liquidated Amount Currency DLR19_$S2 19 13 Balance Balance Currency DLR19_$S2 19 14 aaAssignedPercent aaAssignedPercent Long Integer aaPercent32 5 15 LIQUIDAT Liquidated Boolean Liquidated 0 16 INVINDX Inventory Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Encumbrance AA Purchase Order Line'].INVINDX AS 'Encumbrance AA Purchase Order Line-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ENCAA10110 AS ['Encumbrance AA Purchase Order Line']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Encumbrance AA Purchase Order Line'].INVINDX = ['Account Index Master'].ACTINDX17 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Encumbrance AA Purchase Order Line'].ITEMNMBR AS 'Encumbrance AA Purchase Order Line-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ENCAA10110 AS ['Encumbrance AA Purchase Order Line']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Encumbrance AA Purchase Order Line'].ITEMNMBR = ['Item Master'].ITEMNMBR18 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Encumbrance AA Purchase Order Line'].VENDORID AS 'Encumbrance AA Purchase Order Line-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ENCAA10110 AS ['Encumbrance AA Purchase Order Line']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Encumbrance AA Purchase Order Line'].VENDORID = ['PM Vendor Master File'].VENDORID19 UOFM U Of M String U_Of_M 8 20 UMQTYINB U Of M QTY In Base Currency DLR17_QTY_RBS0_STR 17 21 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 22 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 23 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 24 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 25 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 26 YEAR1 Year Integer Year 4 27 PERIODID Period ID Integer INT3 3 28 REQDATE Required Date Date DATE_L 0 29 ENCBDATE Encumbered Date Date DT 8 30 CRUSRID Created User ID String STR15_User_ID 15 31 CREATDDT Created Date Date DT 8 32 MDFUSRID Modified User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Encumbrance AA Purchase Order Line'].MDFUSRID AS 'Encumbrance AA Purchase Order Line-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ENCAA10110 AS ['Encumbrance AA Purchase Order Line']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Encumbrance AA Purchase Order Line'].MDFUSRID = ['Users Master'].USERID33 MODIFDT Modified Date Date DT 8 34 DOCDATE Document Date Date DT 8 35 LINEORIGIN Line Origin Integer DDL_Line_Origin 0 36 POTYPE PO Type Integer DDL_POP_PO_Type 0 37 LineNumber LineNumber Integer INT 0 38 ProjNum Project Number String STR15_LBAU 15 39 CostCatID Cost Category ID String STR15_LBAU 15