NEC (LAN Flexible Format Variable Length). SMDR/CDR data format and connection settings

This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not applicable for other software titles.

DescriptionData typeColumn name
Call typestringCALL_TYPE
Fusion Point CodeintegerFLAG1
Route + TrunkstringTRUNK
Logical Outgoing RoutestringLOGICAL_ROUTE
Calling party typestringFLAG2
Tenant numberstringFLAG3
Calling partystringEXT
Call timedatetimeCALL_TIME
Call time enddatetimeCALL_TIME_END
Call duration (s)integerCALL_DURATION_S
Condition codestringFLAG4
Caller numberstringCALLER_PHONE
Fusion Point Code of Calling PartystringFPC_CALLING_PARTY
Fusion User Group Number of Calling PartystringUSER_GROUP
Called Party IdentificationstringCALLED_PARTY_ID
Fusion Point Code that was usedstringFPC_USED
Fusion Point Code which was first selectedstringFPC_FIRST
Logical Route Number that was usedstringLOG_ROUTE_USED
Logical Route Number which was first selectedstringLOG_ROUTE_FIRST
Office Code of Calling PartystringOFFICE_CODE_CALLING
Office Code of Billing Process OfficestringOFFICE_CODE_BILLED
Selected routestringFLAG6
First routestringFLAG7
Metering pulsesintegerPULSES
Authorization codestringAUTH
Charge unitstringCHARGE_UNIT
Cost (in basic units)floatCOST
ATT Billing Report IndicationstringATT_BILLING_IND
Billing Report ATT NumberstringATT_BILLING_REPORT_NUM
Data IdentificationstringDATA_ID
Calling Party Number or ANI Presentation IdentifierstringDATA_FLAG
Converted NumberstringCONV_NUM
Department CodestringDEPT_CODE
Calling Party Number or ANIstringANI
Calling Party Multi-Area IDstringCALLING_PARTY_MA_ID
Seized Route MA-IDstringROUTE_MA_ID

Note: Products and companies mentioned here are used only for definition and identification purposes and can be trademarks and/or registered trademarks of the respective companies.