tbl_Account [Account]

Property	Value
Name	tbl_Account
Caption	Account
Module	X15
USI	X15\Workspaces\Accounts\General\Main Grid\tbl_Account
Table Group	tg_Accounts
Is administrated by field	Yes
Is administrated by record	Yes
Record change is logged	No

Fields

#	Name	Type	Name
1.	ID	Identifier	Account
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]	Account
7.	OfficialAccountName	Unicode string [250]	Official Account Name
8.	PrimaryContactID	Unique identifier GUID	Primary Contact
9.	TerritoryID	Unique identifier GUID	Territory
10.	AnnualRevenue	Float [15]	Annual Revenue
11.	EmployeesNumber	Integer	Employees Number
12.	OwnerID	Unique identifier GUID	Owner
13.	CampaignID	Unique identifier GUID	Campaign
14.	AddressTypeID	Unique identifier GUID	Address Type
15.	Address	Unicode string [250]	Address
16.	CityID	Unique identifier GUID	City
17.	StateID	Unique identifier GUID	Status
18.	ZIP	Unicode string [250]	ZIP
19.	CountryID	Unique identifier GUID	Country
20.	ActivityID	Unique identifier GUID	Activity
21.	FieldID	Unique identifier GUID	Field
22.	Communication1	Unicode string [250]	Communication 1
23.	Communication2	Unicode string [250]	Communication 2
24.	Communication3	Unicode string [250]	Communication 3
25.	Communication4	Unicode string [250]	Communication 4
26.	Communication5	Unicode string [250]	Communication 5
27.	Communication1TypeID	Unique identifier GUID	Communication 1 Type
28.	Communication2TypeID	Unique identifier GUID	Communication 2 Type
29.	Communication3TypeID	Unique identifier GUID	Communication 3 Type ID
30.	Communication4TypeID	Unique identifier GUID	Communication4 Type ID
31.	Communication5TypeID	Unique identifier GUID	Communication5 Type ID
32.	Description	Large binary object	Description
33.	AccountTypeID	Unique identifier GUID	Account Type
34.	Code	Unicode string [250]	Code

Relations

#	Relation name	Field	Table	Cascade relation
1.	FAccount_CityID	CityID	tbl_City	No
2.	FAccount_CountryID	CountryID	tbl_Country	No
3.	FAccount_StateID	StateID	tbl_State	No
4.	FAccount_TerritoryID	TerritoryID	tbl_Territory	No
5.	FAccount_OwnerID	OwnerID	tbl_Contact	No
6.	FAccount_CampaignID	CampaignID	tbl_Campaign	No
7.	FAccount_Field	FieldID	tbl_Field	No
8.	FAccount_AccountTypeID	AccountTypeID	tbl_AccountType	No
9.	FAccountActivityID	ActivityID	tbl_Activity	No
10.	FAccountAddressTypeID	AddressTypeID	tbl_AddressType	No
11.	FAccountCommunication1TypeID	Communication1TypeID	tbl_CommunicationType	No
12.	FAccountCommunication2TypeID	Communication2TypeID	tbl_CommunicationType	No
13.	FAccountCommunication3TypeID	Communication3TypeID	tbl_CommunicationType	No
14.	FAccountCommunication4TypeID	Communication4TypeID	tbl_CommunicationType	No
15.	FAccountCommunication5TypeID	Communication5TypeID	tbl_CommunicationType	No

Indexes

#	Name	Unique	Structure
1.	IAccount1	No	ActivityID
2.	IAccount2	No	AccountTypeID
3.	IAccount3	No	FieldID
4.	IAccount4	No	CampaignID
5.	IAccount5	No	OwnerID
6.	IAccount6	No	TerritoryID
7.	IAccount7	No	StateID
8.	IAccount8	No	CountryID
9.	IAccount9	No	CityID
10.	IAccount11	No	AddressTypeID
11.	IAccount12	No	CreatedOn
12.	IAccount15	No	Communication1TypeID
13.	IAccount13	No	Communication2TypeID
14.	IAccount14	No	Communication3TypeID
15.	IAccount16	No	Communication4TypeID
16.	IAccount17	No	Communication5TypeID
17.	IAccountCreatedByID	No	CreatedByID
18.	IAccountModifiedByID	No	ModifiedByID
19.	IAccount10	No	AnnualRevenue
20.	IAccountPrimaryContactID	No	PrimaryContactID