|
|
  |
tbl_Document [Document]
|
Property |
Value |
|
Name |
tbl_Document |
|
Caption |
Document |
|
X15 | |
|
USI |
X15\Workspaces\Documents\General\MainGrid\tbl_Document |
|
Table Group | |
|
Is administrated by field |
Yes |
|
Is administrated by record |
Yes |
|
Record change is logged |
No |
|
# |
Name |
Type |
Name |
|
1. |
ID |
Document | |
|
2. |
CreatedOn |
Created On | |
|
3. |
Created By | ||
|
4. |
ModifiedOn |
Modification Date | |
|
5. |
Modified By | ||
|
6. |
DocumentNumber |
Unicode string [250] |
Document Number |
|
7. |
Title |
Unicode string [250] |
Document Title |
|
8. |
Document Type | ||
|
9. |
Status | ||
|
10. |
Date |
Date | |
|
11. |
Opportunity | ||
|
12. |
Account | ||
|
13. |
Contact | ||
|
14. |
Campaign | ||
|
15. |
Owner | ||
|
16. |
Invoice | ||
|
17. |
Contract | ||
|
18. |
Description |
Description |
|
# |
Relation name |
Field |
Table |
Cascade relation |
|
1. |
FDocument_OpportunityID |
OpportunityID |
No | |
|
2. |
FDocument_AccountID |
AccountID |
No | |
|
3. |
FDocument_ContactID |
ContactID |
No | |
|
4. |
FDocument_CampaignID |
CampaignID |
No | |
|
5. |
FDocument_OwnerID |
OwnerID |
No | |
|
6. |
FDocument_InvoiceID |
InvoiceID |
No | |
|
7. |
FDocument_ContractID |
ContractID |
No | |
|
8. |
FDocumentStateID |
StateID |
No | |
|
9. |
FDocumentDocumentTypeID |
DocumentTypeID |
No |
|
# |
Name |
Unique |
Structure |
|
1. |
IDocument |
No |
DocumentTypeID  |
|
2. |
IDocumentStateID |
No |
StateID |
|
3. |
IDocumentcontractID |
No |
ContractID |
|
4. |
IDocumentInvoiceID |
No |
InvoiceID |
|
5. |
IDocumentOwnerID |
No |
OwnerID |
|
6. |
IDocumentCampaignID |
No |
CampaignID |
|
7. |
IDocumentContactID |
No |
ContactID |
|
8. |
IDocumentAccountID |
No |
AccountID |
|
9. |
IDocumentOpportunityID |
No |
OpportunityID |
|
10. |
IDocumentModificationDate |
No |
ModifiedOn |
|
11. |
IDocumentCreatedByID |
No |
CreatedByID |
|
12. |
IDocumentModifiedByID |
No |
ModifiedByID |
|
Copyright (ñ) Terrasoft 2002-2007.
|
Properties