Extender Inventory Transactions (EXT43600)

azurecurveProductsExtender (3107)ProjectExtender Inventory Transactions (EXT43600)

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

Product: Extender (3107)
Series: Project

Display Name: Extender Inventory Transactions
Physical Name: EXT43600
Technical Name: PT_Extender_Inventory

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_Inventory_ID SearchExtender Inventory IDSTR15_LBAUString1615
2Extender_Inventory_Desc SearchExtender Inventory DescriptionSTR64String6664
3Extender_Type SearchExtender TypeINT5Integer24
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString1615
5IVDOCTYP SearchIV Document TypeDDL_IV_Document_TypeInteger20
6Ext_IV_Batch_From SearchExt_IV_Batch_FromExtender Inventory Batch FromInteger20
7Ext_IV_Desc_From SearchExt_IV_Desc_FromExtender Inventory Description FromInteger20
8Ext_IV_Doc_From SearchExt_IV_Doc_FromExtender Inventory Document FromInteger20
9Ext_IV_From_LocationFrom SearchExt_IV_From_Location_FromExtender Inventory From Location FromInteger20
10Ext_IV_Item_From SearchExt_IV_Item_FromExtender Inventory Item FromInteger20
11Ext_IV_Qty_From SearchExt_IV_Qty_FromExtneder Inventory Quantity FromInteger20
12Ext_IV_To_Location_From SearchExt_IV_To_Location_FromExtender Inventory To Location FromInteger20
13Ext_IV_Unit_Cost_From SearchExt_IV_Unit_Cost_FromExtender Inventory Unit Cost FromInteger20
14Form_Field_Number_1 SearchForm Field Number[1]INT5Integer24
15Form_Field_Number_2 SearchForm Field Number[2]INT5Integer24
16Form_Field_Number_3 SearchForm Field Number[3]INT5Integer24
17Form_Field_Number_4 SearchForm Field Number[4]INT5Integer24
18Form_Field_Number_5 SearchForm Field Number[5]INT5Integer24
19Form_Field_Number_6 SearchForm Field Number[6]INT5Integer24
20Form_Field_Number_7 SearchForm Field Number[7]INT5Integer24
21Form_Field_Number_8 SearchForm Field Number[8]INT5Integer24
22Form_Field_Number_9 SearchForm Field Number[9]INT5Integer24
23Form_Field_Number_10 SearchForm Field Number[10]INT5Integer24
24Form_Field_Number_11 SearchForm Field Number[11]INT5Integer24
25Form_Field_Number_12 SearchForm Field Number[12]INT5Integer24
26Form_Field_Number_13 SearchForm Field Number[13]INT5Integer24
27Form_Field_Number_14 SearchForm Field Number[14]INT5Integer24
28Form_Field_Number_15 SearchForm Field Number[15]INT5Integer24
29Form_Field_Number_16 SearchForm Field Number[16]INT5Integer24
30Form_Field_Number_17 SearchForm Field Number[17]INT5Integer24
31Form_Field_Number_18 SearchForm Field Number[18]INT5Integer24
32Form_Field_Number_19 SearchForm Field Number[19]INT5Integer24
33Form_Field_Number_20 SearchForm Field Number[20]INT5Integer24
34NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Extender Inventory Transactions'].NOTEINDX AS 'Extender Inventory Transactions-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       EXT43600 AS ['Extender Inventory Transactions']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Extender Inventory Transactions'].NOTEINDX = ['Record Notes Master'].NOTEINDX
35MODIFDT SearchModified DateDTDate48
36IVDOCNBR SearchIV Document NumberSTR17_IV_Document_NumberString1817
37BACHNUMB SearchBatch NumberSTR15_LBAUString1615
38ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Extender Inventory Transactions'].ITEMNMBR AS 'Extender Inventory Transactions-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       EXT43600 AS ['Extender Inventory Transactions']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Extender Inventory Transactions'].ITEMNMBR = ['Item Master'].ITEMNMBR
39ITEMDESC SearchItem DescriptionSTR100String102100
40QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
41UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
42TRXLOCTN SearchTRX LocationSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Extender Inventory Transactions'].TRXLOCTN AS 'Extender Inventory Transactions-TRX Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       EXT43600 AS ['Extender Inventory Transactions']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Extender Inventory Transactions'].TRXLOCTN = ['Site Setup'].LOCNCODE
43TRNSTLOC SearchTransfer To LocationSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Extender Inventory Transactions'].TRNSTLOC AS 'Extender Inventory Transactions-Transfer To Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       EXT43600 AS ['Extender Inventory Transactions']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Extender Inventory Transactions'].TRNSTLOC = ['Site Setup'].LOCNCODE
44MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Extender Inventory Transactions'].MDFUSRID AS 'Extender Inventory Transactions-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT43600 AS ['Extender Inventory Transactions']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extender Inventory Transactions'].MDFUSRID = ['Users Master'].USERID
45CREATDDT SearchCreated DateDTDate48
46CRUSRID SearchCreated User IDSTR15_User_IDString1615
azurecurveProductsExtender (3107)ProjectExtender Inventory Transactions (EXT43600)

Leave a Reply

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