Billing / Invoicing
- Timothy Armstrong
Owned by Timothy Armstrong
If requested, a file will be provided with transaction 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 transaction 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) |
|
|
|
|