Bank Master (SY04100)

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

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

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BANKID	Bank ID	String	STR15_Bank_ID	15
2	BANKNAME	Bank Name	String	STR30	30
3	ADDRESS1	Address 1	String	STR60	60
4	ADDRESS2	Address 2	String	STR60	60
5	ADDRESS3	Address 3	String	STR60	60
6	CITY	City	String	STR35	35
7	STATE	State	String	STR30_State	29
8	ZIPCODE	Zip Code	String	STR10	10
9	COUNTRY	Country	String	STR60	60
10	PHNUMBR1	Phone Number 1	String	Phone_Number	14
11	PHNUMBR2	Phone Number 2	String	Phone_Number	14
12	PHONE3	Phone 3	String	Phone_Number3	14
13	FAXNUMBR	Fax Number	String	STR14_FAX	14
14	TRNSTNBR	Transit Number	String	STR9	9
15	BNKBRNCH	Bank Branch	String	STR20	20
16	NOTEINDX	Note Index	Currency	DLR14	14
	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
17	DDTRANUM	DD Transit Number	String	DD_STR09	9