The following is a sample file layout for the CABWIRE.EXE program.
Program: CABWIRE.EXE
Data File: Can be any name conforming to the DOS 8.3 naming convention
Cable & Wireless Version 4.0 File Layout
File Type: Variable Length (tab-delimited)
Field Name Description (only fields in bold are converted)
----- ---------------- -----------------------------------------------
1 REQUESTOR-ACCT-NO Ignored
2 Account Number Ignored
3 Corporate Account Number Ignored
4 Period End Date Ignored
5 Traffic Type Ignored
6 Billable Number Ignored
7 Primary Service Type Ignored
8 Service Type Ignored
9 Usage Type Ignored
10 Account Code Client ID (no separator)
11 Primary Code Ignored
12 Secondary Code Ignored
13 Account Code Label Ignored
14 Account Code List ID Ignored
15 Call Date Tran Date (in mm/dd/yyyy format)
16 Call Time Ignored
17 Duration Ignored
18 Time of Day Code Ignored
19 Cost Tran Amount (in n.nn format)
20 Cost Before Custom Discounts Ignored
21 Custom Discount ID Ignored
22 Dedicated/Switched Ignored
23 Intracompany Indicator Ignored
24 Cellular Flag Ignored
25 IntraLATA Special Rate Ignored
26 IntraLATA Indicator Ignored
27 Precision Indicator Ignored
28 Payphone Surcharge Ignored
29 Surcharge Ignored
30 Real Time ANI Flag Ignored
31 FootNote Flag Ignored
32 Originating Number Ignored
33 Origination Category Ignored
34 Originating City Ignored
35 Originating Country Ignored
36 Originating Province Ignored
37 Originating State Ignored
38 Originating LATA Ignored
39 Incomplete TollFree Flag Ignored
40 TollFree Overflow Flag Ignored
41 Multi-Location Routing Flag Ignored
42 Routing City Ignored
43 Routing Number Ignored
44 Routing State Ignored
45 Terminating Number Tran Description (digits only - no dashes or parantheses)
46 Termination Category Ignored
47 Terminating City Tran Description (spelled out)
48 Terminating Country Ignored
49 Intrastate Termin. Indicator Ignored
50 Interstate Termin. Indicator Ignored
51 Terminating Province Ignored
52 Terminating State Tran Description (2 char abbreviation)
53 International Rate Band Ignored
54 Terminating LATA Ignored
55 Mileage Band Ignored
56 Enhanced Card Session ID Ignored
57 Passport TollFree Access Num. Ignored
58 Enhanced Card Traffic Type Ignored
59 Enhanced Card Sub-Traffic Type Ignored
60 Number of Fax Pages Ignored
61 Enhanced Card Job ID Ignored
62 Conf. Call ID Ignored
63 Conf. Call Number of Partic. Ignored
64 Conf. Call Feature Fees Ignored
65 Conf. Call Feature Type Ignored
66 Conf. Call Feature Quantity Ignored
67 Conf. Call Partic. ID Number Ignored
68 Conf. Call Partic. ID Oc. Num. Ignored
69 Conf. Call Partic. Name Ignored
70 Conf. Call Partic. Phone Num. Ignored
71 GIVN Billable Seconds Ignored
72 GIVN Data ID Ignored
73 GIVN Remote Access ID Ignored
74 GIVN Overflow Termination ID Ignored
75 GIVN Call Origination ID Ignored
76 GIVN Intl Termination ID Ignored
77 GIVN Country Code ID Ignored
78 GIVN LDN ID Ignored
79 GIVN Route ID Ignored
80 GIVN OnNet Termination ID Ignored
81 GIVN Virtual OnNet Termin. ID Ignored
82 GIVN Switched Termin. ID Ignored
83 GIVN Forced OnNet Termin. ID Ignored
84 GIVN Termin. Number Format Ignored
85 GIVN Termin. Area Code/Exch. Ignored
86 GIVN Location Code Ignored
87 Filler1 Ignored
88 Filler2 Ignored
89 Filler3 Ignored
90 Filler4 Ignored
Sample Cable & Wireless data file:
Notes:
1) The input file is a variable length, tab-delimited file. Since "tab"
characters appear as ordinary spaces on the screen, they were replaced with
the text <t> to make them obvious.
2) Since Cable & Wireless records are quite long, each record has been divided
into smaller sections by being wrapped to the next line and indented 5
spaces. "Actual" records in the real world would have 1 line per transaction
no matter how long they were.
3) The first line of every Cable & Wireless data file contains a list of "field
headers". This line contains 89 fields while all the "actual" records
contain 90 fields.
REQUESTOR-ACCT-NO<t>Account Number<t>Corporate Account Number<t>Period End Date<t>
Traffic Type<t>Billable Number<t>Primary Service Type<t>Service Type<t>
Usage Type<t>Account Code<t>Primary Code<t>Secondary Code<t>
Acount Code Label<t>Account Code List ID<t>Call Date<t>Call Time<t>
Duration<t>Time of Day Code<t>Cost<t>Cost Before Custom Discounts<t>
Custom Discount ID<t>Dedicated/Switched<t>Intracompany Indicator<t>
Cellular Flag<t>IntraLATA Special Rate<t>IntraLATA Indicator<t>
Precision Indicator<t>Payphone Surcharge<t>Surcharge<t>Real Time ANI Flag<t>
FootNote Flag<t>Originating Number<t>Origination Category<t>
Originating City<t>Originating Country<t>Originating Province<t>
Originating State<t>Originating LATA<t>Incomplete TollFree Flag<t>
TollFree Overflow Flag<t>Multi-Location Routing Flag<t>Routing City<t>
Routing Number<t>Routing State<t>Terminating Number<t>Termination Category<t>
Terminating City<t>Terminating Country<t>Intrastate Termination Indicator<t>
Interstate Termination Indicator<t>Terminating Province<t>
Terminating State<t>International Rate Band<t>Terminating LATA<t>
Mileage Band<t>Enhanced Card Session ID<t>Passport TollFree Access Number<t>
Enhanced Card Traffic Type<t>Enhanced Card Sub-Traffic Type<t>
Number of Fax Pages<t>Enhanced Card Job ID<t>Conference Call ID<t>
Conference Call Number of Participants<t>Conference Call Feature Fees<t>
Conference Call Feature Type<t>Conference Call Feature Quantity<t>
Conference Call Participant ID Number<t>
Conference Call Participant ID Occurrence Number<t>
Conference Call Participant Name<t>
Conference Call Participant Phone Number<t>GIVN Billable Seconds<t>
GIVN Data ID<t>GIVN Remote Access ID<t>GIVN Overflow Termination ID<t>
GIVN Call Origination ID<t>GIVN Intl Termination ID<t>GIVN Country Code ID<t>
GIVN LDN ID<t>GIVN Route ID<t>GIVN OnNet Termination ID<t>
GIVN Virtual OnNet Termination ID<t>GIVN Switched Termination ID<t>
GIVN Forced OnNet Termination ID<t>GIVN Terminating Number Format<t>
GIVN Terminating Area Code/Exchange<t>GIVN Location Code<t>Filler1<t>
Filler2<t>Filler3
XVA7000131<t>EVA3111145<t>XVA7000131<t>10/20/1999<t>5<t>8048470980 <t>
C<t>02<t>INFRM<t>228011500000 <t>228011500000 <t>NONE <t>
<t>AC000<t>10/01/1999<t>11:34:57<t>
0000000001.0<t> <t>00000000001.25<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>LYNCHBURG <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>7575556030 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>VA<t>000<t>0252<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA3111145<t>XVA7000131<t>10/20/1999<t>5<t>8048470980 <t>
C<t>02<t>INFRM<t>260115000000 <t>260115000000 <t>NONE <t>
<t>AC000<t>09/22/1999<t>16:15:01<t>
0000000001.0<t> <t>00000000001.40<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>LYNCHBURG <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>7135551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>TX<t>000<t>0560<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA3111145<t>XVA7000131<t>10/20/1999<t>5<t>8048473092 <t>
C<t>02<t>INFRM<t>220115000007 <t>220115000007 <t>NONE <t>
<t>AC000<t>10/07/1999<t>11:47:12<t>
0000000001.0<t> <t>00000000001.40<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>LYNCHBURG <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>4045551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>GA<t>000<t>0438<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA3111145<t>XVA7000131<t>10/20/1999<t>5<t>8048473092 <t>
C<t>02<t>INFRM<t>230115000007 <t>230115000007 <t>NONE <t>
<t>AC000<t>10/04/1999<t>15:22:16<t>
0000000001.0<t> <t>00000000001.25<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>LYNCHBURG <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>5405551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>VA<t>000<t>0244<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA3111145<t>XVA7000131<t>10/20/1999<t>5<t>8048473092 <t>
C<t>02<t>INFRM<t>252548005798 <t>252548005798 <t>NONE <t>
<t>AC000<t>09/30/1999<t>10:58:13<t>
0000000001.0<t> <t>00000000001.25<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>LYNCHBURG <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>5405551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>VA<t>000<t>0244<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA7111987<t>XVA7000131<t>10/20/1999<t>5<t>7574730072 <t>
C<t>02<t>INFRM<t>000115000000 <t>000115000000 <t>NONE <t>
<t>AC000<t>10/13/1999<t>13:28:17<t>
0000000001.0<t> <t>00000000001.40<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>NORFOLK <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>2155551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>PA<t>000<t>0228<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA7111987<t>XVA7000131<t>10/20/1999<t>5<t>7574730072 <t>
C<t>02<t>INFRM<t>062548000000 <t>062548000000 <t>NONE <t>
<t>AC000<t>09/24/1999<t>11:19:07<t>
0000000001.0<t> <t>00000000001.40<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>NORFOLK <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>3055551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>FL<t>000<t>0458<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA7111987<t>XVA7000131<t>10/20/1999<t>5<t>7574730072 <t>
C<t>02<t>INFRM<t>650115000000 <t>650115000000 <t>NONE <t>
<t>AC000<t>10/14/1999<t>15:59:07<t>
0000000001.0<t> <t>00000000001.25<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>NORFOLK <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>8045551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>VA<t>000<t>0248<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA7111987<t>XVA7000131<t>10/20/1999<t>5<t>7574730072 <t>
C<t>02<t>INFRM<t>660115000000 <t>660115000000 <t>NONE <t>
<t>AC000<t>10/01/1999<t>09:21:36<t>
0000000001.0<t> <t>00000000001.40<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>NORFOLK <t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>4105551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>MD<t>000<t>0238<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
XVA7000131<t>EVA7111987<t>XVA7000131<t>10/20/1999<t>5<t>7574991295 <t>
C<t>02<t>INFRM<t>062548000000 <t>062548000000 <t>NONE <t>
<t>AC000<t>09/21/1999<t>11:35:43<t>
0000000001.0<t> <t>00000000001.40<t>00000000.00<t>000000000000000000<t> <t>
<t>N<t>N<t> <t> <t>000.00<t>000.00<t> <t> <t>
<t>DOM<t>VIRGINIBCH<t> <t>
<t>VA<t> <t> <t> <t> <t> <t>
<t> <t>3055551212 <t>DOM<t>DIR ASST <t>
<t> <t> <t> <t>FL<t>000<t>0458<t>
00<t> <t> <t> <t> <t>0000000<t> <t>
000000000000000<t>000<t>000000.00<t> <t>000<t>000<t>00<t>
<t> <t>0000000<t> <t> <t> <t> <t>
<t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t> <t>
==================================================================================================
Cable & Wireless Version 2.0 File Layout
File Type: Fixed Length (record length = 258 bytes)
Note: Version 2.0 of the Cable & Wireless is an older format that is probably
not in use anymore. However, it is still supported by the CABWIRE.EXE interface
program in case it should ever be needed.
Note: The Cable & Wireless file that contains the logged telephone calls is a
dBase file that must be converted to a different format before the CABWIRE.EXE
program can use it. This is accomplished using a utility program provided by
Cable & Wireless called DAconvert. Refer to the Cable & Wireless documentation
for more information about running the DAconvert program.
Field Field Name Length Description (only fields in bold are converted)
----- ----------------------- ------ -----------------------------------------------
1 Client Account Number 10 Ignored
2 Call Rate Code 3 Ignored
3 Corporate Account 10 Ignored
4 Account Code 16 Client ID (no separator, zero padded on left)
5 Code Length 2 Ignored
6 Call Date 5 Tran Date (in mmddy format)
7 Call Time 6 Ignored
8 Call Duration 6 Ignored
9 Rate Type 2 Ignored
10 Call Cost 7 Tran Amount (in n.nn format, zero padded on left)
11 Jurisdiction Code 1 Ignored
12 Time Zone 1 Ignored
13 Call City/State 12 Tran Description (10 char city, 2 char state)
14 Call Source 1 Ignored
15 Demographic Code 1 Ignored
16 Originating Number 15 Tran Description (digits only, zero padded on left)
17 Alpha Name 30 Ignored
18 Travel Orig. Number 15 Ignored
19 Travel Orig. City/State 12 Ignored
20 Bill ID 2 Ignored
21 Travel Auth. Code 15 Ignored
22 Precision Code 2 Ignored
23 Intracompany Code 1 Ignored
24 Discount Code 1 Ignored
25 Routed 800 Number 15 Ignored
26 Global Zone ID 3 Ignored
27 Speed Dial Code 1 Ignored
28 Conference Code 15 Ignored
29 Conference Number 3 Ignored
30 Valet Service Code 1 Ignored
31 Conf. Prefile Code 2 Ignored
32 Conf. Tape Code 2 Ignored
33 Conf. One Way Code 2 Ignored
34 Conf. Sub Conf. Code 2 Ignored
35 Conf. Operator Code 2 Ignored
36 Blank 22 Ignored
37 EBIS Number 10 Ignored
38 Carriage Return 1 Ignored
39 Line Feed 1 Ignored
Sample Cable & Wireless data file:
Notes:
1) The first 3 lines are not part of the Cable & Wireless input file.
2) Each record has been divided into 4 separate sections (3 70 byte
sections followed by a 48 byte section) so the records won't be truncated
on the page.
3) The "[" and "]" characters have been added to illustrate where the carriage
return/line feed combination would appear in each record.
1 2 3 4 5 6 7
1234567890123456789012345678901234567890123456789012345678901234567890
----------------------------------------------------------------------
ECA9197055VF3ECA9197055000000000001000003100350123PM0001.3010000.10API
RVINE CAO 000007142521373
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000001010003092800315PM0013.3010001.80APS
ANBARBARACAO 000008056856893
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000001020003092950932AM0028.2010003.81APS
ANBARBARACAO 000008056856893
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000001030003100250412PM0015.1010002.04APS
ANBARBARACAO 000008056856893
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000002000103100650206PM0023.6010003.19APS
ANBARBARACAO 000008056856893
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000002000203100950232PM0000.5010000.07APS
ANBARBARACAO 000008056856893
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000002000303101050422PM0006.3010000.85APS
ANBARBARACAO 000008056856893
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000003000003101350308PM0000.5010000.07APS
ANBARBARACAO 000008056856893
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000004000003092850452PM0002.8010000.38APS
ANBARBARACAO 000008058932155
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]
ECA9197055VF3ECA9197055000000000004020003092950930AM0000.8010000.11APS
ANBARBARACAO 000008058932155
00000000055253303N 001N000000000000000
000 0000000000 C101650020[]