Skip to main content
Avalara Help Center

TM_00405_AFC Custom Sort Utility User Manual

Overview

The Custom Sort Utility is designed to allow clients to produce taxation reports which are sorted and summarized using client-specified fields and/or options. The utility is restricted to fields available in the AvaTax for Communications (AFC) transaction log, which can be affected by configuration settings in the EZtax.cfg.

This utility uses the AvaTax for Communications (AFC) API library.

AFC License

Command Line Usage

customsort -cfg customsort.cfg [-log logfile] [-data datapath] [-work workpath] [-ext extension] [-?]

Arguments

-cfg customsort.cfg : Required. Custom sort configuration to be used.

-log logfile* : EZTax log file to be processed (DEF: EZTax.log).

*The full path for the log file must be specified.

-data <path> : Data directory; overrides config file value.

-work <path> : Working directory; overrides config file value.

-ext <ext> : Result file extension without ‘.’; overrides reserved config file extension.

-summarize <sumfile> : Log file is summarized into sumfile. On large log files, this option can substantially speed up the sorting process.

-out <fname> : Output base filename; overrides config file. This option can be used when there is a need to set the output files from a script so that different sorts can share the same configuration file.

-? : Display usage and exit

Examples

customsort -cfg customsort.cfg

customsort -cfg customsort.cfg -log mylogfile.log

customsort -cfg customsort.cfg -log mylogfile.log -data path/to/data

customsort -cfg customsort.cfg -log mylogfile.log -work path/to/workingdirectory customsort -cfg customsort.cfg -log mylogfile.log -ext csv

customsort -cfg customsort.cfg -log mylogfile.log -summarize quicksort.log customsort -cfg customsort.cfg -log mylogfile.log -out mysort

Output (in working directory)

Taxation Reports - Sorted and summarized taxation reports per configuration options

Metrics Report - Custom sort processing metrics

Status file - Processing status and any errors that might have occurred

AFC SaaS Standard

Usage

The Custom Sort Utility can be called in AFC SaaS Standard to allow clients to produce taxation reports which are sorted and summarized using client-specified fields and/or options based on the transactions contained within the ftp.zip input file. The resulting report is a CSV file that can then be opened and edited within a spreadsheet program such as Microsoft Excel. In order for the custom sort feature to be applied, a configuration file – customsort.cfg – must be either be persisted in your account or embedded in the input zip file (ftp.zip) along with the transaction input file in the Extended AFC SaaS Standard format.

To make the Custom Sort Config file a persisted file, please contact communicationsupport@avalara.com for further assistance. Persisting the file is the preferred method of generating the Custom Sort report.

To embed the Custom Sort Config file, place the customsort.cfg file into the ftp.zip file along with an Extended Format input file.

AFC SaaS Standard Custom Sort Example

Sample customsort.cfg file
///////////////////////////////////////////////////////////////////////////////////// 
//// ext_srtcomma20l.cfg //// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: srtcomma20l 
FIELD: P_CODE 
FIELD: CUST_NO 
FIELD: INV_NO 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: HEADER 
CALCULATED_VALUE_PRECISION: 6 
DEFAULT_EXT: csv 
DELIMITER: ',' 
Sample input file with the base name KML150117AA.csv

Request Type

Date

BillTo Country ISO

BillTo State

BillTo County

BillTo Locality

BillTo Zip Code

Charge

Transaction Type

Service Type

Customer Number

Invoice Number

CalcTaxes

20160315

USA

FL

Brevard

Cocoa Beach

32931

50

19

6

Customer 1

987654

CalcTaxes

20160315

USA

FL

Brevard

Cocoa Beach

32931

15

19

50

Customer 1

123456

CalcTaxes

20160315

USA

CA

San Francisco

San Francisco

94102

50

13

6

Customer 2

4567890

CalcTaxes

20160315

USA

CA

San Francisco

San Francisco

94102

15

13

50

Customer 2

4567890

CalcTaxes

