Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00701V
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: IV Transfer Order Line View
Physical Name: IV00701V
Technical Name: ivTransferOrderLineViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ORDDOCID 
Order Document ID String STR15_LBAU 15 2 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 3 Status Status Integer INT 0 4 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['IV Transfer Order Line View'].ITEMNMBR AS 'IV Transfer Order Line View-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV00701V AS ['IV Transfer Order Line View']
INNER JOIN
IV00101 AS ['Item Master']
ON
['IV Transfer Order Line View'].ITEMNMBR = ['Item Master'].ITEMNMBR5 DSCRIPTN Description String STR30 30 6 UOFM U Of M String U_Of_M 8 The unit of measure. The value in this field must exist in Inventory. 7 UMQTYINB U Of M QTY In Base Currency DLR17_QTY_RBS0_STR 17 The quantity of the base unit of measure that is equivalent to one of the units of measure being referenced. 8 QTYFROM QTYFrom Currency DLR17_QTY_RBS0_UTR 17 9 QTYFULFI QTY Fulfilled Currency DLR17_QTY_RBS0_UTR 17 10 QTYSHPPD QTY Shipped Currency DLR17_QTY_RBS0_UTR 17 11 QTYREMAI QTY Remaining Currency DLR17_QTY_RBS0_UTR 17 12 QTYRECVD QTY Received Currency DLR17_QTY_RBS0_UTR 17 13 TRXLOCTN TRX Location String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['IV Transfer Order Line View'].TRXLOCTN AS 'IV Transfer Order Line View-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV00701V AS ['IV Transfer Order Line View']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['IV Transfer Order Line View'].TRXLOCTN = ['Site Setup'].LOCNCODE14 VIALOCN Via Location String STR10_Location_Code 10 15 TRNSTLOC Transfer To Location String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['IV Transfer Order Line View'].TRNSTLOC AS 'IV Transfer Order Line View-Transfer To Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV00701V AS ['IV Transfer Order Line View']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['IV Transfer Order Line View'].TRNSTLOC = ['Site Setup'].LOCNCODE16 TRFQTYTY Transfer From QTY Type Integer DDL_QTY_Type 0 17 TRTQTYTY Transfer To QTY Type Integer DDL_QTY_Type 0 18 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 19 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 20 Landed_Cost_Group_ID Landed Cost Group ID String STR15_LBAU 15