150561181
2016-05-18 16:08:04
2016-05-23 10:21:18
Approved/Closed
Regular (i.e. consultants, EiRs)
[Null]
[Null]
[Null]
[Null]
150653420
2016-05-20 13:38:24
2016-06-02 09:32:42
Approved/Closed
Regular (i.e. consultants, EiRs)
[Null]
[Null]
[Null]
[Null]
150661613
2016-05-20 17:40:48
2016-06-02 09:32:20
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
150710381
2016-05-23 12:32:04
2017-03-22 18:17:26
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
150861993
2016-05-26 10:34:49
2017-03-22 18:19:39
Approved/Closed
Event
[Null]
[Null]
Vpayment
[Null]
151244207
2016-06-06 13:25:37
2017-03-22 18:20:27
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151248533
2016-06-06 14:53:51
2017-03-22 18:21:06
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151250350
2016-06-06 15:32:54
2017-04-21 19:33:28
Rejected
Event
[Null]
[Null]
Vpayment
[Null]
151255588
2016-06-06 17:37:43
2016-06-06 17:37:43
Draft
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151295697
2016-06-07 11:43:44
2017-03-22 18:29:27
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151306609
2016-06-07 15:21:26
2017-03-22 18:30:10
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151307139
2016-06-07 15:33:33
2017-03-22 18:36:15
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151307438
2016-06-07 15:41:42
2016-06-07 17:47:22
Rejected
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151308561
2016-06-07 16:03:56
2017-03-22 18:36:59
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151312127
2016-06-07 17:43:19
2017-04-21 19:33:59
Rejected
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151465055
2016-06-11 12:02:01
2017-04-21 19:34:29
Rejected
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151514414
2016-06-13 13:45:23
2016-06-15 11:32:34
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151518348
2016-06-13 15:00:51
2017-04-21 19:34:55
Rejected
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151526149
2016-06-13 18:13:51
2017-04-24 13:00:20
Approved/Closed
Event
[Null]
[Null]
Vpayment
[Null]
151526640
2016-06-13 18:59:22
2017-03-22 18:38:05
Approved/Closed
Event
[Null]
[Null]
Vpayment
[Null]
151526923
2016-06-13 19:18:34
2016-06-13 19:18:34
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151570669
2016-06-14 13:08:03
2016-06-17 09:37:51
Approved/Closed
Event
[Null]
[Null]
Vpayment
[Null]
151581642
2016-06-14 16:48:34
2016-07-07 10:54:12
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151613457
2016-06-15 10:11:52
2016-06-17 09:41:43
Approved/Closed
Event
[Null]
[Null]
[Null]
PO
151616534
2016-06-15 10:52:06
2016-07-05 13:25:29
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151623942
2016-06-15 12:50:11
2017-03-22 18:40:43
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151680742
2016-06-16 14:05:08
2016-06-27 10:31:28
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151743688
2016-06-17 14:08:36
2016-06-27 10:38:55
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151744480
2016-06-17 14:22:33
2017-03-22 18:41:47
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151875313
2016-06-21 13:12:56
2016-06-27 10:55:56
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151883638
2016-06-21 16:10:16
2017-04-21 19:36:11
Approved/Closed
Event
[Null]
[Null]
[Null]
PO
151886283
2016-06-21 17:11:22
2016-06-24 08:26:24
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151928764
2016-06-22 11:59:30
2016-06-24 11:37:36
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
151994386
2016-06-23 14:56:00
2016-06-30 09:18:43
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
151995097
2016-06-23 15:10:56
2016-06-27 10:58:47
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152039554
2016-06-24 12:02:17
2016-07-07 13:37:23
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152044638
2016-06-24 14:03:59
2016-07-14 10:46:39
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152123453
2016-06-27 14:33:23
2016-07-20 13:53:42
Approved/Closed
Event
[Null]
[Null]
[Null]
Payment Request
152123632
2016-06-27 14:42:41
2016-06-30 10:52:46
Rejected
Event
[Null]
[Null]
[Null]
Payment Request
152134161
2016-06-27 20:22:23
2016-07-07 13:32:26
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152194942
2016-06-28 17:26:57
2016-07-07 13:35:19
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
152257295
2016-06-29 17:33:42
2017-04-21 19:36:55
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152322644
2016-06-30 17:33:56
2016-07-20 14:06:08
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
152323834
2016-06-30 18:10:04
2016-07-07 13:38:51
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152524213
2016-07-06 14:13:45
2016-07-07 13:40:06
Approved/Closed
Event
[Null]
[Null]
Vpayment
[Null]
152560296
2016-07-07 09:35:15
2016-07-28 13:11:33
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152560946
2016-07-07 09:44:28
2016-08-01 09:21:29
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152583354
2016-07-07 18:08:48
2016-08-15 08:40:42
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
152737843
2016-07-12 12:30:53
2016-07-28 13:14:59
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153015450
2016-07-19 16:19:33
2016-07-20 13:21:05
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153016272
2016-07-19 16:43:06
2016-08-08 13:14:18
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153069433
2016-07-20 17:16:46
2016-07-28 13:16:07
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153224917
2016-07-25 16:01:01
2016-07-25 16:01:01
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
153227812
2016-07-25 17:18:42
2016-08-08 10:10:56
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153251724
2016-07-26 08:51:52
2017-04-21 19:37:30
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153264335
2016-07-26 12:10:45
2017-04-21 19:38:12
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
153280228
2016-07-26 18:29:56
2016-08-15 13:08:02
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153327484
2016-07-27 17:12:54
2016-08-08 10:08:25
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
153381194
2016-07-28 20:20:42
2016-08-15 13:09:29
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153488374
2016-08-01 14:46:26
2016-08-08 10:03:38
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153592418
2016-08-03 12:50:00
2016-08-17 09:31:21
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
153611158
2016-08-03 22:15:01
2016-08-21 20:23:57
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
153654694
2016-08-04 18:05:51
2017-04-21 19:38:46
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
153692183
2016-08-05 13:57:28
2017-04-21 19:39:11
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
153951993
2016-08-12 17:04:47
2016-09-01 14:37:51
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154084493
2016-08-17 11:59:51
2016-09-01 14:42:38
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
154084622
2016-08-17 12:02:21
2016-08-21 23:13:59
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
154086691
2016-08-17 12:56:11
2016-09-01 14:40:55
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154144203
2016-08-18 20:31:14
2016-08-18 20:31:14
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154145657
2016-08-18 20:47:07
2016-09-20 11:26:29
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154247965
2016-08-22 15:48:26
2016-09-01 14:48:07
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154306604
2016-08-23 19:34:13
2016-09-20 11:28:06
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
154398358
2016-08-25 14:42:25
2017-04-21 19:43:46
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154450723
2016-08-26 17:30:47
2016-08-26 17:30:47
Draft
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154450948
2016-08-26 17:34:55
2016-09-23 12:27:55
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154504879
2016-08-29 12:43:12
2016-09-07 11:29:18
Approved/Closed
Event
[Null]
[Null]
[Null]
PO
154504893
2016-08-29 12:45:17
2016-09-07 11:29:49
Approved/Closed
Event
[Null]
[Null]
[Null]
PO
154745347
2016-09-02 15:27:38
2016-09-02 15:27:38
Draft
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154745607
2016-09-02 15:42:55
2017-04-21 19:43:20
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
154757461
2016-09-03 14:16:25
2017-04-21 19:42:52
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
154829797
2016-09-06 11:16:36
2016-09-20 11:37:12
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
154985978
2016-09-09 12:26:15
2016-09-13 10:17:59
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155052000
2016-09-12 13:39:50
2016-09-20 11:40:15
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155052361
2016-09-12 13:45:23
2016-09-12 13:45:23
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155087462
2016-09-13 09:46:41
2016-09-13 14:14:54
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155111901
2016-09-13 18:28:15
2016-09-21 21:20:03
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155217483
2016-09-15 18:58:01
2017-04-21 19:42:19
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155253945
2016-09-16 13:05:22
2016-09-20 15:51:42
Pending[workflow]
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155319663
2016-09-19 12:12:23
2016-09-22 14:41:24
Approved/Closed
Event
[Null]
[Null]
Vpayment
[Null]
155331443
2016-09-19 16:21:58
2017-04-21 19:44:16
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155331647
2016-09-19 16:22:34
2016-09-22 14:42:42
Approved/Closed
Event
[Null]
[Null]
[Null]
Payment Request
155335928
2016-09-19 18:57:30
2016-09-28 10:03:48
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155345236
2016-09-20 02:15:05
2017-04-21 19:41:37
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155393433
2016-09-20 12:35:32
2017-04-21 19:41:13
Approved/Closed
Event
[Null]
[Null]
[Null]
Payment Request
155408685
2016-09-20 21:00:26
2016-09-29 13:07:08
Approved/Closed
Event
[Null]
[Null]
Vpayment
[Null]
155409575
2016-09-20 22:17:54
2016-09-23 12:39:20
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155452214
2016-09-21 13:51:18
2016-10-11 15:06:57
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155462563
2016-09-21 17:58:32
2016-09-28 10:05:50
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155501917
2016-09-22 12:45:44
2016-09-29 13:47:53
Approved/Closed
Event
[Null]
[Null]
[Null]
PO
155515075
2016-09-22 18:53:00
2016-10-20 12:02:45
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155560665
2016-09-23 16:32:01
2017-04-21 19:40:36
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155621249
2016-09-26 11:59:01
2017-04-21 19:39:47
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155632580
2016-09-26 15:25:24
2016-10-19 15:15:32
Approved/Closed
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155681031
2016-09-27 11:55:11
2016-10-03 13:33:58
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155699913
2016-09-27 20:04:25
2016-09-27 20:04:25
Draft
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155726314
2016-09-28 08:50:37
2016-10-17 12:30:50
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155815573
2016-09-29 16:34:29
2016-09-29 16:34:29
Pending[workflow]
Regular (i.e. consultants, EiRs, memberships paid monthly/quarterly)
[Null]
PO
[Null]
[Null]
155861524
2016-09-30 11:52:01
2016-10-20 12:04:26
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155869727
2016-09-30 14:34:50
2016-10-20 12:05:15
Approved/Closed
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155878878
2016-09-30 18:04:05
2016-11-01 11:45:50
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
155942111
2016-10-03 12:50:20
2016-10-03 12:50:20
Pending[workflow]
One-time payment (i.e. reimbursements, charitable contributions, sponsorships, memberships paid annually)
Payment Request
[Null]
[Null]
[Null]
Create the new column
NewRequisitionCol = [Type of requisition]
+ [Type of requisition2]
+ [Type of re...
remove old columns
C:\Users\seanb_000\AppData\Local\Temp\Engine_26324_022e55fb4c59491a9884e41f055b0253_\Engine_8716_f24ed77ff78c4f6c809337d8b8b56092_.yxdb
Single
Profile
Text
replace([_CurrentField_],'[Null]','')
Remove "null" in blank fields
replace([_CurrentField_],'[Null]','')
Horizontal
TestFlow