• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 98 views
  • Users 0 members are here
Related

Automatic Generation of CSI

Simon Davidson
$organization

Hi,

Does anyone have any guidelines on how to automatically generate CSI?  What I want to happen, is that for anyone who has bought a certain concession ticket (such as a student ticket), a CSI should automatically be generated so that when the ticket is scanned at the door they are asked for elgibility ID.

I envisage this running as a job over night as don't want to put triggers on order tables, but I'm unsure on what tables I need to look at for CSI information.

Any pointers whould be greatly appreciated.

Thanks!

Parents
  • $organization

    Hi Simon,

    Here are some tables to consider
    T_CUST_ACTIVITY
    T_ISSUE_ACTION

    Also would need to execute AP_GET_NEXTID for types
    AC (Customer Activity Number)
    within your procedure, as well as
    IA (Customer Issue Action Unique N)
    if you are updating the T_ISSUE_ACTION table.

    I'd probably set this up to run against a dynamic list to keep it simple.

    Hope that helps!

Reply
  • $organization

    Hi Simon,

    Here are some tables to consider
    T_CUST_ACTIVITY
    T_ISSUE_ACTION

    Also would need to execute AP_GET_NEXTID for types
    AC (Customer Activity Number)
    within your procedure, as well as
    IA (Customer Issue Action Unique N)
    if you are updating the T_ISSUE_ACTION table.

    I'd probably set this up to run against a dynamic list to keep it simple.

    Hope that helps!

Children
No Data