Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00700V
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Two Step Transfer View
Physical Name: IV00700V
Technical Name: ivTransferOrderViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ORDDOCID 
Order Document ID String STR15_LBAU 15 2 ORDRDATE Order Date Date DT 8 3 PRMDATE Promised Date Date DATE_L 0 4 Status Status Integer INT 0 5 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['Two Step Transfer View'].SHIPMTHD AS 'Two Step Transfer View-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
IV00700V AS ['Two Step Transfer View']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Two Step Transfer View'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD6 TRXLOCTN TRX Location String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Two Step Transfer View'].TRXLOCTN AS 'Two Step Transfer View-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV00700V AS ['Two Step Transfer View']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Two Step Transfer View'].TRXLOCTN = ['Site Setup'].LOCNCODE7 VIALOCN Via Location String STR10_Location_Code 10 8 TRNSTLOC Transfer To Location String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Two Step Transfer View'].TRNSTLOC AS 'Two Step Transfer View-Transfer To Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV00700V AS ['Two Step Transfer View']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Two Step Transfer View'].TRNSTLOC = ['Site Setup'].LOCNCODE9 CUSTNAME Customer Name String STR64_Customer_Name 64 10 ADDRESS1 Address 1 String STR60 60 11 ADDRESS2 Address 2 String STR60 60 12 ADDRESS3 Address 3 String STR60 60 13 CITY City String STR35 35 14 STATE State String STR30_State 29 15 ZIPCODE Zip Code String STR10 10 16 COUNTRY Country String STR60 60 17 EMPLOYID Employee ID String STR15_Employee_ID 15 18 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Two Step Transfer View'].NOTEINDX AS 'Two Step Transfer View-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
IV00700V AS ['Two Step Transfer View']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Two Step Transfer View'].NOTEINDX = ['Record Notes Master'].NOTEINDX