20160315

USA

NY

New York

New York

10001

50

16

6

Customer 3

1234

CalcTaxes

20160315

USA

NY

New York

New York

10001

25

16

36

Customer 3

5678

Output Files
EZtax_160405.rpt
    Custom Sort Processing Metrics
    ---------------------------------------------------------------------------
        Start Time : Tue Apr 05 10:53:57 2016
        End Time : Tue Apr 05 10:53:57 2016
    
    Taxes Input Metrics
    ---------------------------------------------------------------------------
        Records: 22 File: C:\BILLSOFTONLINE\KML\KML\EZTax\EZTax.log

    Taxes Output Metrics
    ---------------------------------------------------------------------------
        Summarized Records : 19 File: EZtax_160405_ssf.csv 
        Non-billable Records : 3 File: EZtax_160405_nba.csv 
        Non-compliance Records : 0 File: EZtax_160405_nca.csv 
        Total Summarized Records : 22
    ---------------------------------------------------------------------------
    End of Report

 

EZtax_160405_nca.csv

Country

State

County

Locality

TaxType

TaxLvl

TaxRate

TaxAmount

SaleAmt

ExemptAmt

AdjustmentAmt

NetTaxable

Minutes

Lines

PCode

CustNo

InvoiceNo

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EZtax_160405_nba.csv

Country

State

County

Loc ality

TaxType

TaxLvl

TaxRate

TaxAmount

SaleAmt

ExemptAmt

AdjustmentAmt

NetTaxable

Minutes

Lines

PCode

CustNo

Invoic eNo

USA

 

 

 

232

0

0.01635

0.303293

50

31.45

0

18.55

0

0

0

Customer 2

4567890

USA

 

 

 

235

0

0.01635

0.159167

15

5.265

0

9.735

0

0

0

Customer 1

123456

USA

 

 

 

235

0

0.01635

0.530558

50

17.55

0

32.45

0

0

0

Customer 1

987654

 

EZtax_160405_ssf.csv

Country

State

County

Loc ality

TaxType

TaxLvl

TaxRate

TaxAmount

SaleAmt

ExemptAmt

AdjustmentAmt

NetTaxable

Minutes

Lines

P Code

CustNo

Invoic eNo

USA

 

 

 

55

0

0.182

3.3761

50

31.45

0

18.55

0

0

0

Customer 2

4567890

USA

 

 

 

72

0

0.08

0.08

50

0

0

50

0

0

0

Customer 3

1234

USA

 

 

 

162

0

0.182

1.77177

15

5.265

0

9.735

0

0

0

Customer 1

123456

USA

 

 

 

162

0

0.182

5.9059

50

17.55

0

32.45

0

0

0

Customer 1

987654

USA

 

 

 

170

0

0.014167

0.014167

50

0

0

50

0

0

0

Customer 2

4567890

USA

 

 

 

226

0

0.00331

0.032223

15

5.265

0

9.735

0

0

0

Customer 1

123456

USA

 

 

 

226

0

0.00331

0.10741

50

17.55

0

32.45

0

0

0

Customer 1

987654

USA

FL

BREVARD

 

64

1

0.0492

0

15

15

0

0

0

0

539600

Customer 1

123456

USA

FL

BREVARD

 

64

1

0.0492

0

50

50

0

0

0

0

539600

Customer 1

987654

USA

FL

BREVARD

COCOA BEACH

14

1

0.0237

0.398255

16.803993

0

0

16.803993

0

0

540000

Customer 1

123456

USA

FL

BREVARD

COCOA BEACH

14

1

0.0237

1.327515

56.013309

0

0

56.013309

0

0

540000

Customer 1

987654

USA

FL

BREVARD

COCOA BEACH

64

3

0.0552

0

15

15

0

0

0

0

540000

Customer 1

123456

USA

FL

BREVARD

COCOA BEACH

64

3

0.0552

0

50

50

0

0

0

0

540000

Customer 1

987654

USA

FL

