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 TypeLength
1Extender_Inventory_ID SearchExtender Inventory IDSTR15_LBAUString15
2Extender_Inventory_Desc SearchExtender Inventory DescriptionSTR64String64
3Extender_Type SearchExtender TypeINT5Integer4
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString15
5IVDOCTYP SearchIV Document TypeDDL_IV_Document_TypeInteger0
6Ext_IV_Batch_From SearchExt_IV_Batch_FromExtender Inventory Batch FromInteger0
7Ext_IV_Desc_From SearchExt_IV_Desc_FromExtender Inventory Description FromInteger0
8Ext_IV_Doc_From SearchExt_IV_Doc_FromExtender Inventory Document FromInteger0
9Ext_IV_From_LocationFrom SearchExt_IV_From_Location_FromExtender Inventory From Location FromInteger0
10Ext_IV_Item_From SearchExt_IV_Item_FromExtender Inventory Item FromInteger0
11Ext_IV_Qty_From SearchExt_IV_Qty_FromExtneder Inventory Quantity FromInteger0
12Ext_IV_To_Location_From SearchExt_IV_To_Location_FromExtender Inventory To Location FromInteger0
13Ext_IV_Unit_Cost_From SearchExt_IV_Unit_Cost_FromExtender Inventory Unit Cost FromInteger0
14Form_Field_Number_1 SearchForm Field Number[1]INT5Integer4
15Form_Field_Number_2 SearchForm Field Number[2]INT5Integer4
16Form_Field_Number_3 SearchForm Field Number[3]INT5Integer4
17Form_Field_Number_4 SearchForm Field Number[4]INT5Integer4
18Form_Field_Number_5 SearchForm Field Number[5]INT5Integer4
19Form_Field_Number_6 SearchForm Field Number[6]INT5Integer4
20Form_Field_Number_7 SearchForm Field Number[7]INT5Integer4
21Form_Field_Number_8 SearchForm Field Number[8]INT5Integer4
22Form_Field_Number_9 SearchForm Field Number[9]INT5Integer4
23Form_Field_Number_10 SearchForm Field Number[10]INT5Integer4
24Form_Field_Number_11 SearchForm Field Number[11]INT5Integer4
25Form_Field_Number_12 SearchForm Field Number[12]INT5Integer4
26Form_Field_Number_13 SearchForm Field Number[13]INT5Integer4
27Form_Field_Number_14 SearchForm Field Number[14]INT5Integer4
28Form_Field_Number_15 SearchForm Field Number[15]INT5Integer4
29Form_Field_Number_16 SearchForm Field Number[16]INT5Integer4
30Form_Field_Number_17 SearchForm Field Number[17]INT5Integer4
31Form_Field_Number_18 SearchForm Field Number[18]INT5Integer4
32Form_Field_Number_19 SearchForm Field Number[19]INT5Integer4
33Form_Field_Number_20 SearchForm Field Number[20]INT5Integer4
34NOTEINDX SearchNote IndexDLR14Currency14
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 DateDTDate8
36IVDOCNBR SearchIV Document NumberSTR17_IV_Document_NumberString17
37BACHNUMB SearchBatch NumberSTR15_LBAUString15
38ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 DescriptionSTR100String100
40QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency17
41UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
42TRXLOCTN SearchTRX LocationSTR10_Location_CodeString10
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_CodeString10
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 IDSTR15String15
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 DateDTDate8
46CRUSRID SearchCreated User IDSTR15_User_IDString15
azurecurveProductsExtender (3107)ProjectExtender Inventory Transactions (EXT43600)

Leave a Reply

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