Encumbrance Purchase Orders (ENC10119)

azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance Purchase Orders (ENC10119)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC10119

Product: Encumbrance Management (3258)
Series:

Display Name: Encumbrance Purchase Orders
Physical Name: ENC10119
Technical Name: ENC_POList

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1HISTORY SearchHistoryBooleanCB_History0
2PONUMBER SearchPO NumberStringSTR17_POP_Number17
3ORD SearchOrdLong IntegerLI_Sequence_Number10
4POLNESTA SearchPO Line StatusIntegerDDL_PO_Line_Status0
5Status SearchStatusIntegerINT0
6POTYPE SearchPO TypeIntegerDDL_POP_PO_Type0
7QTYORDER SearchQTY OrderedCurrencyDLR17_QTY_RBS0_UTR17
8QTYCANCE SearchQTY CanceledCurrencyDLR17_QTY_RBS0_UTR17
9UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
10EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
11REQDATE SearchRequired DateDateDATE_L0
12YEAR1 SearchYearIntegerYear4
13PERIODID SearchPeriod IDIntegerINT33
14INVINDX SearchInventory IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Encumbrance Purchase Orders'].INVINDX AS 'Encumbrance Purchase Orders-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ENC10119 AS ['Encumbrance Purchase Orders']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Encumbrance Purchase Orders'].INVINDX = ['Account Index Master'].ACTINDX
15ACCTTYPE SearchAccount TypeIntegerDDL_Account_Type0
16ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Encumbrance Purchase Orders'].ITEMNMBR AS 'Encumbrance Purchase Orders-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ENC10119 AS ['Encumbrance Purchase Orders']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Encumbrance Purchase Orders'].ITEMNMBR = ['Item Master'].ITEMNMBR
17ITEMDESC SearchItem DescriptionStringSTR100100
18VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Encumbrance Purchase Orders'].VENDORID AS 'Encumbrance Purchase Orders-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ENC10119 AS ['Encumbrance Purchase Orders']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Encumbrance Purchase Orders'].VENDORID = ['PM Vendor Master File'].VENDORID
19ACTNUMST SearchAccount Number StringStringSTR128_LBU128
20LineNumber SearchLineNumberIntegerINT0
21LINEORIGIN SearchLine OriginIntegerDDL_Line_Origin0
azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance Purchase Orders (ENC10119)

Leave a Reply

Your email address will not be published. Required fields are marked *