Main information of AFC data in Beijing Metro system
| Name | Description |
|---|---|
| CARD_SERIAL_NUMBER | Card ID (encrypted) |
| ENTRY_TIME | Tap-in time (year/month/day/hour/minute/second) |
| TRIP_ORIGIN_LOCATION | Boarding station ID |
| TXN_DATE_TIME | Tap-out time (year/month/day/hour/minute/second) |
| DEVICE_LOCATION | Alighting station ID |
| PRODUCT_ISSUER_ID | Card type, including E-card and one-way card |
| PRODUCT_TYPE | Card subtype, including ordinary card, senior card, student card etc. |
| PAYMENT_VALUE | Deduction amount |
| RECONCILIATION_DATE | Time for reconciliation of accounts |
| SETTLEMENT_DATE | Time for clearing currency receipts and payments |
| DEVICE_ID | Automatic fare gate ID |
| SOURCE_PARTICIPANT_ID | Operating company ID |
| Name | Description |
|---|---|
| CARD_SERIAL_NUMBER | Card ID (encrypted) |
| ENTRY_TIME | Tap-in time (year/month/day/hour/minute/second) |
| TRIP_ORIGIN_LOCATION | Boarding station ID |
| TXN_DATE_TIME | Tap-out time (year/month/day/hour/minute/second) |
| DEVICE_LOCATION | Alighting station ID |
| PRODUCT_ISSUER_ID | Card type, including E-card and one-way card |
| PRODUCT_TYPE | Card subtype, including ordinary card, senior card, student card etc. |
| PAYMENT_VALUE | Deduction amount |
| RECONCILIATION_DATE | Time for reconciliation of accounts |
| SETTLEMENT_DATE | Time for clearing currency receipts and payments |
| DEVICE_ID | Automatic fare gate ID |
| SOURCE_PARTICIPANT_ID | Operating company ID |
Source(s): Table by the authors