Documentation Index

Fetch the complete documentation index at: https://help.idibilling.com/llms.txt

Use this file to discover all available pages before exploring further.

IDI version 26.8 is now available.  Click here for details: IDI Updates.

DataExport_InvoiceTaxDetail

Prev Next

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