BREVARD

COCOA BEACH

160

1

0.0015

0.025206

16.803993

0

0

16.803993

0

0

540000

Customer 1

123456

USA

FL

BREVARD

COCOA BEACH

160

1

0.0015

0.08402

56.013309

0

0

56.013309

0

0

540000

Customer 1

987654

USA

NY

 

 

180

1

0.000975

0.048828

50.08

0

0

50.08

0

0

2502500

Customer 3

1234

USA

NY

 

 

180

1

0.000975

0.024375

25

0

0

25

0

0

2502500

Customer 3

5678

USA

NY

NEW YORK

NEW YORK

73

3

0.049025

2.58154

52.657618

0

0

52.657618

0

0

2604100

Customer 3

1234

USA

NY

NEW YORK

NEW YORK

73

3

0.049025

1.288809

26.288809

0

0

26.288809

0

0

2604100

Customer 3

5678

Output (in working directory)

Taxation Reports -

Compliance, non-compliance (as applicable) and non-billable (as applicable) custom sort reports located in the Report zip file. Examples: {output_filename_format}_ssf.csv, {output_filename_format}_nca.csv, {output_filename_format}_nba.csv

Note: {output_filename_format} is defined in customsort.cfg.

Metrics Reports -

Custom Sort report metrics located in the Report zip file.  Example: {output_filename_format}.rpt

Note: {output_filename_format} is defined in customsort.cfg.

AFC SaaS Pro

Usage

AFC SaaS Pro provides the ability to dynamically generate a custom report containing the transactional data available in the database for a specified timeframe. The general process is as follows:

  1. Invoke the CreateReport API in the web service. The ReportOptions parameter specifies which data to include in the report.
  2. The report is processed in the background. The resulting output file is placed in the designated client FTP folder where it can be downloaded. This process takes anywhere from 30-90 minutes to complete.
  3. Once the report has been generated and is ready for download, an email notification is sent to the email address(s) included in the ReportOptions.

Note: Prior to the first time executing the CreateReport API call, please notify communicationsupport@avalara.com. If not already established, an FTP account needs to be created and the FTP credentials provided.

Please refer to TM_00116_AFC SaaS Pro Telecom Developer Manual and TM_00117_AFC SaaS Pro SAU Developer Manual for further information.

Custom Sort Configuration Format/Options

General Rules / Notes

  • Configuration file should be in standard text file format.
  • You can use the slash-slash (“//”) string to indicate a comment
  • You must define, at a minimum, either the base format and/or fields to be reported.
  • If you specify the tax data directory, you do not need a filelocs.txt.
  • Fields will be sorted in the order they are listed in the configuration file.

Configuration Options

Token

Description

OUTPUT_FILENAME_FORMAT

Format to be used for output / reports

Values: Valid filename or supported pattern. Default is EZTax.

EXAMPLE:

OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d}

Pattern Desc Example
%d Day of the month (01-31) 19
%H Hour in 24h format (00-23) 14
%I Hour in 12h format (01-12) 05
%j Day of the year (001-366) 231
%m Month as a decimal number (01-12) 08
%M Minute (00-59) 55
%p AM or PM designation PM
%S Second (00-61) 02
%y Year, last two digits (00-99) 01
%Y Year 2012

 

BASE

The base format to be used.

Values (choose 1): Default value in BOLD.

NONE

SRTCOMMA20L

SRTCOMMA20L-P

SRTCOMMA20LD

EZLOGCUST

EZLOGCUSTPTS

EXAMPLE:

BASE: SRTCOMMA20L

OPTION

User supplied option.

Values (choose 1 per line): Default values in BOLD.

NBA_FILE | DISCARD_NBA_RECS | INCLUDE_NBA_RECS

NCA_FILE | DISCARD_NCA_RECS | INCLUDE_NCA_RECS

NO_DELETE_LOG | DELETE_LOG

NO_HEADER | HEADER

EXAMPLE:

