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_InventorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Inventory_ID 
Extender Inventory ID STR15_LBAU String 15 2 Extender_Inventory_Desc Extender Inventory Description STR64 String 64 3 Extender_Type Extender Type INT5 Integer 4 4 Extender_Form_ID Extender Form ID STR15_LBAU String 15 5 IVDOCTYP IV Document Type DDL_IV_Document_Type Integer 0 6 Ext_IV_Batch_From Ext_IV_Batch_From Extender Inventory Batch From Integer 0 7 Ext_IV_Desc_From Ext_IV_Desc_From Extender Inventory Description From Integer 0 8 Ext_IV_Doc_From Ext_IV_Doc_From Extender Inventory Document From Integer 0 9 Ext_IV_From_LocationFrom Ext_IV_From_Location_From Extender Inventory From Location From Integer 0 10 Ext_IV_Item_From Ext_IV_Item_From Extender Inventory Item From Integer 0 11 Ext_IV_Qty_From Ext_IV_Qty_From Extneder Inventory Quantity From Integer 0 12 Ext_IV_To_Location_From Ext_IV_To_Location_From Extender Inventory To Location From Integer 0 13 Ext_IV_Unit_Cost_From Ext_IV_Unit_Cost_From Extender Inventory Unit Cost From Integer 0 14 Form_Field_Number_1 Form Field Number[1] INT5 Integer 4 15 Form_Field_Number_2 Form Field Number[2] INT5 Integer 4 16 Form_Field_Number_3 Form Field Number[3] INT5 Integer 4 17 Form_Field_Number_4 Form Field Number[4] INT5 Integer 4 18 Form_Field_Number_5 Form Field Number[5] INT5 Integer 4 19 Form_Field_Number_6 Form Field Number[6] INT5 Integer 4 20 Form_Field_Number_7 Form Field Number[7] INT5 Integer 4 21 Form_Field_Number_8 Form Field Number[8] INT5 Integer 4 22 Form_Field_Number_9 Form Field Number[9] INT5 Integer 4 23 Form_Field_Number_10 Form Field Number[10] INT5 Integer 4 24 Form_Field_Number_11 Form Field Number[11] INT5 Integer 4 25 Form_Field_Number_12 Form Field Number[12] INT5 Integer 4 26 Form_Field_Number_13 Form Field Number[13] INT5 Integer 4 27 Form_Field_Number_14 Form Field Number[14] INT5 Integer 4 28 Form_Field_Number_15 Form Field Number[15] INT5 Integer 4 29 Form_Field_Number_16 Form Field Number[16] INT5 Integer 4 30 Form_Field_Number_17 Form Field Number[17] INT5 Integer 4 31 Form_Field_Number_18 Form Field Number[18] INT5 Integer 4 32 Form_Field_Number_19 Form Field Number[19] INT5 Integer 4 33 Form_Field_Number_20 Form Field Number[20] INT5 Integer 4 34 NOTEINDX Note Index DLR14 Currency 14 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'].NOTEINDX35 MODIFDT Modified Date DT Date 8 36 IVDOCNBR IV Document Number STR17_IV_Document_Number String 17 37 BACHNUMB Batch Number STR15_LBAU String 15 38 ITEMNMBR Item Number STR30_Item_Number String 30 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'].ITEMNMBR39 ITEMDESC Item Description STR100 String 100 40 QUANTITY QTY DLR17_QTY_RBS0_STR Currency 17 41 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 42 TRXLOCTN TRX Location STR10_Location_Code String 10 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'].LOCNCODE43 TRNSTLOC Transfer To Location STR10_Location_Code String 10 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'].LOCNCODE44 MDFUSRID Modified User ID STR15 String 15 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'].USERID45 CREATDDT Created Date DT Date 8 46 CRUSRID Created User ID STR15_User_ID String 15