|
Property |
Value |
|
Name |
tbl_Account |
|
Caption |
Account |
|
X15 | |
|
USI |
X15\Workspaces\Accounts\General\Main Grid\tbl_Account |
|
Table Group | |
|
Is administrated by field |
Yes |
|
Is administrated by record |
Yes |
|
Record change is logged |
No |
|
# |
Name |
Type |
Name |
|
1. |
ID |
Account | |
|
2. |
CreatedOn |
Created On | |
|
3. |
Created By | ||
|
4. |
ModifiedOn |
Modification Date | |
|
5. |
Modified By | ||
|
6. |
Name |
Unicode string [250] |
Account |
|
7. |
OfficialAccountName |
Unicode string [250] |
Official Account Name |
|
8. |
PrimaryContactID |
Primary Contact | |
|
9. |
Territory | ||
|
10. |
AnnualRevenue |
Float [15] |
Annual Revenue |
|
11. |
EmployeesNumber |
Employees Number | |
|
12. |
Owner | ||
|
13. |
Campaign | ||
|
14. |
Address Type | ||
|
15. |
Address |
Unicode string [250] |
Address |
|
16. |
City | ||
|
17. |
Status | ||
|
18. |
ZIP |
Unicode string [250] |
ZIP |
|
19. |
Country | ||
|
20. |
Activity | ||
|
21. |
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. |
Communication 1 Type | ||
|
28. |
Communication 2 Type | ||
|
29. |
Communication 3 Type ID | ||
|
30. |
Communication4 Type ID | ||
|
31. |
Communication5 Type ID | ||
|
32. |
Description |
Description | |
|
33. |
Account Type | ||
|
34. |
Code |
Unicode string [250] |
Code |
|
# |
Relation name |
Field |
Table |
Cascade relation |
|
1. |
FAccount_CityID |
CityID |
No | |
|
2. |
FAccount_CountryID |
CountryID |
No | |
|
3. |
FAccount_StateID |
StateID |
No | |
|
4. |
FAccount_TerritoryID |
TerritoryID |
No | |
|
5. |
FAccount_OwnerID |
OwnerID |
No | |
|
6. |
FAccount_CampaignID |
CampaignID |
No | |
|
7. |
FAccount_Field |
FieldID |
No | |
|
8. |
FAccount_AccountTypeID |
AccountTypeID |
No | |
|
9. |
FAccountActivityID |
ActivityID |
No | |
|
10. |
FAccountAddressTypeID |
AddressTypeID |
No | |
|
11. |
FAccountCommunication1TypeID |
Communication1TypeID |
No | |
|
12. |
FAccountCommunication2TypeID |
Communication2TypeID |
No | |
|
13. |
FAccountCommunication3TypeID |
Communication3TypeID |
No | |
|
14. |
FAccountCommunication4TypeID |
Communication4TypeID |
No | |
|
15. |
FAccountCommunication5TypeID |
Communication5TypeID |
No |
|
# |
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 |
|
Copyright (ñ) Terrasoft 2002-2007.
|