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