OPTION: NBA_FILE OPTION: NCA_FILE OPTION: NO_DELETE_LOG OPTION: HEADER

 

Note: Please be aware that NO_DELETE_LOG | DELETE_LOG only applies to AFC License clients. AFC SaaS Standard clients must set this option to NO_DELETE_LOG3.

ALGORITHM

Algorithm for calculating net taxable sale amount. 

Values (choose 1): Default value in BOLD.

SRTCOMMA20L

SRTCOMMA20LD

ALLOW_NEG_NET

EXAMPLE:

ALGORITHM: SRTCOMMA20L

CALCULATED_VALUE_PRECISION

Precision to be used in reports for calculated floating point.

Values: 0 – 6 (Default is 6)

EXAMPLE:

CALCULATED_VALUE_PRECISION: 2

DEFAULT_EXT

Precision to be used in reports for calculated floating point.

Values: valid file alpha numeric extension. Default is ssf.

EXAMPLE:

DEFAULT_EXT: ssf

Note: Please be aware that this default value only applies to AFC License clients. AFC SaaS Standard clients must use CSV file format3.

DATA_DIR

Directory specify where the EZtax data resides.

If this value is not set, then the file filelocs.txt must exist.

VALUES: valid directory specification. There is no default.

EXAMPLE (windows):

DATA_DIR: C:\BillSoft\EZTax\Data

EXAMPLE (unix/linux):

DATA_DIR: /home/EZtax/install/db

WORKING_DIR

Working directory for custom sort.

VALUES: valid directory specification. There is no default.

EXAMPLE (windows):

WORKING _DIR: E:\BillingApp\Working

EXAMPLE (unix/linux):

DATA_DIR: /home/BillingApp/Working

Configuration Fields for Sorting/Reporting

Token

Description

FIELD or NORPT

Usage of FIELD will be used both in the sort and the report output. Specifying NORPT will use the field in the sort be exclude it from the report.

 

Values

Description

P_CODE

Jurisdiction code used by EZtax (numeric)

ADDRESS

Country, State, County, Locality (alpha). Sort will be on PCode value.

TRANS_TYPE1

Transaction type (numeric)

SRV_TYPE1

Service Type (numeric)

TAX_TYPE

Tax Type (numeric)

TAX_TYPE_DESC

Tax Type Description (alpha). Sort will be on numeric value.

TAX_CATEGORY

Tax Category (numeric)

TAX_CATEGORY_DESC

Tax Category Description (alpha). Sort will be on numeric value.

TAX_LEVEL

Tax Level (numeric)

TAX_LEVEL_DESC

Tax Level Description (alpha). Sort will be on numeric value.

TAX

Tax Rate (numeric)

TAX_AMOUNT

Tax Amount (numeric)

SALE_AMT

Sale Amount (numeric)

EXEMPT_SALE_AMT

Exempt Sale Amount (numeric)

REFUND_UNCOLLECT

Adjustment (numeric)

NET_TAXABLE

Net Taxable Amount (numeric)

MINUTES

Minutes (numeric)

INV_NO

Invoice Number (numeric)

SRV_LVL_NO

Service Level Number (numeric)

OPTIONAL

Optional Field (numeric)

LINES

Lines (numeric)

LOCATIONS

Locations (numeric)

CALC_TYPE

Calculation Type (numeric)

CALC_TYPE_DESC

Calculation Type Description (alpha). Sort will be on numeric value.

BILLABLE

Tax is Billable Flag (numeric: 1=True, 0=False)

COMPLIANCE

Whether tax should be filed or retained (numeric: 1=True, 0=False)

CUST_NO

Customer Number (alpha – max 20 bytes)

ADJ_TYPE

Adjustment Type (numeric)

ADJ_TYPE_DESC

Adjustment Type Description (alpha). Sort will be on numeric value.

EXEMPT_TYPE

Exemption Type (numeric)

EXEMPT_TYPE_DESC

Exemption Type Description (alpha). Sort will be on numeric value.

