1. Using B2C Service
  2. Transactions Database Table Transaction Types

Transactions Database Table Transaction Types

The types of transactions stored in the Transactions table, and the types of records and items that the transaction types can apply to, are listed in this table.

The numeric code for each type is shown in parentheses after the type name. The numeric code for each table is shown after the table name.

Note: Some transaction types listed in the table are intended for use only by Oracle Consulting Services.

Table and Transaction Type Associations

Table Name Transaction Type
Incidents (1)
  • Created (2)
  • Edited (3)
  • Assigned (4)
  • Status Changed (6)
  • Time Billed Added (7)
  • Response Sent (8)
  • Escalated (11)
  • SmartAssist (12)
  • Forwarded (14)
  • Message Send Failure (15)
  • Incident Proposed (16)
  • Queue Changed (17)
  • Forwarded by a Rule (21)
  • Sent (24)
  • Completed (25)
  • Cloud Response Queued (37)
  • Read (48)
  • Cloud Response Received (51)
  • Cloud Result Appended (53)
Contacts (2)
  • Created (2)
  • Edited (3)
  • Escalated (11)
  • Moved (20)
  • Opt-In (23)
  • Invalid Email Flag Changed (35)
  • Contact Password Reset (36)
  • Email Changed (38)
  • Email Alt1 Changed (39)
  • Email Alt2 Changed (40)
  • City Changed (41)
  • Country Changed (42)
  • Postal Code Changed (43)
  • Province Changed (44)
  • Street Changed (45)
  • Sub-Object Move (47)
Organizations (3)
  • Created (2)
  • Edited (3)
  • Escalated (11)
Answers (9)
  • Created (2)
  • Edited (3)
  • Assigned (4)
  • Access Level Changed (5)
  • Status Changed (6)
  • Escalated (11)
  • Forwarded by a Rule (21)
Meta-Answers (10)
  • Created (2)
  • Edited (3)
Quotes (12)
  • Created (2)
  • Edited (3)
  • Status Changed (6)
  • Quote Sent (22)
  • Quote Forecasted (32)
  • Quote Price Schedule Changed (33)
  • Quote Template Changed (34)
Documents (51)
  • Created (2)
  • Edited (3)
  • Proof Message Sent (49)
  • Document Deployed (50)
Contact Lists (52)
  • Created (2)
  • Edited (3)
  • Audience Counted (30)
  • Purge (46)
Mailings (53)
  • Created (2)
  • Edited (3)
  • Assigned (4)
  • Audience Counted (30)
Mailing Messages(54)
  • Edited (3)
  • Status Changed (6)
  • Sent (24)
  • Mailing Error (28)
  • Mailing Scheduled (29)
  • CAN-SPAM Compliance (31)
Segments (79)
  • Created (2)
  • Edited (3)
  • Stage Changed (18)
  • Audience Counted (30)
Opportunities (87)
  • Created (2)
  • Edited (3)
  • Assigned (4)
  • Status Changed (6)
  • Escalated (11)
  • Completed (25)
Tasks (106)
  • Created (2)
  • Edited (3)
  • Assigned (4)
  • Status Changed (6)
  • Escalated (11)
Flows (126)
  • Status Changed (6)
Surveys (127)
  • Created (2)
  • Edited (3)
  • Assigned (4)
  • Survey Disabled (26)
  • Advanced Mode (27)
  • Audience Counted (30)
  • Survey Reminder Sent (52)
Campaigns (163)
  • Created (2)
  • Edited (3)
  • Assigned (4)
Assets (542)
  • Created (2)
  • Edited (3)
  • Status Changed (6)
  • Forwarded (14)