Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00660
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Customer_Contract_Detail
Physical Name: SV00660
Technical Name: SV_Customer_Contract_Detail
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | CUSTNMBR  | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['SV_Customer_Contract_Detail'].CUSTNMBR AS 'SV_Customer_Contract_Detail-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV00660 AS ['SV_Customer_Contract_Detail']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Customer_Contract_Detail'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 2 | ADRSCODE | Address Code | STR15_Address_Code | String | 15 | |
| 3 | Corporate_Contract_Nbr | Corporate Contract Number | STR20_LBAU | String | 20 | |
| 4 | WSMSTRCONTSQ | WS Master Contract Seq Number | LI_Sequence_Number | Long Integer | 10 | |
| 5 | Customer_Contract_Type | Customer Contract Type | STR15 | String | 15 | |
| 6 | Customer_Contract_Desc | Customer Contract Description | STR30 | String | 30 | |