JC_Project_Invoice_ADDR_VIEW (JC90002)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Project_Invoice_ADDR_VIEW (JC90002)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_Project_Invoice_ADDR_VIEW
Physical Name: JC90002
Technical Name: JC_Project_Invoice_ADDR_VIEW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Project_Number SearchWS Project NumberSTR170String1817
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['JC_Project_Invoice_ADDR_VIEW'].CUSTNMBR AS 'JC_Project_Invoice_ADDR_VIEW-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       JC90002 AS ['JC_Project_Invoice_ADDR_VIEW']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['JC_Project_Invoice_ADDR_VIEW'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3Job_Address_Code SearchJob Address CodeSTR15_Address_CodeString1615
4Job_Billto_Address_Code SearchJob Billto Address CodeSTR15_LBAUString1615
5CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
6CNTCPRSN SearchContact PersonSTR60String6260
7Job_Address_1 SearchJob Address 1STR30String3230
8Job_Address_2 SearchJob Address 2STR30String3230
9Job_City SearchJob CitySTR30String3230
10Job_State SearchJob StateSTR4String64
11Job_Zip SearchJob ZipSTR10String1210
12ADDRESS1 SearchAddress 1STR60String6260
13ADDRESS2 SearchAddress 2STR60String6260
14CITY SearchCitySTR35String3635
15STATE SearchStateSTR30_StateString3029
16ZIP SearchZipSTR10String1210
azurecurveProductsWennSoft Products (131)3rd PartyJC_Project_Invoice_ADDR_VIEW (JC90002)

Leave a Reply

Your email address will not be published. Required fields are marked *