If requested, a file will be provided with invoicing information. This file is normally delivered with the following naming convention in a .csv format:
eCardInvoice_ProgramID{}mmddyyyy{}mmddyyyy.csv
The first date is the start date of the invoice and second date is the end date.
Fields included in billing file
Field |
DataType |
Description |
SecurityCode |
GUID |
|
ProgramID |
INT |
|
InvoiceNumber |
VARCHAR(50) |
InstallerNet's invoice number for this invoice file. |
InvoiceDate |
DateTime |
The date of this invoicing information. |
TransactionID |
VarChar(14) |
|
TransactionType |
Char(1) |
|
CustomerFirstName |
VarChar(50) |
|
CustomerLastName |
VarChar(50) |
|
ReceiptNumber |
VarChar(50) |
|
PurchaseDate |
DateTime |
|
CardModel |
VarChar(20) |
|
DeliveryMethod |
Char(1) |
|
Cost |
Money |
|
LineItem |
INT |
|
InstallCardID |
VarChar(14) |
|
|
|
|