Master TNB/Trilliant ↔ ADF Records
Master TNB/Trilliant List compare with ADF shipment Files. (assets.nested_serial_number) . and compare with INHE Master list of Warranty list & direct purchase. (tcm_records.serial_number).
Total ADF Records
282,900
ADF not in Master TNB
493
Total records Master TNB/Trilliant
282,936
Master TNB/Trilliant not in ADF Records
530
ADF records duplicates
2
Master TNB/Trilliant duplicates
0
2 Nested duplicate rows (1 serial) · No Master TNB serial duplicates .
Showing 50 of 493 Nested assets not in Master TNB . Join: assets.nested_serial_number = tcm_records.serial_number . Related: Records, Master TNB, Master Warranty, Cross check. Export builds a workbook in small chunks.
| Nested / serial | Meter serial | Class | Source file |
|---|---|---|---|
| NEQA4904275 | DPM1052307002114 | DDZ1513 | ADF_DT_DPM_L9_RF_1P_20230927_09.xml |
| NEQA4904276 | DPM1052312045521 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904277 | DPM1052312045532 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904278 | DPM1052510068660 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904280 | DPM1062312006729 | DTZ1513 | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904281 | DPM1052307002076 | DDZ1513 | ADF_DT_DPM_L9_RF_1P_20230927_09.xml |
| NEQA4904412 | DPM1052312045510 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904414 | DPM1052312045540 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904486 | DPM1052307000392 | DDZ1513 | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904531 | DPM1052312045592 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904569 | DPM1052312045572 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904570 | DPM1052312045523 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904571 | DPM1052510068659 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904572 | DPM1052307000085 | DDZ1513 | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904573 | DPM1052510068698 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904574 | DPM1052312045537 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904575 | DPM1062312006764 | DTZ1513 | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904576 | DPM1052307000061 | DDZ1513 | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904577 | DPM1052312045544 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904579 | DPM1052312045589 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904582 | DPM1052312045550 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904583 | DPM1052312045596 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904586 | DPM1062312006767 | DTZ1513 | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904588 | DPM1062312006783 | DTZ1513 | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904589 | DPM1052307002182 | DDZ1513 | ADF_DT_DPM_L9_RF_1P_20230927_09.xml |
| NEQA4904599 | DPM1052312045590 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904600 | DPM1052312045527 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904611 | DPM1052312045513 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904612 | DPM1062312006800 | DTZ1513 | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904627 | DPM1052312045518 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904631 | DPM1052510068664 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904633 | DPM1052510068694 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904634 | DPM1052510068647 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904636 | DPM1052307001136 | DDZ1513 | ADF_DT_DPM_L8_RF_1P_20230927_08.xml |
| NEQA4904637 | DPM1052312045570 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904638 | DPM1052312045517 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904639 | DPM1052312045528 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904640 | DPM1052510068671 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904642 | DPM1052312045539 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904643 | DPM1052312045563 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904644 | DPM1052510068695 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904646 | DPM1052312045533 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904647 | DPM1052312045580 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904648 | DPM1052312045545 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904649 | DPM1052307000372 | DDZ1513 | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904650 | DPM1052510068662 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904651 | DPM1052510068697 | DDZ1513 | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904653 | DPM1052312045591 | DDZ1513 | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904654 | DPM1062312006765 | DTZ1513 | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904655 | DPM1062312006790 | DTZ1513 | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |