Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENCAA10110
Product: Encumbrance Management (3258)
Series: Purchasing
Display Name: Encumbrance AA Purchase Order Line DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: ENCAA10110
Technical Name: ENC_aaPOLineSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 PONUMBER PO Number STR17_POP_Number String 18 17 2 POLNENUM PO Line Number LI_Sequence_Number Long Integer 4 10 3 aaSubLedgerHdrID aaSubLedgerHdrID aaLONG_INT Long Integer 4 8 4 aaSubLedgerDistID aaSubLedgerDistID aaLONG_INT Long Integer 4 8 5 aaSubLedgerAssignID aaSubLedgerAssignID aaLONG_INT Long Integer 4 8 6 aaTrxDimID aaTrxDimID aaLONG_INT Long Integer 4 8 7 aaTrxDimCodeID aaTrxDimCodeID aaLONG_INT Long Integer 4 8 8 aaCodeSequence aaCodeSequence aaLONG_INT Long Integer 4 8 9 POLNESTA PO Line Status DDL_PO_Line_Status Integer 2 0 10 ENCBSTAT Encumbrance Status Encumbrance Status Integer 2 0 11 ENCMBAMT Encumbered Amount DLR19_$S2 Currency 10 19 12 LIQUDAMT Liquidated Amount DLR19_$S2 Currency 10 19 13 Balance Balance DLR19_$S2 Currency 10 19 14 aaAssignedPercent aaAssignedPercent aaPercent32 Long Integer 4 5 15 LIQUIDAT Liquidated Liquidated Boolean 2 0 16 INVINDX Inventory Index LI_14 Long Integer 4 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'].ACTINDX
17 ITEMNMBR Item Number STR30_Item_Number String 32 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'].ITEMNMBR
18 VENDORID Vendor ID STR_15_Vendor_ID String 16 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'].VENDORID
19 UOFM U Of M U_Of_M String 10 8 20 UMQTYINB U Of M QTY In Base DLR17_QTY_RBS0_STR Currency 10 17 21 QUANTITY QTY DLR17_QTY_RBS0_STR Currency 10 17 22 DECPLCUR Decimal Places Currency DDL_Decimal_Places_Dollars Integer 2 0 23 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 2 0 24 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 10 17 25 EXTDCOST Extended Cost DLR17_RBS0_UTR$ Currency 10 17 26 YEAR1 Year Year Integer 2 4 27 PERIODID Period ID INT3 Integer 2 3 28 REQDATE Required Date DATE_L Date 4 0 29 ENCBDATE Encumbered Date DT Date 4 8 30 CRUSRID Created User ID STR15_User_ID String 16 15 31 CREATDDT Created Date DT Date 4 8 32 MDFUSRID Modified User ID STR15 String 16 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'].USERID
33 MODIFDT Modified Date DT Date 4 8 34 DOCDATE Document Date DT Date 4 8 35 LINEORIGIN Line Origin DDL_Line_Origin Integer 2 0 36 POTYPE PO Type DDL_POP_PO_Type Integer 2 0 37 LineNumber LineNumber INT Integer 2 0 38 ProjNum Project Number STR15_LBAU String 16 15 39 CostCatID Cost Category ID STR15_LBAU String 16 15 40 DEX_ROW_ID int int 10 10