Bank Master (SY04100)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Bank Master
Physical Name: SY04100
Technical Name: CM_Bank_MSTR

Group Display Name: Checkbook Master
Group Technical Name: Checkbook Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BANKID SearchBank IDStringSTR15_Bank_ID15
2BANKNAME SearchBank NameStringSTR3030
3ADDRESS1 SearchAddress 1StringSTR6060
4ADDRESS2 SearchAddress 2StringSTR6060
5ADDRESS3 SearchAddress 3StringSTR6060
6CITY SearchCityStringSTR3535
7STATE SearchStateStringSTR30_State29
8ZIPCODE SearchZip CodeStringSTR1010
9COUNTRY SearchCountryStringSTR6060
10PHNUMBR1 SearchPhone Number 1StringPhone_Number14
11PHNUMBR2 SearchPhone Number 2StringPhone_Number14
12PHONE3 SearchPhone 3StringPhone_Number314
13FAXNUMBR SearchFax NumberStringSTR14_FAX14
14TRNSTNBR SearchTransit NumberStringSTR99
15BNKBRNCH SearchBank BranchStringSTR2020
16NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Bank Master'].NOTEINDX AS 'Bank Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SY04100 AS ['Bank Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Bank Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
17DDTRANUM SearchDD Transit NumberStringDD_STR099

Leave a Reply

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