AvaTax for Communications 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 submit a support case 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:
- Invoke the CreateReport API in the web service. The ReportOptions parameter specifies which data to include in the report.
- 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.
- 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 submit a support case. 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}
|
|||||||||||||||||||||||||||||||||
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 submit a support case for assistance with configuration options.
2 Only can be used if configuration option [loglength=long] is set. AFC SaaS Standard clients must submit a support case for assistance with configuration options.
3 AFC SaaS Standard clients with a persisted customsort.cfg file must submit a support case 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 |
|
srtcomma20ld |
|
ezlogcust |
|
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: ','