The InvoiceTaxDetail Data Export for the InvoiceTaxDetail table in Usage databases is available through the E-Support website. This data export will produce a zip file containing an ASCII file (.csv). This ASCII/csv file will contain the full contents of the InvoiceTaxDetail table from the selected usage database according to the standard InvoiceTaxDetail Data Export.
The file naming convention for the Invoice Tax Detail Export is as follows:
With date and time stamp:
ITD###_[CustID]_[ dbName]_yyyymmdd_HHMM.zip
ITD###_[CustID]_[ dbName]_yyyymmdd_HHMM.csv
Without date and time stamp:
ITD###_[CustID]_[ dbName].zip
ITD###_[CustID]_[ dbName].csv
The ### is a unique ID to denote which specific Data Export it is, and will be the same if the same Data Export is chosen.
“ITD103_” will be the file prefix if for the standard InvoiceTaxDetail Data Export
The table below indicates the exported record format for CostGuard Usage files according to the standard InvoiceTaxDetail Data Export.
InvoiceTaxDetail file format (ITD103)
Position | Field Name | Data Type | Length | Table |
1 | InvoiceTaxDetailID | int | 4 | InvoiceTaxDetail |
2 | InvoiceNumber | int | 4 | InvoiceTaxDetail |
3 | CustID | int | 4 | InvoiceTaxDetail |
4 | UsgSvcID | int | 4 | InvoiceTaxDetail |
5 | NonUsgSvcID | int | 4 | InvoiceTaxDetail |
6 | UsageTypeID | smallint | 2 | InvoiceTaxDetail |
7 | TaxChargeID | int | 4 | InvoiceTaxDetail |
8 | InvoiceCategoryID | int | 4 | InvoiceTaxDetail |
9 | OrigNPA | int | 4 | InvoiceTaxDetail |
10 | TermNPA | int | 4 | InvoiceTaxDetail |
11 | TaxID | int | 4 | InvoiceTaxDetail |
12 | SurchargeID | int | 4 | InvoiceTaxDetail |
13 | TaxableCharges | decimal | 9 | InvoiceTaxDetail |
14 | TaxableDuration | int | 4 | InvoiceTaxDetail |
15 | TaxRate | decimal | 9 | InvoiceTaxDetail |
16 | TaxAmount | decimal | 9 | InvoiceTaxDetail |
17 | TaxDue | decimal | 9 | InvoiceTaxDetail |
18 | AdjustmentID | int | 4 | InvoiceTaxDetail |
19 | TaxJurisID | int | 4 | InvoiceTaxDetail |
20 | ExemptCharges | decimal | 9 | InvoiceTaxDetail |
21 | NonTaxableCharges | decimal | 9 | InvoiceTaxDetail |
22 | TotalCharges | decimal | 9 | InvoiceTaxDetail |