Database Schema Changes V12.20

To support this release changes have been made to the database schema. These changes may have an impact on reports that have been created using custom queries.

It is important to check your custom reports prior to upgrade to ensure they are working as expected. If you find any issues with data, the information below should assist you to make any changes required.

Table	Field	Action	Comment/Extended Property Description
[dbo].[InvoiceHeader]	EInvoiceId	Field Added	Unique Id used for eInvoicing
[dbo].[InvoiceAudit]	EInvoicingStatus	Field Added	EInvoicing Status. 1 = Submitted, 2 = Ok, 3 = Error
[dbo].[InvoiceAudit]	DeliveryErrorReason	Field Added	If delivery of an eInvoice failed,it display a reason for the failure, if that can be determined.
[dbo].[InvoiceAudit]	EInvoiceId	Field Added	Unique Id used for eInvoicing
[dbo].[DebtorInvoiceLink]	BuyerReference	Field Added	Payment reference that the debtor can refer to when reconciling payments that have been made to a biller
[dbo].[BillingCompany]	RegistrationStatus	Field Added	Billing Company Registration Status. 1 = NotInitiated, 2 = Initiated, 3 = Registered, 4 = Failed
[dbo].[BillingCompany]	RegistrationErrors	Field Added	To check registration error for billing company
[dbo].[BillingCompany]	BankAccountId	Field Added	Foreign Key to BankAccountTable
[dbo].[BillingCompany]	EInvoicingCompanyId	Field Added	Unique identifier that was created by the access point provider when a successful billing company registration request was triggered
[dbo].[BillingCompany]	EInvoicingRegistrationDate	Field Added	Preserve the date and time in UTC format if the initial registration has been successful at any stage. This field will be blank if the initial registration has failed
[dbo].[BillingCompany]	LastEInvoiceRequestDate	Field Added	Preserve the date and time in UTC format when the registration status changes to ''Initiated'' or ''Update Initiated''.
[dbo].[BillingCompany]	LastEInvoiceResponseDate	Field Added	Preserve the data and time in UTC date/time when the registration status changed to Registered or Failed