tbl_Bank [Bank]

Terrasoft CRM 3.0 SDK > Basic Configuration > Tables > User's > tbl_Bank [Bank]

Contents

Index

tbl_Bank [Bank]

Property	Value
Name	tbl_Bank
Caption	Bank
Module	X15
USI	X15\Dictionaries\Bank\tbl_Bank
Table Group	tg_Dictionaries
Is administrated by field	No
Is administrated by record	No
Record change is logged	No

#	Name	Type	Name
1.	ID	Identifier	Bank
2.	CreatedOn	Date/Time	Created On
3.	CreatedByID	Unique identifier GUID	Created By
4.	ModifiedOn	Date/Time	Modification Date
5.	ModifiedByID	Unique identifier GUID	Modified By
6.	Name	Unicode string [250]	Name
7.	Address	Unicode string [250]	Address
8.	MFO	Unicode string [250]	MFO
9.	AddressTypeID	Unique identifier GUID	Address Type
10.	CityID	Unique identifier GUID	City
11.	CountryID	Unique identifier GUID	Country
12.	StateID	Unique identifier GUID	Status
13.	ZIP	Unicode string [250]	ZIP
14.	Description	Unicode string [250]	Description

#	Relation name	Field	Table	Cascade relation
1.	FBank_CountryID	CountryID	tbl_Country	No
2.	FBank_CityID	CityID	tbl_City	No
3.	FBank_StateID	StateID	tbl_State	No
4.	FBankAddressTypeID	AddressTypeID	tbl_AddressType	No

#	Name	Unique	Structure
1.	IBank_State	No	StateID
2.	IBank_City	No	CityID
3.	IBank_Country	No	CountryID
4.	IBank_Address	No	Address
5.	IBank_MFO	No	MFO
6.	IBank_AddressType	No	AddressTypeID
7.	IBank_CreatedBy	No	CreatedByID
8.	IBank_ModifiedBy	No	ModifiedByID

Copyright (с) Terrasoft 2002-2007.