Extender POP (EXT43500)

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

Product: Extender (3107)
Series: Project

Display Name: Extender POP
Physical Name: EXT43500
Technical Name: PT_Extender_POP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_POP_ID SearchExtender POP IDSTR15_LBAUString1615
2Extender_POP_Description SearchExtender POP DescriptionSTR64String6664
3Extender_Type SearchExtender TypeINT5Integer24
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString1615
5Ext_POP_PO_Number_From SearchExt_POP_PO_Number_FromExtender POP PO Number FromInteger20
6Ext_POP_Creditor_From SearchExt_POP_Creditor_FromExtender POP Creditor FromInteger20
7Ext_POP_Buyer_From SearchExt_POP_Buyer_FromExtender POP Buyer FromInteger20
8Ext_POP_Item_From SearchExt_POP_Item_FromExtender POP Item FromInteger20
9Ext_POP_UofM_From SearchExt_POP_UofM_FromExtender POP UofM FromInteger20
10Ext_POP_Quantity_From SearchExt_POP_Quantity_FromExtender POP Quantity FromInteger20
11Ext_POP_Unit_Cost SearchExt_POP_Unit_Cost_FromExtender POP Unit Cost FromInteger20
12Ext_POP_Site_From SearchExt_POP_Site_FromExtender POP Site FromInteger20
13Ext_POP_Freight_From SearchExt_POP_Freight_FromExtender POP Freight FromInteger20
14Ext_POP_Misc_From SearchExt_POP_Misc_FromExtender POP Misc FromInteger20
15Ext_POP_Creditor_Name SearchExt_POP_Creditor_Name_FromExtender POP Creditor Name FromInteger20
16Ext_POP_Purchase_Address SearchExt_POP_Purchase_Address_FromExtender POP Purchase Address FromInteger20
17Ext_POP_Bill_Address SearchExt_POP_Bill_Address_FromExtender POP Company Address FromInteger20
18Ext_POP_Ship_Address SearchExt_POP_Ship_Address_FromExtender POP Company Address FromInteger20
19Ext_POP_Shipping_Method SearchExt_POP_Shipping_Method_FromExtender POP Shipping Method FromInteger20
20Ext_POP_Item_Description SearchExt_POP_Item_Description_FromExtender POP Item Description FromInteger20
21Ext_POP_Requested_From SearchExt_POP_Requested_FromExtender POP Requested FromInteger20
22Ext_POP_Comment_From SearchExt_POP_Comment_FromExtender POP Comment FromInteger20
23Minimum_Freight_Amount SearchMinimum Freight AmountDollar19Currency1019
24Minimum_Misc_Amount SearchMinimum Misc AmountDollar19Currency1019
25Maximum_Freight_Amount SearchMaximum Freight AmountDollar19Currency1019
26Maximum_Misc_Amount SearchMaximum Misc AmountDollar19Currency1019
27PONUMBER SearchPO NumberSTR17_POP_NumberString1817
28VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Extender POP'].VENDORID AS 'Extender POP-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Extender POP'].VENDORID = ['PM Vendor Master File'].VENDORID
29BUYERID SearchBuyer IDSTR15_User_IDString1615
30ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Extender POP'].ITEMNMBR AS 'Extender POP-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Extender POP'].ITEMNMBR = ['Item Master'].ITEMNMBR
31QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
32UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
33LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Extender POP'].LOCNCODE AS 'Extender POP-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Extender POP'].LOCNCODE = ['Site Setup'].LOCNCODE
34FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
35Freight_Percentage SearchFreight PercentageINT5_%2Integer25
36MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
37Misc_Percentage SearchMisc PercentageINT5_%2Integer25
38VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
39VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['Extender POP'].VADCDPAD AS 'Extender POP-Vendor Address Code - Purchase Address'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['Extender POP'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
              AND
                     ['Extender POP'].VENDORID = ['PM Address MSTR'].VENDORID
40Extender_POP_Bill_Addres SearchExtender POP Bill AddressSTR15_Location_IDString1615
41Extender_POP_Ship_Addres SearchExtender POP Ship AddressSTR15_Location_IDString1615
42SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Extender POP'].SHIPMTHD AS 'Extender POP-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Extender POP'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
43ITEMDESC SearchItem DescriptionSTR100String102100
44REQSTDBY SearchRequested BySTR20_LBString2220
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Extender POP'].REQSTDBY AS 'Extender POP-Requested By'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extender POP'].REQSTDBY = ['Users Master'].USERID
45COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Extender POP'].COMMNTID AS 'Extender POP-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Extender POP'].COMMNTID = ['Comment Master'].COMMNTID
46POP_Field_Numbers_1 SearchPOP Field Numbers[1]INT5Integer24
47POP_Field_Numbers_2 SearchPOP Field Numbers[2]INT5Integer24
48POP_Field_Numbers_3 SearchPOP Field Numbers[3]INT5Integer24
49POP_Field_Numbers_4 SearchPOP Field Numbers[4]INT5Integer24
50POP_Field_Numbers_5 SearchPOP Field Numbers[5]INT5Integer24
51POP_Field_Numbers_6 SearchPOP Field Numbers[6]INT5Integer24
52POP_Field_Numbers_7 SearchPOP Field Numbers[7]INT5Integer24
53POP_Field_Numbers_8 SearchPOP Field Numbers[8]INT5Integer24
54POP_Field_Numbers_9 SearchPOP Field Numbers[9]INT5Integer24
55POP_Field_Numbers_10 SearchPOP Field Numbers[10]INT5Integer24
56POP_Field_Numbers_11 SearchPOP Field Numbers[11]INT5Integer24
57POP_Field_Numbers_12 SearchPOP Field Numbers[12]INT5Integer24
58POP_Field_Numbers_13 SearchPOP Field Numbers[13]INT5Integer24
59POP_Field_Numbers_14 SearchPOP Field Numbers[14]INT5Integer24
60POP_Field_Numbers_15 SearchPOP Field Numbers[15]INT5Integer24
61POP_Field_Numbers_16 SearchPOP Field Numbers[16]INT5Integer24
62POP_Field_Numbers_17 SearchPOP Field Numbers[17]INT5Integer24
63POP_Field_Numbers_18 SearchPOP Field Numbers[18]INT5Integer24
64POP_Field_Numbers_19 SearchPOP Field Numbers[19]INT5Integer24
65POP_Field_Numbers_20 SearchPOP Field Numbers[20]INT5Integer24
66POP_Field_Numbers_21 SearchPOP Field Numbers[21]INT5Integer24
67POP_Field_Numbers_22 SearchPOP Field Numbers[22]INT5Integer24
68POP_Field_Numbers_23 SearchPOP Field Numbers[23]INT5Integer24
69POP_Field_Numbers_24 SearchPOP Field Numbers[24]INT5Integer24
70POP_Field_Numbers_25 SearchPOP Field Numbers[25]INT5Integer24
71POP_Field_Numbers_26 SearchPOP Field Numbers[26]INT5Integer24
72POP_Field_Numbers_27 SearchPOP Field Numbers[27]INT5Integer24
73POP_Field_Numbers_28 SearchPOP Field Numbers[28]INT5Integer24
74POP_Field_Numbers_29 SearchPOP Field Numbers[29]INT5Integer24
75POP_Field_Numbers_30 SearchPOP Field Numbers[30]INT5Integer24
76NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Extender POP'].NOTEINDX AS 'Extender POP-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Extender POP'].NOTEINDX = ['Record Notes Master'].NOTEINDX
77MODIFDT SearchModified DateDTDate48
78MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Extender POP'].MDFUSRID AS 'Extender POP-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT43500 AS ['Extender POP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extender POP'].MDFUSRID = ['Users Master'].USERID
79CREATDDT SearchCreated DateDTDate48
80CRUSRID SearchCreated User IDSTR15_User_IDString1615
81Ext_Date_From SearchExt_Date_FromExtender Date FromInteger20

Leave a Reply

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