Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ISC_OnlineOrderExtra
Product: Purchase Order Management (8298)
Series: Sales
Display Name: ISC_OnlineOrderExtra
Physical Name: ISC_OnlineOrderExtra
Technical Name: ISC_OnlineOrderExtraSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ShopperID 
ISC_OnlineShopperID String STR32 32 2 OnlineOrderNumber ISC_OnlineOrderNumber String STR26_LBAU 26 3 SOPNUMBE SOP Number String STR20_SOP_Number 17 4 SOPTYPE SOP Type Integer DDL_SOP_Type 0 5 MSTRNUMB Master Number Long Integer LI_MasterNumber 9 6 OnlineOrderStatus ISC_OnlineOrderStatus String STR10 10 7 OnlineCostCentre ISC_OnlineCostCentre String STR30 30 8 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['ISC_OnlineOrderExtra'].CUSTNMBR AS 'ISC_OnlineOrderExtra-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
ISC_OnlineOrderExtra AS ['ISC_OnlineOrderExtra']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ISC_OnlineOrderExtra'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR9 ISC_Purchasing_Notes ISC_Purchasing_Notes String STR255 255