Transcription
Billing Consolidator - EDS File SpecificationsEDS LayoutThe Enhanced Data Stream file format supports customers need to analyze or distributed invoice details withintheir organizations. The output includes all bill payers (invoices) within the agency per the hierarchy.The EDS file is formatted as ASCII text with pipe-delimited fields. The various record types are identified by atwo-character key at the beginning of each record.Notes1. In this document, “Display BTN” means the value that is used as an invoice grouping within the invoice. Itmay include Billing Telephone Numbers, Circuit Numbers, Subaccount Numbers, Site IDs, etc and iscontrolled within the hierarchy management function.2. Data Type Specificationsa. Integer fields have values ranging from 0 to 2,147,483,647.b. Decimal fields are specified with two numbers: total number of digits, and number of digits to theright of the decimal point. For example, “decimal 12,2” allows for 12 total digits, 10 to the left ofthe decimal point, and 2 to the right.c.Char fields are single-byte ASCII characters. There can be 0 to (Max Size) characters in thefield.d. Dates are listed as “char” types, with length 8; all dates are formatted as MMDDYYYY.00 – Header InformationThis record contains the Remittance Information. There is one ‘00’ Header record for each Bill Payer (BAN)associated with the Agency for which the file is generated.Field #12345678910DescriptionRecord Type ‘00’Bill Run IDBilling CycleBill Date (MMDDYYYY)Remittance NameRemittance Address Line 1Remittance Address Line 2Remittance CityRemittance StateRemittance harMax Size21010840505030210Sample Data00194617612252014AT&TPO BOX 9011Carol StreamIL60197-901101 – Bill Payer InformationThe Bill Payer Information contains one record per Bill Payer (BAN), with information about the bill payer and thebilling date. The ‘01’ record type indicates the beginning of the records for a given Bill Payer.Field #123DescriptionRecord Type ‘01’Bill Payer (BAN)Billing CycleVer: 4.4Updated: 03/16/16TypecharcharintegerMax Size21310Sample Data019390012345176Page 1 of 9
Billing Consolidator - EDS File Specifications4567891011121314Bill Date (MMDDYYYY)Invoice NumberBill Payer NameATTNBill Payer Address 1Bill Payer Address 2Bill Payer CityBill Payer State CodeBill Payer ZipBill Period Start Date(MMDDYYYY)Bill Period End harchar81030305050302108122020148054307STATE AGENCYFRED SMITHSUITE 100123 STATE 2 – Invoice SummaryThe Invoice Summary totals and balance information. There is one record for each Bill Payer (BAN).Field #12345678910111213141516DescriptionRecord Type ‘02’Bill Payer (BAN)Bill Date (MMDDYYYY)Invoice NumberPrevious BalancePaymentsAdjustmentsCurrent ChargesTotal DueMonthly Recurring ChargesNon-Recurring and ProratedChargesUsage ChargesTaxesSurchargesDue Date (MMDDYYYY)Late Fee Date imaldecimaldecimaldecimaldecimalMax aldecimalcharchar12,212,212,288Sample 4.5334.899.85-0.010.325.81122020141231201403 – Payments/General AdjustmentsThe Payments/General Adjustments contain all the Bill Payer (BAN) Payments and Adjustments records. Theremay be multiple records per Bill Payer (BAN)Field #1234567DescriptionRecord Type ‘03’Bill Payer (BAN)Invoice NumberBilling CycleBill Date (MMDDYYYY)AmountAccount Number(939nnnnnnn)Ver: 4.4Updated: ax Size2131010812,215Sample 2345Page 2 of 9
Billing Consolidator - EDS File Specifications8Descriptionchar8091011Reference NumberDate (MMDDYYYY)Type (“P” – Payment, “A” –Adjustment)charcharchar3081Payment received, Thankyou04/19/201304192013P04 – Display BTN InformationThe Display BTN section reports Display BTN with billed charges in the invoice. There is one record per DisplayBTN.Field #123456DescriptionRecord Type ‘04’Bill Payer (BAN)Display BTNBilling CycleBill Date (MMDDYYYY)Display BTN Name/AddressTypecharcharcharintegercharcharMax Size2135010850Sample Data049390012345555765432111117612202014CUSTOMER 123 CALNET05 – Monthly Summary by Bill Payer (BAN)The Monthly Summary by BAN contains one record per Display BTN, with a summary of charges by category.Field #123456789101112DescriptionRecord Type ‘05’Bill Payer (BAN)Display BTNBilling CycleBill Date (MMDDYYYY)AdjustmentsMonthly Recurring ChargesNon-Recurring and ProratedChargesUsage ChargesTaxesSurchargesInvoice imalMax ger12,212,212,210Sample .85-0.010.325.819964307*Please note: Monthly Recurring Charges displays with 2 digits after the decimal, but will be reformatted in 2016to display 4 digits after the decimalVer: 4.4Updated: 03/16/16Page 3 of 9
Billing Consolidator - EDS File Specifications06 –AdjustmentsThe Adjustments contain one record for each prior-period adjustment included in the billing period.Field #123456789101112DescriptionRecord Type ‘06’Display BTNTypecharcharCircuit ID/ WTNBilling CycleBill Period (MMDDYYYY)Provider NameReference NumberFrom Date (MMDDYYYY)To Date (MMDDYYYY)DescriptionAmountInvoice tegerMax Size250301082030888012,210Sample 507 – Monthly Recurring DetailThe Monthly Recurring Detail record details monthly service charges by line or circuit. The file may contain manyrecords for each line and/or circuit.Field #123456789DescriptionRecord Type ‘07’Display BTNQuantityFeature NameTypecharcharintegercharMax Size2501080Product IDBill Period (MMDDYYYY)ChargeInvoice NumberCircuit ID/ WTNcharchardecimalintegerchar7812,4*1030Sample Data0755576543211111Measured Rate ease note: Charge displays with 2 digits after the decimal, but will be reformatted in 2016 to display 4 digitsafter the decimal08 – Inbound Call DetailThere is one Inbound Call Detail record for each Toll Free Usage item billed during the billing periodField #123456DescriptionRecord Type ‘08’Display BTNCall Date(MMDDYYYY)Call Time (HH:mm)Call Duration (Total Seconds)From NumberVer: 4.4Updated: 03/16/16TypecharcharcharcharintegercharMax Size250881015Sample Data0818696586633330723201412:062054587154948Page 4 of 9
Billing Consolidator - EDS File Specifications7891011121314151617181920From PlaceTo NumberTo PlaceCall Type CodeUsage Type CodeCall CountUsage ProviderWorking Telephone NumberProvider NameRate PeriodContractProduct IDTotal ChargeInvoice N NJ8005555397MAYBURY NJTFRR1ATTLD8005555397AT&TDayYUSGLT123.45858393109 – Outbound Call DetailThere is one Outbound Call Detail record for each billed usage charge not identified as Toll Free (see type 08) orLocal (type 10).Field d Type ‘09’Display BTNCall Date (MMDDYYYY)Call Time (HH:mm)Call Duration (Total Seconds)Total ChargeFrom NumberFrom PlaceTo NumberTo PlaceCall Type CodeUsage Type CodeAccount CodeCall CountUsage ProviderWorking Telephone NumberProvider NameRate PeriodFrom StateTo StateInvoice ntegerMax Size250881012,21510151022251020152032210Sample KY858393110 – Zone 1 & 2 Usage SummaryThis contains one record of aggregated Local Usage Detail per Invoice / Display BTN / WTN.Field #1DescriptionRecord Type ‘10’Ver: 4.4Updated: 03/16/16TypecharMax Size2Sample Data10Page 5 of 9
Billing Consolidator - EDS File Specifications234567Display BTNTotal Number of CallsTotal Number of Minutes(listed in seconds)Total AmountInvoice NumberWorking Telephone 11 – TaxesTax records are provided at the Display BTN level; there can be multiple Tax records for a Display BTN.Field #12345678DescriptionRecord Type ‘11’Display BTNProvider NameDescription x Size250201080AmountTax CodeInvoice Numberdecimalcharinteger12,2710Sample Data115557654321111AT&T5967Universal LifelineTelephone ServiceSurcharge0.131234567996430712 – SurchargesSurcharges are detailed at the Display BTN level; there can be multiple Surcharge records for a Display BTN.Field #12345678DescriptionRecord Type ‘12’Display BTNProvider NameDescription x Size250201080AmountTax CodeInvoice Numberdecimalcharinteger12,2710Ver: 4.4Updated: 03/16/16Sample Data125557654321111AT&T2794Federal Subscriber LineCharge4.5912345679964307Page 6 of 9
Billing Consolidator - EDS File Specifications13 – Non Recurring ChargesThese are the Non-Recurring and Prorated Charges; there will be one record for each non-recurring or proratedcharge during the billing period.Field #123456DescriptionRecord Type ‘13’Display BTNProvider NameProduct IDQuantityFeature NameTypecharcharcharcharintegercharMax Size250207101007891011121314From date MMDDYYYYTo date MMDDYYYYSR NumberMonthly RateOne Time ChargeProrated ChargesTotal ChargesInvoice ger882412,212,212,212,21015Circuit ID/ WTNchar50Sample Data135557654321111AT&T9PZLM1Rate Change FederalUniversal Service Fee 964307916555121214 – CSR DetailField #1234567891011121314DescriptionRecord Type ‘14’Display BTNCircuit ax Size250301060CityContractFIDNodeProduct IDFeature nameChargeBill Period (MMDDYYYY)Invoice 130478012,2810Ver: 4.4Updated: 03/16/16Sample Data14471555343574132HCQS000555-001PT0123 CALNET STREETFLR 2 RM FSOMETOWNYOOBA02NCI04CX90.001223201494306642Page 7 of 9
Billing Consolidator - EDS File SpecificationsCode valuesUsage TypeCode DescriptionACAudio ConferencingCCCalling CardCNCanadaDADirectory AssistanceDODomesticEAInterLATAECExpress Call Completion stateINInternationalLOLocalLTLocal erLATARRIntralataTFToll FreeVCVideo ConferenceWCWebmeeting ConferenceZ1Local Zone 1 & 2Z3Local Zone 3Call TypeCode DescriptionABAutomated Billing ServiceACAudio ConferencingCFConference FeatureCLCollectCPCaller PaidCSCasual CallingDLAT&T Digital LinkVer: 4.4Updated: 03/16/16Page 8 of 9
Billing Consolidator - EDS File SpecificationsDSDial StationELSDN Easylink ServicesMTMobile TerminatedOCOperator Completed with Dial Rate AppliedOSOperator StationPCPerson Call BackPRPersonRMNetwork Remote AccessSDSoftware Defined Data NetworkSTStationTFToll FreeVCVideo TeleconferenceRate PeriodCode Multi PeriodMidLate gularSpcSpecial IntrastateStdStandardWkdWeekendVer: 4.4Updated: 03/16/16Page 9 of 9
4 Feature Name char 80 Measured Rate Business Service 5 Product ID char 7 1MB 6 Bill Period (MMDDYYYY) char 8 12022014 7 Charge decimal 12,4* 8.60 8 Invoice Numbe
