- DarkLight
Contact Business Data
- DarkLight
Source Table | Column Name | Display Name | Data Type | Description | Platform |
---|---|---|---|---|---|
RPT_Contact_BussinessData | Id | Id | bigint (not null) | The auto-generated ID for the entry in this table. | All |
RPT_Contact_BussinessData | CampaignId | CampaignId | nvarchar (64) (null) | The Campaign ID for this non-call activity. | All |
RPT_Contact_BussinessData | ContactId | ContactId | int (null) | The contact ID for this non-call activity. | All |
RPT_Contact_BussinessData | ListId | ListId | int (null) | The List ID that the contact belongs to. | All |
RPT_Contact_BussinessData | ContactVersion | ContactVersion | int (null) | The contact version for this contact at the time of non-call activity. This indicates the number of times the contact status has been revised. | All |
RPT_Contact_BussinessData | Bussfld1 | Bussfld1 | nvarchar (128) (null) | The description for Business Field 1. | All |
RPT_Contact_BussinessData | Bussfld2 | Bussfld2 | nvarchar (128) (null) | The description for Business Field 2. | All |
RPT_Contact_BussinessData | Bussfld3 | Bussfld3 | nvarchar (128) (null) | The description for Business Field 3. | All |
RPT_Contact_BussinessData | Bussfld4 | Bussfld4 | nvarchar (128) (null) | The description for Business Field 4. | All |
RPT_Contact_BussinessData | Bussfld5 | Bussfld5 | nvarchar (128) (null) | The description for Business Field 5. | All |
RPT_Contact_BussinessData | Bussfld6 | Bussfld6 | nvarchar (128) (null) | The description for Business Field 6. | All |
RPT_Contact_BussinessData | Bussfld7 | Bussfld7 | nvarchar (128) (null) | The description for Business Field 7. | All |
RPT_Contact_BussinessData | Bussfld8 | Bussfld8 | nvarchar (128) (null) | The description for Business Field 8. | All |
RPT_Contact_BussinessData | Bussfld9 | Bussfld9 | nvarchar (128) (null) | The description for Business Field 9. | All |
RPT_Contact_BussinessData | Bussfld10 | Bussfld10 | nvarchar (128) (null) | The description for Business Field 10. | All |
RPT_Contact_BussinessData | Bussfld11 | Bussfld11 | nvarchar (128) (null) | The description for Business Field 11. | All |
RPT_Contact_BussinessData | Bussfld12 | Bussfld12 | nvarchar (128) (null) | The description for Business Field 12. | All |
RPT_Contact_BussinessData | Bussfld13 | Bussfld13 | nvarchar (128) (null) | The description for Business Field 13. | All |
RPT_Contact_BussinessData | Bussfld14 | Bussfld14 | nvarchar (128) (null) | The description for Business Field 14. | All |
RPT_Contact_BussinessData | Bussfld15 | Bussfld15 | nvarchar (128) (null) | The description for Business Field 15. | All |
RPT_Contact_BussinessData | Bussfld16 | Bussfld16 | nvarchar (128) (null) | The description for Business Field 16. | All |
RPT_Contact_BussinessData | Bussfld17 | Bussfld17 | nvarchar (128) (null) | The description for Business Field 17. | All |
RPT_Contact_BussinessData | Bussfld18 | Bussfld18 | nvarchar (128) (null) | The description for Business Field 18. | All |
RPT_Contact_BussinessData | Bussfld19 | Bussfld19 | nvarchar (128) (null) | The description for Business Field 19. | All |
RPT_Contact_BussinessData | Bussfld20 | Bussfld20 | nvarchar (128) (null) | The description for Business Field 20. | All |
RPT_Contact_BussinessData | Bussfld21 | Bussfld21 | nvarchar (max) (null) | The description for Business Field 21. | All |
RPT_Contact_BussinessData | Bussfld22 | Bussfld22 | nvarchar (max) (null) | The description for Business Field 22. | All |
RPT_Contact_BussinessData | Bussfld23 | Bussfld23 | nvarchar (max) (null) | The description for Business Field 23. | All |
RPT_Contact_BussinessData | Bussfld24 | Bussfld24 | nvarchar (max) (null) | The description for Business Field 24. | All |
RPT_Contact_BussinessData | Bussfld25 | Bussfld25 | nvarchar (max) (null) | The description for Business Field 25. | All |
RPT_Contact_BussinessData | Bussfld26 | Bussfld26 | nvarchar (max) (null) | The description for Business Field 26 – unique business field. | All |
RPT_Contact_BussinessData | Bussfld27 | Bussfld27 | nvarchar (max) (null) | The description for Business Field 27 – additional business field. | All |
RPT_Contact_BussinessData | Bussfld28 | Bussfld28 | nvarchar (max) (null) | The description for Business Field 28 – additional business field. | All |
RPT_Contact_BussinessData | Bussfld29 | Bussfld29 | nvarchar (max) (null) | The description for Business Field 29 – additional business field. | All |
RPT_Contact_BussinessData | Bussfld30 | Bussfld30 | nvarchar (max) (null) | The description for Business Field 30 – additional business field. | All |
RPT_Contact_BussinessData | ContactDetail | ContactDetail | nvarchar (max) (null) | This column contains contact information as XML data format that goes to the dialer. For example, first name, last name, contact number, and so on. | All |
RPT_Contact_BussinessData | ModifiedBy | ModifiedBy | nvarchar (128) (null) | The user ID of the entity that last updated this entry. | All |
RPT_Contact_BussinessData | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | All |
RPT_Contact_BussinessData | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | All |
RPT_Contact_BussinessData | LastAccessedTime | LastAccessedTime | datetime (null) | The date and time the contact was last accessed. | All |