Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENCAUDIT10
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance Audit List Temp
Physical Name: ENCAUDIT10
Technical Name: ENC_AuditList_TempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Encumbrance Audit List Temp'].USERID AS 'Encumbrance Audit List Temp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ENCAUDIT10 AS ['Encumbrance Audit List Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Encumbrance Audit List Temp'].USERID = ['Users Master'].USERID
2 WINDOW Window Integer INT 0 3 PONUMBER PO Number String STR17_POP_Number 17 4 POLNENUM PO Line Number Long Integer LI_Sequence_Number 10 5 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 6 POPRCTNM POP Receipt Number String STR17_POP_Number 17 7 RCPTLNNM Receipt Line Number Long Integer LI_Sequence_Number 10 8 POPTYPE POP Type Integer DDL_POP_Type 0 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 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Encumbrance Audit List Temp'].ITEMNMBR AS 'Encumbrance Audit List Temp-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ENCAUDIT10 AS ['Encumbrance Audit List Temp']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Encumbrance Audit List Temp'].ITEMNMBR = ['Item Master'].ITEMNMBR
14 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Encumbrance Audit List Temp'].VENDORID AS 'Encumbrance Audit List Temp-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ENCAUDIT10 AS ['Encumbrance Audit List Temp']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Encumbrance Audit List Temp'].VENDORID = ['PM Vendor Master File'].VENDORID
15 INVINDX Inventory Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Encumbrance Audit List Temp'].INVINDX AS 'Encumbrance Audit List Temp-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ENCAUDIT10 AS ['Encumbrance Audit List Temp']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Encumbrance Audit List Temp'].INVINDX = ['Account Index Master'].ACTINDX
16 ACTNUMBR_1 Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 17 ACTNUMBR_2 Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 18 ACTNUMBR_3 Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 19 ACTNUMBR_4 Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 20 ACTNUMBR_5 Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 21 ACTNUMBR_6 Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 22 ACTNUMBR_7 Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 23 ACTNUMBR_8 Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 24 ACTNUMBR_9 Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 25 ACTNUMBR_10 Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 26 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 27 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 28 REQDATE Required Date Date DATE_L 0 29 TRXDATE TRX Date Date DT_Date 6 30 CRUSRID Created User ID String STR15_User_ID 15 31 QTYORDER QTY Ordered Currency DLR17_QTY_RBS0_UTR 17 32 QTYCANCE QTY Canceled Currency DLR17_QTY_RBS0_UTR 17 33 QTYSHPPD QTY Shipped Currency DLR17_QTY_RBS0_UTR 17 34 QTYINVCD QTY Invoiced Currency DLR17_QTY_RBS0_UTR 17 35 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 36 UOFM U Of M String U_Of_M 8 37 LINEORIGIN Line Origin Integer DDL_Line_Origin 0 38 POTYPE PO Type Integer DDL_POP_PO_Type 0 39 LineNumber LineNumber Integer INT 0 40 aaSubLedgerHdrID aaSubLedgerHdrID Long Integer aaLONG_INT 8 41 aaSubLedgerDistID aaSubLedgerDistID Long Integer aaLONG_INT 8 42 aaSubLedgerAssignID aaSubLedgerAssignID Long Integer aaLONG_INT 8 43 aaTrxDimID aaTrxDimID Long Integer aaLONG_INT 8 44 aaTrxDimCodeID aaTrxDimCodeID Long Integer aaLONG_INT 8 45 ERRDESCR Error Description String STR130 130 46 ORD Ord Long Integer LI_Sequence_Number 10 47 aaCodeSequence aaCodeSequence Long Integer aaLONG_INT 8 48 aaBudgetLevel aaBudgetLevel Text TX500 500