This document aims to provide a guide for the mapping of the different models used in the different platforms so that we can create more effective communications between products.
AlarmBiller
aCustomer
The aCustomer is a particular billable entity.
Overview
| Property | Description | Type |
|---|---|---|
CustomerId |
Primary Key | integer |
MasterCustomerId |
Foreign Key to Master Customer | integer (nullable) |
MasterCustomer |
A Master Customer is a customer that has some financial responsibility over the customer. | aCustomer |
DealerId |
(Not Used) | integer (nullable) |
EntityId |
(Not Used) | integer |
PartnerProgramId |
integer (nullable) |
|
CustomerNumber |
string (max length 15) |
|
CustomerStatusId |
Foreign Key to Customer Status (rCustomerStatus) |
integer |
CustomerTypeId |
Foreign Key to Customer Type (rCustomerType) |
integer |
EmployeeId |
The Salesperson. Foreign Key to Employee (aEmployee) |
integer |
TermId |
Foreign Key to Billing Term (rTerm) |
integer |
NoLateFees |
boolean |
|
NoStatements |
boolean |
|
LastStatementDate |
date (nullable) |
|
InvoiceDeliveryMethodId |
Foreign Key to Delivery Method (rInvoiceDeliveryMethod) |
integer |
CustomerSince |
date |
|
IsBusiness |
boolean |
|
SuppressRecurringInvoiceDelivery |
boolean |
|
FirstName |
string |
|
LastName |
string |
|
Address1 |
string |
|
Address2 |
string |
|
City |
string |
|
State |
string |
|
ZipCode |
string |
|
Plus4 |
string |
|
Phone1 |
string |
|
Phone1Ext |
string |
|
CellPhone |
string |
|
Email |
string |
|
Comments |
string |
|
ShowOpenInvoices |
boolean |
|
LateFeeAmount |
currency |
|
IsMasterCustomer |
boolean |
|
DoNotProRate |
boolean |
|
IsUnassignedPaymentCustomer |
boolean |
|
PaymentToken |
string |
|
ExternalId |
string |
|
IsFavorite |
boolean |
|
PriorityLabelId |
Foreign Key to Priority Level (rPriorityLevel) |
integer |
Mapping
| AlarmBiller |
|---|
aCustomer |
CustomerId |
MasterCustomerId |
DealerId |
EntityId |
PartnerProgramId |
CustomerNumber |
CustomerStatusId |
CustomerTypeId |
EmployeeId |
TermId |
NoLateFees |
NoStatements |
| `LastStatementDate |
InvoiceDeliveryMethodId |
CustomerSince |
IsBusiness |
SuppressRecurringInvoiceDelivery |
FirstName |
LastName |
Address1 |
Address2 |
City |
State |
ZipCode |
Plus4 |
Phone1 |
Phone1Ext |
CellPhone |
Email |
Comments |
ShowOpenInvoices |
LateFeeAmount |
IsMasterCustomer |
DoNotProRate |
IsUnassignedPaymentCustomer |
PaymentToken |
ExternalId |
IsFavorite |
PriorityLabelId |
