ISC_OnlineOrderExtra (ISC_OnlineOrderExtra)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ISC_OnlineOrderExtra

Display Name: ISC_OnlineOrderExtra
Physical Name: ISC_OnlineOrderExtra
Technical Name: ISC_OnlineOrderExtra

Seq 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'].CUSTNMBR
9	ISC_Purchasing_Notes	ISC_Purchasing_Notes	String	STR255	255