B Comma-Delimited Entries for Local Files
Local File Format
This section contains an example table that shows where, in locally-generated CSV files, specific VSAs may appear. The table is for an Interim CDR to a successful call. The user can produce the formats of local CDRs based on their configuration using the dump_csv_format command, documented in the Configuring Accounting chapter.
For more information about this feature and how to enable it, refer to the Local CDR Storage and FTP Push section in this guide’s Configuring Accounting chapter. Note that the Acme-CDR-Sequence-Number, VSA ID 59, appears in local CDR files when both file-output is enabled and an account server is configured.
Interim Record CSV Placement
| CSV Placement | Attribute Name | VSA ID Number |
|---|---|---|
| 1 | Acct-Status-Type | N/A |
| 2 | NAS-IP-Address | N/A |
| 3 | NAS-Port | N/A |
| 4 | Acct-Session-Id | N/A |
| 5 | Acme-Session-Ingress-CallId | 3 |
| 6 | Acme-Session-Egress-CallId | 4 |
| 7 | Acme-Session-Protocol-Type | 43 |
| 8 | Acme-Session-Forked-Call-Id | 171 |
| 9 | Acme-Session-Generic-Id | 40 |
| 10 | Calling-Station-Id | N/A |
| 11 | Called-Station-Id | N/A |
| 12 | h323-setup-time | N/A |
| 13 | h323-connect-time | N/A |
| 14 | Acme-Egress-Network-Interface-Id | 139 |
| 15 | Acme-Egress-Vlan-Tag-Value | 140 |
| 16 | Acme-Ingress-Network-Interface-Id | 137 |
| 17 | Acme-Ingress-Vlan-Tag-Value | 138 |
| 18 | Acme-Session-Egress-Realm | 42 |
| 19 | Acme-Session-Ingress-Realm | 41 |
| 20 | Acme-FlowId_FS1_F | 1 |
| 21 | Acme-FlowType_FS1_f | 2 |
| 22 | Acme-Flow-In-Realm_FS1_f | 10 |
| 23 | Acme-Flow-In-Src-Addr_FS1_F | 11 |
| 24 | Acme-Flow-In-Src-Port_FS1_F | 12 |
| 25 | Acme-Flow-In-Dst-Addr_FS1_F | 13 |
| 26 | Acme-Flow-In-Dst-Port_FS1_F | 14 |
| 27 | Acme-Flow-Out-Realm_FS1_F | 20 |
| 28 | Acme-Flow-Out-Src-Addr_FS1_F | 21 |
| 29 | Acme-Flow-Out-Src-Port_FS1_F | 22 |
| 30 | Acme-Flow-Out-Dst-Addr_FS1_F | 23 |
| 31 | Acme-Flow-Out-Dst-Port_FS1_F | 24 |
| 32 | Acme-Calling-RTCP-Packets-Lost_FS1 | 32 |
| 33 | Acme-Calling-RTCP-Avg-Jitter_FS1 | 33 |
| 34 | Acme-Calling-RTCP-Avg-Latency_FS1 | 34 |
| 35 | Acme-Calling-RTCP-MaxJitter_FS1 | 35 |
| 36 | Acme-Calling-RTCP-MaxLatency_FS1 | 36 |
| 37 | Acme-Calling-RTP-Packets-Lost_FS1 | 37 |
| 38 | Acme-Calling-RTP-Avg-Jitter_FS1 | 38 |
| 39 | Acme-Calling-RTP-MaxJitter_FS1 | 39 |
| 40 | Acme-Calling-Octets_FS1 | 28 |
| 41 | Acme-Calling-Packets_FS1 | 29 |
| 42 | Acme-Calling-R-Factor | 151 |
| 43 | Acme-Calling-MOS | 152 |
| 44 | Acme-FlowID_FS1_R | 78 |
| 45 | Acme-FlowType_FS1_R | 79 |
| 46 | Acme-Flow-In-Realm_FS1_R | 80 |
| 47 | Acme-Flow-In-Src-Addr_FS1_R | 81 |
| 48 | Acme-Flow-In-Src-Port_FS1_R | 82 |
| 49 | Acme-Flow-In-Dst-Addr_FS1_R | 83 |
| 50 | Acme-Flow-In-Dst-Port_FS1_R | 84 |
| 51 | Acme-Flow-Out-Realm_FS1_R | 85 |
| 52 | Acme-Flow-Out-Src-Addr_FS1_R | 86 |
| 53 | Acme-Flow-Out-Src-Port_FS1_R | 87 |
| 54 | Acme-Flow-Out-Dst-Addr_FS1_R | 88 |
| 55 | Acme-Flow-Out-Dst-Port_FS1_R | 89 |
| 56 | Acme-Called-RTCP-Packets-Lost_FS1 | 46 |
| 57 | Acme-Called-RTCP-Avg-Jitter_FS1 | 47 |
| 58 | Acme-Called-RTCP-Avg-Latency_FS1 | 48 |
| 59 | Acme-Called-RTCP-MaxJitter_FS1 | 49 |
| 60 | Acme-Called-RTCP-MaxLatency_FS1 | 50 |
| 61 | Acme-Called-RTP-Packets-Lost_FS1 | 51 |
| 62 | Acme-Called-RTP-Avg-Jitter_FS1 | 52 |
| 63 | Acme-Called-RTP-MaxJitter_FS1 | 53 |
| 64 | Acme-Called-Octets_FS1 | 44 |
| 65 | Acme-Called-Packets_FS1 | 45 |
| 66 | Acme-Called-R-Factor | 153 |
| 67 | Acme-Called-MOS | 154 |
| 68 | Acme-FlowID_FS2_F | 90 |
| 69 | Acme-FlowType_FS2_F | 91 |
| 70 | Acme-Flow-In-Realm_FS2_F | 92 |
| 71 | Acme-Flow-In-Src-Addr_FS2_F | 93 |
| 72 | Acme-Flow-In-Src-Port_FS2_F | 94 |
| 73 | Acme-Flow-In-Dst-Addr_FS2_F | 95 |
| 74 | Acme-Flow-In-Dst-Port_FS2_F | 96 |
| 75 | Acme-Flow-Out-Realm_FS2_F | 97 |
| 76 | Acme-Flow-Out-Src-Addr_FS2_F | 98 |
| 77 | Acme-Flow-Out-Src-Port_FS2_F | 99 |
| 78 | Acme-Flow-Out-Dst-Addr_FS2_F | 100 |
| 79 | Acme-Flow-Out-Dst-Port_FS2_F | 101 |
| 80 | Acme-Calling-RTCP-Packets-Lost_FS2 | 104 |
| 81 | Acme-Calling-RTCP-Avg-Jitter_FS2 | 105 |
| 82 | Acme-Calling-RTCP-Avg-Latency_FS2 | 107 |
| 83 | Acme-Calling-RTCP-MaxJitter_FS2 | 107 |
| 84 | Acme-Calling-RTCP-MaxLatency_FS2 | 108 |
| 85 | Acme-Calling-RTP-Packets-Lost_FS2 | 109 |
| 86 | Acme-Calling-RTP-Avg-Jitter_FS2 | 110 |
| 87 | Acme-Calling-RTP-MaxJitter_FS2 | 111 |
| 88 | Acme-Calling-Octets_FS2 | 102 |
| 89 | Acme-Calling-Packets_FS2 | 103 |
| 90 | Acme-FlowID_FS2_R | 112 |
| 91 | Acme-FlowType_FS2_R | 113 |
| 92 | Acme-Flow-In-Realm_FS2_R | 114 |
| 93 | Acme-Flow-In-Src-Addr_FS2_R | 115 |
| 94 | Acme-Flow-In-Src-Port_FS2_R | 116 |
| 95 | Acme-Flow-In-Dst-Addr_FS2_R | 117 |
| 96 | Acme-Flow-In-Dst-Port_FS2_R | 118 |
| 97 | Acme-Flow-Out-Realm_FS2_R | 119 |
| 98 | Acme-Flow-Out-Src-Addr_FS2_R | 120 |
| 99 | Acme-Flow-Out-Src-Port_FS2_R | 121 |
| 100 | Acme-Flow-Out-Dst-Addr_FS2_R | 122 |
| 101 | Acme-Flow-Out-Dst-Port_FS2_R | 123 |
| 102 | Acme-Called-RTCP-Packets-Lost_FS2 | 126 |
| 103 | Acme-Called--RTCP-Avg-Jitter_FS2 | 127 |
| 104 | Acme-Called--RTCP-Avg-Latency_FS2 | 128 |
| 105 | Acme-Called--RTCP-MaxJitter_FS2 | 129 |
| 106 | Acme-Called-RTCP-MaxLatency_FS2 | 130 |
| 107 | Acme-Called-RTP-Packets-Lost_FS2 | 131 |
| 108 | Acme-Called-RTP-Avg-Jitter_FS2 | 132 |
| 109 | Acme-Called-RTP-MaxJitter_FS2 | 133 |
| 110 | Acme-Called-Octets_FS2 | 124 |
| 111 | Acme-Called-Packets_FS2 | 125 |
| 112 | Acme-Session-Charging-Vector | 54 |
| 113 | Acme-Session-Charging-Function_Address | 55 |
| 114 | Acme-Firmware-Version | 56 |
| 115 | Acme-Local-Time-Zone | 57 |
| 116 | Acme-Post-Dial-Delay | 58 |
| 117 | Acme-Primary-Routing-Number | 64 |
| 118 | Acme-Originating-Trunk-Group | 65 |
| 119 | Acme-Terminating-Trunk-Group | 66 |
| 120 | Acme-Originating-Trunk-Context | 67 |
| 121 | Acme-Terminating-Trunk-Context | 68 |
| 122 | Acme-P-Asserted-ID | 69 |
| 123 | Acme-Ingress-Local-Addr | 74 |
| 124 | Acme-Ingress-Remote-Addr | 75 |
| 125 | Acme-Egress-Local-Addr | 76 |
| 126 | Acme-Egress-Remote-Addr | 77 |
| 127 | Acme-SIP-Diversion | 70 |
| 128 | Acme-Intermediate_Time | 63 |
| 129 | Acct-Session-Time | N/A |
| 130 | Acme-Egress-Final-Routing-Number | 134 |
| 131 | Acme-Session-Ingress-RPH | 135 |
| 132 | Acme-Session-Egress-RPH | 136 |
| 133 | Acme-Custom-VSA-200 | 200 |
| 134 | Acme-Custom-VSA-201 | 201 |
| 135 | Acme-Custom-VSA-202 | 202 |
| 136 | Acme-Custom-VSA-203 | 203 |
| 137 | Acme-Custom-VSA-204 | 204 |
| 138 | Acme-Custom-VSA-205 | 205 |
| 139 | Acme-Custom-VSA-206 | 206 |
| 140 | Acme-Custom-VSA-207 | 207 |
| 141 | Acme-Custom-VSA-208 | 208 |
| 142 | Acme-Custom-VSA-209 | 209 |
| 143 | Acme-Custom-VSA-210 | 210 |
| 144 | Acme-Custom-VSA-211 | 211 |
| 145 | Acme-Custom-VSA-212 | 212 |
| 146 | Acme-Custom-VSA-213 | 213 |
| 147 | Acme-Custom-VSA-214 | 214 |
| 148 | Acme-Custom-VSA-215 | 215 |
| 149 | Acme-Custom-VSA-216 | 216 |
| 150 | Acme-Custom-VSA-217 | 217 |
| 151 | Acme-Custom-VSA-218 | 218 |
| 152 | Acme-Custom-VSA-219 | 219 |
| 153 | Acme-Custom-VSA-220 | 220 |
| 154 | Acme-Custom-VSA-221 | 221 |
| 155 | Acme-Custom-VSA-222 | 222 |
| 156 | Acme-Custom-VSA-223 | 223 |
| 157 | Acme-Custom-VSA-224 | 224 |
| 158 | Acme-Custom-VSA-225 | 225 |
| 159 | Acme-Custom-VSA-226 | 226 |
| 160 | Acme-Custom-VSA-227 | 227 |
| 161 | Acme-Custom-VSA-228 | 228 |
| 162 | Acme-Custom-VSA-229 | 229 |
| 163 | Acme-Custom-VSA-230 | 230 |
| 164 | Acme-Flow-Calling-Media-Stop-Time_FS1 | 231 |
| 165 | Acme-Flow-Called-Media-Stop-Time_FS1 | 232 |
| 166 | Acme-Flow-Calling-Media-Stop-Time_FS2 | 233 |
| 167 | Acme-Flow-Called-Media-Stop-Time_FS2 | 234 |
| 168 | Acme-FlowMediaType_FS1_F | 142 |
| 169 | Acme-FlowMediaType_FS1_R | 143 |
| 170 | Acme-FlowMediaType_FS2_F | 144 |
| 171 | Acme-FlowMediaType_FS2_R | 145 |
| 172 | ACME-Access-Network-Information | 248 |
| 173 | Acme-CDR-Sequence-Number | 59 |