SURCHARGE_FLAG

Surcharge Flag (numeric: 1=True, 0=False)

LOG_COUNTER

Log Counter (numeric)

OPT_ALPHA_12

Optional Field (alpha)

COMPANY_IDENTIFIER2

Company Identifier (alpha)

OPT_42

Optional 4 (numeric)

OPT_52

Optional 5 (numeric)

OPT_62

Optional 6 (numeric)

OPT_72

Optional 7 (numeric)

OPT_82

Optional 8 (numeric)

OPT_92

Optional 9 (numeric)

OPT_102

Optional 10 (numeric)

1 Only can be used if configuration option [logtransserv=true] is set. AFC SaaS Standard clients must contact communicationsupport@avalara.com for assistance with configuration options.

2 Only can be used if configuration option [loglength=long] is set. AFC SaaS Standard clients must contact communicationsupport@avalara.com for assistance with configuration options.

3 AFC SaaS Standard clients with a persisted customsort.cfg file must contact communicationsupport@avalara.com for assistance with configuration options.

Appendix A – Samples

For further information on the base format samples provided within this section, please reference the documents identified in the table below.

Base Format

Document Name

srtcomma20l

TM_00523_srtcomma20l

srtcomma20ld

TM_00524_srtcomma20ld

ezlogcust

TM_00513_ezlogcust

ezlogcustpts

TM_00515_ezlogcustpts

Note: These additional documents are located in the monthly distribution package.

Sample Configuration Files

Base Format: srtcomma20l

Example that will produce ssf/nba/nca in the same format as srtcomma20l utility.

///////////////////////////////////////////////////////////////////////////////////// 
//// base_srtcomma20l.cfg //// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: srtcomma20l 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: NO_HEADER 
CALCULATED_VALUE_PRECISION: 6 
DEFAULT_EXT: ssf 
DELIMITER: ',' 
DATA_DIR: C:\BillSoft\EZTax\Data 
WORKING_DIR: E:\Logs\customsort 

Base Extended Format: srtcomma20l

Example that will produce ssf/nba/nca similar to srtcomma20l, but with the jurisdiction Address, Company Identifier and Invoice Number added to the report, and a column header row added. Additional, all calculated values will be rounded to 2 decimal places.

///////////////////////////////////////////////////////////////////////////////////// 
//// ext_srtcomma20l.cfg //// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: srtcomma20l 
FIELD: ADDRESS 
FIELD: COMPANY_IDENTIFIER 
FIELD: INV_NO 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: HEADER 
CALCULATED_VALUE_PRECISION: 2 
DEFAULT_EXT: ssf 
DELIMITER: ',' 
DATA_DIR: C:\BillSoft\EZTax\Data 
WORKING_DIR: E:\Logs\customsort 

Base Format: srtcomma20l-p

Example that will produce ssf/nba/nca in the same format as srtcomma20l with the -p cmd line option.

///////////////////////////////////////////////////////////////////////////////////// 
//// base_srtcomma20l_p.cfg //// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: srtcomma20l-p 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: NO_HEADER 
CALCULATED_VALUE_PRECISION: 6 
DEFAULT_EXT: ssf 
DELIMITER: ',' 
DATA_DIR: C:\BillSoft\EZTax\Data 
WORKING_DIR: E:\Logs\customsort 

Extended Format: srtcomma20l-p

Example that will produce ssf/nba/nca similar to srtcomma20l with the –p cmd line option, but with Pcode, Company Identifier and Invoice Number added to the report, and a column header row added. Additional, all calculated values will be rounded to 2 decimal places.

///////////////////////////////////////////////////////////////////////////////////// 
//// ext_srtcomma20l_p.cfg //// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: srtcomma20l 
FIELD: P_CODE 
FIELD: COMPANY_IDENTIFIER 
FIELD: INV_NO 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: HEADER 
CALCULATED_VALUE_PRECISION: 2 
DEFAULT_EXT: ssf 
DELIMITER: ',' 
DATA_DIR: C:\BillSoft\EZTax\Data 
WORKING_DIR: E:\Logs\customsort 

