|
Property |
Value |
|
Name |
tbl_Contract |
|
Caption |
Contract |
|
X15 | |
|
USI |
X15\Workspaces\Contracts\General\MainGrid\tbl_Contract |
|
Table Group | |
|
Is administrated by field |
Yes |
|
Is administrated by record |
Yes |
|
Record change is logged |
No |
|
# |
Name |
Type |
Name |
|
1. |
ID |
Contract | |
|
2. |
CreatedOn |
Created On | |
|
3. |
Created By | ||
|
4. |
ModifiedOn |
Modification Date | |
|
5. |
Modified By | ||
|
6. |
Title |
Unicode string [250] |
Contract |
|
7. |
ContractNumber |
Unicode string [250] |
Contract Number |
|
8. |
Contract Type | ||
|
9. |
ParentContractID |
Parent Contract | |
|
10. |
Opportunity | ||
|
11. |
Contract Status | ||
|
12. |
Owner | ||
|
13. |
StartDate |
Start Date | |
|
14. |
DueDate |
End Date | |
|
15. |
Customer | ||
|
16. |
Account Information | ||
|
17. |
BillingFrequencyID |
Payment Frequency | |
|
18. |
Currency | ||
|
19. |
CurrencyRate |
Float [15] |
Currency Rate |
|
20. |
Amount |
Float [15] |
Amount |
|
21. |
BasicAmount |
Float [15] |
Amount (b.c.) |
|
22. |
Description |
Description | |
|
23. |
Contact | ||
|
24. |
Campaign | ||
|
25. |
Incident |
|
# |
Relation name |
Field |
Table |
Cascade relation |
|
1. |
FContractParentContractID |
ParentContractID |
tbl_Contract |
No |
|
2. |
FContract_OpportunityID |
OpportunityID |
No | |
|
3. |
FContract_OwnerID |
OwnerID |
No | |
|
4. |
FContract_CustomerID |
CustomerID |
No | |
|
5. |
FContractCurrencyID |
CurrencyID |
No | |
|
6. |
FContractBillInfoID |
BillInfoID |
No | |
|
7. |
FContractContactID |
ContactID |
No | |
|
8. |
FContractCampaignID |
CampaignID |
No | |
|
9. |
FContractIncidentID |
IncidentID |
No | |
|
10. |
FContractContractTypeID |
ContractTypeID |
No | |
|
11. |
FContractContractStatusID |
ContractStatusID |
No |
|
# |
Name |
Unique |
Structure |
|
1. |
IContract |
No |
IncidentID |
|
2. |
IContractCampaignID |
No |
CampaignID |
|
3. |
IContractContactID |
No |
ContactID |
|
4. |
IContractBillInfoID |
No |
BillInfoID |
|
5. |
IContractCurrencyID |
No |
CurrencyID |
|
6. |
IContractCustomerID |
No |
CustomerID |
|
7. |
IContractOwnerID |
No |
OwnerID |
|
8. |
IContractOpportunityID |
No |
OpportunityID |
|
9. |
IContractParentContractID |
No |
ParentContractID |
|
10. |
IContractContractTypeID |
No |
ContractTypeID |
|
11. |
IContractContractStatusID |
No |
ContractStatusID |
|
12. |
IContractmOdificationDate |
No |
ModifiedOn |
|
13. |
IContractCreatedByID |
No |
CreatedByID |
|
14. |
IContractModifiedByID |
No |
ModifiedByID |
|
Copyright (ñ) Terrasoft 2002-2007.
|