EXP_SalesOrdersNotLinked (EXPV1000)

azurecurveProductsManufacturing (346)3rd PartyEXP_SalesOrdersNotLinked (EXPV1000)

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

Product: Manufacturing (346)
Series:

Display Name: EXP_SalesOrdersNotLinked
Physical Name: EXPV1000
Technical Name: EXP_SalesOrdersNotLinked

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
2SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
3ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['EXP_SalesOrdersNotLinked'].ITEMNMBR AS 'EXP_SalesOrdersNotLinked-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       EXPV1000 AS ['EXP_SalesOrdersNotLinked']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['EXP_SalesOrdersNotLinked'].ITEMNMBR = ['Item Master'].ITEMNMBR
4UOFM SearchU Of MStringU_Of_M8
5QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
6QTYBACKO SearchQTY BackorderedCurrencyDLR17_QTY_RBS0_UTR17
7ITEMFULFILLMETHOD SearchItem Fulfillment MethodIntegerItem Fulfillment Method0
8ReqShipDate SearchRequested Ship DateDateDT8
9CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['EXP_SalesOrdersNotLinked'].CUSTNMBR AS 'EXP_SalesOrdersNotLinked-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       EXPV1000 AS ['EXP_SalesOrdersNotLinked']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['EXP_SalesOrdersNotLinked'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
10ITEMDESC SearchItem DescriptionStringSTR100100
11LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['EXP_SalesOrdersNotLinked'].LOCNCODE AS 'EXP_SalesOrdersNotLinked-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       EXPV1000 AS ['EXP_SalesOrdersNotLinked']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['EXP_SalesOrdersNotLinked'].LOCNCODE = ['Site Setup'].LOCNCODE
12MAKEBUYCODE_I SearchMake/Buy_CodeIntegerDDL_Make_Buy_Code0
13AVERAGEORDQTY_I SearchAverage ORD QTYCurrencyDLR17_QTY_RBS0_UTR17
14ITEMSTATUS_I SearchItem StatusIntegerDDL_Item_Status0
15EFFECTIVEDATE_I SearchEffective Date0DateDT8
16CUSTPRIORITY SearchCustomer PriorityIntegerDDL_CustomerPriority0
17CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
18LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
19CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
azurecurveProductsManufacturing (346)3rd PartyEXP_SalesOrdersNotLinked (EXPV1000)

Leave a Reply

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