Base Format: srtcomma20ld

Example that will produce ssf/nba/nca in the same format as the srtcomma20ld utility.

///////////////////////////////////////////////////////////////////////////////////// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: srtcomma20ld 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: NO_HEADER 
CALCULATED_VALUE_PRECISION: 6 
DEFAULT_EXT: ssf 
DELIMITER: ',' 
DATA_DIR: C:\BillSoft\EZTax\Data 
WORKING_DIR: E:\Logs\customsort 

Base Format: ezlogcust

Example that will produce reports in the same format as the ezlogcust utility.

///////////////////////////////////////////////////////////////////////////////////// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: ezlogcust 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: NO_HEADER 
CALCULATED_VALUE_PRECISION: 6 
DEFAULT_EXT: rpt 
DELIMITER: ',' 
DATA_DIR: C:\BillSoft\EZTax\Data 
WORKING_DIR: E:\Logs\customsort 

Base Format: ezlogcustpts

Example that will produce reports in the same format as the ezlogcustpts utility.

///////////////////////////////////////////////////////////////////////////////////// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: ezlogcustpts 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: NO_HEADER 
CALCULATED_VALUE_PRECISION: 6 
DEFAULT_EXT: rpt 
DELIMITER: ',' 
DATA_DIR: C:\BillSoft\EZTax\Data 
WORKING_DIR: E:\Logs\customsort 

Fully Defined Format: srtcomma20l-p

Example of a fully defined configuration file that will produce reports in the format of srtcomma20l with the -p cmd line option. Similar to srtcomma20l, this sample uses filelocs.txt and deletes the log when complete.

///////////////////////////////////////////////////////////////////////////////////// 
//// srtcomma20l_p.cfg //// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: none 
FIELD: ADDRESS 
FIELD: TAX_TYPE 
FIELD: TAX_LEVEL 
FIELD: TAX 
FIELD: TAX_AMOUNT 
FIELD: SALE_AMT 
FIELD: EXEMPT_SALE_AMT 
FIELD: REFUND_UNCOLLECT 
FIELD: NET_TAXABLE 
FIELD: MINUTES 
FIELD: LINES 
NORPT: BILLABLE 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: DELETE_LOG 
OPTION: NO_HEADER 
CALCULATED_VALUE_PRECISION: 6 
DEFAULT_EXT: ssf 
DELIMITER: ',' 

Fully Define Format: ezlogcust

Example of a fully defined configuration file that will produce reports in the format of ezlogcust. Similar to ezlogcust, this sample uses filelocs.txt and deletes the log when complete.

Note that CUST_NO leads off the list as a NORPT and appears again at the end of the list as a FIELD. This is to mimic the ezlogcust functionality that used the customer number as the first item in the sort, but output it as the last column in the report.

///////////////////////////////////////////////////////////////////////////////////// 
//// ezlogcust.cfg //// 
OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} 
BASE: none 
NORPT: CUST_NO 
FIELD: ADDRESS 
FIELD: TAX_TYPE 
FIELD: TAX_LEVEL 
FIELD: TAX 
FIELD: CALC_TYPE_DESC 
FIELD: TAX_AMOUNT 
FIELD: SALE_AMT 
FIELD: EXEMPT_SALE_AMT 
FIELD: REFUND_UNCOLLECT 
FIELD: NET_TAXABLE 
FIELD: MINUTES 
FIELD: LINES 
FIELD: LOCATIONS 
NORPT: BILLABLE 
FIELD: CUST_NO 
OPTION: NBA_FILE 
OPTION: NCA_FILE 
OPTION: NO_DELETE_LOG 
OPTION: NO_HEADER 
CALCULATED_VALUE_PRECISION: 6 
DEFAULT_EXT: rpt 
DELIMITER: ',' 
  • Was this article helpful?