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 |