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 IDSTR15_Bank_IDString15
2BANKNAME SearchBank NameSTR30String30
3ADDRESS1 SearchAddress 1STR60String60
4ADDRESS2 SearchAddress 2STR60String60
5ADDRESS3 SearchAddress 3STR60String60
6CITY SearchCitySTR35String35
7STATE SearchStateSTR30_StateString29
8ZIPCODE SearchZip CodeSTR10String10
9COUNTRY SearchCountrySTR60String60
10PHNUMBR1 SearchPhone Number 1Phone_NumberString14
11PHNUMBR2 SearchPhone Number 2Phone_NumberString14
12PHONE3 SearchPhone 3Phone_Number3String14
13FAXNUMBR SearchFax NumberSTR14_FAXString14
14TRNSTNBR SearchTransit NumberSTR9String9
15BNKBRNCH SearchBank BranchSTR20String20
16NOTEINDX SearchNote IndexDLR14Currency14
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 NumberDD_STR09String9
18DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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