Skip to main content
Avalara Help Center

TM_00510_CDF20

AvaTax for Communications (AFC) Telephone Rating System

CLIENT INPUT DATA SPECIFICATION

Data Description

Type

Len

Positions

Defaults

Note

Origin

N

10

1-10

 

Originating NPANXX if flag=N

Originating P-code if flag=P

Originating State code if flag=S (numeric value)

Origin Flag

A

1

11

 

Set to N if using NPANXX, P if using P-code, or S if using State code

Termination

N

10

12-21

 

Terminating NPANXX if flag=N

Terminating P-code if flag=P

Terminating State code if flag=S (numeric value)

Termination Flag

A

1

22

 

Set to N if using NPANXX, P if using P-code, or S if using State code

Service Address

N

10

23-32

 

Service (BTN) NPANXX if flag=N

Service P-code if flag=P

Service State code if flag=S (numeric value)

Service Address Flag

A

1

33

 

Set to N if using NPANXX, P if using P-code, or S if using State code

Customer Type

A

1

34

B

B = Business; R = Residential; I = Industrial; S = Senior Citizen

Invoice Date

N

8

35-42

 

Format "CCYYMMDD"

Taxable Amount Sign

A

1

43

 

Format "+" , "-", “p” or ‘m”

Taxable Amount

N

11.5

44-54

 

Format "99999999999" Zero-Filled, 5 decimal places, no decimal point

Lines

N

6

55-60

0

6-character integer

Location

N

6

61-66

0

6-character integer

Transaction Type

A/N

6

67-72

 

See Table of Transaction Types and Service Types

Service Type

A/N

6

73-78

 

See Table of Transaction Types and Service Types

Client Resale Flag

A

1

79

S

Call subject to Sale or Resale

Inc-Code

A

1

80

I

Customer is Inside or Outside an incorporated city area

Fed. Exempt

A

1

81

Blank

Call is eXempt from Federal taxes (X or blank)

State Exempt

A

1

82

Blank

Call is eXempt from State taxes (X or blank)

County Exempt

A

1

83

Blank

Call is eXempt from County taxes (X or blank)

Local Exempt

A

1

84

Blank

Call is eXempt from Local taxes (X or blank)

Primary Output Key

A/N

20

85-104

 

Defines primary Key for Client Summary Data

Regulated / Unregulated Flag

A

1

105

R

Reseller is Regulated or Unregulated in the state of sale

Call Duration (in minutes)

N

11.1

106-116

 

Format "99999999999" Zero-Filled, 1 decimal place, no decimal point

Telecom Type

A

1

117

C

C - Calls, D-Debit Card Calls, P-Point of sale

Service Class Indicator

A

1

118

L

D = Primarily Long Distance, L = Primarily Local

Lifeline Flag

A

1

119

N

L = Lifeline customer, N = Non-Lifeline

Facilities Based Flag

A

1

120

N

F = Facilities based, N = Non-Facilities based

Franchise Bases Flag

A

1

121

N

F = Franchise based, N = Non-Franchise based

Business Class Indicator

A

1

122

I

C = CLEC, I = ILEC

File Record Length*

 

 

122

 

 

* Each record Must terminate with a CR(ASCII 13) and LF(ASCII 10) located at positions 122 and 123 respectively.

Do not append an end-of-file character (ASCII 26) to the end of the Client Input Data File.

  • Was this article helpful?